We need target column on index to be text_pattern_ops, as we are going to start looking for partials.