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

48 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
overapplication2462391overapplication_
reapplication1954724_re_application_
reapplications2054254_re_applications
application1747475____application_
applications1846775____applications
misapplication2263345_misapplication_
misapplications2363075_misapplications
overmedication2263985over_medication_
overmedications2363635over_medications
overutilization2762675overutilization_
eradication14410116__era__dication_
eradications1549296__era__dications
explication2248456__e__xplication_
explications2347536__e__xplications
overaction1547986overa____c_tion_
overactions1648186overa____c_tions
overcultivation2361566overcultivation_
overeducation1955356over__education_
overeducations2054956over__educations
overestimation19125136over_estimation_
overestimations20124586over_estimations
overevaluation2074516overeval_uation_
overevaluations2194056overeval_uations
overexpectation2972106overexpectation_
overinflation19154556overinfl__ation_
overinflations20154396overinfl__ations
overmedicating2362996over_medicati_ng
overpopulation21144576over_population_
overpopulations22154126over_populations
overspeculation2263316overspeculation_
overvaluation1965086over_val_uation_
overvaluations2064596over_val_uations
reduplication1855046_re_duplication_
reduplications1964536_re_duplications
replication15712016___r_eplication_
replications16811056___r_eplications
supplication1855396___supplication_
supplications1954916___supplications
triplication1695386__tr_iplication_
triplications1795076__tr_iplications
verbalization2769676_ver_balization_
verbalizations2849166_ver_balizations
verification201810646_ver__ification_
verifications21159966_ver__ifications
vernalization25410036_ver_nalization_
vernalizations2649246_ver_nalizations
versification21157496_ver_sification_
versifications22166906_ver_sifications

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 Filter178691658740.0931921408.6
2DLD Change Limit65874487.4538838.6
3Display Results48480.076631.6
 (SQL Overall)178691487.62223444.1
 
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.