History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"foods"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
912 | 2024-05-04 03:25:49 | foods | 2 | 53800 | 205 | 3.706 | 14517.0 |
911 | 2024-05-04 03:25:44 | foods | 1 | 28756 | 15 | 1.126 | 25538.2 |
910 | 2024-05-04 03:25:29 | foods | 2 | 53800 | 205 | 1.563 | 34421.0 |
909 | 2024-05-03 23:15:26 | foods | 1 | 28756 | 15 | 0.530 | 54256.6 |
908 | 2024-04-22 05:23:04 | foods | 2 | 53800 | 205 | 1.440 | 37361.1 |
907 | 2024-04-16 14:16:52 | foods | 1 | 28756 | 15 | 2.060 | 13959.2 |
906 | 2024-04-16 14:15:31 | foods | 1 | 28756 | 15 | 0.920 | 31256.5 |
905 | 2024-04-03 19:40:11 | foods | 2 | 53800 | 205 | 1.843 | 29191.5 |
904 | 2024-04-03 04:46:06 | foods | 2 | 53800 | 205 | 1.890 | 28465.6 |
903 | 2024-04-03 04:15:54 | foods | 1 | 28756 | 15 | 1.173 | 24514.9 |
902 | 2024-04-01 23:02:52 | foods | 2 | 53800 | 205 | 1.843 | 29191.5 |
901 | 2024-03-31 01:17:46 | foods | 1 | 28756 | 15 | 1.263 | 22768.0 |
900 | 2024-03-29 04:25:31 | foods | 1 | 28756 | 15 | 0.563 | 51076.4 |
899 | 2024-03-29 04:25:20 | foods | 2 | 53800 | 205 | 3.033 | 17738.2 |
898 | 2024-03-29 04:25:03 | foods | 1 | 28756 | 15 | 0.530 | 54256.6 |
897 | 2024-03-04 03:55:05 | foods | 2 | 53800 | 205 | 1.623 | 33148.5 |
896 | 2024-03-03 20:05:49 | foods | 2 | 53800 | 205 | 1.513 | 35558.5 |
895 | 2024-03-02 16:07:56 | foods | 2 | 53800 | 205 | 1.796 | 29955.5 |
894 | 2024-02-28 01:05:05 | foods | 1 | 28756 | 15 | 0.610 | 47141.0 |
893 | 2024-02-05 09:07:13 | foods | 1 | 28756 | 15 | 0.546 | 52666.7 |
892 | 2024-02-02 19:48:04 | foods | 2 | 53800 | 205 | 1.453 | 37026.8 |
891 | 2024-01-28 19:51:17 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
890 | 2024-01-17 17:46:03 | foods | 2 | 53800 | 205 | 1.373 | 39184.3 |
889 | 2024-01-03 00:35:00 | foods | 2 | 53800 | 205 | 1.530 | 35163.4 |
888 | 2024-01-02 05:21:50 | foods | 1 | 28756 | 15 | 0.500 | 57512.0 |
887 | 2023-12-14 13:07:36 | foods | 2 | 53800 | 205 | 1.376 | 39098.8 |
886 | 2023-12-12 23:56:55 | foods | 1 | 28756 | 15 | 0.453 | 63479.0 |
885 | 2023-12-07 15:52:05 | foods | 1 | 28756 | 15 | 0.516 | 55728.7 |
884 | 2023-12-07 15:52:04 | foods | 1 | 28756 | 15 | 0.500 | 57512.0 |
883 | 2023-12-02 16:25:22 | foods | 1 | 28756 | 15 | 0.516 | 55728.7 |
882 | 2023-11-28 01:32:33 | foods | 1 | 28756 | 15 | 0.923 | 31154.9 |
881 | 2023-11-17 18:20:40 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
880 | 2023-11-13 16:13:09 | foods | 1 | 28756 | 15 | 0.486 | 59168.7 |
879 | 2023-11-03 20:25:30 | foods | 1 | 28756 | 15 | 0.516 | 55728.7 |
878 | 2023-10-22 17:47:07 | foods | 1 | 28756 | 15 | 0.450 | 63902.2 |
877 | 2023-10-19 21:59:28 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
876 | 2023-10-17 12:18:15 | foods | 1 | 28756 | 15 | 0.533 | 53951.2 |
875 | 2023-10-11 12:10:57 | foods | 1 | 28756 | 15 | 0.483 | 59536.2 |
874 | 2023-10-06 08:01:32 | foods | 1 | 28756 | 15 | 0.483 | 59536.2 |
873 | 2023-09-29 13:05:01 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
872 | 2023-09-26 10:43:37 | foods | 1 | 28756 | 15 | 0.876 | 32826.5 |
871 | 2023-09-15 22:52:56 | foods | 2 | 53800 | 205 | 1.546 | 34799.5 |
870 | 2023-08-19 03:36:45 | foods | 1 | 28756 | 15 | 0.923 | 31154.9 |
869 | 2023-08-08 17:39:03 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
868 | 2023-06-09 09:23:19 | foods | 2 | 53800 | 205 | 1.330 | 40451.1 |
867 | 2023-05-19 23:24:41 | foods | 1 | 28756 | 15 | 0.440 | 65354.5 |
866 | 2023-04-27 11:38:13 | foods | 1 | 28756 | 15 | 0.530 | 54256.6 |
865 | 2023-03-17 22:38:48 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
864 | 2023-03-12 13:10:24 | foods | 2 | 53800 | 205 | 1.610 | 33416.1 |
863 | 2023-01-22 15:25:16 | foods | 1 | 28756 | 15 | 0.466 | 61708.2 |
862 | 2023-01-17 09:03:46 | foods | 1 | 28756 | 15 | 0.440 | 65354.5 |
861 | 2023-01-05 15:48:38 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
860 | 2022-12-15 17:33:27 | foods | 2 | 53800 | 205 | 1.533 | 35094.6 |
859 | 2022-10-08 07:08:44 | foods | 1 | 28756 | 15 | 0.500 | 57512.0 |
858 | 2022-09-30 23:24:39 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
857 | 2022-09-02 00:12:19 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
856 | 2022-08-15 18:07:37 | foods | 1 | 28756 | 15 | 0.420 | 68466.7 |
855 | 2022-08-15 01:55:05 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
854 | 2022-08-06 00:44:55 | foods | 2 | 53800 | 205 | 1.356 | 39675.5 |
853 | 2022-07-29 09:58:06 | foods | 1 | 28756 | 15 | 0.486 | 59168.7 |
852 | 2022-07-29 00:00:27 | foods | 1 | 28756 | 15 | 0.453 | 63479.0 |
851 | 2022-07-18 11:30:10 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
850 | 2022-06-17 21:23:24 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
849 | 2022-06-16 21:17:44 | foods | 1 | 28756 | 15 | 0.453 | 63479.0 |
848 | 2022-06-15 11:19:38 | foods | 1 | 28756 | 15 | 0.440 | 65354.5 |
847 | 2022-06-14 04:02:33 | foods | 1 | 28756 | 15 | 0.890 | 32310.1 |
846 | 2022-06-08 17:14:59 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
845 | 2022-06-01 18:32:05 | foods | 1 | 28756 | 15 | 0.440 | 65354.5 |
844 | 2022-06-01 13:33:18 | foods | 1 | 28756 | 15 | 0.440 | 65354.5 |
843 | 2022-05-25 17:08:30 | foods | 1 | 28756 | 15 | 0.500 | 57512.0 |
842 | 2022-05-13 06:03:07 | foods | 1 | 28756 | 15 | 0.470 | 61183.0 |
841 | 2022-05-02 00:13:48 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
840 | 2022-05-01 10:03:37 | foods | 1 | 28756 | 15 | 0.500 | 57512.0 |
839 | 2022-04-30 19:26:14 | foods | 1 | 28756 | 15 | 0.453 | 63479.0 |
838 | 2022-04-30 10:40:24 | foods | 1 | 28756 | 15 | 0.486 | 59168.7 |
837 | 2022-04-29 13:14:42 | foods | 1 | 28756 | 15 | 0.686 | 41918.4 |
836 | 2022-04-29 01:32:46 | foods | 1 | 28756 | 15 | 0.580 | 49579.3 |
835 | 2022-04-28 15:29:56 | foods | 1 | 28756 | 15 | 0.593 | 48492.4 |
834 | 2022-03-25 15:43:52 | foods | 1 | 28756 | 15 | 0.453 | 63479.0 |
833 | 2022-03-25 01:45:10 | foods | 1 | 28756 | 15 | 0.623 | 46157.3 |
832 | 2022-03-24 11:00:45 | foods | 1 | 28756 | 15 | 0.513 | 56054.6 |
831 | 2022-03-23 11:56:17 | foods | 1 | 28756 | 15 | 0.486 | 59168.7 |
830 | 2022-03-22 23:41:19 | foods | 1 | 28756 | 15 | 0.453 | 63479.0 |
829 | 2022-03-21 17:12:58 | foods | 1 | 28756 | 15 | 0.686 | 41918.4 |
828 | 2022-03-20 18:39:06 | foods | 1 | 28756 | 15 | 0.500 | 57512.0 |
827 | 2022-03-01 11:21:25 | foods | 1 | 28756 | 15 | 0.513 | 56054.6 |
826 | 2022-02-28 11:38:46 | foods | 1 | 28756 | 15 | 0.560 | 51350.0 |
825 | 2022-02-27 09:19:01 | foods | 1 | 28756 | 15 | 0.533 | 53951.2 |
824 | 2022-02-26 23:52:34 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
823 | 2022-02-26 08:34:05 | foods | 1 | 28756 | 15 | 0.516 | 55728.7 |
822 | 2022-02-25 05:11:34 | foods | 1 | 28756 | 15 | 0.440 | 65354.5 |
821 | 2022-01-30 02:40:47 | foods | 1 | 28756 | 15 | 0.453 | 63479.0 |
820 | 2021-11-25 07:19:36 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
819 | 2021-11-22 02:02:46 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |
818 | 2021-10-08 23:44:46 | foods | 1 | 28756 | 15 | 0.500 | 57512.0 |
817 | 2021-10-06 21:37:10 | foods | 1 | 28756 | 15 | 0.440 | 65354.5 |
816 | 2021-09-04 17:20:08 | foods | 1 | 28756 | 15 | 0.420 | 68466.7 |
815 | 2021-09-02 11:02:58 | foods | 1 | 28756 | 15 | 0.470 | 61183.0 |
814 | 2021-08-19 05:09:05 | foods | 1 | 28756 | 15 | 0.440 | 65354.5 |
813 | 2021-08-15 22:51:32 | foods | 1 | 28756 | 15 | 0.436 | 65954.1 |