Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “unpacker” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
unpacker1621589(None) 
unpacked17268661unpacked
unpackers17203811unpackers
unpucker16234271unpucker
knacker12307912kn_acker
packer144223402__packer
snacker133112602sn_acker
unbacked17268732unbacked
unmaker13279512unma_ker
unmasker14245022unmasker
unpack1457832unpack__
unpacks1576092unpack_s
unpicked17237212unpicked
unpuckers17243122unpuckers
unsicker1435302unsicker
untacked15239922untacked
attacker14144983attacker
backer144525533__backer
blacker154513513_blacker
clacker153813773_clacker
cracker153114173_cracker
dacker134920753__dacker
gunpaper1342623gunpa_per
hacker154822693__hacker
hijacker2442463hijacker
impacter14296573impacter
jacker194417583__jacker
knacked13287793kn_acked
knackers13286843kn_ackers
knackery16283663kn_ackery
knocker12296393kn_ocker
lacker125325623__lacker
necker124012793_n_ecker
nicker123818703_n_icker
outbacker1745163outbacker
oxpecker2341803oxpecker
pacer96131613__pac_er
pacier105018683__pacier
packed154822603__packed
packers153818893__packers
packet144726503__packet
parker124121373__parker
pecker144615363__pecker
picker144422173__picker
pucker143817633__pucker
racker124824553__racker
ransacker1543963ransacker
repacked17188743repacked
sacker125124843__sacker
slacker133915293_slacker
smacker153410583_smacker
snacked144013113sn_acked
snackers143010223sn_ackers
sneaker112910453snea_ker
snicker133012673sn_icker
spacer104917793_spac_er
spacier114011633_spacier
spanker133612353_spanker
sparker133914363_sparker
stacker134416263_stacker
tacker124224503__tacker
thwacker2042873thwacker
tracker133515173_tracker
unacted10312733un_acted
unasked122010023un_asked
unbaked143312893unba_ked
uncake122813523unca_ke_
uncaked143514353unca_ked
uncakes133012743unca_kes
uncasked15278453uncasked
uncocked17248753uncocked
uncracked18226803uncracked
undecked16238493undecked
undocked16277633undocked
uneager839753unea_ger
uneasier836963uneasier
unfairer11184283unfairer
unfaked153211173unfa_ked
unhairer11174993unhairer
unlace82215173unlac_e_
unlaced102913733unlac_ed
unlaces92513623unlac_es
unlicked15248263unlicked
unlocked15268383unlocked
unluckier1541933unluckier
unmake122811213unma_ke_
unmakers14256653unma_kers
unmakes132810793unma_kes
unmarked15248813unmarked
unmasked15267143unmasked
unmaskers15243723unmaskers
unpacking1835133unpacking
unpadded1345183unpadded
unpaged113311043unpa_ged
unpaired11208943unpaired
unparted11310823unparted
unpatched1744053unpatched
unpaved133410053unpa_ved
unpick1446903unpick__
unpicks1545183unpick_s
unplaced1338613unplac_ed
unplucked1843573unplucked
unpuckered1942323unpuckered
unraked122914013unra_ked
unranked1338563unranked
unstacked1636433unstacked
untack1239763untack__
untacks1357503untack_s
untaken1137643unta_ken
untracked16228373untracked
untucked15206053untucked
unwarier1136883unwarier
wacker154920123__wacker
whacker19368503_whacker

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit1461621146.40622816.4
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.87525991.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.