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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
metamorphically2972031metamorphically_
metamerically2254414metamer__ically_
isomorphically2662745_isomorphically_
metabolically2253265metabo__lically_
metamorphic2255025metamorphic_____
metaphorically2673295metaphor__ically_
meteorically1956815met_eor__ically_
polymorphically3271605polymorphically_
autotrophically2562816autotrophically_
demographically2963886de__mographically_
edaphically2254936_eda___phically_
etymologically2564126_etymologically_
geostrophically2672556geostrophically_
megascopically2661846megascop_ically_
memorially1745656me__mor__i_ally_
mesmerically2154826me_smer__ically_
metallically1954106meta___llically_
metallurgically2371306metallurgically_
metamorphism2084136metamorphi____sm
metamorphisms21113226metamorphi___sms
metaphysically2982666meta_physically_
metastatically2153466meta_statically_
metathetically2454126meta_thetically_
methodically2356156met_ho__dically_
metrically17411086met___r__ically_
metronomically2354556met_ronomically_
monarchically2553546mona__rchically_
motorically1849436mot__or__ically_
orphically2047636_____orphically_
seraphically2256536sera___phically_
trophically2147556__t_ro_phically_
anarchically2254167___anarchically_
atmospherically2791537_at_mospherically_
autographically2663807autographically_
calorically1847777__calor__ically_
catabolically2253007catabo__lically_
cataleptically2362817cata_leptically_
catatonically2054157catato__nically_
categorically21103477categor__ically_
delphically2254767de____lphically_
demagogically2352847demago__gically_
democratically2454067de__mocratically_
demonically1947847de__mo__nically_
diastrophically2672737_diastrophically_
ectopically2047127_e_cto_p_ically_
empathically2464767_e__mpathically_
entomologically2363207entomologically_
entropically1977827_entro_p_ically_
epigraphically2763277_epigraphically_
ethically1748717_et_____hically_
etiologically1955997_et_iologically_
euphorically2254617_euphor__ically_
geographically2664587ge_ographically_
geotropically2154927geotro_p_ically_
graphically2256227_gra___phically_
hierarchically2762217hiera__rchically_
lethargically2272467let_har_gically_
meiotically1849777me__io__tically_
melodically1946637me__lo__dically_
meromorphic2265307meromorphic_____
mesomorphic2254717mesomorphic_____
metaethical1852947meta__ethica_l__
metamorphose2182737metamorph____ose
metamorphosed2371797metamorph___osed
metamorphoses2262477metamorph___oses
metamorphosing2471307metamorph__osing
metamorphosis2262567metamorph___osis
metaphorical2163527metaphor__ica_l__
meteoritical1652957met_eoritica_l__
mitotically1849127mit__o__tically_
mnemonically2155637m_nemo__nically_
moronically1849107____moronically_
morphemically2753827____morphemically_
mutagenically2153027muta__genically_
myopically2246177m___yo_p_ically_
mythically2345847myt_____hically_
mythologically28154957myt_hologically_
oratorically1756377_orator__ically_
orthoepically2353087ort_hoep_ically_
oxymoronically3162077_oxymoronically_
panoramically2274607__panoramically_
pedagogically2353177pedago__gically_
petrologically2256067pet_rologically_
rhetorically2065867rhet__or__ically_
taxonomically2753157__taxonomically_
telegraphically2673297telegraphically_
tetanically1648067teta____nically_
theoretically2186257__theoretically_
theosophically2763167__theosophically_
thoracically2285447__t_horacically_
topically1649537__t__o_p_ically_
topographically28143697__topographically_
tropically1749847__t_ro_p_ically_
typographically31133727__typographically_
xerographically3363647xerographically_

Search took 10 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 Filter178691950240.373479064.3
2DLD Change Limit95024958.79610803.1
3Display Results95950.0631507.9
 (SQL Overall)178691959.23219355.6
 
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.