History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"flour"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1003 | 2024-05-06 17:08:47 | flour | 1 | 28756 | 9 | 1.016 | 28303.1 |
1002 | 2024-05-05 06:11:00 | flour | 1 | 28756 | 9 | 0.563 | 51076.4 |
1001 | 2024-05-04 21:21:30 | flour | 1 | 28756 | 9 | 1.670 | 17219.2 |
1000 | 2024-05-03 15:05:51 | flour | 1 | 28756 | 9 | 0.516 | 55728.7 |
999 | 2024-04-30 15:16:35 | flour | 1 | 28756 | 9 | 0.483 | 59536.2 |
998 | 2024-04-29 21:15:26 | flour | 1 | 28756 | 9 | 0.516 | 55728.7 |
997 | 2024-04-29 10:35:46 | flour | 1 | 28756 | 9 | 1.063 | 27051.7 |
996 | 2024-04-06 13:43:15 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
995 | 2024-04-04 19:35:23 | flour | 1 | 28756 | 9 | 1.716 | 16757.6 |
994 | 2024-04-01 21:09:46 | flour | 1 | 28756 | 9 | 0.470 | 61183.0 |
993 | 2024-03-31 15:05:25 | flour | 1 | 28756 | 9 | 0.546 | 52666.7 |
992 | 2024-03-07 09:06:21 | flour | 3 | 83667 | 850 | 13.313 | 6284.6 |
991 | 2024-03-07 09:06:22 | flour | 2 | 53800 | 79 | 4.706 | 11432.2 |
990 | 2024-03-07 05:29:13 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
989 | 2024-03-05 18:55:19 | flour | 1 | 28756 | 9 | 2.236 | 12860.5 |
988 | 2024-03-01 11:44:47 | flour | 1 | 28756 | 9 | 0.500 | 57512.0 |
987 | 2024-02-27 10:18:14 | flour | 2 | 53800 | 79 | 1.610 | 33416.1 |
986 | 2024-02-27 10:17:02 | flour | 3 | 83667 | 850 | 7.846 | 10663.7 |
985 | 2024-02-25 22:26:20 | flour | 3 | 83667 | 850 | 7.656 | 10928.3 |
984 | 2024-02-25 22:26:20 | flour | 2 | 53800 | 79 | 3.563 | 15099.6 |
983 | 2024-02-25 19:18:57 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
982 | 2024-02-03 18:40:27 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
981 | 2024-01-29 00:00:59 | flour | 1 | 28756 | 9 | 0.513 | 56054.6 |
980 | 2024-01-26 07:51:57 | flour | 1 | 28756 | 9 | 0.983 | 29253.3 |
979 | 2023-12-24 03:35:17 | flour | 1 | 28756 | 9 | 0.440 | 65354.5 |
978 | 2023-12-19 19:18:46 | flour | 3 | 83667 | 850 | 3.420 | 24464.0 |
977 | 2023-12-19 19:18:38 | flour | 2 | 53800 | 79 | 1.326 | 40573.2 |
976 | 2023-12-08 08:25:31 | flour | 1 | 28756 | 9 | 0.483 | 59536.2 |
975 | 2023-12-08 08:25:30 | flour | 1 | 28756 | 9 | 0.530 | 54256.6 |
974 | 2023-12-08 00:15:50 | flour | 1 | 28756 | 9 | 0.500 | 57512.0 |
973 | 2023-12-08 00:15:49 | flour | 1 | 28756 | 9 | 0.546 | 52666.7 |
972 | 2023-12-06 00:49:56 | flour | 2 | 53800 | 79 | 1.483 | 36277.8 |
971 | 2023-12-03 03:56:42 | flour | 1 | 28756 | 9 | 0.750 | 38341.3 |
970 | 2023-11-29 18:37:15 | flour | 1 | 28756 | 9 | 0.500 | 57512.0 |
969 | 2023-11-29 06:03:50 | flour | 3 | 83667 | 850 | 3.686 | 22698.6 |
968 | 2023-11-23 02:51:47 | flour | 3 | 83667 | 850 | 3.440 | 24321.8 |
967 | 2023-11-23 02:51:48 | flour | 2 | 53800 | 79 | 1.486 | 36204.6 |
966 | 2023-11-12 04:09:22 | flour | 1 | 28756 | 9 | 0.466 | 61708.2 |
965 | 2023-11-09 12:57:04 | flour | 1 | 28756 | 9 | 0.423 | 67981.1 |
964 | 2023-10-28 03:30:14 | flour | 1 | 28756 | 9 | 0.470 | 61183.0 |
963 | 2023-10-27 14:47:32 | flour | 3 | 83667 | 850 | 3.250 | 25743.7 |
962 | 2023-10-20 22:01:50 | flour | 2 | 53800 | 79 | 3.563 | 15099.6 |
961 | 2023-10-19 20:21:03 | flour | 1 | 28756 | 9 | 0.516 | 55728.7 |
960 | 2023-10-18 02:15:33 | flour | 1 | 28756 | 9 | 0.440 | 65354.5 |
959 | 2023-10-18 02:04:25 | flour | 2 | 53800 | 79 | 2.080 | 25865.4 |
958 | 2023-10-16 20:36:50 | flour | 3 | 83667 | 850 | 4.296 | 19475.6 |
957 | 2023-10-16 04:09:20 | flour | 3 | 83667 | 850 | 4.466 | 18734.2 |
956 | 2023-10-16 04:09:18 | flour | 2 | 53800 | 79 | 3.640 | 14780.2 |
955 | 2023-10-12 08:24:49 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
954 | 2023-10-10 23:44:14 | flour | 1 | 28756 | 9 | 0.610 | 47141.0 |
953 | 2023-10-04 13:59:31 | flour | 1 | 28756 | 9 | 0.440 | 65354.5 |
952 | 2023-09-25 05:06:06 | flour | 3 | 83667 | 850 | 4.110 | 20356.9 |
951 | 2023-09-25 05:06:08 | flour | 2 | 53800 | 79 | 1.656 | 32487.9 |
950 | 2023-09-22 01:41:23 | flour | 1 | 28756 | 9 | 0.483 | 59536.2 |
949 | 2023-09-19 13:20:53 | flour | 1 | 28756 | 9 | 1.016 | 28303.1 |
948 | 2023-08-06 23:49:41 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
947 | 2023-08-06 20:41:37 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
946 | 2023-05-07 07:19:35 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
945 | 2023-04-29 10:25:47 | flour | 1 | 28756 | 9 | 0.420 | 68466.7 |
944 | 2023-02-28 18:33:23 | flour | 1 | 28756 | 9 | 0.420 | 68466.7 |
943 | 2023-01-17 03:12:23 | flour | 1 | 28756 | 9 | 0.423 | 67981.1 |
942 | 2022-12-25 00:42:01 | flour | 1 | 28756 | 9 | 0.500 | 57512.0 |
941 | 2022-09-25 20:45:21 | flour | 1 | 28756 | 9 | 0.423 | 67981.1 |
940 | 2022-09-12 22:18:48 | flour | 1 | 28756 | 9 | 0.423 | 67981.1 |
939 | 2022-08-15 01:15:55 | flour | 1 | 28756 | 9 | 0.423 | 67981.1 |
938 | 2022-07-16 02:23:11 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
937 | 2022-07-13 14:42:12 | flour | 1 | 28756 | 9 | 0.466 | 61708.2 |
936 | 2022-06-12 11:07:20 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
935 | 2022-03-13 18:03:45 | flour | 1 | 28756 | 9 | 0.486 | 59168.7 |
934 | 2022-03-11 14:10:11 | flour | 1 | 28756 | 9 | 0.500 | 57512.0 |
933 | 2022-02-25 09:02:39 | flour | 1 | 28756 | 9 | 0.530 | 54256.6 |
932 | 2022-01-05 19:42:50 | flour | 1 | 28756 | 9 | 0.466 | 61708.2 |
931 | 2021-12-11 11:47:53 | flour | 1 | 28756 | 9 | 0.483 | 59536.2 |
930 | 2021-11-17 05:25:12 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
929 | 2021-10-22 19:14:12 | flour | 1 | 28756 | 9 | 0.500 | 57512.0 |
928 | 2021-09-12 20:51:49 | flour | 1 | 28756 | 9 | 0.420 | 68466.7 |
927 | 2021-08-24 02:39:01 | flour | 1 | 28756 | 9 | 0.470 | 61183.0 |
926 | 2021-08-14 08:05:17 | flour | 1 | 28756 | 9 | 0.486 | 59168.7 |
925 | 2021-07-12 11:43:42 | flour | 2 | 53800 | 79 | 1.360 | 39558.8 |
924 | 2021-06-07 23:18:32 | flour | 1 | 28756 | 9 | 0.500 | 57512.0 |
923 | 2021-05-13 15:45:57 | flour | 1 | 28756 | 9 | 0.483 | 59536.2 |
922 | 2021-05-01 03:42:54 | flour | 2 | 53800 | 79 | 1.423 | 37807.4 |
921 | 2021-03-16 20:06:59 | flour | 1 | 28756 | 9 | 0.420 | 68466.7 |
920 | 2021-02-21 18:27:34 | flour | 1 | 28756 | 9 | 0.466 | 61708.2 |
919 | 2021-02-20 01:30:13 | flour | 1 | 28756 | 9 | 0.530 | 54256.6 |
918 | 2021-02-19 18:53:56 | flour | 1 | 28756 | 9 | 0.513 | 56054.6 |
917 | 2021-02-10 00:52:06 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
916 | 2021-02-04 14:24:03 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
915 | 2021-02-01 04:02:07 | flour | 3 | 83667 | 850 | 3.233 | 25879.1 |
914 | 2021-01-13 23:40:14 | flour | 2 | 53800 | 79 | 1.530 | 35163.4 |
913 | 2021-01-04 13:13:44 | flour | 3 | 83667 | 850 | 3.206 | 26097.0 |
912 | 2020-12-26 21:06:18 | flour | 2 | 53800 | 79 | 1.343 | 40059.6 |
911 | 2020-12-26 16:07:41 | flour | 2 | 53800 | 79 | 1.530 | 35163.4 |
910 | 2020-12-01 11:40:23 | flour | 1 | 28756 | 9 | 0.436 | 65954.1 |
909 | 2020-11-03 06:15:31 | flour | 1 | 28756 | 9 | 0.453 | 63479.0 |
908 | 2020-10-30 17:36:55 | flour | 3 | 83667 | 850 | 3.673 | 22778.9 |
907 | 2020-10-28 22:05:08 | flour | 3 | 83667 | 850 | 3.500 | 23904.9 |
906 | 2020-10-26 10:47:27 | flour | 2 | 53800 | 79 | 1.466 | 36698.5 |
905 | 2020-10-19 13:18:16 | flour | 3 | 83667 | 850 | 3.783 | 22116.6 |
904 | 2020-10-01 21:49:26 | flour | 1 | 28756 | 9 | 0.423 | 67981.1 |