History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"watch"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
984 | 2024-05-09 18:48:58 | watch | 1 | 28756 | 11 | 0.813 | 35370.2 |
983 | 2024-05-06 11:23:35 | watch | 1 | 28756 | 11 | 1.080 | 26625.9 |
982 | 2024-04-30 08:12:14 | watch | 1 | 28756 | 11 | 0.500 | 57512.0 |
981 | 2024-04-29 13:50:17 | watch | 1 | 28756 | 11 | 0.500 | 57512.0 |
980 | 2024-04-29 05:03:13 | watch | 2 | 53800 | 87 | 2.406 | 22360.8 |
979 | 2024-04-29 05:02:50 | watch | 3 | 83667 | 796 | 4.173 | 20049.6 |
978 | 2024-04-28 19:26:42 | watch | 2 | 53800 | 87 | 1.656 | 32487.9 |
977 | 2024-04-28 19:25:43 | watch | 3 | 83667 | 796 | 4.126 | 20278.0 |
976 | 2024-04-28 15:09:12 | watch | 2 | 53800 | 87 | 1.966 | 27365.2 |
975 | 2024-04-28 15:08:31 | watch | 3 | 83667 | 796 | 3.953 | 21165.4 |
974 | 2024-04-28 00:30:47 | watch | 3 | 83667 | 796 | 13.033 | 6419.6 |
973 | 2024-04-28 00:30:39 | watch | 1 | 28756 | 11 | 0.546 | 52666.7 |
972 | 2024-04-28 00:30:31 | watch | 2 | 53800 | 87 | 1.783 | 30173.9 |
971 | 2024-04-27 23:53:25 | watch | 2 | 53800 | 87 | 1.673 | 32157.8 |
970 | 2024-04-06 06:19:31 | watch | 1 | 28756 | 11 | 0.500 | 57512.0 |
969 | 2024-03-31 07:46:28 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
968 | 2024-03-29 22:27:02 | watch | 2 | 53800 | 87 | 1.856 | 28987.1 |
967 | 2024-03-29 22:26:41 | watch | 3 | 83667 | 796 | 5.470 | 15295.6 |
966 | 2024-03-29 01:40:45 | watch | 3 | 83667 | 796 | 7.813 | 10708.7 |
965 | 2024-03-29 01:40:44 | watch | 2 | 53800 | 87 | 5.533 | 9723.5 |
964 | 2024-03-29 01:35:51 | watch | 1 | 28756 | 11 | 1.156 | 24875.4 |
963 | 2024-03-08 06:59:11 | watch | 3 | 83667 | 796 | 9.940 | 8417.2 |
962 | 2024-03-07 20:00:44 | watch | 3 | 83667 | 796 | 4.046 | 20678.9 |
961 | 2024-03-07 09:14:28 | watch | 3 | 83667 | 796 | 4.623 | 18098.0 |
960 | 2024-03-07 09:14:29 | watch | 2 | 53800 | 87 | 3.516 | 15301.5 |
959 | 2024-03-07 04:19:29 | watch | 1 | 28756 | 11 | 0.453 | 63479.0 |
958 | 2024-03-05 22:28:23 | watch | 1 | 28756 | 11 | 0.610 | 47141.0 |
957 | 2024-03-01 04:04:48 | watch | 1 | 28756 | 11 | 0.483 | 59536.2 |
956 | 2024-02-27 19:51:03 | watch | 1 | 28756 | 11 | 0.513 | 56054.6 |
955 | 2024-02-21 17:37:05 | watch | 1 | 28756 | 11 | 0.546 | 52666.7 |
954 | 2024-02-03 17:52:43 | watch | 1 | 28756 | 11 | 0.500 | 57512.0 |
953 | 2023-12-17 07:45:19 | watch | 2 | 53800 | 87 | 1.546 | 34799.5 |
952 | 2023-12-16 18:38:49 | watch | 3 | 83667 | 796 | 3.283 | 25484.9 |
951 | 2023-12-07 11:05:07 | watch | 1 | 28756 | 11 | 0.500 | 57512.0 |
950 | 2023-11-14 16:29:03 | watch | 3 | 83667 | 796 | 3.690 | 22674.0 |
949 | 2023-11-14 16:28:55 | watch | 2 | 53800 | 87 | 1.483 | 36277.8 |
948 | 2023-11-12 01:47:58 | watch | 3 | 83667 | 796 | 3.203 | 26121.4 |
947 | 2023-11-12 01:47:51 | watch | 2 | 53800 | 87 | 1.533 | 35094.6 |
946 | 2023-11-11 21:39:41 | watch | 1 | 28756 | 11 | 0.456 | 63061.4 |
945 | 2023-11-08 13:12:36 | watch | 1 | 28756 | 11 | 0.533 | 53951.2 |
944 | 2023-11-03 13:34:12 | watch | 1 | 28756 | 11 | 0.813 | 35370.2 |
943 | 2023-10-21 10:37:38 | watch | 1 | 28756 | 11 | 0.593 | 48492.4 |
942 | 2023-10-17 07:44:11 | watch | 1 | 28756 | 11 | 0.516 | 55728.7 |
941 | 2023-10-14 01:22:37 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
940 | 2023-10-07 10:21:04 | watch | 1 | 28756 | 11 | 0.440 | 65354.5 |
939 | 2023-09-29 18:59:19 | watch | 1 | 28756 | 11 | 0.470 | 61183.0 |
938 | 2023-09-22 06:05:08 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
937 | 2023-09-12 18:05:40 | watch | 1 | 28756 | 11 | 0.470 | 61183.0 |
936 | 2023-04-22 06:23:07 | watch | 1 | 28756 | 11 | 0.440 | 65354.5 |
935 | 2023-02-14 19:07:41 | watch | 1 | 28756 | 11 | 0.876 | 32826.5 |
934 | 2022-12-11 12:27:17 | watch | 1 | 28756 | 11 | 0.470 | 61183.0 |
933 | 2022-11-25 04:08:15 | watch | 1 | 28756 | 11 | 0.486 | 59168.7 |
932 | 2022-09-17 20:40:21 | watch | 1 | 28756 | 11 | 0.453 | 63479.0 |
931 | 2022-08-17 08:30:59 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
930 | 2022-08-08 03:50:42 | watch | 2 | 53800 | 87 | 1.360 | 39558.8 |
929 | 2022-08-08 03:50:10 | watch | 3 | 83667 | 796 | 3.716 | 22515.3 |
928 | 2022-08-07 04:31:40 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
927 | 2022-08-05 21:29:25 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
926 | 2022-04-05 23:16:01 | watch | 1 | 28756 | 11 | 0.453 | 63479.0 |
925 | 2022-04-03 20:09:08 | watch | 1 | 28756 | 11 | 0.500 | 57512.0 |
924 | 2022-01-03 06:56:13 | watch | 1 | 28756 | 11 | 0.453 | 63479.0 |
923 | 2021-11-07 18:43:14 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
922 | 2021-10-10 01:37:48 | watch | 1 | 28756 | 11 | 0.483 | 59536.2 |
921 | 2021-06-12 08:49:18 | watch | 1 | 28756 | 11 | 0.530 | 54256.6 |
920 | 2021-03-21 21:22:44 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
919 | 2021-02-04 19:30:51 | watch | 3 | 83667 | 796 | 3.813 | 21942.6 |
918 | 2021-01-03 17:25:59 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
917 | 2020-11-12 18:37:55 | watch | 1 | 28756 | 11 | 0.466 | 61708.2 |
916 | 2020-11-10 17:39:51 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
915 | 2020-11-10 08:27:30 | watch | 3 | 83667 | 796 | 4.220 | 19826.3 |
914 | 2020-10-18 04:33:03 | watch | 1 | 28756 | 11 | 0.483 | 59536.2 |
913 | 2020-10-14 15:30:51 | watch | 1 | 28756 | 11 | 0.453 | 63479.0 |
912 | 2020-09-03 08:38:27 | watch | 1 | 28756 | 11 | 0.453 | 63479.0 |
911 | 2020-09-01 23:27:11 | watch | 1 | 28756 | 11 | 0.500 | 57512.0 |
910 | 2020-08-28 10:36:07 | watch | 1 | 28756 | 11 | 0.500 | 57512.0 |
909 | 2020-08-15 14:09:02 | watch | 1 | 28756 | 11 | 0.450 | 63902.2 |
908 | 2020-07-20 12:14:43 | watch | 1 | 28756 | 11 | 0.470 | 61183.0 |
907 | 2020-04-11 01:21:12 | watch | 1 | 28756 | 11 | 0.486 | 59168.7 |
906 | 2020-04-04 03:38:22 | watch | 1 | 28756 | 11 | 0.453 | 63479.0 |
905 | 2020-03-28 21:47:01 | watch | 3 | 83667 | 796 | 5.423 | 15428.2 |
904 | 2020-03-25 21:18:51 | watch | 1 | 28756 | 11 | 0.483 | 59536.2 |
903 | 2020-03-25 07:17:37 | watch | 1 | 28756 | 11 | 0.486 | 59168.7 |
902 | 2020-03-24 09:54:26 | watch | 3 | 83667 | 796 | 7.110 | 11767.5 |
901 | 2020-03-24 03:57:58 | watch | 3 | 83667 | 796 | 5.203 | 16080.5 |
900 | 2020-03-23 23:55:49 | watch | 3 | 83667 | 796 | 4.000 | 20916.8 |
899 | 2020-03-23 19:39:39 | watch | 1 | 28756 | 11 | 0.513 | 56054.6 |
898 | 2020-03-22 08:39:43 | watch | 1 | 28756 | 11 | 0.530 | 54256.6 |
897 | 2020-03-22 06:45:07 | watch | 1 | 28756 | 11 | 0.500 | 57512.0 |
896 | 2020-03-21 10:24:18 | watch | 3 | 83667 | 796 | 3.686 | 22698.6 |
895 | 2020-03-21 05:47:58 | watch | 3 | 83667 | 796 | 4.156 | 20131.6 |
894 | 2020-03-20 23:18:40 | watch | 1 | 28756 | 11 | 0.453 | 63479.0 |
893 | 2020-03-19 01:33:07 | watch | 1 | 28756 | 11 | 0.470 | 61183.0 |
892 | 2020-03-18 01:51:28 | watch | 3 | 83667 | 796 | 3.923 | 21327.3 |
891 | 2020-03-18 00:51:48 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
890 | 2020-03-17 15:28:23 | watch | 3 | 83667 | 796 | 4.530 | 18469.5 |
889 | 2020-03-17 04:28:02 | watch | 3 | 83667 | 796 | 3.936 | 21256.9 |
888 | 2020-03-16 06:23:12 | watch | 1 | 28756 | 11 | 0.436 | 65954.1 |
887 | 2020-03-14 07:39:23 | watch | 3 | 83667 | 796 | 3.390 | 24680.5 |
886 | 2020-03-06 04:10:32 | watch | 3 | 83667 | 796 | 7.220 | 11588.2 |
885 | 2020-03-03 17:16:05 | watch | 3 | 83667 | 796 | 4.313 | 19398.8 |