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

438 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
prowess123790(None) 
process11310401process
profess1237711profess
prowest12311531prowest
browless1346652browless
browses124712692browses
crowers124614892crowers
drowses114610232drowses
growers113612722growers
plowers123812242plowers
powers113822322p_owers
precess11310862precess
press75425952pr__ess
prioress1035392prioress
probers113514582probers
probes104119452probe_s
proems104711162pro_ems
progress1137022progress
projets1639162projets
prolegs10379992prolegs
proles84627202prole_s
propels113412842propels
propers113619032propers
prosers94219642prosers
proses84733472prose_s
pross76529402pro__ss
prosses94019512prosses
proteas92015122proteas
protest9317532protest
protests10310492protests
proteus92511592proteus
provers123817792provers
proves114322252prove_s
prower114218122prowe_r
prowesses1437192prowesses
prowlers13328932prowlers
prowls115511082prow_ls
prows106327012prow__s
rowels94515452_rowels
rowens94515302_rowens
rowers94924572_rowers
trowels10358362trowels
armless9369943armless
arouses74921293arouses
arrowless1242803arrowless
artless73712513artless
avowers1336333avowers
baroness101210063baroness
blowers124313593blowers
bowels114315593_bowels
bowers115523703_bowers
bowless123310313_bowless
bowses115718863_bowses
braless92910563braless
brawest123810483brawest
brewers123811053brewers
brokers133111913brokers
bromes104719763brome_s
broses86524403brose_s
browed125216393browe_d
brownest1398893brownest
brownness1444343brownness
browns116415633brow_ns
brows105425983brow__s
browse115713853brow_se
browsed134511233browsed
browser124911143browser
browsers13449203browsers
chowses155611283chowses
cowers114625533_cowers
cress75022833cr__ess
crewels12438483crewels
crewless1335403crewless
crones84729243crone_s
cropless1237793cropless
crores86121163crore_s
cross75124503cro__ss
crosses94220793crosses
crowders14398803crowders
crowds124910763crow_ds
crowed124717293crowe_d
crower114117553crowe_r
crowners133710743crowners
crownets13407673crownets
crownless1443423crownless
crowns115615113crow_ns
crows105727313crow__s
crozers184111083crozers
crozes174417663croze_s
dowels104813343_dowels
dowers104523293_dowers
dowses105718303_dowses
drawees11378363drawees
drawers113610073drawers
dress65319833dr__ess
droners84114383droners
drones75023433drone_s
dross65418093dro__ss
drosses84513823drosses
drovers115212643drovers
droves105116673drove_s
drownds12346153drownds
drowners12428273drowners
drowns105612333drow_ns
drowse105010553drow_se
drowsed12448743drowsed
drowsy13487903drow_sy
dryness11114783dryness
egoless836983egoless
erodes74819883erode_s
eroses65327053erose_s
flowers133413173flowers
froes86126693fro_e_s
frowners14377933frowners
frowns126011393frow_ns
frows116623103frow__s
frowst125512073frow_st
frowsts13426103frowsts
frowsy15498273frow_sy
glowers113412093glowers
grocers103511253grocers
gropers104813853gropers
gropes95220403grope_s
gross65421693gro__ss
grosses84517683grosses
grouses84616543grouses
grovels11427813grovels
groves104318103grove_s
grower104614933growe_r
growlers12327093growlers
growls104711113grow_ls
grows95523923grow__s
growths1494423growths
howes114730263_howe_s
ireless72312243ireless
ironers74813553ironers
irones64724013irone_s
ironness836953ironness
knowers1436343knowers
krewes1337923krewe_s
lioness739103lioness
loess55714703_lo_ess
lowers94624923_lowers
lowes85732463_lowe_s
lowest93915593_lowest
lowness1037813_lowness
mowers113219403_mowers
nowness1037033_nowness
orbless937493orbless
owes75137103__owe_s
parolees104313973parolees
paroles95025883parole_s
patness92912283patness
patroness1137483patroness
pawers114818783p_awers
peeress939503peeress
peewees1236803peewees
pegless1038053pegless
peones83821043peone_s
pertness10310093pertness
pewees11311393p_ewees
phones114121213phone_s
phoneys15437143phoneys
phoresy1534653phoresy
piolets93513193piolets
plotless10256793plotless
plovers123611833plovers
plowed124213203plowe_d
plower114315063plowe_r
plows105419903plow__s
poems95715553p_o_ems
poesy105014063p_o_esy
poetess938933poetess
poets76024443p_o_ets
pogeys124110353p_ogeys
poises84226543p_oises
pokers124617923p_okers
pokes116133013p_oke_s
pokeys15529513p_okeys
poleis86018353p_oleis
polers84225643p_olers
poles75351003p_ole_s
pomes94833933p_ome_s
pones74547043p_one_s
poolers94217423poolers
poorest9312773poorest
poorness1036363poorness
pooves113914713poove_s
popes95933813p_ope_s
pores75849033p_ore_s
porkers134314933porkers
porters93722703porters
portless10310643portless
portress1038323portress
posers84223973p_osers
poses74642763p_ose_s
posses85128803p_osses
possess9419123possess
powders134111553p_owders
power105325953p_owe_r
pows95537663p_ow__s
powters124015663p_owters
poxes145325723p_oxe_s
praises94121103praises
prases84429023prase_s
praters94921653praters
prates84633163prate_s
prawners1346003prawners
prawns11509023praw_ns
praxes156215183praxe_s
prayers124212853prayers
prebless1236823prebless
preens85020113pr_eens
prees75937173pr__ees
prefers123713333prefers
premeds12389583premeds
premiss113513813premiss
prepress12137983prepress
preps96220693pr__eps
presa74319043pr__esa
prese75228383pr__ese
presets94216423presets
presses93523153presses
prest75736353pr__est
prests84021263pr__ests
pretest9517633pretest
pretests10310013pretests
prewash1535213prewash
prexes154915943prexe_s
preyers124412363preyers
preys105717783pr__eys
prezes173614693preze_s
pricers113915063pricers
prices104524543price_s
prides94324183pride_s
priers84521193pr_iers
pries74339533pr_ie_s
priest84125423pr_iest
priests93810863pr_iests
primers114215673primers
primes104225263prime_s
primness1276763primness
princess12266803princess
prises84133173prise_s
priss74623893pr__iss
prisses94816713prisses
privets122910053privets
prizers183911843prizers
prizes173819813prize_s
proas75028803pro__as
probe94320813probe__
probed114114823probe_d
prober104516073probe_r
probits112712573probits
problems1434343problems
proceed12310543proceed
proceeds1335973proceeds
processed1446803processed
processer1346893processer
processes13310233processes
processor1346233processor
procuress1344093procuress
prodders1237463prodders
prods85523553pro__ds
proem94818273pro_e_m
professed1545243professed
professes1437873professes
professor1445033professor
proffers16126593proffers
profits122911243profits
profs105120893pro__fs
profuse1237153profuse
progeny1389463progeny
proggers12258163proggers
progs86624153pro__gs
project1838453project
projects1936413projects
projet15315183proje_t
prolans9314273prolans
prole74527793prole__
proleg94612113prole_g
prolepses13126193prolepses
prolepsis13125063prolepsis
prologs103512133prologs
promise113415843promise
promises122916763promises
promos105116423pro_mos
prompts1337473prompts
proms95426413pro__ms
prone75332623prone__
pronely12310243pronely
proneness11310443proneness
prongs94314483pro_ngs
proofers13118363proofers
proofs114511683pro_ofs
propel103714063prope_l
propend123311273propend
propends13249173propends
propene112716043propene
propenes122816513propenes
propense122410103propense
proper104319953prope_r
prophesy1844453prophesy
prophets1539503prophets
propjets1935493propjets
propose112714843propose
proposes122515973proposes
props95726883pro__ps
propyls14308193propyls
pros65742783pro___s
prose75835123pro__se
prosect11313393prosect
prosects1239473prosects
prosed94921093prose_d
proser84223463prose_r
prosiest10416523prosiest
prosiness11311683prosiness
proso77222413pro__so
prosos85718553pro_sos
prospers123012263prospers
prost75434103pro__st
prosy106319253pro__sy
protases102115033protases
protasis102411973protasis
protea82214763prote_a
protean92412193protean
proteans102811543proteans
protease10209893protease
proteases112110833proteases
protect11313633protect
protects1239743protects
protege1059153protege
proteges1149923proteges
protei82615313prote_i
proteid103513673proteid
proteids11259943proteids
protein92414733protein
proteins102114283proteins
protend104012793protend
protends113010353protends
proteose10229413proteose
proteoses112211013proteoses
proteuses11238993proteuses
protheses1449073protheses
prothesis1449433prothesis
protist9320223protist
protists10313363protists
protons93118003protons
protyls12298463protyls
proudest1138943proudest
proudness1246693proudness
prove104823193prove__
proved125016033prove_d
proven114314773prove_n
prover113819723prove_r
proverb14378213proverb
proverbs15315583proverbs
proviso1237313proviso
provisos1336913provisos
provost1238573provost
provosts1336083provosts
prow97030383prow___
prowar114110943prow_ar
prowl105615123prow__l
prowled13309903prowled
prowler123310013prowler
proxies163014933proxies
prudes94215443prude_s
pruners93710723pruners
prunes83419063prune_s
pryers115012243pr_yers
ptoses83514673ptose_s
pureness101110183pureness
pyoses114314303pyose_s
pyrogens1437293pyrogens
pyrones123113303pyrone_s
pyropes142210193pyrope_s
rawest93615063_rawest
rawness1038153_rawness
recess8314263_recess
reprocess1345933reprocess
reweds104412303_reweds
rewets94617213_rewets
robes75133303_robe_s
rodeos75314503_rodeos
rodes614039083_rode_s
rodless8310073_rodless
roes45954133_ro_e_s
rogers74517913_rogers
roles56747983_role_s
romeos84013173_romeos
rooses65526233_rooses
ropers84325903_ropers
ropes75940063_rope_s
roses56445773_rose_s
rosets65819953_rosets
rotes56143903_rote_s
rouens64814443_rouens
roues56039353_roue_s
rouses65436283_rouses
rovers95423523_rovers
roves84834483_rove_s
rowans95715343_rowans
rowed94034323_rowe_d
rowel84721413_rowe_l
rowen84921153_rowe_n
rower85430493_rowe_r
rows75941753_row__s
rowths12458173_rowths
showers134612683showers
slowest10168713slowest
slowness1135013slowness
snowless1145623snowless
sowens93613153_sowens
sowers94923443_sowers
spryness1334003spryness
thowless1434613thowless
throwers14106033throwers
towels94314643_towels
towers94423673_towers
tress55423163tr__ess
trokes104019263troke_s
trones65629283trone_s
tropes84824353trope_s
trovers103713323trovers
troves94719113trove_s
trowed104714653trowe_d
trowel94211463trowe_l
trows88826183trow__s
trowsers11428003trowsers
trowths1365023trowths
uprouses1037553uprouses
vowels124410483_vowels
vowers124317183_vowers
vowless13246603_vowless
vrows116115263vrow__s
wryness13113983wryness
yowes114926373_yowe_s

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.1561145455.1
2DLD Change Limit1340274386.68620045.9
3Display Results4384380.1433062.9
 (SQL Overall)1786914386.98525582.1
 
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.