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

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

55 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
devaluates1426606(None) 
devaluate13226361devaluate_
devaluated15265491devaluated
evaluates12247351_evaluates
revaluates13246791revaluates
dealates92716682de_al_ates
defalcates1644542defalcates
devalues1235852devalu__es
devastates1444662devastates
evacuates14256802_evacuates
evaluate11287792_evaluate_
evaluated13276652_evaluated
reevaluates1453012reevaluates
revaluate12277102revaluate_
revaluated14306362revaluated
valuates112811202__valuates
deaerates10313643de_aerates
dealate83617843de_al_ate_
dealated103213603de_al_ated
decollates13137153decollates
defalcate1544923defalcate_
defalcated1744183defalcated
deflates123013943de_fl_ates
defoliates1446333defoliates
delates83526283de__l_ates
demarcates1545973demarcates
depilates12310923depil_ates
desalinates1246213desalinates
desolates10311793desol_ates
devaluating1645053devaluating
devaluation1547073devaluation
devaluations1646353devaluations
devalue1136013devalu__e_
devalued1335013devalu__ed
devastate1344953devastate_
devastated1544123devastated
deviates12312733dev__iates
divagates1444733diva_gates
divulgates1562933divulgates
eluates72014683_e__luates
evacuate13217303_evacuate_
evacuated15196263_evacuated
evaluator12104963_evaluator
evaluators1374593_evaluators
evolutes1156063_evolu_tes
misevaluates1782443misevaluates
reevaluate1353143reevaluate_
reevaluated1552833reevaluated
resalutes947433resalu_tes
retaliates1049093retaliates
revalidates1554353revalidates
revalues1137883revalu__es
unevaluated1553073unevaluated
valuate102512733__valuate_
valuated12239203__valuated

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 Filter1786911406030.826216332.9
2DLD Change Limit140603558.94015727.4
3Display Results55550.0134230.8
 (SQL Overall)178691559.77918272.9
 
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.