Fuzzy matching

[sqlor]

Hello

I want to use Soundex to match an external list with the values of a column of a SQL table.

Is there an easy way to do that? Unfortunately SOUNDEX([Col1]) does not seem to work which is very frustrating.

Thanks!

[yosiasz]

You have asked similar question a few times. Search fuzzy and @sqlor

Fuzziness with wildcards

Hello Is it possible to use soundex or other algo to match e.g.: ABC Inc with xxxx xxxxx ABC Corp xxxx xxxx (where x is any character) In other words, fuzzy match usually compares the whole strings as one but I would like to also match if the reference string has a fuzzy match somewhere inside the to be checked string. Thanks!

Are the answers provided for this not satisfactory?

Look back and answer those first

[sqlor]

Thanks, this is a bit different, it's actually on how to find the soundex of a whole column.

[yosiasz]

@sqlor

Unfortunately SOUNDEX([Col1]) does not seem to work

What does does not seem to work mean?

Please provide the necessary data of table and external list then

[sqlor]

Basically I need to get the soundex of the below values:

Column1
John
George
Betty
Sue

And select soundex([Column1]) from Table1 does not seem to work?
I would expect to return:

C400
F450
B409
B944
(or whatever the soundex code for each is)

[yosiasz]

@sqlor

does not seem to work?

You keep saying "Does not seem to work" i

What does that mean? Is it erroring? Is it producing what you did not expect?