This is a sample of how to match strings which are not exact and have a different order of words. Usually the strings have similar digit patterns but the words may be in different order.
https://stackoverflow.com/questions/48380545/fuzzy-string-matching-sql-words-in-different-order
Another approach is using TF*IDF. This is known as Term Frequency and Inverse Document Frequency. Here is a reference;
SSIS Fuzzy lookup has a good support for this;
Add to favorites
