History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
768 | 2025-07-08 03:29:03 | harry | 1 | 28756 | 12 | 1.250 | 23004.8 |
767 | 2025-07-07 17:14:30 | harry | 1 | 28756 | 12 | 2.343 | 12273.2 |
766 | 2025-07-07 14:02:30 | harry | 1 | 28756 | 12 | 4.033 | 7130.2 |
765 | 2025-07-06 08:39:02 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
764 | 2025-07-04 08:14:17 | harry | 1 | 28756 | 12 | 2.310 | 12448.5 |
763 | 2025-06-30 12:32:04 | harry | 1 | 28756 | 12 | 3.923 | 7330.1 |
762 | 2025-06-30 12:03:38 | harry | 1 | 28756 | 12 | 1.356 | 21206.5 |
761 | 2025-06-18 04:02:36 | harry | 1 | 28756 | 12 | 2.330 | 12341.6 |
760 | 2025-06-13 22:05:58 | harry | 1 | 28756 | 12 | 1.513 | 19005.9 |
759 | 2025-06-08 03:10:26 | harry | 1 | 28756 | 12 | 1.186 | 24246.2 |
758 | 2025-06-06 13:06:57 | harry | 1 | 28756 | 12 | 2.593 | 11089.9 |
757 | 2025-06-03 11:24:28 | harry | 1 | 28756 | 12 | 0.530 | 54256.6 |
756 | 2025-06-02 08:13:53 | harry | 1 | 28756 | 12 | 2.626 | 10950.5 |
755 | 2025-05-31 00:20:02 | harry | 1 | 28756 | 12 | 2.000 | 14378.0 |
754 | 2025-05-29 05:42:46 | harry | 1 | 28756 | 12 | 2.220 | 12953.2 |
753 | 2025-05-19 03:44:35 | harry | 1 | 28756 | 12 | 3.686 | 7801.4 |
752 | 2025-05-18 17:47:53 | harry | 1 | 28756 | 12 | 3.390 | 8482.6 |
751 | 2025-05-16 18:37:35 | harry | 1 | 28756 | 12 | 1.390 | 20687.8 |
750 | 2025-05-12 03:06:54 | harry | 2 | 53800 | 125 | 7.996 | 6728.4 |
749 | 2025-05-10 20:21:29 | harry | 2 | 53800 | 125 | 9.390 | 5729.5 |
748 | 2025-05-08 02:50:16 | harry | 1 | 28756 | 12 | 2.873 | 10009.0 |
747 | 2025-05-08 02:48:11 | harry | 1 | 28756 | 12 | 1.530 | 18794.8 |
746 | 2025-05-08 02:40:29 | harry | 1 | 28756 | 12 | 5.390 | 5335.1 |
745 | 2025-05-08 02:37:38 | harry | 1 | 28756 | 12 | 1.606 | 17905.4 |
744 | 2025-05-05 14:05:27 | harry | 1 | 28756 | 12 | 1.610 | 17860.9 |
743 | 2025-05-05 06:49:34 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
742 | 2025-05-04 11:22:26 | harry | 1 | 28756 | 12 | 2.500 | 11502.4 |
741 | 2025-05-01 07:56:16 | harry | 1 | 28756 | 12 | 0.530 | 54256.6 |
740 | 2025-04-30 11:57:03 | harry | 1 | 28756 | 12 | 2.436 | 11804.6 |
739 | 2025-04-23 14:07:08 | harry | 2 | 53800 | 125 | 1.420 | 37887.3 |
738 | 2025-04-18 00:50:48 | harry | 1 | 28756 | 12 | 2.016 | 14263.9 |
737 | 2025-04-16 03:37:24 | harry | 1 | 28756 | 12 | 2.783 | 10332.7 |
736 | 2025-04-15 20:13:35 | harry | 1 | 28756 | 12 | 3.703 | 7765.6 |
735 | 2025-04-15 03:29:40 | harry | 1 | 28756 | 12 | 3.593 | 8003.3 |
734 | 2025-04-08 02:09:52 | harry | 1 | 28756 | 12 | 3.466 | 8296.6 |
733 | 2025-04-08 00:20:41 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
732 | 2025-04-07 03:56:51 | harry | 1 | 28756 | 12 | 3.703 | 7765.6 |
731 | 2025-04-06 03:37:42 | harry | 2 | 53800 | 125 | 7.093 | 7584.9 |
730 | 2025-04-04 12:54:52 | harry | 1 | 28756 | 12 | 5.063 | 5679.6 |
729 | 2025-04-04 12:37:00 | harry | 2 | 53800 | 125 | 8.310 | 6474.1 |
728 | 2025-04-04 03:20:56 | harry | 2 | 53800 | 125 | 4.220 | 12748.8 |
727 | 2025-04-03 10:56:48 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
726 | 2025-03-31 09:49:08 | harry | 1 | 28756 | 12 | 2.733 | 10521.8 |
725 | 2025-03-29 14:30:24 | harry | 1 | 28756 | 12 | 2.326 | 12362.9 |
724 | 2025-03-23 01:09:15 | harry | 2 | 53800 | 125 | 8.266 | 6508.6 |
723 | 2025-03-19 04:56:32 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
722 | 2025-03-17 14:20:42 | harry | 1 | 28756 | 12 | 1.953 | 14724.0 |
721 | 2025-03-16 21:18:08 | harry | 2 | 53800 | 125 | 1.826 | 29463.3 |
720 | 2025-03-16 12:33:49 | harry | 2 | 53800 | 125 | 4.263 | 12620.2 |
719 | 2025-03-16 12:29:23 | harry | 1 | 28756 | 12 | 0.970 | 29645.4 |
718 | 2025-03-07 15:19:10 | harry | 1 | 28756 | 12 | 2.186 | 13154.6 |
717 | 2025-03-04 16:53:57 | harry | 1 | 28756 | 12 | 2.796 | 10284.7 |
716 | 2025-03-03 21:41:37 | harry | 1 | 28756 | 12 | 0.890 | 32310.1 |
715 | 2025-02-27 23:58:02 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
714 | 2025-02-27 21:53:24 | harry | 2 | 53800 | 125 | 8.923 | 6029.4 |
713 | 2025-02-27 10:03:59 | harry | 2 | 53800 | 125 | 1.670 | 32215.6 |
712 | 2025-02-27 08:18:31 | harry | 2 | 53800 | 125 | 7.500 | 7173.3 |
711 | 2025-02-27 07:11:30 | harry | 1 | 28756 | 12 | 0.563 | 51076.4 |
710 | 2025-02-05 15:45:06 | harry | 1 | 28756 | 12 | 1.860 | 15460.2 |
709 | 2025-01-31 19:44:45 | harry | 1 | 28756 | 12 | 2.546 | 11294.6 |
708 | 2025-01-28 13:45:41 | harry | 2 | 53800 | 125 | 8.406 | 6400.2 |
707 | 2025-01-28 08:23:02 | harry | 1 | 28756 | 12 | 3.313 | 8679.7 |
706 | 2025-01-28 00:39:17 | harry | 2 | 53800 | 125 | 1.656 | 32487.9 |
705 | 2025-01-27 23:13:00 | harry | 2 | 53800 | 125 | 7.063 | 7617.2 |
704 | 2025-01-27 23:10:39 | harry | 1 | 28756 | 12 | 0.513 | 56054.6 |
703 | 2025-01-21 17:01:54 | harry | 2 | 53800 | 125 | 9.703 | 5544.7 |
702 | 2025-01-06 11:13:52 | harry | 1 | 28756 | 12 | 1.343 | 21411.8 |
701 | 2024-12-29 09:07:01 | harry | 2 | 53800 | 125 | 9.563 | 5625.8 |
700 | 2024-12-29 08:03:40 | harry | 1 | 28756 | 12 | 0.733 | 39230.6 |
699 | 2024-12-28 22:39:19 | harry | 2 | 53800 | 125 | 12.016 | 4477.4 |
698 | 2024-12-28 22:38:44 | harry | 1 | 28756 | 12 | 0.970 | 29645.4 |
697 | 2024-12-06 03:09:32 | harry | 1 | 28756 | 12 | 3.280 | 8767.1 |
696 | 2024-11-29 01:56:43 | harry | 2 | 53800 | 125 | 7.580 | 7097.6 |
695 | 2024-11-29 01:49:41 | harry | 1 | 28756 | 12 | 2.016 | 14263.9 |
694 | 2024-11-28 21:33:49 | harry | 2 | 53800 | 125 | 5.126 | 10495.5 |
693 | 2024-11-28 21:21:53 | harry | 1 | 28756 | 12 | 0.513 | 56054.6 |
692 | 2024-11-26 13:23:01 | harry | 1 | 28756 | 12 | 1.533 | 18758.0 |
691 | 2024-11-20 18:40:16 | harry | 1 | 28756 | 12 | 0.486 | 59168.7 |
690 | 2024-11-07 06:55:07 | harry | 1 | 28756 | 12 | 2.720 | 10572.1 |
689 | 2024-10-30 02:30:15 | harry | 1 | 28756 | 12 | 0.530 | 54256.6 |
688 | 2024-10-30 01:48:41 | harry | 2 | 53800 | 125 | 4.766 | 11288.3 |
687 | 2024-10-29 22:01:20 | harry | 2 | 53800 | 125 | 10.236 | 5256.0 |
686 | 2024-10-29 21:52:55 | harry | 1 | 28756 | 12 | 2.203 | 13053.1 |
685 | 2024-10-27 13:08:59 | harry | 1 | 28756 | 12 | 2.393 | 12016.7 |
684 | 2024-10-08 19:58:53 | harry | 1 | 28756 | 12 | 2.546 | 11294.6 |
683 | 2024-10-08 03:01:26 | harry | 1 | 28756 | 12 | 5.686 | 5057.3 |
682 | 2024-09-29 23:14:00 | harry | 2 | 53800 | 125 | 18.640 | 2886.3 |
681 | 2024-09-29 17:57:12 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
680 | 2024-09-29 14:50:50 | harry | 2 | 53800 | 125 | 6.890 | 7808.4 |
679 | 2024-09-29 14:42:18 | harry | 1 | 28756 | 12 | 3.110 | 9246.3 |
678 | 2024-09-25 16:42:08 | harry | 1 | 28756 | 12 | 3.890 | 7392.3 |
677 | 2024-09-22 07:50:52 | harry | 1 | 28756 | 12 | 3.653 | 7871.9 |
676 | 2024-08-30 20:46:17 | harry | 2 | 53800 | 125 | 9.610 | 5598.3 |
675 | 2024-08-30 13:49:27 | harry | 2 | 53800 | 125 | 17.406 | 3090.9 |
674 | 2024-08-30 13:43:15 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
673 | 2024-08-30 11:51:47 | harry | 1 | 28756 | 12 | 3.406 | 8442.7 |
672 | 2024-08-29 18:35:32 | harry | 1 | 28756 | 12 | 3.813 | 7541.6 |
671 | 2024-08-26 15:16:44 | harry | 1 | 28756 | 12 | 1.810 | 15887.3 |
670 | 2024-08-08 01:26:07 | harry | 1 | 28756 | 12 | 1.470 | 19561.9 |
669 | 2024-08-07 09:31:45 | harry | 1 | 28756 | 12 | 1.936 | 14853.3 |