> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# freetextwords table

> This table contains the word list (automatically updated by the indexer) for the free-text search. Words are in UPPERCASE and truncated to 9 significant characters. Indexed words, dynamically updated by the freetext index

## freetextwords Table (45)

This table contains the word list (automatically updated by the indexer) for the free-text search. Words are in UPPERCASE and truncated to 9 significant characters. Indexed words, dynamically updated by the freetext index

## Fields

| Name              | Description                                                               | Type       | Nullable |
| ----------------- | ------------------------------------------------------------------------- | ---------- | :------: |
| freetextwords\_id | Primary key                                                               | PK         |    No    |
| word              | Indexed word                                                              | String(19) |    No    |
| soundEx           | Soundex form of word using Metaphone algorithm, for sounds-like searching | String(9)  |    No    |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/freetextwords.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=9935b5a65ffcab1255961df759ef8923" alt="freetextwords table relationship diagram" width="449" height="59" data-path="media/loc/en/database/tables/freetextwords.png" />

## Indexes

| Fields  | Types      | Description |
| ------- | ---------- | ----------- |
| word    | String(19) | Index       |
| soundEx | String(9)  | Index       |

## Relationships

| Table                            | Description                                                                                                                                                                                                                                                                                                                                                                                       |
| -------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [freetextindex](./freetextindex) | This is the index table for the free text search function. Each word in FreeTextWords can have multiple occurrences in this table. Each record in this table points to one occurrence of the word, and points to both the table in which the word occurs (which might be contact or text), and also a pointer to the owner table (which is one of contact, person, project, appointment or sale). |

## Replication Flags

* Copy to satellite and travel prototypes.

## Security Flags

* No access control via user's Role.


## Related topics

- [freetextindex table](/en/database/tables/freetextindex.md)
- [freetextstopwords table](/en/database/tables/freetextstopwords.md)
- [contact table](/en/database/tables/contact.md)
- [Blocked tables list](/en/online/mirroring/blocked-tables.md)
- [Database table listing](/en/database/tables/index.md)
- [extra_tables table](/en/database/tables/extra-tables.md)