History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"flies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
969 | 2024-04-27 12:42:01 | flies | 1 | 28756 | 17 | 0.640 | 44931.3 |
968 | 2024-04-25 12:14:40 | flies | 1 | 28756 | 17 | 1.783 | 16127.9 |
967 | 2024-04-24 17:58:00 | flies | 1 | 28756 | 17 | 0.546 | 52666.7 |
966 | 2024-04-24 15:44:30 | flies | 1 | 28756 | 17 | 0.936 | 30722.2 |
965 | 2024-04-24 03:49:19 | flies | 1 | 28756 | 17 | 1.470 | 19561.9 |
964 | 2024-04-20 21:25:29 | flies | 1 | 28756 | 17 | 1.233 | 23322.0 |
963 | 2024-04-03 06:28:56 | flies | 1 | 28756 | 17 | 1.373 | 20943.9 |
962 | 2024-03-31 11:17:19 | flies | 2 | 53800 | 266 | 3.470 | 15504.3 |
961 | 2024-03-31 11:17:12 | flies | 1 | 28756 | 17 | 0.516 | 55728.7 |
960 | 2024-03-31 11:16:55 | flies | 2 | 53800 | 266 | 3.576 | 15044.7 |
959 | 2024-03-31 10:06:28 | flies | 2 | 53800 | 266 | 1.876 | 28678.0 |
958 | 2024-03-31 08:28:39 | flies | 1 | 28756 | 17 | 1.016 | 28303.1 |
957 | 2024-03-09 14:16:30 | flies | 1 | 28756 | 17 | 0.466 | 61708.2 |
956 | 2024-03-04 06:42:48 | flies | 2 | 53800 | 266 | 3.376 | 15936.0 |
955 | 2024-03-04 02:27:03 | flies | 1 | 28756 | 17 | 0.513 | 56054.6 |
954 | 2024-03-03 09:56:15 | flies | 2 | 53800 | 266 | 1.343 | 40059.6 |
953 | 2024-03-01 07:12:40 | flies | 1 | 28756 | 17 | 0.486 | 59168.7 |
952 | 2024-02-25 17:42:40 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
951 | 2024-02-03 02:46:55 | flies | 1 | 28756 | 17 | 0.516 | 55728.7 |
950 | 2024-01-28 21:54:15 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
949 | 2024-01-26 11:15:09 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |
948 | 2024-01-24 04:33:23 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
947 | 2024-01-06 10:02:44 | flies | 2 | 53800 | 266 | 1.360 | 39558.8 |
946 | 2024-01-02 08:39:40 | flies | 1 | 28756 | 17 | 0.453 | 63479.0 |
945 | 2023-12-30 11:52:44 | flies | 2 | 53800 | 266 | 1.356 | 39675.5 |
944 | 2023-12-29 10:25:03 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
943 | 2023-12-12 01:49:42 | flies | 1 | 28756 | 17 | 0.440 | 65354.5 |
942 | 2023-12-07 19:52:36 | flies | 1 | 28756 | 17 | 0.500 | 57512.0 |
941 | 2023-12-07 19:52:35 | flies | 1 | 28756 | 17 | 0.486 | 59168.7 |
940 | 2023-12-07 00:04:51 | flies | 2 | 53800 | 266 | 1.563 | 34421.0 |
939 | 2023-12-07 00:04:49 | flies | 2 | 53800 | 266 | 1.656 | 32487.9 |
938 | 2023-12-06 21:37:00 | flies | 2 | 53800 | 266 | 1.593 | 33772.8 |
937 | 2023-12-03 20:22:19 | flies | 2 | 53800 | 266 | 1.343 | 40059.6 |
936 | 2023-12-03 20:22:17 | flies | 2 | 53800 | 266 | 1.576 | 34137.1 |
935 | 2023-12-03 18:18:11 | flies | 1 | 28756 | 17 | 0.423 | 67981.1 |
934 | 2023-12-03 18:18:10 | flies | 1 | 28756 | 17 | 0.500 | 57512.0 |
933 | 2023-11-24 12:42:39 | flies | 2 | 53800 | 266 | 1.343 | 40059.6 |
932 | 2023-11-18 05:30:19 | flies | 1 | 28756 | 17 | 0.423 | 67981.1 |
931 | 2023-11-18 00:24:34 | flies | 1 | 28756 | 17 | 0.486 | 59168.7 |
930 | 2023-11-15 08:49:47 | flies | 1 | 28756 | 17 | 0.986 | 29164.3 |
929 | 2023-11-15 08:31:34 | flies | 2 | 53800 | 266 | 1.326 | 40573.2 |
928 | 2023-11-13 14:14:03 | flies | 1 | 28756 | 17 | 0.423 | 67981.1 |
927 | 2023-10-28 04:38:22 | flies | 1 | 28756 | 17 | 0.466 | 61708.2 |
926 | 2023-10-24 01:39:14 | flies | 1 | 28756 | 17 | 0.500 | 57512.0 |
925 | 2023-10-21 10:29:32 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
924 | 2023-10-18 15:55:05 | flies | 1 | 28756 | 17 | 0.440 | 65354.5 |
923 | 2023-10-11 13:04:10 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
922 | 2023-10-05 02:53:15 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
921 | 2023-09-22 20:46:28 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |
920 | 2023-09-16 14:57:52 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |
919 | 2023-09-12 06:52:39 | flies | 1 | 28756 | 17 | 0.470 | 61183.0 |
918 | 2023-08-23 23:51:12 | flies | 2 | 53800 | 266 | 1.376 | 39098.8 |
917 | 2023-08-20 06:51:12 | flies | 1 | 28756 | 17 | 0.423 | 67981.1 |
916 | 2023-06-12 14:30:54 | flies | 1 | 28756 | 17 | 0.466 | 61708.2 |
915 | 2023-05-19 19:43:52 | flies | 1 | 28756 | 17 | 0.516 | 55728.7 |
914 | 2023-05-10 08:38:49 | flies | 2 | 53800 | 266 | 1.343 | 40059.6 |
913 | 2023-03-15 13:57:15 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
912 | 2023-03-10 04:36:20 | flies | 1 | 28756 | 17 | 0.380 | 75673.7 |
911 | 2023-02-15 08:39:27 | flies | 2 | 53800 | 266 | 1.483 | 36277.8 |
910 | 2023-01-04 05:34:45 | flies | 1 | 28756 | 17 | 0.486 | 59168.7 |
909 | 2022-12-05 06:27:49 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |
908 | 2022-12-01 22:35:09 | flies | 1 | 28756 | 17 | 0.440 | 65354.5 |
907 | 2022-11-25 05:21:32 | flies | 2 | 53800 | 266 | 1.330 | 40451.1 |
906 | 2022-11-22 23:48:27 | flies | 2 | 53800 | 266 | 1.360 | 39558.8 |
905 | 2022-09-27 18:47:38 | flies | 2 | 53800 | 266 | 1.390 | 38705.0 |
904 | 2022-09-25 08:39:31 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |
903 | 2022-09-02 18:38:28 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
902 | 2022-08-31 21:43:30 | flies | 2 | 53800 | 266 | 1.610 | 33416.1 |
901 | 2022-08-28 14:29:12 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
900 | 2022-08-25 19:34:38 | flies | 1 | 28756 | 17 | 0.466 | 61708.2 |
899 | 2022-08-09 19:53:06 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
898 | 2022-06-29 03:15:48 | flies | 1 | 28756 | 17 | 0.593 | 48492.4 |
897 | 2022-06-28 03:15:59 | flies | 1 | 28756 | 17 | 0.516 | 55728.7 |
896 | 2022-06-27 03:57:53 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
895 | 2022-06-26 11:04:12 | flies | 1 | 28756 | 17 | 0.500 | 57512.0 |
894 | 2022-06-25 04:33:26 | flies | 1 | 28756 | 17 | 0.500 | 57512.0 |
893 | 2022-06-24 06:05:51 | flies | 1 | 28756 | 17 | 0.423 | 67981.1 |
892 | 2022-06-23 03:41:47 | flies | 1 | 28756 | 17 | 0.453 | 63479.0 |
891 | 2022-06-22 02:55:30 | flies | 1 | 28756 | 17 | 0.453 | 63479.0 |
890 | 2022-06-21 06:23:35 | flies | 1 | 28756 | 17 | 0.533 | 53951.2 |
889 | 2022-06-20 21:21:32 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |
888 | 2022-06-19 03:50:50 | flies | 1 | 28756 | 17 | 0.470 | 61183.0 |
887 | 2022-06-18 11:26:31 | flies | 1 | 28756 | 17 | 0.456 | 63061.4 |
886 | 2022-06-17 11:38:13 | flies | 1 | 28756 | 17 | 0.440 | 65354.5 |
885 | 2022-06-15 12:30:37 | flies | 1 | 28756 | 17 | 0.513 | 56054.6 |
884 | 2022-06-13 21:12:04 | flies | 1 | 28756 | 17 | 0.466 | 61708.2 |
883 | 2022-05-22 20:27:12 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |
882 | 2022-05-19 10:53:33 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
881 | 2022-05-19 05:38:19 | flies | 1 | 28756 | 17 | 0.500 | 57512.0 |
880 | 2022-05-18 14:41:59 | flies | 1 | 28756 | 17 | 0.483 | 59536.2 |
879 | 2022-05-18 01:41:32 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |
878 | 2022-05-17 14:52:46 | flies | 1 | 28756 | 17 | 0.530 | 54256.6 |
877 | 2022-05-16 12:51:28 | flies | 1 | 28756 | 17 | 0.470 | 61183.0 |
876 | 2022-05-15 23:00:37 | flies | 1 | 28756 | 17 | 0.423 | 67981.1 |
875 | 2022-05-15 04:16:54 | flies | 1 | 28756 | 17 | 0.470 | 61183.0 |
874 | 2022-05-14 05:10:21 | flies | 1 | 28756 | 17 | 0.423 | 67981.1 |
873 | 2022-05-13 19:17:37 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |
872 | 2022-05-13 09:39:29 | flies | 1 | 28756 | 17 | 0.610 | 47141.0 |
871 | 2022-05-12 23:39:00 | flies | 1 | 28756 | 17 | 0.500 | 57512.0 |
870 | 2022-05-08 20:35:40 | flies | 1 | 28756 | 17 | 0.436 | 65954.1 |