two things come to mind -

full text indexing

and if you have enterprise edition fuzzy grouping in SSIS advanced data flow transformations.