Dictionary Search

For an autocomplete feature in an app, English words are stored in a table with the following data definition:

TABLE dictionary
  id INTEGER NOT NULL PRIMARY KEY
  word VARCHAR(100) NOT NULL

To evaluate the user-friendliness of the feature, you need to measure how many word suggestions are returned based on the user’s input.

For letters 'b', 'i' and 'd' typed in succession, write a query that returns the count of the suggestions as shown in the video below: All words in the table will be in lowercase.

See the example case for more details.

SQL
Loading...
Database Engine
Loading...

Tags

  • AI-resistant
  • SQL
  • Conditions
  • Select
  • Video

Information

Difficulty:
Easy
Duration:
7 min
Type:
code
Set:
Public

Score Distribution

% of candidates
0-33%
34-67%
68-100%
Score

Would you like to see our other questions?

We have 1000+ premium hand-crafted questions for 160+ job skills and 20+ coding languages. We prefer questions with small samples of actual work over academic problems or brain teasers.

Would you like to see our tests?

The following tests contain SQL related questions:

On the blog

Since we're all biased and we use incorrect proxies, why not just outsource hiring to experts or recruitment agencies? After all, they've been screening people for many years, so they must know how to do it right?

Not really. I was surprised to discover that many experts...