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

128 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
devalue113601(None) 
devalued1335011devalued
devalues1235851devalues
revalue1038151revalue
devaluate13226362devaluate
devolve14316062devolve
disvalue1244432disvalue
prevalue1345072prevalue
revalued1237022revalued
revalues1137882revalues
value85719092__value
bivalve1543593bivalve
crevalle1346163crevalle
dale55643983d__al_e
deal56347413de_al__
dealate83617843de_alate
dealer74122143de_aler
deals65435343de_al_s
dealt65234283de_al_t
dearie73319813de_arie
deave95022333de_a_ve
debacle1237443debacle
debase94014473deba_se
debate94419193deba_te
decade104216163deca_de
decal85523233decal__
decalog1136003decalog
decalogue1343253decalogue
decals93717713decal_s
decane93818873deca_ne
decare93919153deca_re
decile94619213decil_e
deckle1312012453deckl_e
declare10411223declare
dedal75719023dedal__
deface123113863defa_ce
defame123212433defa_me
default1147893default
defile105216663defil_e
deflate113613943deflate
degage92711383dega_ge
degame102713183dega_me
deglaze1835583deglaze
dekare112811563deka_re
delaine8314793delaine
delate73827753dela_te
dele56843083de__l_e
delude81910673de__lude
deluge8189403de__luge
deluxe14197303de__luxe
delve96018263de__lve
demilune1144423demilune
denature938063denature
dengue838253de_ngue
deplane10311413deplane
deplume1255063de_plume
derange939813derange
derate74531233dera_te
desalt7518313desal_t
desalted1038313desalted
desalter938363desalter
desalts839573desalts
detinue85010033detinue
deva85720983deva___
devaluated15265493devaluated
devaluates14266063devaluates
devaluing1434833devaluing
devas96218883deva__s
devel94217123devel__
develed123611933develed
develop13145033develop
develope14135723develope
devels104313903devel_s
deviance1477083deviance
deviate11312713deviate
device124512163dev_ice
devil94714733devil__
deviled124112183deviled
devilled1336743devilled
devilry1433973devilry
devils104412813devil_s
devious1138523devious
devise104215753dev_ise
devisee113812713devisee
devoice13347343devoice
devolved16325513devolved
devolves15286263devolves
devote104513783dev_ote
devotee113811823devotee
devour1076703dev_our
devout10712993dev_out
disvalued1444193disvalued
disvalues1344503disvalues
divulge1243103divulge
divulse1134913divulse
evacuee12105073_evacuee
evade938183_eva_de
evaluate11287793_evaluate
evolute1045683_evolute
evolve12306503_evolve
evulse935213_evulse
female11310553femal_e
league758743le_ague
mealie82519813me_alie
misvalue1344683misvalue
outvalue1144233outvalue
overvalue1545443overvalue
prevalued1544553prevalued
prevalues1445323prevalues
regale74821453regal_e
reglue739703re_glue
resale64025543resal_e
resalute857413resalute
revaluate12277103revaluate
revenue1039533revenue
revile94921613revil_e
revolute1176793revolute
revolve13328373revolve
revue81114453rev__ue
undervalue1444533undervalue
unvalued1266313unvalued
vague96513113__vague
vale74937343__val_e
valse85117523__valse
valued104011153__valued
valuer93911443__valuer
values94314943__values
valve114515933__valve

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271287.75017293.8
3Display Results1281280.0462782.6
 (SQL Overall)1786911288.20221786.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.