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

492 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
sesames931074(None) 
sesame8311011sesame_
benames112814602benames
beshames1537202beshames
defames132812252defames
degames113312622degames
mesdames1346042mesdames
pesades10310892pesades
renames92418052renames
resales74724902resales
resumes9313372resumes
seamed94823882se_amed
seamen84518562se_amen
seamer84223612se_amer
seamers94719432se_amers
seams75731662se_am_s
sedates83418032sedates
sememes11109202sememes
semes75731582se__mes
senates73322582senates
sensates8511132sensates
serapes95218102serapes
sewages1139752sewages
shames114726222s_hames
aerates74627483aerates
amesaces1246693amesaces
arames84622573_arames
assumes967163assumes
beamed115720733be_amed
beams95328173be_am_s
became123213163became_
becomes132911963becomes
bedamns1235733bedamns
begazes1937963begazes
behaves15198523behaves
beldames1336803beldames
bename103316073bename_
benamed122911093benamed
berakes134815773berakes
berates94126853berates
berimes115216643berimes
bermes106023003be_rmes
beseems1175913beseems
beses75830723bes__es
beshame1447483beshame_
beshamed1635733beshamed
besides104814533besides
beslimes1246953beslimes
besoms105712733besom_s
betakes134212523betakes
betimes115114413betimes
bewares12313373bewares
blames105121863_blames
bynames14256243bynames
cames97047313__cames
ceases84427073ce_ases
cerates95428233cerates
cesses84221363ces_ses
cetanes9315133cetanes
dames85435853__dames
deashes113313903deashes
deaves105319533de_aves
debases103814133debases
debates103718523debates
decades113615503decades
decamps1435643decamps
decanes103118913decanes
decares102818533decares
defaces133213403defaces
defame123212433defame_
defamed14309833defamed
defamer132710323defamer
defamers14258523defamers
degame102713183degame_
degamis11268433degamis
degases93413103degases
dekares122710873dekares
delates83526283delates
delimes10314193delimes
demes86032693de__mes
derates84028883derates
desalts839573desalts
desands94810163desands
desexes1537833desexes
desires81316133desires
deskmen1435023deskmen
desmans1039003desmans
dewaxes18297843dewaxes
dismes95617673dis_mes
dosages92310803dosages
eases56041613_e_ases
easies64126633_easies
eaves85231993_e_aves
elates65032363_elates
emes65434663_e__mes
enamel81210113_enamel
enamels9128163_enamels
enates64026423_enates
erases64425403_erases
escapes113811673escapes
eses45336103_es__es
esnes54817363_es_nes
espies83716803_espies
essayed1134013essayed
essayer1033943essayer
essayers1133563essayers
essays965653essa_ys
esses56422973_es_ses
estates74520173estates
etapes85415293_etapes
evades1039023_evades
examen1538283_examen
examens1637193_examens
exams14199083_exam_s
eyases94513683_eyases
fames105735923__fames
feases95422923fe_ases
feazes184514173fe_azes
females12310663females
femes105626223fe__mes
femmes135410213fe_mmes
fescues1236783fescues
fesses94820253fes_ses
flames114723693_flames
frames115119863_frames
games86238553__games
gelates83219583gelates
genomes103611703genomes
gessoes838293gessoes
gestates93213723gestates
gestes75721393ges_tes
gisarmes1144433gisarmes
hames106138703__hames
heaumes1237423heaumes
heaves124120303he_aves
hemes105031083he__mes
hexades18378703hexades
hexanes17319463hexanes
jesses135215953jes_ses
jetsams16124103jetsam_s
kames115024693__kames
kermes124616123ke_rmes
lames75445543__lames
leases65428113le_ases
leashes103514403leashes
leaves94222383le_aves
legates82917673legates
legumes1036633legumes
leses54930813les__es
lessees73510243lessees
lexemes1635673lexemes
lysates10317473lysates
madames12310063madames
measles92412753measles
melamed1249633melamed
memes94927703me__mes
menaces112715523menaces
menages103615393menages
mesas76823203mesa__s
meseems1165603meseems
meshes115019443mes_hes
mesnes85216213mes_nes
messages1138233messages
messes84924343mes_ses
messmen1137393messmen
mestees94617753mestees
metages102714973metages
metamer1139613metamer
metamers1249623metamers
metates92720003metates
misnames12119883misnames
names74833363__names
negates83215833negates
nesses64718323nes_ses
nestles73015463nestles
neumes83112623ne_umes
peaces106324083pe_aces
peages94321843pe_ages
peases85229473pe_ases
pelages10714613pelages
penates93321593penates
pennames12287783pennames
pesade9311103pesade_
pestles93217693pestles
pregames1339003pregames
prenames12311633prenames
presages11312203presages
presales10315263presales
presumes1239843presumes
reales64934123re_ales
reamed94326123re_amed
reamer84325213re_amer
reamers94221083re_amers
reams75729623re_am_s
reaves94127573re_aves
rebates95123173rebates
recanes93222263recanes
reclames12310893reclames
redates83423863redates
refaces123216743refaces
reframes1338983reframes
regales83520793regales
regimes104514743regimes
relaces93420883relaces
relates73731423relates
relaxes143215323relaxes
relumes9612513relumes
remakes134116173remakes
remates93827103remates
rename82718813rename_
renamed103114523renamed
repaves123513653repaves
resails74616743resails
resale64025543resale_
resamples1344713resamples
resawed113111183resawed
resaws93713513resa_ws
resays93714153resa_ys
rescales103414563rescales
rescues9312753rescues
resees63827483res_ees
reshapes1338803reshapes
reshaves1438733reshaves
reshes94124363res_hes
reshoes102316033reshoes
resides84523283resides
resiles74026543resiles
resites74027793resites
resizes164216843resizes
reslates83619493reslates
resoles73823653resoles
respaces12311043respaces
respades1139853respades
restages92815763restages
restamps1234703restamps
restates83423413restates
resume8313783resume_
resumed10310623resumed
resumer9410113resumer
resumers1038083resumers
retakes113718863retakes
retapes93917423retapes
retaxes143615093retaxes
retimes95020173retimes
revamps1433993revamps
rewakes144614983rewakes
rewaxes173911333rewaxes
sabes76437463__sabes
sades65239893__sades
safes85226723__safes
sagamen10127503sagamen
sages65339063__sages
sakes95540753__sakes
salamis9313513salamis
sales56055593__sales
same65245643__same_
samek114915273__samek
sameks12409323__sameks
samps96124673__samps
sanes55649073__sanes
sarapes94617743sarapes
sashes94728483sas_hes
sasses64124393sas_ses
sassies74719263sassies
sates54949323__sates
sausages937003sausages
savages1139973savages
savates10312953savates
saves85838633__saves
saxes125229343__saxes
scales84529313s_cales
scamps125014173s_camps
scams94423973s_cam_s
scapes105122263s_capes
scares85033003s_cares
schemes1489663schemes
scrams105216623scram_s
scrapes116217663scrapes
seabed95017693se_abed
seabeds10417223se_abeds
sealed74328363se_aled
sealer63928963se_aler
sealers74323553se_alers
seals54839693se_a_ls
seam66645973se_am__
seaman84015903se_aman
seamier93114633se_amier
seamiest102715413se_amiest
seamless10238723se_amless
seamy105921273se_am_y
seances93015343seances
seared75232843se_ared
searer65432023se_arer
searest73322023se_arest
sears54744913se_a_rs
seas45755273se_a__s
seascapes1344813seascapes
seasides938743seasides
seasons72614233seasons
seated75131053se_ated
seater64534153se_ater
seaters74028933se_aters
seats54844343se_a_ts
seawares1139333seawares
sebums10369813sebum_s
secants93413893secants
secedes103711983secedes
secures9613163secures
sedans74816093seda_ns
sedate73019803sedate_
sedated93714343sedated
sedater83713623sedater
sedatest9249393sedatest
sedges83817793se_dges
seduces1069283seduces
sedums93910483sedum_s
seedmen1037683seedmen
seemed95117613se_emed
seemer84418043se_emer
seemers93814333se_emers
seems75525023se_em_s
seepages1137283seepages
sees45361053se___es
seesawed1243293seesawed
seesaws1034703seesa_ws
seethes103613743seethes
segues7412073se_gues
seiches12513813seiches
seines65029903se_ines
seises64026713se_ises
seisms84912143seism_s
seisures838273seisures
seizes154317533se_izes
selahs9313213sela_hs
selfsame1342883selfsame_
selkies113513353selkies
selles64426983se_lles
selvages1236513selvages
selves94119613se_lves
seme65836653se__me_
sememe10129983sememe_
semen75724103se__men
semens84616963se__mens
semis74623533se__mis
semises93916553semises
senate63725143senate_
seniles72618023seniles
senores73218113senores
sensate7311883sensate_
sensated938183sensated
senses63923943se_nses
sepaled10510593sepaled
sepals85217373sepa_ls
sepses84515883se_pses
septages1168263septages
septimes1238293septimes
seracs84418573sera_cs
serails73318363serails
serais64326133sera_is
serape84818413serape_
seraphs12408093seraphs
serenes73222903serenes
seres55448893se__res
serfages1238233serfages
serges74225963se_rges
seriates82620663seriates
series64540973se_ries
serines74229543serines
serrates82617003serrates
serries73925353serries
serums83916303serum_s
serves94423653se_rves
sesamoid1144053sesamoid
sesamoids1243053sesamoids
sestet6826203ses_tet
sestets7911473sestets
sestines82717243sestines
setae56026223seta_e_
settees73513633settees
settles73916003settles
sewage10310733sewage_
sewans95215903sewa_ns
sewars94018623sewa_rs
sexes126126223se__xes
shades105924533s_hades
shakes135024593s_hakes
shales94731253s_hales
shamas113717933s_hamas
shame105726703s_hame_
shamed125120213s_hamed
shammes144312833shammes
shamos114216983s_hamos
shams105829413s_ham_s
shamus114112813s_hamus
shapes115124943s_hapes
shares95236413s_hares
shaves125224933s_haves
sheaves134412973sheaves
siamese936503s_iamese
silages82514443silages
silanes72517163silanes
sisals63013573sisa_ls
sises55233833sis__es
sisses64520603sis_ses
sissies73716603sissies
skates104219393s_kates
skeanes113610713skeanes
slakes104021883s_lakes
slams74927903s_lam_s
slashes103619103slashes
slates64934063s_lates
slaves95023023s_laves
sleaves103813203sleaves
sleazes162810333sleazes
slimes84722043s_limes
smashes123914613smashes
smazes174311663s_mazes
snakes103919603s_nakes
snares65329033s_nares
snashes105214753snashes
soaves94218673s_oaves
socages101012053socages
solaces93116133solaces
solates73523853solates
spaces104722633s_paces
spades94222583s_pades
spaes76029973s_pa_es
spales84728103s_pales
spams94922193s_pam_s
spares84834553s_pares
spasmed12296993spasmed
spasms10418973spasm_s
spates85028173s_pates
splakes1349673splakes
spumes1021314883s_pumes
squares163714453squares
stades74626243s_tades
stages75629493s_tages
stakes103927293s_takes
stales65538293s_tales
stamen84115943s_tamen
stamens93411483s_tamens
stamps105614023s_tamps
stanes64933403s_tanes
stapes85028733s_tapes
stares66038753s_tares
stases64225563s_tases
stashes103916163stashes
states64337083s_tates
staves94525193s_taves
steamed103712143steamed
steamer93313093steamer
steamers103410873steamers
steams84916903steam_s
stepdames1443333stepdames
stimes85920573s_times
strafes104515993strafes
strakes114218073strakes
subsales10310123subsales
subsumes1246923subsumes
surnames1037273surnames
susses64221053sus_ses
swages104417073s_wages
swales93920763s_wales
swamies123712063s_wamies
swamis114212293s_wamis
swamps135910263s_wamps
swashes134714403swashes
systems1234673systems
tames75242013__tames
teamed95418593te_amed
teams75726513te_am_s
teases65426273te_ases
telomes9310533telomes
tenaces92814513tenaces
testates83615443testates
testees74215913testees
testes65125823tes_tes
texases1437573texases
tisanes7311853tisanes
tsades74310993_tsades
usages759603_usages
usernames1142373usernames
velamen1237123velamen
vermes115019143ve_rmes
vestees103513163vestees
visages1138693visages
wakames1635283wakames
wames106432803__wames
weaves123616373we_aves
yeses85119323yes__es
yesses93615813yes_ses

Search took 8 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.1431249587.4
2DLD Change Limit1340274927.29618369.9
3Display Results4924920.1702894.1
 (SQL Overall)1786914927.60923484.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.