Results 1 to 3 of 3

Thread: Alias\Alternate name searching?

  1. #1
    Join Date
    Sep 2008
    Posts
    2

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    In sql server, can try with replace function in your query.

  3. #3
    Join Date
    Sep 2008
    Posts
    2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •