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

195 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
methyl143640(None) 
ethyl1136511_ethyl
methyls1535451methyls
bethel1169642bethel
bimethyl1841852bimethyl
dimethyl1741912dimethyl
ethyls1235902_ethyls
lethal939802lethal
menthol1236732menthol
meshy135612782meshy_
metal75427382met_al
meth95827842meth__
method1239032method
methoxyl2342742methoxyl
meths105320232meth_s
methylal1644272methylal
methylic1846012methylic
metol75917812met_ol
mothy136214552mothy_
mythy16568672mythy_
tetryl935692tetryl
acetyl11396553acet_yl
aether94213673aether
alphyl1484083alphyl
amethyst1642303amethyst
anethol1045383anethol
bathyal1544823bathyal
benthal1247963benthal
benzyl2034163benzyl
beryl101211673be_ryl
betel74419903bet_el
beth96629233beth__
bethels1238533bethels
beths105519223beth_s
bimethyls1951713bimethyls
bothy136713963bothy_
butyl1089103but_yl
deathly14336863deathly
deathy134210233deathy_
detail74516433detail
dimethyls1851603dimethyls
eth66630983_eth__
ether84518773_ether
ethic101511223_ethic
ethinyl1343433_ethinyl
ethos85514193_ethos
ethoxyl2042353_ethoxyl
eths76619523_eth_s
ethylic1546323_ethylic
ethyne12407153_ethyne
ethynyl1642123_ethynyl
fetal85623373fet_al
fetial95716193fetial
heathy156111213heathy_
heth107028023heth__
heths116317783heth_s
hexyl1844463he_xyl
jetty156212583jetty_
ketol95414003ket_ol
lathy115215063lathy_
lethals1038113lethals
lethe85717303leth_e
lethes94818083lethes
mashy136016503mashy_
matey107022663matey_
mateys115610943mateys
math95437453math__
maths105624023math_s
meal65643173me__al
mealy104422183mealy_
meanly115412043meanly
meany104620483meany_
measly113610443measly
meatal84114733meatal
meatily12311093meatily
meaty107021313meaty_
medal86221333me_dal
medfly1535223medfly
medial93819863medial
meekly1535193meekly
meetly1138673meetly_
meiny104015413meiny_
mel56047483me___l
mell64935613me__ll
melty104918363melty_
menhir1136783menhir
menial84223033menial
mensal84615663mensal
mental84521603mental
menthols1347043menthols
mercy125916183mercy_
merely111312593merely
merl65830973me__rl
merry104721493merry_
mescal104113493mescal
mesh96823003mesh__
meshed124415933meshed
meshes115019443meshes
mesial84818083mesial
mesophyl1844043mesophyl
messy104913833messy_
met56072433met___
meta65932413met__a
metage93114453metage
metals84520893metals
metate82720533metate
mete64438133met__e
meted85424433met_ed
meteor84910073meteor
metepa1066013metepa
meter75130323met_er
meters85625833meters
metes74736213met_es
methane123211793methane
methanol1344643methanol
methods1338893methods
methoxy2243953methoxy
methylals1743683methylals
methylase1744243methylase
methylate1745683methylate
methylene1754773methylene
metical11315363metical
metier83517693metier
meting94320593meting
metis75025903met_is
metols84115773metols
metonym1445573metonym
metope10611123metope
metre74821303met_re
metred95315143metred
metres85121563metres
metric10314683metric
metro74718803met_ro
metros84217803metros
mettle83815723mettle
metump1235713metump
mewl95618323me__wl
mezcal19367853mezcal
mither114218563mither
mitral81314323mitral
mity95528223mit_y_
moghul1244473moghul
mohel104914833m_ohel
monthly1535673monthly
motel76623243mot_el
motey105922953motey_
moth96731333moth__
mother113718643mother
moths106021553moth_s
mouthy14409063mouthy_
muchly1686203muchly
mughal1236273mughal
muhly1358523m_uhly
mushy135316633mushy_
mutely113811653mutely
mutual838503mutual
mutuel837823mutuel
myth126715433myth__
mythic1637273mythic
mythoi14417143mythoi
mythos14398473mythos
myths135911603myth_s
nether94014163nether
nettly9459453nettly
netty85816763netty_
octyl10136063oct_yl
pentyl1138813pentyl
petal76526893pet_al
petrel83111533petrel
petrol82714063petrol
petty105320293petty_
pithy135614463pithy_
retail65522073retail
retell63813643retell
retial64724993retial
retool63914483retool
retral64419743retral
retry84718083retry_
setal56430903set_al
smithy14508273smithy_
techy135612013techy_
tenthly1335743tenthly
tetchy1436003tetchy_
teth76327893teth__
tether93716103tether
teths85418513teth_s
tetryls1034643tetryls
thy97022913__thy_
triethyl1452503triethyl
wether123315393wether
wetly114511713wetly_
withal1238933withal
withy144813763withy_
yechy16519083yechy_
zephyr2342083zephyr

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.373479064.3
2DLD Change Limit1127161955.22021593.1
3Display Results1951950.0603250.0
 (SQL Overall)1786911955.65331609.9
 
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.