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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
dense6592350(None) 
cense75121401cense
dene56643411den_e
denes65639721denes
dens55945071dens_
denser74115191denser
lense54523431lense
mense75025631mense
sense55526821sense
tense55225841tense
bene66439492ben_e
benes75536232benes
benne76521122benne
bens65945702bens_
cease75227652cease
censed94016322censed
censer84516582censer
censes83721802censes
dance85223132dance
dans56748142dans_
deans66131392deans_
deash95617242deash
deave95022332deave
debase94014472debase
debs76530242debs_
debye1138902debye
dee47665822de__e
dees56356632dees_
defense1137502defense
defuse105712722defuse
deice84320032deice
deism84116032deism
deist64633592deist
deke95228762de_ke
dekes105224452dekes
dele56843082de_le
deles65139252deles
dels56745472dels_
delve96018262delve
deme76536282de_me
demes86032692demes
demise94618322demise
den47554342den__
denar65223292denar
dengue838252dengue
deni56929392den_i
denied84318632denied
denier74420692denier
denies74729642denies
denim85518842denim
denned84215632denned
denote74118042denote
densely1146712densely
densest83112472densest
dent57158412den_t
dented84120512dented
dents65031802dents
denude8169352denude
deny86027122den_y
depose94215762depose
dere56845902de_re
desex13311982de_sex
desk95618902de_sk
deuce84517492deuce
devise104215752devise
devs86424032devs_
dews86230602dews_
dexes135224512dexes
dexie134716892dexie
deys85027472deys_
diene65720132dien_e
dienes75719902dienes
dine55555332din_e
dines66449152dines
dinge75627302dinge
dins56652042dins_
done55747912don_e
donee66931012donee
donne65520462donne
dons56048702dons_
donsie7613642donsie
donsy96414682donsy
dose56442432d_ose
douse66329722douse
dowse96020812dowse
druse64817662druse
duende836922duende
dulse65415042dulse
dunce86319262dunce
dune56137582dun_e
dunes65332172dunes
duns55140432duns_
dyne85320932dyn_e
dynes95917582dynes
ease45042332_ease
else45923082_else
ens37245922_ens_
ensue54013832_ensue
esne47018792_esne
fease84824872fease
fence105319912fence
fens76139762fens_
fesse86116332fesse
flense938902flense
geese64316002geese
gene56237222gen_e
genes65133092genes
genie66124922genie
genre66016802genre
gens55740072gens_
hanse85722792hanse
hence104920042hence
henge94819822henge
hens75642572hens_
jesse126012832jesse
kens85435232kens_
kente95821062kente
lease55230262lease
lenes54738522lenes
lens46146492lens_
lensed74015472lensed
lenses64620892lenses
manse75528222manse
mensa75318662mensa
mensae84114042mensae
mensed93916542mensed
menses84222452menses
mensh105413552mensh
mesne75116292mesne
nene45932062nen_e
nenes55329672nenes
pease75231112pease
peise75825772peise
pence94924452pence
penes75839222penes
penne75423852penne
pens65649642pens_
pensee8417312pensee
perse75429522perse
rente54733782rente
reuse56025362reuse
rinse54820972rinse
seise54727852seise
sene46848052sen_e
sensa54117472sensa
sensed73918162sensed
sensei64712592sensei
senses63923942senses
sente56432872sente
spense83912432spense
tease55428712tease
tenge65720432tenge
tens45647412tens_
tensed74817832tensed
tenser64919432tenser
tenses64722552tenses
terse55026822terse
venae85920982venae
venge95117982venge
venose9310842venose
venue84918212venue
verse84723582verse
wens76337932wens_
yens75832262yens_
yente86220042yente

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001651.90628226.7
3Display Results1651650.0602750.0
 (SQL Overall)1786911652.05986785.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.