History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"goods"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
896 | 2024-04-29 20:38:17 | goods | 1 | 28756 | 18 | 0.483 | 59536.2 |
895 | 2024-04-27 19:30:41 | goods | 1 | 28756 | 18 | 0.516 | 55728.7 |
894 | 2024-04-27 01:40:46 | goods | 1 | 28756 | 18 | 1.733 | 16593.2 |
893 | 2024-04-19 12:19:54 | goods | 1 | 28756 | 18 | 0.546 | 52666.7 |
892 | 2024-04-03 04:34:12 | goods | 1 | 28756 | 18 | 1.546 | 18600.3 |
891 | 2024-03-31 01:17:33 | goods | 1 | 28756 | 18 | 1.733 | 16593.2 |
890 | 2024-03-27 01:05:03 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
889 | 2024-03-17 04:01:09 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
888 | 2024-03-04 03:53:23 | goods | 2 | 53800 | 216 | 1.716 | 31352.0 |
887 | 2024-03-04 00:43:51 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
886 | 2024-02-25 18:22:23 | goods | 1 | 28756 | 18 | 0.656 | 43835.4 |
885 | 2024-01-29 00:58:35 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
884 | 2024-01-25 23:23:41 | goods | 1 | 28756 | 18 | 1.033 | 27837.4 |
883 | 2024-01-01 19:33:19 | goods | 1 | 28756 | 18 | 0.516 | 55728.7 |
882 | 2023-12-26 09:22:44 | goods | 2 | 53800 | 216 | 1.390 | 38705.0 |
881 | 2023-12-17 07:14:21 | goods | 2 | 53800 | 216 | 1.533 | 35094.6 |
880 | 2023-12-07 21:27:56 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
879 | 2023-12-07 21:27:55 | goods | 1 | 28756 | 18 | 0.483 | 59536.2 |
878 | 2023-11-15 12:13:22 | goods | 1 | 28756 | 18 | 0.440 | 65354.5 |
877 | 2023-11-13 05:26:00 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
876 | 2023-11-12 07:57:47 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
875 | 2023-11-12 05:47:44 | goods | 2 | 53800 | 216 | 1.656 | 32487.9 |
874 | 2023-11-03 05:39:07 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
873 | 2023-10-27 15:06:11 | goods | 2 | 53800 | 216 | 1.453 | 37026.8 |
872 | 2023-10-26 17:14:56 | goods | 1 | 28756 | 18 | 0.560 | 51350.0 |
871 | 2023-10-22 12:58:26 | goods | 1 | 28756 | 18 | 0.423 | 67981.1 |
870 | 2023-10-19 22:00:19 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
869 | 2023-10-19 19:57:15 | goods | 1 | 28756 | 18 | 0.483 | 59536.2 |
868 | 2023-10-18 07:31:29 | goods | 2 | 53800 | 216 | 1.623 | 33148.5 |
867 | 2023-10-17 12:18:21 | goods | 1 | 28756 | 18 | 0.466 | 61708.2 |
866 | 2023-10-16 00:32:31 | goods | 2 | 53800 | 216 | 1.673 | 32157.8 |
865 | 2023-10-12 23:41:42 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
864 | 2023-10-06 08:02:10 | goods | 1 | 28756 | 18 | 0.423 | 67981.1 |
863 | 2023-09-27 14:52:43 | goods | 1 | 28756 | 18 | 0.516 | 55728.7 |
862 | 2023-09-18 02:52:03 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
861 | 2023-08-18 21:06:32 | goods | 1 | 28756 | 18 | 0.453 | 63479.0 |
860 | 2023-07-30 08:06:08 | goods | 1 | 28756 | 18 | 0.453 | 63479.0 |
859 | 2023-05-17 22:20:02 | goods | 1 | 28756 | 18 | 0.450 | 63902.2 |
858 | 2023-04-21 23:45:16 | goods | 1 | 28756 | 18 | 0.516 | 55728.7 |
857 | 2023-03-13 18:12:35 | goods | 1 | 28756 | 18 | 0.453 | 63479.0 |
856 | 2023-03-03 01:18:22 | goods | 1 | 28756 | 18 | 0.420 | 68466.7 |
855 | 2023-01-17 09:03:46 | goods | 1 | 28756 | 18 | 0.453 | 63479.0 |
854 | 2023-01-09 14:02:06 | goods | 1 | 28756 | 18 | 0.466 | 61708.2 |
853 | 2023-01-02 18:08:03 | goods | 1 | 28756 | 18 | 0.420 | 68466.7 |
852 | 2022-09-29 08:56:22 | goods | 1 | 28756 | 18 | 0.530 | 54256.6 |
851 | 2022-09-24 21:13:35 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
850 | 2022-09-10 15:51:54 | goods | 1 | 28756 | 18 | 0.440 | 65354.5 |
849 | 2022-09-10 14:56:56 | goods | 1 | 28756 | 18 | 0.470 | 61183.0 |
848 | 2022-08-26 03:12:00 | goods | 1 | 28756 | 18 | 0.486 | 59168.7 |
847 | 2022-08-08 00:43:57 | goods | 2 | 53800 | 216 | 1.343 | 40059.6 |
846 | 2022-08-07 01:30:43 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
845 | 2022-07-30 02:42:40 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
844 | 2022-07-03 10:24:12 | goods | 1 | 28756 | 18 | 0.453 | 63479.0 |
843 | 2022-07-02 23:12:02 | goods | 1 | 28756 | 18 | 0.470 | 61183.0 |
842 | 2022-07-02 09:20:14 | goods | 1 | 28756 | 18 | 0.483 | 59536.2 |
841 | 2022-06-16 10:21:50 | goods | 1 | 28756 | 18 | 0.470 | 61183.0 |
840 | 2022-06-16 01:48:07 | goods | 1 | 28756 | 18 | 0.466 | 61708.2 |
839 | 2022-06-15 19:48:46 | goods | 1 | 28756 | 18 | 0.486 | 59168.7 |
838 | 2022-06-15 17:03:41 | goods | 1 | 28756 | 18 | 0.580 | 49579.3 |
837 | 2022-06-08 16:01:07 | goods | 1 | 28756 | 18 | 0.456 | 63061.4 |
836 | 2022-06-01 12:23:40 | goods | 1 | 28756 | 18 | 0.486 | 59168.7 |
835 | 2022-05-26 02:40:23 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
834 | 2022-05-25 15:49:18 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
833 | 2022-05-18 22:06:54 | goods | 1 | 28756 | 18 | 0.516 | 55728.7 |
832 | 2022-05-17 19:48:44 | goods | 1 | 28756 | 18 | 0.516 | 55728.7 |
831 | 2022-05-16 20:21:26 | goods | 1 | 28756 | 18 | 0.530 | 54256.6 |
830 | 2022-05-14 19:10:26 | goods | 1 | 28756 | 18 | 0.450 | 63902.2 |
829 | 2022-05-13 12:27:56 | goods | 1 | 28756 | 18 | 0.576 | 49923.6 |
828 | 2022-05-10 22:12:44 | goods | 1 | 28756 | 18 | 0.486 | 59168.7 |
827 | 2022-05-08 17:40:13 | goods | 1 | 28756 | 18 | 0.486 | 59168.7 |
826 | 2022-04-27 16:10:24 | goods | 2 | 53800 | 216 | 1.720 | 31279.1 |
825 | 2022-03-23 22:20:51 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
824 | 2022-03-15 10:28:05 | goods | 1 | 28756 | 18 | 0.513 | 56054.6 |
823 | 2022-03-14 18:23:57 | goods | 1 | 28756 | 18 | 0.486 | 59168.7 |
822 | 2022-03-13 18:26:51 | goods | 1 | 28756 | 18 | 0.516 | 55728.7 |
821 | 2022-03-12 17:00:54 | goods | 1 | 28756 | 18 | 0.470 | 61183.0 |
820 | 2022-03-04 03:17:54 | goods | 1 | 28756 | 18 | 0.470 | 61183.0 |
819 | 2022-02-28 17:25:52 | goods | 1 | 28756 | 18 | 0.766 | 37540.5 |
818 | 2022-02-01 23:20:15 | goods | 1 | 28756 | 18 | 0.530 | 54256.6 |
817 | 2022-01-31 23:32:56 | goods | 1 | 28756 | 18 | 0.530 | 54256.6 |
816 | 2022-01-25 13:04:59 | goods | 1 | 28756 | 18 | 0.483 | 59536.2 |
815 | 2022-01-23 20:59:37 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
814 | 2022-01-13 14:00:59 | goods | 1 | 28756 | 18 | 0.546 | 52666.7 |
813 | 2022-01-12 14:13:59 | goods | 1 | 28756 | 18 | 0.936 | 30722.2 |
812 | 2022-01-11 17:49:15 | goods | 1 | 28756 | 18 | 0.436 | 65954.1 |
811 | 2022-01-10 19:24:29 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
810 | 2021-12-31 18:12:14 | goods | 1 | 28756 | 18 | 0.563 | 51076.4 |
809 | 2021-12-31 07:20:46 | goods | 1 | 28756 | 18 | 0.516 | 55728.7 |
808 | 2021-12-30 18:08:10 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
807 | 2021-12-30 00:05:26 | goods | 1 | 28756 | 18 | 0.563 | 51076.4 |
806 | 2021-12-29 17:01:46 | goods | 1 | 28756 | 18 | 0.453 | 63479.0 |
805 | 2021-12-29 05:45:51 | goods | 1 | 28756 | 18 | 0.453 | 63479.0 |
804 | 2021-12-28 16:29:58 | goods | 1 | 28756 | 18 | 0.500 | 57512.0 |
803 | 2021-12-28 12:59:59 | goods | 2 | 53800 | 216 | 1.533 | 35094.6 |
802 | 2021-12-27 22:09:51 | goods | 1 | 28756 | 18 | 0.470 | 61183.0 |
801 | 2021-12-27 12:48:19 | goods | 1 | 28756 | 18 | 0.550 | 52283.6 |
800 | 2021-12-26 23:34:30 | goods | 1 | 28756 | 18 | 0.513 | 56054.6 |
799 | 2021-12-26 14:30:58 | goods | 1 | 28756 | 18 | 0.486 | 59168.7 |
798 | 2021-12-26 03:22:14 | goods | 1 | 28756 | 18 | 0.513 | 56054.6 |
797 | 2021-12-25 10:57:40 | goods | 1 | 28756 | 18 | 0.533 | 53951.2 |