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

402 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
heckles16371138(None) 
deckles143312801deckles
hackles162917061hackles
heckle153112091heckle_
heckled17318461heckled
heckler16278571heckler
hecklers17357121hecklers
huckles163612621huckles
keckles12318761keckles
buckles153416092buckles
cackles153717202cackles
checkless2044232checkless
chuckles1936802chuckles
cockles153414642cockles
deciles104417722deciles
deckels14367362deckels
deckle1312012452deckle_
feckless17225782feckless
freckles17126382freckles
geckoes14325792geckoes
hackees165014102hackees
hackies163418242hackies
hackle154916812hackle_
hackled173312492hackled
hackler163512352hackler
hacklers173710302hacklers
hecks145220652heck__s
heddles123311622heddles
hercules1337632hercules
hickies163614742hickies
huckle153913072huckle_
keckle11359422keckle_
keckled13376502keckled
mackles154415752mackles
mickles153415002mickles
muckles153413252muckles
neckless14236432neckless
nickles133713822nickles
pickles153215442pickles
reckless14257972reckless
ruckles133414602ruckles
shackles173010592shackles
sickles133417542sickles
speckles16268132speckles
suckles134516742suckles
tackles133816522tackles
tickles133416852tickles
ackees124914583_ackees
aediles83413903aediles
ankles104818383_ankles
backless162910633backless
beadles103414733beadles
beagles103212123beagles
beakless14297383beakless
becalms1335743becalms
becked155417763beck_ed
becket144619883beck_et
beckets15399823beckets
beckons15279143beckons
becks135522013beck__s
becomes132911963becomes
beetles9312083beetles
belles85325993be_lles
brickles162810283brickles
buckle144815193buckle_
buckled164411883buckled
buckler154112033buckler
bucklers16349503bucklers
buckoes153810393buckoes
cackle143416923cackle_
cackled164613303cackled
cackler153812573cackler
cacklers163710703cacklers
checked193710023check_ed
checker18329533check_er
checkers19317843checkers
checklist2043853checklist
checks174912703check__s
checkups2142803checkups
cheekless1873883cheekless
chickees19258513chickees
chicles143512503chic_les
chuckies1937703chuckies
chuckle1836443chuckle_
chuckled2045163chuckled
chuckler1935553chuckler
chucklers2034443chucklers
cockle143913573cockle_
cockled163710823cockled
coles76055063__coles
crackles164111273crackles
cycles1339303cyc_les
darkles124011933darkles
decades113615513decades
decals93717713decal_s
decanes103118913decanes
decares102818533decares
decides114217653decides
decile94619213decile_
decked145217623deck_ed
deckel134911043deck_el
decker135215993deck_er
deckers144413833deckers
decks124822193deck__s
decodes113914983decodes
decrees102513123decrees
decries103319803decries
decuples1395283decuples
defiles114016843defiles
dekes105224453de_k_es
deles65139253de__les
dickies143416343dickies
duckies143613813duckies
eagles73819163_eagles
eches106322163_ec_hes
echoes114715523_echoes
ediles74016983_ediles
ekes86726603_e_k_es
exiles134816403_exiles
feces105625363fec__es
feckly18335963feckl_y
fecks145417853feck__s
females12310663females
ferules103112723ferules
fettles103912733fettles
fickle153912973fickle_
fickler16348423fickler
ficklest17267903ficklest
fleckless1842893fleckless
freckle16106643freckle_
freckled18104443freckled
gecked146911933geck_ed
geckos13457433geck_os
gecks125117093geck__s
gentles83714343gentles
grackles15309183grackles
hacked164923513hack_ed
hackee154921833hack_ee
hacker154822693hack_er
hackers164619043hackers
hackie154615623hackie_
hacklier1737133hacklier
hackliest1836523hackliest
hackly18298733hackl_y
hackmen1836713hackmen
hackney1935123hackney
hackneys2033683hackneys
hacks144928713hack__s
haggles123312483haggles
hakes126034303h_ak_es
hales85449843h__ales
handles114020653handles
hankies143617763hankies
hantles104117513hantles
haoles94919803h_aoles
hassles103411693hassles
hawkies173311243hawkies
headless12289863headless
healed105121443he_aled
healer94221803he_aler
healers104319463he_alers
heals85733453he_al_s
hearses104414533hearses
heatless113011463heatless
heaumes1237423heaumes
heaves124120303he_aves
heavies132713873heavies
hebes105521673he__bes
heck135826493heck___
heckling18257163heckling
hectares1338853hectares
hectors123513263hectors
heddle114211163heddle_
hedges115016263he_dges
heedless12278813heedless
heeled104018413he_eled
heeler93917313he_eler
heelers103815623he_elers
heelless11257653heelless
heels85625533he_el_s
heezes184211643he_ezes
heiled104415613he_iled
heils85222193he_il_s
heinies102514543heinies
heirless1146053heirless
helices12313723helices
helixes1739133helixes
helled104024703he_lled
heller93322513he_ller
hellers103619833he_llers
helloes103717463helloes
hellos95321683he_llos
hells85032043he__lls
helmless1334273helmless
helms105619463he__lms
helos84928063he__los
helpless1335063helpless
helps105219343he__lps
helves124316063he_lves
hemes105031083he__mes
henges104516463he_nges
henley1237483he_nley
henleys1334843he_nleys
henries102718283henries
heralds1137713heralds
herbless1336663herbless
heredes11313133heredes
heres86245903he__res
herls85226433he_rl_s
heroes94923823he_roes
herpes115517323he_rpes
herries104025073herries
hertzes1938303hertzes
hexades18378703hexades
hexanes17319463hexanes
hexes155123043he__xes
hexones17299143hexones
hexoses17228883hexoses
hexyls1933433hexyl_s
hickey185011993hick_ey
hickeys19508223hickeys
hickie153812473hickie_
hicks145322173hick__s
higgles123911803higgles
hikes125426983h_ik_es
hirples12149643hirples
hirsles101510073hirsles
hobbles143313783hobbles
hocked165521303hock_ed
hocker155118563hock_er
hockers163915913hockers
hockey184813153hock_ey
hockeys19509273hockeys
hocks144925493hock__s
hocuses121710423hocuses
hoecakes1745323hoecakes
hokes126231643h_ok_es
holes84748653h__oles
hondles113614523hondles
honkies143015143honkies
hookies144017443hookies
hookless151238363hookless
hooklet142510813hooklet
hooklets15217203hooklets
hopples142810713hopples
hoyles12315013h_oyles
hucks144322173huck__s
huddles123712573huddles
humbles143215803humbles
hunkies143214503hunkies
hurdles113613373hurdles
hurtles103913753hurtles
huskies143212083huskies
hustles103414173hustles
inkles103515653_inkles
jacales16310323jacales
jackies202912623jackies
jackleg2135043jackleg
jacklegs2233963jacklegs
jerkies183411583jerkies
kecked125113173keck_ed
kecks105416573keck__s
kettles113411613kettles
knuckles1384453knuckles
leakless12246983leakless
leches115421313lec_hes
lechwes1535063lechwes
locales93715093locales
locules92812603locules
luckies133313683luckies
luckless14265893luckless
mackle143716433mackle_
mackled164111923mackled
macles107023223mac_les
macules114015133macules
measles92412753measles
meddles113213253meddles
meikle1236653meikle_
merles85322763me_rles
mettles94115023mettles
mickle143715133mickle_
mickler153310233mickler
micklest16219123micklest
muckle143413583muckle_
myceles1435213myceles
necked134715063neck_ed
necker124012793neck_er
neckers134210463neckers
necklaces1743513necklaces
necklines15115723necklines
necks115119333neck__s
neckties1445903neckties
needles83211563needles
nestles73015463nestles
nettles73214083nettles
nickels13338653nickels
nickle123814483nickle_
nickled144010443nickled
oscules938123oscules
peakless14236683peakless
pebbles1337573pebbles
pecked155019103peck_ed
pecker144615363peck_er
peckers153312673peckers
peckier153910523peckier
peckiest162711393peckiest
pecks135724433peck__s
peddles112913703peddles
pekes114623563pe_k_es
pekoes124410423pe_koes
peles75738083pe__les
penuckles1743243penuckles
peoples11312223peoples
percales12313803percales
pestles93217693pestles
pettles93916483pettles
pickle144215653pickle_
pickled164011883pickled
prickles162511093prickles
rackle123917293rackle_
rankles113114543rankles
reales64934123re_ales
recalls92613623recalls
recanes93222263recanes
recces10614913rec_ces
recedes102816063recedes
recipes113314463recipes
recites93524583recites
recked134821803reck_ed
reckons13269653reckons
recks115625133reck__s
recodes102918633recodes
recuses94619463recuses
recycles1535353recycles
reddles93315773reddles
refiles104122423refiles
regales83520793regales
resales74724903resales
rescales103414573rescales
resiles74026543resiles
resoles73823653resoles
retackles1545363retackles
retiles74426993retiles
reviles104421353reviles
rockless14297293rockless
ruckle124414583ruckle_
ruckled144111033ruckled
runkles114111943runkles
scales84529313_scales
secedes103711983secedes
secures9613163secures
selkies113513353selkies
selles64426983se_lles
seniles72618023seniles
settles73916003settles
shackle16409543shackle_
shackled18277603shackled
shackler17317973shackler
shacklers18336033shacklers
shackoes17367853shackoes
shekels1436043she_kels
sickees134514213sickees
sickies133717503sickies
sickle124418323sickle_
sickled144713433sickled
sicklies14710013sicklies
sockless14267793sockless
socles8418453soc_les
spackles16319953spackles
speckle15297553speckle_
speckled17255833speckled
stickles142512103stickles
suckle124015963suckle_
suckled144212513suckled
suckler133413093suckler
sucklers14379963sucklers
suckless14288823suckless
tackle123815733tackle_
tackled143913193tackled
tackler134013323tackler
tacklers143010773tacklers
tackless14419483tackless
teazles16308923teazles
techies12513603techies
tekkies1035943tekkies
teles54536003te__les
temples112610893temples
tickle124616743tickle_
tickled144313133tickled
tickler133612653tickler
ticklers14339303ticklers
tinkles113713923tinkles
trickles143013763trickles
truckles14319383truckles
uncles8317163unc_les
venules104011483venules
wackes154717713wack_es
weeklies1534913weeklies
wheedles1534643wheedles
wheeples1634743wheeples
wickless1736083wickless
winkles143412773winkles

Search took 10 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 Filter1786911340270.423422437.4
2DLD Change Limit1340274028.78015265.0
3Display Results4024020.3131284.3
 (SQL Overall)1786914029.51618778.0
 
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.