Thank you for visiting The Link King.
If you feel The Link King has simplified your life or if you just want to support a worthy Kickstarter
project, please consider making a contribution to the production of The Bond, a short film by Bryan
Click on the image below to go to The Bond's Kickstarter page and pledge a contribution of any amount.
In addition to incentives offered on The Bond's Kickstarter page, contributions of $250 or more are
entitled to a free Link King t-shirt. To redeem, send me the email/name associated with the contribution.
The Link King
Record Linkage and Consolidation Software
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”
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
- 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
- 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
- First Name
- Last Name
- Date of Birth or SSN
- Middle Name (or initial)
- Maiden Name
- Zip Code or City Name or County (etc.)
Technical Support, Consulting, and Training
Copyright Camelot Consulting 2004