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

482 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
deckles14331280(None) 
deciles104417721deciles
deckels14367361deckels
deckle1312012451deckle_
heckles163711381heckles
keckles12318761keckles
buckles153416092buckles
cackles153717202cackles
cockles153414642cockles
darkles124011932darkles
decades113615512decades
decals93717712decal_s
decanes103118912decanes
decares102818532decares
decides114217652decides
decile94619212decile_
decked145217622deck_ed
deckel134911042deck_el
decker135215992deck_er
deckers144413832deckers
decks124822192deck__s
decodes113914982decodes
decrees102513122decrees
decries103319802decries
decuples1395282decuples
defiles114016842defiles
dekes105224452de_k_es
deles65139252de__les
dickies143416342dickies
duckies143613812duckies
feckless17225782feckless
freckles17126382freckles
geckoes14325792geckoes
hackles162917062hackles
heckle153112092heckle_
heckled17318462heckled
heckler16278572heckler
hecklers17357122hecklers
huckles163612622huckles
keckle11359422keckle_
keckled13376502keckled
mackles154415752mackles
mickles153415002mickles
muckles153413252muckles
neckless14236432neckless
nickles133713822nickles
pickles153215442pickles
reckless14257972reckless
ruckles133414602ruckles
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
checkless2044233checkless
chuckles1936803chuckles
cockle143913573cockle_
cockled163710823cockled
coles76055063__coles
crackles164111273crackles
cycles1339303cyc_les
dabbles124514773dabbles
daces85030683dac__es
dacites101114593dacites
dacker134920753dack_er
dackers143417043dackers
daddles104213803daddles
daggles103611913daggles
dales66439743d__ales
dalles74222063d_alles
dandles94218533dandles
dangles93618423dangles
dapples1238993dapples
darkies124015753darkies
darkle113813943darkle_
darkled13378723darkled
dartles84014133dartles
dawdles12379163dawdles
dazzles1636413dazzles
dealer74122143de_aler
dealers84118613de_alers
deals65435343de_al_s
dearies83526273dearies
deashes113313903deashes
deaves105319533de_aves
debacles1335723debacles
debases103814133debases
debates103718533debates
debones103315113debones
debtless1135653debtless
debyes1238103de_byes
decade104216163decade_
decafs124010883dec_afs
decal85523233decal__
decalog1136003decalog
decalogs1245633decalogs
decamps1435643decamps
decane93818873decane_
decants103514443decants
decare93919153decare_
decayed14309333decayed
decayer13339353decayer
decayers14307963decayers
decayless1542863decayless
decays124612913dec_ays
decease1049523decease
deceases11410153deceases
deceits102810883deceits
deceives1437903deceives
decerns10119053decerns
deciares11510633deciares
decibel1235993decibel
decibels1344523decibels
decide104116873decide_
decided124312423decided
decider114213183decider
deciders123510753deciders
deck115827753deck___
decking153915593decking
deckings16346683deckings
declares11611313declares
declass1038733declass
declaw1266703dec_law
declaws1336253declaws
declines113315803declines
decocts1237833decocts
decode104414743decode_
decoded123212383decoded
decoder113712293decoder
decoders122810413decoders
decolor1087033decolor
decolors1187713decolors
decors94017773dec_ors
decos85522123dec__os
decouples14104943decouples
decoyed14358333decoyed
decoyer13348683decoyer
decoyers14287713decoyers
decoys123911283dec_oys
decree93117783dec_ree
decreed112710253decreed
decreer10269123decreer
decreers11277623decreers
decried112612853decried
decrier102713553decrier
decriers11299733decriers
decuple1285363decuple_
decupled1494983decupled
decuries11312223decuries
decurves1435863decurves
deduces1168793deduces
deedless10318253deedless
dees56356633de___es
defaces133213403defaces
defames132812253defames
defies104624053de_fies
defile105216663defile_
defiled124013103defiled
defiler113911883defiler
defilers12439473defilers
defines114118683defines
deflea1037443de_flea
defleas1147223de_fleas
defuels11296983defuels
defuses114814593defuses
defuzes20398303defuzes
degames113312623degames
degases93413103degases
degrees92810723degrees
deices94119373de_ices
deicides1249303deicides
deifies113317453deifies
deils65722863de_il_s
deities82621923deities
dekares122710873dekares
deke95228763de_k_e_
deked115718533de_k_ed
dekkos1034103de_kkos
delates83526283delates
dele56843083de__le_
deled75326543de__led
deletes83117933deletes
delfs94918673de__lfs
delimes10314193delimes
delis64928543de__lis
dellies83622213dellies
dells66630943de__lls
dels56745473de__l_s
delts65731793de__lts
deludes91810643deludes
deluges9169263deluges
delves104917083de_lves
demes86032693de__mes
demies94825803de_mies
demises103719563demises
demoses103815823demoses
demotes104717673demotes
denes65639723de__nes
dengues938183dengues
denies74729643de_nies
denotes83817003denotes
denudes91510043denudes
depones103717093depones
deposes103117213deposes
deputes104911783deputes
derates84028893derates
derbies103016053derbies
derides93420853derides
derives114017813derives
derries83124623derries
desalts839573desalts
descries11311923descries
desexes1537833desexes
desires81316133desires
deskmen1435023deskmen
desks105913073desk__s
detoxes1538803detoxes
deuces94015513de_uces
devalues1235853devalues
develed123611933develed
devels104313903devel_s
devices133212583devices
deviled124112183deviled
devils104412813devil_s
devises114116763devises
devolves15286263devolves
devotes113713753devotes
dewaxes18297843dewaxes
dewless1137473de_wless
dexes135224513de__xes
dexies145018343de_xies
dholes104914793d_holes
dibbles124013333dibbles
dices86434243dic__es
dicked144920863dick_ed
dickens144410133dickens
dicker134521403dick_er
dickers144117663dickers
dickey165913523dick_ey
dickeys17479303dickeys
dickie133913113dickie_
dickier143512453dickier
dickiest153412503dickiest
dicks125824693dick__s
diddles103915073diddles
dikes105831333d_ik_es
dimples122813213dimples
dindles93817243dindles
dingles93818323dingles
dinkies123716033dinkies
dipoles101013753dipoles
docile94213123docile_
dockages1635983dockages
docked145018333dock_ed
docker134417653dock_er
dockers143715003dockers
docket134721173dock_et
dockets144412243dockets
docks126022313dock__s
doles67843753d__oles
dongles93212873dongles
doodles93614163doodles
dottles83912283dottles
doubles103113353doubles
drakes114715863drak_es
drecks13459203dreck__s
duces86327473duc__es
duchies133312313duchies
ducked144718013duck_ed
ducker134317993duck_er
duckers143214713duckers
duckie133511663duckie_
duckier143911793duckier
duckiest153211863duckiest
ducks124823213duck__s
ductless11196313ductless
ductules1155543ductules
duffles14308923duffles
dukes105023473d_uk_es
dykes135215573d_yk_es
eagles73819163_eagles
eches106322163_ec_hes
echoes114715523_echoes
edibles1048003edibles
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
hackees165014103hackees
hackies163418243hackies
hackle154916813hackle_
hackled173312493hackled
hackler163512353hackler
hacklers173710303hacklers
hecks145220653heck__s
heddles123311623heddles
hercules1337633hercules
hickies163614743hickies
huckle153913073huckle_
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
shackles173010593shackles
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
wickless1736083wickless
winkles143412773winkles

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 Filter1786911340270.390458182.1
2DLD Change Limit1340274825.95322514.2
3Display Results4824820.1732786.1
 (SQL Overall)1786914826.51627423.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.