How to search for compound words, and get the word parts returned

by   Last Updated June 17, 2018 19:06 PM

I need to be able to search for compound words like "menneskerettighedsforkæmperens" (the human rights activist's) and find the words "menneske" (human), "rettighed" (right) and "forkæmper" (activist).

I have all the words (and hundreds of thousands of other words) listed in MySQL, all in separate rows with additional information about each word (like hyphenation, which is what I need the DB to return), but I need to search a lot of words at the same time, which can be painfully slow.

I'm currently using a MySQL database, but willing to switch it out for something better suiting my needs, maybe some kind of NoSQL or elasticsearch. But I haven't been able to find any examples of how to accomplish what I'm looking for in any other type of databases. So if anyone can help me out, I would really appreciate it.

Related Questions

Unable to make a dynamic search for my Jtable

Updated April 25, 2018 12:06 PM

Performance to find the string with like operator?

Updated November 28, 2017 09:06 AM

Database Design and structure

Updated April 09, 2017 12:06 PM

Search 200M documents of text by keyword in text

Updated February 18, 2017 13:06 PM