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

504 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
coyotes1241070(None) 
coyote11411781coyote_
capotes11314642capotes
cenotes92814542cenotes
chayotes1636502chayotes
cocottes1238312cocottes
cojones163512102cojones
colones96124432colones
comates114123642comates
compotes144716512compotes
comtes106222812co_mtes
connotes10311452connotes
contes84432912co_ntes
cooees85621892co_oees
cooter85128612co_oter
cooters94525732co_oters
cooties93725732co_oties
coots75636842co_ot_s
cotes76347842c__otes
peyotes1238482peyotes
achiotes1339003achiotes
acolytes13168043acolytes
aconites10314353aconites
azotes154312223_azotes
boites84322703bo_ites
boletes9316063boletes
booted94822733bo_oted
bootee84323023bo_otee
bootees94114473bo_otees
booths115313793bo_oths
booties94124613bo_oties
boots75837973bo_ot_s
boozes174916523bo_ozes
borates94823013borates
boycotts1543093boycotts
boyos105418283boyo__s
bytes105217493_by_tes
cajoles163712103cajoles
cajones163311333cajones
calottes10610083calottes
canoes84725883cano_es
capote10315733capote_
carates95630613carates
cartes86239473c_artes
castes85631863c_astes
cates75951893c__ates
cayuses12188403cayuses
celotex1635023celotex
cenote83715843cenote_
cerates95428253cerates
cerites94823433cerites
certes84623083c_ertes
cetes75731103c__etes
chaoses124715123chaoses
chayote1536493chayote_
chokes154917383c_hokes
cholates132414763cholates
chooses125717433chooses
chores114828023c_hores
choses115825133c_hoses
chotts113610993c_hotts
chromes142914933chromes
chutes114615773c_hutes
chyles144813283chy_les
chymes165912153chy_mes
cites74435593c__ites
citoles9312553citoles
cleomes1138813cleomes
clones84526563c_lones
cloots85113693cloot_s
closes85425593c_loses
clothes124513813c_lothes
cloths115512483c_loths
clots75627643c_lot_s
cloves114918823c_loves
clozes174915563c_lozes
clyster12317453clyster
clysters13227843clysters
coaches144018693coaches
coacted123611613coacted
coacts105314333coact_s
coapted123911503coapted
coapts104614013coapt_s
coasted104015963coasted
coaster94219043coaster
coasters104317343coasters
coasts85719143coast_s
coated94927043co_ated
coatee84327223co_atee
coatees93816553coatees
coater84329573co_ater
coaters93525793co_aters
coatis85122603co_atis
coats75635003co_at_s
coattest1038863coattest
coaxes154715633co_axes
cobbles133814823cobbles
cobles104622883co_bles
cockles153414643cockles
cocoas104915743coco_as
cocoons11310563cocoons
cocos95624693coco__s
cocotte1138603cocotte
coddles114213593coddles
codes86247293c__odes
codices12512583codices
codons96119463codo_ns
coelomes1239293coelomes
coerces11311943coerces
coesites101313093coesites
coffees15329573coffees
coffles152610003coffles
cogitos1037613cogitos
cognates11311583cognates
cogons96818113cogo_ns
coheres122917693coheres
cohobates1646523cohobates
cohogs125810273coho_gs
cohorts123411103cohorts
cohos105921853coho__s
cohoshes1635883cohoshes
cohosted1436143cohosted
cohostess1443463cohostess
cohosts12398813cohosts
cohunes1249713cohunes
coiffes1546803coiffes
coignes103912153coignes
cointer93616723cointer
cointers103616423cointers
coitus8511893co_itus
cojoins1638993cojoins
cokes115537193c__okes
coles76055063c__oles
colies84837053co_lies
colitis92617353colitis
collates103019143collates
collets93517903collets
collies94326583collies
colobus11389373colobus
colocates13312853colocates
colognes11310603colognes
cologs96517353colo_gs
colone85425003colone_
colonel94213283colonel
colonels104210463colonels
colonies103620013colonies
colons86028683colo_ns
colonus94413443colonus
colored10313473colored
coloreds1138093coloreds
colorer9312523colorer
colorers10312183colorers
colors86622373colo_rs
colours95913443colours
colter84625093co_lter
colters93522443co_lters
colts76633293co_lt_s
colures9315143colures
comakes154413643comakes
comate104124843comate_
combes125321733co_mbes
comes97246993c__omes
comets105823583comet_s
comities12317793comities
commies133718453commies
commodes1539093commodes
commoves1736963commoves
commutes143011893commutes
comose105016853comose_
comous10816513como_us
competes144117243competes
composes145017123composes
compote135616463compote_
compted143813523compted
compts125216653compt_s
computes143914553computes
comte96125473co_mte_
conatus9310463conatus
conches144019813conches
condoes104319203condoes
condoles113015803condoles
condones112817393condones
condores113315643condores
cones76457423c__ones
confutes1339843confutes
congees103517923congees
conges94928173co_nges
congoes103617303congoes
conies84338593co_nies
conines93827793conines
conioses10313323conioses
connote9311613connote_
connoted1138863connoted
conoids10813883conoids
consoles103216153consoles
conte76633203co_nte_
contest93523233co_ntest
contos84923233co_ntos
convokes17247703convokes
cooches143515833cooches
cooed84534343co_o_ed
cooee74531023co_o_ee
cooeed95917863co_oeed
cooer74831013co_o_er
cooers84324563co_oers
cooey105828223co_o_ey
cooeys114914483co_oeys
coofs105924713co_o_fs
cooked135921363co_oked
cooker124722453co_oker
cookers134619463co_okers
cookey155414333co_okey
cookeys16478503co_okeys
cookies133719273cookies
cooks115429143co_o_ks
cooled95224593co_oled
cooler84824713co_oler
coolers93522493co_olers
coolest9318643co_olest
coolies93824963coolies
cools75632633co_o_ls
coolths1236013coolths
coombes133810663coombes
coombs124210193co_ombs
coons76737283co_o_ns
coonties10513803coonties
cooped114821613co_oped
cooper104221123co_oper
coopers114019483co_opers
coops96229643co_o_ps
coopted123710773coopted
coopts105814583co_opts
coos67456493co_o__s
coot67860383co_ot__
cootie84223093co_otie
copes97747103c__opes
copies104130313co_pies
coplots11511593coplot_s
copouts11311083copouts
copses104922483co_pses
copter109822013co_pter
copters113621283co_pters
coquets18399893coquets
corbies113520123corbies
cordites11314633cordites
cores76361853c__ores
cornets94820573cornets
corodies11313693corodies
coronas93916913coronas
coronates1110816923coronates
coronel94515223coronel
coronels104012153coronels
coroner94218203coroner
coroners104016233coroners
coronet94227173coronet
coronets103814363coronets
corotates112714283corotates
corpses113913813corpses
corries94026803corries
corrodes111310333corrodes
corses84433463co_rses
corsets94819803corsets
cortex15311473co_rtex
corvees124613793corvees
corves115122523co_rves
corvets124715023corvets
coses76949493c__oses
cosets85824403coset_s
coshes115022783co_shes
cosies84932163co_sies
cosines94122673cosines
cosmoses1239713cosmoses
cossets95014283cossets
costed95623123co_sted
coster84331293co_ster
costers94128343co_sters
costs77231143co_st_s
cote66648733c__ote_
coted85033853c__oted
cots68054843c__ot_s
cottas84615573co_ttas
cotter84926673co_tter
cotters94323453co_tters
cottons9312193cottons
cotypes1437943cotypes
couches144020473couches
coulees9315513coulees
coulter94115603coulter
coulters103614313coulters
counted103815803counted
counter94220153counter
counters103320193counters
countess103710053countess
counties10316283counties
counts84618273count_s
coupes105022523co_upes
couples115317053couples
courses94218893courses
courted103514923courted
courter94516483courter
courters103015373courters
courtesy1364973courtesy
courts84216173court_s
couter84930223co_uter
couters93827303co_uters
couths115715413co_uths
coves105539173c__oves
coveted133011523coveted
coveter122912063coveter
coveters132411083coveters
covets114819643covet_s
cowages13310943cowages
cowpies143314283cowpies
cowpokes1944573cowpokes
cowpoxes2244513cowpoxes
cowries124218013cowries
cowrites133011593cowrites
cowrote12289673cowrote_
coxes145430863c__oxes
coxitis16238463coxitis
coydogs1434493coydogs
coyed114623803coy__ed
coyer105222843coy__er
coyest11316053coy__est
coyness1277323coyness
coypous14248813coypous
coypus13389303coy_pus
coys97537243coy___s
cozes166033243c__ozes
cozies174521413co_zies
cozzes164510893co_zzes
crates85736063c_rates
creates95225203creates
creoles9913323creoles
creosotes1145653creosotes
crocoites1347473crocoites
crones84729243c_rones
crores86121163c_rores
croutes94815653croutes
crozes174417663c_rozes
cryogen1345043cryogen
cryogens1444723cryogens
cryolites1446963cryolites
cryptos14337213cryptos
crypts13397743crypt_s
culottes1076293culottes
curates95323833curates
curites93919863curites
cutes79438323c__utes
cycles1339303c_ycles
cyeses11510123c_yeses
cymes1210118923c_y_mes
cypres1338523c_ypres
cysts105912773c_yst_s
cytons111710183c_ytons
demotes104717673demotes
denotes83817003denotes
devotes113713753devotes
dodoes85716103dodo_es
donates83217223donates
dotes65836693__dotes
doylies114512573doylies
ecotones1039493ecotones
emotes84620283_emotes
flytes123911563fly_tes
folates103218453folates
fomites123613203fomites
footed104418623fo_oted
footer94320773fo_oter
footers104618333fo_oters
footies103721543fo_oties
footles103715713fo_otles
foots85528283fo_ot_s
fortes95327183fo_rtes
fyttes1236933_fyttes
garotes8614563garotes
gemotes103712143gemotes
goboes95914443gobo_es
gooses75723063go_oses
guyots1036003guyot_s
hoboes114717453hobo_es
hooted104422663ho_oted
hooter94123933ho_oter
hooters104520483ho_oters
hoots84830253ho_ot_s
hooves124815493ho_oves
horstes104516113horstes
hoyles12315013hoy_les
iodates8312903iodates
iolites73819483iolites
ionones7313883ionones
joyous16276763joyo_us
kayoes134710823kayo_es
keynotes1543633keynotes
kytes125012913_ky_tes
litotes7311183litotes
locates93218813locates
locoes85516583loco_es
locomotes1346333locomotes
looies65025833lo_oies
looses67328253lo_oses
looted74421113lo_oted
looter64222323lo_oter
looters74419163lo_oters
loots55431423lo_ot_s
lotoses73713653lotoses
lottes65322753lo_ttes
mojoes15399523mojo_es
montes84226933mo_ntes
mooted94120373mo_oted
mooter83921093mo_oter
mooters93818623mo_oters
moots75831663mo_ot_s
mopokes1536693mopokes
motes75944003__motes
mottes85523693mo_ttes
mottoes93412193mottoes
myopes13419963_myopes
myoses114013843_myoses
myosotes1344653myosotes
nooses65623653no_oses
norites74018803norites
notates72817483notates
notes55034583__notes
noyades1136563noyades
oboes75717713_obo_es
oboles83815833_oboles
oocytes1246063oocytes
oolites72817843oolites
oots46446443_o_ot_s
oozes145418713_o_ozes
orates64328613_orates
oyes74940133_oy__es
oyezes1835053_oyezes
oyster94111703_oyster
oysters103411693_oysters
ozones1539393_ozones
peyote1139853peyote_
peyotls1233633peyotls
podites103014733podites
pointes93216753pointes
pontes83627853po_ntes
pooves113914713po_oves
posoles9314883posoles
poyous112911623poyo_us
pozoles1839063pozoles
promotes12314123promotes
pyoses114314303_pyoses
quotes153312463_quotes
remotes94521613remotes
revotes104716393revotes
robots8313153robot_s
rooses65526243ro_oses
rooted75424003ro_oted
rooter64926033ro_oter
rooters74522933ro_oters
rootles73215633ro_otles
roots55933673ro_ot_s
rotates72819773rotates
rotes56143903__rotes
rottes64524833ro_ttes
routes66129313ro_utes
royster103110533royster
roysters113610533roysters
ryots85313783_ryot_s
sapotes9313943sapotes
scooted103612283sco_oted
scooter93312873sco_oter
scooters103511033sco_oters
scoots85315943sco_ot_s
shotes95321913_shotes
solates73523853solates
solutes73515263solutes
somites94219123somites
sooted73922593so_oted
soothes103917113so_othes
sooths95715593so_oths
soots55536213so_ot_s
sopites93817173sopites
sorites73825243sorites
soroses73117493soroses
soyuzes1932953soyuzes
tooted74620123to_oted
tooter64420803to_oter
tooters73818773to_oters
tooths96013803to_oths
tootles72915603to_otles
toots55331873to_ot_s
tootses72910773to_otses
tortes64826053to_rtes
totes55139683__totes
toyons95512133toyo_ns
toyos87519143toyo__s
trystes10419993trystes
unyokes1466733unyokes
voltes94915583vo_ltes
volutes102710983volutes
votes84627083__votes
voyages1435703voyages
wytes114113433_wy_tes
yokes125223023__yokes
yores85031323__yores
yowes114926373__yowes
zygotes20355163zygotes

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 Limit1340275046.40620922.1
3Display Results5045040.1732913.3
 (SQL Overall)1786915046.96925640.8
 
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.