Fuzzy matching in SQL through name

Question

0.00/5 (No votes)

See more:

Hello all,

I am creating a program where i need to match similar names in order to get the results.
Now the problem here is the names can be spelled differently or can be in different order.
I am basically matching hotel names together and lets say for example,
there is one hotel Mariott. Now this name can be spelled differently and since the hotel is in different countries therefore every country might have a different combination, lets say for example in Dubai it is known as Mariott Hotel, Dubai,
in Australia, it is known as Hotel Mariott, Australia, or somewhere it is spelled with one t, like Mariot Hotel.
In actual the program should match all above examples and display the results. So how can i achieve this using SQL.
Need your help.
I would highly appreciate it.

Many Thanks

What I have tried:

Tried searching the web but to no avail

Posted 14-Feb-17 19:39pm

Faran Saleem

Updated 14-Feb-17 20:39pm

Add a Solution

Comments

[no name] 15-Feb-17 6:53am

Have maybe a look here for ideas: Query with Full-Text Search[^]

RedDk 15-Feb-17 13:04pm

Learn what a QUERY is using TSQL first.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JonPoley3 · Answer 1 · 2017-02-15T00:28:00

It's a tough problem - because many of the examples you give are obvious for humans - but less so for machines. But here are some thoughts that may help:

SQL

SELECT
  SoundEx( 'Mariott' ),
  SoundEx( 'Mariot' )

gives the same results "M630". You need MDS installed (worth checking what you need as I'm no expert) to use this. You'll get some false positives and non-matches - but it's a pretty easy starter for your problem.

For the word order issue (SoundEx will help only with spelling variations and sounds like problems), I would suggest just splitting the hotel name into it's component words and running soundEx on each separately.

Hope this helps,

Jon

Peter Leow · Answer 2 · 2017-02-14T20:39:00

Solution 1

Use LIKE (Transact-SQL)[^], e.g.

WHERE hotelname LIKE '%Mariot%'

Posted 14-Feb-17 20:39pm

Peter Leow

Updated 14-Feb-17 20:44pm

v2