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)