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

137 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
methanes13381216(None) 
ethanes103713511_ethanes
methane123211791methane_
bethanks1765312bethanks
cetanes9315132cet_anes
ethane94613242_ethane_
ethenes103313872_ethenes
ethynes13377572_ethynes
menthenes1447702menthenes
metages102714972met_ages
metates92720012met_ates
methadones1644162methadones
methanol1344642methanol
methanols1444872methanols
methinks1775192methinks
thanes94918982__thanes
urethanes1245162urethanes
bechances1847613bechances
behaves15198523be_haves
beshames1537203beshames
betaines10313293betaines
betakes134212523bet_akes
bethank1666273bethan_k
bethanked1943283bethanked
bethinks1765043bethinks
butanes9312743but_anes
cetane8315283cet_ane_
decanes103118913de_canes
deplanes11311213deplanes
dethrones1347313dethrones
emetines10611053emet_ines
emphases1568353emphases
emplanes1239503emplanes
enhances1339293_enhances
etapes85415293_et_apes
etchants1346023_etchants
ethanol1044593_ethanol
ethanols1144333_ethanols
ethene93312923_ethene_
ethnos947053_eth_nos
ethoses10311763_ethoses
ethyne12407153_ethyne_
exhales1737143_exhales
fetiales11319613fetiales
henbanes1336573henbanes
heptanes1339003heptanes
hetmans12187593hetman_s
hexanes17319463he_xanes
ketenes114813503ket_enes
ketones115014503ket_ones
lethals1038113letha_ls
lethes94818083leth__es
machines15312893machines
manes76648963m___anes
meaner84617843me__aner
meaners94415243me__aners
meanest9315703me__anest
meanies93620743me__anies
means75831233me__an_s
mechanic1747613mechanic
mechanics1845983mechanics
mechanism1846563mechanism
mechanist1648743mechanist
mechanizes2646773mechanizes
medians103214213median_s
mediants11299493mediants
mediates112814063mediates
melanges1138613me_langes
meltages1148243meltages
membranes1545563membranes
menaces112715523me_naces
menages103615393me_nages
menhaden1444213menhaden
menhadens1543003menhadens
menthene1347033menthene_
merchants1646213merchants
mesdames1346043mesdames
meshes115019443mesh__es
mesnes85216213me__snes
messages1138233messages
messans92710463messan_s
metage93114453met_age_
metaled102913883met_aled
metals84520883met_a_ls
metamer1139613met_amer
metamers1249623met_amers
metaphases1745053metaphases
metate82720533met_ate_
meterages1248183meterages
metes74736213met___es
methadon1444523methadon
methadone1544433methadone_
methadons1544423methadons
methods1338883meth_ods
meths105320233meth___s
methylases1844263methylases
methylates1845473methylates
methylenes1854593methylenes
methyls1535453meth_yls
metisses1036833metisses
metopes11311363met_opes
metres85121563met__res
mettles94115023met_tles
montanes101114523montanes
mutants938583mut_ants
mutases92012043mut_ases
mutates92215793mut_ates
mutines93117823mut_ines
octanes91111393oct_anes
pechans14810503pechan_s
pentanes10316083pentanes
petrales10312983petrales
recanes93222263re_canes
rechanges1568183rechanges
rehangs1137563re_hangs
reshapes1338803reshapes
reshaves1438733reshaves
reshines112615443reshines
retakes113718863ret_akes
retapes93917423ret_apes
retaxes143615093ret_axes
retenes76324623ret_enes
rethinks1576033rethinks
retines75134673ret_ines
retraces101417273retraces
retunes76918403ret_unes
setlines8312743setlines
stanes64933403_st_anes
terranes82514433terranes
tetanies8513553tet_anies
tetanus737933tet_anus
thane86122533__thane_
thanks134313133__thanks
urethane1145433urethane_
urethans1145243urethan_s
wetlands1244763wetlands
wetwares1445953wetwares

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.1561145455.1
2DLD Change Limit1461621377.75018859.6
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.96922423.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.