Search and translate a person’s name

Question

I am working on the requirement to map people from different databases. One difficult problem is the variety of names like Bob - Robert, Jim - James, Lizzy - Elizabeth, etc. Through the database.

Whether search / translation is available for this kind of requirement.

Answer 1

Take a look at my answer (as well as others) here:

Tools for matching name / address data

Answer 2

You will need to implement a lookup table with alternative names in it:

Base      | Alternate
----------------
Robert    | Bob
Elizabeth | Liz 
Elizabeth | Lizzy
Elizabeth | Beth

. , , , , . , - , , .