MerlinMerge® SpeedPro Features
Duplicate Detection, Merge/Purge Software

MerlinMerge® SpeedPro is a highly affordable sophisticated list management tool that provides a variety of features. With MerlinMerge® SpeedPro you can:

Enjoy ease of installation and use Perform data management tasks with NO prior technical experience     Process flat text files (delimited and fixed-width) Extract data from SQL Server, Oracle, DB2, Sybase, Access, MySQL, Teradata Merge files with different field structures directly Perform point and click field mapping Save all settings to a configuration file for future use     Define output formats: delimited and fixed-width, output columns, column order etc. Easily import and integrate the output files with other applications Create unique duplicate id number assignment for each duplicate set Generate duplicates and unique log files Merge/remove the duplicates in the output View results easily     Configure a variety of options for searching and comparison Perform loose or tight matching with control over settings Produce a comparison threshold score that determines the likelihood of a match Match on multiple fields e.g. Name, Address, Company and produce a combined score Hanlde International Data Utilize rulebases for personal names, addresses, company names etc.   For example, the personal name rulebase helps match Robert, Rob and Bobby: Name Address Company Robert Wagner 24 Milltown Road Smith Corporation Rob Wagner 24 Milltown Avenue Smith Inc. Bobby Wagner 24 Milltown Blvd Smith Corp Inc. Benefit from advanced phonetics capabilities For example, the following variations are detected with the help of phonetics: Name Phillip Mac Affik Filip Mkafic Philip Mackaphik Employ acronym recognition For example, IST is recognized as an acronym for Intelligent Search Technology: Company Intelligent Search Technology IST IS Technology Overcome sequence variations For example, the different permutations of the words in the input are matched: Name Address Company Ricky Scott Wagner 24 West Jones Avenue Jones and Smith Corporation Scott Rick Wagner 24 Jones Avenue West Smith and Jones Corporation Wagner Rick Scott 24 Avenue Jones West Corporation Jones Smith Use key extraction utility to help fine-tune search settings Set up OR definitions (match keys)   For example, a match on name and address OR name and company would put the following records in the same duplicate set: Name Address Company Richard Wagner 20 Milltown Rd Intelligent Search Technology Rich Wagner 20 Milltown Rd   Rick Wagner   Intelligent Search Technology     Run the process in the background and see the progress at any time Check for the latest software updates     Perform interactive records searching against any input file Control comparison settings during interactive search