MerlinMerge® SpeedPro - Duplicate Detection, Merge/Purge SoftwareOur MerlinMerge® software solution is an easy-to-use and affordable data de-duplication and merging tool that allows users to upload their data to a batch server and receive processed output in various formats. MerlinMerge® uses our powerful searching and matching intelligence to achieve unparalleled accuracy and speed while overcoming variations due to acronyms, spelling errors, phonetic errors, and word sequence.
MerlinMerge® Online
MerlinMerge® Online is an advanced list management tool that performs duplicate record detection, as well as merge/purge solutions through our hosted batch server. MerlinMerge® Online can process data from text files and a variety other data formats.
MerlinMerge®
IST also offers a standalone version of MerlinMerge® SpeedPro that intelligently searches for and identifies duplicate records. The product uses IST's powerful fuzzy searching and matching intelligence to achieve unparalleled accuracy and speed while overcoming variations due to many common errors found in data.
MerlinMerge® is capable of processing data from a number of databases, including SQL Server, Oracle, Access, DB2, MySQL, Sybase, and TeraData, and can improve database quality accurately and quickly by overcoming the following variations:
Acronyms: MerlinMerge® uses corporate search algorithms and acronym recognition functions to significantly advance the ability to seek and match corporate name data, e.g. "Triple A Towing" vs. "AAA towing."
Spelling errors: Spelling and keyboard errors account for many of the duplicates found in a database. Through the use of intelligent key building and advanced comparison routines, MerlinMerge® can accurately identify duplicates despite misleading spelling errors.
Phonetic Errors: Discrepancies caused by phonetic errors account for roughly 25% of all name variations. MerlinMerge® addresses problems due to phonetics by employing analysis routines to identify and eliminate phonetic mistakes.
Word Sequence Variations: Many search problems are caused by sequence variations. The inability to determine the order of words for a particular entity occurs at both data entry and inquiry levels. The name "Frank Lee," for example, could appear as "Lee Frank." MerlinMerge® is able to overcome word sequence variations without sacrificing performance.
Missing, Extra and Noise Words: Noise words are elements in a name that do not help in the identification of a candidate, including "incorporated," "Corporation," "Limited," "Senior," "Junior," "Avenue" and "Street." While processing the data, MerlinMerge® also goes through a process called sanitization that removes noise characters (e.g. @,#,$,%,^,&, etc.), extra spaces, control characters, and converts all characters into uppercase.
