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

196 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
defending1529835(None) 
defencing16226691defencing
defensing14217001defensing
defunding15216121defunding
depending14208781depending
deafening1476272deafen_ing
deeding103315122de_e_ding
defanging1535332defanging
defeating142311972defeating
defecting162510222defecting
defendant1445432defendant
deferring1436142deferring
defining133711802defin_ing
deleading1237772deleading
demanding14237922demanding
dementing13311042dementing
desanding12207652desanding
descending1546112descending
emending12298892_emending
fending123717602__fending
offending1744092offending
refeeding14247932refeeding
refencing15188852refencing
refinding14259942refinding
refunding14258072refunding
relending112412022relending
remending132311312remending
resending112313362resending
amending12308913_amending
appending1536283appending
ascending1336283ascending
attending11136373attending
befriending1842213befriending
beheading1636163beheading
bending114420893__bending
blending12249963_blending
cementing1438763cementing
davening13258873daven_ing
deadening1277583deaden_ing
deafenings1562503deafen_ings
deaning94020473de_an_ing
debeaking1735923debeaking
debearding1543733debearding
deboning12109153debon_ing
debriding1446483debriding
debunking1733353debunking
decanting132510633decanting
deceasing1338403deceasing
deceiving1635733deceiving
decentring1446753decentring
decerning1337293decerning
deciding132210833de_ciding
decoding132410053de_coding
deeming113913123de_e_ming
deepening1335613deepen_ing
defacing15238683def_acing
defaming15238463def_aming
defatting1436103defatting
defecating17237783defecating
defend113910493defend___
defendants1543653defendants
defended1437223defend_ed
defender1337293defend_er
defenders1436363defenders
defends12358773defend__s
defensive1644993defensive
defilading1643643defilading
defiling132812463def_iling
deflating142610713deflating
defleaing1444743defleaing
deflecting1736503deflecting
defoaming1645653defoaming
defogging1653863defogging
deforcing1636063deforcing
deforming1636703deforming
defrauding1642923defrauding
defraying1735853defraying
defueling14255093defueling
defuelling1573543defuelling
defusing13227933def_using
defuzing22195253def_uzing
defying15328823def__ying
degendering1543633degendering
degerming1435753degerming
degrading13137373degrading
deigning1137753deign_ing
dejecting20217793dejecting
dekeing13358353deke__ing
deleaving1436263deleaving
deleing93313953dele__ing
deleting103314423dele_ting
deluding1137683de_luding
demeaning1337243demeaning
demerging1436643demerging
denning93515173d__enning
denting94422183d__enting
denuding1137113de_nuding
denying123711293d__enying
dependant1346993dependant
dependent1349113dependent
deperming1537113deperming
deponing121211213depon_ing
deranging1238063deranging
deriding112512933de_riding
deserting11713143deserting
deserving1497903deserving
desexing1736293dese_xing
desponding1555663desponding
detecting13259983detecting
deterging1237853deterging
deterring1138623deterring
detesting112610323detesting
detruding1245193detruding
deveining1436393deveining
develing133212733deve_ling
devesting14249903devesting
dezincing2244183dezincing
dispending1547923dispending
distending1348333distending
dizening19177143dizen_ing
dovening13238353doven_ing
dozening19236183dozen_ing
dreading113712803d_reading
drownding1564123drownding
ending83220253___ending
evening11310223_even_ing
expending2045933expending
extending1835853extending
feeding123515073__feeding
fencing132411133__fencing
feuding123410263__feuding
finding124116543__finding
fonding123815423__fonding
forefending1943493forefending
forfending1844183forfending
friending1495553friending
funding124113663__funding
heeding123515063he_e_ding
impending1535933impending
intending1139983intending
keening123713153ke_en_ing
lending94118533__lending
mending114018683__mending
needing93214423ne_e_ding
nonending1138003nonending
peening103318303pe_en_ing
pending114119773__pending
perpending1646683perpending
prefunding1745233prefunding
pretending1438613pretending
rebinding13249483rebinding
reblending1455813reblending
receding122713763rece_ding
redenying1437783redenying
reeding94124133re_e_ding
refecting152413353refecting
refeeling13229313refeeling
refelling132211313refelling
referring1338033referring
refining122416863refin_ing
refolding1437453refolding
refounding1545353refounding
relanding112110923relanding
relenting102716773relenting
remanding132211143remanding
reminding132311543reminding
rending93924263__rending
repenting122316553repenting
rereading111212713rereading
rerenting102617663rerenting
reseeding112410493reseeding
resenting102619293resenting
revenging1438083revenging
rewedding1535093rewedding
rewelding1436913rewelding
rewinding14238933rewinding
scending122610583_scending
seceding12288563sece_ding
seconding1337613seconding
seeding93719483se_e_ding
sending94221373__sending
serenading1246103serenading
shending132511253_shending
spending122712433_spending
tending94419163__tending
trending103012833_trending
unbending1337463unbending
unending10239943_unending
unfencing1545953unfencing
upending12258133_upending
upsending1334903upsending
vending124015263__vending
weeding123815213we_e_ding
weekending1942233weekending
weening114113973we_en_ing
wending123816843__wending

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.453394461.4
2DLD Change Limit1486411966.86021667.8
3Display Results1961960.0932107.5
 (SQL Overall)1786911967.40624127.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.