<p>SSIS 2005/2008 does fuzzy lookups and groupings.  Is there a feature that does the same in T-SQL?</p>

SQL Server has a SOUNDEX() function:
```
```
SELECT * 
FROM Customers
WHERE SOUNDEX(Lastname) = SOUNDEX('Stonehouse')
AND SOUNDEX(Firstname) = SOUNDEX('Scott')
```
```