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

182 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
descents11251120(None) 
descants112910141descants
descends12266981descends
descent102616291descent_
acescents1345232acescents
ascents93812552_ascents
crescents1367542crescents
decants103514442de_cants
deceits102810882de_ceits
decent94023702de_cent_
dements103016622de_ments
descant104315592descant_
descend11248152descen_d
deserts82513052des_erts
desserts9247922desserts
detents83615152de_tents
discants112912022discants
discepts1336742discepts
dissents93411862dissents
docents102810802d_ocents
nescients1145102nescients
percents122713372percents
reascents1177402reascents
resents74221222res_ents
scents85317022__scents
absents93510723abs_ents
accents113511233_accents
acescent1248013acescent_
adolescents1453303adolescents
ascends10388203_ascends
ascent84519653_ascent_
assents74512223_assents
besets85718803bes_e_ts
cements112714223ce_ments
cents74730333___cents
concents122516603concents
crescent12711053crescent_
deacons10310393deacon_s
deadens93410693deaden_s
deafens11317253deafen_s
decadents1346393decadents
decanes103118913de_canes
decant93524223de_cant_
decedents1347323decedents
deceit93018213de_ceit_
decency1537453de_cency
decenter112412163de_center
decenters122410373de_centers
decentest1249083de_centest
decently1448013de_cently
decentre11248553de_centre
decentres12238523de_centres
decerns10119053de_cerns
decocts1237833de_cocts
deepens10307813deepen_s
deets65330243de__e_ts
defeats113511233de_feats
defects134511523de_fects
defends12358773de_fends
deferents13269393deferents
deficients1644323deficients
deflects14336733deflects
dehiscent1545493dehiscent_
deicers103612733deice_rs
deices94119373deice__s
dejects17389223de_jects
dement93825153de_ment_
demounts1135473demounts
demulcents15102483demulcents
dents65031803d___ents
depaints1136643depaints
depends11348993de_pends
deponents1246673deponents
desalts839573des_alts
desands94810163des_ands
descanted1336673descanted
descanter1246443descanter
descanters1345013descanters
descendants1552753descendants
descended1446283descended
descendents1554143descendents
descender1346663descender
descenders1445453descenders
descries11311923descries
deselects1244493deselects
desert72725493des_ert_
desexes1537833des_exes
desiccants1542663desiccants
designs9328313design_s
desinent9312963desinent_
desists83611723des_ists
desmans1039003desman_s
desponds1246243desponds
despots10319683des_pots
dessert82916453dessert_
destines93619663destines
detects104011093de_tects
detent73624483de_tent_
detente83313603de_tente
detentes92712873de_tentes
detests83711743de_tests
deuces94015513deuce__s
devests114410473de_vests
deviants1236733deviants
diluents946053diluents
discant103017263discant_
discept12310623discept_
discerns1138163discerns
discounts1287823discounts
disjects18275923disjects
dispends12308533dispends
disseats93211503disseats
dissects11279243dissects
dissent84018683dissent_
disserts92411813disserts
distends10339823distends
distent84120853distent_
docent92918683d_ocent_
dracenas1145793dracenas
duecento1143563duecento
duecentos1243153duecentos
dulcets1046283dulce_ts
eluents738703_eluents
escheats1346253_escheats
escorts9418403_escorts
escots84211743_esc_ots
esculents1144693_esculents
events94814073_e_vents
excepts1885203_excepts
extents142610173_extents
ferments13311473ferments
gerents82612923ge_rents
ignescents1373383ignescents
incents92414533_incents
lessens7409383lessen_s
nascent9610523nascent_
nescient1048713nescient_
pendents1139413pendents
percent113520603percent_
percepts14247643percepts
perpents122312043perpents
precents123015043precents
presents103315643pres_ents
pschents1544113_pschents
reaccents1365853reaccents
reagents959623reagents
reascends1244293reascends
reascent10411983reascent_
recants93217093re_cants
recent83630853re_cent_
recepts113010263re_cepts
redescends1483723redescends
regents83416543re_gents
relents74018503re_lents
repents93717623re_pents
rerents73319423re_rents
rescinds1136333rescinds
reseats74319583res_eats
resects94115593res_ects
resends83513713res_ends
resent63833623res_ent_
resets65427613res_e_ts
residents1038423residents
resmelts1046143resmelts
respects1247703respects
scants85219723__scants
scenas84114703__scenas
scends95213003__scends
scenes84520353__scenes
scent75831623__scent_
secants93413893se_cants
segments1138903segments
seicento1045043seicento
seicentos1144553seicentos
sequents1756993sequents
serpents102410373serpents
sestets7911473seste_ts
stents65019453__stents
tercets93512443terce_ts
vesicants1444753vesicants
vestments1486813vestments
wisents10249063wis_ents

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.423422437.4
2DLD Change Limit1461621826.62322068.9
3Display Results1821820.0802275.0
 (SQL Overall)1786911827.12625075.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.