Anyone have experience using Fuzzy Lookup in SQL Server 2005 Integration Services? Is there a standard to use to return reasonable matches? I'm wading through 250,000 rows, the great majority of which are too 'fuzzy'. I've got a lot of partial word matches, of, inc., and, the...
What about confidence or similarity numbers? Is there a threshold below which the match will be too 'fuzzy'?
Any help appreciated.
What about confidence or similarity numbers? Is there a threshold below which the match will be too 'fuzzy'?
Any help appreciated.