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

139 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
penne7542385(None) 
benne76521121benne
panne76623651panne
pence94924451pence
penna74520201penna
pennae84314031pennae
penned94217611penned
penner84616661penner
penni74617901penni
penny105119451penny
bene66439492be_ne
bennes86019012bennes
bennet84823362bennet
benni74715362benni
benny105217362benny
bonne75124712bonne
cense75121402cense
dene56643412de_ne
denned84215632denned
dense65923502dense
donne65520462donne
erne46727432_erne
esne47018792_esne
eyne76322462_eyne
fence105319912fence
fennec11326912fennec
fennel9429472fennel
fenny115115132fenny
gene56237222ge_ne
genie66124922genie
genre66016802genre
hence104920042hence
henge94819832henge
henna84414042henna
jennet134714952jennet
jenny153811622jenny
kenned114411272kenned
kennel10369222kennel
kente95821072kente
kerne94718222kerne
lense54523432lense
leone55018822leone
mense75025632mense
mesne75116292mesne
nene45932062ne_ne
pane64950292p_ane
panned94123432panned
panner84224762panner
pannes85522852pannes
peace95026082peace
peage84723572peage
pean66147172pean_
peans75437642peans
pease75231112pease
pee56066512pe__e
peen65938082peen_
peened94318162peened
peens76428192peens
peeve104915252peeve
pein65834942pein_
peined94918842peined
peins76128062peins
peise75825772peise
peke105926202pe_ke
pekoe114612362pekoe
pele65539552pe_le
pen56558842pe_n_
penal75228372penal
penance11313442penance
penang92511112penang
pencel103812912pencel
pend75934532pe_nd
pended103819012pended
pends85527192pends
penes75839222penes
pengo84317592pengo
penile82219602penile
penis75129322penis
penmen10311492penmen
penname11328552penname
pennate93314032pennate
penners93414182penners
pennia84412972pennia
pennies94218812pennies
pennine93712952pennine
pennis84315742pennis
pennon8310642pennon
pens65649642pe_ns
pensee8417312pensee
pent66559072pe_nt
pentane9415742pentane
pentene9313792pentene
peon65635242peon_
peones83821042peones
peons75327182peons
peony105717562peony
pere66450262pe_re
perse75429522perse
pewee10319972pewee
phone105621932phone
pine67755712p_ine
pinene82915642pinene
pinna75320182pinna
pinnae84414642pinnae
pinned94818382pinned
pinner84521502pinner
pinny105222062pinny
plane74929142plane
ponce95222512ponce
pone65747532p_one
prone75332622prone
prune75119632prune
punned93416192punned
punner84918152punner
punnet83518842punnet
punny104217712punny
rennet64624852rennet
rente54733782rente
seine55732872seine
sene46848052se_ne
senna54617982senna
sennet64224142sennet
sense55526822sense
sente56432882sente
spence103813792spence
spense83912432spense
tenge65720442tenge
tenner64117102tenner
tense55225842tense
terne56426152terne
tonne54921432tonne
venae85920982venae
venene92912522venene
venge95117992venge
venine93718432venine
venue84918212venue
wenny114412462wenny
yenned10409382yenned
yente86220042yente

Search took 2 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.360496363.9
2DLD Change Limit538001391.40638264.6
3Display Results1391390.0463021.7
 (SQL Overall)1786911391.81298615.3
 
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.