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

81 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
hyperexcretions3282331hyperexcretions_
hyperexcretion3172792hyperexcretion__
hypersecretions2562773hypersecretions_
hypersecretion2463274hypersecretion__
hyperextensions30192245hyperextensions_
excretions1946626_____excretions_
hypercautious2362676hyper__cautious_
hypercorrection27132196hypercorrection__
hypercriticism28112876hyper__criticism
hypercritics2464916hyper__criti_cs_
hyperemotional2461816hypere__motional
hyperexcitement34151426hyperexcitemen_t
hyperextension29152776hyperextension__
hyperfunctions2762666hyper_functions_
hyperinflations2682526hyperinflations_
hyperrational2153936hyper___rational
overexertions23115196_overexer_tions_
oversecretions1963736_oversecretions_
apperceptions1893037apper__ceptions_
appreciations1964757_appre_ciations_
cerebrations1646967__cere_brations_
decerebrations1993747decere_brations_
deprecations1748567dep_re_c_ations_
depreciations1846577dep_re_ciations_
desecrations1559217__dese_crations_
erections112515217___ere_c__tions_
excretion1846717_____excretion__
execrations2048927___exe_crations_
hydroxylations3163117hy_droxylations_
hyperactives2555277hyper_ac__tives_
hyperacuities2364577hyper_acuiti_es_
hyperboreans2263307hyper_bore__ans_
hypercritic2365777hyper__criti___c
hypercritical2563517hyper__criti_cal
hypercriticisms29111947hyper__criticisms
hyperenergetic2571667hyperenergeti___c
hyperesthesia24123947hyperesthesi___a
hyperesthesias25133497hyperesthesi_as_
hyperesthetic2683607hyperestheti___c
hyperexcitable3371467hyperexc_it_able
hyperexcited3063517hyperexc___i_ted
hyperextend2753377hyperex___t_en_d
hyperextending3162067hyperex_tendin_g
hyperextends2863057hyperex___t_ends
hyperfunction2662837hyper_function__
hyperfunctional2881357hyper_functional
hyperinflation2572867hyperinflation__
hypermetropia2562877hyper___metropia
hyperpyrexia3263337hyper_pyrexi___a
hyperpyrexias3363037hyper_pyrexi_as_
hyperreactors2362377hyperreac__t_ors_
hypertensions2194067hyper__tensions_
hypertonia18108067hyp__e__r_t_onia
hyphenations2393527hyp_he__nations_
hypothecations27132577hypothec_ations_
imperfections2254007imperfec__tions_
imprecations1846277imp_re_c_ations_
overexertion22115407_overexer_tion__
overextractions27163257_overextractions_
oversecretion1863947_oversecretion__
penetrations1448857__pene_trations_
perceptions1798197__per__ceptions_
perennations1447257__pere_nnations_
perfections1848147__perfec__tions_
perforations1747877__per_forations_
perorations13314067__per__orations_
perpetrations1746377__perpetrations_
persecutions1654797__persec_utions_
perseverations1953247__perseverations_
perspirations1786177__perspirations_
precautions1546557__p_re_cautions_
preparations1648317__p_reparations_
preportions1548267__p_repor_tions_
prescriptions19135337__p_rescriptions_
procreations1647277__p_r_ocreations_
recreations13412257____re_creations_
secretions12117847____se_cretions_
superelevations2062767superelevations_
supererogations1862837supererogations_
supernutritions1763437supernutritions_
superscriptions2163347super_scriptions_

Search took 9 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.1231452772.4
2DLD Change Limit95024817.84612111.1
3Display Results81810.0601350.0
 (SQL Overall)178691818.02922255.7
 
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.