Solved

Smart first name matching in TSQL

Posted on 2013-06-18
9
341 Views
Last Modified: 2013-06-19
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.
0
Comment
Question by:partners1998
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 500 total points
ID: 39255683
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
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39255749
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
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39255775
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
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39255830
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 48

Expert Comment

by:PortletPaul
ID: 39255831
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
 
LVL 76

Expert Comment

by:arnold
ID: 39255996
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
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39256088
or, allow folks to choose? saves an awful lot of effort
0
 

Author Comment

by:partners1998
ID: 39256174
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
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39256635
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

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now