SQL Server Integration Services (SSIS) - Fuzzy Lookup Transformation in SSIS
SQL Server Integration Services (SSIS) - Export Column Transformations in SSIS
I see this great article.
Now, i have one question.
I make this sample in integration services but now how can run this from my visual studio 2010 app?
I need to make a fuzzy query from one word in database and show result in a grid.
Sample, i need to search all words like "DIASA" in 3.000.000 words db.
There are some word like D.I.A.S.A. - DIA, SA - CIASA - DIALA - ETC
I need to take all the word that have similitary with the original with % of silimtary.
Sorry for my english.