Order(:id, :delivery_name, :consignment_number)

id - exact
delivery_name - partial matching (word_start, word_middle)
consignment_number - exact

id   | delivery_name  | consignment_number
==========================================
1000 | Bill Smith     | A1234
1001 | Janet Example  | B1000
1002 | Bill Examsmith | C4322

q = "1000" returns Order 1000
q = "Exam" returns Order 1000, 1001
q = "B1000" returns Order 1001
q = "smith" returns Order 1000, 1002