search - Database of common name aliases / nicknames of people

Question

I'm involved with a SQL / .NET project that will be searching through a list of names. I'm looking for a way to return some results on similar first names of people. If searching for "Tom" the results would include Thom, Thomas, etc. It is not important whether this be a file or a web service. Example Design:

Table "Names" has Name and NameID
Table "Nicknames" has Nickname, NicknameID and NameID

Example output:

You searched for "John Smith"
You show results Jon Smith, Jonathan Smith, Johnny Smith, ...

Are there any databases out there (public or paid) suited to this type of task to populate a relationship between nicknames and names?

question from:https://stackoverflow.com/questions/2381522/database-of-common-name-aliases-nicknames-of-people

Answer 1

I'm adding another source for anyone who comes across this question via Google. This project provides a very good lookup for this purpose.

https://github.com/carltonnorthern/nickname-and-diminutive-names-lookup

It's somewhat simpler and less complete than pdNickName but on the other hand it's free and easy to use.