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

442 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
pencels11361005(None) 
pencel103812911pencel_
pencils113011771pencils
cancels114113312cancels
excels1536662_excels
fencers123810622fencers
fences114617112fence_s
fennels10387902fennels
kennels11387192kennels
panels84716522pan_els
parcels113712662parcels
peaces106324082peace_s
pedicels1336252pedicels
peels75226422pe__els
pence94924452pence__
pencil103712972pencil_
penes75839222pen_e_s
penicils1247862penicils
penners93414182penners
penoncels1343592penoncels
pensees9311202pensees
pensils92811592pensils
pentyls1236522pentyls
petrels9279372petrels
pincers113916502pincers
ponces104720842ponce_s
spancels1245272spancels
spencers12269192spencers
spences113413922spence_s
tercels94110362tercels
aeneus61111143aen_eus
angels74416173_angels
bedels94015273be_dels
benchers153611013benchers
benches143918603benches
bendees103913863bendees
benders104021063benders
benes75536233ben_e_s
bennes86019013benne_s
bennets94712163bennets
benzols1836673benzols
benzyls2133673benzyls
betels84515063be_tels
bethels1238533bethels
bevels113913983be_vels
bezels173712283be_zels
cancel105316683cancel_
cancers114018583cancers
cannels93413363cannels
carcels114516063carcels
cels65534973___cels
cenacles1238023cenacles
censers94313903censers
censes83721803cense_s
centals94317053centals
centers94420603centers
chancels15439083chancels
conceals123111013conceals
crenels93711013cren_els
dancers103413093dancers
dances95120653dance_s
decals93717713de_cals
deckels14367363deckels
defuels11296983defuels
deicers103612733deicers
deices94119373deice_s
denes65639723den_e_s
denials84114133denials
deniers84515183deniers
denies74729643denie_s
densely1146713densely
dentals83915393dentals
dentils84115583dentils
deuces94015513deuce_s
devels104313903de_vels
donzels1735393donzels
dunces95215753dunce_s
dynels10536813dyn_els
easels65914553_easels
eels46536743_e__els
emcees1037813_emcees
enamels9128163_enamels
enders74324053_enders
enols54718403_en_ols
enrols61213383_enrols
enters64425643_enters
excel1437743_excel_
excess1546053_excess
expels1547173_expels
feces105625363fe_ce_s
feels85223043fe__els
fence105319913fence__
fenced124412713fence_d
fenceless1444163fenceless
fencer114613533fence_r
fenders113717263fenders
fennecs12305693fennecs
fennel9429473fennel_
ferrels10248623ferrels
funnels10348173funnels
genders93616783genders
genes65133093gen_e_s
genets75716663gen_ets
genies75324943genie_s
genres75515623genre_s
gentes75324163gente_s
gentles83714343gentles
gunnels8358563gunnels
gunsels8338133gunsels
hances115621283hance_s
hansels104011653hansels
heels85625533he__els
hence104920043hence__
henges104516463henge_s
henleys1334843henleys
jebels15418913je_bels
jennets14517633jennets
jewels16508613je_wels
keels94622413ke__els
kenches163912273kenches
kennel10369223kennel_
kentes105118653kente_s
kernels11417953kernels
kevels134410713ke_vels
kneels10408933_kneels
lancers93616643lancers
lances84824103lance_s
lancets93411163lancets
lenders84419643lenders
lenes54738523len_e_s
lenses64620893lense_s
lenticels1184493lenticels
lentils73912973lentils
levels94113283le_vels
lintels73311163lintels
mangels103614493mangels
mantels94515043mantels
marcels113212373marcels
menacers12279313menacers
menaces112715523menace_s
menders103818803menders
menials94015683menials
menses84222453mense_s
mentees93214503mentees
mercers114412773mercers
merces105720743merce_s
mescals112911563mescals
mezcals20246533mezcals
mincers113714853mincers
minces104420803mince_s
nances83618643nance_s
nenes55329673nen_e_s
newels93710823ne_wels
noels56418703__noels
nonces84418833nonce_s
nuncles939843nuncles
oenomels1044583oenomels
openers9339493open_ers
openness1035473openness
opercele1244593opercele
operceles1344613operceles
ounces83617773ounce_s
pacers105124543p_acers
paces96741113p_ace_s
panaceas1236763panaceas
pancreas1235393pancreas
panders103423733panders
panel76023623pan_el_
panes76148693pan_e_s
panfuls1237173panfuls
pangens103112063pangens
panicles121010113panicles
paniers94717333paniers
panners93621273panners
pannes85522853panne_s
panzers184012013panzers
parcel103915473parcel_
parrels94713493parrels
pascals11610013pascals
passels93913023passels
pastels95215183pastels
peace95026083peace__
peaced115818913peace_d
peachers153213843peachers
peaches144120053peaches
peages94321853peage_s
peahens12307573peahens
peals75235493pe__als
pearls84715393pe_arls
peases85229473pease_s
peaveys15324063peaveys
pebbles1337573pebbles
pecans101515833pe_cans
pechs125516203pe_c_hs
peckers153312673peckers
pecks135724433pe_c_ks
pecs84634103pe_c__s
pectens11189203pectens
pedals94316033pe_dals
peddles112913703peddles
pedes85327293pe_de_s
pedicel1237813pedicel_
pedicles1338683pedicles
pedlers103013273pedlers
pedocals1346083pedocals
peduncles1443643peduncles
peeks115021113pe__eks
peel65535613pe__el_
peelers93615593peelers
peens76428193pe__ens
peepers113713673peepers
peeps95822363pe__eps
peepuls1134923peepuls
peeress939503peeress
peers75130273pe__ers
pees65257373pe__e_s
peeves113814873peeve_s
peewees1236803peewees
pegless1038053pegless
peises84125043peise_s
pekes114623563pe_ke_s
pekoes124410423pekoe_s
peles75738083pe_le_s
pellets94014783pellets
pelmets11309693pelmets
pelters93720313pelters
pelves114514663pelve_s
penal75228373pen_al_
penally121111773penally
penances12312443penance_s
penangs10268373penangs
penates93321603penates
penciled1337823penciled
penciler1237113penciler
pencilers1345643pencilers
pended103819013pende_d
pendent10314723pendent
pendents1139413pendents
pends85527193pen__ds
pengos94612413pen_gos
penial84120893penial_
penicil1138833penicil_
penile82219603pen_ile
penis75129323pen__is
penises9318193penises
penmen10311493penme_n
penne75423853penne__
penned94217613penne_d
penner84616663penne_r
pennies94218813pennies
pennis84315743pen_nis
pennoncels1452163pennoncels
pennons939713pennons
penoches1538933penoches
penoncel1244843penoncel_
pens65649643pen___s
pensee8417313pense_e
pensil83013333pensil_
pensile92713543pensile
pensters103012123pensters
pentacles1338773pentacles
pentads1039523pentads
pentene9313793pentene
pentenes10315633pentenes
pentyl1138813pentyl_
penuches1536943penuches
penuchis1544283penuchis
penuchle1543763penuchle
penuchles1643763penuchles
penuckle1643263penuckle
penuckles1743243penuckles
penult8314653pen_ult
penults937123penults
peones83821043peone_s
peonies93620153peonie_s
peoples11312223peoples
peppers103311443peppers
percale11314093percale
percales12313803percales
percent113520603percent
percents122713373percents
percept133112523percept
percepts14247643percepts
perchers153611523perchers
perches143717953perches
percuss1137163percuss
peres76246643pe_re_s
perils84121853pe_rils
perses85428063perse_s
pesters93827093pesters
pestles93217693pestles
petals84719813pe_tals
peters86624593pe_ters
petrel83111533petrel_
petrols92913083petrols
petters93722363petters
pettles93916483pettles
pewees11311393pe_wees
pewters124113353pewters
peyotls1233633peyotls
peytrels1363373peytrels
phenols1238103phen_ols
phenyls1534333phen_yls
piculs103511753p_iculs
piecers114112253piecers
pieces104217273piece_s
piercers12316723piercers
pierces113411193pierce_s
pincer104019173pince_r
pinchers153510613pinchers
pinches144117933pinches
pinders103720473pinders
pineals93212843pineals
pines76048863pin_e_s
pingers104020743pingers
pinkens13419643pinkens
pinkers134118603pinkers
pinkeys16378213pinkeys
pinners93518603pinners
pinocles1248693pinocles
pinoles93418703pinoles
pintles94118723pintles
pixels15478533p_ixels
placers114515263placers
places104323703place_s
placets113911223placets
plenches153110623plenches
pommels13235783pommels
ponce95222513ponce__
ponced114314813ponce_d
ponchos143410703ponchos
ponders103618843ponders
pones74547043pon_e_s
pongees104212543pongees
ponies84833463ponie_s
pontes83627853ponte_s
pontils9312213pontils
potences12710693potence_s
pouncers12349203pouncers
pounces114113893pounce_s
prancers123210333prancers
prances113618773prance_s
precancels1644063precancels
precess11310863precess
prequels1934833prequels
pretzels1934033pretzels
pricers113915063pricers
prices104524543price_s
princely1545153princely
princes113015143prince_s
princess12266803princess
process11310403process
propels113412843propels
puces94924633p_uce_s
pummels13236543pummels
punchers152610073punchers
punches144816133punches
pungles104013713pungles
punkers133714853punkers
punkeys16366493punkeys
punners94114233punners
punnets9409263punnets
punters93617043punters
rances84625443rance_s
rebels84518133re_bels
recces10614913recce_s
recess8314263re_cess
reels55333263re__els
refeels10379693refeels
refels94618053re_fels
refuels10399523refuels
reheels10298253reheels
renails74917263renails
renders83821673renders
renews93811753ren_ews
rennets75212633rennets
rentals74017473rentals
renters74224813renters
rentes65431193rente_s
repels84318763re_pels
revels94220573re_vels
rondels82510053rondels
ronnels7318613ronnels
runnels7329153runnels
seances93015343seance_s
seels55632823se__els
seidels838393seidels
sendals81912263sendals
senders83022353senders
senecas939013senecas
seniles72618023seniles
sennets73712583sennets
senseis73310643senseis
senses63923943sense_s
sequels1665703sequels
spancel1147363spancel_
spaniels1045963spaniels
speels85116393spe__els
spence103813793spence__
spencer113610973spence_r
spenders113211743spenders
spenses92913573spense_s
spinels94512443spin_els
stencils1046403stencils
teasels74311313teasels
teazels16406893teazels
teels55726373te__els
tenaces92814513tenace_s
tenails73713923tenails
tenches123515523tenches
tenders83719723tenders
tenets65518953ten_ets
tenners74014923tenners
tenrecs936033tenrecs
tensely1037363tensely
tenses64722553tense_s
tenters73921103tenters
tenues63816443tenue_s
tercel83612993tercel_
terces83921413terce_s
tercets93512443tercets
tiercels10344733tiercels
tincals93610643tincals
tinsels738373tinsels
tunnels7328723tunnels
uncles8317163_uncles
vendees114011453vendees
venders113717003venders
veneers103710293veneers
venges104015153venge_s
venters103717733venters
venues95115203venue_s
venules104011483venules
vessels1035933vessels
weasels10468503weasels
wedels103811033we_dels
wenchers16319213wenchers
wenches152914133wenches
wincers123415363wincers
winces114819113wince_s
winceys15395523winceys
yentes95517603yente_s

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 Filter1786911340270.436409841.7
2DLD Change Limit1340274426.26621389.6
3Display Results4424420.1732554.9
 (SQL Overall)1786914426.87525991.4
 
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.