View Issue Details

IDProjectCategoryView StatusLast Update
0003848Composrsearchpublic2019-07-31 19:25
ReporterAdamAssigned To 
Severityfeature 
Status non-assignedResolutionopen 
Product Version 
Fixed in Version 
Summary0003848: Metaphonic search indexing
DescriptionBy making use of the PHP 'metaphone' function we could allow the search engine to be more tolerant of spelling mistakes.

The metaphone function reduces spelling to a simplified phonetic spelling that captures the broad sound but in a much denser way (i.e. less room for subtle alternatives).

For example, the metaphone() of the word "javascript" returns the string: JFSKRPT.
For example. Composr would return KMPSR and Conposr would return KNPSR. Even if you typed Composer and Conposer the phonetic results are the same as without the 'e' (KMPSR, KNPSR) - a good example of the aforementioned tolerance for mistakes.

To implement this, we'd need to introduce metaphonic indexing, similar to full-search indexing. Search terms would be converted to their metaphone-equivalent, then compared to entries in the index.
Additional InformationThe YouTube video where I discovered this little known/used function @ https://www.youtube.com/watch?v=Yuj1wDMlZc0
A tutorial which uses the equally obscure levenshtein function to return the minimum number of modified characters to further enhance results @ https://www.codepunker.com/blog/implement-a-sounds-like-search-in-php
TagsNo tags attached.
Attach Tags
Time estimation (hours)16
Sponsorship open

Relationships

related to 0003288 non-assigned Major overhaul of fulltext search support 
related to 0001573 non-assigned Database natural sorting 

Activities

Adam

2019-07-15 01:25

administrator  

example.png (105,509 bytes)
example.png (105,509 bytes)

Issue History

Date Modified Username Field Change
2019-07-15 01:25 Adam New Issue
2019-07-15 01:25 Adam File Added: example.png
2019-07-15 01:31 Adam Description Updated View Revisions
2019-07-15 01:32 Adam Issue Revision Dropped: Description: 0002632
2019-07-19 01:45 Chris Graham Relationship added related to 0003288
2019-07-19 01:50 Chris Graham Summary Metaphone function => Metaphonic search indexing
2019-07-19 01:50 Chris Graham Description Updated View Revisions
2019-07-19 01:50 Chris Graham Time estimation (hours) => 16
2019-07-31 19:25 Chris Graham Relationship added related to 0001573