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

159 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
distends1033982(None) 
dispends12308531dispends
distend93312071distend_
mistends11419591mistends
descends12266982descends
disbands1237352disbands
dispend11289412dispend_
dissents93411862dissents
distended12157922distended
distender11167742distender
distenders12166732distenders
distent84120852disten_t
intends8239962_intends
listens74014132listen_s
missends11368232missends
mistend103812522mistend_
ascends10388203_ascends
attends8257593_attends
bartends1136793bartends
besteads11307123besteads
bilsteds1134273bilste_ds
bisters93922613biste_rs
cisted95217523ciste_d_
cisterns10369573cisterns
contends112810573contends
dastards10278083dastards
defends12358773d_efends
depends11348993d_epends
desands94810163des_ands
descend11248153descend_
descents112511203descents
desponds1246243desponds
destines93619663destines
detents83615153d_etents
diamonds12125173diamonds
diastemas12234393diastemas
diastems11226523diaste_ms
diasters92913183diaste_rs
dickens144410133dicken_s
dienes75719903di__enes
diesters92513603dieste_rs
dieted83115493diete_d_
dieters83216433diete_rs
diluents946053diluents
dinted84419843dinte_d_
disband1138243disband_
disbuds11125243dis_buds
discants112912023discants
discards1238913discards
disced104914653disce_d_
discepts1336743discepts
discerns1138163discerns
discoids1239873discoids
discords1238593discords
disendow1343813dis_endow
disendows1444083dis_endows
diseurs839403dis_eurs
dished114318713dishe_d_
dishelms1444723dishelms
dishes104622653dishe__s
disjects18275923disjects
disked125015763diske_d_
dismes95617673disme__s
disowns1136733disown_s
dispels10310503dispe_ls
dispended14147823dispended
dispense11129783dispense
dispenses121210763dispenses
dispreads1346003dispreads
disseats93211503disseats
dissects11279243dissects
dissed85220183disse_d_
dissensus1044353dissensus
dissent84018683dissen_t
disserts92411813disserts
disses75225963disse__s
distaffs1565083distaffs
distains9413603distains
distance11311853distance
distances12311653distances
distant83519953distan_t
distaves12311403distaves
distending1348333distending
distichs1447633distichs
distills9319043distills
distils83015803dist_ils
distinct11410763distinct
distomes11314163distomes
distorts91112353distorts
distress9311713distress
disturbs1145403disturbs
dites66339153di_te__s
dividends15273313dividends
dizens164911393di_zen_s
dusted83918373duste_d_
dusters84918363duste_rs
dustings10419033dustings
existents1644983existents
extends15227113_extends
fastens105511753fasten_s
fiends104110293fi__ends
fisted104218703fiste_d_
glistens9366593glisten_s
hastens106214813hasten_s
histed104420243histe_d_
histones11312803histones
impends12376803_impends
intend72310373_intend_
intents72115703_intents
islands837323_islands
kittens11347583kitten_s
listed74322833liste_d_
listees73416673liste_es
listels74212433liste_ls
listen64816813listen__
listened9168813listened
listener8158313listener
listeners9147323listeners
listers74026533liste_rs
listings93310043listings
minuends1143893minuends
misbinds1345163misbinds
misdeeds12276813misdeeds
misfeeds14315623misfeeds
misleads11358543misleads
mispens11311073mispen_s
misreads11268923misreads
missend104411373missend_
misspends1443853misspends
misted93625823miste_d_
mistended13137333mistended
misterms123711353misterms
misters93927513miste_rs
mistunes10311133mistunes
mittens9349883mitten_s
moistens10268773moisten_s
pistes85325633piste__s
pistons93016373piston_s
portends11358963portends
pretends11299113pretends
protends113010353protends
resends83513713res_ends
scends95213003__scends
sends65528243__s_ends
shends105313773__shends
sisters73721593siste_rs
spends94714473__spends
stands75118053__stands
steads74116223__steads
steeds73814883__steeds
stenos63915773__stenos
stents65019453__stents
subtends1136173subtends
suspends1145143suspends
tends65425583___tends
upsends10265293ups_ends
upstands1144093upstands
wisents10249063wis_ents
wisted104120273wiste_d_

Search took 9 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.440406115.9
2DLD Change Limit1461621597.51319454.5
3Display Results1591590.0632523.8
 (SQL Overall)1786911598.01622291.8
 
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.