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

125 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
deepened123566(None) 
deepener1145181deepener
dampened1435622dampened
deadened1137232deadened
deafened1335852deafened
deepen9339192deepen__
deepeners1244522deepeners
deepens10307812deepen_s
depend103510922d_epen_d
depended1337982d_epended
deponed113712872d_eponed
reopened1138512reopened
steepened1244072steepened
beelined11277713beelined
beeped115313453beep__ed
cheapened1743783cheapened
dampener1335533dampener
darkened1435943darkened
davened124610073d_avened
deaconed1237493deaconed
deadener1036743deadener
deaned84620453d_e_aned
deboned113411633d_eboned
decerned1237263decerned
declined123910883declined
decreed112710253decre_ed
deeded94615543d_e_eded
deejayed2042443deejayed
deemed104713063d_e_emed
deepening1335613deepening
deeper93613503deep__er
deepest10310443deepe_st
deepness1136443deepness
deerweed1344183deerweed
defenced1537203d_efenced
defend113910493d_efen_d
defended1437223d_efended
defensed1336223d_efensed
defined123813823d_efined
defleaed1344953defleaed
deflexed2043883deflexed
defueled1374513defueled
degreed10258883degre_ed
dehorned1345683dehorned
deigned1037503d_eigned
deleted93314913d_eleted
demeaned1237283demeaned
demented12311273d_emented
denizened2042753denizened
denned84215633d_e_nned
depends11348993d_epends
depermed1436453depermed
deplaned1238663deplaned
depleted12258723depleted
depone93616553d_epone_
depones103717093d_epones
deposed113412023d_eposed
deputed114610173d_eputed
descend11248153descen_d
descended1446283descended
desexed1636183d_esexed
designed1136943designed
despised1236923despised
despited1248323despited
despond1137513despon_d
desponded1445323desponded
destined103312453destined
detained103111643detained
deveined1336673deveined
develed123611933d_eveled
diapered1238003diapered
dieseled1035523dieseled
dispend11289413dispen_d
dispended14147823dispended
dispensed13158773dispensed
dizened18267333d_izened
dovened12389063d_ovened
dozened18377453d_ozened
dyeweed1543203dyewe_ed
evened101010313__evened
expend16247503_expen_d
expended19136543_expended
expensed18126413_expensed
greened93111263gre_ened
happened1635653happened
jeeped16469843jeep__ed
jeepney1942093jeep_ney
keened114013633_ke_ened
leadened1036153leadened
leavened1235553leavened
lessened935103lessened
lippened13255223lippened
neatened937043neatened
opened94311863__opened
peened94318163_pe_ened
peeped113915393peep__ed
peppered1236133peppered
perpend12259353perpen_d
perpended1546083perpended
preened103214993pre_ened
queened17105863que_ened
reddened1136423reddened
reearned948883reearned
repented112614983_repented
repined104918773_repined
ripened1038203_ripened
seeped94317523seep__ed
sheened113511703she_ened
sleekened1442543sleekened
sweetened1343253sweetened
teepee8314363teepe_e_
teepees939263teepe_es
teetered9258303teetered
tempered13248223tempered
terpene92310863terpene_
terpenes102111573terpenes
unopened1137023unopened
veepee11311483veepe_e_
veepees1245813veepe_es
weakened1634823weakened
weaponed1445493weaponed
weekend1533393weeken_d
weekended1842173weekended
weened104013733_we_ened
weeweed1435183weewe_ed

Search took 7 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.423422437.4
2DLD Change Limit1461621256.50022486.5
3Display Results1251250.0462717.4
 (SQL Overall)1786911256.96925640.8
 
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.