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

476 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
deckle131201245(None) 
decile94619211decile
deckel134911041deckel
deckles143312801deckles
heckle153112091heckle
keckle11359421keckle
buckle144815192buckle
cackle143416922cackle
cockle143913572cockle
darkle113813942darkle
decade104216162decade
decal85523232decal_
decals93717712decals
decane93818872decane
decare93919152decare
decide104116872decide
deciles104417722deciles
deck115827752deck__
decked145217622decked
deckels14367362deckels
decker135215992decker
decks124822192deck_s
decode104414742decode
decree93117782decree
decuple1285362decuple
defile105216662defile
deke95228762de_k_e
dele56843082de__le
dickie133913112dickie
docile94213122docile
duckie133511662duckie
feckly18335962feckly
fickle153912972fickle
freckle16106642freckle
hackle154916812hackle
heckled17318462heckled
heckler16278572heckler
heckles163711382heckles
huckle153913072huckle
keckled13376502keckled
keckles12318762keckles
mackle143716432mackle
meikle1236652meikle
mickle143715132mickle
muckle143413582muckle
nickle123814482nickle
pickle144215652pickle
rackle123917292rackle
ruckle124414582ruckle
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_
chuckle1836443chuckle
cicale10314503cicale
cockled163710823cockled
cockles153414643cockles
cole66956113__cole
crackle153611253crackle
cycle1239523cyc_le
dabble114515193dabble
dace76934923dac__e
dacite91115883dacite
dacker134920753dacker
daddle94214283daddle
daggle93711903daggle
dale55643983d__ale
dandle84218093dandle
dangle84119303dangle
dankly14419463dankly
dapple1138853dapple
darkie113714013darkie
darkled13378723darkled
darkles124011933darkles
darkly145411073darkly
dartle73714833dartle
dawdle11399503dawdle
dazzle1536853dazzle
deadly113811473deadly
deafly13389123deafly
deal56347413de_al_
dealer74122143de_aler
deals65435343de_als
dealt65234283de_alt
dearie73319813dearie
dearly104615323dearly
deave95022333de_ave
debacle1237443debacle
debase94014473debase
debate94419193debate
debone93714783debone
debye1138903de_bye
decades113615513decades
decaf114919443dec_af
decafs124010883decafs
decalog1136003decalog
decamp1338453decamp
decanes103118913decanes
decant93524223decant
decares102818533decares
decay114718483dec_ay
decayed14309333decayed
decayer13339353decayer
decays124612913decays
decease1049523decease
deceit93018213deceit
deceive1337813deceive
decent94023703decent
decern91310953decern
deciare10710663deciare
decibel1235993decibel
decided124312423decided
decider114213183decider
decides114217653decides
deckers144413833deckers
decking153915593decking
declare10411223declare
declaw1266703declaw
decline103716613decline
deco76125973dec__o
decoct11313783decoct
decoded123212383decoded
decoder113712293decoder
decodes113914983decodes
decolor1087033decolor
decor84717573dec_or
decors94017773decors
decos85522123dec_os
decouple13114873decouple
decoy115716313dec_oy
decoyed14358333decoyed
decoyer13348683decoyer
decoys123911283decoys
decreed112710253decreed
decreer10269123decreer
decrees102513123decrees
decried112612853decried
decrier102713553decrier
decries103319803decries
decry115514353dec_ry
decupled1494983decupled
decuples1395283decuples
decurve1335583decurve
decury1277963decury
dedal75719023dedal_
deduce1079253deduce
dee47665823de___e
deeply1257013deeply
deface123113863deface
defame123212433defame
defiled124013103defiled
defiler113911883defiler
defiles114016843defiles
define104718143define
deflea1037443de_flea
deftly1336533deftly
defuel10348933defuel
defuse105712723defuse
defuze19487843defuze
degage92711383degage
degame102713183degame
degree82814853degree
deice84320033de_ice
deicide1149403deicide
deil56231623de_il_
deils65722863de_ils
dekare112811563dekare
deked115718533de_ked
dekes105224453de_kes
dekko936393de_kko
dekkos1034103dekkos
del46752753de__l_
delate73827753delate
deled75326543de__led
deles65139253de__les
delete73620703delete
delf85436573de__lf
deli55631293de__li
delime9314043delime
dell56938203de__ll
dells66630943de_lls
delly96023873de_lly
dels56745473de__ls
delt57855273de__lt
delude81910673delude
deluge8189403deluge
deluxe14197303deluxe
delve96018263de_lve
deme76536283de__me
demise94618323demise
demode104013463demode
demote94817803demote
demure9311533demure
dene56643413de__ne
dengue838253dengue
denote74118043denote
dense65923503de_nse
denude8169353denude
depone93616553depone
depose94215763depose
depute94512303depute
derate74531233derate
dere56845903de__re
deride84420033deride
derive103817043derive
desalt7518313desalt
desire7415303desire
desk95618903desk__
deskmen1435023deskmen
desks105913073desk_s
deuce84517493de_uce
devalue1136013devalue
devel94217123devel_
develed123611933develed
devels104313903devels
device124512163device
devil94714733devil_
deviled124112183deviled
devils104412813devils
devise104215753devise
devolve14316063devolve
devote104513783devote
dewily1338343dewily
dexie134716893de_xie
dhole95215363d_hole
dibble114013843dibble
dice75841893dic__e
dick116432383dick__
dicked144920863dicked
dicker134521403dicker
dickey165913523dickey
dickier143512453dickier
dickies143416343dickies
dicks125824693dick_s
dicky154816243dick_y
diddle94915213diddle
dike95935763d_ik_e
dimple113512793dimple
dindle84417223dindle
dingle84317073dingle
dinkly144311083dinkly
dipole91112853dipole
doable93115243doable
dock116228743dock__
dockage1535723dockage
docked145018333docked
docker134417653docker
docket134721173docket
docks126022313dock_s
dole56550003d__ole
dongle83612493dongle
doodle83212853doodle
dottle74212503dottle
double94013993double
drake104918303drak_e
dreck124812803dreck__
drecks13459203dreck_s
drecky16486333dreck_y
ducal84816423ducal_
duce76933503duc__e
duck115929173duck__
ducked144718013ducked
ducker134317993ducker
duckier143911793duckier
duckies143613813duckies
ducks124823213duck_s
ducky154216113duck_y
ductile1048483ductile
ductule1065503ductule
duffle13368533duffle
duke95628103d_uk_e
duple85315863d_uple
dyable12308983dyable
dyeable1337303dyeable
dyke126418183d_yk_e
eagle64219483_eagle
eche97520283_ec_he
edible969353edible
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
hackee154921833hackee
hackie154615623hackie
hackled173312493hackled
hackler163512353hackler
hackles162917063hackles
hackly18298733hackly
heck135826493heck__
hecklers17357123hecklers
hecks145220653heck_s
heddle114211163heddle
hickie153812473hickie
huckles163612623huckles
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
shackle16409543shackle
sickee124622223sickee
sickie123715743sickie
sickled144713433sickled
sickles133417543sickles
sickly153110483sickly
socle7419573soc_le
spackle15369573spackle
speckled17255833speckled
speckles16268133speckles
stickle132410973stickle
suckled144212513suckled
suckler133413093suckler
suckles134516743suckles
tackled143913193tackled
tackler134013323tackler
tackles133816523tackles
teazle15329553teazle
techie11511723techie
tekkie934203tekkie
tele45040873te__le
temple102811333temple
tickled144313133tickled
tickler133612653tickler
tickles133416853tickles
tinkle103714453tinkle
trickle133613443trickle
truckle13358863truckle
uncle7317053unc_le
venule94411763venule
wacke145918623wack_e
weakly1636483weakly
weekly1635313weekly
winkle133812833winkle

Search took 6 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.360496363.9
2DLD Change Limit1127164765.12322002.0
3Display Results4764760.1563051.3
 (SQL Overall)1786914765.63931688.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.