Smart first name matching in TSQL

Hello experts,

We are looking for script (actually for data) for smart first name conversion.
I.e. if user enter William or Billy then script should return Bill, if user enter Alexander, Aleks, Sasha then script should return Alex, etc.
Actually I can write SQL to do it, but I can't find list of all possible first names.
Is anybody have it?

Much thanks, Alex.
partners1998Asked:
Who is Participating?
 
Lee SavidgeConnect With a Mentor Commented:
There isn't a list of all possible first names so this is not a task that is ultimately possible to complete.

For example, if I decide to call one of my offspring "hubcap" you'd stand no chance of knowing that I might call them "hub" or "capper" for short. There are no official shortenings of names. For example Bob is short for Robert but it isn't part of any official rules or list of official names because anyone can call their children whatever they like.

The UK's rules on baby names are among the most liberal in the world. The General Register Office says there are no restrictions on parents - except for exceptional cases, such as a name which could be deemed offensive, when an official could refuse to register it.

How are you expecting to handle names from outside the UK or unusual names like Moonunit?
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
You need to use FullText.  It supports synonyms.  Please read the following article (credit to op):

https://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/
0
 
Lee SavidgeCommented:
That assumes you have a list of all names.

Does FullText know that Richy could be short for Richard whereas Richie may not be?
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Does FullText know that Richy could be short for Richard whereas Richie may not be?
No you'd have to configure it.  But Full Text is the way you can implement this under SQL Server.
0
 
PortletPaulfreelancerCommented:
I have to agree about getting a "full list of names" - that's a tall order.
(e.g. what about cultures with totally different names and abbreviations (or that don't use abbreviations?)

but anyway, this service MIGHT be of some use
http://www.fakenamegenerator.com/
0
 
arnoldCommented:
Your best bet is to build it. I.e. when you collect information.
As others pointed out while bill, billy is short for some who are named William, another may not like to be called the shortened form.
This is why some people have nicknames that are the shortens version of their names and others do not.

I.e. maybe some one named Alex, aleksander, Might prefer Sasha versus Alex as the nickname.
0
 
PortletPaulfreelancerCommented:
or, allow folks to choose? saves an awful lot of effort
0
 
partners1998Author Commented:
Ok, thanks all for comments, but we do not need list of absolutelly ALL names for all cultures and countries, we think about most popular and most used names, at least something we can start from.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Sorry but I am not aware of the existence of such list of first names synonyms.  You will probably need to associate these names yourself through data entry.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.