Spring Boot 4 · SQL Server · Word index (search_token table)

Find any asset in a second.

A study lab for 20 search & filter techniques on a fictional company's equipment register. Every page shows the SQL it runs, so you can see how each feature is built.

Try: labtop dell fuzzy thinkpad -retired full-text "docking station" prnter did you mean laptops in repair or lost scan a barcode

2,400assets in SQL Server

94,476rows in the word index

7,700distinct words (vocabulary)

471searches logged

The 20 features

How they work

#21

Search by Keyword

Type words; every word must appear in the name, code, brand, model, serial, location or description.

#22

Advanced Search

Build conditions such as Price > 30000 AND Purchase date between two dates, matched with ALL or ANY.

#23

Full-Text Search

Ranked word search with prefix*, -exclude, "exact phrase" and OR.

#24

Filter by Date Range

Pick From / To or a preset (last 7 days, this month, this year ...) on the purchase or last-update date.

#25

Filter by Status

Tick one or more statuses. Each checkbox shows how many results it would give.

#26

Filter by Category

Narrow down to laptops, monitors, vehicles ...

#27

Filter by Tag

Choose tags and whether an asset needs ANY of them or ALL of them.

#28

Filter by User

Show the assets owned by one or more people. The list can be searched.

#29

Filter by Department

Show the assets of one or more departments.

#30

Multi-filter

Combine keyword, status, category, tags, user, department, dates and conditions at once. Counts update live.

#31

Save Search Criteria

Save keyword + filters + sort under a name and run it again with one click.

#32

Search History

Every search you run is listed with its result count and time; run it again or delete it.

#33

Auto-complete Search

Matching assets and word completions appear while you type (arrow keys + Enter work).

#34

Fuzzy Search

Finds results even with typos: "labtop", "thinkpda", "microscpe", "fone".

#35

Search Suggestions

"Did you mean ...", popular searches, and one-click category / tag / department filters.

#36

Recent Search

Click the empty search box to see your latest searches.

#37

Search by Barcode

Type or scan an EAN-13 barcode, upload a photo of it, or hold it up to the webcam.

#38

Search by QR Code

Each asset has a QR code (SFL:AST-000123). Scan it from a picture or the webcam to open the asset.

#39

Filter Reset

Remove one filter with its × chip, or everything with "Clear all".

#40

Saved Filter

Store a set of filters (without keyword) as a coloured quick button above the results.