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

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

37 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
overeducations205498(None) 
overeducation1955371overeducation_
overeducating2054852overeducati_ng
overmedications2363662overmedications
overeducates1854393overeducat__es
overmedication2264003overmedication_
overregulations1963853overregulations
reeducations1545473_re_educations
coeducations1745874__coeducations
deregulations1545204_deregulations
educations1339234____educations
eradications1549304__eradications
miseducations18113294_miseducations
overactions1648214over__ac_tions
overcautions1755264over___cautions
overdecorations2163724overdecorations
overeducate1754514overeducat___e
overeducated1954354overeducat__ed
overestimations20124604overestimations
overevaluations2194074overevaluations
overexertions23115194overe_xertions
overextractions27163254overextractions
overinflations20154414overinflations
overmedicating2363014overmedicati_ng
overpopulations22154144overpopulations
overproductions2363784overproduc_tions
overreactions1854724overreac_tions
overregulation1864344overregulation_
oversaturations1863964oversaturations
overtaxations2353514over_taxations
overvaluations2064614overvaluations
predications17411184__predications
rededications1746124_rededications
reductions1359584___reduc_tions
reeducation1445934_re_education_
reregulations1455714_reregulations
verifications21159974_verifications

Search took 4 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.310576422.6
2DLD Change Limit65874373.44019149.4
3Display Results37370.0301233.3
 (SQL Overall)178691373.78047272.8
 
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.