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

176 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
penname1132855(None) 
pennae84314031penna_e
pennames12287791pennames
pennate93314031pennate
bename103316072be_name
penance11313442penance
penna74520202penna__
pennant9312492pennant
pennated11299542pennated
penne75423852penn__e
pennine93712952pennine
pentane9415742pentane
peonage1048722peonage
pinnace113510312pinnace
pinnae84414642pinna_e
pinnate93613742pinnate
prename11412642prename
rename82718812re_name
rennase738712rennase
became123213163be_came
beldame1237233beldame
benamed122911093be_named
benames112814603be_names
benne76521123benn__e
beshame1447483beshame
biennale1044103biennale
byname13256363_byname
centare93113703centare
centime114513033centime
connate9315753connate
defame123212433de_fame
degame102713183de_game
dentate8315153dentate
dunnage9175213dunnage
empennage1441943empennage
enamel81210113_e_namel
enate54428153_e_nate
encage93713503_encage
encamp1235943_encamp
encase83714363_encase
endgame1145233_endgame
enface112510353_enface
enflame1236573_enflame
enframe1247363_enframe
engage82812103_engage
enlace82213233_enlace
ennuye973753_ennuye
enrage72715073_enrage
ensnare767123_ensnare
enzyme2054343_enzyme
gendarme1243523gendarme
gennaker1342923gennaker
genome94312193ge_nome
henbane1237363henbane
henna84414043henna__
hennaed1135103hennaed
hennas94211803henna_s
innage73011573_innage
innate63917313_innate
jobname1842933jobname
menace103216943me_nace
menage93216543me_nage
mensae84114053mensa_e
misname11119483misname
name65637413___name
neonate7311333neonate
nongame1038183nongame
panama104213353p_anama
pancake1536673pancake
panne76623653pann__e
pawnage1335873pawnage
peace95026083pe__ace
peage84723573pe__age
pease75231113pe__ase
pectase112410363pectase
pectate112214693pectate
pedate93117763pe_date
peerage1089803peerage
pelage9515363pe_lage
peltate92013773peltate
penal75228373pe_na_l
penanced1338163penanced
penances12312443penances
penang92511113pe_nang
penangs10268373penangs
penates93321603pe_nates
pence94924453pe_n_ce
pendant10314853pendant
penial84120893penia_l
penile82219603pe_nile
penknife1752543penknife
penlite9313243penlite
penman10312323penma_n
penmen10311493pe_n_men
pennants1037063pennants
penned94217613penn_ed
penner84616663penn_er
penners93414183penners
penni74617903penn__i
pennia84412973penn_ia
pennies94218813pennies
pennines103112043pennines
penning103616493penning
pennis84315743penn_is
pennon8310643penn_on
pennoned1136313pennoned
pennons939713pennons
penny105119453penn__y
penoche1447043penoche
pensee8417313pe_nsee
pensile92713543pensile
pensive122610393pensive
pentacle1239383pentacle
pentad9313763penta_d
pentads1039523pentads
pentamery1644023pentamery
pentanes10316083pentanes
pentene9313793pentene
pentode1039893pentode
pentose9311593pentose
penuche1435943penuche
peonages1138473peonages
percale11314093percale
perennate1147783perennate
perfume1446503perfume
pervade1337023pervade
pesade9311103pe_sade
petnap1037423petna_p
petnaper1243913petnaper
petnaps1145033petnaps
petrale9312623petrale
pfennige1461823pfennige
phenate12412203phenate
phonate12411813phonate
phoneme1446203phoneme
pinna75320183pinna__
pinnaces12268863pinnaces
pinnacle12416963pinnacle
pinnal84814283pinna_l
pinnas85315523pinna_s
pinnated11338553pinnated
pinnule936003pinnule
pinwale1257843pinwale
planate9314573planate
preflame1545913preflame
pregame1239553pregame
prenames12311643prenames
pronate9418873pronate
reclame11411063reclame
reframe1239393reframe
renamed103114523re_named
renames92418053re_names
rennases848983rennases
senate63725173se_nate
senna54617983senna__
sennas64214233senna_s
sensate7311893sensate
sesame8311013se_same
surname937603surname
tannage8209583tannage
tannate71813523tannate
teenage8108053teenage
tenace82715693te_nace
teniae64517353tenia_e
tentage81010643tentage
ternate7415483ternate
tonnage8168053tonnage
tunnage8166373tunnage
unnamed102410273_unnamed
untame82513603_untame
username1042583username
venae85920983ve_na_e
vendace1357363vendace
venenate1147933venenate
ventage11109623ventage
wannabe1234533wannabe

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271766.84619577.4
3Display Results1761760.0602933.3
 (SQL Overall)1786911767.30924448.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.