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 |
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 |
886 | 2022-02-18 20:07:44 | canon | 2 | 53800 | 126 | 1.703 | 31591.3 |
885 | 2022-02-18 10:33:31 | canon | 2 | 53800 | 126 | 3.110 | 17299.0 |
884 | 2022-02-17 18:26:46 | canon | 2 | 53800 | 126 | 1.876 | 28678.0 |
883 | 2022-02-17 00:37:16 | canon | 2 | 53800 | 126 | 1.436 | 37465.2 |
882 | 2022-02-16 08:38:28 | canon | 2 | 53800 | 126 | 1.580 | 34050.6 |
881 | 2022-02-15 14:52:56 | canon | 2 | 53800 | 126 | 1.596 | 33709.3 |
880 | 2022-02-14 18:26:14 | canon | 2 | 53800 | 126 | 1.813 | 29674.6 |
879 | 2022-02-13 23:28:26 | canon | 2 | 53800 | 126 | 1.686 | 31909.8 |
878 | 2022-02-10 23:29:00 | canon | 2 | 53800 | 126 | 1.626 | 33087.3 |
877 | 2022-02-10 06:10:12 | canon | 2 | 53800 | 126 | 1.610 | 33416.1 |
876 | 2022-02-09 17:28:00 | canon | 2 | 53800 | 126 | 1.546 | 34799.5 |
875 | 2022-02-08 22:22:20 | canon | 2 | 53800 | 126 | 1.470 | 36598.6 |
874 | 2022-02-08 17:34:32 | canon | 1 | 28756 | 10 | 0.516 | 55728.7 |
873 | 2022-02-08 07:37:58 | canon | 2 | 53800 | 126 | 1.453 | 37026.8 |