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

240 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
petnap103742(None) 
petnaps1145031petnaps
catnap1098382catnap
etna46415262_etna_
etnas54713932_etnas
penal75228372pe_nal
penna74520202penna_
pennae84314032pennae
pentad9313762pentad
petal76526892pet_al
petnaper1243912petnaper
petsai838082petsai
atap66722453_at_ap
becap114315053be_cap
beleap10410283beleap
beta66234133bet_a_
betas75528763bet_as
betray111511443betray
betta74916843betta_
bettas84913923bettas
bewrap13157053bewrap
bitmap1235613bitmap
catnaps1197033catnaps
catnip1097973catnip
centai84814783centai
cental84420963cental
centas85020703centas
cetane8315283cetane
denar65223293de_nar
dental74319173dental
dewlap1264843dewlap
dognap1035343dognap
entrap8710563entrap
eta35834193_et_a_
etape74413703_et_ape
etas46432273_et_as
feta76528903fet_a_
fetal85623373fet_al
fetas85624403fet_as
fetial95716193fetial
gelcap1136213gelcap
genip84415203ge_nip
geta56627443get_a_
getas65421483get_as
getup83410263get_up
heap96432893he__ap
henna84414043henna_
hennas94211803hennas
hetman112510603hetman
jetlag1434523jetlag
jetsam15116323jetsam
jetway19105273jetway
kenaf12316033ke_naf
kidnap1334193kidnap
knap105815403__knap
leap66032683le__ap
lethal939803lethal
letup73712163let_up
menad85918983me_nad
menta74424423menta_
mental84521603mental
meta65932413met_a_
metal75427383met_al
metepa1066013metepa
metump1235713metump
nap56753203___nap
neap66927013ne__ap
netop7312343net_op
padnag1036073padnag
pap76758403p___ap
patina86022193patina_
patinae95414403patinae
patinas96318523patinas
pea56657243pe__a_
peag75431343pe__ag
peak106535203pe__ak
peal68648103pe__al
pean66147173pe__an
peans75437643pean_s
peanut8318183peanut
pear69745233pe__ar
peas65755063pe__as
peat65967933pe__at
pecan91919033pe_can
pecans101515833pecans
pechan13511543pechan
pedal86022503pe_dal
pedant9319493pedant
pedlar93311273pedlar
peen65938083peen__
peened94318163peened
peens76428193peen_s
peep85833693pe__ep
pein65834943pein__
peined94918843peined
peins76128063pein_s
pekan111613973pe_kan
pekans121710553pekans
pen56558843pe_n__
penang92511113pe_nang
pence94924453pe_nce
pend75934533pe_n_d
pends85527193pe_nds
penes75839223pe_nes
pengo84317593pe_ngo
penial84120893penial
penis75129323pe_nis
penman10312323penman
penname11328553penname
pennant9312493pennant
pennate93314033pennate
penne75423853pe_nne
penned94217613penned
penner84616663penner
penni74617903pe_nni
pennia84412973pennia
pennis84315743pennis
pennon8310643pennon
penny105119453pe_nny
pens65649643pe_n_s
pent66559073pe_n_t
pentads1039523pentads
pentane9415743pentane
pentyl1138813pentyl
peon65635243peon__
peonage1048723peonage
peones83821043peones
peons75327183peon_s
peony105717563peon_y
pep76447083pe___p
pepla9312863pepla_
perea75026443perea_
perhaps1446123perhaps
periapt11313413periapt
pernio8513143pernio
pernod9310453pernod
perp89029893pe__rp
pet56477303pet___
petals84719813petals
petard95013803petard
peter74427593pet_er
peters86624593peters
petit74332653pet_it
petite84320653petite
petnapers1343823petnapers
petnaping1444543petnaping
petnapped1342383petnapped
petnapper1242453petnapper
petrale9312623petrale
petrel83111533petrel
petrol82714063petrol
pets66248333pet__s
petsais938433petsais
petted94121523petted
petter83924773petter
petti75119453pet_ti
pettle84116053pettle
petto76021043pet_to
petty105320293pet_ty
petunia966803petunia
petunias1066013petunias
peytral1287503peytral
phonal11310383phonal
pieta75421753piet_a_
pietas84516503piet_as
pina65842633p_ina_
pinas75434453p_inas
pinna75320183pinna_
pinnae84414643pinnae
pinnal84814273pinnal
pinnas85315513pinnas
pinta75727053pinta_
pintas85021393pintas
pinup9612883p_inup
pita65436433pit_a_
pitas77427673pit_as
pitman102412123pitman
pitsaw1135613pitsaw
pitta75018693pitta_
pittas86014523pittas
planar84212713planar
plena75816393plena_
pleonal937243pleonal
potman102813573potman
preanal9310713preanal
pretape113511623pret_ape
pretax152310193pret_ax
prewrap14104973prewrap
puna65331653p_una_
punas74826753p_unas
reap65934743re__ap
recap95718023re_cap
redcap1158493redcap
regna64614813regna_
regnal74812933regnal
remap95418103re_map
renal55929503re_nal
rental63922023rental
retag63618413ret_ag
retape83917683ret_ape
retax124517973ret_ax
reteam83214533reteam
retear63115483retear
retia55326113retia_
retial64724993retial
retina65023383retina_
retinae75517333retinae
retinal75318353retinal
retinas74819353retinas
retral64419743retral
rewrap11127533rewrap
satrap86212553satrap
senna54617983senna_
sennas64214233sennas
seta45637313set_a_
setae56026223set_ae
setal56430903set_al
setup73915823set_up
snap65727033__snap
strap77925263_strap
tap57663873__t_ap
tetanal738023tetanal
tetany959843tetany
tetra53417953tetra_
tetrad73612053tetrad
tetras63017623tetras
trap67532803__trap
unsnap836203unsnap
veena81912323veena_
veenas91410413veenas
veinal93812963veinal
vena76126293ve_na_
venae85920983ve_nae
venal85523213ve_nal
vernal93514213vernal
watap102111673wat_ap
yenta83917043yenta_
yentas94614213yentas
zeta135121643zet_a_
zetas145018163zet_as

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162405.76619548.4
3Display Results2402400.0803000.0
 (SQL Overall)1786912406.23628654.7
 
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.