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 “proses” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

242 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
proses8473347(None) 
broses86524401broses
eroses65327061eroses
poses74642761p_oses
prases84429021prases
prises84133171prises
probes104119451probes
proles84627201proles
prose75835121prose_
prosed94921101prosed
proser84223461proser
prosers94219641prosers
prosos85718551prosos
pross76529401pros_s
prosses94019511prosses
proves114322251proves
ptoses83514671ptoses
pyoses114314301pyoses
roses56445771_roses
apposes11511472apposes
arises65233802arises
arkoses113910832arkoses
arose55832082arose_
arouses74921292arouses
arses55733872ar_ses
brises84927612brises
bromes104719762bromes
brose75227032brose_
browses124712692browses
choses115825132choses
closes85425592closes
corses84433462corses
coses76949492_coses
crases85532312crases
crises84529432crises
crones84729242crones
crores86121162crores
cross75124502cros_s
crosse85216312crosse
crosses94220802crosses
crozes174417662crozes
cruses88127712cruses
doses65938502_doses
drones75023432drones
dross65418092dros_s
drosses84513822drosses
droves105116672droves
drowses114610232drowses
druses75517252druses
eposes84418782eposes
erases64425402erases
erodes74819882erodes
erose55727282erose_
erses55826802er_ses
frises94124272frises
froes86126692fro_es
frosts94214622frosts
gnoses76515162gnoses
gooses75723062gooses
gorses74723292gorses
gropes95220402gropes
gross65421692gros_s
grosses84517682grosses
grouses84616542grouses
groves104318102groves
horses94729352horses
hoses85443182_hoses
irises64221172irises
irones64724012irones
krises105016082krises
looses67328252looses
loses56742012_loses
mioses84318852mioses
myoses114013842myoses
nooses65623652nooses
noses55435642_noses
opposes1149242opposes
oses46641512__oses
pareses94718882pareses
parises94827192parises
paroles95025892paroles
parses85534702parses
pases75346502p_ases
passes86030472passes
pauses84621472pauses
peases85229472peases
peises84125042peises
peones83821042peones
perses85428062perses
peruses94018162peruses
pharoses13310322pharoses
phases114618402phases
phones114121212phones
phrases12711462phrases
physes14399782physes
pisses84525082pisses
pluses83618072pluses
poises84226542poises
pokes116133012p_okes
poles75351002p_oles
pomes94833932p_omes
pones74547042p_ones
pooves113914712pooves
popes95933812p_opes
pores75849032p_ores
porose84818742porose_
pose66441732p_ose_
posed85828412p_osed
poser75128772p_oser
posers84223972p_osers
posies84431432p_osies
posse74722272p_osse
posses85128802posses
posts75228782p_osts
poxes145325722p_oxes
praises94121112praises
prase76128752prase_
prates84633162prates
praxes156215182praxes
prees75937172pr_ees
prese75228382prese_
preset84430982preset
presets94216422presets
press75425952pres_s
presses93523152presses
prests84021262prests
prexes154915952prexes
prezes173614692prezes
prices104524542prices
prides94324182prides
pries74339532pr_ies
primes104225262primes
prise74632612prise_
prised94322202prised
prisms104915502prisms
priss74623892pris_s
prisses94816712prisses
prizes173819812prizes
proas75028802pro_as
probe94320812probe_
probed114114822probed
prober104516072prober
probers113514582probers
process11310402process
prods85523552pro_ds
proem94818272pro_em
proems104711162proems
profess1237712profess
profs105120892pro_fs
progs86624152pro_gs
projet15315182projet
projets1639162projets
prole74527792prole_
proleg94612112proleg
prolegs10379992prolegs
promises122916762promises
promos105116422promos
proms95426412pro_ms
prone75332622prone_
prongs94314482prongs
proofs114511682proofs
propel103714062propel
propels113412842propels
proper104319952proper
propers113619032propers
proposes122515972proposes
props95726882pro_ps
pros65742782pro__s
prosect11313392prosect
prosects1239472prosects
prosier93817492prosier
prosiest10416522prosiest
prosit85124592prosit
proso77222412pros_o
prosper114012192prosper
prospers123012262prospers
prossies101515232prossies
prost75434102pros_t
prosties101421192prosties
prosy106319252pros_y
protases102115032protases
protea82214762protea
proteas92015122proteas
protei82615312protei
protest9317532protest
proteus92511592proteus
prove104823192prove_
proved125016032proved
proven114314772proven
prover113819722prover
provers123817792provers
prower114218122prower
prowess1237902prowess
prowest12311532prowest
prowls115511082prowls
prows106327012pro_ws
proxies163014932proxies
prudes94215442prudes
prunes83419062prunes
ptosis83611822ptosis
pulses83818662pulses
purposes1237822purposes
purses84826372purses
puses75532202p_uses
pusses84322842pusses
pyosis114012122pyosis
pyrones123113302pyrones
pyropes142210192pyropes
pyrosis12411652pyrosis
rases55447212_rases
rises55244042_rises
robes75133302_robes
rodes614039082_rodes
roes45954142_ro_es
roles56747982_roles
rooses65526242rooses
ropes75940062_ropes
rose46148902_rose_
rosed65930352_rosed
roset55945242_roset
rosets65819952_rosets
rotes56143902_rotes
roues56039352_roues
rouses65436282_rouses
roves84834482_roves
ruses56136582_ruses
saroses73619332saroses
soroses73117492soroses
torses64727952torses
trioses75015652trioses
trokes104019262trokes
trones65629282trones
tropes84824352tropes
troves94719112troves
uprises92012732uprises
uprose82311482uprose_
uprouses1037552uprouses
urases63723562urases
uruses63616502uruses
viroses10310532viroses
worses95522952worses
xeroses143612832xeroses

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825512423.06326951.0
3Display Results2422420.0763184.2
 (SQL Overall)1786912423.48251318.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.