SQLTeam.com | Weblogs | Forums

Is Fuzzy Matching possible in SQL?

Hello

PowerBI has a very straightforward Fuzzy Matching function but it is unfortunately extremely slow.

Is there anything like this in SQL?

I found SOUNDEX() but I do not think it is a Fuzzy Matching, it looks like a phonetic matching which is different.

Example of fuzzy matching:
Door matches with Dor (because 75% of the characters are the same)
Example of phoentic matching:
Door matches with Ntor (because they sound similar despite 50% of the characters being the same)

Any idea?

Thanks

Thanks, I take that as a 'no'.

so odor is a 100% match to door? or are you saying comparing them slot wise
slot 1, slot 2, slot 3?

there's a reason why the fuzzy matching in PowerBi is extremely slow. The only thing I've seen that works is using full text indexing

what is the intended application of this fuzzy matching. SQL Server might not be your target technology to that

Odor is not a match to door because in PowerBI you can specify if you want to change the order of the characters in your fuzzy matching or not.

we are not talking about PowerBi, we are talking about SQL Server. What are you attempting to do? You requirements are often very vague and you object to many answers given. If your requirements are not clear then you will get a lot of responses you will not like.