SQLite User Forum

Fixing typos
Login

Fixing typos

(1) By Vasilii Lakhin (qobood) on 2025-02-22 08:36:40 [link] [source]

Greetings! I've made a small patch that fixes some typos.

Is there a need for this initiative? I could continue, if so. I expect around 300 words to be changed.
As I can't attach the patch, for convenience I'll copypaste it as an answer.

Here are the changes I've made:
abled -> enabled
abiguity -> ambiguity
accomadate -> accommodate
accumlate -> accumulate
accumuated -> accumulated
accumuluate -> accumulate
Actualy -> Actually
algorihm -> algorithm
allocing -> allocating
amaglamation -> amalgamation
amalamgation -> amalgamation
appliation -> application
appling -> applying
approprately -> appropriately
arbitarily -> arbitrarily
aruguments -> arguments
attemp -> attempt
availble -> available
becaure -> because
beteween -> between
betwen -> between
boostrapping -> bootstrapping
cantains -> contains
Certaint -> Certain
chanages -> changes
chracters -> characters
clearn -> clear
compenents -> components
compliing -> compiling
configution -> configuration
Conider -> Consider
conjuction -> conjunction
cononical -> canonical
consective -> consecutive
conver -> convert
Convience -> Convenience
Ctorage -> Storage
debuggingn -> debugging
descripions -> descriptions
descriptr -> descriptor
Destructgor -> Destructor
diffrently -> differently
disposible -> disposable
disttribution -> distribution
documnent -> document
downstreadm -> downstream
ealier  -> earlier
emited -> emitted
emiting -> emitting

(2) By Stephan Beal (stephan) on 2025-02-22 18:16:35 in reply to 1 [link] [source]

I've made a small patch that fixes some typos.

For legal reasons we cannot accept patches from random folks, but if you will tell us where you've found these typos i will ensure that they get fixed.

While trying to determine whether these are from sqlite3.c/h or the website i wasn't able to locate "cononical" or "Conider" (for example):

