SQL Select records where any word / value contained within one string is also contained within another string
I don't know the requirements of your project but with the info you provided on this post, this qualify for a data quality project from Data Quality Services (DQS):

Data Quality Project (DQS)