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

316 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
knacking1429671(None) 
knocking14245941knocking
snacking153411701snacking
backing165523442_backing
blacking174213602blacking
clacking173313492clacking
cracking174013902cracking
enacting11311362enacting
flacking184311792flacking
hacking173720612_hacking
jacking214515262_jacking
kecking134111882k_ecking
kicking133314022k_icking
knapping17314972knapping
knuckling1542752knuckling
lacking143821542_lacking
narking124015382_narking
necking143913892_necking
nicking143516322_nicking
nocking143615112_nocking
packing164420722_packing
quacking2436742quacking
racking144323662_racking
sacking144122702_sacking
shacking184014082shacking
slacking153914132slacking
smacking173510762smacking
snaking123915302sna_king
snicking153610232snicking
stacking154215082stacking
tacking144421482_tacking
thacking183110042thacking
tracking153715462tracking
uncaking1539462uncaking
unpacking1835132unpacking
untacking1636642untacking
whacking21377482whacking
wracking18349962wracking
yacking174315682_yacking
aching126521973__aching
acing87429153__ac_ing
acting95920983__acting
anticking1649243anticking
antiking13412073antiking
arcking145811963_arcking
asking116017233__asking
attacking1635323attacking
awaking1547813awa_king
baching156017753_baching
backings174012213_backings
baking135626623_ba_king
balking143717353_balking
banking144621353_banking
barking144724183_barking
basking144718613_basking
beaching164114143beaching
becking164416073_becking
blackings18316763blackings
blanking154411933blanking
blocking174510573blocking
bracing123817613brac_ing
braking143917713bra_king
bricking173911403bricking
bucking163617573_bucking
caching156317503_caching
cackling172610943_cackling
caking134624673_ca_king
calking144617783_calking
carking144322853_carking
casking144317353_casking
chalking183310063chalking
charking183512613charking
checking20379203checking
chocking204011013chocking
chucking20379503chucking
clanking154313063clanking
clicking173610983clicking
clocking174312413clocking
clucking17429993clucking
coaching164011963coaching
coacting133412703coacting
cocking163619983_cocking
crackings18346843crackings
crackling18157003crackling
cranking154613073cranking
cricking173412653cricking
crocking174313443crocking
dancing113611563danc_ing
darking134217343_darking
decking153915593_decking
dicking153617613_dicking
docking153615013_docking
ducking154315053_ducking
enabling1138603enabling
encaging1258733encaging
encasing11610823encasing
enfacing1467293enfac_ing
enlacing1148773enlac_ing
exacting1838523exacting
facing125321573_fac_ing
faking145520983_fa_king
fancying1735353fancying
finicking1954463finicking
flaking154114493fla_king
flanking164211083flanking
flecking18408233flecking
flicking184110043flicking
flocking183410873flocking
franking164310863franking
frocking18309573frocking
fucking173212283_fucking
gasking134415913_gasking
gawking16398823_gawking
gecking154111363_gecking
glaceing1236533glaceing
gnarling10217603gnarling
gnarring10225973gnarring
gnashing1336423gnashing
gnawing12377903gna_wing
gracing113216443grac_ing
hackling183310163_hackling
hanking154619103_hanking
harking154120943_harking
hawking183711423_hawking
hijacking2642763hijacking
hocking173417243_hocking
hoicking1836053hoicking
inarching1546343inarching
inarming1138343inarming
incaging1288673incaging
incasing11610603incasing
inching134414323in_ching
inking115119053in__king
inlacing1158373inlac_ing
invoking1635653invoking
jauking19418323_jauking
kachina1637663k_achina
karting123716063k_arting
kayaking1534063kayaking
kayoing1535403k_ayoing
keckling14245523k_eckling
keeking114210893k_eeking
kinking113615153k_inking
knack104311043knack___
knacked13287793knack_ed
knacker12307913knack_er
knackers13286843knackers
knackery16283663knackery
knacks11428543knack__s
kneading1436373kneading
kneeing12226523kn_eeing
kneeling13287783kneeling
knelling13319023knelling
knifing1536483kn_ifing
knitting13257023knitting
knolling13206893knolling
knotting13236573knotting
knouting13226793knouting
knowing15287683kn_owing
knurling1344943knurling
konking113510213k_onking
kraaling13186663kraaling
lacing94626233_lac_ing
laking115027043_la_king
lancing103314123lanc_ing
larking123718253_larking
leaching143012833leaching
leaking123616973lea_king
licking144118283_licking
locking143718153_locking
lucking143615833_lucking
macing114221553_mac_ing
mackling172710063_mackling
making134823853_ma_king
manacling1446283manacling
marking144020133_marking
masking145116613_masking
menacing1339783menac_ing
mocking163614453_mocking
mucking163213823_mucking
nabbing12299963_nabbing
naffing14359033_naffing
nagging102613043_nagging
nailing83419963_nailing
naming93917893_na_ming
nankin1039673_nankin_
nankins1159053_nankins
napkin1236903_napkin_
napkins1336673_napkins
napping123514183_napping
neckings15346113_neckings
niching133612433_niching
nickling15278703_nickling
nonacting1238783nonacting
noncaking1646683noncaking
nuking113411253_n_uking
pacing114522753_pac_ing
packings174310063_packings
paiking143814813_paiking
pancaking1836383pancaking
panicking1835293panicking
parking143423043_parking
peaching163613643peaching
peacing124117073peac_ing
peaking144317693pea_king
pecking164017783_pecking
picking163418333_picking
placing123815283plac_ing
planking153513013planking
plucking17357723plucking
poaching163510833poaching
pocking163916763_pocking
pranking153813383pranking
pricking173212603pricking
quaking2139313qua_king
racing95030533_rac_ing
raking114728423_ra_king
ranching141712043ranching
ranking124320883_ranking
ransacking1744423ransacking
reaching143317203reaching
reacting113317893reacting
recking144319923_recking
repacking1838283repacking
reracking1639313reracking
retacking1658973retacking
ricking143920233_ricking
roaching143210433roaching
rocking143619633_rocking
rucking143216673_rucking
sackings15389633_sackings
sacring103115983_sacring
shackling19286173shackling
shaking153317253sha_king
shanking163612283shanking
sharking163912973sharking
shocking184311543shocking
shucking18339433shucking
sicking143720173_sicking
skanking12288743skanking
skyjacking2641603skyjacking
slaking123717473sla_king
slicking153712593slicking
smocking17349103smocking
snafuing1235083snafuing
snagging11319373snagging
snailing92912973snailing
snapping13349653snapping
snarfing12358663snarfing
snaring83920953sna_ring
snarling92513183snarling
snatching1536363snatching
snawing113612483sna_wing
sneaking133211093sneaking
snooking133010583snooking
soaking123116613soa_king
socking143518603_socking
spacing123614493spac_ing
spackling18266503spackling
spanking153911973spanking
sparking152812543sparking
specking17359733specking
staking123919803sta_king
stalking133512223stalking
sticking153513463sticking
stocking152912503stocking
sucking143217413_sucking
swanking16399963swanking
tackling153211123_tackling
taking114725953_ta_king
talcking1567083talcking
talking123815823_talking
tanking123918793_tanking
tasking124616323_tasking
teaching143612603teaching
thanking16409523thanking
thwacking2253193thwacking
ticking143218753_ticking
tracing103720153trac_ing
trackings16247543trackings
traiking132511973traiking
tricking152714513tricking
trocking153612423trocking
trucking153310163trucking
tucking143415183_tucking
unageing1036273unageing
unaging9510933una_ging
unakin10310963una_kin_
unarming1138623unarming
uncaging1268713uncaging
uncaring11312843uncaring
uncasing11511003uncasing
uncocking1836233uncocking
undocking1735653undocking
unlacing1148653unlac_ing
unlocking1636073unlocking
unmaking1538133unmaking
unmasking1635263unmasking
unpicking1834883unpicking
unstacking1744993unstacking
untracking1746933untracking
untucking1644693untucking
unyoking1636183unyoking
waking144821383_wa_king
walking154013303_walking
wanking154216783_wanking
warking153519573_warking
wauking153410013_wauking
wicking173414773_wicking
wrecking18328153wrecking
wricking18349493wricking
yakking14376423_yakking
yanking154512463_yanking
yocking173712373_yocking
yucking173211693_yucking
zincking2435463zincking

Search took 9 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 Limit1461623167.87318565.0
3Display Results3163160.1262507.9
 (SQL Overall)1786913168.42221217.2
 
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.