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

385 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
heckle15311209(None) 
deckle1312012451deckle
hackle154916811hackle
heckled17318461heckled
heckler16278571heckler
heckles163711381heckles
huckle153913071huckle
keckle11359421keckle
buckle144815192buckle
cackle143416922cackle
chuckle1836442chuckle
cockle143913572cockle
decile94619212decile
deckel134911042deckel
deckles143312802deckles
feckly18335962feckly
fickle153912972fickle
freckle16106642freckle
hackee154921832hackee
hackie154615622hackie
hackled173312492hackled
hackler163512352hackler
hackles162917062hackles
hackly18298732hackly
heck135826492heck__
hecklers17357122hecklers
hecks145220652heck_s
heddle114211162heddle
hickie153812472hickie
huckles163612622huckles
keckled13376502keckled
keckles12318762keckles
mackle143716432mackle
meikle1236652meikle
mickle143715132mickle
muckle143413582muckle
nickle123814482nickle
pickle144215652pickle
rackle123917292rackle
ruckle124414582ruckle
shackle16409542shackle
sickle124418322sickle
speckle15297552speckle
suckle124015962suckle
tackle123815732tackle
tickle124616742tickle
ackee115825373_ackee
aedile73716653aedile
ankle95220253_ankle
beadle93314683beadle
beagle93612593beagle
becalm1239203becalm
became123213163became
beck126226573beck__
becked155417763becked
becket144619883becket
beckon14309383beckon
becks135522013beck_s
become123312593become
beetle8311673beetle
belle75827833be_lle
brickle15279933brickle
buckled164411883buckled
buckler154112033buckler
buckles153416093buckles
cackled164613303cackled
cackler153812573cackler
cackles153717203cackles
cecal94619113cecal_
check164714713check__
checkable2244743checkable
checked193710023checked
checker18329533checker
checkless2044233checkless
checks174912703check_s
checkup2043323checkup
chickee183111553chickee
chicle134312543chic_le
chuckled2045163chuckled
chuckler1935553chuckler
chuckles1936803chuckles
cicale10314503cicale
cockled163710823cockled
cockles153414643cockles
cole66956113__cole
crackle153611253crackle
cycle1239523cyc_le
darkle113813943darkle
decade104216163decade
decal85523233decal_
decals93717713decals
decane93818873decane
decare93919153decare
decide104116873decide
deciles104417723deciles
deck115827753deck__
decked145217623decked
deckels14367363deckels
decker135215993decker
decks124822193deck_s
decode104414743decode
decree93117783decree
decuple1285363decuple
defile105216663defile
deke95228763de_k_e
dele56843083de__le
dickie133913113dickie
docile94213123docile
duckie133511663duckie
eagle64219483_eagle
eche97520283_ec_he
edile64819493_edile
eke75630093_e_k_e
exile126117653_exile
facile112514883facile
fecal105119213fecal_
feck134923433feck__
feckless17225783feckless
fecks145417853feck_s
fecula113310053fecula
feculae12339203feculae
feeble1138253feeble
female11310553female
ferule93413203ferule
fettle93713123fettle
fickler16348423fickler
fickly18318533fickly
freckled18104443freckled
freckles17126383freckles
freckly19124593freckly
geck115721993geck__
gecked146911933gecked
gecko124511113geck_o
geckoes14325793geckoes
geckos13457433geckos
gecks125117093geck_s
gentle74014513gentle
grackle14338893grackle
habile11515213habile
hack135134543hack__
hackable1937473hackable
hacked164923513hacked
hackees165014103hackees
hacker154822693hacker
hackies163418243hackies
hacklers173710303hacklers
hacklier1737133hacklier
hackmen1836713hackmen
hackney1935123hackney
hacks144928713hack_s
haggle113511983haggle
hake115637843h_ak_e
hale76052833h__ale
handle104219293handle
hankie133915713hankie
hantle94318203hantle
haole84820083h_aole
hassle93711593hassle
hawkie163810093hawkie
heal75645693he_al_
healed105121443he_aled
healer94221803he_aler
heals85733453he_als
hearse94114273hearse
heaume1137543heaume
heave114521813he_ave
hebe96424703he__be
heckling18257163heckling
hectare1238463hectare
hectic132311523hectic
hector113312653hector
heddles123311623heddles
hedge105317353he_dge
heel75034223he_el_
heeled104018413he_eled
heeler93917313he_eler
heels85625533he_els
heeze175313483he_eze
heil76328933he_il_
heiled104415613he_iled
heils85222193he_ils
heinie92512663heinie
held85330403he__ld
hell75637893he__ll
helled104024703he_lled
heller93322513he_ller
hello86522983he_llo
hells85032043he_lls
helm95530023he__lm
helo75332853he__lo
help95328923he__lp
helve115018093he_lve
hemal104419803hemal_
heme95034413he__me
hempie132410563hempie
hence104920043he_nce
henge94819833he_nge
henley1237483he_nley
herald10311343herald
hercules1337633hercules
here76447103he__re
herl75834553he_rl_
herls85226433he_rls
hermae115314473hermae
hewable15177823hewable
hexade17438903hexade
hexane16379533hexane
hexone16289233hexone
hexose16267843hexose
hexyl1844463hexyl_
hexyls1933433hexyls
hick135530303hick__
hickey185011993hickey
hickies163614743hickies
hicks145322173hick_s
higgle113811743higgle
hike116830393h_ik_e
hirple11158973hirple
hirsle9159573hirsle
hobble133913433hobble
hock136031303hock__
hocked165521303hocked
hocker155118563hocker
hockey184813153hockey
hocks144925493hock_s
hoecake1645203hoecake
hoke115935933h_ok_e
hole77553393h__ole
hondle103914523hondle
honkie133011673honkie
hooklet142510813hooklet
hopple132910483hopple
hoyle11314413h_oyle
huck135927633huck__
hucks144322173huck_s
huddle113712993huddle
humble133615053humble
hunkie133812383hunkie
hurdle103712793hurdle
hurtle93512943hurtle
hustle93113993hustle
inkle94515833_inkle
jackleg2135043jackleg
keck94920713keck__
kecked125113173kecked
kecks105416573keck_s
kettle104311613kettle
knuckle1254233knuckle
lechwe1435113lechwe
leke85527403le_k_e
locale83915653locale
locule83412033locule
luckie123611413luckie
mackled164111923mackled
mackles154415753mackles
macle96127003mac_le
macule104115273macule
measle83513223measle
meddle103312763meddle
meekly1535193meekly
merle75824373me_rle
mettle83815723mettle
mickler153310233mickler
mickles153415003mickles
muckles153413253muckles
mycele1335853mycele
nebule848753nebule
neck105423663neck__
necked134715063necked
necker124012793necker
necklace1643643necklace
neckless14236433neckless
necklike13104563necklike
neckline1496363neckline
necks115119333neck_s
necktie1344363necktie
needle73310613needle
nestle63013953nestle
nettle64514583nettle
nickel123811343nickel
nickled144010443nickled
nickles133713823nickles
oscule838193oscule
packly17228333packly
pebble1238003pebble
peck125730683peck__
pecked155019103pecked
pecker144615363pecker
peckier153910523peckier
pecks135724433peck_s
pecky165515093peck_y
peddle103512823peddle
peke105926203pe_k_e
pekoe114612363pe_koe
pele65539553pe__le
penile82219603penile
penuckle1643263penuckle
people10310193people
percale11314093percale
pestle83215843pestle
pettle84116053pettle
pickled164011883pickled
pickles153215443pickles
prickle153611013prickle
rankle103414883rankle
recall83815723recall
recane83022873recane
recce9514563rec_ce
recede95515533recede
recipe103414893recipe
recite83625113recite
reck106130563reck__
recked134821803recked
reckless14257973reckless
reckon123010543reckon
recks115625133reck_s
recode93618713recode
recuse85519163recuse
recycle1445343recycle
reddle83815913reddle
refile95122373refile
regale74821453regale
resale64025543resale
rescale93215473rescale
resile64627673resile
resole64624183resole
retackle1445043retackle
retile65929673retile
revile94921613revile
ruckled144111033ruckled
ruckles133414603ruckles
runkle103611543runkle
scale74629143_scale
secede93311993secede
sectile9311973sectile
secure8513533secure
sedile73517233sedile
selkie102811693selkie
selle54428313se_lle
semple103212753semple
senile63420213senile
settle63915663settle
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
shekel1338383she_kel
sickee124622223sickee
sickie123715743sickie
sickled144713433sickled
sickles133417543sickles
sickly153110483sickly
socle7419573soc_le
spackle15369573spackle
speckled17255833speckled
speckles16268133speckles
stickle132410973stickle
suckled144212513suckled
suckler133413093suckler
suckles134516743suckles
tackled143913193tackled
tackler134013323tackler
tackles133816523tackles
teazle15329553teazle
techie11511723techie
tekkie934203tekkie
tele45040873te__le
temple102811333temple
thecae11299653thec_ae
thecal113310303thecal_
thecate123210023thecate
thickly19415573thickly
tickled144313133tickled
tickler133612653tickler
tickles133416853tickles
tinkle103714453tinkle
trickle133613443trickle
truckle13358863truckle
uncle7317053unc_le
venule94411763venule
wacke145918623wack_e
weakly1636483weakly
weekly1635313weekly
wheedle1434823wheedle
wheeple1534853wheeple
winkle133812833winkle

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127163855.72019705.6
3Display Results3853850.1233130.1
 (SQL Overall)1786913856.23328668.5
 
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.