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 “unpacking” 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.

138 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
unpacking183513(None) 
unpicking1834881unpicking
untacking1636641untacking
knacking14296712kn_acking
packing164420722__packing
repacking1838282repacking
snacking153411702sn_acking
uncaking1539462unca_king
uncocking1836232uncocking
undocking1735652undocking
unlacing1148652unlac_ing
unlocking1636072unlocking
unmaking1538132unma_king
unmasking1635262unmasking
unpaying1456942unpa_ying
unstacking1744992unstacking
untracking1746932untracking
untucking1644692untucking
anticking1649243anticking
attacking1635323attacking
backing165523443__backing
blacking174213603_blacking
clacking173313493_clacking
cracking174013903_cracking
enacting11311363en_acting
enfacing1467293enfac_ing
enlacing1148773enlac_ing
flacking184311793_flacking
hacking173720613__hacking
henpecking2242303henpecking
hijacking2642763hijacking
hopsacking2242533hopsacking
impacting1635943impacting
imparking1834713imparking
inlacing1158373inlac_ing
jacking214515263__jacking
knocking14245943kn_ocking
lacking143821543__lacking
narking124015383_n_arking
necking143913893_n_ecking
nicking143516323_n_icking
nocking143615113_n_ocking
outpacing1478363outpac_ing
pacing114522753__pac_ing
packings174310063__packings
paiking143814813__paiking
parking143423043__parking
pecking164017783__pecking
picking163418333__picking
pocking163916763__pocking
prepacking2145773prepacking
quacking2436743_quacking
racking144323663__racking
ransacking1744423ransacking
reparking1638923reparking
reracking1639313reracking
retacking1658973retacking
sacking144122703__sacking
shacking184014083_shacking
slacking153914133_slacking
smacking173510763_smacking
snaking123915303sn_a_king
sneaking133211093snea_king
snicking153610233sn_icking
spacing123614493_spac_ing
spackling18266503_spackling
spanking153911973_spanking
sparking152812543_sparking
specking17359733_specking
stacking154215083_stacking
tacking144421483__tacking
thacking183110043_thacking
thwacking2253193thwacking
tracking153715463_tracking
unageing1036273un_ageing
unaging9510933un_a_ging
unakin10310963un_a_kin_
unarming1138623un_arming
unbaling11310683unba_ling
unbanning1235893unbanning
unbarring1236063unbarring
unblocking1943693unblocking
unbracing1437023unbrac_ing
unbraking1636933unbraking
unbuckling1942363unbuckling
uncaging1268713unca_ging
uncapping1635133uncapping
uncaring11312843unca_ring
uncasing11511003unca_sing
unchoking1935703unchoking
uncorking1637403uncorking
undaring10412753unda_ring
unfading1347693unfa_ding
unfailing1337453unfailing
unfrocking2043533unfrocking
ungazing1936033unga_zing
unhairing1335953unhairing
unhanding1437203unhanding
unhanging1436363unhanging
unhatting1335873unhatting
unhooking1735353unhooking
unhusking1744093unhusking
unjamming2143043unjamming
unkinking1334783unkinking
unlading1058863unla_ding
unlashing1336493unlashing
unlatching1643153unlatching
unlaying1258363unla_ying
unlinking1436273unlinking
unmanning1245873unmanning
unnailing1037023unnailing
unpack1457833unpack___
unpacked17268663unpack_ed
unpacker16215893unpack_er
unpackers17203813unpackers
unpacks1576093unpack__s
unpegging1443863unpegging
unpenning1236183unpenning
unpiling1139753unp_iling
unpinning1245623unpinning
unpitying1544043unpitying
unplaiting1345503unplaiting
unpuckering2071493unpuckering
unquaking2354593unquaking
unsaying1288153unsa_ying
unshackling2141653unshackling
unsparing1237713unspa_ring
unspeaking1744423unspeaking
unsticking1744943unsticking
unteaching1645493unteaching
unvarying1644503unvarying
unwaning1238133unwa_ning
unwinking1735073unwinking
unyoking1636183un_yoking
uptalking1643353uptalking
whacking21377483_whacking
wracking18349963_wracking
yacking174315683__yacking

Search took 8 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 Filter1786911486410.406440125.6
2DLD Change Limit1486411386.53022762.8
3Display Results1381380.0632190.5
 (SQL Overall)1786911386.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.