Word searching/matching in SQL Server

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;

TF*IDF in C# example

SSIS Fuzzy lookup has a good support for this;

Fuzzy lookup using SSIS

FavoriteLoadingAdd to favorites
Spread the love

Author: Shahzad Khan

Software developer / Architect