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

114 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
bedecked187457(None) 
becked155417762b__ecked
bedeck1536212bedeck__
bedecks1635792bedeck_s
bedewed1437152bede_wed
beflecked2142652beflecked
bemocked1934072bemocked
decked145217622__decked
rednecked1743162rednecked
redocked16206822redocked
undecked16238492undecked
backed155725723b__acked
beached154516553be_ached
beaked135919493b__eaked
becket144619883b__ecket
bedamned1434583bedamned
bedarken1544513bedarken
bedaubed1443183bedaubed
bedded115114073bed__ded
bedeafen1443343bedeafen
bedecking1934283bedecking
bedemen12910183bede_men
bedesmen1355713bedesmen
bedeviled1673443bedeviled
bedimmed1643443bedimmed
bedlike14369533bedlike_
bedmaker1744933bedmaker
bedotted1234983bedotted
bedraped1455813bedraped
bedrenched1942583bedrenched
bedumbed1643023bedumbed
bedunced1453903bedunced
beechen14367703be_echen
beeches143413883be_eches
beefed123510873be_e_fed
beeped115313453be_e_ped
beetled1038213be_etled
beheaded1536373beheaded
belaced124112153belac_ed
belched154011843be_lched
beleaped1336103beleaped
bemeaned1335783bemeaned
benched154713943be_nched
beraked144312433be_raked
bereaved1446403bereaved
beseeched1743193beseeched
beseemed1334853beseemed
besmoked17405413besmoked
beuncled1334013beuncled
beveled133811123beve_led
bevelled14327793bevelled
bisected1336203bisected
blacked163613373b_lacked
blocked16449983b_locked
breeched16337383breeched
bricked164312063b_ricked
bucked155121063b__ucked
checked193710023_checked
debeaked1634613debeaked
deckel134911043__deckel
decker135215993__decker
deduced1266683deduc_ed
deducted1356243deducted
defected15289973defected
dejected19307593dejected
deked115718533__de_ked
detected12289733detected
deticked1635693deticked
dicked144920863__dicked
docked145018333__docked
ducked144718013__ducked
educed10418853_educ_ed
ejected17297653_ejected
elected102812613_elected
erected103213993_erected
fedexed1934083fede_xed
flecked17358073_flecked
gecked146911933__gecked
geeked124510163ge_e_ked
henpecked2141893henpecked
kecked125113173__kecked
keeked104810123ke_e_ked
leeched13369503le_eched
medevacked2351433medevacked
necked134715063__necked
overdecked2164603overdecked
pecked155019103__pecked
pedicled1436463pedicled
peeked134314583pe_e_ked
rechecked2143973rechecked
recked134821803__recked
recocked17248473recocked
redacted12410243redacted
redecide12127183redecide
redecided1455123redecided
redeemed1235593redeemed
redefied1368223redefied
redenied10511283redenied
reduced11610323reduc_ed
reeked113717643re_e_ked
refected142311663refected
rejected182710113rejected
relocked15217743relocked
repacked17188743repacked
reperked15177793reperked
reracked15169123reracked
resected112514743resected
retacked15169273retacked
seduced1186753seduc_ed
selected1159783selected
specked16329013_specked
undocked16277633undocked
wedeled1237783wede_led
wrecked17418333_wrecked

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.406440125.6
2DLD Change Limit1461621147.08020644.4
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.53223724.2
 
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.