Systems and methods for analyzing failed and successful search queries

A computer system for identifying failed and successful search queries, comprising:

• a memory device that stores a set of instructions;
• and
• at least one processor that executes the set of instructions and is configured to:
• retrieve a first record including a first character string;
• retrieve a second record including a second character string;
• determine that the second character string is a refinement attempted by a user of the first character string;
• identify at least a first sequence of characters of the first character string that differs from at least a second sequence of characters of the second character string;
• and
• store the first sequence of characters and the second sequence of characters as a pair in a database of stored pairs.

A non-transitory computer-readable medium that stores a set of instructions that, when executed by at least one processor, configures the at least one processor to carry out a method, the method comprising:

• retrieving a first record including a first character string;
• retrieving a second record including a second character string;
• determining that the second character string is a refinement attempted by a user of the first character string;
• identifying at least a first sequence of characters of the first character string that differs from at least a second sequence of characters of the second character string;
• and
• storing the first sequence of characters and the second sequence of characters as a pair in a database of stored pairs.