History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pat"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1606 | 2024-04-23 17:12:01 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1605 | 2024-04-20 05:31:30 | pat | 1 | 5146 | 51 | 0.123 | 41837.4 |
1604 | 2024-04-19 02:31:06 | pat | 1 | 5146 | 51 | 0.090 | 57177.8 |
1603 | 2024-04-18 21:45:06 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1602 | 2024-04-15 17:29:29 | pat | 1 | 5146 | 51 | 0.343 | 15002.9 |
1601 | 2024-04-15 17:27:30 | pat | 1 | 5146 | 51 | 0.170 | 30270.6 |
1600 | 2024-04-10 22:41:08 | pat | 1 | 5146 | 51 | 0.110 | 46781.8 |
1599 | 2024-04-05 17:39:14 | pat | 2 | 14084 | 628 | 0.436 | 32302.8 |
1598 | 2024-04-05 11:51:40 | pat | 1 | 5146 | 51 | 0.220 | 23390.9 |
1597 | 2024-04-05 11:51:20 | pat | 2 | 14084 | 628 | 1.593 | 8841.2 |
1596 | 2024-04-05 11:51:13 | pat | 1 | 5146 | 51 | 0.233 | 22085.8 |
1595 | 2024-04-02 17:54:47 | pat | 1 | 5146 | 51 | 0.190 | 27084.2 |
1594 | 2024-03-30 18:10:16 | pat | 1 | 5146 | 51 | 0.110 | 46781.8 |
1593 | 2024-03-30 09:52:55 | pat | 1 | 5146 | 51 | 0.296 | 17385.1 |
1592 | 2024-03-28 10:38:31 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1591 | 2024-03-27 18:47:57 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1590 | 2024-03-26 18:42:15 | pat | 1 | 5146 | 51 | 0.173 | 29745.7 |
1589 | 2024-03-22 04:58:20 | pat | 1 | 5146 | 51 | 0.110 | 46781.8 |
1588 | 2024-03-06 08:49:28 | pat | 1 | 5146 | 51 | 0.203 | 25349.8 |
1587 | 2024-03-05 02:33:42 | pat | 1 | 5146 | 51 | 0.313 | 16440.9 |
1586 | 2024-03-02 16:28:42 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1585 | 2024-02-29 19:03:21 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1584 | 2024-02-27 06:38:04 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1583 | 2024-02-25 15:49:58 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1582 | 2024-02-25 15:45:39 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1581 | 2024-02-04 20:13:46 | pat | 1 | 5146 | 51 | 0.186 | 27666.7 |
1580 | 2024-02-04 20:11:02 | pat | 1 | 5146 | 51 | 0.096 | 53604.2 |
1579 | 2024-02-04 20:05:06 | pat | 1 | 5146 | 51 | 0.186 | 27666.7 |
1578 | 2024-02-04 20:02:01 | pat | 1 | 5146 | 51 | 0.186 | 27666.7 |
1577 | 2024-02-04 20:00:54 | pat | 1 | 5146 | 51 | 0.096 | 53604.2 |
1576 | 2024-02-04 20:00:42 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1575 | 2024-02-04 20:00:00 | pat | 1 | 5146 | 51 | 0.203 | 25349.8 |
1574 | 2024-02-04 19:27:54 | pat | 2 | 14084 | 628 | 0.406 | 34689.7 |
1573 | 2024-02-04 19:27:42 | pat | 1 | 5146 | 51 | 0.096 | 53604.2 |
1572 | 2024-01-28 12:38:51 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1571 | 2024-01-25 17:36:54 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1570 | 2024-01-20 16:07:29 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1569 | 2024-01-17 20:17:57 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1568 | 2024-01-05 17:48:48 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1567 | 2023-12-26 21:37:04 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1566 | 2023-12-18 14:38:37 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1565 | 2023-12-16 22:04:52 | pat | 2 | 14084 | 628 | 0.373 | 37758.7 |
1564 | 2023-12-16 02:15:40 | pat | 2 | 14084 | 628 | 0.420 | 33533.3 |
1563 | 2023-12-12 15:03:37 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1562 | 2023-11-29 09:18:46 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1561 | 2023-11-14 21:41:23 | pat | 2 | 14084 | 628 | 0.376 | 37457.4 |
1560 | 2023-11-11 16:41:58 | pat | 2 | 14084 | 628 | 0.343 | 41061.2 |
1559 | 2023-11-08 14:03:21 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1558 | 2023-11-08 03:09:54 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1557 | 2023-11-07 12:33:31 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1556 | 2023-11-07 08:09:32 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1555 | 2023-10-26 03:32:55 | pat | 2 | 14084 | 628 | 0.410 | 34351.2 |
1554 | 2023-10-25 23:45:36 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1553 | 2023-10-24 21:39:12 | pat | 2 | 14084 | 628 | 0.373 | 37758.7 |
1552 | 2023-10-24 13:50:41 | pat | 1 | 5146 | 51 | 0.110 | 46781.8 |
1551 | 2023-10-24 03:19:53 | pat | 1 | 5146 | 51 | 0.190 | 27084.2 |
1550 | 2023-10-19 18:43:56 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1549 | 2023-10-17 16:49:49 | pat | 1 | 5146 | 51 | 0.110 | 46781.8 |
1548 | 2023-10-16 23:19:31 | pat | 2 | 14084 | 628 | 0.373 | 37758.7 |
1547 | 2023-10-16 21:28:50 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1546 | 2023-10-16 07:51:51 | pat | 1 | 5146 | 51 | 0.096 | 53604.2 |
1545 | 2023-10-15 13:21:44 | pat | 2 | 14084 | 628 | 0.373 | 37758.7 |
1544 | 2023-10-10 22:30:48 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1543 | 2023-10-06 02:02:42 | pat | 2 | 14084 | 628 | 0.330 | 42678.8 |
1542 | 2023-10-03 10:41:51 | pat | 1 | 5146 | 51 | 0.096 | 53604.2 |
1541 | 2023-09-27 13:11:19 | pat | 2 | 14084 | 628 | 0.376 | 37457.4 |
1540 | 2023-09-25 11:03:02 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1539 | 2023-09-19 18:15:24 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1538 | 2023-09-15 19:01:18 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1537 | 2023-09-15 16:50:14 | pat | 2 | 14084 | 628 | 0.390 | 36112.8 |
1536 | 2023-09-10 15:31:28 | pat | 1 | 5146 | 51 | 0.096 | 53604.2 |
1535 | 2023-08-12 14:12:33 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1534 | 2023-07-16 19:19:07 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1533 | 2023-07-12 01:43:00 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1532 | 2023-05-14 07:22:19 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1531 | 2023-04-04 12:44:34 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1530 | 2023-03-31 18:55:09 | pat | 1 | 5146 | 51 | 0.060 | 85766.7 |
1529 | 2023-03-23 04:03:15 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1528 | 2023-03-12 12:24:40 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1527 | 2023-03-08 02:14:52 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1526 | 2023-01-17 08:30:48 | pat | 1 | 5146 | 51 | 0.096 | 53604.2 |
1525 | 2022-12-29 15:18:44 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1524 | 2022-12-26 14:45:52 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1523 | 2022-11-26 11:36:02 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1522 | 2022-09-18 14:12:33 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1521 | 2022-08-14 06:46:00 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1520 | 2022-08-05 23:13:21 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1519 | 2022-07-30 06:39:18 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1518 | 2022-07-29 10:25:59 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1517 | 2022-07-03 12:56:31 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1516 | 2022-06-16 12:56:21 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1515 | 2022-06-09 17:08:04 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1514 | 2022-06-08 18:23:12 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1513 | 2022-06-06 02:24:26 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1512 | 2022-06-01 14:35:53 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1511 | 2022-05-26 04:26:10 | pat | 1 | 5146 | 51 | 0.080 | 64325.0 |
1510 | 2022-05-25 18:18:56 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1509 | 2022-04-29 22:52:19 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |
1508 | 2022-03-21 23:45:16 | pat | 1 | 5146 | 51 | 0.076 | 67710.5 |
1507 | 2022-03-01 14:35:35 | pat | 1 | 5146 | 51 | 0.093 | 55333.3 |