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

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

41 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
methodology218319(None) 
meteorology1763342meteorology
ethnology1645693_eth_nology
ethology1547253_eth__ology
methodologies2053483methodologies
methodologist2054313methodologist
metrology1546803met__rology
mythology2145793myth__ology
aetiology1346424aet__iology
anthology1646794anth__ology
anthropology2163544anthropology
cetology1477604cet___ology
cohomology2153334_cohomology
demonology1744384de_monology
entomology1654234_entomology
etiology1236444_et__iology
etymology1844754_et_ymology
fetology1566444fet___ology
geohydrology2461554geohydrology
homology1738414___homology
horology1548124___horology
lithology1645444lith__ology
menology14218484me___nology
meteorologic1763174meteorologic
methodological2353304methodological
methodologists2153474methodologists
monology142310114m___onology
nephology1865964neph__ology
nephrology1944224neph_rology
pathobiology2362964pathobiology
pathology1846934path__ology
pedology15216904pe___dology
petrology1547334pet__rology
phonology1847164__phonology
pteridology1852594pteridology
technology1944914tech_nology
theology1536894__th_eology
tocology14107384__t_ocology
tokology1655704__t_okology
topology1467214__t_opology
tropology1546424__tropology

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 Filter1786911488190.423422437.4
2DLD Change Limit148819419.11016335.8
3Display Results41410.0133153.8
 (SQL Overall)178691419.54618718.9
 
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.