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 “mezes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

193 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
mezes16771926(None) 
fezes175220021fezes
mazes165632171mazes
memes94927701memes
meres75143571meres
metes74736211metes
meze154420901meze_
adzes155913802adzes
aedes64625142aedes
amazes175613472amazes
bees65453382be_es
benes75536232benes
beses75830722beses
bezel165215172bezel
bezels173712282bezels
bizes165923662bizes
cedes84927322cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
cozes166033242cozes
dazes155024142dazes
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
dozes155226302dozes
ekes86726602_ekes
emes65434662_emes
emeses86114962emeses
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
fazes175527212fazes
feazes184514172feazes
feces105625362feces
fees76450602fe_es
feezes184412612feezes
femes105626222femes
feres86038182feres
fetes85630142fetes
fezzes174910402fezzes
fuzes175120222fuzes
gazes155425912gazes
gees55647882ge_es
genes65133092genes
hazes174928322hazes
hebes105521672hebes
heezes184211642heezes
hemes105031082hemes
heres86245902heres
hexes155123042hexes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
kexes166216812kexes
lazes145129572lazes
lees45455882le_es
leges64427282leges
lenes54738522lenes
leses54930812leses
lexes127225262lexes
lezzes14387832lezzes
mabes96331532mabes
maces97139962maces
maes66948402m_aes
mages85036022mages
maizes175115732maizes
makes115336852makes
males75049792males
manes76648962manes
mares76457632mares
mates75251362mates
maxes145629532maxes
maze155434982maze_
mazed175523872mazed
mazer165722422mazer
mazers173917092mazers
meads85425322meads
meals75933372meals
means75831232means
meats75034052meats
meds75735362me_ds
meed74934702me_ed
meeds84920272meeds
meek105624832me_ek
meet65350552me_et
meets74224612meets
megs75530632me_gs
melds84822382melds
melee73729102melee
melees83618082melees
mells75031332mells
mels65941532me_ls
melts74930102melts
meme85330552meme_
memos95719112memos
mems85931502me_ms
mends84927692mends
mense75025632mense
menses84222452menses
menus75822842menus
meous76120062meous
meows104612682meows
merces105720742merces
mercs96020452mercs
merdes94518602merdes
mere67244442mere_
merer75126232merer
merest84725112merest
merges94122482merges
merks114722402merks
merles85322762merles
merls77423902merls
mesas76823202mesas
meshes115019442meshes
mesnes85216212mesnes
mess65932432me_ss
messes84924342messes
mete64438132mete_
meted85424432meted
meter75130322meter
meters85625832meters
meths105320232meths
metis75025902metis
metres85121562metres
mewed115218012mewed
mewls105813232mewls
mews96629332me_ws
mezzo1537432mezzo
mezzos1635052mezzos
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
mizen164815272mizen
mizens174610252mizens
modes85537412modes
mokes114631032mokes
moles74747922moles
momes95134472momes
mopes95134982mopes
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
mozos165516332mozos
mules75034292mules
mures75937212mures
muses75134302muses
mutes75033782mutes
nenes55329672nenes
neves87021872neves
oozes145418712oozes
oyezes1835052oyezes
pedes85327282pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
prezes173614692prezes
razes145032702razes
redes65139122redes
rees45364192re_es
reges65628782reges
rexes124526952rexes
sees45361052se_es
seizes154317532seizes
semes75731582semes
seres55448892seres
sexes126126222sexes
sizes146727762sizes
smazes174311662smazes
tees45353582te_es
teles54536002teles
tmeses85712242tmeses
vees75439432ve_es
veges94118862veges
vexes155719122vexes
wees76249122we_es
wizes174723342wizes
yeses85119322yeses
zees136331892ze_es

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001932.43622085.4
3Display Results1931930.423456.3
 (SQL Overall)1786911932.95260532.2
 
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.