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.
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