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

413 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
sermons931178(None) 
sermon8413551sermon_
demons94917722de_mons
fermions1336202fermions
germans1079472germans
germens1078632germens
herons94820542her_ons
lemons84415052le_mons
merlons93311272merlons
pereons92815002pereons
perrons93115482perrons
persons93717012persons
salmons93713262salmons
seasons72614232seasons
semens84616972se_mens
sereins73716122sereins
serins64029672ser_ins
serious73616282serious
sermonic1248882sermonic
serous65023562ser_ous
serows96016392ser_ows
servos93812722servo_s
setons64620172se_tons
sextons143710412sextons
spermous1247932spermous
summons1158002summons
termors94712772termors
aeons57624653ae__ons
aprons8316993apr_ons
argons75018203_argons
armors85017813_armors
arsons63917213_arsons
barons85025383bar_ons
baryons121010473baryons
beacons11410733beacons
beckons15279143beckons
belons84119413be_lons
bemoans1138253be_moans
berlins93216013berlins
bermes106023003berm_es
berming123614833berming
berms95323663berm__s
betons84919553be_tons
borons85520543bor_ons
burtons9310853burtons
carbons115418943carbons
cardons104519943cardons
cartons94122473cartons
ceremony1544313ceremony
cermets1139713cermets
ceros74726073cer_o_s
cerous85821203cer_ous
cerumens1235763cerumens
commons13311043commons
cordons104415763cordons
cormous11312353cormous
crepons1139323crepons
croons85418423_croons
daemons10269233daemons
daimons10249323daimons
deacons10310393deacons
demobs11429483de_mobs
demon86520313de_mon_
demos86022993de_mo_s
dermas94116813derm_as
dermis94717163derm_is
dermoid1138523dermoid
dermoids1246163dermoids
derms85022893derm__s
desmans1039003desmans
devons104512253de_vons
dormins10311273dormins
dromons1038193dromons
durions839963durions
ebons74316093_e_bons
eikons1038503_eikons
eons46638713_e__ons
ergots74512373_ergots
ermine8416923_ermine
ermines9416673_ermines
erns45428233_er__ns
eros45238453_er_o_s
errors63311313_errors
etymons1244153etymons
exons125813343_e_xons
felons93615763fe_lons
ferment12315573ferment
ferments13311473ferments
fermion1236763fermion_
fermis114313503ferm_is
ferns85220083fer__ns
ferrous1049803ferrous
fervors1336233fervors
firmans12238523firmans
formols12299413formols
frons86124043_fr_ons
gammons1237973gammons
garcons102411643garcons
garrons82713463garrons
gemots93712153ge_mots
german9611983german_
germane1049663germane
germen9612313germen_
germina1038503germina
germs85118873germ__s
girons75014373gir_ons
gnomons1035753gnomons
gorgons938853gorgons
guerdons1044233guerdons
gyrons105511223gyr_ons
harmins123716723harmins
harmony1538173harmony
hegemons1444893hegemons
hemins113417573he_mins
hereon93914363hereon_
heriots10312063heriots
hermits12312143hermits
herms105626433herm__s
herns84825583her__ns
heroes94923823her_oes
heroins103518013heroins
heron85025503her_on_
heros84930863her_o_s
hetmans12187593hetmans
hormone12410503hormone
hormones13311163hormones
irons55324133_ir_ons
jargons1558203jargons
jerboas1636163jerboas
jerkins18358253jerkins
jetons134512613je_tons
jettons1437273jettons
kelsons1137323kelsons
kermes124616133kerm_es
kermess13396223kermess
kermis124012393kerm_is
kerns94719563ker__ns
kroons103711243_kroons
lardons83914493lardons
legions84611783legions
lemans85316393le_mans
lemon75618183le_mon_
lemony11419553le_mony
leptons91910433leptons
lesions73813873lesions
lessons73811023lessons
leukons1135753leukons
mammons1048513mammons
marmots11311513marmots
maroons92615553maroons
marrons93216973marrons
melons84117713me_lons
meltons9410923meltons
memos95719113me_mo_s
merinos9311983merinos
merlins93015813merlins
merlon83012353merlon_
merlots92710123merlots
merman10513863merman_
mermen10813813mermen_
mesons83215843me_sons
mons68152263___mons
morions94014643morions
morons84919543mor_ons
nektons1136393nektons
nelsons738003nelsons
neocons936913neocons
neons55818683ne__ons
nerols6914883ner_ols
nervous1037143nervous
neurons7410443neurons
newtons1036813newtons
operons91411743oper_ons
orlons6411013_orlons
overmans13310313overmans
pardons103817623pardons
parsons93516873parsons
partons94620513partons
pennons939713pennons
peons75327183pe__ons
pereions10310853pereions
pereon83517453pereon_
perigons11310083perigons
periods10312243periods
perming123416093perming
permits11314003permits
perms95524513perm__s
pernods1038483pernods
perron83216623perron_
person83517873person_
persona92812453persona
personas102511883personas
prions84317783_prions
psammons1442783psammons
reasons72514943reasons
reckons13269653reckons
recons84922993re_cons
redons75222183re_dons
regions83613473regions
remans84823003re_mans
reroofs1037943reroofs
reruns66413743rer_uns
saimins9312113saimins
salmon84614183salmon_
salons63823693s_alons
saloons74415323saloons
sarans64224433sar_ans
sarcous9312933sarcous
sargos74318273sargo_s
sarins63932623sar_ins
sarment9318763sarment
sarments10311963sarments
sarods74918573sar_ods
sarong73914873sar_ong
sarongs84511803sar_ongs
saros55238063sar_o_s
sarsens7311393sarsens
sartors7314973sartors
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153schmo_s
scions82612243s_cions
screens95212183screens
scrods94111613scr_ods
scroops11288253scroops
seadogs958643seadogs
seaman84015903seaman_
seamen84518563seamen_
seamers94719433seamers
seaming103222113seaming
seamount1047923seamount
seamounts1143683seamounts
seams75731663seam__s
season62714903season_
seawans10379943seawans
seccos1039923secco_s
secerns987733secerns
second9411153se_cond
seconds1038283se_conds
sections102714703sections
sectors93116453sectors
sedans74816093se_dans
seemers93814333seemers
seeming103216263seeming
seemings11337643seemings
seems75525023seem__s
segment10312563segment
segments1138903segments
segnos73610443segno_s
segos64919483se_go_s
seisins73614393seisins
seisors73212843seisors
seitans73312303seitans
seizins164010133seizins
seizors16329013seizors
selsyns1092943selsyns
semen75724103se_men_
semes75731583se_m_es
semina8915573se_mina
semis74623533se_m_is
senhors103512133senhors
seniors73413623seniors
senors63620793se_nors
sensors73514643sensors
sepoys1138473se_poys
sequins1637863sequins
seracs84418573ser_acs
serails73318363serails
serais64326133ser_ais
serapes95218103serapes
seraphs12408093seraphs
serdabs1035323serdabs
serein63318463serein_
serene63522353ser_ene
serenes73222903serenes
seres55448893ser__es
serfdoms1443763serfdoms
serfs84922013ser__fs
sergers83815633sergers
serges74225973ser_ges
serging93416673serging
sergings10299213sergings
serials73919743serials
sericins10312463sericins
series64540973ser_ies
serifs94017053ser_ifs
serin55434443ser_in_
serine65432673ser_ine
serines74229543serines
sering74731813ser_ing
sermonize20148483sermonize
sermonizes21148363sermonizes
serosa6313023ser_osa
serosas7312663serosas
serow86720443ser_o_w
serpent92916283serpent
serpents102410373serpents
serrano768463serrano
serranos857873serranos
serries73925353serries
sers45746653ser___s
serums83916303ser_ums
servals103410743servals
servant10313633servant
servants1138003servants
servers103214833servers
serves94423653ser_ves
serving113014983serving
servings12249223servings
servo84516683servo__
sessions839723sessions
seton55223543se_ton_
setous64917373se_tous
sevens93813663se_vens
sewans95215903se_wans
sexpots1636293sexpots
sextans14349263sextans
sexton133610793sexton_
sextos134012163sexto_s
shamans123610903shamans
shamois123210423shamois
shamos114216983shamo_s
shamoys15367283shamoys
sheroots1137863sheroots
shmoes114612103s_hmoes
siemens938413siemens
simony1137903s_imony
simoons937943simoons
siphons1239353siphons
sirens65318153sir_ens
sirloins836723sirloins
sixmos1534813sixmo_s
skimos12548803skimo_s
smogs85112163s__mogs
solions7513753solions
solons65120023s_olons
somans84619303s_omans
somoni8310743s_omoni
sons46049553s___ons
sordors8310013sordors
sorgos74514663sorgo_s
sorns55028423sor__ns
sorrows10278403sorrows
spermine12311433spermine
spermines13310543spermines
sperms102512603sperm__s
spoons84116023s_poons
sprains93013593sprains
spumone1154383spumone
spumones1254953spumones
spumoni1173453spumoni
spumonis1264113spumonis
spumous1135853spumous
stamens93411483stamens
stemsons1045003stemsons
stepsons1045663stepsons
stereos74314973stereo_s
sterns64616763ster__ns
sternsons944663sternsons
sterols7313443ster_ols
stertors8310933stertors
stetsons845623stetsons
stolons73410243stolons
strains74218153strains
stramony1344933stramony
strong74914883str_ong
strops86220383str_ops
strows96718273str_ows
stroys95914603str_oys
strumous1045733strumous
summon1037623summon_
sumos75720093s_umo_s
supermoms1547303supermoms
surgeons947033surgeons
surmount1045903surmount
surmounts1143443surmounts
swoons94511143s_woons
syphons1537503syphons
syrens94911993syr_ens
tarpons92612213tarpons
teflons1036543teflons
telsons739223telsons
tendons8311473tendons
tenons62916603te_nons
termers95414503termers
terming104016003terming
termini93410813termini
terminus1037393terminus
termor84412513termo_r
terms75523473term__s
ternions838813ternions
terns55226873ter__ns
terrors73112213terrors
testons7313563testons
thermions1445333thermions
thermos124610753thermo_s
tremors93711233tremors
turions7311573turions
turnons737863turnons
verdins112812333verdins
vermes115019143verm_es
vermin113414523vermin_
vermis114214963verm_is
versions11310353versions
versos93812803verso_s
virions1039873virions
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
xenons132710483xe_nons
zeroes154314343zer_oes
zeros144918113zer_o_s
zircons1854963zircons

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.403443402.0
2DLD Change Limit1340274137.67317467.4
3Display Results4134130.1402950.0
 (SQL Overall)1786914138.21621749.1
 
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.