Dedupe Batch software is one of the market leaders in data duplication identification............ ------------------------------------------------------------------------------------------------------------------------------------- Dedupe have developed complex algorithms and extensive data transformation libraries to identify potential matches................................................................................................ ------------------------------------------------------------------------------------------------------------------------------------- Dedupe uses Phonetic Rules to find similar sounding names such as Leigh and Lee. Soundex technology is unable to identify these records as potential matches...................... ------------------------------------------------------------------------------------------------------------------------------------- Dedupe also has an extensive Data Transformation Library. This enables the software to know that Robert can be shortened to Bob, William to Bill etc. This increases the ability to identify potential matches such Mr Anthony Dickson esq. and Tony Dixon. ....................... ------------------------------------------------------------------------------------------------------------------------------------- The software can also use an initial function that can be used to identify the potential match of B.T., B T, and British Telecom. (Obviously you would link this match to Postcode/Zip or another reference point to be sure that this is the same company). ................................... ------------------------------------------------------------------------------------------------------------------------------------- The Data Transformation Library can be used to enhance data e.g. Ltd. To Limited in Company Name Field, Av. To Avenue in Address field, correctly case data, e.g. town to TOWN in address line..................................................................................................... ------------------------------------------------------------------------------------------------------------------------------------- Dedupe lite: Enables a Dedupe session to be run over a single data file e.g. .txt, .xls, .mdb, .csv etc. Identify duplicates for deletion............................................................................. ------------------------------------------------------------------------------------------------------------------------------------- Dedupe Desktop: Enables a Dedupe session to be run over a single data file or compare two separate files. Case convert the data, duplicate summary by percentage match score, Export duplicate and/or Master Records to .csv file. Filter records using SQL, Edit table data, Edit data comparisons, Create keylist of duplicates found, assign group numbers, scheduling of find duplicates, keep records based upon percentage match, reassign orphan records.......................................................................................................................... ------------------------------------------------------------------------------------------------------------------------------------- Dedupe Enterprise: As Above Plus. Find duplicates on Access Queries, Connection to Databases using ODBC connectivity, Reassign orphan records (Dual Session)................... .................................................................................................................................... This is definitely the edition to have.
