Is it possible to perform T-SQL fuzzy lookup without SSIS?

sql-server tsql ssis fuzzy-search
ScottStonehouse picture ScottStonehouse · Oct 29, 2008 · Viewed 21.3k times · Source

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

Answer

Ian Boyd picture Ian Boyd · Oct 29, 2008

SQL Server has a SOUNDEX() function:

SELECT * 
FROM Customers
WHERE SOUNDEX(Lastname) = SOUNDEX('Stonehouse')
AND SOUNDEX(Firstname) = SOUNDEX('Scott')

Related questions

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I'm trying to import a flat file into an oledb target sql server database. here's the field that's giving me trouble: here are the properties of that flat file connection, specifically the field: here's the error message: [Source - 18942979103_txt [424]] …

Read More
convert Excel Date Serial Number to Regular Date

I got a column called DateOfBirth in my csv file with Excel Date Serial Number Date Example: 36464 37104 35412 When i formatted cells in excel these are converted as 36464 => 1/11/1999 37104 => 1/08/2001 35412 => 13/12/1996 I need to do this transformation in SSIS or in …

Read More
How do I create a step in my SQL Server Agent Job which will run my SSIS package?

I'm trying to create an automated job for the SQL Server Agent to run. The job is supposed to run my SSIS package. Here's what I have so far: EXEC sp_add_job @job_name = 'My Job' ,@description = 'My First …

Read More