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

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

101 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
overvaluations206459(None) 
overevaluations2194051overevaluations
overvaluation1965081overvaluation_
overevaluation2074512overevaluation_
devaluations1646353_de_valuations
evaluations1457323__e_valuations
overcautions1755233overca_u_tions
oversaturations1863933oversaturations
overtaxations2353493overta_xations
reevaluations1654273_reevaluations
revaluations1557633_re_valuations
undervaluations1982283undervaluations
devaluation1547074_de_valuation_
evacuations1646304__e_vacuations
evaluation1358184__e_valuation_
misevaluations19133454misevaluations
overactions1648184over_a__ctions
overcaution1655144overca_u_tion_
overcautious1752734overca_u_tious
overeducations2054954overeducations
overinflations20154394overinflations
overpopulations22154124overpopulations
overregulations1963824overregulations
oversaturation1794444oversaturation_
overtaxation2253674overta_xation_
overvaluing1845284overvalu__i_ng
reevaluation1554484_reevaluation_
revaluation1458144_re_valuation_
undervaluation1882684undervaluation_
valuations1348784____valuations
verbalizations2849164_verbalizations
vernalizations2649244_vernalizations
coevolutions1754085coe_volu_tions
dealations11311375_de__al_ations
defalcations1845195_de_falcations
derealizations24910805_derealizations
deregulations1545195_deregulations
devaluating1645055_de_valuati_ng
devastations1645825_de_vastations
devolutions15106265_de_volu_tions
enervations1478575enerv___ations
escalations1347665__escal_ations
evacuation1547165__e_vacuation_
evaluating1456015__e_valuati_ng
evaluators1374595__e_valuat_ors
evolutions13107045__e_volu_tions
exaltations1847295__e_xaltations
exhalations2146015__exhal_ations
graduations1385225__gr_aduations
intercalations1655915intercal_ations
misevaluation18153625misevaluation_
nervations1359485_nerv___ations
observations1785015observ___ations
operations12312935oper____ations
overaction1547985over_a__ction_
overambitious2061835over_ambitious
overassertions17133285overassertions
overattentions17103175overattentions
overdecorations2163695overdecorations
overeducation1955355overeducation_
overestimations20124585overestimations
overexertions23115145over_exertions
overextractions27163225overextractions
overinflation19154555overinflation_
overmedications2363625overmedications
overnutritions1763105overnutritions
overpersuasions20152065overpersuasions
overpopulation21144575overpopulation_
overproductions2363775overproductions
overreactions1854705over_reactions
overregulation1864325overregulation_
oversalting1548575oversal__ti_ng
oversaturating1864035oversaturati_ng
oversecretions1963695oversecretions
overtalkative2361435overtalkati_ve
overvalues1644965overvalu____es
ovulations1337975o___vul_ations
percolations1648025_percol_ations
perpetuations1754975_perpetuations
predevaluation2062385predevaluation_
reescalations1573785reescal_ations
reevaluating1653355_reevaluati_ng
reradiations1349495_rer_adiations
reregulations1455705_reregulations
retaliations12511405_re_taliations
revalidations1747115_re_validations
revaluating1545895_re_valuati_ng
revelations14410305_re_vel_ations
revolutions1497635_re_volu_tions
serializations23710925_serializations
thermalizations2955175thermalizations
transvaluations1863025transvaluations
vallations1339085____vallations
valuation1249975____valuation_
ventilations1547405_ventil_ations
verbalization2769675_verbalization_
verifications21159965_verifications
vermiculations2153885_vermiculations
vernalization25410035_vernalization_
vernations13310325_ver___nations
vesiculations1845315_vesiculations

Search took 8 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 Limit950241017.45312749.8
3Display Results1011010.143706.3
 (SQL Overall)1786911017.71923149.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.