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

354 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
mere6724444(None) 
cere66741471cere
dere56845901dere
ere36352771_ere
fere76342231fere
here76447101here
mare64759331mare
meme85330551meme
merc87225621merc
merde84320121merde
merer75126231merer
meres75143571meres
merge84523691merge
merk106027941merk
merl65830971merl
merle75824371merle
mete64438131mete
metre74821301metre
meze154420901meze
mire66748231mire
more67154521more
mure65941331mure
pere66450261pere
sere46153471sere
were76238331were
acre67330772acre
aerie54634602aerie
aero45435342aero
aery77231682aery
ameer75618982ameer
amerce10310512amerce
ampere10514412ampere
are37874572_are
bare65460522bare
bee56262402be_e
beer65635992beer
bene66439492bene
beret74946362beret
berg75425542berg
berk105929842berk
berm86732752berm
berme96022942berme
bore66051332bore
bree67241262bree
byre95023852byre
care66968372care
cede74928772cede
cee55952702ce_e
cepe84926652cepe
cered85227442cered
ceres75540012ceres
cero66329452cero
cete64934782cete
cire65836372cire
core67263112core
cure66149122cure
dare55848862dare
dee47665822de_e
deer56739022deer
deke95228762deke
dele56843082dele
deme76536282deme
dene56643412dene
derm76031892derm
dire56644142dire
dore56353302dore
dree56638322dree
dure56341812dure
eerie55228532eerie
eery76129622eery
eke75630092_eke
eme55837182_eme
emeer74815362emeer
emerge91510462emerge
emery104814332emery
er28345142_er_
era35741502_era
erg45531072_erg
ern35738362_ern
erne46727432_erne
err35626532_err
ers36046282_ers
eve66331162_eve
ewe66630982_ewe
eye65539772_eye
eyre75525252eyre
fare76354462fare
fee66862012fe_e
feme96130542feme
fer66646122fer_
feres86038182feres
fern76129322fern
fete75734922fete
fire76245592fire
fore78351472fore
free75940182free
frere85617722frere
gee45359202ge_e
gene56237222gene
genre66016802genre
germ75428962germ
gore55744962gore
gree56641562gree
gyre84722762gyre
hare76255732hare
hebe96424702hebe
heme95034412heme
her66547812her_
herb94730962herb
herd84933062herd
heres86245902heres
herl75834552herl
herm95636152herm
hern76134892hern
hero74635782hero
hers75844872hers
hire75538962hire
ire36943172_ire
jee106648642je_e
jeer115426462jeer
jefe146516882jefe
jerk154920132jerk
jete115927252jete
kerb104322712kerb
kerf115827462kerf
kern85326212kern
kerne94718222kerne
kore85834162kore
lee36068142le_e
leer46239352leer
leke85527402leke
lire47845292lire
lore45850352lore
lure45142462lure
lyre75623792lyre
mabe85733362mabe
mace87345792mace
made75440242made
madre85720172madre
mae57659112m_ae
mage75739132mage
make105537892make
male66052302male
mane65052032mane
mar57965952mar_
mara67444572mara
marc87034632marc
mares76457632mares
marge85328332marge
mark105138062mark
marl66341622marl
mars66261872mars
marse76231152marse
mart66865982mart
mate65154222mate
maze155434982maze
me47748332m__e
mead75531602mead
meagre9349322meagre
meal65643172meal
mean65538092mean
meat66359602meat
med66146742me_d
meds75735362meds
meed74934702meed
meek105624832meek
meet65350552meet
meg66040952me_g
mega77620872mega
megs75530632megs
mel56047482me_l
meld75830472meld
melee73729102melee
mell64935612mell
mels65941532mels
melt65752892melt
mem77943472me_m
memes94927702memes
memo85924792memo
mems85931502mems
men59252852me_n
mend75334032mend
meno66031362meno
mense75025632mense
menu65130232menu
meou65325862meou
meow95117882meow
mercer105214202mercer
merces105720742merces
merch125417962merch
mercs96020452mercs
mercy125916182mercy
merdes94518602merdes
merely111312592merely
merest84725112merest
merged104214952merged
mergee94018142mergee
merger95016482merger
merges94122492merges
merit7339182merit
merks114722402merks
merles85322762merles
merls77423902merls
mermen10813812mermen
merry104721482merry
mesa67025482mesa
mesh96823002mesh
mesne75116292mesne
mess65932432mess
met56072432me_t
meta65932412meta
meted85424432meted
meter75130322meter
metes74736212metes
meth95827842meth
metred95315142metred
metres85121562metres
metro74718802metro
mew86137732me_w
mewed115218012mewed
mewl95618322mewl
mews96629332mews
mezes167719262mezes
mice87442232mice
mike105535292mike
mile66352572mile
mime85736402mime
mine67256172mine
mir57046772mir_
mired85729222mired
mires75640882mires
mirex146816622mirex
miri66730372miri
mirk106729502mirk
mirs66940572mirs
miry96326752miry
mise66043582mise
mite66249412mite
mitre75522422mitre
mode75840302mode
moire71017322moire
moke106234222moke
mole66251832mole
mome85239352mome
mope86838042mope
mor56855002mor_
mora66641272mora
morae75831192morae
morel75729092morel
mores76249642mores
morn66237562morn
mors65950062mors
morse76032702morse
mort66758832mort
mote67048082mote
moue65835572moue
move96630722move
mule65236972mule
mura65633302mura
mured85726702mured
mures75937222mures
murex145517172murex
murk105527252murk
murr65225132murr
murre74821072murre
muse67136032muse
mute65136872mute
nee36657782ne_e
nene45932062nene
nerd56624942nerd
nerve86617372nerve
neve76224832neve
ogre56320742ogre
ombre94111802ombre
omer67028392omer_
omers76923192omers
ore36661832_ore
pare66760842pare
pee56066512pe_e
peer66238352peer
peke105926202peke
pele65539552pele
per56353092per_
perea75026442perea
peres76246642peres
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
perse75429522perse
pert66759322pert
perv97224812perv
pore66451262pore
pree67044732pree
pure65543332pure
pyre94925552pyre
rare45348432rare
re26153742__re
rede55037672rede
ree37974072re_e
rete44944132rete
see35772262se_e
seer45547042seer
seme65836652seme
sene46848052sene
ser36752402ser_
sera46141392sera
sered65737292sered
serer55935512serer
seres55448892seres
serf76340112serf
serge64727472serge
sers45746652sers
serve85425962serve
sire46150412sire
smerk115412722smerk
sore47059532sore
stere55328542stere
sure45447412sure
tare45957622tare
tee38366872te_e
tele45040872tele
terce75721842terce
term66233152term
tern46134802tern
terne56426152terne
terse55026822terse
there87527392there
tire46143352tire
tore47359322tore
tree47745812tree
tyre75428252tyre
vee65750182ve_e
veer76229572veer
vera76828842vera
verb96224872verb
verge93419842verge
verse84723582verse
vert77249372vert
verve115417722verve
very108025642very
ware76254722ware
wee66760812we_e
weer75535092weer
wert79749822wert
where117019422where
wire75839812wire
wore77144672wore
yare75636942yare
yerk116222082yerk
yore76335942yore
zee126143232ze_e
zerk175319252zerk
zero134822472zero

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298723540.78038297.4
3Display Results3543540.0804425.0
 (SQL Overall)1786913541.126158695.4
 
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.