Select name matching like 80%

Question

I have a requirement to found the fraud customer's , the customer name which are all matching 80% with the fraudulent customer's name. So any one give idea for pattern check. I think this explanation is sufficient to understand.

score 3 · Answer 1 · answered Nov 21 '11 at 10:08

3

There are set of standard algorithmns which will help you to acheive the requirement like ..

Levenstein
JaroWinkler
NeedlemanWunch
SmithWaterman
ChapmanLengthDeviation..

answered Nov 21 '11 at 10:08

Ashley John

2,379
2
21
36

Thanks friends ... really these concepts are new to my life... thanks fr a valuable suggetion.. i will try this now.. – Nagarajan Nov 21 '11 at 10:14

score 1 · Accepted Answer · edited May 23 '17 at 12:22

1

You can use Levenshtein for this see Levenshtein distance in T-SQL

The example is in T-sql but you can use it to see the pattern

edited May 23 '17 at 12:22

Community

1
1

answered Nov 21 '11 at 10:01

Ivo

3,406
4
33
56

score 0 · Answer 3 · answered Mar 08 '12 at 05:44

0

I just created a SQLCLR library for running Levenshtein on Sql Server here. Feel free to contribute. :)

answered Mar 08 '12 at 05:44

Robert Jeppesen

7,837
3
35
50

Select name matching like 80%

3 Answers3