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 “degenders” 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
degenders123608(None) 
defenders1436361defenders
degender1136891degender_
decenters122410372decenters
defender1337292defender_
degendered1443502degendered
degraders12245932degraders
demanders13247572demanders
descenders1445452descenders
emenders11319032_emenders
engenders1145302engenders
genders93616782__genders
amenders11288353_amenders
ascenders1235683ascenders
attenders1045273attenders
begetters12135043begetters
beginners1283613beginners
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
defeaters13289103defeaters
defences1439633defence_s
defended1437223defende_d
defends12358773defend__s
defenses1237913defense_s
deferrers13115153deferrers
definers124211193defin_ers
degassers11354833degassers
degendering1543633degendering
degrader11247913degrader_
degrades11269923degrade_s
degreasers1243143degreasers
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
digesters11257883digesters
distenders12166733distenders
duendes938193d_uende_s
emender10649843_emender_
enders74324053___enders
engender1046633engender_
eveners10109503_even_ers
expenders19145963expenders
extenders17125673extenders
feeders113712863fe_e_ders
fenders113717263__fenders
ganders93521703__ganders
gelders93812573__gelders
gender83517933__gender_
heeders114213743he_e_ders
intenders10219373intenders
keeners113610783ke_en_ers
kegelers1355163kege_lers
lavenders1334753lavenders
legendary1442403legendary
legendry1342493legend_ry
legends936073legend__s
lenders84419643__lenders
meanders1168833me_anders
menders103818803__menders
needers84111903ne_e_ders
offenders1643403offenders
pretenders1345243pretenders
reenters82915303re_enters
refunders1334973refunders
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.406440125.6
2DLD Change Limit1486411147.25020502.2
3Display Results1141140.0502280.0
 (SQL Overall)1786911147.70623188.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.