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

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

49 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
heterotrophies226322(None) 
heterotrophic2363752heterotrophi_c
heterotrophs2063992heterotroph__s
heterotroph1964093heterotroph___
heterotrophy2363393heterotroph__y
hypertrophies2693423hyper_trophies
autotrophies1756034aut__otrophies
heterodoxies2353834hetero_do_xies
heterogonies16104814hetero_go_nies
heteromorphic2563314heteromorphi_c
heteromorphism2673034heteromorphism
heteromorphisms2792264heteromorphisms
heteronomies1755384hetero_no_mies
heterophonies2164094heteropho_nies
heteroploidies2072334heteroploidies
heterospories1863744heterospo_ries
heterotopic18125304heterot_op_i_c
hypertrophied2792524hyper_trophied
luteotrophins1862714lute_otrophins
petrographies2157144pet_rographies
arteriographies2172745arteriographies
auxotrophies2453955__auxotrophies
azeotropies2254035_aze_otrop_ies
electrophiles2055115_ele_ctrophiles
ethnographies2254935_ethnographies
eutrophies1556515___e_utrophies
exstrophies2353715___exstrophies
heliotropes1654045he_liotrop__es
heterogameties2072205heterogameties
heterogamies1854675hetero__gamies
heterogenies1695565hetero__genies
heterophil1895665hete___rophi_l
heterophile19135275hete___rophile
heterophyllies2592315heterophyllies
heteroploids18124805heteroplo__ids
heterotypic21124515heterot_yp_i_c
hydrographies2675805h_ydrographies
hypertrophic2763685hyper_trophi_c
hysterotomies2162435hysterot_o_mies
luteotrophic1963275lute_otrophi_c
luteotrophin1763165lute_otrophi_n
luteotropins1463135lute_otrop_ins
pleiotropies1653725_pleiotrop_ies
prototrophies2064665_prototrophies
reprographies2196095re_prographies
stenographies19125315_stenographies
stereographies2054245_stereographies
thyrotrophins2462955_thyrotrophins
xerographies2586715__xerographies

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 Filter178691950240.360496363.9
2DLD Change Limit95024496.47014686.9
3Display Results49490.0301633.3
 (SQL Overall)178691496.86026048.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.