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: http://mysql.livejournal.com/132846.html