History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"others"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1039 | 2024-05-02 13:54:24 | others | 1 | 48755 | 8 | 0.950 | 51321.1 |
1038 | 2024-04-26 06:34:50 | others | 1 | 48755 | 8 | 1.203 | 40527.8 |
1037 | 2024-04-18 10:45:14 | others | 1 | 48755 | 8 | 1.813 | 26891.9 |
1036 | 2024-04-15 01:41:15 | others | 1 | 48755 | 8 | 3.623 | 13457.1 |
1035 | 2024-04-15 01:35:10 | others | 1 | 48755 | 8 | 1.656 | 29441.4 |
1034 | 2024-04-03 04:03:25 | others | 2 | 82551 | 103 | 5.626 | 14673.1 |
1033 | 2024-04-03 03:58:50 | others | 1 | 48755 | 8 | 0.936 | 52088.7 |
1032 | 2024-03-31 04:47:34 | others | 1 | 48755 | 8 | 2.970 | 16415.8 |
1031 | 2024-03-04 04:11:38 | others | 1 | 48755 | 8 | 2.250 | 21668.9 |
1030 | 2024-01-31 07:28:02 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
1029 | 2024-01-11 18:10:01 | others | 2 | 82551 | 103 | 2.453 | 33653.1 |
1028 | 2024-01-04 15:45:51 | others | 1 | 48755 | 8 | 0.720 | 67715.3 |
1027 | 2023-12-08 03:24:26 | others | 2 | 82551 | 103 | 2.560 | 32246.5 |
1026 | 2023-12-06 11:32:08 | others | 2 | 82551 | 103 | 2.593 | 31836.1 |
1025 | 2023-11-26 14:00:11 | others | 1 | 48755 | 8 | 0.736 | 66243.2 |
1024 | 2023-11-21 12:12:26 | others | 1 | 48755 | 8 | 0.830 | 58741.0 |
1023 | 2023-11-11 18:31:11 | others | 1 | 48755 | 8 | 1.000 | 48755.0 |
1022 | 2023-11-10 22:51:08 | others | 1 | 48755 | 8 | 0.876 | 55656.4 |
1021 | 2023-11-10 16:10:21 | others | 1 | 48755 | 8 | 0.720 | 67715.3 |
1020 | 2023-10-29 04:17:37 | others | 1 | 48755 | 8 | 0.846 | 57630.0 |
1019 | 2023-10-25 10:32:56 | others | 2 | 82551 | 103 | 2.860 | 28864.0 |
1018 | 2023-10-20 06:24:45 | others | 1 | 48755 | 8 | 0.800 | 60943.8 |
1017 | 2023-10-20 04:53:31 | others | 1 | 48755 | 8 | 0.796 | 61250.0 |
1016 | 2023-10-17 23:29:11 | others | 2 | 82551 | 103 | 2.123 | 38884.1 |
1015 | 2023-10-11 04:45:51 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
1014 | 2023-10-06 10:07:14 | others | 1 | 48755 | 8 | 0.843 | 57835.1 |
1013 | 2023-09-23 20:56:09 | others | 1 | 48755 | 8 | 0.766 | 63648.8 |
1012 | 2023-09-14 14:06:35 | others | 2 | 82551 | 103 | 2.626 | 31436.0 |
1011 | 2023-09-11 00:39:57 | others | 1 | 48755 | 8 | 0.810 | 60191.4 |
1010 | 2023-09-10 14:27:59 | others | 1 | 48755 | 8 | 0.826 | 59025.4 |
1009 | 2023-07-28 09:16:47 | others | 2 | 82551 | 103 | 2.453 | 33653.1 |
1008 | 2023-07-05 10:02:16 | others | 1 | 48755 | 8 | 0.846 | 57630.0 |
1007 | 2023-06-18 13:02:10 | others | 1 | 48755 | 8 | 0.826 | 59025.4 |
1006 | 2023-04-07 00:59:05 | others | 2 | 82551 | 103 | 2.076 | 39764.5 |
1005 | 2023-04-01 18:38:55 | others | 1 | 48755 | 8 | 0.796 | 61250.0 |
1004 | 2023-03-15 08:11:39 | others | 1 | 48755 | 8 | 0.716 | 68093.6 |
1003 | 2023-01-14 13:26:20 | others | 1 | 48755 | 8 | 0.796 | 61250.0 |
1002 | 2023-01-05 08:57:56 | others | 2 | 82551 | 103 | 2.080 | 39688.0 |
1001 | 2022-11-20 11:07:24 | others | 1 | 48755 | 8 | 0.733 | 66514.3 |
1000 | 2022-11-16 21:31:24 | others | 1 | 48755 | 8 | 0.720 | 67715.3 |
999 | 2022-11-02 18:56:31 | others | 1 | 48755 | 8 | 0.766 | 63648.8 |
998 | 2022-09-18 16:09:19 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
997 | 2022-09-10 06:47:56 | others | 2 | 82551 | 103 | 2.110 | 39123.7 |
996 | 2022-09-09 12:05:54 | others | 1 | 48755 | 8 | 0.860 | 56691.9 |
995 | 2022-08-14 06:18:47 | others | 1 | 48755 | 8 | 0.826 | 59025.4 |
994 | 2022-08-07 05:43:20 | others | 1 | 48755 | 8 | 0.736 | 66243.2 |
993 | 2022-08-05 22:47:50 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
992 | 2022-07-20 09:01:52 | others | 1 | 48755 | 8 | 0.813 | 59969.2 |
991 | 2022-07-11 08:21:00 | others | 2 | 82551 | 103 | 2.313 | 35690.0 |
990 | 2022-06-22 05:28:41 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
989 | 2022-06-13 14:17:55 | others | 2 | 82551 | 103 | 2.093 | 39441.5 |
988 | 2022-04-28 12:01:03 | others | 2 | 82551 | 103 | 2.406 | 34310.5 |
987 | 2022-04-23 01:47:50 | others | 2 | 82551 | 103 | 2.390 | 34540.2 |
986 | 2022-03-27 08:15:49 | others | 2 | 82551 | 103 | 2.140 | 38575.2 |
985 | 2022-03-22 20:19:19 | others | 1 | 48755 | 8 | 0.813 | 59969.2 |
984 | 2022-02-25 06:59:46 | others | 1 | 48755 | 8 | 0.796 | 61250.0 |
983 | 2021-12-14 07:58:42 | others | 1 | 48755 | 8 | 0.793 | 61481.7 |
982 | 2021-12-12 04:21:36 | others | 2 | 82551 | 103 | 2.420 | 34112.0 |
981 | 2021-12-08 20:59:14 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
980 | 2021-10-19 10:32:16 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
979 | 2021-09-13 16:06:36 | others | 1 | 48755 | 8 | 0.846 | 57630.0 |
978 | 2021-09-01 11:51:46 | others | 1 | 48755 | 8 | 0.733 | 66514.3 |
977 | 2021-08-27 01:45:39 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
976 | 2021-07-26 11:54:29 | others | 1 | 48755 | 8 | 0.843 | 57835.1 |
975 | 2021-05-31 19:27:07 | others | 1 | 48755 | 8 | 0.813 | 59969.2 |
974 | 2021-05-17 05:10:32 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
973 | 2021-03-01 14:01:52 | others | 1 | 48755 | 8 | 0.733 | 66514.3 |
972 | 2021-01-29 17:52:34 | others | 1 | 48755 | 8 | 0.813 | 59969.2 |
971 | 2021-01-01 09:16:24 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
970 | 2020-11-29 23:15:56 | others | 1 | 48755 | 8 | 0.733 | 66514.3 |
969 | 2020-10-27 11:47:38 | others | 1 | 48755 | 8 | 1.250 | 39004.0 |
968 | 2020-10-22 17:47:24 | others | 1 | 48755 | 8 | 0.830 | 58741.0 |
967 | 2020-10-17 08:12:25 | others | 1 | 48755 | 8 | 0.873 | 55847.7 |
966 | 2020-08-29 14:59:52 | others | 1 | 48755 | 8 | 0.733 | 66514.3 |
965 | 2020-08-22 21:16:02 | others | 1 | 48755 | 8 | 0.780 | 62506.4 |
964 | 2020-08-22 18:05:14 | others | 1 | 48755 | 8 | 0.763 | 63899.1 |
963 | 2020-08-03 22:37:32 | others | 1 | 48755 | 8 | 0.846 | 57630.0 |
962 | 2020-07-29 18:39:04 | others | 1 | 48755 | 8 | 1.016 | 47987.2 |
961 | 2020-07-29 07:55:55 | others | 1 | 48755 | 8 | 0.780 | 62506.4 |
960 | 2020-07-28 16:19:12 | others | 1 | 48755 | 8 | 0.903 | 53992.2 |
959 | 2020-05-25 00:16:55 | others | 1 | 48755 | 8 | 0.720 | 67715.3 |
958 | 2020-05-21 22:50:02 | others | 1 | 48755 | 8 | 0.750 | 65006.7 |
957 | 2020-04-26 03:49:30 | others | 1 | 48755 | 8 | 0.813 | 59969.2 |
956 | 2020-03-26 20:45:23 | others | 1 | 48755 | 8 | 0.843 | 57835.1 |
955 | 2020-03-26 17:40:02 | others | 1 | 48755 | 8 | 0.830 | 58741.0 |
954 | 2020-03-25 02:55:10 | others | 1 | 48755 | 8 | 0.906 | 53813.5 |
953 | 2020-03-23 07:27:35 | others | 1 | 48755 | 8 | 0.906 | 53813.5 |
952 | 2020-03-22 03:05:35 | others | 1 | 48755 | 8 | 0.843 | 57835.1 |
951 | 2020-03-18 09:36:26 | others | 1 | 48755 | 8 | 0.733 | 66514.3 |
950 | 2020-02-26 22:04:31 | others | 1 | 48755 | 8 | 0.953 | 51159.5 |
949 | 2020-02-25 09:37:28 | others | 1 | 48755 | 8 | 0.846 | 57630.0 |
948 | 2020-02-25 06:58:36 | others | 1 | 48755 | 8 | 1.610 | 30282.6 |
947 | 2020-02-24 07:48:27 | others | 1 | 48755 | 8 | 1.373 | 35509.8 |
946 | 2020-02-22 16:00:44 | others | 1 | 48755 | 8 | 1.703 | 28628.9 |
945 | 2020-02-22 07:00:51 | others | 1 | 48755 | 8 | 1.376 | 35432.4 |
944 | 2020-02-18 19:43:28 | others | 1 | 48755 | 8 | 0.876 | 55656.4 |
943 | 2020-02-10 07:28:13 | others | 1 | 48755 | 8 | 0.940 | 51867.0 |
942 | 2020-01-31 17:20:07 | others | 1 | 48755 | 8 | 1.343 | 36303.1 |
941 | 2020-01-30 15:43:16 | others | 1 | 48755 | 8 | 0.813 | 59969.2 |
940 | 2020-01-30 04:09:47 | others | 1 | 48755 | 8 | 0.920 | 52994.6 |