MariaDB [babynames]> select count(*) from pop1980 where firstname='Jennifer';
+----------+
| count(*) |
+----------+
|    58617 |
+----------+

MariaDB [babynames]> select count(*) from pop1980 where firstname='Jennice';
+----------+
| count(*) |
+----------+
|        7 |
+----------+
1 row in set (1.17 sec)

MariaDB [babynames]> analyze select count(*) from pop1980 where firstname='Jennifer';
+------+-------------+---------+------+---------------+------+---------+------+---------+------------+----------+------------+-------------+
| id   | select_type | table   | type | possible_keys | key  | key_len | ref  | rows    | r_rows     | filtered | r_filtered | Extra       |
+------+-------------+---------+------+---------------+------+---------+------+---------+------------+----------+------------+-------------+
|    1 | SIMPLE      | pop1980 | ALL  | NULL          | NULL | NULL    | NULL | 3444156 | 3444156.00 |     4.69 |       1.70 | Using where |
+------+-------------+---------+------+---------------+------+---------+------+---------+------------+----------+------------+-------------+
1 row in set (1.21 sec)

MariaDB [babynames]> analyze select count(*) from pop1980 where firstname='Jennice';
+------+-------------+---------+------+---------------+------+---------+------+---------+------------+----------+------------+-------------+
| id   | select_type | table   | type | possible_keys | key  | key_len | ref  | rows    | r_rows     | filtered | r_filtered | Extra       |
+------+-------------+---------+------+---------------+------+---------+------+---------+------------+----------+------------+-------------+
|    1 | SIMPLE      | pop1980 | ALL  | NULL          | NULL | NULL    | NULL | 3444156 | 3444156.00 |     4.69 |       0.00 | Using where |
+------+-------------+---------+------+---------------+------+---------+------+---------+------------+----------+------------+-------------+
1 row in set (1.21 sec)