TABLE needed to match nicknames with actual given names

[DataFinder]

Not wanting to re-create the wheel, I have a need for a two-column
table that links nicknames and given names if they are a derivative or
source of another. Can you help?

Using an Access database, I ultimately need to have Steve Jones come
up as a potential match for Stephen Jones, based on a link through
this auxiliary table (and matches on other criteria within their
respective records).

The application is not-for-profit database cleansing in the USA, and
the names would be primarily English (Bob = Robert) and Spanish (Juan
= Juanito). However, if Oriental, African and/or Arabic names were
included I would not complain.

Is there a free or inexpensive tool you know about? Might you let me
know where to get it?

Thanks

[timmg]

Re: TABLE needed to match nicknames with actual given names

On Mar 17, 8:36 am, DataFinder <dzi...@yahoo.c omwrote:

Not wanting to re-create the wheel, I have a need for a two-column
table that links nicknames and given names if they are a derivative or
source of another.  Can you help?
>
Using an Access database, I ultimately need to have Steve Jones come
up as a potential match for Stephen Jones, based on a link through
this auxiliary table (and matches on other criteria within their
respective records).
>
The application is not-for-profit database cleansing in the USA, and
the names would be primarily English (Bob = Robert) and Spanish (Juan
= Juanito). However, if Oriental, African and/or Arabic names were
included I would not complain.
>
Is there a free or inexpensive tool you know about?  Might you let me
know where to get it?
>
Thanks

While not complete, this page is a good start

http://www.genealogytoday.com/genealogy/enoch/nicknames.html

However, I am reminded of a nonprofit project I had a while ago moving
a homemaker time tracking application from Excel to Access. The
mechanics of tracking clients and homemakers by hours per day was
simple enough, but when it came to importing name we had a problem. I
had no cultural familiarity with the predominatly Russian and Asian
name names, and the users had developed the habit of entering Asian
names as first then last name and Russian names as last then first (no
comma). It took a while to figure that out - staff had internalized
that little bit of transition. Unfortunately, Russian patronymics did
not play a roll (Son's name + Father's first name + "ovich" or
Daughter's name + mother's first + "nova" plus ).

Beware diminutives of many lands.

Best of luck

Tim Richardovich <g>