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

169 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
deplored123723(None) 
deplore1039481deplore_
deplorer1136341deplorer
deplores1139531deplores
deployed1535911deployed
declared1248742declared
decolored1345662decolored
deplaned1238662deplaned
depleted12258722depleted
deplorers1245462deplorers
deployer1445632deployer
deplumed1434082deplumed
deponed113712872dep_oned
deported1249702dep_orted
deposed113412022dep_osed
explored1845082explored
implored13135372implored
replowed14127572replowed
bellowed14158603bellowed
beloved13188393be_loved
cellared11398793cellared
censored11197953censored
colored10313473_colored
deaconed1237493deaconed
deaired9411533de_aired
dealated103213603dealated
debarred12165633debarred
deboned113411633de_boned
declare10411223declare_
declarer1148063declarer
declares11611313declares
declawed1545923declawed
declined123910883declined
decoded123212383de_coded
decoloured1443083decoloured
decoyed14358333de_coyed
deferred13106363deferred
deflated133412303deflated
defleaed1344953defleaed
deflexed2043883deflexed
deflower15126073deflower
deflowered1842513deflowered
deforced15247373de_forced
deformed15248263de_formed
deglazed2034953deglazed
dehorned1345683de_horned
dehorted1357303de_horted
delated93722873de_lated
delayed123310763de_layed
deled75326543de_l__ed
deleted93314913de_leted
delimed11310723de_limed
deloused1036973de_loused
deluded10158763de_luded
deluged10167413de_luged
delved114112753de_l_ved
demoded123611123de_moded
demoed103713443de_mo_ed
demoted114313543de_moted
demurred1234933demurred
denoted93512763de_noted
departed1238823departed
depended1337983depended
depeopled1543223depeopled
depermed1436453depermed
depicted1437743depicted
depilated1339653depilated
deplane10311413deplane_
deplanes11311213deplanes
deplete103010423deplete_
depleter11298863depleter
depletes112810643depletes
deploring1337853deploring
deploy1237583deplo__y
deployers1545063deployers
deploys1336523deplo_ys
deplume1255063deplume_
deplumes1334943deplumes
depone93616553dep_one_
depones103717093dep_ones
deport94922393dep_or_t
deportee11510353dep_ortee
deporter1169393dep_orter
deports105012883dep_orts
depose94215763dep_ose_
deposer104011843dep_oser
deposes103117213dep_oses
depraved1535543depraved
deprived1546463deprived
deputed114610173dep_uted
desired9311983de_sired
desorbed1236443de_sorbed
despaired1344503despaired
deterred10137803deterred
detoured1036513detoured
detoxed1636103de_toxed
developed16124313developed
devolved16325513devolved
devoted124111093de_voted
devoured1335723devoured
dewooled1333833dewooled
dewormed15236223de_wormed
dialoged1146693dialoged
diploe9810153diplo_e_
diploes101111493diplo_es
diploid11310293diplo_id
diplomaed1573713diplomaed
diplopod1453883diplopod
diploses111110323diploses
disploded1446543disploded
doctored1245613doctored
dolloped1234983dolloped
duplexed1943143duplexed
eloped95914143_e_loped
employed1654953employed
encored10412103_encored
exploded1944753exploded
explore1646613explore_
explorer1744713explorer
explores1746253explores
fellowed15136833fellowed
hectored1436873hectored
helloed113512423hello_ed
imploded14145073imploded
implore11176703implore_
implorer12125103implorer
implores12127043implores
leporid1048153lep_orid
mellowed14166923mellowed
mentored1138003mentored
peploses1269473peploses
peplumed1543043peplumed
peppered1236133peppered
plowed124213203__plowed
ployed124310563__ployed
pored85234513__p_ored
rebored105015883re_bored
recolored1246853recolored
redeployed1742623redeployed
reexplored2042623reexplored
reflowed15126903reflowed
reglowed13125853reglowed
repaired1148953repaired
replaced133211403replaced
replated112817523replated
replayed14248633replayed
repled93319783repl__ed
replied103914453repl_ied
replotted1235823replotted
repolled11359623repolled
reported11312703rep_orted
reposed103616273rep_osed
repoured1139563repoured
reprobed13228743reprobed
reproved14199473reproved
rescored114513103rescored
restored96417193restored
sectored1138063sectored
splore81611303_splore_
splores91910953_splores
spoored104411293_spoored
spored94821793_sp_ored
tailored936203tailored
unexplored2042633unexplored
unplowed1436353unplowed
vapored1336923vap_ored
vectored1435623vectored
velured1136683ve_lured
yellowed15185743yellowed

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.420425454.8
2DLD Change Limit1461621697.23620199.3
3Display Results1691690.0762223.7
 (SQL Overall)1786911697.73223110.6
 
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.