History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spare"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
999 | 2024-04-03 06:34:45 | spare | 2 | 53800 | 265 | 5.640 | 9539.0 |
998 | 2024-04-03 06:15:10 | spare | 1 | 28756 | 23 | 1.690 | 17015.4 |
997 | 2024-03-29 04:31:04 | spare | 2 | 53800 | 265 | 5.236 | 10275.0 |
996 | 2024-03-29 04:30:57 | spare | 1 | 28756 | 23 | 1.140 | 25224.6 |
995 | 2024-03-29 04:30:49 | spare | 2 | 53800 | 265 | 1.720 | 31279.1 |
994 | 2024-03-29 04:30:31 | spare | 1 | 28756 | 23 | 0.516 | 55728.7 |
993 | 2024-03-20 18:18:54 | spare | 1 | 28756 | 23 | 0.550 | 52283.6 |
992 | 2024-03-04 01:56:51 | spare | 1 | 28756 | 23 | 0.450 | 63902.2 |
991 | 2024-02-28 01:11:54 | spare | 1 | 28756 | 23 | 0.500 | 57512.0 |
990 | 2024-02-22 04:55:12 | spare | 2 | 53800 | 265 | 3.563 | 15099.6 |
989 | 2024-02-21 17:27:41 | spare | 2 | 53800 | 265 | 3.376 | 15936.0 |
988 | 2024-02-19 18:43:12 | spare | 2 | 53800 | 265 | 3.716 | 14477.9 |
987 | 2024-02-19 12:50:14 | spare | 1 | 28756 | 23 | 0.453 | 63479.0 |
986 | 2024-02-03 03:48:51 | spare | 1 | 28756 | 23 | 0.516 | 55728.7 |
985 | 2024-01-28 22:48:41 | spare | 1 | 28756 | 23 | 0.500 | 57512.0 |
984 | 2024-01-19 15:13:30 | spare | 1 | 28756 | 23 | 0.643 | 44721.6 |
983 | 2024-01-19 14:42:48 | spare | 1 | 28756 | 23 | 0.450 | 63902.2 |
982 | 2024-01-15 13:36:23 | spare | 2 | 53800 | 265 | 1.563 | 34421.0 |
981 | 2024-01-12 17:21:14 | spare | 1 | 28756 | 23 | 0.656 | 43835.4 |
980 | 2024-01-11 03:36:00 | spare | 2 | 53800 | 265 | 1.453 | 37026.8 |
979 | 2023-12-15 03:50:24 | spare | 2 | 53800 | 265 | 1.593 | 33772.8 |
978 | 2023-12-14 03:39:33 | spare | 2 | 53800 | 265 | 1.750 | 30742.9 |
977 | 2023-12-04 16:30:41 | spare | 1 | 28756 | 23 | 0.500 | 57512.0 |
976 | 2023-11-29 11:05:09 | spare | 2 | 53800 | 265 | 1.406 | 38264.6 |
975 | 2023-11-18 07:58:42 | spare | 1 | 28756 | 23 | 0.453 | 63479.0 |
974 | 2023-11-11 17:28:18 | spare | 1 | 28756 | 23 | 0.453 | 63479.0 |
973 | 2023-11-07 22:58:47 | spare | 1 | 28756 | 23 | 0.453 | 63479.0 |
972 | 2023-11-01 16:10:48 | spare | 1 | 28756 | 23 | 0.516 | 55728.7 |
971 | 2023-10-28 01:16:20 | spare | 2 | 53800 | 265 | 1.453 | 37026.8 |
970 | 2023-10-27 15:12:52 | spare | 2 | 53800 | 265 | 1.373 | 39184.3 |
969 | 2023-10-21 13:43:40 | spare | 1 | 28756 | 23 | 0.466 | 61708.2 |
968 | 2023-10-19 20:33:36 | spare | 2 | 53800 | 265 | 1.360 | 39558.8 |
967 | 2023-10-17 17:10:49 | spare | 1 | 28756 | 23 | 0.453 | 63479.0 |
966 | 2023-10-11 09:31:53 | spare | 1 | 28756 | 23 | 1.016 | 28303.1 |
965 | 2023-10-11 06:54:54 | spare | 1 | 28756 | 23 | 0.516 | 55728.7 |
964 | 2023-10-05 17:27:29 | spare | 1 | 28756 | 23 | 0.483 | 59536.2 |
963 | 2023-10-04 07:34:54 | spare | 2 | 53800 | 265 | 1.783 | 30173.9 |
962 | 2023-09-23 16:20:41 | spare | 1 | 28756 | 23 | 0.453 | 63479.0 |
961 | 2023-09-14 07:41:17 | spare | 1 | 28756 | 23 | 0.576 | 49923.6 |
960 | 2023-09-05 11:25:56 | spare | 2 | 53800 | 265 | 1.420 | 37887.3 |
959 | 2023-09-04 22:39:59 | spare | 2 | 53800 | 265 | 1.453 | 37026.8 |
958 | 2023-09-03 08:09:01 | spare | 2 | 53800 | 265 | 1.563 | 34421.0 |
957 | 2023-09-02 06:41:55 | spare | 2 | 53800 | 265 | 1.626 | 33087.3 |
956 | 2023-08-30 03:34:13 | spare | 2 | 53800 | 265 | 1.576 | 34137.1 |
955 | 2023-08-28 22:31:44 | spare | 2 | 53800 | 265 | 1.483 | 36277.8 |
954 | 2023-08-28 01:44:11 | spare | 1 | 28756 | 23 | 0.436 | 65954.1 |
953 | 2023-08-13 21:43:52 | spare | 2 | 53800 | 265 | 1.530 | 35163.4 |
952 | 2023-07-30 16:48:03 | spare | 2 | 53800 | 265 | 1.453 | 37026.8 |
951 | 2023-07-07 22:20:50 | spare | 2 | 53800 | 265 | 1.373 | 39184.3 |
950 | 2023-06-14 11:12:32 | spare | 1 | 28756 | 23 | 0.750 | 38341.3 |
949 | 2023-05-31 14:19:23 | spare | 1 | 28756 | 23 | 0.440 | 65354.5 |
948 | 2023-04-10 01:49:11 | spare | 2 | 53800 | 265 | 1.343 | 40059.6 |
947 | 2023-03-25 10:03:01 | spare | 1 | 28756 | 23 | 0.516 | 55728.7 |
946 | 2023-02-23 03:10:58 | spare | 1 | 28756 | 23 | 1.000 | 28756.0 |
945 | 2023-01-21 09:01:33 | spare | 2 | 53800 | 265 | 1.516 | 35488.1 |
944 | 2023-01-17 08:31:25 | spare | 1 | 28756 | 23 | 0.483 | 59536.2 |
943 | 2023-01-13 23:35:22 | spare | 2 | 53800 | 265 | 1.546 | 34799.5 |
942 | 2023-01-10 20:25:24 | spare | 1 | 28756 | 23 | 0.436 | 65954.1 |
941 | 2022-10-26 11:24:00 | spare | 1 | 28756 | 23 | 0.560 | 51350.0 |
940 | 2022-10-17 05:27:26 | spare | 2 | 53800 | 265 | 1.360 | 39558.8 |
939 | 2022-10-14 13:14:40 | spare | 1 | 28756 | 23 | 0.436 | 65954.1 |
938 | 2022-08-15 18:29:15 | spare | 2 | 53800 | 265 | 1.546 | 34799.5 |
937 | 2022-08-07 19:31:27 | spare | 1 | 28756 | 23 | 0.436 | 65954.1 |
936 | 2022-08-06 10:48:42 | spare | 1 | 28756 | 23 | 0.436 | 65954.1 |
935 | 2022-08-05 20:34:05 | spare | 2 | 53800 | 265 | 1.546 | 34799.5 |
934 | 2022-07-29 02:44:17 | spare | 1 | 28756 | 23 | 0.453 | 63479.0 |
933 | 2022-07-19 10:22:56 | spare | 2 | 53800 | 265 | 1.373 | 39184.3 |
932 | 2022-07-17 23:28:07 | spare | 1 | 28756 | 23 | 0.500 | 57512.0 |
931 | 2022-07-03 03:26:46 | spare | 1 | 28756 | 23 | 0.453 | 63479.0 |
930 | 2022-07-03 02:05:30 | spare | 1 | 28756 | 23 | 0.436 | 65954.1 |
929 | 2022-06-25 10:17:37 | spare | 1 | 28756 | 23 | 0.483 | 59536.2 |
928 | 2022-06-08 23:18:54 | spare | 1 | 28756 | 23 | 0.516 | 55728.7 |
927 | 2022-06-04 22:00:39 | spare | 1 | 28756 | 23 | 0.453 | 63479.0 |
926 | 2022-05-26 22:24:15 | spare | 2 | 53800 | 265 | 1.543 | 34867.1 |
925 | 2022-05-18 15:17:32 | spare | 2 | 53800 | 265 | 1.423 | 37807.4 |
924 | 2022-05-18 09:53:50 | spare | 2 | 53800 | 265 | 1.470 | 36598.6 |
923 | 2022-05-17 15:17:42 | spare | 2 | 53800 | 265 | 1.810 | 29723.8 |
922 | 2022-05-16 19:35:04 | spare | 2 | 53800 | 265 | 1.830 | 29398.9 |
921 | 2022-05-16 00:50:38 | spare | 2 | 53800 | 265 | 1.390 | 38705.0 |
920 | 2022-05-14 17:49:30 | spare | 2 | 53800 | 265 | 1.466 | 36698.5 |
919 | 2022-05-13 23:56:55 | spare | 2 | 53800 | 265 | 1.360 | 39558.8 |
918 | 2022-05-13 08:44:58 | spare | 2 | 53800 | 265 | 1.563 | 34421.0 |
917 | 2022-05-02 05:27:06 | spare | 2 | 53800 | 265 | 1.423 | 37807.4 |
916 | 2022-05-01 22:58:58 | spare | 1 | 28756 | 23 | 0.470 | 61183.0 |
915 | 2022-05-01 12:05:36 | spare | 2 | 53800 | 265 | 1.360 | 39558.8 |
914 | 2022-04-30 22:58:02 | spare | 1 | 28756 | 23 | 0.516 | 55728.7 |
913 | 2022-04-29 19:03:41 | spare | 1 | 28756 | 23 | 0.440 | 65354.5 |
912 | 2022-04-28 23:04:18 | spare | 1 | 28756 | 23 | 0.626 | 45936.1 |
911 | 2022-04-12 15:10:34 | spare | 2 | 53800 | 265 | 1.843 | 29191.5 |
910 | 2022-04-12 03:02:54 | spare | 2 | 53800 | 265 | 1.796 | 29955.5 |
909 | 2022-04-11 14:12:51 | spare | 2 | 53800 | 265 | 1.843 | 29191.5 |
908 | 2022-04-11 01:57:59 | spare | 2 | 53800 | 265 | 1.546 | 34799.5 |
907 | 2022-04-10 09:01:01 | spare | 2 | 53800 | 265 | 1.576 | 34137.1 |
906 | 2022-04-09 20:32:20 | spare | 2 | 53800 | 265 | 1.483 | 36277.8 |
905 | 2022-04-09 05:11:12 | spare | 2 | 53800 | 265 | 1.440 | 37361.1 |
904 | 2022-04-08 10:56:31 | spare | 2 | 53800 | 265 | 2.296 | 23432.1 |
903 | 2022-04-08 10:53:57 | spare | 2 | 53800 | 265 | 1.890 | 28465.6 |
902 | 2022-04-08 09:48:31 | spare | 2 | 53800 | 265 | 1.876 | 28678.0 |
901 | 2022-04-07 20:34:14 | spare | 2 | 53800 | 265 | 2.016 | 26686.5 |
900 | 2022-04-07 20:31:52 | spare | 2 | 53800 | 265 | 2.126 | 25305.7 |