Alias\Alternate name searching?

Hi,

I have been asked if we can search a table for alternate names of people; such as Bob instead of Robert or Peg instead of Margaret, etc.

I have hunted around and found terms such as Dimunitive, Hypocoristic, Content Equivalent and Keyword Substitution...but none of them have helped by providing code to search the table of names.

I've also looked at phonetics but obviously they aren't going to return alias names.

Has anyone ever seen or done this? I would appreciate any help in how to approach or solve this issue.

Thanks in advance,
Steven

In sql server, can try with replace function in your query.

After some more research it appears that the closest thing I could do is use FullText Indexing and a reference/lookup table...other than that it appears that this isn't a common problem with an existing solution. :confused: