SQL Server 2005 offers a completely redesigned SQL Server Integration Services engine, formerly known as Data Transformation Services. It includes many new features such as built-in support for Fuzzy Lookups and Fuzzy Groupings, which help you build power

SQL Server 2005: Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities