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.