Prxmatch

[ChrisNZ]

I'll ask again.

Have you looked at the spelling distance functions? like SPEDIS or COMPGED? 

[ChrisHemedinger]

To build on @ChrisNZ's suggestion, check out this fuzzy matching tip from @Ron_Cody:

https://blogs.sas.com/content/sastraining/sas-authors-tip-spedis-and-fuzzy-matching/

[SASPhile]

Yes, they both are giving  me the desired output.

I tried where soundex(a.text)=soundex(b.text), this did not yeild the result as well. Many of the words between the two strings match. Yet soundex fails.