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

92 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
hypercorrection27132191hypercorrection_
hypercorrect2463084hypercorrect____
hypercorrectly2971254hypercorrect__ly
hyperexcretion3172795hyperexcre_tion_
hyperexcretions3282335hyperexcre_tions
hyperproduction2872535hyperproduction_
hypersecretion2463275hypersecre_tion_
hypersecretions2562775hypersecre_tions
overcorrecting2262755_overcorrecti_ng
correction1448816_____correction_
correctional1675326_____correctional
corrections1548866_____corrections
hyperconscious2672136hyperco_nsc_ious
hyperfunction2662836hyper__function_
hyperfunctional2881356hyper__functional
hyperfunctions2762666hyper__functions
hyperrational2153936hype___rr_ational
interconnection1963126interconnection_
apperception1793467apperc___eption_
apperceptions1893037apperc___eptions
correcting15199307_____correcti_ng
hyperborean2153607hyperbo_re___an_
hyperboreans2263307hyperbo_re___ans
hypercalcemia2773237hypercalce_mi__a
hypercatalectic2671337hypercatalecti__c
hypercautious2362677hyperc___autious
hypercritic2365777hyperc__r_iti__c
hypercritical2563517hyperc__r_itical
hypercritics2464917hyperc__r_iti_cs
hyperemotional2461817hype___remotional
hypereutectic2562817hyper_eutecti__c
hypereutectoid2571797hyper_eutect_oid
hyperextension29152777hyper_extension_
hyperextensions30192247hyper_extensions
hyperinflation2572867hyper_inflation_
hyperinflations2682527hyper_inflations
hyperinvolution2671287hyperinvolution_
hyperpyrexia3263337hyper_pyre_xi__a
hyperreactive2663317hyper__reacti_ve
hyperreactor2262577hyper__react_o_r
hyperreactors2362377hyper__react_ors
hypersalivation2662157hypersalivation_
hypertension2084727hype___rtension_
hypertensions2194067hype___rtensions
hyperuricemia25102737hyper_uricemi__a
hypothecation26152917hyp___othecation_
hypothecations27132577hyp___othecations
imperfection2154047impe___rfection_
imperfections2254007impe___rfections
interconnecting2062347interconnecti_ng
misrecollection2171357misrecollection_
overcorrect18144007_overcorrect____
overcorrected2163057_overcorrect__ed
overcorrects19153007_overcorrect___s
overprotection2163617_overprotection_
overprotections2263347_overprotections
perception1688617__perc___eption_
perceptional1854907__perc___eptional
perceptions1798197__perc___eptions
percolation1549227__perco__lation_
percolations1648057__perco__lations
perfection1748367__pe___rfection_
perfections1848147__pe___rfections
perforation1649007__perfo_r_ation_
perforations1747877__perfo_r_ations
peroration12316007__per_o_r_ation_
perorational1446397__per_o_r_ational
perorations13314067__per_o_r_ations
preconception2154287__preconception_
preconceptions2253887__preconceptions
preconvention2074007__preconvention_
preconviction2253707__preconviction_
preconvictions2353357__preconvictions
procreation1547957__p_r_ocreation_
procreations1647277__p_r_ocreations
projection2158767__p_r_o_jection_
projectional2355427__p_r_o_jectional
projections2258477__p_r_o_jections
protection14511477__p_r_o_tection_
protections15510707__p_r_o_tections
protraction1547217__p_r_otraction_
protractions1646647__p_r_otractions
recollection1654857__re_collection_
recollections1754727__re_collections
reconnection1655997__re_connection_
reconnections1765757__re_connections
resurrection1453357__re_surrection_
resurrectional1661757__re_surrectional
resurrections1553467__re_surrections
superconducting23102527superconducti_ng
superinfection2163657super_infection_
superinfections2263417super_infections

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.360496363.9
2DLD Change Limit95024927.86012089.6
3Display Results92920.0631460.3
 (SQL Overall)178691928.28321573.2
 
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.