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

549 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
emeries9162002(None) 
emerges101310881emerges
emperies12314561emperies
aeries64737782_aeries
amberies122514692amberies
ambries111614562ambries
amerces1149852amerces
aperies9423202aperies
celeries10316312celeries
demerges12129502demerges
demerits11310762demerits
eateries8324322eateries
eerie55228532e_erie_
eerier64320022e_erier
eeriest73620672e_eriest
elegies81312902elegies
embrues1136472embrues
emerge91510462emerge_
emerged11158212emerged
emerita938712emerita
emeritas1046432emeritas
emeriti949432emeriti
emeritus1045172emeritus
emerods10137652emerods
emeroids11147722emeroids
emersed10138512emersed
emeses86114962eme_ses
emesis84712622emesi_s
emetics11610722emetics
emetines10611052emetines
emetins9812652emetins
emeutes938012emeutes
empires1139852empires
emprise11310722emprise
emprises12311002emprises
emprizes2138132emprizes
empties11712242empties
enemies9313692enemies
energies9310782energies
entries71523162entries
eserines8413742eserines
eyries93816812e_yries
faeries104118992faeries
memories121214352memories
merces105720742_merces
mercies113817562_mercies
merdes94518602_merdes
meres75143572_mer_es
merges94122492_merges
merises93421422_merises
merits8320872_merits
merles85322762_merles
peeries93623022peeries
queries16315872queries
remedies11310552remedies
remerges111110202remerges
reveries112518512reveries
series64540972_series
veeries102916892veeries
veneries112815032veneries
aerie54634603_aerie_
aeried74221873_aeried
aerier64823163_aerier
aeriest73924053_aeriest
ambaries123312383ambaries
amerce10310513amerce_
amerced1256523amerced
amercer1146373amercer
amercers1256133amercers
amies76837693am__ies
amities9317383amities
amperes11313983amper_es
anergies9310453anergies
armories10313653armories
arteries8321513arteries
bakeries14312203bakeries
beaneries11310903beaneries
beedies10314203beedies
beerier93613033beerier
beeriest104013403beeriest
belfries1336983belfries
belies84631053_belies
bemires113212833bemir_es
berimes115216643_berimes
bermes106023003_bermes
berries94423553berries
bevies114017313_bevies
bewearies1447013bewearies
boweries13312293boweries
breweries1447583breweries
bries74942153__bries
buries84633273_buries
caries85147623_caries
carries94328013carries
cemeteries1447383cemeteries
ceres75540013_cer_es
cerias83321983_cerias
cerise84822043_cerise
cerises94722253_cerises
cerites94823433_cerites
certes84623083_certes
cherries131812993cherries
chevies153511443chevies
claries93422203claries
clergies1137903clergies
clerics1149333clerics
clerids1049093clerids
coerces11311943coerces
comedies13311843comedies
corries94026803corries
coteries10422713coteries
cowries124218013cowries
creameries1446673creameries
cries75438403__cries
curies84934023_curies
curries93723163curries
dairies84217733dairies
deaneries10310833deaneries
dearies83526273dearies
decries103319813decries
decuries11312223decuries
defies104624053_defies
demerge11168023demerge_
demerged13157603demerged
demerger12127373demerger
demergers13146403demergers
demerit10314993demeri_t
demerited1339073demerited
demesnes1137083demesnes
demies94825803_demies
denies74729643_denies
derbies103016053_derbies
derides93420853_derides
derives114017813_derives
derries83124623derries
descries11311923descries
deserves12109893deserves
deterges101510093deterges
dexies145018343_dexies
diaries83321953diaries
dimerizes2167943dimerizes
dories75232363_dories
doweries12411933doweries
dowries114413983dowries
drearies92313413drearies
dries64733673__dries
duperies11312813duperies
durries83817353durries
eagres74014573eagr_es
easies64126633e_asies
ebonies9312883ebonies
ecartes94212563ecartes
ecesis84611203ecesi_s
ecesises1037023ecesises
eddies83313163e_ddies
edifies113012283edifies
eelier64216463e_elier
eeliest73516473e_eliest
eerily92913563e_erily
eeriness8311873e_eriness
egers65120373eger__s
elderlies1044673elderlies
elegise8139393elegise
elegises9128823elegises
elegits8149343elegits
elegizes18137103elegizes
elemis8312383elemi_s
emails84412343em_ails
embers104116183ember__s
embodies1337003embodies
embolies1239153embolies
embraces14128873embraces
embroils1245773embroils
embrue1036533embrue_
embrued1235293embrued
embrutes1245193embrutes
embryos1464093embryos
emcees1037813em_cees
emeer74815363eme__er
emeerates1149373emeerates
emeers83314183eme_ers
emended11329603emended
emender10649843emender
emenders11319033emenders
emends95711433eme_nds
emerald1046923emerald
emeralds1144593emeralds
emergent1149113emergent
emergents1245973emergents
emerging1237893emerging
emeritae1046353emeritae
emerod9139213emer_od
emeroid101511183emeroid
emersion1047733emersion
emersions1147283emersions
emery104814333emer__y
emes65434663em___es
emetic10614453emeti_c
emetin8613463emeti_n
emetine9712943emetine
emeus76913333eme__us
emeute838533emeute_
emigres1037673emigres
emirates101214853emirates
emirs76116163em__irs
emits75421473em__its
emmers104013223emmer__s
emodins1039433emodins
emotes84620283em_otes
empales112411433empales
emperors1256123emperors
empire1039323empire_
empirics1444003empirics
empress1138163empress
emprize2038843emprize
emptied1297403emptied
emptier1187603emptier
emptiers1275193emptiers
emptiest1278103emptiest
emptins1179403emptins
emydes1236173em_ydes
endrins8312163endrins
energids1045583energids
energise947333energise
energises1047063energises
energizes1945473energizes
enmeshes1345343enmeshes
enmities10611353enmities
enskies1138573enskies
enterics10312863enterics
entires71517783entires
entrees71813773entrees
enures63919713enur_es
envies9314053e_nvies
epees75219833epe__es
epergnes1156713epergnes
epimeres12117653epimer_es
epoxies1637753epoxies
equerries1844883equerries
eremites10312613eremites
ernes55224813__ernes
erses55826803__erses
eserine7415903eserine
espies83716803e_spies
esprits938393esprits
estrins7315853estrins
eterne6311723eterne_
eternise8119663eternise
eternises9119453eternises
eternizes18118013eternizes
etherizes2149313etherizes
eucrites1049483eucrites
everted112711853everted
everts94514893ever_ts
ewers86018823ewer__s
exequies2444153exequies
exercise1747063exercise
exercises1846463exercises
exergues1644123exergues
exerted152210053exerted
exerts133712293exer_ts
expires1638683expires
expiries1747753expiries
externes1539833externes
eyelids1135943eyelids
eyers86521333eyer__s
eyres84921773e_yr_es
eyrie88117833e_yrie_
faerie93514683faerie_
fairies103516043fairies
fakeries1559833fakeries
feres86038183_fer_es
ferias95020393_ferias
ferlies103216693_ferlies
ferneries1239053ferneries
ferries103521083ferries
fierier103511193fierier
fieriest112112243fieriest
fineries112416753fineries
freres94716173frer_es
fries85535603__fries
furies95126373_furies
generics11118803generics
genies75324943_genies
gentries91315273gentries
geometries13139253geometries
glories81915923glories
gomerils1146803gomerils
gurries83515953gurries
haeres94017033haer_es
harries103525503harries
helleries122611693helleries
henneries1248643henneries
henries102718283henries
heres86245903_her_es
heresies11312703heresies
heroes94923833_heroes
herpes115517323_herpes
herries104025083herries
hexereis1894803hexereis
hurries103919653hurries
imageries1246783imageries
imbrues1135503imbrues
immerges1345393immerges
immerses1235953immerses
immies102412443im_mies
imperils1247713imperils
implies11312123implies
ivories10310713ivories
japeries17311463japeries
jemmies18318333jem_mies
jerids142810943_jerids
jerkies183411583_jerkies
jerries143817513jerries
jewelries1943033jewelries
juries134120633_juries
kauries113613193kauries
kermes124616143_kermes
kernes104717533_kernes
kerries113317913kerries
kyries133411373_kyries
lecheries1449073lecheries
leerier73111503leerier
leeriest83112883leeriest
lemures938793lemur_es
levies93919863_levies
liernes739623liernes
liveries11314373liveries
lories64933043_lories
lorries74518353lorries
mamies104626243_mamies
mares76457633_mar_es
marges94525713_marges
marines93928033_marines
marries93825283marries
marses84827113_marses
mavies114923193_mavies
mealies92821933mealies
meanies93620743meanies
medias93620783_medias
medics114115353_medics
medius93613283_medius
megrims1276103megrims
meinies92516073meinies
melees83618083_melees
memes94927703_me_mes
memetics1447803memetics
memorise121411433memorise
memorises131211583memorises
memorizes221310823memorizes
menses84222453_menses
mercer105214203_mercer
merceries13410043merceries
mercers114412773_mercers
merches144013763_merches
mercs96020453_mer_cs
merde84320123_merde_
mere67244443_mer_e_
merer75126233_mer_er
merest84725113_mer_est
merge84523693_merge_
merged104214953_merged
mergee94018143_mergee
mergees104411233_mergees
merger95016483_merger
mergers103813423_mergers
merino8315093_merino
merinos9311983_merinos
merisis93213173_merisis
merit7339183_meri_t
merited10313853_merited
merks114722403_mer_ks
merle75824373_merle_
merlins93015813_merlins
merls77423903_mer_ls
mermen10813813_mermen
merrier92612303merrier
merriest10311483merriest
meshes115019443_meshes
mesmerise1345843mesmerise
mesmerises1445823mesmerises
mesmerizes2345993mesmerizes
mesnes85216213_mesnes
messes84924343_messes
metes74736213_me_tes
metier83517693_metier
metiers93312843_metiers
metis75025903_meti_s
metres85121563_metres
metrics11312363metrics
mezes167719263_me_zes
mires75640883_mir_es
mirier83918363_mirier
miriest93619823_miriest
mirins83918903_mirins
miseries10320403miseries
moires8915633_moires
molies84429513_molies
monies83233163_monies
moperies12313873moperies
mores76249643_mor_es
movies115118453_movies
moxies154317403_moxies
mummeries1247243mummeries
mures75937223_mur_es
murices112612283_murices
murids93212193_murids
murines93718223_murines
murres85019043_murres
murries94118673murries
naperies10313903naperies
nemertines1245963nemertines
nemeses948663neme_ses
nemesis937373nemesi_s
nereis6315343_nereis
nerves94216193_nerves
newies91014073_newies
niteries8318383niteries
numerics1266283numerics
ombres103911143ombr_es
omers76923193omer__s
onerier7311613onerier
oneriest8313443oneriest
orreries8310123orreries
ovaries10312653ovaries
overlies112417043overlies
paries84742523_paries
parries93925853parries
pedleries1298783pedleries
peerie83617893peerie_
pelerines11311843pelerines
peltries10313023peltries
penuries10311663penuries
peres76246643_per_es
perils84121853_perils
peris75537073_peri_s
perries93226603perries
perses85428063_perses
pierces113411193pierces
pieties9419223pieties
pineries102419083pineries
poesies93217403poesies
poetries10315583poetries
poperies12316793poperies
predries112714383predries
premies113823063premies
prexies163415003prexies
pries74339533__pries
pterins9812993pterins
queried1738693queried
querier16310013querier
queriers1736973queriers
reburies10311143reburies
redefies12710163redefies
redenies9615713redenies
redries83721713redries
reemerges1255173reemerges
referees111310413referees
refries104419733refries
relies65036423_relies
remarries1147683remarries
remedied1237953remedied
remerge10148923remerge_
remerged12149173remerged
remorses10311993remorses
rerigs74014793_rerigs
rerise64325633_rerise
rerises73525883_rerises
reserves111011983reserves
reties65436193_reties
retries74129073retries
revelries1246923revelries
reveres103621343rever_es
reverie103615163reverie_
reverses112513513reverses
rezeroes1737143rezeroes
roperies10315773roperies
roseries8317323roseries
ruderies9311333ruderies
sauries72821623sauries
sceneries1149403sceneries
scries85226823_scries
sealeries9313133sealeries
sememes11109203seme_mes
sentries81318063sentries
seres55448893_ser_es
serges74225973_serges
serifs94017053_serifs
serines74229543_serines
serins64029673_serins
serries73925353serries
serves94423653_serves
sferics1236133sferics
sherifs13299683sherifs
sherries111812903sherries
skerries12168673skerries
smarties10312873smarties
smearier1036953smearier
smeariest1138123smeariest
smerked14327283smerked
smerks12449713smer_ks
species11314133species
stemmeries1445183stemmeries
steres63929533ster_es
stories7324273stories
swerves1377533swerves
tarries73324263tarries
temerities1268493temerities
temerity1346903temerity
tepefies1346893tepefies
terces83921413_terces
ternes65422903_ternes
terries73425633terries
theories11311593theories
theres96525473ther_es
thermes126214613thermes
tierces93710453tierces
tmeses85712243tme_ses
tmesis8529793tmesi_s
tories65435883_tories
tries55742813__tries
tumefies1345773tumefies
umpires1137813umpires
updries10209083updries
usuries7510633usuries
varies94330873_varies
vegies104314273_vegies
verges104320183_verges
verier94620963_verier
veriest103719133_veriest
verites103822263_verites
vermes115019143_vermes
verses94223763_verses
verves124617883_verves
vestries11314053vestries
vineries112716043vineries
voleries11313233voleries
wearies103020233wearies
weenies102915093weenies
weepies122811743weepies
wheres125917443wher_es
wherries14179033wherries
wherves16548063wherves
wienies102213683wienies
wineries112316533wineries
worries104117133worries
wries85827743__wries
yperites13310153yperites
zeroes154314343_zeroes

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.763234195.3
2DLD Change Limit1340275496.79619721.5
3Display Results5495490.2062665.0
 (SQL Overall)1786915497.76523012.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.