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

139 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
defenders143636(None) 
defender1337291defender_
degenders1236081degenders
decenters122410372decenters
defeaters13289102defeaters
defences1439632defence_s
defended1437222defende_d
defends12358772defend__s
defenses1237912defense_s
deferrers13115152deferrers
definers124211192defin_ers
degender1136892degender_
demanders13247572demanders
descenders1445452descenders
emenders11319032_emenders
fenders113717262__fenders
offenders1643402offenders
refunders1334972refunders
amenders11288353_amenders
ascenders1235683ascenders
attenders1045273attenders
befingers1544103befingers
beheaders1545153beheaders
benders104021063__benders
blenders115210993_blenders
calenders1237403calenders
cementers1338313cementers
danders93921183d__anders
daunders10278473d_aunders
deadeners1146283deaden_ers
deboners11268113debon_ers
debunkers1642703debunkers
decanters12229223decanters
deceivers1535723deceivers
decenter112412163decenter_
decentres12238523decentres
deciders123510753de_ciders
decoders122810413de_coders
deepeners1244523deepen_ers
defacers14237993def_acers
defamers14258523def_amers
defeater122611663defeater_
defectors15237883defectors
defence1339893defence__
defenced1537203defence_d
defend113910493defend___
defendant1445443defendant
defendants1543653defendants
defending15298353defending
defense1137503defense__
defensed1336223defense_d
deferrer12135593deferrer_
defers105116943def___ers
defiers113913993def__iers
defilers12439473def_ilers
definer114413773defin_er_
defines114118683defin_e_s
definiens1345303definiens
deflaters13298703deflaters
deflowers16145643deflowers
defoamers15285253defoamers
defoggers1543053defoggers
deforcers15265503deforcers
deformers15266533deformers
defrauders1541993defrauders
defrayers1644173defrayers
deftness1236303deftn_ess
defunded1435163defunde_d
defunds12376753defund__s
defusers12487363def_users
degendered1443503degendered
degraders12245933degraders
dejeuners1742443dejeuners
deluders10156433de_luders
demander12238723demander_
demergers13146403demergers
deniers84515183d__eniers
denuders10165873de_nuders
depended1337983depende_d
dependent1349113dependent
dependents1446163dependents
depends11348993depend__s
derangers1136703derangers
deriders102411853de_riders
deringers1137183deringers
descender1346663descender_
deserters10129983deserters
deservers13107293deservers
detecters12217753detecters
detentes92712873detente_s
detergers11147183detergers
deterrers10116593deterrers
detesters10298303detesters
distenders12166733distenders
duendes938193d_uende_s
emender10649843_emender_
enders74324053___enders
engenders1145303engenders
eveners10109503_even_ers
expenders19145963expenders
extenders17125673extenders
feeders113712863__feeders
fencers123810623__fencers
fender103718723__fender_
finders113717873__finders
funders113813933__funders
genders93616783__genders
heeders114213743he_e_ders
intenders10219373intenders
keeners113610783ke_en_ers
lavenders1334753lavenders
lenders84419643__lenders
meanders1168833me_anders
menders103818803__menders
needers84111903ne_e_ders
offender1543723offender_
pretenders1345243pretenders
reenters82915303re_enters
refences13311843refence_s
referrers12125373referrers
refiners114713313refin_ers
refunder1236503refunder_
reminders12308653reminders
renders83821673__renders
repenters112511553repenters
revengers1336413revengers
revenuers1235983revenuers
rewinders13246503rewinders
seceders11277963sece_ders
seconders1236953seconders
seeders83017113se_e_ders
senders83022353__senders
serenaders11204663serenaders
spenders113211743_spenders
teeners74415453te_en_ers
tenders83719723__tenders
venders113717003__venders
weeders113412933we_e_ders
weekenders1842263weekenders

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411397.05021083.8
3Display Results1391390.0602316.7
 (SQL Overall)1786911397.53023730.5
 
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.