History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spat"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1066 | 2024-04-11 14:01:09 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1065 | 2024-04-02 20:19:06 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1064 | 2024-04-01 15:30:18 | spat | 1 | 13983 | 25 | 0.576 | 24276.0 |
1063 | 2024-03-31 00:49:25 | spat | 2 | 29872 | 289 | 1.436 | 20802.2 |
1062 | 2024-03-30 23:13:22 | spat | 1 | 13983 | 25 | 0.530 | 26383.0 |
1061 | 2024-03-28 17:14:05 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1060 | 2024-03-13 22:07:39 | spat | 1 | 13983 | 25 | 0.563 | 24836.6 |
1059 | 2024-03-02 17:26:00 | spat | 1 | 13983 | 25 | 0.450 | 31073.3 |
1058 | 2024-03-02 14:43:43 | spat | 2 | 29872 | 289 | 1.060 | 28181.1 |
1057 | 2024-03-02 13:35:38 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1056 | 2024-02-25 17:10:10 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1055 | 2024-02-22 09:49:20 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1054 | 2024-01-05 12:46:37 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1053 | 2023-12-28 09:39:56 | spat | 2 | 29872 | 289 | 0.890 | 33564.0 |
1052 | 2023-12-14 09:54:34 | spat | 2 | 29872 | 289 | 0.763 | 39150.7 |
1051 | 2023-11-13 18:01:39 | spat | 1 | 13983 | 25 | 0.203 | 68881.8 |
1050 | 2023-11-11 16:41:43 | spat | 1 | 13983 | 25 | 0.203 | 68881.8 |
1049 | 2023-10-31 10:35:27 | spat | 2 | 29872 | 289 | 0.826 | 36164.6 |
1048 | 2023-10-31 07:17:14 | spat | 2 | 29872 | 289 | 0.810 | 36879.0 |
1047 | 2023-10-28 02:11:54 | spat | 1 | 13983 | 25 | 0.236 | 59250.0 |
1046 | 2023-10-26 00:06:01 | spat | 1 | 13983 | 25 | 0.236 | 59250.0 |
1045 | 2023-10-21 05:14:04 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
1044 | 2023-10-20 20:10:32 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1043 | 2023-10-17 17:09:20 | spat | 1 | 13983 | 25 | 0.236 | 59250.0 |
1042 | 2023-10-11 06:57:41 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1041 | 2023-10-05 02:30:23 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1040 | 2023-09-25 11:11:37 | spat | 1 | 13983 | 25 | 0.216 | 64736.1 |
1039 | 2023-09-23 16:20:03 | spat | 1 | 13983 | 25 | 0.203 | 68881.8 |
1038 | 2023-09-11 19:17:47 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
1037 | 2023-08-21 18:32:50 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1036 | 2023-06-30 14:08:21 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
1035 | 2023-06-26 20:33:01 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1034 | 2023-05-23 20:05:39 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1033 | 2023-03-21 04:43:52 | spat | 1 | 13983 | 25 | 0.216 | 64736.1 |
1032 | 2023-03-11 02:00:25 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
1031 | 2023-03-07 19:17:43 | spat | 1 | 13983 | 25 | 0.203 | 68881.8 |
1030 | 2023-02-23 18:14:28 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1029 | 2023-01-17 08:30:48 | spat | 2 | 29872 | 289 | 0.766 | 38997.4 |
1028 | 2023-01-17 08:14:27 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1027 | 2023-01-06 07:37:24 | spat | 1 | 13983 | 25 | 0.203 | 68881.8 |
1026 | 2022-11-15 20:56:59 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1025 | 2022-10-01 13:15:29 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
1024 | 2022-09-03 19:18:22 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1023 | 2022-07-29 03:32:39 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1022 | 2022-07-26 16:02:28 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1021 | 2022-07-19 11:38:10 | spat | 2 | 29872 | 289 | 0.736 | 40587.0 |
1020 | 2022-07-17 23:42:14 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1019 | 2022-07-12 12:51:40 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1018 | 2022-07-11 19:43:36 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1017 | 2022-07-09 11:27:06 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1016 | 2022-07-08 15:10:51 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1015 | 2022-07-08 00:04:18 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1014 | 2022-07-06 12:27:05 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
1013 | 2022-07-05 13:27:20 | spat | 1 | 13983 | 25 | 0.236 | 59250.0 |
1012 | 2022-07-03 16:03:08 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1011 | 2022-07-03 11:39:41 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1010 | 2022-07-03 03:45:40 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1009 | 2022-07-02 09:52:24 | spat | 1 | 13983 | 25 | 0.216 | 64736.1 |
1008 | 2022-07-01 13:19:40 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1007 | 2022-06-30 21:31:54 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
1006 | 2022-06-08 23:29:45 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
1005 | 2022-05-31 14:51:29 | spat | 1 | 13983 | 25 | 0.236 | 59250.0 |
1004 | 2022-05-15 13:39:05 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
1003 | 2022-04-27 00:29:25 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
1002 | 2022-03-28 16:46:44 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
1001 | 2022-03-04 01:15:38 | spat | 1 | 13983 | 25 | 0.343 | 40766.8 |
1000 | 2022-02-06 20:13:04 | spat | 1 | 13983 | 25 | 0.266 | 52567.7 |
999 | 2022-02-06 08:58:40 | spat | 1 | 13983 | 25 | 0.203 | 68881.8 |
998 | 2022-02-05 13:47:22 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
997 | 2022-02-04 22:00:01 | spat | 1 | 13983 | 25 | 0.216 | 64736.1 |
996 | 2022-02-04 13:43:58 | spat | 1 | 13983 | 25 | 0.563 | 24836.6 |
995 | 2022-02-04 00:38:50 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
994 | 2022-02-03 14:36:09 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
993 | 2022-02-03 12:40:57 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
992 | 2022-02-03 06:35:36 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
991 | 2022-02-02 16:40:49 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
990 | 2022-02-02 01:12:20 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
989 | 2022-02-01 12:45:05 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
988 | 2022-02-01 01:37:05 | spat | 1 | 13983 | 25 | 0.436 | 32071.1 |
987 | 2022-01-31 09:57:38 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
986 | 2022-01-31 00:25:32 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
985 | 2022-01-30 17:17:40 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
984 | 2022-01-30 05:41:07 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
983 | 2022-01-29 12:10:57 | spat | 1 | 13983 | 25 | 0.250 | 55932.0 |
982 | 2022-01-28 23:17:24 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
981 | 2022-01-28 04:20:56 | spat | 1 | 13983 | 25 | 0.236 | 59250.0 |
980 | 2022-01-27 10:30:24 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
979 | 2022-01-26 23:47:01 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
978 | 2022-01-26 14:25:55 | spat | 1 | 13983 | 25 | 0.203 | 68881.8 |
977 | 2022-01-26 01:53:37 | spat | 1 | 13983 | 25 | 0.203 | 68881.8 |
976 | 2022-01-25 06:16:23 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
975 | 2022-01-24 21:21:43 | spat | 1 | 13983 | 25 | 0.216 | 64736.1 |
974 | 2022-01-24 01:53:09 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
973 | 2022-01-09 10:10:07 | spat | 1 | 13983 | 25 | 0.263 | 53167.3 |
972 | 2022-01-08 19:54:42 | spat | 1 | 13983 | 25 | 0.266 | 52567.7 |
971 | 2022-01-08 03:01:21 | spat | 1 | 13983 | 25 | 0.220 | 63559.1 |
970 | 2022-01-07 16:09:02 | spat | 1 | 13983 | 25 | 0.266 | 52567.7 |
969 | 2022-01-07 00:17:13 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |
968 | 2021-12-17 21:34:55 | spat | 1 | 13983 | 25 | 0.263 | 53167.3 |
967 | 2021-12-14 09:44:55 | spat | 1 | 13983 | 25 | 0.233 | 60012.9 |