The Link King
Record Linkage and Consolidation Software
Dedupe Software Icon
In the realm of public domain software for record linkage and
unduplication (aka.
dedupe software), The Link King reigns supreme.  
The Link King has fashioned a powerful alliance between sophisticated
probabilistic record linkage and deterministic record linkage protocols
incorporating features unavailable in many proprietary record linkage
programs. (
detailed overview (pdf))

The Link King’s probabilistic record linkage protocol was adapted from
the algorithm developed by MEDSTAT for the Substance Abuse and
Mental Health Services Administration’s (SAMHSA) Integrated Database
Project.  The deterministic record linkage protocols were developed at
Washington State’s Division of Alcohol and Substance Abuse for use in a
variety of evaluation and research projects.

The Link King’s graphical user interface (GUI) makes record linkage and
unduplication easy for beginning and advanced users.  The data linking
neophyte will appreciate the easy-to-follow instructions.  The Link King's
artificial intelligence will assist in the selection of the most appropriate
linkage/unduplication protocol.  The technical wizard will appreciate the
discussion of data linkage/unduplication issues in The Link King’s user
manual, the variety of user-specified options for blocking and linkage
decisions, and the powerful interface for manual review of “uncertain”
linkages.

The Link King requires a base SAS license but NO SAS programming
experience.  
If you have a SAS dataset, a SPSS portable file, an EXCEL
spreadsheet, or a comma/tab delimited file, The Link King can do the rest.
 
The Link King v6.4 requires SAS v9.0 or higher but v6.3 is compatible
with SAS v8.

Best of all,
download  The Link King for FREE !
The Link King v7.1.21
Last updated 6/23/12
Link King Screensaver
Preview Screensaver (flash video)
Features:
  • Probabilistic Record Linkage Algorithm

  • Deterministic Record Linkage Algorithm

  • Calculates distance between zip code
    centroids for use in probabilistic algorithm.

  • NEW ! Jaro-Winkler string comparison (with
    prefix and long-string adjustments)

  • Phonetic name matching (Double
    Metaphone, NYSIIS and Soundex)

  • Approximate string matching and spelling
    distance algorithms

  • Nickname matching

  • Gender imputation for 20,000 names

  • Scaling of name weights (“Smith” receives
    less weight than “Freud”)

  • Powerful interface for manual review

  • Generates random samples of linked records
    for user validation of the process

Data Elements Used in Linking
Required:
  • First Name
  • Last Name
  • Date of Birth or SSN

Recommended:
  • Middle Name (or initial)
  • Maiden Name
  • Gender
  • Race/Ethnicity
  • Zip Code or City Name or County (etc.)

Technical Support, Consulting, and Training
Copyright Camelot Consulting 2004
Now Playing !
View Online (flash video)
Download (for Windows Media Player)
Empirical Evaluations of Link King Accuracy

Health Informatics Journal
Kansas Health Institute
International Association for Dental Research
Logo by Reid Psaltis
Buy his Art and Comics
Journal of Substance Abuse Treatment
(pdf for JSAT)
Proclaim your allegiance with a
Link King t-shirt