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

96 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
dispended1414782(None) 
dispensed13158771dispensed
distended12157921distended
depended1337982d_epended
descended1446282descended
desponded1445322desponded
disbanded1445642disbanded
dispelled13117572dispelled
dispend11289412dispen__d
dispends12308532dispend_s
dispense11129782dispense_
dispenser12128322dispenser
dispenses121210762dispenses
dispersed13119782dispersed
disploded1446542disploded
dissented1199722dissented
distender11167742distender
impended1435952_impended
mispenned1445412mispenned
mistended13137332mistended
suspended13104512suspended
appended1435483_appended
ascended1246513_ascended
crispened1443613crispen_ed
dampened1435623dampen_ed
deepened1235663deepen_ed
defended1437223d_efended
desanded11227453des_anded
descender1346663descender
diamonded1443393diamonded
diapered1238003diape_red
disbudded1543293disbudded
discanted1339333discanted
discarded1437083discarded
discepted1547523discepted
discerned1347863discerned
discorded1438133discorded
diseased103011713dis_eased
disendow1343813dis_endow
disendowed1653053dis_endowed
dishelmed1645093dishelmed
disjected2086353disjected
disowned1336433disown_ed
disparted1338853disparted
dispeller12146983dispeller
dispending1547923dispending
dispensers13146743dispensers
dispeopled16143823dispeopled
disperse111011353disperse_
disperser12109083disperser
disperses121211773disperses
displaced1546793displaced
displanted14126633displanted
displayed1645883displayed
displeased1444483displeased
displode1247643displode_
displodes1347863displodes
displumed1544353displumed
disported13310303disported
disposed12310943disp_osed
disprized2247363disprized
disproved16147343disproved
disputed1238353disp_uted
disseated11711083disseated
dissected13108663dissected
disseised1147863disseised
disseized2046323disseized
dissenter1059133dissenter
disserted11109813disserted
disserved14107003disserved
dissuaded1265433dissuaded
distanced1348573distanced
distend93312073disten__d
distenders12166733distenders
distends10339823distend_s
dizened18267333di_zen_ed
expended19136543_expended
impeded13418183_impe_ded
intended102310413_intended
islanded1035513_islanded
lippened13255223lippen_ed
listened9168813listen_ed
mispleaded1644133mispleaded
misrender1286293misrender
pended103819013___pended
perpended1546083perpended
propended1546163propended
responded1336513responded
ripened1038203ri_pen_ed
scended11329873__scended
sended85121233__s_ended
speeded113310423__speeded
spender103713693__spender
suspender12115093suspender
upended11267323__upended
vilipended1751323vilipended

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 Limit148641967.12620859.0
3Display Results96960.0462087.0
 (SQL Overall)178691967.59223536.7
 
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.