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

378 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
metope1061112(None) 
metopae1147741metopae
metopes11311361metopes
elope75219342_elope
etape74413702_etape
ketone105014532ketone
ketose105711812ketose
metage93114452metage
metate82720532metate
mete64438132met__e
metepa1066012metepa
metol75917812meto_l
metols84115772metols
metopic1339762metopic
metopon11137072metopon
metre74821302met_re
mettle83815722mettle
mope86838042m__ope
myope124010972m_yope
netop7312342netop_
netops839212netops
retape83917682retape
retore67630762retore
retype11399142retype
setose65114772setose
stope74727242_stope
tope65946382__tope
acetone9310793acetone
acetose938843acetose
aerobe8412403aerobe
aslope839013aslope
atone56527983_atone
atop66124753_atop_
atopy106813393_atopy
autopen947123autopen
bebop11410793bebop_
bebops1237623bebops
become123312593become
before11410153before
begone9512133begone
behove14207203behove
betake124512703betake
betide95115973betide
betime105914833betime
betise85616273betise
betoken13386503betoken
beton76022063beto_n
betons84919553betons
betony114211583betony
betook12439603betook
biotope1146623biotope
cenote83715843cenote
cepe84926653ce__pe
cestode1037963cestode
cetane8315283cetane
cete64934783cet__e
citole8311503citole
cope86847383__cope
cotype1346823cotype
debone93714783debone
decode104414743decode
demode104013463demode
demote94817803demote
denote74118043denote
depone93616553depone
depose94215763depose
detour778193detour
detox13310953deto_x
detoxed1636103detoxed
detoxes1538803detoxes
devote104513783devote
dope76038893__dope
ectype1334283ectype
eloped95914143_eloped
eloper85414153_eloper
elopes85918163_elopes
emetine9712943emetine
emmetrope1552173emmetrope
emote75421193_emote
epitope1147053epitope
epode85114093_epode
epopee10312503_epopee
erode64520993_erode
erose55727273_erose
estop74312103estop_
estops84011223estops
etapes85415293_etapes
etoile6312263_etoile
etude63612303_etude
etwee84115333_etwee
evoke12478853_evoke
fete75734923fet__e
fetor81214533feto_r
fetors91014473fetors
fettle93713123fettle
gemote94613023gemote
genome94312193genome
geode7412593ge_ode
getup83410263getup_
getups9346853getups
grope84821613_grope
heptose1237493heptose
hexone16289233hexone
hexose16267843hexose
hope96639673__hope
intone61115423intone
isotope9227783isotope
jete115927253jet__e
jeton124815403jeto_n
jetons134512613jetons
ketene106613003ketene
keto86223453keto__
ketol95414003keto_l
ketols104210763ketols
ketones115014503ketones
ketoses114912873ketoses
kettle104311613kettle
leone55018823le_one
lethe85717303let_he
letup73712163letup_
letups8317683letups
lope65941923__lope
mahoe10315573maho_e
maltose939783maltose
manrope1138033manrope
mate65154213mat__e
matte75626843mat_te
mature8313463mature
meagre9349323meagre
mealie82519803mealie
meanie83718393meanie
measle83513223measle
meddle103312763meddle
mediae94217413mediae
megohm14124193megohm
meikle1236653meikle
meinie82614523meinie
meioses9310833meioses
melee73729103me_lee
melody1237203melody
meloid9615993meloid
melon73922083melo_n
melons84117713melons
meltage1037953meltage
melton8311553melto_n
meltons9410923meltons
meme85330553me__me
memo85924793memo__
memoir1037213memoir
memory1338803memory
memos95719113memo_s
menace103216943menace
menage93216543menage
meno66031353meno__
mensae84114043mensae
mense75025633me_nse
mentee84121293mentee
mentor8414363mento_r
mentored1138003mentored
mentors9314993mentors
meou65325863me_o_u
meoued9118533me_oued
meous76120063me_ous
meow95117883me_o_w
meowed12148003me_owed
meows104612683me_ows
merde84320123me_rde
mere67244443me__re
merge84523683me_rge
mergee94018133mergee
merle75824373me_rle
meropia1149613meropia
meropic13310263meropic
mesne75116293me_sne
meson74118313meso_n
mesons83215843mesons
mestee84523883mestee
met56072433met___
meta65932413met__a
metages102714973metages
metal75427383met_al
metaled102913873metaled
metals84520883metals
metamer1139613metamer
metates92720003metates
meted85424433met_ed
meteor84910073meteor
meteors94610013meteors
metepas1136303metepas
meter75130323met_er
metered103514013metered
meters85625833meters
metes74736213met_es
meth95827843met__h
methane123211793methane
method1239023method
methods1338883methods
methoxy2243943methoxy
meths105320233met_hs
methyl1436403methyl
metier83517693metier
meting94320593meting
metis75025903met_is
metisse936503metisse
metonym1445573metonym
metopons12107023metopons
metred95315143metred
metres85121563metres
metric10314673metric
metro74718803met_ro
metroplex2043443metroplex
metros84217803metros
mettled103510543mettled
mettles94115023mettles
metump1235713metump
metumps1334133metumps
meze154420903me__ze
mistype14126523mistype
mite66249403mit__e
mitogen1036963mitogen
mitoses9312183mitoses
mitre75522423mit_re
mode75840303m__ode
moke106234223m__oke
mole66251833m__ole
mome85239353m__ome
moose76327193m_oose
mop76950823m__op_
moped105424733m__oped
moper94925923m__oper
mopes95134983m__opes
mopey124821823m__opey
mopoke1436633mopoke
mops85940133m__ops
mopy115721973m__opy
more67154523m__ore
morose85116243morose
mote67048083m__ote
motile83818343motile
motive113112143motive
motor75317293moto_r
motored1039933motored
motors84616593motors
motte75526973mot_te
mottle84116053mottle
moue65835573m__oue
move96630723m__ove
mucose10149313mucose
mutase82811983mutase
mutate83017483mutate
mute65136873mut__e
mutine84420373mutine
muton73817003muto_n
mutons84314363mutons
mutule8311423mutule
myopes13419963m_yopes
myopy15457353m_yopy
myotome1445483myotome
neotype1244593neotype
nettle64514583nettle
nope65934193__nope
octopi1036533octopi
ope56845243___ope
pekoe114612363peko_e
pentode1039893pentode
pentose9311593pentose
people10310183pe_ople
peptone11310763peptone
petiole9311303petiole
petite84320653petite
pettle84116053pettle
peyote1139853peyote
pope85535613__pope
pretape113511623pretape
pretype14387483pretype
pyrope132810533pyrope
rebop9313283rebop_
rebops10311423rebops
rebore86625643rebore
recipe103414893recipe
recode93618713recode
recopy1339043recopy
recoupe11109933recoupe
redone74820053redone
redtop937973redtop_
redtops1037373redtops
remote84222603remote
remove116115573remove
reopen8311573re_open
repose84121413repose
rerose63320843rerose
resole64624183resole
restoke116113903restoke
restore75822973restore
retake104718533retake
retaped103814283retaped
retapes93917423retapes
rete44944133ret__e
retene69224273retene
retie55735303ret_ie
retile65929673retile
retime85321803retime
retine66237333retine
retire64927013retire
retold73013753retold
retook104313443retook
retool63914483retool
retorn610923423retorn
retort66831143retort
retune69121953retune
retuse66617223retuse
retyped13367303retyped
retypes12308623retypes
revoke135216243revoke
revote94917453revote
rewoke1339521213rewoke
rewore938030153rewore
rewove126420073rewove
rezone153814783rezone
rope65542913__rope
scope94821483_scope
serape84818413serape
setae56026223set_ae
setoff1238913setoff
seton55223543seto_n
setons64620173setons
setous64917373setous
setout64719463setout
settee63721023settee
settle63915663settle
setup73915823setup_
setups83910463setups
slope75823563_slope
steppe10319873steppe
stipe76523373_stipe
stoae55024263_stoae
stoke94922513_stoke
stole54928813_stole
stone55431183_stone
stop66532033_stop_
stoped94721013_stoped
stoper84320093_stoper
stopes84525893_stopes
stops74827283_stops
stopt76528353_stopt
store56333813_store
stove85220253_stove
stupe75217753_stupe
tape64538143__tape
telome8311923telome
tetrode839333tetrode
toe310166853__to_e
toke86738493__toke
tole46052903__tole
tome67543193__tome
tone46953743__tone
top510560683__top_
toped85631313__toped
topee76029953__topee
toper75231023__toper
topes76941763__topes
toph96326873__toph
tophe106718973__tophe
topi67830393__topi
topo66932403__topo
tops66248123__tops
tore47359323__tore
tote46643673__tote
trope75725803_trope
type96223743__type
uptore8279453uptore
veloce11310133veloce
venose9310843venose
veto76622993veto__
vetoed10359823vetoed
vetoer93410063vetoer
vetoes92914083vetoes
watape11208483watape

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163785.48320557.4
3Display Results3783780.1263000.0
 (SQL Overall)1786913785.74931082.1
 
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.