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

235 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
knocking1424594(None) 
knacking14296711knacking
nocking143615111_nocking
blocking174510572blocking
chocking204011012chocking
clocking174312412clocking
cocking163619982_cocking
crocking174313442crocking
docking153615012_docking
flocking183410872flocking
frocking18309572frocking
hocking173417242_hocking
kecking134111882k_ecking
kicking133314022k_icking
knolling13206892knolling
knotting13236572knotting
knouting13226792knouting
knowing15287682kno_wing
knuckling1542752knuckling
konking113510212k_onking
locking143718152_locking
mocking163614452_mocking
necking143913892_necking
nicking143516322_nicking
pocking163916762_pocking
rocking143619632_rocking
shocking184311542shocking
smocking17349102smocking
snacking153411702snacking
snicking153610232snicking
snooking133010582snooking
socking143518602_socking
stocking152912502stocking
trocking153612422trocking
uncocking1836232uncocking
undocking1735652undocking
unlocking1636072unlocking
yocking173712372_yocking
anticking1649243anticking
antiking13412073antiking
arcking145811963_arcking
backing165523443_backing
becking164416073_becking
bemocking2034653bemocking
blacking174213603blacking
bonking144116373_bonking
booking143618383_booking
borking144716173_borking
bricking173911403bricking
broking143514823bro_king
brooking153710703brooking
bucking163617573_bucking
checking20379203checking
choking173911943cho_king
chucking20379503chucking
clacking173313493clacking
clicking173610983clicking
cloaking15299713cloaking
clonking153810153clonking
clucking17429993clucking
cockling172310393_cockling
coking134523883_co_king
conking143618453_conking
cooking143818973_cooking
corking143018823_corking
cracking174013903cracking
cricking173412653cricking
croaking153712163croaking
crooking153611343crooking
decking153915593_decking
dicking153617613_dicking
drouking1436443drouking
ducking154315053_ducking
enacting11311363enacting
encoding1239043encoding
encoring11312173encoring
evoking1536413evo_king
finicking1954463finicking
flacking184311793flacking
flecking18408233flecking
flicking184110043flicking
floccing16306033floccing
flockings19314343flockings
forking154014843_forking
fucking173212283_fucking
gecking154111363_gecking
grokking1334813grokking
hacking173720613_hacking
havocking2242773havocking
hoicking1836053hoicking
hoking144419513_ho_king
holking153512313_holking
honking153414793_honking
hooking153716693_hooking
howking183610313_howking
inching134414323in_ching
incoming1349863incoming
inking115119053in__king
invoking1635653invoking
jacking214515263_jacking
joking184113023_jo_king
jouking19307613_jouking
kayaking1534063kayaking
keckling14245523k_eckling
keeking114210893k_eeking
kinking113615153k_inking
knapping17314973knapping
kneading1436373kneading
kneeing12226523kn_eeing
kneeling13287783kneeling
knelling13319023knelling
knifing1536483kn_ifing
knitting13257023knitting
knock10487963knock___
knocked13236303knock_ed
knocker12296393knock_er
knockers13285733knockers
knockoff1951423knockoff
knockout1343893knockout
knocks11397443knock__s
knottings14243073knottings
knowings16234043kno_wings
knurling1344943knurling
lacking143821543_lacking
licking144118283_licking
locoing102810973_locoing
looking123415043_looking
lucking143615833_lucking
mooching16259063mooching
mucking163213823_mucking
narking124015383_narking
neckings15346113_neckings
niching133612433_niching
nickling15278703_nickling
nodding103811523_nodding
nogging103612723_nogging
noising83615173_noising
noncaking1646683_noncaking
noncling11310763_noncling
noncoking1646813_noncoking
nooning83014853_nooning
noosing83315053_noosing
noshing114612773_noshing
nosing73419843_no_sing
notching14288583_notching
nothing113511903_nothing
noting74120153_no_ting
nuking113411253_n_uking
oncoming1338353oncoming
onlooking1444453onlooking
packing164420723_packing
panicking1835293panicking
pecking164017783_pecking
picking163418333_picking
plonking15358563plonking
plucking17357723plucking
poking133819303_po_king
poncing122913583ponc_ing
pooching16328983pooching
porking143515813_porking
pricking173212603pricking
quacking2436743quacking
racking144323663_racking
recking144319923_recking
recocking18138373recocking
redocking17126783redocking
relocking16137683relocking
ricking143920233_ricking
rockling15259383_rockling
rooking123517363_rooking
rucking143216673_rucking
sacking144122703_sacking
shacking184014083shacking
shucking18339433shucking
sicking143720173_sicking
slacking153914133slacking
slicking153712593slicking
smacking173510763smacking
smockings18264283smockings
smoking143210523smo_king
snaking123915303sn_aking
sneaking133211093sneaking
snogging11318043snogging
snooding102910433snooding
snooling93013473snooling
snooping113811323snooping
snooting92813203snooting
snoozing18319083snoozing
snoring83917203sno_ring
snorting92613373snorting
snouting92511923snouting
snowing113913453sno_wing
soaking123116613_soaking
specking17359733specking
spoking143212223spo_king
spooking15269803spooking
stacking154215083stacking
sticking153513463sticking
stockings16296093stockings
stoking123615593sto_king
stooking132711143stooking
sucking143217413_sucking
tacking144421483_tacking
talcking1567083talcking
thacking183110043thacking
ticking143218753_ticking
toking114420723_to_king
tracking153715463tracking
tricking152714513tricking
troaking133310973troaking
troking123514103tro_king
trucking153310163trucking
tucking143415183_tucking
unblocking1943693unblocking
uncaking1539463uncaking
uncorking1637403uncorking
unfrocking2043533unfrocking
unhooking1735353unhooking
unmaking1538133unmaking
unpacking1835133unpacking
unpicking1834883unpicking
untacking1636643untacking
untucking1644693untucking
unyoking1636183unyoking
whacking21377483whacking
wicking173414773_wicking
working153813253_working
wracking18349963wracking
wrecking18328153wrecking
wricking18349493wricking
yacking174315683_yacking
yoking143912283_yo_king
yucking173211693_yucking
zincking2435463zincking
zonking21359113_zonking

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.466383457.1
2DLD Change Limit1461622357.80018738.7
3Display Results2352350.0932526.9
 (SQL Overall)1786912358.35921377.1
 
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.