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

486 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
pappus940837(None) 
palpus104210281palpus
pappous1057461pappous
apps86319692_app_s
campus125213922campus
carpus105514302carpus
kappas144410362kappas
lapsus8437272lapsus
nappas105511612nappas
nappes104515622nappes
palps94719562palp_s
pampas124913992pampas
papas94927492pa_pas
papaws13419112papaws
papers105125322papers
pappi84810892papp_i
pappies103214822pappies
pappose1047412pappose
pappy114713802papp_y
paps86443452pa_p_s
papyrus1444062papyrus
pareus85420742pareus
parous84024162parous
passus83610292passus
peplus10138342peplus
poppas93710712poppas
pupus94614042p_upus
wampus13499012wampus
alps65529243_alp_s
amps86230343_amp_s
ampul91110853_ampul
ampuls1098893_ampuls
amus65529613_a_mus
ankus91410683_ankus
anus47131113_a_nus
apers76629133_apers
apes66047433_a_pes
aphis105917133_aphis
apods86316343_apods
apos65433823_a_pos
app76827603_app__
appal95315223_appal
appals104812943appals
appel94615893_appel
appels104312793appels
apple94517673_apple
apples104315763apples
apply125111393_apply
appose10411993_appose
appulse1134673_appulse
apres75426403_apres
apses76823913_apses
apsis75718293_apsis
arcus76918863_arcus
argus66716543_argus
ascus75013583_ascus
aspis74618143_aspis
asps65622093_asp_s
babus95620333ba_bus
baps86040843ba_p_s
bayous11411153bayous
bupkus14385683bupkus
cactus104912233cactus
callus85317073callus
campos125217953campos
camps116330263camp_s
cantus85117763cantus
capers105428143capers
capes95441923ca_pes
capful1368173capful
capfuls1436523capfuls
caphs124515373ca_phs
capias10318353capias
capons104119503capons
capos94826073ca_pos
capped134721853capped
capper124421983capper
cappers134419403cappers
capris10415083capris
caps87147893ca_p_s
caput9823983ca_put
carps96932253carp_s
casus76419253ca_sus
caucus1039613caucus
corpus106015293corpus
coypus13389303coypus
cuppas12458593cuppas
cyprus1335363cyprus
damps105220413damp_s
dapped124516763dapped
dapper114016633dapper
dapple1138853dapple
dapples1238993dapples
daps77239163da_p_s
famous11412393famous
favus114311733fa_vus
frappes14328383frappes
gallus74313203gallus
gamps105323713gamp_s
gapers94520473gapers
gapes86030823ga_pes
gapped124217123gapped
gappy136212033gapp_y
gaps76042973ga_p_s
gasps85415483gasp_s
gawps115911013gawp_s
grampus12356313grampus
grappas12357103grappas
habus106317143ha_bus
haikus13538293haikus
hakus125114113ha_kus
happed144820103happed
happen134812193happen
happens14359173happens
happy155813533happ_y
haps96443463ha_p_s
harps105926873harp_s
hasps105114643hasp_s
hippos13408433hippos
iambus10468903iambus
japans1539823japans
japers154616173japers
japes146322823ja_pes
jaups144810533jaup_s
kagus105812033ka_gus
kalpas124112943kalpas
kanzus1944603kanzus
kapas116021733ka_pas
kaphs144911503ka_phs
kapoks11347263kapoks
kappa13469743kapp_a
kaput11717063ka_put
koppas14407603koppas
lampas106615953lampas
lamps95624833lamp_s
lapels83712043lapels
lapful1156483lapful
lapfuls1234503lapfuls
lapins84520683lapins
lapis76223153la_pis
lapped114320033lapped
lapper104319953lapper
lappers113717463lappers
lappet103817723lappet
lappets11329123lappets
laps66848873la_p_s
lapses85217693lapses
layups1133993layups
lupous849433lupous
lupus74512523_lupus
magus85318753ma_gus
manus75924933ma_nus
maples104819423maples
mapped134015883mapped
mapper124516093mapper
mappers133313783mappers
maps86141053ma_p_s
naevus934593naevus
nairus639143nairus
napas75924353na_pas
napes74828463na_pes
nappa98511863napp_a
nappe96114993napp_e
napped114218163napped
napper103718283napper
nappers114214863nappers
nappie104112263nappie
nappies114613393nappies
nappy126312333napp_y
naps66238583na_p_s
opus66420593__opus
pablum1237503pablum
pablums1345123pablums
pacas96029403pa_cas
pacers105124543pacers
paces96741113pa_ces
pachas135017143pachas
packs135528933pa_cks
pacs85842183pa__cs
pacts95125803pa_cts
padauk1335643padauk
padauks1443943padauks
padis86227143pa_dis
padles95221123padles
padouk1336683padouk
padouks1434873padouks
padres95016983padres
pads76742953pa__ds
paeans85118263paeans
paeons83915523paeons
pagans95717923pagans
pagers94423253pagers
pages85235073pa_ges
pagods105310193pagods
paiks114719853pa_iks
pails75833063pa_ils
pains75138283pa_ins
paints85921833paints
pairs75325833pa_irs
paisas84317493paisas
palais8420423palais
palapas11311493palapas
pales75753803pa_les
palets85122313palets
palls74332563pa_lls
palms94921753pa_lms
palp85828573palp__
palpal104112053palpal
palped114513643palped
palpi95414553palp_i
pals66951353pa__ls
pampa114913423pamp_a
pamper124316663pamper
pampers133615933pampers
pams85641763pa__ms
pandas95521963pandas
panels84716523panels
panes76148693pa_nes
panful1179743panful
panfuls1237173panfuls
pangas99921103pangas
pangs84628663pa_ngs
panics103815363panics
pannes85522853pannes
panpipes1135173panpipes
pans65855733pa__ns
pantos85222743pantos
pants76536923pa_nts
pap76758403pa_p__
papa85827143pa_p_a
papacy1547493papacy
papadum1475233papadum
papadums1573853papadums
papain10313793papain
papains11312363papains
papal95820673pa_pal
papaw125112493pa_paw
papaya1337503papaya
papayas1437273papayas
paper95128663pa_per
papery134812743papery
papism122211513papism
papisms13238543papisms
papist102618743papist
papists112110453papists
papoose1147513papoose
pappier103511593pappier
pappiest112611113pappiest
pappoose1143803pappoose
papula103011113papula
papule102212133papule
papules112411573papules
papyri1334903papyri
paraphs1439313paraphs
paras76143043pa_ras
pards85634333pa_rds
pareos87023773pareos
parers85530743parers
pares77164483pa_res
pareu74928743pareu_
parges94529543parges
pargos95719043pargos
paries84742513paries
paris75145943pa_ris
parkas125018023parkas
parks116134463pa_rks
parles86334403parles
parlous9414293parlous
parols84722613parols
parrs75928673pa_rrs
pars67560793pa__rs
parses85534703parses
parts77743373pa_rts
parvis116114803parvis
parvos116614753parvos
pas58775743pa___s
paseos88015813paseos
pases75346503pa_ses
pashas115117063pashas
pashes115828393pashes
pass65239953pa__ss
passes86030473passes
pastas85422873pastas
pastes85233913pastes
pastis84924323pastis
pasts75936503pa_sts
patens84820863patens
paters84935833paters
pates76047893pa_tes
pathos115516693pathos
paths105521383pa_ths
patins87528783patins
patios85221783patios
patois84319363patois
pats66460853pa__ts
pauper103511943pauper
paupers114311073paupers
pause75021833pa__use
pauses84621473pauses
pavans115715593pavans
pavers115021823pavers
paves104833923pa_ves
pavins114919663pavins
pavis106422733pa_vis
pawers114818783pawers
pawls105617663pa_wls
pawns108818133pa_wns
pawpaw1653503pawpaw
pawpaws1732823pawpaws
paws96038183pa__ws
paxes144928423pa_xes
payees114812903payees
payers114621823payers
payors114312643payors
payout11714653payout
payouts1247303payouts
pays95940223pa__ys
peeps95822363peep_s
peepul1035783peepul
peepuls1134923peepuls
peplos101211543peplos
peplum12156823peplum
peplums13145503peplums
pepos96620083p_epos
pepped103113403pepped
pepper93512943pepper
peppers103311443peppers
peppy114310363pepp_y
peps85134513p_ep_s
perdus93711273perdus
perps95521483perp_s
phallus1236063phallus
pignus937953pignus
pilaus84114133pilaus
pileus84514943pileus
pilous84717753pilous
pilus75921063p_ilus
pimps114616983pimp_s
pinups1037413pinups
pious74621273p_ious
pipals104213643pipals
pipers104318663pipers
pipes96030143p_ipes
pipets105714773pipets
pipits104713063pipits
pipped104516543pipped
pippin92810303pippin
pippins10319753pippins
pips85837133p_ip_s
platypus1542353platypus
plexus15377283plexus
plops95920333plop_s
plus66324833__plus
poilus82210573poilus
polypus14346933polypus
pompous1338063pompous
pomps115316193pomp_s
poops94422413poop_s
popes95933813p_opes
popgun1145733popgun
popguns1234023popguns
poppa8409893popp_a
popped104117813popped
popper93615963popper
poppers103414863poppers
poppet92717323poppet
poppets10338853poppets
poppies102816193poppies
popple92710983popple
popples103011873popples
poppy114813193popp_y
pops86340953p_op_s
porous84419483porous
poyous112911623poyous
prahus11458243prahus
praus74621753p_raus
preps96220693prep_s
priapus1134353priapus
primus103712173primus
props95726883prop_s
prunus8399363prunus
pulpous1177013pulpous
pulps95116483pulp_s
pumps115520603pump_s
pupas95219283p_upas
pupils10389913pupils
pupped105013273pupped
puppet93514593puppet
puppets10317013puppets
puppies103212613puppies
puppy114912413pupp_y
pups86032233p_up_s
pupu87620713p_upu_
pus55547843___pus
quippus20363543quippus
quipus17458003quipus
radius73914873radius
rakus94413673ra_kus
ralphs1135373ralphs
ramous8417113ramous
ramps96224633ramp_s
ramus76418283ra_mus
rapers84327183rapers
rapes75740723ra_pes
raphes115117453raphes
raphis114014323raphis
rapids94913893rapids
rapped114122683rapped
rappee103618673rappee
rappees113611453rappees
rappel104211953rappel
rappels11448803rappels
rappen103512713rappen
rapper104621573rapper
rappers113618443rappers
raps66247733ra_p_s
rasps74316663rasp_s
repps95114343repp_s
rumpus10458893rumpus
sadhus10298463sadhus
sajous13310583sajous
salpas85116923salpas
salps74423243salp_s
samps96124673samp_s
sapors84118813sapors
sapour83812373sapour
sapours93610623sapours
sapped114422013sapped
sapper103822353sapper
sappers113518903sappers
sappy125413473sapp_y
saps65346373sa_p_s
tabus74820923ta_bus
talus55423263ta_lus
tamps95524083tamp_s
tapas74627713ta_pas
tapers84025813tapers
tapes75838603ta_pes
tapirs84113173tapirs
tapis75028863ta_pis
tapped113820053tapped
tapper104419613tapper
tappers113416543tappers
tappet103820113tappet
tappets113610013tappets
taps66050673ta_p_s
tarps76527113tarp_s
tarsus6310513tarsus
taupes8212673taupes
taus46342733ta__us
taxus125512483ta_xus
tophus115210363tophus
trappous1246023trappous
typhus14395713typhus
typps12549303typp_s
vagus96713813va_gus
valgus1047103valgus
vamps125415483vamp_s
vapors113812693vapors
vapour11378873vapour
vapours12277463vapours
varus85921183va_rus
vatus86114643va_tus
vaus75928923va__us
walrus956433walrus
wammus13426733wammus
wampum15406053wampum
wampums16314213wampums
wamus105514683wa_mus
wapped144416473wapped
waps96642083wa_p_s
warps107126423warp_s
wasps106714693wasp_s
yapoks15346783yapoks
yapons114411773yapons
yapped144415143yapped
yapper133714513yapper
yappers144012253yappers
yaps95933523ya_p_s
yaups105910743yaup_s
yawps13628793yawp_s
zapped204213523zapped
zapper193414023zapper
zappers203911633zappers
zappy21548943zapp_y
zaps156826893za_p_s

Search took 9 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.420425454.8
2DLD Change Limit1127164867.47015089.2
3Display Results4864860.1563115.4
 (SQL Overall)1786914868.04622208.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.