CODEWITHSUNDEEP
databasename-matching
Gnana
Gnana

Reputation: 573

Human Name lookup / translation

I am working on a requirement to match people from different databases. One tricky problem is variance in names like Bob - Robert, Jim - James, Lizzy - Elizabeth etc across databases.

Is there a lookup/translation available for this kind of a requirement.

Upvotes: 3

Views: 499

Answers (2)

Robert Groves
Robert Groves

Reputation: 7738

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

Tools for matching name/address data

Upvotes: 1

Andrew
Andrew

Reputation: 6351

You'd need to implement a lookup table with the alternate names in it:

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

Then search the database for the base name and all alternates. You'll end up with a number of multiple matches which will then need to be checked to see if they really match based on a comparison of whatever other data you have in the two databases. Maybe the dates of the records in each database could be used - records entered close in time indicate the same person.

Upvotes: 0

Related Questions