History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canon"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
986 | 2024-05-02 03:48:28 | canon | 1 | 28756 | 10 | 0.516 | 55728.7 |
985 | 2024-04-30 17:54:17 | canon | 1 | 28756 | 10 | 0.563 | 51076.4 |
984 | 2024-04-27 22:54:51 | canon | 1 | 28756 | 10 | 2.906 | 9895.4 |
983 | 2024-04-27 10:32:01 | canon | 2 | 53800 | 126 | 2.813 | 19125.5 |
982 | 2024-04-22 11:48:46 | canon | 1 | 28756 | 10 | 1.500 | 19170.7 |
981 | 2024-04-20 18:53:02 | canon | 1 | 28756 | 10 | 1.860 | 15460.2 |
980 | 2024-04-17 11:37:44 | canon | 1 | 28756 | 10 | 0.466 | 61708.2 |
979 | 2024-04-08 14:12:36 | canon | 1 | 28756 | 10 | 0.533 | 53951.2 |
978 | 2024-04-03 03:45:49 | canon | 1 | 28756 | 10 | 0.596 | 48248.3 |
977 | 2024-03-31 08:58:51 | canon | 2 | 53800 | 126 | 2.250 | 23911.1 |
976 | 2024-03-31 07:59:16 | canon | 1 | 28756 | 10 | 0.563 | 51076.4 |
975 | 2024-03-28 19:45:19 | canon | 2 | 53800 | 126 | 1.906 | 28226.7 |
974 | 2024-03-28 19:31:03 | canon | 1 | 28756 | 10 | 0.530 | 54256.6 |
973 | 2024-03-28 13:37:09 | canon | 1 | 28756 | 10 | 0.516 | 55728.7 |
972 | 2024-03-20 07:40:13 | canon | 1 | 28756 | 10 | 0.533 | 53951.2 |
971 | 2024-03-20 07:40:01 | canon | 2 | 53800 | 126 | 4.970 | 10824.9 |
970 | 2024-03-20 07:39:55 | canon | 1 | 28756 | 10 | 1.156 | 24875.4 |
969 | 2024-03-12 01:57:40 | canon | 1 | 28756 | 10 | 1.736 | 16564.5 |
968 | 2024-03-05 20:56:41 | canon | 1 | 28756 | 10 | 0.733 | 39230.6 |
967 | 2024-03-04 15:42:19 | canon | 1 | 28756 | 10 | 1.156 | 24875.4 |
966 | 2024-03-03 20:58:16 | canon | 1 | 28756 | 10 | 1.013 | 28387.0 |
965 | 2024-02-26 07:51:42 | canon | 2 | 53800 | 126 | 1.560 | 34487.2 |
964 | 2024-02-26 07:51:36 | canon | 1 | 28756 | 10 | 0.470 | 61183.0 |
963 | 2024-02-19 02:10:01 | canon | 1 | 28756 | 10 | 0.576 | 49923.6 |
962 | 2024-02-02 19:10:15 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
961 | 2024-01-30 07:44:06 | canon | 1 | 28756 | 10 | 0.550 | 52283.6 |
960 | 2024-01-28 22:00:19 | canon | 1 | 28756 | 10 | 0.483 | 59536.2 |
959 | 2024-01-27 03:03:09 | canon | 1 | 28756 | 10 | 0.516 | 55728.7 |
958 | 2024-01-19 05:47:27 | canon | 1 | 28756 | 10 | 0.530 | 54256.6 |
957 | 2024-01-06 12:45:32 | canon | 1 | 28756 | 10 | 0.516 | 55728.7 |
956 | 2023-12-31 16:15:12 | canon | 2 | 53800 | 126 | 1.483 | 36277.8 |
955 | 2023-12-30 09:24:27 | canon | 1 | 28756 | 10 | 0.450 | 63902.2 |
954 | 2023-12-18 22:35:14 | canon | 2 | 53800 | 126 | 1.453 | 37026.8 |
953 | 2023-12-15 22:57:59 | canon | 2 | 53800 | 126 | 1.453 | 37026.8 |
952 | 2023-12-14 17:20:11 | canon | 1 | 28756 | 10 | 0.453 | 63479.0 |
951 | 2023-12-14 09:04:48 | canon | 2 | 53800 | 126 | 1.423 | 37807.4 |
950 | 2023-12-03 13:23:45 | canon | 2 | 53800 | 126 | 1.690 | 31834.3 |
949 | 2023-12-03 13:23:43 | canon | 2 | 53800 | 126 | 1.670 | 32215.6 |
948 | 2023-12-03 07:07:42 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
947 | 2023-12-03 07:07:41 | canon | 1 | 28756 | 10 | 0.516 | 55728.7 |
946 | 2023-12-02 12:47:57 | canon | 2 | 53800 | 126 | 1.453 | 37026.8 |
945 | 2023-11-13 11:50:30 | canon | 1 | 28756 | 10 | 0.513 | 56054.6 |
944 | 2023-11-12 01:37:57 | canon | 1 | 28756 | 10 | 0.450 | 63902.2 |
943 | 2023-11-11 21:31:49 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
942 | 2023-11-01 21:30:39 | canon | 1 | 28756 | 10 | 0.516 | 55728.7 |
941 | 2023-10-29 00:58:13 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
940 | 2023-10-19 18:04:35 | canon | 1 | 28756 | 10 | 1.096 | 26237.2 |
939 | 2023-10-18 00:24:56 | canon | 1 | 28756 | 10 | 0.563 | 51076.4 |
938 | 2023-10-11 20:23:06 | canon | 1 | 28756 | 10 | 0.906 | 31739.5 |
937 | 2023-10-05 19:14:47 | canon | 1 | 28756 | 10 | 0.453 | 63479.0 |
936 | 2023-09-24 21:02:21 | canon | 1 | 28756 | 10 | 0.453 | 63479.0 |
935 | 2023-09-20 20:53:40 | canon | 1 | 28756 | 10 | 0.440 | 65354.5 |
934 | 2023-09-14 11:16:19 | canon | 1 | 28756 | 10 | 0.453 | 63479.0 |
933 | 2023-08-30 21:34:11 | canon | 2 | 53800 | 126 | 1.656 | 32487.9 |
932 | 2023-08-14 01:43:02 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
931 | 2023-08-04 14:31:34 | canon | 1 | 28756 | 10 | 0.436 | 65954.1 |
930 | 2023-07-08 21:53:01 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
929 | 2023-06-30 15:26:06 | canon | 2 | 53800 | 126 | 1.436 | 37465.2 |
928 | 2023-06-16 20:01:48 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
927 | 2023-05-18 06:42:15 | canon | 2 | 53800 | 126 | 1.610 | 33416.1 |
926 | 2023-05-16 05:10:53 | canon | 2 | 53800 | 126 | 1.373 | 39184.3 |
925 | 2023-05-15 21:48:05 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
924 | 2023-04-22 02:47:11 | canon | 1 | 28756 | 10 | 0.453 | 63479.0 |
923 | 2023-03-31 12:32:14 | canon | 2 | 53800 | 126 | 1.516 | 35488.1 |
922 | 2023-03-26 23:31:57 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
921 | 2023-03-21 07:52:15 | canon | 1 | 28756 | 10 | 0.986 | 29164.3 |
920 | 2023-03-13 23:23:31 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
919 | 2023-03-11 02:49:38 | canon | 1 | 28756 | 10 | 0.453 | 63479.0 |
918 | 2023-03-07 20:11:25 | canon | 1 | 28756 | 10 | 0.436 | 65954.1 |
917 | 2023-02-22 03:52:33 | canon | 2 | 53800 | 126 | 2.780 | 19352.5 |
916 | 2023-01-01 04:16:46 | canon | 1 | 28756 | 10 | 0.500 | 57512.0 |
915 | 2022-12-02 20:34:57 | canon | 1 | 28756 | 10 | 0.436 | 65954.1 |
914 | 2022-12-02 16:17:55 | canon | 2 | 53800 | 126 | 1.423 | 37807.4 |
913 | 2022-11-29 13:44:12 | canon | 1 | 28756 | 10 | 0.453 | 63479.0 |
912 | 2022-09-19 05:21:27 | canon | 1 | 28756 | 10 | 0.453 | 63479.0 |
911 | 2022-08-22 13:43:29 | canon | 1 | 28756 | 10 | 0.436 | 65954.1 |
910 | 2022-05-13 09:43:16 | canon | 1 | 28756 | 10 | 0.610 | 47141.0 |
909 | 2022-04-30 07:14:15 | canon | 1 | 28756 | 10 | 0.440 | 65354.5 |
908 | 2022-04-17 05:14:33 | canon | 2 | 53800 | 126 | 1.406 | 38264.6 |
907 | 2022-03-30 20:19:14 | canon | 2 | 53800 | 126 | 1.733 | 31044.4 |
906 | 2022-03-30 08:24:46 | canon | 2 | 53800 | 126 | 1.826 | 29463.3 |
905 | 2022-03-29 11:42:49 | canon | 2 | 53800 | 126 | 1.826 | 29463.3 |
904 | 2022-03-29 04:40:48 | canon | 2 | 53800 | 126 | 1.860 | 28924.7 |
903 | 2022-03-28 06:14:21 | canon | 2 | 53800 | 126 | 1.670 | 32215.6 |
902 | 2022-03-27 14:14:00 | canon | 2 | 53800 | 126 | 1.656 | 32487.9 |
901 | 2022-03-27 01:20:17 | canon | 2 | 53800 | 126 | 1.593 | 33772.8 |
900 | 2022-03-26 02:23:16 | canon | 2 | 53800 | 126 | 1.440 | 37361.1 |
899 | 2022-03-22 06:00:16 | canon | 2 | 53800 | 126 | 1.440 | 37361.1 |
898 | 2022-03-21 17:38:56 | canon | 2 | 53800 | 126 | 2.346 | 22932.7 |
897 | 2022-03-20 19:02:07 | canon | 2 | 53800 | 126 | 1.406 | 38264.6 |
896 | 2022-02-25 04:31:06 | canon | 2 | 53800 | 126 | 2.046 | 26295.2 |
895 | 2022-02-24 10:53:40 | canon | 2 | 53800 | 126 | 1.906 | 28226.7 |
894 | 2022-02-23 19:46:43 | canon | 2 | 53800 | 126 | 1.750 | 30742.9 |
893 | 2022-02-23 00:40:16 | canon | 2 | 53800 | 126 | 1.453 | 37026.8 |
892 | 2022-02-22 05:23:44 | canon | 2 | 53800 | 126 | 1.593 | 33772.8 |
891 | 2022-02-21 09:01:10 | canon | 2 | 53800 | 126 | 1.703 | 31591.3 |
890 | 2022-02-20 20:28:07 | canon | 2 | 53800 | 126 | 1.703 | 31591.3 |
889 | 2022-02-20 09:21:14 | canon | 2 | 53800 | 126 | 1.690 | 31834.3 |
888 | 2022-02-19 18:57:42 | canon | 2 | 53800 | 126 | 1.563 | 34421.0 |
887 | 2022-02-19 06:20:00 | canon | 2 | 53800 | 126 | 1.703 | 31591.3 |