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

129 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
devalues123585(None) 
devalue1136011devalue_
devalued1335011devalued
revalues1137881revalues
devaluates14266062devaluates
devolves15286262devolves
disvalues1344502disvalues
prevalues1445322prevalues
revalue1038152revalue_
revalued1237022revalued
values94314942__values
behalves1644083behalves
bivalves1643383bivalves
crevalles1455723crevalles
dales66439743d__al_es
dalles74222063d__alles
dealates92716683de_alates
dealer74122143de_al_er
dealers84118613de_alers
deals65435343de_al__s
dearies83526273de_aries
deashes113313903de_ashes
deaves105319533de_a_ves
debacles1335723debacles
debases103814133deba_ses
debates103718533deba_tes
decades113615513deca_des
decalogs1245633decalogs
decalogues1443253decalogues
decals93717713decal__s
decanes103118913deca_nes
decares102818533deca_res
deciles104417723decil_es
deckles143312803deckl_es
declares11611313declares
defaces133213403defa_ces
defames132812253defa_mes
defaults1243333defaults
defiles114016843defil_es
deflates123013943deflates
degames113312623dega_mes
degases93413103dega_ses
degasses10278363degasses
degauss933923dega_uss
deglazes1935463deglazes
dekares122710873deka_res
delaines9312963delaines
delates83526283dela_tes
deles65139253de__l_es
dellies83622213de_llies
deludes91810643de__ludes
deluges9169263de__luges
delves104917083de__lves
demilunes1244473demilunes
denatures1038133denatures
dengues938183de_ngues
deplanes11311213deplanes
deplumes1334943de_plumes
deranges1039973deranges
derates84028893dera_tes
desalted1038313desalted
desalter938363desalter
desalters1037673desalters
desalts839573desal_ts
detaches1439653detaches
detinues9569823detinues
devaluate13226363devaluate
devaluated15265493devaluated
devaluing1434833devaluing
devas96218883deva___s
develed123611933devel_ed
developes15155283developes
develops14145323develops
devels104313903devel__s
deviances1566493deviances
deviates12312733deviates
devices133212583dev_ices
deviled124112183devil_ed
devilled1336743devilled
devilries1345253devilries
devils104412813devil__s
devious1138523deviou_s
devisees12358283devisees
devises114116763dev_ises
devoices14307413devoices
devolve14316063devolve_
devolved16325513devolved
devotees12286283devotees
devotes113713753dev_otes
devours1166643dev_ours
dewaxes18297843dewa_xes
disvalue1244433disvalue_
disvalued1444193disvalued
divulges1343603divulges
divulses1244763divulses
evacuee12105073_evacuee
evacuees1382483_evacuees
evades1039023_eva_des
evaluates12247353_evaluates
evolutes1156063_evolutes
evolves13286743_evolves
evulses1035043_evulses
females12310663femal_es
leagues837943le_agues
mealies92821933me_alies
misvalues1444683misvalues
outvalues1244303outvalues
overvalues1644963overvalues
prevalue1345073prevalue_
prevalued1544553prevalued
reales64934123re_al_es
regales83520793regal_es
reglues838713re_glues
resales74724903resal_es
resalutes947433resalutes
revaluates13246793revaluates
revenues1138663revenues
reviles104421353revil_es
revolves14278623revolves
revues9813903rev__ues
undervalues1544153undervalues
unvalued1266313unvalued
vales85434263__val_es
valses94514613__valses
value85719093__value_
valued104011153__valued
valuer93911443__valuer
valuers10328943__valuers
valves124113783__valves

Search took 9 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.436409841.7
2DLD Change Limit1461621297.59619242.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911298.07822120.7
 
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.