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

262 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
metamers124962(None) 
metamer1139611metamer_
metamere1257351metamere
metameres1347451metameres
defamers14258522defamers
meaners94415242me_aners
menacers12279312menacers
metages102714972metage_s
metameric1546202metameric
metamerism1354772metamerism
metates92720012metate_s
meters85625832met__ers
metiers93312842met_iers
reamers94221082re_amers
retakers123511132retakers
seamers94719432se_amers
steamers103410872steamers
tamers84224032__tamers
tetramers1146462tetramers
vitamers1334682vitamers
aethers103614943aet_hers
beaders104120183be_aders
beakers134216873be_akers
bearers94619593be_arers
beaters94925043be_aters
beavers124417323be_avers
behavers16205613behavers
bejabers1933633bejabers
belayers13298143belayers
benames112814603bename_s
betakes134212523betake_s
betatters1134963betatters
betimes115114413betime_s
betrayers1445013betrayers
betters94422093bet_ters
blamers115314213_blamers
cetanes9315133cetane_s
creamers124111313creamers
dealers84118613de_alers
debasers11377903debasers
debaters113511923debaters
decayers14307963decayers
defacers14237993defacers
defamer132710323defamer_
defames132812253defame_s
defoamers15285253defoamers
degames113312623degame_s
delayers12268663delayers
detachers1536483detachers
detailers10257253detailers
detainers10269103detainers
deters74724683det__ers
dewaters122910723dewaters
dreamers11369003dreamers
eagers74523683_e_agers
eaters65535953_e_aters
elaters74420193_elaters
embalmers1543773embalmers
emmers104013223_e_mmers
empalers12226743empalers
enamels9128163_enamels
enamors939123_enamors
epimers11109493_epimers
erasers74413943_erasers
etagere836533_etagere
etageres936863_etageres
etamins91511833_etamins
etapes85415293_etape_s
etchers123411293_etchers
ethers94518413_et_hers
evaders1136933_evaders
examens1637193_examens
fearers104815273fe_arers
feathers143513243feathers
fetchers16328863fetchers
fetters103517903fet_ters
flamers124616363_flamers
foamers123812103_foamers
framers125113823_framers
gamers94420833__gamers
getters84216103get_ters
gleamers11306563gleamers
headers113819393he_aders
healers104319463he_alers
heapers123616673he_apers
hearers104319783he_arers
heaters104225223he_aters
heathers143914733heathers
heavers133717193he_avers
hemmers143310843he_mmers
hetaera1036493heta_era
hetaeras1146733heta_eras
leaders83819603le_aders
leakers113415423le_akers
leaners73718173le_aners
leapers93716663le_apers
leasers74717843le_asers
leathers114215083leathers
leavers103717783le_avers
letters73819853let_ters
macers105321273m__acers
madames12310063madame_s
maimers113813043m_aimers
makers123921733m__akers
mameys13449523m__ameys
mammers104615693m_ammers
mamzers20409163m__amzers
managers112911003managers
masers84623453m__asers
matadors1156983matadors
matchers153012433matchers
maters85032393m__aters
matters94421753mat_ters
maturers1037373maturers
mazers173917093m__azers
meager94515203me_ager_
meanders1168833meanders
meaner84617843me_aner_
meatier93214613meatier_
meatless103410863meatless
meatmen1138243meatme_n
meddlers12318203meddlers
meeters94714543me_eters
megabars1344403megabars
meisters103313843meisters
melamed1249633melame_d
melders103213913me_lders
meltages1148243meltage_s
melters93918313me_lters
meltwaters1542963meltwaters
members13258603me_mbers
memes94927703me__me_s
menacer112610883menacer_
menaces112715523menace_s
menages103615393menage_s
menders103818803me_nders
mercers114412773me_rcers
mergers103813423me_rgers
mesdames1346043mesdame_s
mesomere1247193mesomere
mesomeres1347193mesomeres
metage93114453metage__
metaled102913883metale_d
metalmark1752363metalmark
metalmarks1852403metalmarks
metals84520883meta__ls
metamerisms1453903metamerisms
metaphors1645683metaphors
metatags1144693metatags
metatarsi1143133metatarsi
metate82720533metate__
meteors94610013met_eors
meter75130323met__er_
metes74736213met__e_s
methanes133812163methane_s
metier83517693met_ier_
metopes11311363metope_s
metres85121563met_re_s
mettles94115023mettle_s
metumps1334133metum_ps
mewlers12288983me_wlers
mimers105520183m__imers
misavers1348063misavers
mistakers15117083mistakers
miterers10219683miterers
miters84328783mit__ers
mithers123516733mit_hers
moaners92813553m_oaners
monomers12311033monomers
mothers123717623mot_hers
mottlers10388183mottlers
mummers103712843m_ummers
mutagens1144853mutagens
mutases92012043mutase_s
mutates92215793mutate_s
mutters94117143mut_ters
namers84517333__namers
negaters9349783negaters
netters73618583net_ters
nettlers8307513nettlers
patamars1246843patamars
pedalers11239393pedalers
pentamery1644023pentamery
peters86624593pet__ers
petnapers1343823petnapers
petters93722363pet_ters
readers83823773re_aders
reamer84325213re_amer_
reapers93520453re_apers
rearers74323563re_arers
reavers108320743re_avers
rebaters103413943rebaters
recamiers1345513recamiers
regalers94311133regalers
rehammers1644503rehammers
relaters83218153relaters
relaxers15298263relaxers
remakers143811303remakers
renames92418053rename_s
repapers1258833repapers
resumers1038083resumers
retailers9258773retailers
retainers92510763retainers
retaker113714313retaker_
retakes113718863retake_s
retapes93917423retape_s
retarders10227573retarders
retaxes143615093retaxe_s
retempers1345023retempers
retimes95020173retime_s
retirers84311533retirers
retracers11149553retracers
revampers1653443revampers
roamers93713463_roamers
sealers74323553se_alers
seamer84223613se_amer_
seaters74028943se_aters
seemers93814333se_emers
sesames9310743sesame_s
setters73822063set_ters
settlers8289023settlers
smearers10308623sme_arers
stagers84116673_stagers
stamens93411483_stamens
stammers123611523_stammers
stampers124211603_stampers
starers74522313_starers
staters73922343_staters
stayers103813633_stayers
stealers83412213stealers
steamer93313093steamer_
stemmers12378443stemmers
tabers84621573__tabers
takers103923743__takers
talers64628143__talers
tamer75230103__tamer_
tames75242013__tame_s
tampers113516743__tampers
tapers84025813__tapers
taters64932203__taters
tawers94118603__tawers
taxers134015283__taxers
tearers75218233te_arers
teasers75317243te_asers
teemers95012903te_emers
termers95414503te_rmers
tethers103815313tet_hers
tetramer1046813tetramer_
tetters74320473tet_ters
timers84420993__timers
vealers103214293ve_alers
venomers1336703venomers
vetivers1435163vetivers
vetoers10359473vet_oers
vetters104016323vet_ters
vitamer1235473vitamer_
weaners104613833we_aners
wearers104615903we_arers
weathers143412833weathers
weavers133714463we_avers
wethers135214693wet_hers
wetters103817753wet_ters

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622627.07620656.0
3Display Results2622620.0962729.2
 (SQL Overall)1786912627.60823487.3
 
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.