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

206 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
mayhems176341(None) 
maihems1444301maihems
mayhem1644921mayhem_
maches134827232mache_s
maihem1366212maihem_
mashers124621052mashers
mashes115030002mashe_s
maybes1339242maybe_s
sachems14348902sachems
aches106132293_ache_s
adeems946333_adeems
ahem97225363_a_hem_
amylums1473613amylums
anthems12309423anthems
ashes86230613_ashe_s
ayes76543513_ay_e_s
baches135426943bache_s
bashers124820833bashers
bashes115631393bashe_s
bathers124720363bathers
bathes116524833bathe_s
caches137926913cache_s
cachets145014263cachets
cashes114729883cashe_s
cashews15428603cashews
dashers115016863dashers
dashes106124983dashe_s
daybeds14234473daybeds
fashes124524023fashe_s
fathers133916503fathers
fathoms1537523fathoms
gashes105725153gashe_s
gathers114315073gathers
gayness1136843gayness
haems105517013ha__ems
hakeems16394803hakeems
hareems12428203hareems
harems115513823ha_rems
hashes125024803hashe_s
hayers124415943hay_ers
hems95534943___hems
jaygees1854513jaygees
jayvees2052923jayvees
kashers143914023kashers
kayles134712003kayle_s
kayoes134710823kayoe_s
laches116528343lache_s
lashers104121833lashers
lashes94831003lashe_s
lathers104321883lathers
lathes95127493lathe_s
layers93921183lay_ers
mabes96331533ma_be_s
macers105321273ma_cers
maces97139963ma_ce_s
mache125925303mache__
machete14310883machete
machetes1539633machetes
machos135217493mach_os
machrees1545503machrees
machs125722563mach__s
macles107023223macle_s
madames12310063madames
madams11310943ma_dams
maddens11359753maddens
madders113513213madders
madness10310073madness
madres93718183madre_s
madtoms1236923madtoms
maes66948403ma__e_s
mages85036023ma_ge_s
maglevs1334693maglevs
magnets10311143magnets
magnums1234683magnums
magueys1333943magueys
mahoes11313103ma_hoes
maidens10349663maidens
mailers94420333mailers
mailes84329113maile_s
maimers113813043maimers
maims96321793ma__ims
maizes175115733maize_s
makers123921733ma_kers
makes115336853ma_ke_s
males75049793ma_le_s
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
malms95021553ma__lms
malteds10377603malteds
mameys13449523ma_meys
mamies104626243mamie_s
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mamzers20409163mamzers
manches143818623manche_s
manchets15269573manchets
manes76648963ma_ne_s
mangels103614493mangels
mangers103521263mangers
manges94628943mange_s
manless93012933manless
manners93417833manners
manses84225513manse_s
mantels94515043mantels
mantes84430783mante_s
maples104819423maple_s
mappers133313783mappers
marcels113212373marcels
marchers153710813marchers
marches143921173marche_s
mares76457633ma_re_s
marges94525713marge_s
markers133516103markers
markets133314033markets
marrams11310123marrams
marrers93414313marrers
marses84827113marse_s
marshes123615373marshe_s
martens93714953martens
marvels123810093marvels
masers84623453ma_sers
mashed125325043mashe_d
masher114123203mashe_r
mashies12318253mashies
maskegs14375413maskegs
maskers133913843maskers
masses85028713masse_s
masters94628923masters
matchers153012433matchers
matches143219783matche_s
maters85032393ma_ters
mates75251363ma_te_s
mateys115610943ma_teys
maths105624023math__s
matless93014043matless
matres84522233matre_s
matters94421753matters
mattes85624533matte_s
maulers94213303maulers
maumets11369693maumets
mauves113811553mauve_s
mavens114312973ma_vens
mavies114923193mavie_s
maxes145629533ma_xe_s
maxims17399673ma_xims
mayas105924383may__as
maybe12311133maybe__
maydays1634493maydays
mayed115522403may_e_d
mayest114614793may_est
mayhap1635233mayh_ap
mayings134410513mayings
mayoress1344383mayoress
mayors115714193may_ors
mayos105521933may__os
maypops16104453maypops
mays96940033may___s
mayvins1535323mayvins
mayweed1634163mayweed
mayweeds1742993mayweeds
mazers173917093ma_zers
mazes165632173ma_ze_s
mems85931503m___ems
meseems1165603meseems
meshes115019443meshe_s
miches134320733miche_s
mithers123516733mithers
modems114610763m_odems
mohels115011323m_ohels
moshers124017843moshers
moshes115222873moshe_s
mothers123717623mothers
muches134718993muche_s
mudhens1335103mudhens
mushers124016443mushers
mushes114124563mushe_s
myases113711553myase_s
naches114622413nache_s
pashes115828393pashe_s
payees114812903pay_ees
payers114621823pay_ers
paynims1434973paynims
rachets124516833rachets
raphes115117453raphe_s
rashers104020913rashers
rashes95330153rashe_s
rayless10239003rayless
rehems113410983_rehems
sachem134012223sachem_
sachets123914103sachets
sadhes104715373sadhe_s
sashes94728483sashe_s
sayeds10469253say_eds
sayers94221593say_ers
smashers13339593smashers
smashes123914613smashe_s
taches114224173tache_s
tandems1037633tandems
washers134517523washers
washes124425493washe_s
wayless13308243wayless
xylems1833203_xylems
ylems1039263__ylems

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.420425454.8
2DLD Change Limit1340272067.20318607.1
3Display Results2062060.1101872.7
 (SQL Overall)1786912067.73323107.6
 
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.