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

148 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
degender113689(None) 
defender1337291defender
degenders1236081degenders
decenter112412162decenter
defended1437222defended
defenders1436362defenders
degendered1443502degendered
degrader11247912degrader
demander12238722demander
depended1337982depended
descender1346662descender
emender10649842_emender
engender1046632engender
gender83517932__gender
amender10349613_amender
ascender1136733ascender
attender935913attender
begetter11136313begetter
beginner1173953beginner
beheader1436043beheader
bender95223303__bender
blender104613843_blender
calender1138273calender
cementer1239193cementer
damneder1243763damneder
dander811222993d__ander
darneder1033983darneder
daunder9348893d_aunder
deadener1036743deaden_er
deader84220473d__eader
deboner103110483debon_er
debunker1543093debunker
decanter112510793decanter
deceiver1436233deceiver
decenters122410373decenters
decentre11248553decentre
decider114213183de_cider
decoder113712293de_coder
deeded94615543de_e_ded
deedier93011593de_edier
deepener1145183deepen_er
deeper93613503de_e_per
defeater122611663defeater
defence1339893defence_
defenced1537203defenced
defences1439633defences
defend113910493defend__
defends12358773defend_s
defense1137503defense_
defensed1336223defensed
defenses1237913defenses
deferrer12135593deferrer
definer114413773defin_er
defunded1435163defunded
degasser10325813degasser
degendering1543633degendering
degermed1335453degermed
degrade10229903degrade_
degraded12288323degraded
degraders12245933degraders
degrades11269923degrades
degreaser1144333degreaser
dejeuner1682933dejeuner
deleaded1148333deleaded
deluder9168333de_luder
demanded13348513demanded
demanders13247573demanders
demented12311273demented
demerger12127373demerger
denier74420693d__enier
denser74115193d__enser
denuder9167603de_nuder
depend103510923depend__
dependent1349113dependent
depends11348993depend_s
deranger1037353deranger
derider93214973de_rider
deringer1038143deringer
dernier83011943de_rnier
desanded11227453desanded
descended1446283descended
descenders1445453descenders
deserter91211603deserter
deserver12118383deserver
detecter11298733detecter
detente83313603detente_
detentes92712873detentes
deterger10147593deterger
deterrer9137013deterrer
detester9239683detester
digester10258433digester
distender11167743distender
duende836923d_uende_
duendes938193d_uendes
durneder1043233durneder
emended11329603_emended
emenders11319033_emenders
ender64325863___ender
engenders1145303engenders
evener91010623_even_er
expender18136843expender
extender16146333extender
feeder103513843fe_e_der
fender103718723__fender
gander84322763__gander
gelder84613713__gelder
genders93616783__genders
heeder104216043he_e_der
hereunder1343183hereunder
intender93310443intender
keener104012843ke_en_er
kegeler1245493kege_ler
lavender1235143lavender
legend837693legend__
legendary1442403legendary
legendry1342493legendry
legends936073legend_s
lender73921273__lender
meander1049973me_ander
mender93520793__mender
needer73614953ne_e_der
offender1543723offender
pretender1246663pretender
recenter102715443recenter
reenter73217793re_enter
refunder1236503refunder
remended123010393remended
reminder113110513reminder
render74024143__render
repenter102813863repenter
revenger1237303revenger
revenuer1136893revenuer
rewinder12317663rewinder
seceder10329573sece_der
seconder1137183seconder
seeder74320773se_e_der
sender73824413__sender
serenader10216003serenader
serener73415763seren_er
slender83413593_slender
spender103713693_spender
teener64717503te_en_er
teenier72611143te_enier
tender74121843__tender
vender103418423__vender
weeder103315513we_e_der
weekender1742463weekender
weenier103210803we_enier

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 Limit1461621487.28320068.9
3Display Results1481480.0602466.7
 (SQL Overall)1786911487.74923059.9
 
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.