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

520 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
merches14401376(None) 
marches143921171marches
merces105720741merc_es
mercies113817561mercies
perches143717951perches
amerces1149852amerc_es
arches114822042_arches
beaches144120652beaches
beeches143413882beeches
belches143514342belches
benches143918602benches
birches143412322birches
creches14313092creches
curches143512742curches
eches106322162_e_ches
etches114217762_etches
fetches153413892fetches
kenches163912272kenches
ketches164012192ketches
larches124416442larches
leaches123319342leaches
leches115421312le_ches
leeches123911932leeches
letches124015482letches
lurches123311662lurches
maches134827232m_aches
manches143818622manches
marched153813402marched
marchen143312072marchen
marcher143912972marcher
marchers153710812marchers
marchesa15346882marchesa
marchese15358912marchese
marchesi15337322marchesi
marshes123615372marshes
matches143219782matches
menarches1646682menarches
mensches1536302mensches
menshes12310452menshes
mercer105214202merc_er
mercers114412772mercers
merch125417962merch__
mercs96020452merc__s
merdes94518602mer_des
meres75143572mer__es
mergees104411232mergees
merges94122492mer_ges
merises93421422merises
merles85322762mer_les
meshes115019442me_shes
miches134320732m_iches
mooches143714452mooches
mouches143815962mouches
muches134718992m_uches
mulches143210672mulches
munches144215792munches
mutches143314282mutches
parches143720002parches
peaches144120052peaches
perched154713242perched
percher143313422percher
perchers153611522perchers
porches143815672porches
reaches123423202reaches
retches123318512retches
searches132112902searches
seiches12513812seiches
smirches1535992smirches
teaches122718352teaches
tenches123515522tenches
terces83921412terc_es
torches123715432torches
vetches153411262vetches
welches153710312welches
wenches152914132wenches
aches106132293__aches
aerates74627493aerates
aeries64737783aer_ies
aerobes9311493aerobes
aitches123014363aitches
amerce10310513amerc_e_
amerced1256523amerc_ed
amercer1146373amerc_er
amercers1256133amercers
apaches143411833apaches
arched125717323_arched
archer115016243_archer
archers124414573_archers
baches135426943_baches
batches144019613batches
beached154516553beached
beechen14367703beechen
belched154011843belched
belcher143511493belcher
belchers153510023belchers
benched154713943benched
bencher144113483bencher
benchers153611013benchers
berakes134815773berakes
berates94126873berates
berdaches1745053berdaches
berimes115216643berimes
bermes106023003ber_mes
berries94423553berries
berthas12398763berthas
berthed13259123berthed
berths114712423berth_s
birched15349913birched
birchen14347883birchen
bitches144117063bitches
bleaches153410673bleaches
blenches153310763blenches
boches134618523_boches
borsches1536003borsches
botches143716023botches
braches144621223braches
breaches153714123breaches
breeches15258673breeches
bunches144116033bunches
butches144315363butches
caches137926913_caches
caroches15710693caroches
catches144320773catches
cerates95428253cerates
cercis104614493cerc_is
cercises12410933cercises
cercus105013153cerc_us
ceres75540013cer__es
cerises94722253cerises
cerites94823433cerites
certes84623083cer_tes
ceruses93716233ceruses
ceviches1834843ceviches
churches1846433churches
cinches144215773cinches
circles1139903circles
clenches152910953clenches
cliches144213743cliches
cloches144113713cloches
coaches144018693coaches
coerces11311943coerc_es
conches144019813conches
cooches143515833cooches
couches144020473couches
creche13310763creche_
culches143710743culches
cutches143216463cutches
deashes113313903deashes
decrees102513123decrees
decries103319803decries
deices94119373deic_es
demarches1745913demarches
derates84028893derates
derbies103016053derbies
derides93420853derides
derives114017813derives
derries83124623derries
detaches1439653detaches
deuces94015513deuc_es
ditches133215713ditches
douches134315233douches
drenches14309803drenches
dunches133312583dunches
earaches13411303earaches
eche97520283_e_che_
eched116919223_e_ched
echoes114715523_e_choes
echos105216463_e_chos
emcees1037813_emcees
emerges101310883emer_ges
emeries91620023emer_ies
enriches1337263enriches
erases64425403_erases
ernes55224813_er_nes
erodes74819883_erodes
eroses65327053_eroses
erses55826803_er_ses
eschew1436333_eschew
eschews1534553_eschews
etched123613703_etched
etcher113912943_etcher
etchers123411293_etchers
euchres1288663_euchres
farces115223323farc_es
farcies125317883farcies
feces105625363fe_c_es
fences114617113fenc_es
feres86038183fer__es
ferlies103216693ferlies
ferries103521083ferries
ferules103112723ferules
fescues1236783fescues
fetched163710473fetched
fetcher153510393fetcher
fetchers16328863fetchers
fetiches1636953fetiches
fiches145219533_fiches
filches153410723filches
finches153914193finches
fitches153516193fitches
fleches153411443fleches
fleeches16287083fleeches
flenches163410533flenches
fletches16308853fletches
forces114422133forc_es
frenches163311633frenches
freshes133515823freshes
gerahs1039413gerah_s
girshes11248293girshes
gulches13398103gulches
gurshes112210033gurshes
hatches153420273hatches
hercules1337633hercules
heredes11313133heredes
heres86245903her__es
heroes94923823her_oes
herpes115517323her_pes
herries104025073herries
hertzes1938303hertzes
heuchs14447923heuch_s
hitches153616273hitches
hooches153812523hooches
hotches153814363hotches
hunches153913463hunches
hutches153613523hutches
impeaches1843873impeaches
inarches1358043inarches
inches114419673_inches
itches114916213_itches
jerkies183411583jerkies
jerries143817513jerries
kerchief2043873kerchief
kerchiefs2141763kerchiefs
kerchoo1644973kerchoo
kermes124616133ker_mes
kernes104717533ker_nes
kerries113317913kerries
kirsches1743843kirsches
kvetches2053583kvetches
laches116528343_laches
larchen12479623larchen
latches123320123latches
leached133715043leached
leacher124014843leacher
leachers133712813leachers
leashes103514403leashes
leched123716003le_ched
lecher113415853le_cher
lechers123313963le_chers
lechwes1535063le_chwes
leeched13369503leeched
letched133912053letched
lethes94818083le_thes
liches114724293_liches
loaches123613983loaches
lunches124115443lunches
lurched13358033lurched
lurcher12338133lurcher
lurchers13307153lurchers
lyches144213613_lyches
lynches15378873lynches
maces97139963m_ac_es
mache125925303m_ache_
machos135217493m_achos
machs125722563m_ach_s
macles107023223m_acles
manche133515103manche_
manchet143317783manchet
manchets15269573manchets
marbles114516653marbles
marcel103714853marc_el
marcels113212373marcels
march125622893march__
marcs95726623marc__s
mares76457633mar__es
marges94525713mar_ges
marines93928013marines
marishes13512553marishes
marques182610863marques
marries93825283marries
marses84827113mar_ses
mashes115030003m_ashes
matched153513963matched
matcher143214283matcher
matchers153012433matchers
mealies92821933mealies
meanies93620743meanies
measles92412753measles
meccas1239493me_ccas
meddles113213253meddles
megohms1592863megohms
meinies92516073meinies
meioses9310833meioses
melees83618083me_lees
memes94927703me__mes
menaces112715523menaces
menages103615393menages
menarche1545813menarche_
menschen1543713menschen
menses84222453me_nses
menshen1236813menshen
mentees93214503mentees
merc87225623merc___
merceries13410043merceries
mercery14397623mercery
merchant1548813merchant
merchants1646223merchants
merciless1344473merciless
mercuries1347273mercuries
mercury14364893mercury
mercy125916183merc__y
merde84320123mer_de_
mere67244443mer__e_
merer75126233mer__er
merest84725113mer__est
merge84523693mer_ge_
merged104214953mer_ged
mergee94018143mer_gee
merger95016483mer_ger
mergers103813423mergers
merinos9311983merinos
merisis93213173merisis
merited10313853merited
merits8320873mer_its
merks114722403mer__ks
merle75824373mer_le_
merlins93015813merlins
merlons93311273merlons
merlots92710123merlots
merls77423903mer__ls
mermen10813813mer_men
merrier92612303merrier
merriest10311473merriest
mescals112911563mescals
meshed124415933me_shed
mesnes85216213me_snes
messes84924343me_sses
mestees94617753mestees
metages102714973metages
metates92720013metates
metes74736213me__tes
meths105320233me_th_s
metopes11311363metopes
metres85121563me_tres
mettles94115023mettles
mezcals20246533mezcals
mezes167719263me__zes
miche126219243m_iche_
miched143913393m_iched
minces104420803minc_es
miracles1238333miracles
mirages102213533mirages
mires75640883mir__es
mirexes1636993mirexes
mirths114912993mirth_s
miscues11312393miscues
mochas13310663m_ochas
mooched153910533mooched
moocher143610673moocher
moochers15369123moochers
morales93619403morales
mores76249643mor__es
morgues1038273morgues
morphed1537133morphed
morphos14159083morphos
morphs13149433morph_s
moshes115222873m_oshes
mouched153612593mouched
mulched15307763mulched
munched153411073munched
muncher143610373muncher
munchers15318773munchers
munchies1539253munchies
mures75937223mur__es
murexes1636973murexes
murices112612283murices
murines93718223murines
murphies1536453murphies
murres85019043mur_res
murrhas12286173murrhas
murries94118673murries
murther1237953murther
murthers1336543murthers
muscles11310563muscles
mushes114124563m_ushes
myrrhs1443603myrrh_s
myrtles1235733myrtles
naches114622413_naches
nerves94216193ner_ves
niches114419143_niches
notches123513653notches
oraches124216473oraches
orchis11710773_orchis
ouches114322183_ouches
parched154013693parched
parchesi15358213parchesi
patches143320383patches
peaces106324083peac_es
peached154315883peached
peacher144216073peacher
peachers153213843peachers
peched144915343pe_ched
pechs125516203pe_ch_s
penoches1538933penoches
penuches1536943penuches
percales12313803percales
perch124518833perch__
percuss1137163percuss
perdues103511333perdues
peres76246643per__es
perishes13313753perishes
perries93226603perries
perses85428063per_ses
perukes133210113perukes
peruses94018163peruses
pierces113411193pierc_es
pinches144117933pinches
pitches143617753pitches
pleaches153210433pleaches
plenches153110623plenches
poaches144416943poaches
pooches143214163pooches
pouches144116743pouches
preaches153214893preaches
psyches1755803psyches
punches144816133punches
quenches2236013quenches
quiches2139333quiches
qurshes19228573qurshes
ranches123620113ranches
ratches123620463ratches
reached134619083reached
reacher123718293reacher
reachers133515723reachers
recces10614913re_cces
rechew14310213re_chew
rechews1537293re_chews
reechoes1338413reechoes
rerises73525883rerises
rescues9312753rescues
reshes94124363re_shes
retched133814273retched
riches115022083_riches
roaches123616213roaches
rotches123515703rotches
rouches124217893rouches
ruches114819583_ruches
scorches15189143scorches
searched14209253searched
searcher13209103searcher
searchers14197353searchers
seethes103613743seethes
seiche11811833seiche_
serapes95218103serapes
serenes73222903serenes
seres55448893ser__es
serges74225973ser_ges
series64540973ser_ies
serines74229543serines
serries73925353serries
serves94423653ser_ves
seviches1635803seviches
sketches1746823sketches
smirched1634673smirched
smooches15217263smooches
smutches15177273smutches
soroches1338803soroches
speeches1537413speeches
starches131912913starches
stenches132110293stenches
taches114224173_taches
teacher123714833teacher
teachers133212393teachers
teched124014433te_ched
techies12513603te_chies
techs106915833te_ch_s
teethes103611653teethes
terce75721843terc_e_
tercel83612993terc_el
tercels94110363tercels
tercet83624913terc_et
tercets93512443tercets
ternes65422903ter_nes
terries73425633terries
tetched133010773tetched
tierces93710453tierc_es
torched133511353torched
touches125118343touches
trenches133512603trenches
troches123715343troches
tusches1237903tusches
verges104320183ver_ges
verites103822263verites
vermes115019143ver_mes
verses94223763ver_ses
verstes104014283verstes
verves124617883ver_ves
vouches153914113vouches
watches153017373watches
wechts1446253we_chts
welched16298833welched
welcher15319393welcher
welchers16338053welchers
welshes13379093welshes
wenched163910913wenched
wencher153811133wencher
wenchers16319213wenchers
wiches144418753_wiches
winches154714373winches
witches152715793witches
wrenches163210233wrenches
wretches16257283wretches
wyches17387913_wyches
xeroses143612823xeroses
xeroxes13246443xeroxes
xeruses143010753xeruses
yecchs16414953yecch_s
yechs136112583ye_ch_s
zeroes154314343zer_oes
zilches21326303zilches

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.423422437.4
2DLD Change Limit1340275207.37318178.1
3Display Results5205200.1902736.8
 (SQL Overall)1786915207.98622375.5
 
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.