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

368 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
eyasses1038802(None) 
eyases94513681eya_ses
amasses93912852amasses
asses55629282__asses
basses85428302_basses
biasses94911652biasses
brasses93818352brasses
bypasses1533832bypasses
chasses124017502chasses
classes94717942classes
degasses10278362degasses
eases56041612e_a_ses
easies64126632e_asies
elapses957662elapses
erases64425402era_ses
esses56422972e__sses
eyass84410782eya_s_s
frasses104314512frasses
gasses75724782_gasses
glasses84414272glasses
grasses84117342grasses
kvasses14365502kvasses
lasses64827592_lasses
lyases95211872lya_ses
masses85028712_masses
megasses11307742megasses
myases113711552mya_ses
oyesses1037332oyesses
passes86030472_passes
quasses16209502quasses
repasses101810372repasses
sasses64124392_sasses
tasses64826762_tasses
trasses74819322trasses
wrasses103812592wrasses
yesses93615812_yesses
abases85720773aba_ses
abashes12510373abashes
abysses1234863abysses
admasses1135413admasses
amassed10388633amassed
amasser9418733amasser
amassers10337843amassers
apses76823913__apses
arses55733873__arses
ashes86230613__ashes
assess65710463__assess
asset55932263__asset
assets65617663__assets
avgasses1284193avgasses
baases85218013_baases
badasses1136173badasses
bagasses1136313bagasses
bases75644353_ba_ses
bashes115631393_bashes
basset85225383_basset
bassets96414823_bassets
bassos85313703_bassos
bastes85330383_bastes
bekisses1434243bekisses
biases84618433bia_ses
biassed10418703biassed
blesses93812393blesses
blisses94911513blisses
bosses85925403_bosses
braises93818873braises
brashes124518463brashes
brassed103612373brassed
brassies103613533brassies
brisses94314313brisses
busses85023383_busses
bypassed1642713bypassed
byssus1133763by_ssus
byssuses1342273byssuses
camasses12388973camasses
carses85233653_carses
cases75048383_ca_ses
cashes114729883_cashes
cassis84818853_cassis
castes85631863_castes
causes88026473_causes
cayuses12188403cayuses
ceases84427073cea_ses
cerastes101111093cerastes
cesses84221363_cesses
chaises124317493chaises
chaoses124715123chaoses
chases115128233cha_ses
chasse115114603chasse_
chassed134712133chassed
chassis123910663chassis
chausses1345963chausses
chesses124112633chesses
clashes124017283clashes
classed104113653classed
classer93614613classer
classers104111833classers
classis93712723classis
clauses93813323clauses
crases85532313cra_ses
crashes124618403crashes
crasser94114343crasser
crassest103411523crassest
cresses94219813cresses
crevasses1444143crevasses
crosses94220793crosses
cuisses9319883cuisses
cusses84522773_cusses
cyanoses1337423cyanoses
cycases1437533cycases
cyeses11510123cy_eses
daises74318983_daises
dashes106124983_dashes
dassies84418663_dassies
deashes113313903deashes
debases103814133deba_ses
declasses1246443declasses
degases93413103dega_ses
degassed11275963degassed
degasser10325813degasser
degassers11354833degassers
degausses1143203degausses
detassel943653detassel
detassels1042673detassels
disses75225963_disses
dosses76126273_dosses
dresses83716173dresses
drosses84513823drosses
eagles73819163e_agles
eagres74014573e_agres
ease45042333e_a_se_
eased65430403e_a_sed
easel54521113e_a_sel
easels65914553e_asels
easier64218463e_asier
easiest72318773e_asiest
easter65027983e_aster
easters75125683e_asters
easts57530323e_a_sts
eaves85231993e_a_ves
ecartes94212563ecartes
ecdyses1333413ecdyses
ecesises1037023ecesises
ectases92911673ectases
effuses1335903effuses
egises7312493e_gises
egresses949443egresses
elapse857523elapse_
elapsed1056103elapsed
elastases946113elastases
elates65032363ela_tes
embassies1344003embassies
embosses1235963embosses
emdashes14224303emdashes
emeses86114963e_meses
enables92813123enables
enates64026433ena_tes
encases93116053encases
encashes13227673encashes
endashes12217453endashes
enisles72312603enisles
enosises8311003enosises
ensues63313813e_nsues
entases72816273entases
eposes84418783e_poses
erase54925493era_se_
erased74816753era_sed
eraser64216333era_ser
erasers74413943erasers
erasures837213erasures
eroses65327053e_roses
erses55826803e__rses
eses45336103e___ses
esnes54817363e__snes
etapes85415293eta_pes
ethoses10311763ethoses
evades1039023eva_des
evulses1035043evulses
excesses1736753excesses
excises1638933excises
excuses1638903excuses
expanses17156173expanses
exposes1639963exposes
eyas76427433eya___s
eyeglasses1442263eyeglasses
eyelashes1542853eyelashes
eyeless1058053eyeless
eyes75837883ey___es
eyesores1145113eyesores
eyewashes1842163eyewashes
eyres84921773ey__res
eyries93816813ey_ries
fasces114914543_fasces
fashes124524023_fashes
feases95422923fea_ses
fesses94820253_fesses
feynesses1535223feynesses
flashes133916103flashes
flosses103411973flosses
fosses96022083_fosses
fraises104215693fraises
fusses94920553_fusses
gases65633993_ga_ses
gashes105725153_gashes
gassed85217633_gassed
gasser75017773_gasser
gassers84714633_gassers
gausses8308693gausses
glassed93710433glassed
glassies94012273glassies
glosses84014123glosses
gnashes11419573gnashes
grassed93812793grassed
grosses84517683grosses
guesses8169373guesses
gypsies1335953gypsies
gyrases11368313gyrases
hanses95022633_hanses
harasses11311033harasses
hashes125024803_hashes
hassel95614213_hassel
hassels104311013_hassels
hassles103411693_hassles
hastes95727073_hastes
hawses125113993_hawses
hearses104414533hearses
hisses94719353_hisses
impasses12257523impasses
jesses135215953_jesses
josses135117683_josses
kavasses1544303kavasses
kisses104217333_kisses
kvases13467103kva_ses
kyanises15206393kyanises
lapses85217693_lapses
lases54944763_la_ses
lashes94831003_lashes
lassies74420103_lassies
lassis65216703_lassis
lassoes74613853_lassoes
lassos64913813_lassos
leases65428113lea_ses
leashes103514403leashes
liaises7311053liaises
loesses7310033loesses
losses65925233_losses
lyase85512413lya_se_
lysates10317473lysates
lyses84518253ly__ses
lyssas935443ly_ssas
manses84225513_manses
marses84827113_marses
mashes115030003_mashes
massas85116463_massas
masse75125293_masse_
massed94421323_massed
measles92412753measles
megasse10266243megasse_
messes84924343_messes
metisses1036833metisses
misses85130873_misses
molasses1037233molasses
morasses1038903morasses
mosses85527683_mosses
mousses94012703mousses
musses84624783_musses
myasis114010473mya_sis
mycoses1437733mycoses
myiases1235493myiases
myoses114013843my_oses
nesses64718323_nesses
oases55330983_oa_ses
parses85534703_parses
pases75346503_pa_ses
pashes115828393_pashes
passe75525693_passe_
passed94320943_passed
passee84522023_passee
passel85117003_passel
passels93913023_passels
passer84721033_passer
passers94717753_passers
passus83610293_passus
pastes85233913_pastes
pauses84621473_pauses
peases85229473pea_ses
pelisses1048483pelisses
petasoses1145443petasoses
petasuses1144373petasuses
phases114618403pha_ses
pisses84525083_pisses
plashes124417393plashes
plisses94411773plisses
plusses93510693plusses
posses85128803_posses
praises94121103praises
prases84429023pra_ses
presses93523153presses
prisses94816713prisses
prosses94019513prosses
pusses84322843_pusses
pyoses114314303py_oses
quashes192110973quashes
raises64826543_raises
rases55447213_ra_ses
rashes95330153_rashes
rassles73513923_rassles
reassess836513reassess
recesses10312323recesses
rehashes1436953rehashes
relapses1038033relapses
repassed11229273repassed
reraises8415643reraises
retastes82212903retastes
rewashes1447033rewashes
rubasses1035493rubasses
sashes94728483_sashes
sassed76116173_sassed
sassies74719263_sassies
sisses64520603_sisses
slashes103619103slashes
smashes123914613smashes
snashes105214753snashes
stases64225563sta_ses
stashes103916173stashes
strasses81311443strasses
susses64221053_susses
swashes134714403swashes
swisses10417143swisses
sycoses1249133sycoses
synapses1344713synapses
syngasses1343813syngasses
tasse54821843_tasse_
tassel66014773_tassel
tassels74510853_tassels
tasset65925313_tasset
tassets75012773_tassets
tassies74918933_tassies
tastes64126423_tastes
tawses94913193_tawses
teases65426273tea_ses
texases1437573texa_ses
tosses65225393_tosses
trashes104119263trashes
tresses73719543tresses
trusses73813643trusses
tusses64921243_tusses
ukases10358063uka_ses
upases84112903upa_ses
urases63723563ura_ses
valses94514613_valses
vases84626263_va_ses
vinasses1135703vinasses
washes124425493_washes
wastes96224883_wastes
wisses94619603_wisses
wrasse9398773wrasse_
wrassles11376713wrassles
wusses93314893_wusses
xyloses1746843xyloses
yeasted1138503yeasted
yeasts96413053yea_sts
yeses85119323_y_eses
yessed104511163_yessed
zebrasses2043513zebrasses
zygoses20436783zygoses
zymases21938333zymases
zymoses21608693zymoses

Search took 9 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.420425454.8
2DLD Change Limit1340273687.62617575.0
3Display Results3683680.2661383.5
 (SQL Overall)1786913688.31221498.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.