Entity Synonym Names

    Date: 12/07/08 (MySQL Communtiy)    Keywords: html, sql, google

    Heyo. I'm putting together a user search function and I would like to include a Facebook-style name recognition system that understands name synonyms. A search for Will would also return Bill and William, for example. To some extent I could see a Soundex search kinda accomplishing this, but I'm wondering if anyone has any really good ideas as to how to implement this. At the moment I'm trying to find a sql dump of name synonyms which I would use for cross-references.

    Anyone done this before and have some words of wisdom?

    *update*

    I've found this: http://answers.google.com/answers/threadview/id/778986.html

    ... which is definitely helpful.

    I created a SQL file and posted about it here: http://danconnor.com/wordpress/?p=138

    I'm still open to suggestions though!

    Source: https://mysql.livejournal.com/132846.html

« Efficient full-text searchs... || Find datetimes with time of... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home