Compare two string columns

Wojtek_Dz

Hi, I'm wondering if it is possible to find a match from one column into the next one. 
There are couple conditions:
- strings are not 100 % the same
- matched string could be in different row then the original one

Example:

Column_1	Column_2	Match
ABC DEF	DEF XYZ	TRUE	- matched by DEF - this case I solved by STRSPN function

But what if I had this case:

Column_1	Column_2
ABC DEF	ASDFUZP
ASDFDF	123XYZ XXXX
11111HHH	DEF XYZ
123XYZ	MMMKKK

Result
Column_1    Column_2          Match
ABC DEF     DEF XYZ          TRUE
ASDFDF      ASDFUZP         TRUE
123XYZ       123XYZ XXXX   TRUE
11111HHH    MMMKKK          FALSE

caltang

What you’re looking for is Fuzzy Matching. Mind you, Fuzzy Matching is an art and not a science. You may not get all the records as well depending on your settings in Fuzzy Matching.