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

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

140 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
devalued133501(None) 
devalue1136011devalue_
devalues1235851devalues
revalued1237021revalued
desalted1038312desalted
devaluated15265492devaluated
develed123611932devel_ed
deviled124112182devil_ed
devilled1336742devilled
devolved16325512devolved
disvalued1444192disvalued
prevalued1544552prevalued
revalue1038152revalue_
revalues1137882revalues
unvalued1266312unvalued
valued104011152__valued
becalmed1534813becalmed
begalled1236023begalled
beveled133811123bevel_ed
bevelled14327793bevelled
bivalved1742683bivalved
deaired9411533de_aired
dealated103213603de_alated
dealer74122143de_al_er
deaned84620453de_a_ned
deashed123411303de_ashed
deaved114916553de_a_ved
debagged1433723debagged
debarked16175823debarked
debarred12165633debarred
debased113310583deba_sed
debated113916083deba_ted
decamped1634963decamped
decanted122310493decanted
decayed14309333deca_yed
declared1248743declared
declawed1545923declawed
defaced142910973defa_ced
defamed14309833defa_med
defanged1435433defanged
defatted1335673defatted
defaulted1443313defaulted
defiled124013103defil_ed
deflated133412303deflated
degassed11275963degassed
deglazed2034953deglazed
delated93722873dela_ted
delayed123310763dela_yed
deled75326543de__l_ed
delude81910673de__lude
deluded10158763de__luded
deluged10167413de__luged
delved114112753de__lved
demanded13348513demanded
demarked16187223demarked
demasted1238763demasted
denatured1146023denatured
departed1238823departed
deplaned1238663deplaned
deplumed1434083de_plumed
derailed102410403derailed
deranged1137693deranged
derated93623503dera_ted
deratted1048403deratted
desalter938363desalter
desanded11227453desanded
detached1537733detached
detailed10319873detailed
detained103111643detained
devaluate13226363devaluate
devaluates14266063devaluates
devaluing1434833devaluing
deveined1336673deveined
developed16124313developed
devested13239133devested
deviated13311043deviated
devised123712563dev_ised
devoiced15276063devoiced
devolve14316063devolve_
devolves15286263devolves
devoted124111093dev_oted
devoured1335723devoured
dewaxed19316053dewa_xed
dialed84716453d_ial_ed
dialled9510133d_ialled
disvalue1244433disvalue_
disvalues1344503disvalues
divulged1442963divulged
divulsed1343883divulsed
evacuee12105073_evacuee
evaded1137063_eva_ded
evaluated13276653_evaluated
evolved14305583_evolved
evulsed1133963_evulsed
exalted1537393_exalted
healed105121443he_al_ed
heralded1335443heralded
leagued935463le_agued
levanted1245323levanted
leveled114010383level_ed
levelled12327443levelled
medaled113411613medal_ed
medalled1246893medalled
metaled102913883metal_ed
metalled1148983metalled
misvalued1544283misvalued
outvalued1344203outvalued
overvalued1744703overvalued
pealed95322813pe_al_ed
pedaled113711893pedal_ed
pedalled1246933pedalled
petaled103614153petal_ed
petalled1138703petalled
prevalue1345073prevalue_
prevalues1445323prevalues
recalled11310803recalled
regaled93615963regal_ed
reglued936333re_glued
resaluted1046473resaluted
revaluated14306363revaluated
revamped1634143revamped
revealed123211213reveal_ed
reveled113917753revel_ed
revelled123712733revelled
revenued1237223revenued
reviled114417923revil_ed
revolted12319863revolted
revolved15328103revolved
revulsed1235443revulsed
rivaled1138933rival_ed
rivalled1236093rivalled
sealed74328363se_al_ed
sepaled10510593sepal_ed
sepalled1156903sepalled
undervalued1643793undervalued
value85719093__value_
valuer93911443__valuer
values94314943__values
valved136711043__valved
vealed103916323ve_al_ed

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621406.67321903.5
3Display Results1401400.0632222.2
 (SQL Overall)1786911407.13925030.3
 
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.