[stephan@nuc:~/f/s/doc]$ grep cononical pages/*
[stephan@nuc:~/f/s/doc]$ grep Conider pages/*

[stephan@nuc:~/f/s/lite]$ grep cononical sqlite3.[ch]
[stephan@nuc:~/f/s/lite]$ grep Conider sqlite3.[ch]

None of those find any hits.

(3.1) By Vasilii Lakhin (qobood) on 2025-02-25 14:54:28 edited from 3.0 in reply to 2 [link] [source]

Greetings!

So I've made the same thing, but using sed. Hope it'll be clearer and easier to process.

Best regards,
Vasilii

sed 's/\babled\b/enabled/' -i ./src/main.c
sed 's/\babiguity\b/ambiguity/' -i ./src/parse.y
sed 's/\baccomadate\b/accommodate/' -i ./ext/fts3/fts3_snippet.c
sed 's/\baccumlate\b/accumulate/' -i ./ext/session/sqlite3session.c
sed 's/\baccumuated\b/accumulated/' -i ./ext/rtree/rtree.c
sed 's/\baccumuluate\b/accumulate/' -i ./ext/fts5/fts5_hash.c
sed 's/\bActualy\b/Actually/' -i ./ext/fts3/fts3Int.h
sed 's/\balgorihm\b/algorithm/' -i ./ext/rtree/geopoly.c
sed 's/\ballocing\b/allocating/' -i ./ext/jni/src/c/sqlite3-jni.c
sed 's/\bamaglamation\b/amalgamation/' -i ./main.mk
sed 's/\bamalamgation\b/amalgamation/' -i ./main.mk
sed 's/\bappliation\b/application/' -i ./ext/rbu/sqlite3rbu.h
sed 's/\bappling\b/applying/' -i ./ext/misc/fuzzer.c
sed 's/\bapproprately\b/appropriately/' -i ./tool/mksqlite3internalh.tcl
sed 's/\barbitarily\b/arbitrarily/' -i ./doc/pager-invariants.txt
sed 's/\baruguments\b/arguments/' -i ./ext/wasm/api/sqlite3-vfs-opfs.c-pp.js
sed 's/\battemp\b/attempt/' -i ./ext/wasm/api/sqlite3-vfs-opfs.c-pp.js
sed 's/\bavailble\b/available/' -i ./ext/wasm/fiddle/fiddle.js
sed 's/\bbecaure\b/because/' -i ./ext/jni/src/org/sqlite/jni/capi/SQLTester.java
sed 's/\bbeteween\b/between/' -i ./autosetup/sqlite-config.tcl
sed 's/\bbetwen\b/between/' -i ./doc/lemon.html
sed 's/\bboostrapping\b/bootstrapping/' -i ./ext/wasm/GNUmakefile
sed 's/\bcantains\b/contains/' -i ./ext/fts3/fts3_hash.c
sed 's/\bCertaint\b/Certain/' -i ./main.mk
sed 's/\bchanages\b/changes/' -i ./test/json/json-speed-check.sh /tool/run-speed-test.sh /tool/speed-check.sh
sed 's/\bchracters\b/characters/' -i ./ext/misc/totype.c
sed 's/\bclearn\b/clear/' -i ./src/main.c
sed 's/\bcompenents\b/components/' -i ./ext/fts5/fts5_index.c
sed 's/\bcompliing\b/compiling/' -i ./ext/misc/vfsstat.c
sed 's/\bconfigution\b/configuration/' -i ./ext/jni/src/org/sqlite/jni/capi/CApi.java
sed 's/\bConider\b/Consider/' -i ./ext/jni/src/c/sqlite3-jni.c
sed 's/\bconjuction\b/conjunction/' -i ./src/os_unix.c
sed 's/\bcononical\b/canonical/' -i ./autoconf/README.txt
sed 's/\bconsective\b/consecutive/' -i ./autoconf/README.txt
sed 's/\bconver\b/convert/' -i ./autoconf/README.txt
sed 's/\bConvience\b/Convenience/' -i ./ext/wasm/common/whwasmutil.js
sed 's/\bCtorage\b/Storage/' -i ./ext/wasm/demo-jsstorage.js
sed 's/\bdebuggingn\b/debugging/' -i ./ext/repair/checkindex.c
sed 's/\bdescripions\b/descriptions/' -i ./ext/wasm/api/sqlite3-wasm.c
sed 's/\bdescriptr\b/descriptor/' -i ./ext/lsm1/lsm_file.c
sed 's/\bDestructgor\b/Destructor/' -i ./ext/lsm1/lsm_file.c
sed 's/\bdiffrently\b/differently/' -i ./ext/wasm/api/sqlite3-api-prologue.js
sed 's/\bdisposible\b/disposable/' -i ./ext/misc/vtshim.c
sed 's/\bdisttribution\b/distribution/' -i ./ext/jni/GNUmakefile
sed 's/\bdocumnent\b/document/' -i ./ext/fts3/fts3.c
sed 's/\bdownstreadm\b/downstream/' -i ./ext/lsm1/lsm_file.c
sed 's/\bealier\b/earlier/' -i ./ext/lsm1/lsm_log.c
sed 's/\bemited\b/emitted/' -i ./autosetup/sqlite-config.tcl /ext/wasm/GNUmakefile
sed 's/\bemiting\b/emitting/' -i ./ext/wasm/jaccwabyt/jaccwabyt.md
sed 's/\bemperically\b/empirically/' -i ./src/pragma.c

(4) By Stephan Beal (stephan) on 2025-02-25 16:32:56 in reply to 3.1 [link] [source]

Hope it'll be clearer and easier to process.

Definitely! Thank you for this - i'll commit to getting these typos fixed for the 3.50 release.

(5) By Vasilii Lakhin (qobood) on 2025-02-27 10:00:35 in reply to 4 [source]

Greetings!

Here's a finished list. My expectations have fallen short of 300 words, it's around 150 in total.
Thank you for your time!

Best regards,
Vasilii

sed 's/\bcontroled\b/controlled/' -i ext/fts3/fts3Int.h ext/wasm/api/sqlite3-wasm.c
sed 's/\bencounted\b/encountered/' -i ext/fts3/fts3_expr.c
sed 's/\bEqivalent\b/Equivalent/' -i ext/fts5/fts5_hash.c
sed 's/\bequivalant\b/equivalent/' -i ext/jni/src/org/sqlite/jni/capi/CApi.java
sed 's/\bEquivallent\b/Equivalent/' -i ext/jni/src/org/sqlite/jni/wrapper1/Sqlite.java
sed 's/\berrror\b/error/' -i ext/wasm/api/sqlite3-api-glue.c-pp.js
sed 's/\bespeically\b/especially/' -i src/json.c
sed 's/\bexistance\b/existence/' -i ext/rbu/sqlite3rbu.c test/colmeta.test test/dbfuzz.c test/fuzzcheck.c
sed 's/\bexplcitely\b/explicitly/' -i autosetup/proj.tcl
sed 's/\bexplicitely\b/explicitly/' -i ext/jni/src/org/sqlite/jni/capi/CallbackProxy.java
sed 's/\bexplict\b/explicit/' -i ext/fts3/README.syntax test/collate1.test test/fts3expr2.test
sed 's/\bexplitly\b/explicitly/' -i ext/jni/README.md
sed 's/\bExpresion\b/Expression/' -i src/expr.c
sed 's/\bfist\b/first/' -i ext/wasm/api/sqlite3-wasm.c
sed 's/\bflused\b/flushed/' -i ext/fts5/fts5_hash.c
sed 's/\bforiegn\b/foreign/' -i test/alter3.test test/alter4.test tool/genfkey.README
sed 's/\bforumlate\b/formulate/' -i ext/fts3/README.syntax
sed 's/\bfuncion\b/function/' -i ext/misc/decimal.c
sed 's/\bfuther\b/further/' -i ext/lsm1/lsmInt.h
sed 's/\bgadzillion\b/gazillion/' -i autoconf/tea/win/rules.vc
sed 's/\bhierachy\b/hierarchy/' -i ext/lsm1/lsm_sorted.c
sed 's/\bhoook\b/hook/' -i ext/jni/src/c/sqlite3-jni.c
sed 's/\bidentifer\b/identifier/' -i src/parse.y tool/lempar.c
sed 's/\bimcompatable\b/incompatable/' -i src/shell.c.in
sed 's/\bimpedence\b/impedance/' -i ext/wasm/api/sqlite3-api-prologue.js
sed 's/\bimplemenation\b/implementation/' -i ext/wasm/common/whwasmutil.js
sed 's/\bimplemention\b/implementation/' -i doc/vfs-shm.txt ext/jni/src/org/sqlite/jni/test-script-interpreter.md
sed 's/\bindentifies\b/identifies/' -i tool/sqldiff.c
sed 's/\binherient\b/inherent/' -i tool/lemon.c
sed 's/\binitalization\b/initialization/' -i ext/wasm/api/sqlite3-vfs-opfs-sahpool.c-pp.js
sed 's/\binitalized\b/initialized/' -i ext/wasm/api/sqlite3-api-prologue.js
sed 's/\binitalizes\b/initializes/' -i ext/wasm/api/sqlite3-api-prologue.js
sed 's/\binitilialized\b/initialized/' -i ext/session/sqlite3session.c
sed 's/\bintepreting\b/interpreting/' -i ext/lsm1/lsm_ckpt.c
sed 's/\binteration\b/iteration/' -i ext/fts3/fts3.c
sed 's/\binterpretated\b/interpreted/' -i ext/jni/src/org/sqlite/jni/capi/CApi.java
sed 's/\bkepts\b/kept/' -i ext/misc/fuzzer.c
sed 's/\blangauge\b/language/' -i ext/misc/amatch.c test/fts4langid.test
sed 's/\blibary\b/library/' -i autosetup/sqlite-config.tcl
sed 's/\blimitiations\b/limitations/' -i tool/genfkey.README
sed 's/\bmaching\b/matching/' -i ext/wasm/common/whwasmutil.js
sed 's/\bmaginitude\b/magnitude/' -i ext/misc/uint.c
sed 's/\bmaintenace\b/maintenance/' -i ext/wasm/jaccwabyt/jaccwabyt.md
sed 's/\bMakfile\b/Makefile/' -i autoconf/tea/README.txt
sed 's/\bmannaged\b/managed/' -i ext/fts5/fts5_expr.c
sed 's/\bmimimum\b/minimum/' -i ext/fts5/fts5_aux.c ext/misc/shathree.c tool/fuzzershell.c
sed 's/\bmininum\b/minimum/' -i ext/misc/ieee754.c
sed 's/\bmodifing\b/modifying/' -i tool/soak1.tcl
sed 's/\bnevery\b/never/' -i doc/wal-lock.md
sed 's/\bnornal\b/normal/' -i ext/misc/ieee754.c
sed 's/\bnuisence\b/nuisance/' -i ext/misc/normalize.c
sed 's/\bobjec\b/object/' -i doc/vfs-shm.txt
sed 's/\boccassionally\b/occasionally/' -i ext/wasm/api/sqlite3-opfs-async-proxy.js
sed 's/\boccurance\b/occurrence/' -i ext/wasm/mkwasmbuilds.c
sed 's/\boccurrance\b/occurrence/' -i ext/misc/percentile.c
sed 's/\boccuring\b/occurring/' -i ext/fts5/test/fts5simple3.test ext/misc/btreeinfo.c test/analyze3.test test/collateB.test test/fts3cov.test
sed 's/\bopeation\b/operation/' -i contrib/sqlitecon.tcl
sed 's/\bOtherwse\b/Otherwise/' -i contrib/sqlitecon.tcl
sed 's/\boutlier\b/outliner/' -i ext/wasm/api/README.md
sed 's/\boverlow\b/overflow/' -i ext/misc/series.c
sed 's/\bperperty\b/property/' -i src/parse.y
sed 's/\bpimary\b/primary/' -i ext/rtree/README
sed 's/\bpoitner\b/pointer/' -i ext/wasm/api/sqlite3-wasm.c
sed 's/\bpreceeded\b/preceded/' -i tool/stripccomments.c
sed 's/\bpreceeds\b/preceds/' -i ext/fts3/fts3_porter.c test/in4.test
sed 's/\bprefered\b/preferred/' -i ext/wasm/jaccwabyt/jaccwabyt.js
sed 's/\bprimatives\b/primitives/' -i ext/misc/vfstrace.c
sed 's/\bprimite\b/primitive/' -i doc/jsonb.md
sed 's/\bProces\b/Process/' -i ext/fts3/unicode/mkunicode.tcl
sed 's/\bquire\b/require/' -i ext/wasm/GNUmakefile
sed 's/\brefered\b/referred/' -i ext/rbu/sqlite3rbu.h ext/rtree/rtreedoc2.test test/fuzz.test test/indexedby.test
sed 's/\brefering\b/referring/' -i main.mk
sed 's/\bremaininder\b/remainder/' -i ext/wasm/c-pp.c
sed 's/\brequiremenst\b/requirements/' -i README.md
sed 's/\brequirments\b/requirements/' -i ext/wasm/api/sqlite3-api-prologue.js
sed 's/\brequries\b/requires/' -i ext/fts5/fts5_index.c
sed 's/\brequrired\b/required/' -i ext/fts3/fts3_write.c
sed 's/\bretreive\b/retrieve/' -i ext/fts3/fts3_snippet.c ext/lsm1/lsm_sorted.c test/enc2.test
sed 's/\breutrn\b/return/' -i ext/expert/sqlite3expert.c
sed 's/\brever\b/revert/' -i ext/rbu/sqlite3rbu.h
sed 's/\bsearchs\b/search/' -i ext/misc/csv.c
sed 's/\bsegement\b/segment/' -i ext/rtree/geopoly.c
sed 's/\bsentinals\b/sentinels/' -i ext/fts3/fts3.c
sed 's/\bsigificantly\b/significantly/' -i ext/jni/src/c/sqlite3-jni.c
sed 's/\bstatae\b/state/' -i ext/jni/GNUmakefile
sed 's/\bsubsiduary\b/subsidiary/' -i ext/fts3/fts3_write.c
sed 's/\bsubsitute\b/substitute/' -i ext/fts5/fts5_buffer.c
sed 's/\bsucces\b/success/' -i ext/wasm/api/sqlite3-vfs-opfs-sahpool.c-pp.js
sed 's/\bsymetric\b/symmetric/' -i ext/fts3/fts3.c
sed 's/\bsyncronous\b/synchronous/' -i ext/wasm/api/sqlite3-opfs-async-proxy.js
sed 's/\bterminlogy\b/terminology/' -i ext/wasm/mkwasmbuilds.c
sed 's/\bthie\b/this/' -i ext/lsm1/lsm_sorted.c
sed 's/\btogglable\b/toggleable/' -i ext/wasm/fiddle/index.html
sed 's/\bTranform\b/Transform/' -i ext/misc/amatch.c
sed 's/\btransfering\b/transferring/' -i ext/jni/src/org/sqlite/jni/capi/PrepareMultiCallback.java
sed 's/\bTues\b/Tuesday/' -i src/date.c
sed 's/\bTyipcally\b/Typically/' -i tool/build-all-msvc.bat
sed 's/\bundersirable\b/undesirable/' -i autoconf/tea/configure.ac.in
sed 's/\bunderyling\b/underlying/' -i autoconf/tea/configure.ac.in
sed 's/\bUnpexected\b/Unexpected/' -i ext/wasm/c-pp.c
sed 's/\bvocubulary\b/vocabulary/' -i ext/misc/fuzzer.c
sed 's/\bvolumn\b/volume/' -i ext/rtree/rtree.c
sed 's/\bwha\b/what/' -i autosetup/proj.tcl
sed 's/\bwhants\b/wants/' -i src/json.c

(6) By Stephan Beal (stephan) on 2025-02-27 21:18:17 in reply to 5 [link] [source]

Here's a finished list.

Thank you! These have been applied except for the following:

#sed 's/\bgadzillion\b/gazillion/' -i autoconf/tea/win/rules.vc

That file is from an upstream source which we cannot modify, so any changes we make there would eventually be overwritten. Also, "gadzillion" might really be the intended (exaggerated) spelling.

#sed 's/\boutlier\b/outliner/' -i ext/wasm/api/README.md

"outlier" is actually correct there.

#sed 's/bpreceedsb/preceds/' -i ext/fts3/fts3_porter.c test/in4.test

Replaced with "precedes" instead.

#sed 's/\brever\b/revert/' -i ext/rbu/sqlite3rbu.h

Replaced with "refer" instead.

sed 's/\bwha\b/what/' -i autosetup/proj.tcl

"wha?" is actually intended there. That spelling is often used to indicate something like "that's impossible."

(8.1) By Vasilii Lakhin (qobood) on 2025-03-01 06:17:18 edited from 8.0 in reply to 6 [link] [source]

Greetings!

Thank you for your time and attention, Stephan! I'll take your notes into account.

Best regards!

(7) By brickviking on 2025-03-01 03:05:00 in reply to 1 [link] [source]

Darn. He's beaten me to it!

Ah well, I get to hunt a bit harder then.

RTDoc brickviking
(Post 30)