It's scarce because searchable encryption is rarely practical.
Generally, it means you are either using a very weak cypher or you are decrypting everything as you go. The first case is bad because you can use the patterns in the encryption to break it with large enough of a sample. The second, more advisable method, is painfully slow because you have to decrypt your whole data set to run a single query. Either way, Searchable Encryption is only really practical with very small data-sets.
One example of where you would use it would be if you want to be able to search a single employee record for keywords. The Employee's ID would be unencrypted; so, you could use that to only query that person's records, then you could pass his whole record set to your application to decrypt. Then search the decrypted data and only output the fields you need from that.
That said, there is a lot of promise with sortable encryption as long as you are doing exact searches. Sortable encryption sets the scope of each new encrypted string between the ones it should sort between; so, lets say the following is true:
7iFA384S4BPmuXokR9rcMI37SKnClqnE = ant
E10ZJbnmvJHs3MOKkzDXw7sd037kLCUJ = cat
miHBVXxATe1Jg6G97ug86zv31BxrpRAa = dog
z0L9f8Py12euq9Nhy9Zk0e9L83F8MiBi = man
If I wanted to add "fox" to the list, then my encryption algorithm would return between "miHBVXxATe1Jg6G97ug86zv31BxrpRAa" and "z0L9f8Py12euq9Nhy9Zk0e9L83F8MiBi" resulting in something like:
7iFA384S4BPmuXokR9rcMI37SKnClqnE = ant
E10ZJbnmvJHs3MOKkzDXw7sd037kLCUJ = cat
miHBVXxATe1Jg6G97ug86zv31BxrpRAa = dog
Pe2624gcRjP6YGWOnhiW2xnRomAjDYQK = fox // sorts alphabetically between dog and man
z0L9f8Py12euq9Nhy9Zk0e9L83F8MiBi = man
This works because the first part of the encrypted string is just sorting information, and the second part is the actual encrypted data
SortingId(Pe2624gcRjP6YG), EncyptedData(WOnhiW2xnRomAjDYQK)
Once you have sorted encryption this means two things, one that you can sort encrypted data just as easily as unencrypted data which is pretty amazing unto itself, but secondly, it means that you can selectively decrypt. I don't personally know what databases actually do/don't support this yet, but in the above list, if I search for "man", and decrypt "dog", then I know the top 2 items are not man so I don't have to decrypt them to search them. This means that the larger your data set, the smaller % of your dataset you need to decrypt to find things.