SQL Alphanumeric Pattern Matching

Question

we ran into an issue where we need to test two varchar numeric strings. So if we had one string like '123456' and '123465'. The character could be swapped at any place in the string. I have no clue what to even Google for help with this, but my hope would be to assign a match ranking percentage. Is that even feasible? Any direction would be extremely appreciated.

score 2 · Accepted Answer · edited May 23 '17 at 12:28

2

You might google "Levenshtein distance". Here's a potentially relevant answer:

Levenshtein distance in T-SQL

edited May 23 '17 at 12:28

Community

1
1

answered Jan 27 '15 at 01:44

Matthew Nizol

2,609
1
18
22

I think that's going to do the trick. Thanks for the direction Matt. – CSharp821 Jan 27 '15 at 13:53

SQL Alphanumeric Pattern Matching

1 Answers1