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

137 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
dispends1230853(None) 
dispend11289411dispend_
distends10339821distends
depends11348992d_epends
descends12266982descends
desponds1246242desponds
disbands1237352disbands
dispels10310502dispe_ls
dispended14147822dispended
dispense11129782dispense
dispenses121210762dispenses
dispreads1346002dispreads
dissents93411862dissents
distend93312072distend_
impends12376802_impends
mispens11311072mispen_s
missends11368232missends
misspends1443852misspends
mistends11419592mistends
spends94714472__spends
suspends1145142suspends
airspeeds1242513airspeeds
appends1236393_appends
ascends10388203_ascends
aspens85013353_aspen_s
bipeds11458053bi_pe_ds
compends15378253compends
crispens12286253crispen_s
dampens12348563dampen_s
deepens10307813deepen_s
defends12358773d_efends
depend103510923d_epend_
desands94810163des_ands
descend11248153descend_
descents112511203descents
despond1137513despond_
diamonds12125173diamonds
diapers104713913diape_rs
diapsids1244753diapsids
dickens144410133dicken_s
dienes75719903di__enes
diluents946053diluents
dipnets10109033di_pnets
dipped123517493dippe_d_
dippers123615183dippe_rs
disband1138243disband_
disbuds11125243dis_buds
discants112912023discants
discards1238913discards
disced104914653disce_d_
discepts1336743discepts
discerns1138163discerns
discoids1239873discoids
discords1238593discords
disendow1343813dis_endow
disendows1444083dis_endows
diseurs839403dis_eurs
dished114318713dishe_d_
dishelms1444723dishelms
dishes104622653dishe__s
dishpans14115833dishpan_s
disjects18275923disjects
disked125015763diske_d_
dismes95617673disme__s
disowns1136733disown_s
disparts11109953disparts
dispel9310323dispe__l
dispending1547923dispending
dispensed13158773dispensed
dispenser12128323dispenser
dispensers13146743dispensers
disperse111011353disperse
disperses121211773disperses
displants1248073displants
displays1446293displays
displode1247643displode
displodes1347863displodes
disports111111113disports
disposes11313823disposes
dispread1247103dispread_
disputes1139653disputes
disseats93211503disseats
dissects11279243dissects
dissed85220183disse_d_
dissensus1044353dissensus
dissent84018683dissen_t
disserts92411813disserts
disses75225963disse__s
distended12157923distended
distender11167743distender
distenders12166733distenders
distent84120853disten_t
dividends15273313dividends
dizens164911393di_zen_s
dyspneas1462753dyspneas
expends17217083_expends
fiends104110293fi__ends
fishponds1852513fishponds
impend11478793_impend_
intends8239963_intends
islands837323_islands
lippens11328533lippen_s
lisped94113423lispe_d_
lispers94514323lispe_rs
listens74014133listen_s
minuends1143893minuends
misbinds1345163misbinds
misdeeds12276813misdeeds
misfeeds14315623misfeeds
misleads11358543misleads
mispen10312173mispen__
mispleads1444203mispleads
misreads11268923misreads
missend104411373missend_
misspend1345243misspend_
mistend103812523mistend_
outspends1294123outspends
pends85527193___pends
perpends13227753perpends
pigpens1235503pigpen_s
propends13249173propends
resends83513713res_ends
responds1136913responds
ripens85012173ri_pen_s
scends95213003__scends
sends65528243__s_ends
shends105313773__shends
speeds94316053__speeds
spend85619333__spend_
spendy124911143__spendy
stipends11304793stipends
suspend1036013suspend_
upends9438763__upends
upsends10265293ups_ends
vilipends1542073vilipends
wisents10249063wis_ents
wisped123411893wispe_d_

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 Limit1461621377.36019859.0
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.82922824.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.