History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"file"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1099 | 2024-05-02 00:21:22 | file | 2 | 29872 | 425 | 3.453 | 8651.0 |
| 1098 | 2024-05-01 21:28:04 | file | 1 | 13983 | 25 | 0.530 | 26383.0 |
| 1097 | 2024-05-01 21:12:13 | file | 1 | 13983 | 25 | 0.266 | 52567.7 |
| 1096 | 2024-04-30 05:43:38 | file | 1 | 13983 | 25 | 0.513 | 27257.3 |
| 1095 | 2024-04-02 18:09:29 | file | 1 | 13983 | 25 | 1.110 | 12597.3 |
| 1094 | 2024-04-01 15:33:04 | file | 1 | 13983 | 25 | 0.580 | 24108.6 |
| 1093 | 2024-03-31 00:29:41 | file | 1 | 13983 | 25 | 0.266 | 52567.7 |
| 1092 | 2024-03-06 14:48:21 | file | 1 | 13983 | 25 | 0.266 | 52567.7 |
| 1091 | 2024-03-06 03:22:02 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1090 | 2024-03-06 01:04:42 | file | 1 | 13983 | 25 | 0.483 | 28950.3 |
| 1089 | 2024-03-03 20:13:14 | file | 2 | 29872 | 425 | 0.860 | 34734.9 |
| 1088 | 2024-03-03 16:18:10 | file | 2 | 29872 | 425 | 1.940 | 15397.9 |
| 1087 | 2024-03-02 18:12:03 | file | 2 | 29872 | 425 | 2.843 | 10507.2 |
| 1086 | 2024-03-02 13:31:30 | file | 1 | 13983 | 25 | 0.843 | 16587.2 |
| 1085 | 2024-02-25 16:56:51 | file | 1 | 13983 | 25 | 0.236 | 59250.0 |
| 1084 | 2024-01-28 21:56:03 | file | 1 | 13983 | 25 | 0.266 | 52567.7 |
| 1083 | 2024-01-28 15:56:39 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1082 | 2024-01-24 12:41:06 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1081 | 2023-12-21 02:35:21 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |
| 1080 | 2023-12-17 22:09:45 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |
| 1079 | 2023-12-14 20:24:51 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1078 | 2023-12-10 16:54:12 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1077 | 2023-12-09 08:10:15 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1076 | 2023-12-03 06:48:07 | file | 1 | 13983 | 25 | 0.423 | 33056.7 |
| 1075 | 2023-11-13 22:50:21 | file | 2 | 29872 | 425 | 0.826 | 36164.6 |
| 1074 | 2023-11-11 10:51:39 | file | 2 | 29872 | 425 | 0.826 | 36164.6 |
| 1073 | 2023-11-11 01:39:27 | file | 1 | 13983 | 25 | 0.220 | 63559.1 |
| 1072 | 2023-11-08 03:04:26 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1071 | 2023-11-07 21:16:07 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1070 | 2023-11-02 07:15:44 | file | 2 | 29872 | 425 | 0.843 | 35435.3 |
| 1069 | 2023-11-01 12:57:44 | file | 2 | 29872 | 425 | 0.736 | 40587.0 |
| 1068 | 2023-10-26 01:21:19 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1067 | 2023-10-20 08:05:18 | file | 2 | 29872 | 425 | 0.720 | 41488.9 |
| 1066 | 2023-10-19 15:48:03 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1065 | 2023-10-18 14:49:55 | file | 2 | 29872 | 425 | 0.860 | 34734.9 |
| 1064 | 2023-10-16 19:33:58 | file | 1 | 13983 | 25 | 0.220 | 63559.1 |
| 1063 | 2023-10-13 06:00:12 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |
| 1062 | 2023-10-03 16:21:59 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1061 | 2023-10-01 04:22:37 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1060 | 2023-09-23 15:18:14 | file | 1 | 13983 | 25 | 0.203 | 68881.8 |
| 1059 | 2023-09-23 03:48:32 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1058 | 2023-09-13 22:49:17 | file | 2 | 29872 | 425 | 0.800 | 37340.0 |
| 1057 | 2023-09-10 13:52:12 | file | 1 | 13983 | 25 | 0.200 | 69915.0 |
| 1056 | 2023-08-27 18:12:39 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1055 | 2023-08-18 22:33:17 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1054 | 2023-07-17 06:55:52 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1053 | 2023-05-27 15:50:02 | file | 1 | 13983 | 25 | 0.220 | 63559.1 |
| 1052 | 2023-04-17 03:52:26 | file | 1 | 13983 | 25 | 0.236 | 59250.0 |
| 1051 | 2023-02-21 17:26:45 | file | 1 | 13983 | 25 | 0.423 | 33056.7 |
| 1050 | 2023-02-11 16:25:59 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1049 | 2022-12-08 19:04:36 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |
| 1048 | 2022-11-18 21:53:04 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1047 | 2022-09-10 19:24:28 | file | 1 | 13983 | 25 | 0.203 | 68881.8 |
| 1046 | 2022-08-18 11:13:32 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1045 | 2022-08-15 01:09:07 | file | 1 | 13983 | 25 | 0.203 | 68881.8 |
| 1044 | 2022-08-11 02:23:32 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |
| 1043 | 2022-07-29 09:14:35 | file | 1 | 13983 | 25 | 0.220 | 63559.1 |
| 1042 | 2022-06-04 08:54:17 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1041 | 2022-05-12 21:24:15 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1040 | 2022-04-06 18:03:07 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1039 | 2022-03-01 18:00:31 | file | 1 | 13983 | 25 | 0.220 | 63559.1 |
| 1038 | 2022-03-01 01:12:21 | file | 1 | 13983 | 25 | 0.343 | 40766.8 |
| 1037 | 2022-02-28 11:56:18 | file | 1 | 13983 | 25 | 0.283 | 49409.9 |
| 1036 | 2022-02-27 17:15:52 | file | 1 | 13983 | 25 | 0.236 | 59250.0 |
| 1035 | 2022-02-26 11:28:59 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1034 | 2022-02-25 20:58:05 | file | 1 | 13983 | 25 | 0.220 | 63559.1 |
| 1033 | 2022-02-25 10:32:16 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1032 | 2022-02-12 23:09:40 | file | 1 | 13983 | 25 | 0.236 | 59250.0 |
| 1031 | 2022-02-12 11:27:31 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1030 | 2022-02-11 20:30:24 | file | 1 | 13983 | 25 | 0.200 | 69915.0 |
| 1029 | 2022-02-11 03:58:07 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |
| 1028 | 2022-02-08 04:49:00 | file | 1 | 13983 | 25 | 0.220 | 63559.1 |
| 1027 | 2022-01-08 07:38:20 | file | 1 | 13983 | 25 | 0.326 | 42892.6 |
| 1026 | 2022-01-07 01:14:18 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1025 | 2021-12-31 20:40:40 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1024 | 2021-12-31 09:22:44 | file | 1 | 13983 | 25 | 0.263 | 53167.3 |
| 1023 | 2021-12-30 16:25:07 | file | 1 | 13983 | 25 | 0.500 | 27966.0 |
| 1022 | 2021-12-30 01:34:13 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1021 | 2021-12-29 13:57:56 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |
| 1020 | 2021-12-28 12:59:14 | file | 1 | 13983 | 25 | 0.266 | 52567.7 |
| 1019 | 2021-12-27 21:00:52 | file | 1 | 13983 | 25 | 0.236 | 59250.0 |
| 1018 | 2021-12-27 10:55:24 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1017 | 2021-12-26 18:40:53 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1016 | 2021-12-26 07:54:31 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1015 | 2021-12-25 19:01:07 | file | 1 | 13983 | 25 | 0.436 | 32071.1 |
| 1014 | 2021-12-25 06:20:15 | file | 1 | 13983 | 25 | 0.563 | 24836.6 |
| 1013 | 2021-12-24 23:50:49 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1012 | 2021-12-24 09:51:28 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1011 | 2021-12-23 13:59:14 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1010 | 2021-12-23 02:37:09 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1009 | 2021-12-22 19:53:27 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1008 | 2021-12-22 07:41:08 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |
| 1007 | 2021-12-21 13:25:54 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1006 | 2021-12-21 02:26:10 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |
| 1005 | 2021-12-20 15:36:29 | file | 1 | 13983 | 25 | 0.236 | 59250.0 |
| 1004 | 2021-12-20 03:42:01 | file | 1 | 13983 | 25 | 0.233 | 60012.9 |
| 1003 | 2021-11-10 15:53:32 | file | 1 | 13983 | 25 | 0.203 | 68881.8 |
| 1002 | 2021-11-10 05:20:28 | file | 1 | 13983 | 25 | 0.250 | 55932.0 |
| 1001 | 2021-11-09 19:00:49 | file | 1 | 13983 | 25 | 0.313 | 44674.1 |
| 1000 | 2021-11-09 07:21:58 | file | 1 | 13983 | 25 | 0.216 | 64736.1 |