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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
overprotections2263341overprotections_
overprotection2163612overprotection__
overproductions2363783overproductions_
overprotecting2263193overprotecti_n_g
overproduction2264054overproduction__
overproportions2272544overproportions_
overprotective2472494overprotecti__ve
overprotects1953034overprotect___s_
overattentions17103185over_attentions_
overproportion2172685overproportion__
overprotect1854575overprotect_____
overprotected2162845overprotect___ed
overreactions1854725over_r_eactions_
protections15510705____protections_
overactions1648216ove__r__actions_
overassertions17133306over_assertions_
overattention16113236over_attention__
overcorrecting2262756overcorrecti_n_g
overexertions23115196ove__rexertions_
overextensions2463176over_extensions_
overextractions27163256overextractions_
overnutritions1763126over_nutritions_
overplotting1845046overplot__ti_n_g
overpopulations22154146overpopulations_
overprecise1854886overpr__ec_i__se
overprocessing2262856overprocessi_n_g
overproducing2253546overproduc_i_n_g
overpromoting2153966overpro_moti_n_g
overreaction1754926over_r_eaction__
oversecretions1963736oversecre_tions_
preproductions2153946pre_productions_
projections2258476____projections_
protection14511476____protection__
protectionism1984946____protectionism
protectionist17116686____protectionist
reproductions1865276_re_productions_
coproductions2054497__coproductions_
corrections1548867_cor_r__ections_
deportations1548467_de_port_ations_
deprecations1748567_de_pr__ecations_
detections131410047_de____tections_
erections112515217__e__r__ections_
exportations2146657__export_ations_
hyperproduction2872537hyperproduction__
interpretations17134807interpret_ations_
introjections2255787__introjections_
ivermectins1852867ive__r_mecti_ns_
microprojection3072657microprojection__
overaction1547997ove__r__action__
overassertion16113517over_assertion__
overcautions1755267ove__r_cautions_
overconscious2062407over_consc_ious_
overcorrects19153007overcorrect___s_
overdecorations2163727overdecorations_
overdirecting2053747over_directi_n_g
overeducations2054987over_educations_
overemotional1861927overemo___tional
overestimations20124607overestimations_
overevaluations2194077overevaluations_
overexertion22115407ove__rexertion__
overextension2363287over_extension__
overextraction26153547overextraction__
overinflations20154417over_inflations_
overmedications2363667overmedications_
overnutrition1663387over_nutrition__
overpersuasions20152087overpersuasions_
overpopulation21144587overpopulation__
overpotent1548057overp_ote____n_t
overpowering2144467overp_owe_ri_n_g
overprescribes2382037overpr_escribes_
overpricing1947737overpr__ic_i_n_g
overprinting1846877overpr__inti_n_g
overprocess1853957overpro__c___ess
overprocesses2072977overpro__cesses_
overproduces2053527overproduc___es_
overprograming2362537overprogrami_n_g
overpromise1854817overpro___mi__se
overpromises1954247overpro___mises_
overpromising2153967overpro_misi_n_g
overpromotes1963367overpro_mot__es_
overreacting1856667over_r_eacti_n_g
overregulations1963857overregulations_
overroasting1646097over_ro_asti_n_g
oversaturations1863967oversaturations_
oversecretion1863947oversecre_tion__
oversolicitous19201067over_solicitous_
overtaxations2353517ove__rtaxations_
overtreating1648557overtr__eati_n_g
overvaluations2064617over_valuations_
ovipositions1753567ov_ip_o_sitions_
perfections1848147_pe__r_fections_
perpetrations1746377_perp_etrations_
perpetuations1754987_perp_etuations_
postproductions2272507postproductions_
prelections151210477____prelections_
preproduction2054397pre_production__
proactions1449347____pro_actions_
productions1647537____productions_
projection2158767____projection__
projectional2355427____projectional
projectionist2485257____projectionist
prosecutions1645617____prosecutions_
protecting151910217____protecti_n_g
protectionisms2094027____protectionisms
protectionists18105147____protectionists
protectors142010147____protect_ors_
protractions1646647____protractions_
radioprotection2081347radioprotection__
redirections1546177_redir__ections_
reexportations2352847reexport_ations_
reprobations1647777_re_pro_bations_
reproduction1765657_re_production__
resurrections1553467_resur_rections_
retroactions1447077_re_tro_actions_
retrodictions1655537_re_trodictions_
retroflections1953877_re_troflections_
retrospections1894177_re_trospections_
underproduction2171987underproduction__
venesections1752937_ve__nesections_

Search took 10 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 Limit950241198.81010785.9
3Display Results1191190.0961239.6
 (SQL Overall)1786911199.29619222.4
 
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.