History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pubs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1053 | 2024-04-27 10:07:22 | pubs | 1 | 13983 | 22 | 0.266 | 52567.7 |
1052 | 2024-04-25 15:21:04 | pubs | 1 | 13983 | 22 | 0.296 | 47239.9 |
1051 | 2024-04-25 15:03:55 | pubs | 1 | 13983 | 22 | 0.280 | 49939.3 |
1050 | 2024-04-12 23:12:05 | pubs | 2 | 29872 | 319 | 0.893 | 33451.3 |
1049 | 2024-04-12 23:12:01 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
1048 | 2024-04-12 23:11:53 | pubs | 2 | 29872 | 319 | 1.236 | 24168.3 |
1047 | 2024-04-12 23:11:17 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
1046 | 2024-04-03 00:13:17 | pubs | 1 | 13983 | 22 | 0.830 | 16847.0 |
1045 | 2024-04-01 17:15:09 | pubs | 2 | 29872 | 319 | 3.076 | 9711.3 |
1044 | 2024-04-01 16:39:56 | pubs | 1 | 13983 | 22 | 0.266 | 52567.7 |
1043 | 2024-03-27 10:24:53 | pubs | 1 | 13983 | 22 | 0.360 | 38841.7 |
1042 | 2024-03-12 19:33:00 | pubs | 1 | 13983 | 22 | 0.420 | 33292.9 |
1041 | 2024-03-12 19:32:44 | pubs | 2 | 29872 | 319 | 0.763 | 39150.7 |
1040 | 2024-03-12 19:32:34 | pubs | 1 | 13983 | 22 | 0.266 | 52567.7 |
1039 | 2024-03-03 20:30:43 | pubs | 1 | 13983 | 22 | 0.483 | 28950.3 |
1038 | 2024-03-02 15:40:27 | pubs | 2 | 29872 | 319 | 2.903 | 10290.0 |
1037 | 2024-03-02 14:13:30 | pubs | 2 | 29872 | 319 | 2.000 | 14936.0 |
1036 | 2024-03-02 14:09:00 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
1035 | 2024-02-11 18:09:59 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
1034 | 2024-02-02 18:13:59 | pubs | 1 | 13983 | 22 | 0.500 | 27966.0 |
1033 | 2024-01-26 09:46:09 | pubs | 1 | 13983 | 22 | 0.236 | 59250.0 |
1032 | 2024-01-07 19:43:46 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
1031 | 2023-12-31 13:36:25 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
1030 | 2023-12-26 14:52:10 | pubs | 2 | 29872 | 319 | 0.826 | 36164.6 |
1029 | 2023-12-22 15:43:57 | pubs | 2 | 29872 | 319 | 0.813 | 36742.9 |
1028 | 2023-12-21 18:03:53 | pubs | 1 | 13983 | 22 | 0.233 | 60012.9 |
1027 | 2023-12-19 21:29:12 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
1026 | 2023-11-21 02:21:27 | pubs | 2 | 29872 | 319 | 0.750 | 39829.3 |
1025 | 2023-11-13 13:59:02 | pubs | 1 | 13983 | 22 | 0.236 | 59250.0 |
1024 | 2023-11-12 17:20:22 | pubs | 1 | 13983 | 22 | 0.203 | 68881.8 |
1023 | 2023-11-12 10:19:35 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
1022 | 2023-10-27 03:53:10 | pubs | 1 | 13983 | 22 | 0.516 | 27098.8 |
1021 | 2023-10-19 21:37:26 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
1020 | 2023-10-17 13:42:50 | pubs | 1 | 13983 | 22 | 0.236 | 59250.0 |
1019 | 2023-10-13 12:43:08 | pubs | 1 | 13983 | 22 | 0.236 | 59250.0 |
1018 | 2023-10-07 02:00:06 | pubs | 1 | 13983 | 22 | 0.233 | 60012.9 |
1017 | 2023-10-03 23:52:12 | pubs | 1 | 13983 | 22 | 0.233 | 60012.9 |
1016 | 2023-09-28 01:59:08 | pubs | 2 | 29872 | 319 | 0.876 | 34100.5 |
1015 | 2023-09-24 00:07:00 | pubs | 1 | 13983 | 22 | 0.373 | 37487.9 |
1014 | 2023-09-21 19:40:35 | pubs | 1 | 13983 | 22 | 0.203 | 68881.8 |
1013 | 2023-08-22 09:05:24 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
1012 | 2023-08-02 21:46:50 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
1011 | 2023-05-08 16:01:06 | pubs | 1 | 13983 | 22 | 0.200 | 69915.0 |
1010 | 2023-04-29 14:41:25 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
1009 | 2023-02-18 15:52:06 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
1008 | 2023-01-29 21:41:16 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
1007 | 2022-12-17 00:41:37 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
1006 | 2022-11-25 16:05:56 | pubs | 1 | 13983 | 22 | 0.203 | 68881.8 |
1005 | 2022-11-22 18:46:22 | pubs | 1 | 13983 | 22 | 0.203 | 68881.8 |
1004 | 2022-10-08 07:57:54 | pubs | 1 | 13983 | 22 | 0.233 | 60012.9 |
1003 | 2022-09-10 19:43:50 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
1002 | 2022-08-27 05:45:14 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
1001 | 2022-07-29 00:19:47 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
1000 | 2022-07-18 18:12:02 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
999 | 2022-06-17 02:17:40 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
998 | 2022-06-15 20:57:31 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
997 | 2022-06-10 13:48:23 | pubs | 1 | 13983 | 22 | 0.203 | 68881.8 |
996 | 2022-06-08 17:26:30 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
995 | 2022-06-01 20:28:54 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
994 | 2022-06-01 13:43:42 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
993 | 2022-05-25 17:19:51 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
992 | 2022-04-16 10:21:45 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
991 | 2022-04-14 08:22:25 | pubs | 1 | 13983 | 22 | 0.470 | 29751.1 |
990 | 2022-02-20 03:52:14 | pubs | 1 | 13983 | 22 | 0.233 | 60012.9 |
989 | 2022-01-09 17:23:35 | pubs | 1 | 13983 | 22 | 0.266 | 52567.7 |
988 | 2022-01-07 20:51:17 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
987 | 2022-01-07 16:38:37 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
986 | 2022-01-05 18:25:32 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
985 | 2022-01-01 03:32:23 | pubs | 1 | 13983 | 22 | 0.263 | 53167.3 |
984 | 2021-12-31 16:15:44 | pubs | 1 | 13983 | 22 | 0.266 | 52567.7 |
983 | 2021-12-30 22:02:34 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
982 | 2021-12-30 04:49:06 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
981 | 2021-12-29 20:46:15 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
980 | 2021-12-29 09:35:33 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
979 | 2021-12-28 20:08:13 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
978 | 2021-12-28 02:04:32 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
977 | 2021-12-27 16:32:36 | pubs | 1 | 13983 | 22 | 0.233 | 60012.9 |
976 | 2021-12-27 00:24:06 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
975 | 2021-12-26 13:41:39 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
974 | 2021-12-25 14:04:58 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
973 | 2021-12-25 04:46:44 | pubs | 1 | 13983 | 22 | 0.216 | 64736.1 |
972 | 2021-12-24 15:58:08 | pubs | 1 | 13983 | 22 | 0.483 | 28950.3 |
971 | 2021-12-24 04:48:21 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
970 | 2021-11-24 17:36:31 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
969 | 2021-11-24 09:09:50 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
968 | 2021-11-23 10:38:04 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
967 | 2021-11-23 01:01:08 | pubs | 1 | 13983 | 22 | 0.360 | 38841.7 |
966 | 2021-11-22 17:06:21 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
965 | 2021-11-18 22:25:45 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
964 | 2021-11-18 10:11:30 | pubs | 1 | 13983 | 22 | 0.263 | 53167.3 |
963 | 2021-11-17 21:15:28 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
962 | 2021-11-17 13:34:16 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |
961 | 2021-11-08 19:57:22 | pubs | 1 | 13983 | 22 | 0.233 | 60012.9 |
960 | 2021-11-04 00:02:41 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
959 | 2021-11-02 22:25:29 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
958 | 2021-11-01 15:04:33 | pubs | 1 | 13983 | 22 | 0.233 | 60012.9 |
957 | 2021-11-01 02:08:36 | pubs | 1 | 13983 | 22 | 0.236 | 59250.0 |
956 | 2021-10-31 11:08:29 | pubs | 1 | 13983 | 22 | 0.250 | 55932.0 |
955 | 2021-10-26 17:21:34 | pubs | 1 | 13983 | 22 | 0.233 | 60012.9 |
954 | 2021-10-26 06:46:26 | pubs | 1 | 13983 | 22 | 0.220 | 63559.1 |