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

247 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
neckings1534611(None) 
deckings16346681deckings
necking143913891necking_
backings174012212backings
becking164416072becking_
decking153915592decking_
gecking154111362gecking_
kecking134111882kecking_
lickings15298142lickings
necklines15115722necklines
nervings12256322nervings
nettings9288102nettings
nicking143516322nicking_
nocking143615112nocking_
packings174310062packings
pecking164017782pecking_
pickings17359382pickings
recking144319922recking_
sackings15389632sackings
tickings15368582tickings
wickings18357182wickings
wreckings19233682wreckings
actings104512463_actings
antikings1446233antikings
archings14499863archings
arcking145811963arcking_
askings12519173_askings
backing165523443backing_
bakings144312023_bakings
bankings15489403bankings
beadings123711783beadings
bearings113912253bearings
beatings114113233beatings
beckons15279143beckon_s
becomings1643783becomings
beddings13407923beddings
beings94613033be__ings
bellings113811153bellings
beltings11369253beltings
blackings18316763blackings
bookings15358733bookings
breakings16297063breakings
brokings15317713brokings
bucking163617573bucking_
calkings15289223calkings
ceilings11397993ceilings
checking20379203checking_
clings95716213__clings
cocking163619983cocking_
cookings15358603cookings
crackings18346843crackings
cyclings1635373cyclings
dealings103510703dealings
declines113315803declines
deking125614553de_king_
dicking153617613dicking_
docking153615013docking_
ducking154315053ducking_
ducklings17204013ducklings
ductings12346673ductings
earings84517713_earings
eatings84616443_eatings
eching126315563_eching_
echinus1236203_echinus
edgings10256243_edgings
eking106614983_e_king_
encinas938723enc_inas
endings92910443_endings
erlkings1333563erlkings
etchings14396293etchings
facings134511263fac_ings
feelings12338933feelings
feltings12317903feltings
fencings14225663fencings
flecking18408233flecking_
flockings19314343flockings
fucking173212283fucking_
gaskings14427473gaskings
gearings10359503gearings
geldings11316163geldings
hacking173720613hacking_
hawkings19336133hawkings
headings133510493headings
hearings123611853hearings
heckling18257163heckling_
heelings12359753heelings
helpings14255653helpings
herrings12379533herrings
hocking173417243hocking_
huskings16276043huskings
icings9428453_ic_ings
itchings14386193itchings
jacking214515263jacking_
jerking19308923jerking_
jerkins18358253jerkin_s
jestings16368023jestings
keckling14245523keckling_
keeking114210893keeking_
keepings15345943keepings
keglings14245233keglings
kennings13315273kennings
kicking133314023kicking_
kings105825563___kings
knacking14296713knacking_
knocking14245943knocking_
lacings105013653lac_ings
lacking143821543lacking_
lakings124713513_lakings
leadings103511243leadings
leaking123616973leaking_
leanings94010183leanings
leasings9379843leasings
leavings12407493leavings
leching134613653leching_
lectins92515003lectin_s
leggings11316193leggings
lekking11306503lekking_
lemmings13254733lemmings
licking144118283licking_
likings12539413_likings
locking143718153locking_
lucking143615833lucking_
makings145413163_makings
markings153410243markings
maskings15448753maskings
meanings11329163meanings
meetings11287413meetings
mendings12338303mendings
mocking163614453mocking_
mucking163213823mucking_
naethings1343873naethings
nankins1159053nankin_s
napkins1336673napkin_s
narking124015383narking_
nearing83020333nearing_
neckbands1842383neckbands
neckers134210463neck_ers
neckless14236433neckless
neckline1496363necklin_e
necks115119333neck___s
neckties1445903neckties
needing93214423needing_
needlings11294693needlings
nervines112310463nervines
nerving112910833nerving_
nesting84320443nesting_
nestlings1074313nestlings
netting84018763netting_
neurines8311193neurines
niching133612433niching_
nickling15278703nickling_
noggings11285743noggings
noonings9246653noonings
nosings8349593n_osings
nothings12266683nothings
nuking113411253n_uking_
nursings9325773nursings
nuttings9276783nuttings
packing164420723packing_
parkings153610683parkings
peaking144317693peaking_
peching154513903peching_
pectines121914683pectines
pectins112315233pectin_s
peeking144414953peeking_
peelings11339523peelings
pekins121812233pe_kin_s
perking143716463perking_
pettings11349703pettings
picking163418333picking_
piecings1345343piec_ings
pinkings15338143pinkings
pocking163916763pocking_
prickings18315653prickings
racings105015133rac_ings
racking144323663racking_
rankings13389173rankings
readings103512643readings
reckonings1742713reckonings
reckons13269653reckon_s
reclines103718543reclines
recoins94019243recoin_s
redwings13305733redwings
reedings103510363reedings
reeking123318643reeking_
reelings94012563reelings
ricking143920233ricking_
rocking143619633rocking_
rocklings16224843rocklings
ruchings14287073ruchings
rucking143216673rucking_
sacking144122703sacking_
sacrings11278923sacrings
seatings93614303seatings
seeings84411293se_eings
seeking124016063seeking_
seemings11337643seemings
seisings9398523seisings
seizings18326473seizings
sergings10299213sergings
servings12249223servings
settings93810073settings
sewings11369173se_wings
shuckings19273853shuckings
sicking143720173sicking_
smockings18264283smockings
snacking153411703snacking_
sneaking133211093sneaking_
snicking153610233snicking_
socking143518603socking_
speakings16345933speakings
specking17359733specking_
stockings16296093stockings
sucking143217413sucking_
sucklings16225113sucklings
tacking144421483tacking_
tacklings16235853tacklings
takings124512573_takings
talkings13358403talkings
teachings15296553teachings
ticking143218753ticking_
trackings16247543trackings
truckings16235023truckings
tucking143415183tucking_
veilings12357313veilings
veinings12306433veinings
vestings12359143vestings
vikings15386623_vikings
walkings16327313walkings
weaklings1794003weaklings
webbings1633243webbings
weddings14355533weddings
weepings14346483weepings
welkins1437173welkin_s
weltings12388203weltings
westings12429803westings
wettings12348403wettings
wicking173414773wicking_
workings16337503workings
wrecking18328153wrecking_
yacking174315683yacking_
yealings12257703yealings
yerking15368813yerking_
yeuking15286123yeuking_
yocking173712373yocking_
yucking173211693yucking_
zechins21137123zechin_s

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622476.72021750.3
3Display Results2472470.1062330.2
 (SQL Overall)1786912477.24924650.4
 
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.