History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"guard"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
839 | 2024-04-25 22:19:53 | guard | 3 | 83667 | 1075 | 3.843 | 21771.3 |
838 | 2024-04-16 17:51:37 | guard | 2 | 53800 | 78 | 1.860 | 28924.7 |
837 | 2024-04-13 05:53:13 | guard | 2 | 53800 | 78 | 1.580 | 34050.6 |
836 | 2024-04-13 05:53:09 | guard | 1 | 28756 | 4 | 0.500 | 57512.0 |
835 | 2024-04-13 05:53:03 | guard | 2 | 53800 | 78 | 1.750 | 30742.9 |
834 | 2024-04-13 05:52:39 | guard | 3 | 83667 | 1075 | 3.966 | 21096.1 |
833 | 2024-04-04 20:05:51 | guard | 1 | 28756 | 4 | 1.923 | 14953.7 |
832 | 2024-04-04 19:43:08 | guard | 3 | 83667 | 1075 | 4.533 | 18457.3 |
831 | 2024-04-03 16:58:38 | guard | 3 | 83667 | 1075 | 15.486 | 5402.8 |
830 | 2024-04-03 09:12:39 | guard | 3 | 83667 | 1075 | 11.953 | 6999.7 |
829 | 2024-04-03 06:29:29 | guard | 3 | 83667 | 1075 | 15.310 | 5464.9 |
828 | 2024-04-03 06:29:27 | guard | 2 | 53800 | 78 | 2.640 | 20378.8 |
827 | 2024-04-03 06:23:23 | guard | 1 | 28756 | 4 | 1.720 | 16718.6 |
826 | 2024-03-31 07:36:06 | guard | 1 | 28756 | 4 | 0.423 | 67981.1 |
825 | 2024-03-29 05:07:06 | guard | 1 | 28756 | 4 | 1.690 | 17015.4 |
824 | 2024-03-29 01:54:38 | guard | 1 | 28756 | 4 | 0.563 | 51076.4 |
823 | 2024-03-05 18:00:59 | guard | 1 | 28756 | 4 | 1.606 | 17905.4 |
822 | 2024-03-03 20:53:49 | guard | 1 | 28756 | 4 | 0.890 | 32310.1 |
821 | 2024-03-01 10:42:40 | guard | 1 | 28756 | 4 | 1.203 | 23903.6 |
820 | 2024-03-01 03:36:56 | guard | 1 | 28756 | 4 | 0.500 | 57512.0 |
819 | 2024-02-27 20:15:14 | guard | 1 | 28756 | 4 | 0.546 | 52666.7 |
818 | 2024-02-07 05:05:20 | guard | 1 | 28756 | 4 | 0.483 | 59536.2 |
817 | 2024-01-28 23:29:29 | guard | 1 | 28756 | 4 | 0.423 | 67981.1 |
816 | 2024-01-26 07:32:27 | guard | 1 | 28756 | 4 | 0.500 | 57512.0 |
815 | 2024-01-22 22:46:31 | guard | 1 | 28756 | 4 | 0.500 | 57512.0 |
814 | 2024-01-12 07:28:40 | guard | 3 | 83667 | 1075 | 4.046 | 20678.9 |
813 | 2024-01-12 07:28:41 | guard | 2 | 53800 | 78 | 1.656 | 32487.9 |
812 | 2023-12-18 11:04:00 | guard | 1 | 28756 | 4 | 0.516 | 55728.7 |
811 | 2023-12-03 13:27:12 | guard | 1 | 28756 | 4 | 0.513 | 56054.6 |
810 | 2023-12-03 13:27:11 | guard | 1 | 28756 | 4 | 0.483 | 59536.2 |
809 | 2023-11-27 05:01:35 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
808 | 2023-11-19 15:06:55 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
807 | 2023-11-15 14:09:00 | guard | 1 | 28756 | 4 | 0.440 | 65354.5 |
806 | 2023-11-03 10:52:17 | guard | 1 | 28756 | 4 | 0.486 | 59168.7 |
805 | 2023-10-23 15:59:12 | guard | 1 | 28756 | 4 | 1.186 | 24246.2 |
804 | 2023-10-20 06:37:21 | guard | 1 | 28756 | 4 | 0.546 | 52666.7 |
803 | 2023-10-20 03:15:33 | guard | 1 | 28756 | 4 | 0.483 | 59536.2 |
802 | 2023-10-15 05:16:43 | guard | 1 | 28756 | 4 | 0.486 | 59168.7 |
801 | 2023-10-05 06:39:22 | guard | 1 | 28756 | 4 | 0.470 | 61183.0 |
800 | 2023-09-28 16:07:06 | guard | 1 | 28756 | 4 | 0.500 | 57512.0 |
799 | 2023-09-25 20:59:28 | guard | 1 | 28756 | 4 | 0.483 | 59536.2 |
798 | 2023-09-13 13:53:37 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
797 | 2023-09-12 01:46:26 | guard | 1 | 28756 | 4 | 0.440 | 65354.5 |
796 | 2023-06-16 15:42:12 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
795 | 2023-06-11 13:42:29 | guard | 1 | 28756 | 4 | 0.423 | 67981.1 |
794 | 2023-03-31 02:52:42 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
793 | 2023-03-02 11:59:31 | guard | 1 | 28756 | 4 | 0.466 | 61708.2 |
792 | 2023-01-13 13:19:24 | guard | 1 | 28756 | 4 | 0.420 | 68466.7 |
791 | 2022-11-10 01:24:53 | guard | 1 | 28756 | 4 | 0.450 | 63902.2 |
790 | 2022-10-20 20:25:07 | guard | 1 | 28756 | 4 | 0.453 | 63479.0 |
789 | 2022-09-17 20:26:50 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
788 | 2022-09-12 12:10:28 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
787 | 2022-08-15 11:21:23 | guard | 1 | 28756 | 4 | 0.500 | 57512.0 |
786 | 2022-08-14 04:53:56 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
785 | 2022-07-17 02:50:52 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
784 | 2022-06-12 04:59:39 | guard | 1 | 28756 | 4 | 0.486 | 59168.7 |
783 | 2022-06-10 00:29:35 | guard | 1 | 28756 | 4 | 0.453 | 63479.0 |
782 | 2022-03-19 19:49:57 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
781 | 2022-02-15 12:29:44 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
780 | 2021-12-06 22:18:20 | guard | 1 | 28756 | 4 | 0.470 | 61183.0 |
779 | 2021-12-04 21:08:45 | guard | 1 | 28756 | 4 | 0.483 | 59536.2 |
778 | 2021-12-02 16:33:40 | guard | 1 | 28756 | 4 | 0.483 | 59536.2 |
777 | 2021-10-14 07:24:24 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
776 | 2021-09-06 01:06:17 | guard | 1 | 28756 | 4 | 0.470 | 61183.0 |
775 | 2021-09-03 18:26:31 | guard | 1 | 28756 | 4 | 0.516 | 55728.7 |
774 | 2021-08-26 07:25:58 | guard | 1 | 28756 | 4 | 0.470 | 61183.0 |
773 | 2021-08-15 01:10:31 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
772 | 2021-07-27 05:10:07 | guard | 1 | 28756 | 4 | 0.500 | 57512.0 |
771 | 2021-05-25 13:35:45 | guard | 1 | 28756 | 4 | 0.516 | 55728.7 |
770 | 2021-05-17 22:32:39 | guard | 1 | 28756 | 4 | 0.500 | 57512.0 |
769 | 2021-02-20 01:52:31 | guard | 1 | 28756 | 4 | 0.516 | 55728.7 |
768 | 2021-02-17 05:44:26 | guard | 3 | 83667 | 1075 | 3.656 | 22884.8 |
767 | 2021-02-01 14:44:30 | guard | 1 | 28756 | 4 | 0.486 | 59168.7 |
766 | 2021-01-30 08:48:52 | guard | 1 | 28756 | 4 | 0.453 | 63479.0 |
765 | 2021-01-02 07:51:37 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
764 | 2020-11-21 03:33:08 | guard | 1 | 28756 | 4 | 0.440 | 65354.5 |
763 | 2020-11-03 18:03:55 | guard | 2 | 53800 | 78 | 1.720 | 31279.1 |
762 | 2020-10-25 00:11:13 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
761 | 2020-10-23 07:30:42 | guard | 1 | 28756 | 4 | 0.420 | 68466.7 |
760 | 2020-10-21 02:54:20 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
759 | 2020-10-19 11:16:18 | guard | 1 | 28756 | 4 | 0.420 | 68466.7 |
758 | 2020-10-17 19:59:40 | guard | 1 | 28756 | 4 | 0.576 | 49923.6 |
757 | 2020-09-10 01:17:24 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
756 | 2020-09-04 06:15:18 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
755 | 2020-08-21 10:32:02 | guard | 1 | 28756 | 4 | 0.450 | 63902.2 |
754 | 2020-08-20 10:43:27 | guard | 1 | 28756 | 4 | 0.470 | 61183.0 |
753 | 2020-08-18 13:59:45 | guard | 1 | 28756 | 4 | 0.483 | 59536.2 |
752 | 2020-05-26 06:15:29 | guard | 1 | 28756 | 4 | 0.453 | 63479.0 |
751 | 2020-05-06 23:21:14 | guard | 1 | 28756 | 4 | 0.436 | 65954.1 |
750 | 2020-03-29 07:10:33 | guard | 3 | 83667 | 1075 | 8.343 | 10028.4 |
749 | 2020-03-28 05:37:22 | guard | 3 | 83667 | 1075 | 4.420 | 18929.2 |
748 | 2020-03-25 15:53:41 | guard | 1 | 28756 | 4 | 0.483 | 59536.2 |
747 | 2020-03-25 05:34:53 | guard | 1 | 28756 | 4 | 0.500 | 57512.0 |
746 | 2020-03-24 21:42:54 | guard | 3 | 83667 | 1075 | 4.563 | 18336.0 |
745 | 2020-03-24 20:48:23 | guard | 3 | 83667 | 1075 | 4.156 | 20131.6 |
744 | 2020-03-24 09:55:00 | guard | 3 | 83667 | 1075 | 6.423 | 13026.2 |
743 | 2020-03-24 03:16:23 | guard | 3 | 83667 | 1075 | 4.393 | 19045.5 |
742 | 2020-03-23 21:29:06 | guard | 3 | 83667 | 1075 | 4.096 | 20426.5 |
741 | 2020-03-23 15:55:34 | guard | 3 | 83667 | 1075 | 3.656 | 22884.8 |
740 | 2020-03-23 12:50:28 | guard | 1 | 28756 | 4 | 1.563 | 18398.0 |