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

365 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
profess123771(None) 
process11310401process
prowess1237901prowess
precess11310862precess
prefers123713332prefers
press75425952pr__ess
prioress1035392prioress
probers113514582probers
probes104119452probe_s
proems104711162pro_ems
professed1545242professed
professes1437872professes
professor1445032professor
proffers16126592proffers
profits122911242profits
profs105120892prof__s
profuse1237152profuse
progress1137022progress
projets1639162projets
prolegs10379992prolegs
proles84627202prole_s
proofers13118362proofers
propels113412842propels
propers113619032propers
prosers94219642prosers
proses84733472prose_s
pross76529402pro__ss
prosses94019512prosses
proteas92015122proteas
protest9317532protest
protests10310492protests
proteus92511592proteus
provers123817792provers
proves114322252prove_s
prowest12311532prowest
armless9369943armless
arouses74921293arouses
artless73712513artless
baroness101210063baroness
braless92910563braless
brokers133111913brokers
bromes104719763brome_s
broses86524403brose_s
browless1346653browless
browses124712693browses
confess12399903confess
cress75022833cr__ess
crofters13358903crofters
crofts114910593crof_ts
crones84729243crone_s
cropless1237793cropless
crores86121163crore_s
cross75124503cro__ss
crosses94220793crosses
crowers124614903crowers
crozers184111083crozers
crozes174417663croze_s
dress65319833dr__ess
droners84114383droners
drones75023433drone_s
dross65418093dro__ss
drosses84513823drosses
drovers115212643drovers
droves105116673drove_s
drowses114610233drowses
dryness11114783dryness
egoless836983egoless
erodes74819883erode_s
eroses65327053erose_s
fess76529163___fess
froes86126693fro_e_s
gofers104711513_gofers
grocers103511253grocers
gropers104813853gropers
gropes95220403grope_s
gross65421693gro__ss
grosses84517683grosses
grouses84616543grouses
grovels11427813grovels
groves104318103grove_s
growers113612723growers
hoofers134513323hoofers
hoofless14258013hoofless
ireless72312243ireless
ironers74813553ironers
irones64724013irone_s
ironness836953ironness
lioness739103lioness
loess55714703_lo_ess
orbless937493orbless
parolees104313983parolees
paroles95025883parole_s
patness92912283patness
patroness1137483patroness
peeress939503peeress
pegless1038053pegless
peones83821043peone_s
pertness10310093pertness
phones114121213phone_s
phoneys15437143phoneys
phoresy1534653phoresy
pilfers1238963pilfers
piolets93513193piolets
plotless10256793plotless
plovers123611833plovers
plowers123812243plowers
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
poofs105222793poof__s
poofters1336923poofters
poolers94217423poolers
poorest9312773poorest
poorness1036363poorness
pooves113914713poove_s
popes95933813p_ope_s
pores75849033p_ore_s
porkers134314933porkers
porters93722703porters
portless10310643portless
portress1038323portress
posers84223973p_osers
poses74642763p_ose_s
posses85128803p_osses
possess9419123possess
powers113822323p_owers
poxes145325723p_oxe_s
praises94121103praises
prases84429023prase_s
praters94921653praters
prates84633163prate_s
praxes156215183praxe_s
prayers124212853prayers
prebless1236823prebless
preens85020113pr_eens
prees75937173pr__ees
prefabs1435163prefabs
prefect141011073prefect
prefects1598133prefects
prefer113813203prefe_r
premeds12389593premeds
premiss113513813premiss
prepress12137983prepress
preps96220693pr__eps
presa74319043pr__esa
prese75228383pr__ese
presets94216423presets
presses93523153presses
prest75736353pr__est
prests84021263pr__ests
pretest9517633pretest
pretests10310013pretests
prexes154915953prexe_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
proceed12310553proceed
proceeds1335983proceeds
processed1446803processed
processer1346893processer
processes13310233processes
processor1346233processor
procuress1344093procuress
prodders1237463prodders
prods85523553pro__ds
proem94818273pro_e_m
prof96134663prof___
profane122111863profane
profaners14256213profaners
profanes132311573profanes
professing16106623professing
profession1546593profession
professors1555253professors
proffer15126933proffer
profile123211153profile
profilers14236293profilers
profiles133211233profiles
profit113016273prof_it
profiters14228313profiters
profitless1542763profitless
progeny1389463progeny
proggers12258163proggers
progs86624153pro__gs
project1838453project
projects1936413projects
projet15315183proje_t
prolans9314273prolans
prole74527793prole__
proleg94612113prole_g
prolepses13126193prolepses
prolepsis13125063prolepsis
prologs103512133prologs
promise113415843promise
promises122916763promises
promos105116423pro_mos
prompts1337473prompts
proms95426413pro__ms
prone75332623prone__
pronely12310253pronely
proneness11310443proneness
prongs94314483pro_ngs
proofed13138723proofe_d
proofer12149103proofe_r
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
prower114218123prowe_r
prowesses1437193prowesses
prowlers13328933prowlers
prowls115511083pro_wls
prows106327013pro__ws
proxies163014933proxies
prudes94215443prude_s
pruners93710723pruners
prunes83419063prune_s
pryers115012243pr_yers
ptoses83514673ptose_s
puffers15349203puffers
pureness101110183pureness
pyoses114314303pyose_s
pyrogens1437293pyrogens
pyrones123113303pyrone_s
pyropes142210193pyrope_s
recess8314263_recess
refels94618053_refels
refers93921083_refers
reprocess1345933reprocess
rifest93114583_rifest
robes75133303_robe_s
rodeos75314503_rodeos
rodes614039083_rode_s
rodless8310073_rodless
roes45954143_ro_e_s
rogers74517913_rogers
roles56747983_role_s
rolfers104011813_rolfers
romeos84013173_romeos
roofers105013903roofers
roofless11316733roofless
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
rowels94515453_rowels
rowens94515303_rowens
rowers94924573_rowers
spoofers13307323spoofers
spryness1334003spryness
tress55423163tr__ess
troffers14125433troffers
trokes104019263troke_s
trones65629283trone_s
tropes84824353trope_s
trovers103713323trovers
troves94719113trove_s
trowels10358363trowels
twofers1364053twofers
uprouses1037553uprouses
woofers133810583woofers
wryness13113983wryness

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.390458182.1
2DLD Change Limit1340273655.94022563.5
3Display Results3653650.1232967.5
 (SQL Overall)1786913656.45327691.2
 
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.