History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"logon"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 7668 | 2024-05-06 16:27:48 | logon | 2 | 53800 | 83 | 2.216 | 24278.0 |
| 7667 | 2024-05-06 16:27:44 | logon | 3 | 83667 | 998 | 4.436 | 18860.9 |
| 7666 | 2024-05-06 16:27:23 | logon | 3 | 83667 | 998 | 8.860 | 9443.2 |
| 7665 | 2024-05-06 16:27:28 | logon | 1 | 28756 | 10 | 0.576 | 49923.6 |
| 7664 | 2024-05-06 16:27:19 | logon | 2 | 53800 | 83 | 2.830 | 19010.6 |
| 7663 | 2024-05-06 13:05:51 | logon | 1 | 28756 | 10 | 0.560 | 51350.0 |
| 7662 | 2024-05-05 12:02:11 | logon | 1 | 28756 | 10 | 0.703 | 40904.7 |
| 7661 | 2024-05-05 09:33:27 | logon | 1 | 28756 | 10 | 1.140 | 25224.6 |
| 7660 | 2024-05-04 06:32:01 | logon | 1 | 28756 | 10 | 0.593 | 48492.4 |
| 7659 | 2024-05-03 17:30:25 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
| 7658 | 2024-05-03 15:35:11 | logon | 1 | 28756 | 10 | 0.936 | 30722.2 |
| 7657 | 2024-05-02 03:26:45 | logon | 1 | 28756 | 10 | 0.563 | 51076.4 |
| 7656 | 2024-05-01 22:10:03 | logon | 1 | 28756 | 10 | 1.750 | 16432.0 |
| 7655 | 2024-04-29 04:30:51 | logon | 1 | 28756 | 10 | 0.580 | 49579.3 |
| 7654 | 2024-04-27 04:08:13 | logon | 1 | 28756 | 10 | 0.580 | 49579.3 |
| 7653 | 2024-04-26 16:25:14 | logon | 3 | 83667 | 998 | 3.970 | 21074.8 |
| 7652 | 2024-04-26 09:16:12 | logon | 1 | 28756 | 10 | 1.796 | 16011.1 |
| 7651 | 2024-04-26 05:01:07 | logon | 3 | 83667 | 998 | 4.200 | 19920.7 |
| 7650 | 2024-04-26 03:38:45 | logon | 2 | 53800 | 83 | 1.563 | 34421.0 |
| 7649 | 2024-04-24 20:14:20 | logon | 3 | 83667 | 998 | 17.080 | 4898.5 |
| 7648 | 2024-04-24 20:13:43 | logon | 2 | 53800 | 83 | 5.563 | 9671.0 |
| 7647 | 2024-04-24 16:10:26 | logon | 2 | 53800 | 83 | 5.953 | 9037.5 |
| 7646 | 2024-04-24 16:09:27 | logon | 3 | 83667 | 998 | 14.033 | 5962.2 |
| 7645 | 2024-04-24 15:17:08 | logon | 1 | 28756 | 10 | 0.563 | 51076.4 |
| 7644 | 2024-04-24 14:29:11 | logon | 1 | 28756 | 10 | 1.670 | 17219.2 |
| 7643 | 2024-04-24 11:19:26 | logon | 1 | 28756 | 10 | 1.140 | 25224.6 |
| 7642 | 2024-04-23 08:06:27 | logon | 1 | 28756 | 10 | 1.140 | 25224.6 |
| 7641 | 2024-04-23 04:02:49 | logon | 1 | 28756 | 10 | 1.110 | 25906.3 |
| 7640 | 2024-04-22 23:09:53 | logon | 1 | 28756 | 10 | 0.533 | 53951.2 |
| 7639 | 2024-04-22 06:21:25 | logon | 1 | 28756 | 10 | 1.626 | 17685.1 |
| 7638 | 2024-04-21 07:21:15 | logon | 3 | 83667 | 998 | 3.953 | 21165.4 |
| 7637 | 2024-04-21 07:21:13 | logon | 2 | 53800 | 83 | 1.576 | 34137.1 |
| 7636 | 2024-04-21 06:35:35 | logon | 1 | 28756 | 10 | 0.530 | 54256.6 |
| 7635 | 2024-04-21 01:45:11 | logon | 2 | 53800 | 83 | 3.813 | 14109.6 |
| 7634 | 2024-04-21 01:45:08 | logon | 1 | 28756 | 10 | 0.563 | 51076.4 |
| 7633 | 2024-04-19 22:43:02 | logon | 1 | 28756 | 10 | 2.110 | 13628.4 |
| 7632 | 2024-04-17 09:03:17 | logon | 3 | 83667 | 998 | 3.376 | 24782.9 |
| 7631 | 2024-04-17 09:03:15 | logon | 2 | 53800 | 83 | 1.466 | 36698.5 |
| 7630 | 2024-04-17 08:35:44 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
| 7629 | 2024-04-17 07:03:18 | logon | 1 | 28756 | 10 | 0.763 | 37688.1 |
| 7628 | 2024-04-15 21:08:07 | logon | 1 | 28756 | 10 | 1.486 | 19351.3 |
| 7627 | 2024-04-15 13:29:54 | logon | 1 | 28756 | 10 | 1.343 | 21411.8 |
| 7626 | 2024-04-14 18:21:46 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
| 7625 | 2024-04-13 14:27:17 | logon | 3 | 83667 | 998 | 4.186 | 19987.3 |
| 7624 | 2024-04-13 14:27:15 | logon | 2 | 53800 | 83 | 1.656 | 32487.9 |
| 7623 | 2024-04-13 14:04:58 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
| 7622 | 2024-04-12 11:53:13 | logon | 1 | 28756 | 10 | 1.156 | 24875.4 |
| 7621 | 2024-04-12 11:39:28 | logon | 1 | 28756 | 10 | 0.856 | 33593.5 |
| 7620 | 2024-04-11 14:35:11 | logon | 1 | 28756 | 10 | 0.530 | 54256.6 |
| 7619 | 2024-04-11 14:04:46 | logon | 1 | 28756 | 10 | 0.530 | 54256.6 |
| 7618 | 2024-04-11 06:12:18 | logon | 3 | 83667 | 998 | 6.610 | 12657.6 |
| 7617 | 2024-04-11 06:12:15 | logon | 2 | 53800 | 83 | 1.653 | 32546.9 |
| 7616 | 2024-04-11 05:39:16 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
| 7615 | 2024-04-11 02:22:48 | logon | 3 | 83667 | 998 | 3.813 | 21942.6 |
| 7614 | 2024-04-09 19:04:38 | logon | 1 | 28756 | 10 | 0.986 | 29164.3 |
| 7613 | 2024-04-09 17:26:35 | logon | 1 | 28756 | 10 | 0.813 | 35370.2 |
| 7612 | 2024-04-09 16:08:21 | logon | 1 | 28756 | 10 | 1.423 | 20208.0 |
| 7611 | 2024-04-09 15:58:17 | logon | 1 | 28756 | 10 | 0.563 | 51076.4 |
| 7610 | 2024-04-06 12:14:19 | logon | 3 | 83667 | 998 | 13.030 | 6421.1 |
| 7609 | 2024-04-06 12:14:18 | logon | 2 | 53800 | 83 | 4.703 | 11439.5 |
| 7608 | 2024-04-02 17:13:30 | logon | 1 | 28756 | 10 | 0.530 | 54256.6 |
| 7607 | 2024-04-01 09:25:45 | logon | 3 | 83667 | 998 | 11.190 | 7476.9 |
| 7606 | 2024-04-01 09:25:42 | logon | 2 | 53800 | 83 | 5.580 | 9641.6 |
| 7605 | 2024-03-31 10:04:19 | logon | 3 | 83667 | 998 | 9.360 | 8938.8 |
| 7604 | 2024-03-22 16:19:16 | logon | 1 | 28756 | 10 | 0.983 | 29253.3 |
| 7603 | 2024-03-21 23:03:17 | logon | 2 | 53800 | 83 | 5.500 | 9781.8 |
| 7602 | 2024-03-21 23:03:15 | logon | 1 | 28756 | 10 | 0.576 | 49923.6 |
| 7601 | 2024-03-21 18:05:56 | logon | 1 | 28756 | 10 | 1.143 | 25158.4 |
| 7600 | 2024-03-21 15:39:15 | logon | 1 | 28756 | 10 | 1.203 | 23903.6 |
| 7599 | 2024-03-20 18:54:24 | logon | 1 | 28756 | 10 | 0.530 | 54256.6 |
| 7598 | 2024-03-19 12:22:47 | logon | 1 | 28756 | 10 | 1.153 | 24940.2 |
| 7597 | 2024-03-08 10:23:53 | logon | 1 | 28756 | 10 | 0.576 | 49923.6 |
| 7596 | 2024-03-07 18:35:56 | logon | 2 | 53800 | 83 | 1.906 | 28226.7 |
| 7595 | 2024-03-07 05:25:22 | logon | 3 | 83667 | 998 | 9.000 | 9296.3 |
| 7594 | 2024-03-07 05:25:23 | logon | 2 | 53800 | 83 | 2.173 | 24758.4 |
| 7593 | 2024-03-05 19:02:18 | logon | 2 | 53800 | 83 | 7.606 | 7073.4 |
| 7592 | 2024-03-05 09:20:16 | logon | 3 | 83667 | 998 | 5.173 | 16173.8 |
| 7591 | 2024-03-05 09:20:13 | logon | 2 | 53800 | 83 | 3.106 | 17321.3 |
| 7590 | 2024-03-05 08:46:49 | logon | 1 | 28756 | 10 | 1.123 | 25606.4 |
| 7589 | 2024-02-28 10:34:12 | logon | 2 | 53800 | 83 | 3.000 | 17933.3 |
| 7588 | 2024-02-28 10:33:36 | logon | 3 | 83667 | 998 | 5.846 | 14311.8 |
| 7587 | 2024-02-28 06:46:54 | logon | 2 | 53800 | 83 | 3.606 | 14919.6 |
| 7586 | 2024-02-28 06:46:21 | logon | 3 | 83667 | 998 | 4.483 | 18663.2 |
| 7585 | 2024-02-25 15:59:36 | logon | 3 | 83667 | 998 | 4.360 | 19189.7 |
| 7584 | 2024-02-25 15:59:35 | logon | 2 | 53800 | 83 | 1.750 | 30742.9 |
| 7583 | 2024-02-25 15:47:19 | logon | 1 | 28756 | 10 | 0.576 | 49923.6 |
| 7582 | 2024-02-21 07:07:35 | logon | 1 | 28756 | 10 | 0.546 | 52666.7 |
| 7581 | 2024-02-21 06:00:57 | logon | 1 | 28756 | 10 | 0.516 | 55728.7 |
| 7580 | 2024-02-21 03:59:26 | logon | 1 | 28756 | 10 | 1.156 | 24875.4 |
| 7579 | 2024-02-20 19:51:38 | logon | 1 | 28756 | 10 | 1.093 | 26309.2 |
| 7578 | 2024-02-19 09:31:59 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
| 7577 | 2024-02-07 15:23:00 | logon | 3 | 83667 | 998 | 3.936 | 21256.9 |
| 7576 | 2024-01-29 11:20:25 | logon | 3 | 83667 | 998 | 3.533 | 23681.6 |
| 7575 | 2024-01-29 02:59:15 | logon | 2 | 53800 | 83 | 1.546 | 34799.5 |
| 7574 | 2024-01-29 02:58:31 | logon | 3 | 83667 | 998 | 3.263 | 25641.1 |
| 7573 | 2024-01-26 13:34:44 | logon | 3 | 83667 | 998 | 4.063 | 20592.4 |
| 7572 | 2024-01-26 13:34:42 | logon | 2 | 53800 | 83 | 1.546 | 34799.5 |
| 7571 | 2024-01-26 13:09:41 | logon | 1 | 28756 | 10 | 0.513 | 56054.6 |
| 7570 | 2024-01-24 11:04:36 | logon | 3 | 83667 | 998 | 3.766 | 22216.4 |
| 7569 | 2024-01-24 00:30:16 | logon | 3 | 83667 | 998 | 3.876 | 21585.9 |