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

374 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
metopes1131136(None) 
metope10611121metope_
detoxes1538802detoxes
elopes85918162_elopes
etapes85415292_etapes
ketones115014502ketones
ketoses114912872ketoses
meioses9310832meioses
metages102714972metages
metates92720002metates
metepas1136302metepas
metes74736212met__es
metols84115772meto_ls
metopae1147742metopae
metopic1339762metopic
metopon11137072metopon
metopons12107022metopons
metres85121562met_res
mettles94115022mettles
mitoses9312182mitoses
mopes95134982m__opes
myopes13419962m_yopes
netops839212netop_s
retapes93917422retapes
retypes12308622retypes
stopes84525892_stopes
topes76941762__topes
vetoes92914082veto_es
acetones10310033acetones
aerobes9311493aerobes
amitoses1039053amitoses
atones65225773_atones
atopies92816433_atopies
autopen947123autopen
autopens1046633autopens
bebops1237623bebop_s
becomes132911963becomes
behoves15177353behoves
betakes134212523betakes
betides104915263betides
betimes115114413betimes
betises94816123betises
betoken13386503betoken
betokens14324573betokens
betonies10413063betonies
betons84919553beto_ns
biotopes1246963biotopes
cenotes92814543cenotes
centones10313663centones
cepes94424463ce__pes
cestodes1138203cestodes
cetanes9315133cetanes
cetes75731103cet__es
citoles9312553citoles
copes97747103__copes
cotypes1437943cotypes
debones103315113debones
decodes113914983decodes
demoses103815823demoses
demotes104717673demotes
denotes83817003denotes
depones103717093depones
deposes103117213deposes
detours858033detours
detoxed1636103detoxed
devotes113713753devotes
dopes84935043__dopes
ectypes1434803ectypes
elope75219343_elope_
eloped95914143_eloped
eloper85414153_eloper
elopers95112943_elopers
emetines10611053emetines
emmetropes1652343emmetropes
emotes84620283_emotes
epitopes1246973epitopes
epodes94315563_epodes
epopee10312503_epopee
epopees1137233_epopees
eposes84418783_eposes
erodes74819883_erodes
eroses65327053_eroses
estops84011223estop_s
etape74413703_etape_
etches114217763_etches
ethoses10311753_ethoses
etoiles7411293_etoiles
etudes73811603_etudes
etwees9348793_etwees
evokes13459683_evokes
fetches153413893fetches
fetes85630143fet__es
fetors91014473feto_rs
fettles103912733fettles
fetuses10310243fetuses
gemotes103712143gemotes
genomes103611703genomes
geodes8412153ge_odes
getups9346853getup_s
gropes95220403_gropes
heptoses1338373heptoses
heroes94923823hero_es
herpes115517323he_rpes
hexones17299143hexones
hexoses17228883hexoses
hopes105835643__hopes
intones7816543intones
isotopes10228073isotopes
jetes124922843jet__es
jetons134512613jeto_ns
jetties143613123jetties
ketches164012193ketches
ketenes114813503ketenes
ketols104210763keto_ls
ketone105014533ketone_
ketose105711813ketose_
ketosis11429733ketosis
kettles113411613kettles
leones64417723le_ones
letches124015483letches
lethes94818083let_hes
letups8317683letup_s
litotes7311183litotes
lopes76437343__lopes
lotoses73713643lotoses
mahoes11313103maho_es
maltoses1039853maltoses
manropes1237913manropes
matches143219783matches
mates75251363mat__es
matres84522233mat_res
mattes85624533mat_tes
matures9314303matures
mealies92821933mealies
meanies93620743meanies
measles92412753measles
meatuses1038203meatuses
meddles113213253meddles
megohms1592863megohms
meinies92516073meinies
meiosis939023meiosis
melees83618083me_lees
melodies11310123melodies
meloids10911443meloids
melons84117713melo_ns
meltages1148243meltages
meltons9410923melto_ns
memes94927703me__mes
memoirs1136803memoirs
memories121214343memories
memos95719113memo__s
menaces112715523menaces
menages103615393menages
menses84222453me_nses
menshes12310443menshes
mentees93214503mentees
mentored1138003mentored
mentors9314993mento_rs
meoued9118533me_oued
meous76120063me_o_us
meowed12148003me_owed
meows104612683me_o_ws
merces105720743me_rces
merches144013763merches
mercies113817563mercies
merdes94518603me_rdes
meres75143573me__res
mergees104411233mergees
merges94122483me_rges
merises93421423merises
merles85322763me_rles
meropia1149613meropia
meropias1249953meropias
meropic13310263meropic
meshes115019443me_shes
mesnes85216213me_snes
mesons83215843meso_ns
messes84924343me_sses
mestees94617753mestees
metage93114453metage_
metaled102913873metaled
metals84520883met_als
metamer1139613metamer
metamers1249623metamers
metate82720533metate_
mete64438133met__e_
meted85424433met__ed
meteors94610013meteors
metepa1066013metep_a
meter75130323met__er
metered103514013metered
meters85625833met_ers
methanes133812163methanes
methods1338883methods
meths105320233met__hs
methyls1535453methyls
metier83517693met_ier
metiers93312843metiers
metis75025903met__is
metisse936503metisse
metisses1036833metisses
metol75917813meto__l
metonym1445573metonym
metonyms1545323metonyms
metre74821303met_re_
metred95315143met_red
metrics11312363metrics
metroplex2043443metroplex
metros84217803met_ros
mettle83815723mettle_
mettled103510543mettled
metumps1334133metumps
mezes167719263me__zes
mioses84318853m_ioses
mistypes15116713mistypes
mites75141803mit__es
mitises9315543mitises
mitogen1036963mitogen
mitogens1146973mitogens
mitosis939633mitosis
mitres83922073mit_res
modes85537413m__odes
mojoes15399523mojo_es
mokes114631033m__okes
moles74747923m__oles
momes95134473m__omes
mope86838043m__ope_
moped105424733m__oped
mopeds11499663m__opeds
moper94925923m__oper
mopers104220373m__opers
mopey124821823m__opey
mopokes1536693mopokes
mops85940133m__op_s
mores76249643m__ores
motes75944003m__otes
motiles93317433motiles
motives123611893motives
motored1039933motored
motors84616593moto_rs
mottes85523693mot_tes
mottles93415803mottles
mottoes93412193mottoes
moues75732843m__oues
moves106128423m__oves
mutases92012043mutases
mutates92215793mutates
mutches143314283mutches
mutes75033783mut__es
mutines93117823mutines
mutons84314363muto_ns
mutules9311843mutules
mycoses1437723mycoses
myope124010973m_yope_
myopies14309713m_yopies
myoses114013843m_yoses
myotomes1546233myotomes
neotypes1344523neotypes
netop7312343netop__
nettles73214083nettles
octopus1144803octopus
opes65942613___opes
ostoses71213543ostoses
pekoes124410423peko_es
pentodes11310363pentodes
pentoses10312893pentoses
peones83821043pe_ones
peoples11312213pe_oples
peptones12311033peptones
petioles10311633petioles
petites93820203petites
pettles93916483pettles
peyotes1238483peyotes
popes95933813__popes
pretapes122811533pretapes
pretypes15337253pretypes
ptoses83514673_ptoses
pyropes142210193pyropes
rebops10311423rebop_s
rebores95319163rebores
recipes113314463recipes
recodes102918633recodes
recopies12313723recopies
redoes74623753redo_es
redoxes15310883redoxes
redtops1037373redtop_s
remotes94521613remotes
removes124514713removes
reopen8311573re_open
reopens939373re_opens
reposes94021263reposes
resoles73823653resoles
restokes125213043restokes
restores85222983restores
retakes113718863retakes
retape83917683retape_
retaped103814283retaped
retaxes143615093retaxes
retches123318513retches
retenes76324623retenes
reties65436193ret_ies
retiles74426993retiles
retimes95020173retimes
retines75134673retines
retires74726213retires
retools73411023retools
retore67630763retore_
retorts76016513retorts
retries74129073retries
retunes76918403retunes
retype11399143retype_
retyped13367303retyped
revokes144212503revokes
revotes104716393revotes
rezones163213943rezones
ropes75940063__ropes
scopes104719593_scopes
senores73218113senores
serapes95218103serapes
setoffs1334133setoffs
setons64620173seto_ns
setose65114773setose_
setous64917373seto_us
setouts74110333setouts
settees73513633settees
settles73916003settles
setups83910463setup_s
slopes84820453_slopes
stapes85028733_stapes
steppes113110693steppes
stipes84524053_stipes
stokes104821793_stokes
stoles63927673_stoles
stones65130033_stones
stope74727243_stope_
stoped94721013_stoped
stoper84320093_stoper
stopers94217363_stopers
stops74827283_stop_s
stores65533643_stores
stoves93818923_stoves
stupes84116953_stupes
tapes75838603__tapes
telomes9310533telomes
tetrodes939073tetrodes
toes46956443__to_es
tokes95234973__tokes
toles55147133__toles
tomes76037383__tomes
tones56048663__tones
tope65946383__tope_
toped85631313__toped
topee76029953__topee
topees85519703__topees
toper75231023__toper
topers85025323__topers
tophes115218423__tophes
tophs105220053__tophs
topis76025833__topis
topos75726393__topos
tops66248123__top_s
tores55352673__tores
totes55139683__totes
tropes84824353_tropes
types105721063__types
vetches153411263vetches
vetoed10359823veto_ed
vetoer93410063veto_er
vetoers10359473vetoers
watapes12228383watapes
xenopus1642983xenopus
xeroses143612823xeroses
xeroxes13246443xeroxes
zeroes154314343zero_es

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.1561145455.1
2DLD Change Limit1340273746.76619808.9
3Display Results3743740.1402671.4
 (SQL Overall)1786913747.06225303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.