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

438 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
mergees10441123(None) 
mergee94018141mergee_
mergers103813421mergers
merges94122491merg_es
bargees105415872bargees
bergeres1189112bergeres
burgees104915892burgees
degrees92810722degrees
emerges101310882emerg_es
marges94525712marg_es
melees83618082me_lees
mentees93214502mentees
mercers114412772mercers
merces105720742mer_ces
merches144013762merches
mercies113817562mercies
merdes94518602mer_des
meres75143572mer__es
merge84523692merg_e_
merged104214952merg_ed
mergences14137552mergences
merger95016482merg_er
merises93421422merises
merles85322762mer_les
mestees94617752mestees
morgens10310462morgens
morgues1038272morgues
muggees11338882muggees
perigees1189502perigees
sergers83815632sergers
serges74225972serg_es
vergers114412632vergers
verges104320182verg_es
aerates74627493aerates
aeries64737783aer_ies
aerobes9311493aerobes
aerogels945593aerogels
agrees74915323agr_ees
amercers1256133amercers
amerces1149853amer_ces
anergies9310453anergies
apogees1037103apogees
argles75218483_argles
argues74516413_argues
bareges105212033bareges
bargee94624443bargee_
barges94528253barg_es
beagles103212123beagles
beebees1138013beebees
begets96215523be_gets
beiges91014413beig_es
beignes10149243beignes
bendees103913863bendees
berakes134815773berakes
berates94126873berates
berets85822523ber_ets
bergere1068913bergere
bergs84718043berg__s
berimes115216643berimes
bermes106023003ber_mes
berries94423553berries
berseem1166463berseem
berseems1263933berseems
brees75632553_br_ees
bungees104513103bungees
burgee97120593burgee_
burgers103918573burgers
burgess10409343burgess
burgles105615963burgles
cargoes104415223cargoes
cerates95428253cerates
ceres75540013cer__es
cereus85215523cer_eus
cerises94722253cerises
cerites94823433cerites
cermets1139713cermets
certes84623083cer_tes
ceruses93716233ceruses
clergies1137903clergies
congees103517923congees
corvees124613793corvees
decrees102513123decrees
degree82814853degree_
degreed10258883degreed
demergers13146403demergers
demerges12129503demerg_es
dengues938183dengues
derates84028893derates
derbies103016053derbies
derides93420853derides
derives114017813derives
derries83124623derries
dirges84915103dirg_es
dragees9359483dragees
drees65628523_dr_ees
eagers74523683_eagers
eagles73819163_eagles
eagres74014573_eagres
edgers84413923_edgers
edges75718743_edg_es
egers65120373_e_gers
eggers84612583_eggers
egress73310433_egress
egrets72712243_egrets
emcees1037813_emcees
emerge91510463emerg_e_
emerged11158213emerg_ed
emergences15105953emergences
emergent1149113emergent
emergents1245973emergents
emeries91620023emer_ies
emigres1037673emigres
energies9310783energies
epees75219833_e_pees
epergnes1156713epergnes
erases64425403_erases
ergates8314493_ergates
ergots74512373_ergots
ergs55523813_erg__s
ernes55224813_er_nes
erodes74819883_erodes
eroses65327053_eroses
erses55826803_er_ses
etwees9348793_etwees
exergues1644123exergues
feres86038183fer__es
ferlies103216693ferlies
ferrels10248623ferrels
ferrets103111393ferrets
ferries103521083ferries
ferules103112723ferules
forgers115218183forgers
forges105024263forg_es
forgets113813793forgets
forgoes11311353forgoes
frees86131393_fr_ees
gargets94614573gargets
gargles94214893gargles
gees55647883___gees
gelees74116263ge_lees
germens1078633germens
gorgers94813643gorgers
gorges85321893gorg_es
gorgets94711783gorgets
grees65132473_gr_ees
gurges84716863gurg_es
gurgles94312873gurgles
hedgers124310263hedgers
hedges115016263hedg_es
henges104516463heng_es
herders113914123herders
heredes11313133heredes
heres86245903her__es
heroes94923823her_oes
herpes115517323her_pes
herries104025073herries
hertzes1938303hertzes
hirees95117293hir_ees
immerges1345393immerg_es
jaygees1854513jaygees
jereed144012073jer_eed
jereeds15326393jereeds
jerkers18287083jerkers
jerkies183411583jerkies
jerreed1535213jerreed
jerreeds1653273jerreeds
jerries143817513jerries
jerseys1733243jerseys
kedges124812983kedg_es
keggers13357043keggers
kermes124616133ker_mes
kermess13396223kermess
kernels11417953kernels
kernes104717533ker_nes
kerogens1345763kerogens
kerries113317913kerries
kerseys1433993kerseys
larees65323113lar_ees
larges74824233larg_es
largess8408913largess
leagues837943leagues
ledgers94912183ledgers
ledges84918013ledg_es
legers74518313le_gers
leges64427293le_g_es
lessees73510243lessees
levees93714523le_vees
lungees84412143lungees
mages85036023m_ag_es
mallees93315973mallees
mammees104411143mammees
maneges103612143maneges
mangels103614493mangels
mangers103521263mangers
manges94628943mang_es
mangles104021463mangles
mangoes104316133mangoes
marbles114516653marbles
marcels113212373marcels
marches143921173marches
mares76457633mar__es
margays1337493margays
marge85328333marg_e_
margent10316693margent
margents11410133margents
margins103815193margins
marines93928013marines
markers133516103markers
markets133314033markets
marquees19206243marquees
marques182610863marques
marrers93414313marrers
marries93825283marries
marses84827113mar_ses
marshes123615373marshes
martens93714953martens
marvels123810093marvels
meager94515203meag_er
meagre9349323meagre_
mealies92821933mealies
meaners94415243meaners
meanies93620743meanies
measles92412753measles
meddles113213253meddles
medleys13115333medleys
meeds84920273me__eds
meeters94714543meeters
meets74224613me__ets
megass9219443me_gass
megrims1276103megrims
megs75530633me_g__s
meinies92516073meinies
meioses9310833meioses
melders103213913melders
melee73729103me_lee_
melters93918313melters
members13258603members
memes94927703me__mes
menaces112715523menaces
menages103615393menages
menders103818803menders
menses84222453me_nses
menshes12310453menshes
mentee84121293mentee_
mercer105214203mer_cer
merceries13410043merceries
mercery14397623mercery
mercs96020453mer__cs
merde84320123mer_de_
mere67244443mer__e_
merely111312593mer_ely
merengues1243373merengues
merer75126233mer__er
merest84725113mer_est
mergence13137943mergence
merging112711763merging
meringues1244383meringues
merinos9311983merinos
merisis93213173merisis
merited10313853merited
merits8320873mer_its
merks114722403mer__ks
merle75824373mer_le_
merlins93015813merlins
merlons93311273merlons
merlots92710123merlots
merls77423903mer__ls
mermen10813813mer_men
merrier92612303merrier
merriest10311473merriest
meseems1165603meseems
meshes115019443me_shes
mesnes85216213me_snes
messes84924343me_sses
mestee84523883mestee_
metages102714973metages
metates92720013metates
meters85625833me_ters
metes74736213me__tes
metiers93312843metiers
metopes11311363metopes
metres85121563me_tres
mettles94115023mettles
mewlers12288983mewlers
mezes167719263me__zes
midges103516483midg_es
midgets113910253midgets
miggles113512033miggles
mingles103719003mingles
mirages102213533mirages
mires75640883mir__es
mirexes1636993mirexes
moggies113111723moggies
mongeese1144593mongeese
mongers104217273mongers
mongoes103415713mongoes
morales93619403morales
moreen8313343mor_een
moreens939963moreens
morels84820013mor_els
mores76249643mor__es
morgans10310123morgans
morgen9312203morg_en
morgue938113morgue_
morsels94112653morsels
muggee103612833muggee_
muggers113611933muggers
mungoes103510463mungoes
murders103311363murders
mures75937223mur__es
murexes1636973murexes
murices112612283murices
murines93718223murines
murres85019043mur_res
murreys12367323murreys
murries94118673murries
mustees94614923mustees
myrtles1235733myrtles
nereis6315343ner_eis
nerves94216193ner_ves
ogees65119143__ogees
orgies72316093_orgies
oversees112415903oversees
parges94529543parg_es
pargets105215193pargets
peages94321853peag_es
peewees1236803peewees
pensees9311203pensees
perches143717953perches
perdues103511333perdues
peres76246643per__es
perigee101113393perigee_
perries93226603perries
perses85428063per_ses
perukes133210113perukes
peruses94018163peruses
pewees11311393pe_wees
pledgees12376283pledgees
pongees104212543pongees
porgies103017003porgies
prees75937173_pr_ees
pugrees10218523pugrees
purees84721683pur_ees
purgers104714003purgers
purges94421763purg_es
ragees74618663_ragees
raggees93710913raggees
reargues936713reargues
rees45364193__r_ees
refugees12476403refugees
reges65628793re_g_es
reggaes948883reggaes
regreen8309043regreen
regreens9257453regreens
regreet83015953regreet
regreets9287853regreets
regress82711453regress
regrets83212923regrets
remerges111110203remerg_es
reneges82513593reneges
rerises73525883rerises
resees63827483re_sees
sarees65329943sar_ees
sarges75128593sarg_es
screes85023973scr_ees
sedges83817813sedg_es
segues7412073se_gues
serapes95218103serapes
serenes73222903serenes
seres55448893ser__es
serge64727473serg_e_
serged84118773serg_ed
serger73819743serg_er
series64540973ser_ies
serines74229543serines
serries73925353serries
servers103214833servers
serves94423653ser_ves
settees73513633settees
sirees64624583sir_ees
sirrees73410573sirrees
sprees85620643spr_ees
surgers83517483surgers
surges73924593surg_es
targes74524593targ_es
targets84314223targets
teepees939263teepees
tepees84215243te_pees
tercels94110363tercels
terces83921413ter_ces
tercets93512443tercets
tergites9310543tergites
termers95414503termers
ternes65422903ter_nes
terpenes102111573terpenes
terreen7257573terreen
terreens8246533terreens
terrenes82212603terrenes
terrets72913583terrets
terries73425633terries
testees74215913testees
threes97117323thr_ees
trees55835763_tr_ees
urgers73313623_urgers
urges64619913_urg_es
veepees1245813veepees
veges94118873ve_g_es
veggies1237553veggies
vegies104314273ve_gies
vendees114011453vendees
venges104015153veng_es
verge93419843verg_e_
verged114815163verg_ed
vergences15128063vergences
verger104315703verg_er
verglas1137813verglas
verites103822263verites
vermes115019143ver_mes
versers103813523versers
verses94223763ver_ses
versets103913103versets
verstes104014283verstes
vertexes18105633vertexes
verves124617883ver_ves
vervets13419753vervets
vestees103513173vestees
wedges114614583wedg_es
wedgies123910213wedgies
weewees1336563weewees
wergeld1233183wergeld
wergelds1342293wergelds
wergelt1138583wergelt
wergelts1253413wergelts
xeroses143612823xeroses
xeroxes13246443xeroxes
xeruses143010753xeruses
yogees10510633_yogees
zeroes154314343zer_oes

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.436409841.7
2DLD Change Limit1340274387.11018850.5
3Display Results4384380.1562807.7
 (SQL Overall)1786914387.70223200.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.