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

97 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
distended1215792(None) 
dispended14147821dispended
distender11167741distender
mistended13137331mistended
descended1446282descended
disbanded1445642disbanded
dispensed13158772dispensed
dissented1199722dissented
distanced1348572distanced
distend93312072disten__d
distenders12166732distenders
distends10339822distend_s
intended102310412_intended
listened9168812listen_ed
ascended1246513_ascended
attended1035763_attended
bartended1344663bartended
besteaded1345073besteaded
bistered112913333biste_red
contended1339273contended
defended1437223d_efended
depended1337983d_epended
desanded11227453des_anded
descender1346663descender
desponded1445323desponded
destined103312453destin_ed
diamonded1443393diamonded
disbudded1543293disbudded
discanted1339333discanted
discarded1437083discarded
discepted1547523discepted
discerned1347863discerned
discorded1438133discorded
diseased103011713dis_eased
disendow1343813dis_endow
disendowed1653053dis_endowed
dishelmed1645093dishelmed
disjected2086353disjected
disowned1336433disown_ed
dispelled13117573dispelled
dispend11289413dispen__d
dispends12308533dispend_s
dispense11129783dispense_
dispenser12128323dispenser
dispenses121210763dispenses
dispersed13119783dispersed
disploded1446543disploded
disseated11711083disseated
dissected13108663dissected
disseised1147863disseised
disseized2046323disseized
dissenter1059133dissenter
disserted11109813disserted
disserved14107003disserved
dissuaded1265433dissuaded
distained1139603distained
distance11311853distance_
distances12311653distances
distasted1137963distasted
distemper1444853distemper
distending1348333distending
distent84120853disten__t
distilled1147183distilled
distorted1139373distorted
distressed1246443distressed
disturbed13195583disturbed
dizened18267333di_zen_ed
extended17135833_extended
fastened12257853fasten_ed
glistened11174283glisten_ed
hastened12239103hasten_ed
impended1435953_impended
intendeds11265743_intendeds
intender93310443_intender
islanded1035513_islanded
kittened1334523kitten_ed
listener8158313listen_er
mispenned1445413mispenned
misrender1286293misrender
mistend103812523misten__d
mistends11419593mistend_s
mistermed1438363mistermed
mistuned1157723mistun_ed
mittened1136363mitten_ed
moistened1246003moisten_ed
portended1345643portended
pretended1337193pretended
protended1336803protended
scended11329873__scended
sended85121233__s_ended
sistered92612803siste_red
steaded92811673__steaded
subtended1345153subtended
suspended13104513suspended
tended83819483___tended
unintended1243513unintended
untended102611153_untended

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.420425454.8
2DLD Change Limit148641976.73322076.5
3Display Results97970.0332939.4
 (SQL Overall)178691977.18624866.5
 
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.