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 “methanations” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
methanations174397(None) 
methanation1644531methanation_
methylations2053682methylations
detonations1239373det_onations
emanations1289593_e_manations
exhalations2146023_exhalations
machinations19115763machinations
mechanizations3055813mechanizations
methylation1954413methylation_
metrications1649833metrications
alternations1246774alternations
botherations1754194botherations
catenations1348364cat_enations
dealations11311374de__alations
deaminations151010134deaminations
decantations1547944de_cantations
declamations1745304declamations
declarations1546804declarations
declinations15410224declinations
defamations1745894de_famations
degradations1544554degradations
depravations1885374depravations
designations1456944designations
destinations13412664destinations
detentions11148804det_en_tions
detestations1347584detestations
detonation11310944det_onation_
detractions14118274detra_ctions
emanation11910784_e_manation_
enations83316904_e___nations
escalations1347664_escalations
etiolations1147394_etiolations
euthanatizes2452124euthanatizes
excavations2345084_excavations
exhalation2046654_exhalation_
exhaustions2153124_exhaustions
exhumations2344084_exhumations
explanations2144624explanations
fetations12511384fet___ations
geminations14139254ge_minations
germinations15137944germinations
halations12312394___halations
hyphenations2393524hyphenations
inhalations14126744_inhalations
intonations1149524int_onations
machination18106824machination_
marginations1546454marginations
marinations13411274m_arinations
maturations1348444mat_urations
mechanicians2162354mechanicians
mechanization2956324mechanization_
mediations13310984me__diations
medications1649934me_dications
meditations1449334me_ditations
melanizations2449364me_lanizations
meliorations1466754meliorations
mensurations1445714mensurations
mentations12312584me__ntations
mentions10312894me___n_tions
mercurations1646564mercurations
metafictions1952654metafictions
methadons1544424meth__a_dons
methanols1444874methan___ols
methenamine1883764methenami_ne
methenamines1963384methenamines
methylating2054454methylati_ng
methylators1953294methylat_ors
metrication15410654metrication_
mitigations1447624mit_igations
motivations1647094mot_ivations
mutations111211454mut___ations
mutilations1348644mut_ilations
patinations13411004pat_inations
pectinations1649254pectinations
perennations1447254perennations
personations1448394personations
phonations1538314__phonations
planations1238724__planations
profanations17175254profanations
recantations1448874re_cantations
reclamations1645714reclamations
relaxations1845644re_laxations
reparations13611664re_parations
replantations1544864replantations
resignations1346884resignations
retaliations12511404retaliations
retardations1396514retardations
retentions101611114ret_en_tions
retractions13910354retra_ctions
retranslations1454214retranslations
separations1369274se_parations
stagnations1244904_stagnations
tarnations1038904__tarnations
taxations1636864__t_axations
terminations14149764terminations
tetanizations2249914tet_anizations
thanatos1165124__thanat_o_s
trepanations1444574trepanations
trephinations1853554trephinations
venations12311724ve___nations
vernations13310334ve__rnations

Search took 7 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 Filter1786911247900.393454684.5
2DLD Change Limit1247901016.31019776.5
3Display Results1011010.0631603.2
 (SQL Overall)1786911016.76626410.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.