Index that mimics full-text-index
Because Compact Edition is deprecated and doesn't support full-text search (or anything like it), I think the best solution here is to stop using Compact Edition and instead use SQL Server Express with Advanced Services, which includes full-text search capabilities.

Stop moving database files around between developers. This is just dangerous, regardless of whether you are using Compact Edition or proper editions of SQL Server. You should install a single instance of SQL Server, and everybody manage a single copy of the database. Use source control so that rolling back is easier than "use the copy of the file from Jimmy's machine and then add this change and take this table away..."

In order to convert back from Compact Edition to proper SQL Server, see this question and this question.