History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dubs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
996 | 2024-04-19 17:46:40 | dubs | 1 | 13983 | 23 | 0.423 | 33056.7 |
995 | 2024-04-08 16:34:20 | dubs | 2 | 29872 | 327 | 3.296 | 9063.1 |
994 | 2024-04-08 06:37:37 | dubs | 2 | 29872 | 327 | 0.940 | 31778.7 |
993 | 2024-04-04 22:40:13 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
992 | 2024-04-04 11:12:04 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
991 | 2024-04-02 23:06:42 | dubs | 1 | 13983 | 23 | 0.563 | 24836.6 |
990 | 2024-03-30 22:24:50 | dubs | 2 | 29872 | 327 | 2.766 | 10799.7 |
989 | 2024-03-30 22:08:30 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
988 | 2024-03-30 09:41:56 | dubs | 1 | 13983 | 23 | 0.533 | 26234.5 |
987 | 2024-03-29 16:38:02 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
986 | 2024-03-27 07:30:15 | dubs | 1 | 13983 | 23 | 0.440 | 31779.5 |
985 | 2024-03-05 20:22:56 | dubs | 1 | 13983 | 23 | 0.546 | 25609.9 |
984 | 2024-03-03 20:30:51 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
983 | 2024-02-25 21:47:34 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
982 | 2024-02-02 22:46:21 | dubs | 1 | 13983 | 23 | 0.500 | 27966.0 |
981 | 2024-02-02 18:15:43 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
980 | 2024-01-26 17:21:37 | dubs | 1 | 13983 | 23 | 0.466 | 30006.4 |
979 | 2024-01-04 16:42:56 | dubs | 2 | 29872 | 327 | 0.750 | 39829.3 |
978 | 2023-12-29 22:13:21 | dubs | 1 | 13983 | 23 | 0.200 | 69915.0 |
977 | 2023-12-26 17:10:46 | dubs | 1 | 13983 | 23 | 0.216 | 64736.1 |
976 | 2023-12-20 08:27:01 | dubs | 2 | 29872 | 327 | 0.936 | 31914.5 |
975 | 2023-12-19 03:41:51 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
974 | 2023-12-10 12:46:45 | dubs | 2 | 29872 | 327 | 0.813 | 36742.9 |
973 | 2023-11-21 02:01:05 | dubs | 2 | 29872 | 327 | 0.843 | 35435.3 |
972 | 2023-11-15 18:49:47 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
971 | 2023-11-12 04:05:29 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
970 | 2023-10-27 03:52:29 | dubs | 1 | 13983 | 23 | 0.206 | 67878.6 |
969 | 2023-10-19 23:24:38 | dubs | 2 | 29872 | 327 | 0.843 | 35435.3 |
968 | 2023-10-19 21:36:15 | dubs | 1 | 13983 | 23 | 0.466 | 30006.4 |
967 | 2023-10-18 10:20:06 | dubs | 2 | 29872 | 327 | 0.813 | 36742.9 |
966 | 2023-10-16 19:24:13 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
965 | 2023-10-11 03:06:33 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
964 | 2023-10-06 03:54:19 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
963 | 2023-10-03 23:45:10 | dubs | 1 | 13983 | 23 | 0.280 | 49939.3 |
962 | 2023-09-22 20:51:12 | dubs | 1 | 13983 | 23 | 0.283 | 49409.9 |
961 | 2023-09-13 18:13:19 | dubs | 1 | 13983 | 23 | 0.203 | 68881.8 |
960 | 2023-09-10 17:01:13 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
959 | 2023-09-10 16:36:18 | dubs | 2 | 29872 | 327 | 0.860 | 34734.9 |
958 | 2023-09-09 19:42:05 | dubs | 2 | 29872 | 327 | 0.766 | 38997.4 |
957 | 2023-08-20 12:28:47 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
956 | 2023-08-02 22:03:28 | dubs | 1 | 13983 | 23 | 0.216 | 64736.1 |
955 | 2023-07-26 10:42:52 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
954 | 2023-06-06 12:56:55 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
953 | 2023-06-03 06:31:37 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
952 | 2023-06-01 14:25:01 | dubs | 2 | 29872 | 327 | 1.466 | 20376.5 |
951 | 2023-05-02 10:31:17 | dubs | 1 | 13983 | 23 | 0.216 | 64736.1 |
950 | 2023-03-07 13:07:17 | dubs | 2 | 29872 | 327 | 0.716 | 41720.7 |
949 | 2023-02-25 02:45:23 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
948 | 2023-02-22 19:18:06 | dubs | 1 | 13983 | 23 | 0.216 | 64736.1 |
947 | 2022-12-20 04:09:48 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
946 | 2022-12-18 04:05:21 | dubs | 2 | 29872 | 327 | 1.780 | 16782.0 |
945 | 2022-12-14 00:34:15 | dubs | 2 | 29872 | 327 | 0.720 | 41488.9 |
944 | 2022-12-10 08:28:41 | dubs | 2 | 29872 | 327 | 0.876 | 34100.5 |
943 | 2022-11-23 23:31:57 | dubs | 2 | 29872 | 327 | 0.826 | 36164.6 |
942 | 2022-11-19 18:47:58 | dubs | 2 | 29872 | 327 | 0.813 | 36742.9 |
941 | 2022-11-18 23:30:51 | dubs | 1 | 13983 | 23 | 0.203 | 68881.8 |
940 | 2022-11-08 09:54:07 | dubs | 2 | 29872 | 327 | 0.920 | 32469.6 |
939 | 2022-10-09 02:25:53 | dubs | 2 | 29872 | 327 | 0.733 | 40753.1 |
938 | 2022-09-18 11:59:01 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
937 | 2022-09-04 01:50:31 | dubs | 2 | 29872 | 327 | 0.826 | 36164.6 |
936 | 2022-09-03 03:50:14 | dubs | 1 | 13983 | 23 | 0.203 | 68881.8 |
935 | 2022-08-15 07:36:41 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
934 | 2022-08-07 01:34:14 | dubs | 1 | 13983 | 23 | 0.216 | 64736.1 |
933 | 2022-08-04 20:42:08 | dubs | 2 | 29872 | 327 | 0.750 | 39829.3 |
932 | 2022-07-18 04:04:16 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
931 | 2022-07-10 06:54:08 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
930 | 2022-06-25 12:00:09 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
929 | 2022-06-01 21:16:43 | dubs | 1 | 13983 | 23 | 0.203 | 68881.8 |
928 | 2022-06-01 17:07:36 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
927 | 2022-05-12 23:14:04 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
926 | 2022-04-22 19:48:28 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
925 | 2022-02-08 06:46:55 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
924 | 2022-01-16 09:36:52 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
923 | 2021-11-12 05:09:10 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
922 | 2021-11-07 08:30:21 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
921 | 2021-09-25 15:03:02 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
920 | 2021-09-23 11:08:08 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
919 | 2021-09-11 06:03:08 | dubs | 1 | 13983 | 23 | 0.216 | 64736.1 |
918 | 2021-08-17 10:44:55 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
917 | 2021-08-15 06:19:49 | dubs | 1 | 13983 | 23 | 0.216 | 64736.1 |
916 | 2021-08-04 06:17:46 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
915 | 2021-05-18 14:02:13 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
914 | 2021-05-03 13:28:29 | dubs | 1 | 13983 | 23 | 0.266 | 52567.7 |
913 | 2021-05-03 05:00:19 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
912 | 2021-04-29 21:56:00 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
911 | 2021-02-28 20:31:36 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
910 | 2021-02-27 22:49:38 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
909 | 2021-02-19 11:11:30 | dubs | 1 | 13983 | 23 | 0.296 | 47239.9 |
908 | 2021-02-03 14:30:36 | dubs | 1 | 13983 | 23 | 0.203 | 68881.8 |
907 | 2021-01-30 10:09:06 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
906 | 2021-01-27 23:47:36 | dubs | 1 | 13983 | 23 | 0.220 | 63559.1 |
905 | 2021-01-25 11:00:08 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
904 | 2021-01-02 09:04:53 | dubs | 1 | 13983 | 23 | 0.203 | 68881.8 |
903 | 2020-11-09 09:57:38 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
902 | 2020-11-06 21:45:18 | dubs | 1 | 13983 | 23 | 0.216 | 64736.1 |
901 | 2020-10-28 09:47:29 | dubs | 1 | 13983 | 23 | 0.250 | 55932.0 |
900 | 2020-10-26 09:15:16 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
899 | 2020-10-24 07:12:57 | dubs | 1 | 13983 | 23 | 0.233 | 60012.9 |
898 | 2020-10-23 02:00:20 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |
897 | 2020-10-18 08:55:37 | dubs | 1 | 13983 | 23 | 0.236 | 59250.0 |