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

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

52 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
hypercorrection2713219(None) 
hypercorrect2463083hypercorrect___
hypercorrectly2971253hypercorrect_ly
hyperexcretion3172794hyperexcre_tion
hyperproduction2872534hyperproduction
hypersecretion2463274hypersecre_tion
correction1448815_____correction
hyperexcretions3282335hyperexcre_tions
hyperfunction2662835hyper__function
hypersecretions2562775hypersecre_tions
interconnection1963125interconnection
overcorrecting2262755_overcorrecting
apperception1793466apperc___eption
corrections1548866_____corrections
hyperborean2153606hyperbo_re___an
hypercatalectic2671336hypercatalecti_c
hyperconscious2672136hyperco_nsc_ious
hypercritic2365776hyperc__r_iti_c
hypercritics2464916hyperc__r_itics
hypereutectic2562816hyper_eutecti_c
hypereutectoid2571796hyper_eutectoid
hyperextension29152776hyper_extension
hyperfunctions2762666hyper__functions
hyperinflation2572866hyper_inflation
hyperinvolution2671286hyperinvolution
hyperreactive2663316hyper__reactive
hyperreactor2262576hyper__react_or
hypersalivation2662156hypersalivation
hypertension2084726hype___rtension
hypothecation26152916hyp___othecation
imperfection2154046impe___rfection
misrecollection2171356misrecollection
overcorrect18144006_overcorrect___
overcorrected2163056_overcorrect_ed
overcorrects19153006_overcorrect__s
overprotection2163616_overprotection
perception1688616__perc___eption
percolation1549226__perco__lation
perfection1748366__pe___rfection
perforation1649006__perfo_r_ation
peroration12316006__per_o_r_ation
preconception2154286__preconception
preconvention2074006__preconvention
preconviction2253706__preconviction
procreation1547956__p_r_ocreation
projection2158766__p_r_o_jection
protection14511476__p_r_o_tection
protraction1547216__p_r_otraction
recollection1654856__re_collection
reconnection1655996__re_connection
resurrection1453356__re_surrection
superinfection2163656super_infection

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.343520965.0
2DLD Change Limit95024527.65612411.7
3Display Results52520.0301733.3
 (SQL Overall)178691528.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.