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

76 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
oversecretions196373(None) 
oversecretion1863941oversecretion_
hypersecretions2562773hypersecretions
overdecorations2163723overdecorations
overexertions23115193over_exertions
desecrations1559214_de_secrations
hypersecretion2463274hypersecretion_
neurosecretions1771404neurosecretions
overactions1648214over_ac__tions
overassertions17133304overasser_tions
overcautions1755264over__cautions
overdecoration2063944overdecoration_
overexertion22115404over_exertion_
overnutritions1763124overnutritions
overreactions1854724overre_actions
oversaturations1863964oversaturations
overserious1453944overse_r__ious
persecutions1654794_persec_utions
secretions12117854____secretions
cerebrations1646965_cer_ebrations
consecrations1749215_consecrations
desecration14410075_de_secration_
desertions1139885_de_se_r_tions
discretions1447235__dis_cretions
erections112515215__er_ec__tions
eviscerations1882705ev_iscerations
excretions1946625__e__xcretions
execrations2048925__e_xecrations
exsections1947635__exsec__tions
exsertions1746745__exse_r_tions
hyperexcretions3282335hyperexcretions
indiscretions1652595indis_cretions
intersections1598965intersec__tions
ivermectins1852865ivermec__ti_ns
neurosecretion1671525neurosecretion_
overaction1547995over_ac__tion_
overassertion16113515overasser_tion_
overattentions17103185overattentions
overcaution1655155over__caution_
overcautious1752745over__cautious
overdecorating2153685overdecorati_ng
overeducations2054985overeducations
overestimations20124605overestimations
overexerting2346495over_exerti_ng
overextensions2463175over_extensions
overextractions27163255overextractions
overinflations20154415overinflations
overmedications2363665overmedications
overnutrition1663385overnutrition_
overprotections2263345overprotections
overreaction1754925overre_action_
overregulations1963855overregulations
oversaturation1794465oversaturation_
overseeding1647005overse__edi_ng
overseeing1438385overse__e_i_ng
overservices2093365overse_r_vices
oversetting1548815overse__tti_ng
overspeculation2263335overspeculation_
overstrains1447165overs_tr_ai_ns
overstretches2181985overs_tretches
overstrewing1944675overs_trewi_ng
oversweetens1852865overs_weet_ens
overtaxations2353515over_taxations
overvaluations2064615overvaluations
perfections1848145_perfec__tions
perpetrations1746375_perpetrations
persecution1564785_persec_ution_
perseverations1953245_perseverations
perspirations1786175_perspirations
recreations13412255___r_ecreations
resections121513035_re_sec__tions
reverberations19113585reverbe_rations
secretins11108465____secreti_ns
secretion11118305____secretion_
venerations14411315_ve_ne_rations
venesections1752935_venesec__tions

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.390458182.1
2DLD Change Limit95024766.50014619.1
3Display Results76760.0631206.3
 (SQL Overall)178691766.95325699.8
 
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.