History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oil"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1557 | 2024-04-27 18:10:55 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1556 | 2024-04-27 17:57:10 | oil | 1 | 5146 | 18 | 0.186 | 27666.7 |
1555 | 2024-04-27 17:52:15 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1554 | 2024-04-27 02:53:23 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1553 | 2024-04-26 17:27:13 | oil | 2 | 14084 | 438 | 0.486 | 28979.4 |
1552 | 2024-04-26 16:08:24 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1551 | 2024-04-25 12:29:03 | oil | 2 | 14084 | 438 | 1.046 | 13464.6 |
1550 | 2024-04-25 02:31:25 | oil | 2 | 14084 | 438 | 1.076 | 13089.2 |
1549 | 2024-04-24 15:44:51 | oil | 2 | 14084 | 438 | 1.486 | 9477.8 |
1548 | 2024-04-24 15:38:41 | oil | 1 | 5146 | 18 | 0.216 | 23824.1 |
1547 | 2024-04-24 15:34:29 | oil | 2 | 14084 | 438 | 1.373 | 10257.8 |
1546 | 2024-04-24 15:24:29 | oil | 1 | 5146 | 18 | 0.453 | 11359.8 |
1545 | 2024-04-09 21:24:17 | oil | 1 | 5146 | 18 | 0.110 | 46781.8 |
1544 | 2024-04-02 17:26:26 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1543 | 2024-03-30 18:39:05 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1542 | 2024-03-26 17:30:59 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1541 | 2024-03-02 16:24:27 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1540 | 2024-02-29 18:15:26 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1539 | 2024-02-25 15:48:07 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1538 | 2024-02-02 19:38:40 | oil | 2 | 14084 | 438 | 0.766 | 18386.4 |
1537 | 2024-02-02 16:33:54 | oil | 2 | 14084 | 438 | 0.390 | 36112.8 |
1536 | 2024-02-01 11:17:55 | oil | 1 | 5146 | 18 | 0.186 | 27666.7 |
1535 | 2024-01-28 12:03:15 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1534 | 2024-01-25 17:00:37 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1533 | 2024-01-14 23:52:32 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1532 | 2024-01-07 20:51:28 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1531 | 2024-01-06 10:50:07 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1530 | 2023-12-25 17:49:34 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1529 | 2023-12-25 09:44:32 | oil | 2 | 14084 | 438 | 0.343 | 41061.2 |
1528 | 2023-12-16 03:39:04 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1527 | 2023-12-15 10:06:45 | oil | 1 | 5146 | 18 | 0.143 | 35986.0 |
1526 | 2023-12-14 13:25:12 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1525 | 2023-11-27 13:41:58 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1524 | 2023-11-25 03:09:05 | oil | 1 | 5146 | 18 | 0.173 | 29745.7 |
1523 | 2023-11-17 17:10:24 | oil | 2 | 14084 | 438 | 0.343 | 41061.2 |
1522 | 2023-11-10 01:38:42 | oil | 2 | 14084 | 438 | 0.376 | 37457.4 |
1521 | 2023-11-08 11:01:14 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1520 | 2023-11-08 00:15:10 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1519 | 2023-11-04 20:34:22 | oil | 2 | 14084 | 438 | 0.376 | 37457.4 |
1518 | 2023-10-31 12:52:03 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1517 | 2023-10-30 17:20:45 | oil | 2 | 14084 | 438 | 0.360 | 39122.2 |
1516 | 2023-10-26 08:20:55 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1515 | 2023-10-20 07:57:07 | oil | 2 | 14084 | 438 | 0.406 | 34689.7 |
1514 | 2023-10-19 14:38:25 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1513 | 2023-10-17 06:36:04 | oil | 1 | 5146 | 18 | 0.110 | 46781.8 |
1512 | 2023-10-12 22:37:41 | oil | 1 | 5146 | 18 | 0.096 | 53604.2 |
1511 | 2023-10-03 18:18:29 | oil | 2 | 14084 | 438 | 0.876 | 16077.6 |
1510 | 2023-10-03 09:12:20 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1509 | 2023-10-01 21:18:13 | oil | 2 | 14084 | 438 | 0.390 | 36112.8 |
1508 | 2023-09-28 04:10:39 | oil | 2 | 14084 | 438 | 0.690 | 20411.6 |
1507 | 2023-09-26 07:17:38 | oil | 1 | 5146 | 18 | 0.170 | 30270.6 |
1506 | 2023-09-26 05:12:10 | oil | 2 | 14084 | 438 | 0.326 | 43202.5 |
1505 | 2023-09-23 20:06:22 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1504 | 2023-09-12 01:08:36 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1503 | 2023-08-23 21:08:18 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1502 | 2023-08-13 04:11:28 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1501 | 2023-08-10 02:20:58 | oil | 2 | 14084 | 438 | 0.390 | 36112.8 |
1500 | 2023-07-12 01:50:25 | oil | 2 | 14084 | 438 | 0.423 | 33295.5 |
1499 | 2023-07-05 19:24:21 | oil | 2 | 14084 | 438 | 0.390 | 36112.8 |
1498 | 2023-07-02 16:30:55 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1497 | 2023-06-26 04:24:01 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1496 | 2023-06-17 21:14:23 | oil | 2 | 14084 | 438 | 0.796 | 17693.5 |
1495 | 2023-05-27 14:26:18 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1494 | 2023-05-22 17:27:51 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1493 | 2023-03-31 14:53:18 | oil | 2 | 14084 | 438 | 0.376 | 37457.4 |
1492 | 2023-03-27 15:19:56 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1491 | 2023-03-26 20:13:44 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1490 | 2023-03-26 07:25:35 | oil | 2 | 14084 | 438 | 0.390 | 36112.8 |
1489 | 2023-03-03 00:40:01 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1488 | 2023-02-06 00:48:32 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1487 | 2023-01-10 10:04:31 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1486 | 2022-12-24 06:54:03 | oil | 2 | 14084 | 438 | 0.346 | 40705.2 |
1485 | 2022-10-23 05:28:56 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1484 | 2022-10-16 08:09:47 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1483 | 2022-10-15 17:37:18 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1482 | 2022-09-19 22:19:28 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1481 | 2022-09-18 16:28:18 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1480 | 2022-08-30 14:32:12 | oil | 2 | 14084 | 438 | 0.420 | 33533.3 |
1479 | 2022-08-26 02:54:54 | oil | 1 | 5146 | 18 | 0.096 | 53604.2 |
1478 | 2022-08-22 16:02:00 | oil | 2 | 14084 | 438 | 0.393 | 35837.2 |
1477 | 2022-08-14 11:51:59 | oil | 1 | 5146 | 18 | 0.096 | 53604.2 |
1476 | 2022-08-07 00:36:05 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1475 | 2022-07-30 01:58:53 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1474 | 2022-07-03 09:59:39 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1473 | 2022-06-29 12:30:24 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1472 | 2022-06-25 21:46:37 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1471 | 2022-06-16 09:57:58 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1470 | 2022-06-09 11:43:10 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1469 | 2022-06-08 22:38:55 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1468 | 2022-06-08 19:34:39 | oil | 1 | 5146 | 18 | 0.110 | 46781.8 |
1467 | 2022-06-06 06:00:34 | oil | 1 | 5146 | 18 | 0.076 | 67710.5 |
1466 | 2022-06-01 21:27:52 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1465 | 2022-03-22 09:39:01 | oil | 2 | 14084 | 438 | 0.560 | 25150.0 |
1464 | 2022-03-20 06:46:01 | oil | 2 | 14084 | 438 | 0.360 | 39122.2 |
1463 | 2022-03-09 10:30:01 | oil | 1 | 5146 | 18 | 0.110 | 46781.8 |
1462 | 2022-02-18 05:05:57 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1461 | 2022-01-05 19:01:00 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1460 | 2021-12-23 20:07:16 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |
1459 | 2021-12-23 12:10:57 | oil | 1 | 5146 | 18 | 0.080 | 64325.0 |
1458 | 2021-12-23 00:57:49 | oil | 1 | 5146 | 18 | 0.093 | 55333.3 |