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 “descended” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
descended144628(None) 
descender1346661descender
ascended1246512_ascended
defended1437222de_fended
depended1337982de_pended
desanded11227452des_anded
descanted1336672descanted
descend11248152descen__d
descendent1446282descendent
descenders1445452descenders
descends12266982descend_s
desponded1445322desponded
dispended14147822dispended
distended12157922distended
reascended1444362reascended
redescended1653292redescended
rescinded1335762rescinded
scended11329872__scended
undescended1643512undescended
absconded1543003absconded
ascender1136733_ascender
besteaded1345043besteaded
condescended1952573condescended
crescendoed1751273crescendoed
deaconed1237493deacon_ed
deadened1137233deaden_ed
deafened1335853deafen_ed
decanted122310493de_canted
deceased1247713de_ceased
deceived1535893de_ceived
decenter112412163de_center
decentred13236233de_centred
decerned1237263de_cerned
decided124312423de_c_ided
decoded123212383de_c_oded
deeded94615543de__e_ded
deepened1235653deepen_ed
defenced1537203de_fenced
defender1337293de_fender
defensed1336223de_fensed
defunded1435163de_funded
degender1136893de_gender
deleaded1148333de_leaded
demanded13348513de_manded
demented12311273de_mented
descanter1246443descanter
descendant1454063descendant
descendents1554143descendents
descending1546113descending
descent102616293descen__t
descents112511203descen_ts
described1544953described
descried1248073desc_ried
deserted101012203des_erted
deserved13108133des_erved
desexed1636173des_e_xed
designed1136943design_ed
destined103312453destin_ed
disbanded1445643disbanded
discanted1339333discanted
discarded1437083discarded
discepted1547523discepted
discerned1347863discerned
discorded1438133discorded
dispensed13158773dispensed
dissented1199723dissented
distender11167743distender
emended11329603_e_mended
exceeded1943493_exceeded
expended19136543_expended
exscinded2042223exscinded
extended17135833_extended
lessened935093lessen_ed
mistended13137333mistended
perpended1546073perpended
prescinded1644343prescinded
reblended1355203reblended
receded112713043re_ce_ded
remended123010393re_mended
rescinder1245293rescinder
reseeded1038093res_eeded
resented92716963res_ented
resounded1136323resounded
responded1336513responded
scented102811883__scented
seceded11319203se_ce_ded
seconded1236353se_conded
sended85121233__s_ended
suspended13104513suspended
unscented1237513unscented
weekended1842173weekended

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.1531167915.0
2DLD Change Limit148641917.03321134.8
3Display Results91910.0303033.3
 (SQL Overall)178691917.21624763.2
 
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.