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

155 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
methane12321179(None) 
ethane94613241_ethane
methanes133812161methanes
bethank1666272bethank
cetane8315282cet_ane
ethanes103713512_ethanes
ethene93312922_ethene
ethyne12407152_ethyne
menthene1347032menthene
metage93114452met_age
metate82720532met_ate
methadone1544432methadone
methanol1344642methanol
thane86122532__thane
urethane1145432urethane
bechance1747743bechance
behave14209013be_have
beshame1447483beshame
betaine9413783betaine
betake124512703bet_ake
bethanked1943283bethanked
bethanks1765313bethanks
bethink1677203bethink
butane8313653but_ane
cetanes9315133cet_anes
decane93818873de_cane
deplane10311413deplane
dethrone1247563dethrone
emetine9712943emet_ine
emplane11410013emplane
enhance1239693_enhance
etape74413703_et_ape
etchant1249823_etchant
eterne6311723_eterne
ethanol1044593_ethanol
ethenes103313873_ethenes
ethynes13377573_ethynes
exhale1636873_exhale
germane1049663germane
henbane1237353henbane
heptane1238363heptane
hetman112510603hetman_
hetmans12187593hetmans
hexane16379533he_xane
ketene106613003ket_ene
ketone105014533ket_one
lethal939803letha_l
lethals1038113lethals
lethe85717303leth__e
lethean1037093lethean_
machine14313493machine
mane65052033m___ane
mean65538093me__an_
meaner84617843me__aner
meanie83718393me__anie
means75831233me__ans
meant76537213me__ant
meany104620483me__any
meatman1137903meatman_
mechanic1747613mechanic
mechanize2547073mechanize
mediae94217413media_e
median94117543median_
medians103214213medians
mediant103516703mediant
mediate103415213mediate
melange1038363me_lange
meltage1037953meltage
membrane1445653membrane
menace103216943me_nace
menage93216543me_nage
menhaden1444213menhaden
mensae84114053mensa_e
menthenes1447703menthenes
merchant1548823merchant
merman10513863merman_
meshing134513813meshing
mesian84315503mesian_
mesne75116293me__sne
message1037833message
messan83912063messan_
messans92710463messans
meta65932413met_a__
metages102714973met_ages
metal75427383met_a_l
metaled102913883met_aled
metals84520893met_als
metamer1139613met_amer
metaphase1644963metaphase
metates92720013met_ates
mete64438133met___e
meterage1147933meterage
meth95827843meth___
methadon1444523methadon
methadones1644163methadones
methadons1544423methadons
methanols1444873methanols
methinks1775193methinks
method1239033meth_od
methods1338893methods
methoxy2243953methoxy
meths105320233meth__s
methyl1436403meth_yl
methylase1744243methylase
methylate1745683methylate
methylene1754773methylene
methyls1535453methyls
meting94320593met_ing
metisse936503metisse
metopae1147743metopae
metope10611123met_ope
metre74821303met__re
metring103215293metring
mettle83815723met_tle
montane91313623montane
mundane1038073mundane
mutant8317693mut_ant
mutase82811993mut_ase
mutate83017483mut_ate
mutine84420373mut_ine
octane81411633oct_ane
pechan13511543pechan_
pechans14810503pechans
pentane9415743pentane
petrale9312623petrale
recane83022873re_cane
rechange1458183rechange
rehang1039823re_hang
reshape1249043reshape
reshave1338603reshave
reshine102816943reshine
reshone102414163reshone
retake104718533ret_ake
retape83917683ret_ape
retene69224273ret_ene
rethink1488883rethink
retinae75517333retinae
retine66237333ret_ine
retrace91417343retrace
retune69121953ret_une
setae56026223set_a_e
setline7313923setline
stane55933003_st_ane
terrane72814233terrane
tetany959843tet_any
thae76825563__tha_e
than76128773__than_
thanes94918983__thanes
thank125817803__thank
thine85026863__thine
urethan1045473urethan_
urethanes1245163urethanes
urethans1145243urethans
wetland1135353wetland
wetware1335793wetware

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.390458182.1
2DLD Change Limit1340271556.54620474.6
3Display Results1551550.0463369.6
 (SQL Overall)1786911556.98225593.1
 
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.