Similar string values Sql Server 2016

Asked Feb 08 '18 at 15:43

Active Feb 08 '18 at 16:22

Viewed 45 times

I would be so happy if someone could help me with this one. Here is the problem: I have table like this

[Account ID]      |  [Account Name]
-------------------------------------------------
0014600000tgE23   |  Lizzards Pub - Various
0014600000tgE25   |  Lizzards Pub, The - Various
0014600000tgE20   |  Phi Nguyen - Various

I can find duplicates easy, but I can't match "Lizzards Pub - Various" and "Lizzards Pub, The - Various", so question is how can I match similar values. I tried Soundex and Difference but the problem is that I have about 45000 records in this table, and I don't have time to scroll that much.

This is what I have tried

select sfc.[Account Name], sfc.[Account ID]
FROM [Test].[dbo].[report1517492198819$] sfc
join (select left(sfc1.[Account Name], 8) as firstFew, count(*) as brojac
      from [Test].[dbo].[report1517492198819$] sfc1
      group by [Account Name] 
      having COUNT(*)>1) y 
      on sfc.[Account Name] like '%' + y.firstFew + '%' 
      order by sfc.[Account Name]

Thank you all so very much! :D

edited Feb 08 '18 at 16:22

asked Feb 08 '18 at 15:43

Aleksandar Picuric

1

Use the LIKE operator – Ryan Wilson Feb 08 '18 at 15:45
I guess you are interested on https://stackoverflow.com/questions/560709/levenshtein-distance-in-t-sql – dani herrera Feb 08 '18 at 15:47
Yeah, already try that, didn't do as I expected :( – Aleksandar Picuric Feb 08 '18 at 15:50
1

What did you try, exactly, and in what way did it not work for you? – Tab Alleman Feb 08 '18 at 15:53
I edited question so you can see what I tried to do. – Aleksandar Picuric Feb 08 '18 at 16:23

Similar string values Sql Server 2016

0 Answers0