History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"post"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1216 | 2024-04-20 18:56:13 | post | 1 | 13983 | 23 | 0.656 | 21315.5 |
1215 | 2024-04-14 17:05:13 | post | 2 | 29872 | 344 | 2.170 | 13765.9 |
1214 | 2024-04-12 19:15:33 | post | 1 | 13983 | 23 | 0.513 | 27257.3 |
1213 | 2024-04-02 20:18:44 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1212 | 2024-04-01 17:16:04 | post | 2 | 29872 | 344 | 3.093 | 9657.9 |
1211 | 2024-04-01 16:39:28 | post | 1 | 13983 | 23 | 0.530 | 26383.0 |
1210 | 2024-03-30 22:17:47 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1209 | 2024-03-20 19:04:11 | post | 2 | 29872 | 344 | 0.906 | 32971.3 |
1208 | 2024-03-20 02:23:43 | post | 1 | 13983 | 23 | 0.530 | 26383.0 |
1207 | 2024-03-20 02:23:23 | post | 2 | 29872 | 344 | 0.906 | 32971.3 |
1206 | 2024-03-20 02:23:20 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1205 | 2024-03-12 19:28:20 | post | 1 | 13983 | 23 | 0.280 | 49939.3 |
1204 | 2024-03-02 17:26:12 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1203 | 2024-03-02 14:23:15 | post | 2 | 29872 | 344 | 2.093 | 14272.3 |
1202 | 2024-03-02 13:54:42 | post | 1 | 13983 | 23 | 0.266 | 52567.7 |
1201 | 2024-02-25 09:48:24 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1200 | 2024-02-18 22:19:30 | post | 1 | 13983 | 23 | 0.686 | 20383.4 |
1199 | 2024-02-13 12:14:39 | post | 2 | 29872 | 344 | 3.063 | 9752.5 |
1198 | 2024-02-13 04:52:33 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1197 | 2024-02-12 01:07:25 | post | 2 | 29872 | 344 | 3.216 | 9288.6 |
1196 | 2024-02-11 18:15:16 | post | 1 | 13983 | 23 | 0.283 | 49409.9 |
1195 | 2024-01-25 20:25:17 | post | 1 | 13983 | 23 | 0.266 | 52567.7 |
1194 | 2024-01-17 09:25:02 | post | 1 | 13983 | 23 | 0.266 | 52567.7 |
1193 | 2024-01-11 08:31:42 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1192 | 2023-12-18 17:05:18 | post | 1 | 13983 | 23 | 0.313 | 44674.1 |
1191 | 2023-12-07 14:19:18 | post | 1 | 13983 | 23 | 0.266 | 52567.7 |
1190 | 2023-12-07 14:19:17 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1189 | 2023-12-01 02:49:20 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1188 | 2023-11-22 01:12:16 | post | 2 | 29872 | 344 | 0.780 | 38297.4 |
1187 | 2023-11-15 14:55:31 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1186 | 2023-11-12 23:17:18 | post | 2 | 29872 | 344 | 0.750 | 39829.3 |
1185 | 2023-11-09 06:37:10 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1184 | 2023-11-08 02:27:21 | post | 1 | 13983 | 23 | 0.216 | 64736.1 |
1183 | 2023-11-07 18:55:36 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1182 | 2023-11-07 08:09:34 | post | 1 | 13983 | 23 | 0.486 | 28771.6 |
1181 | 2023-11-02 05:03:38 | post | 2 | 29872 | 344 | 0.906 | 32971.3 |
1180 | 2023-10-29 09:46:50 | post | 1 | 13983 | 23 | 0.500 | 27966.0 |
1179 | 2023-10-26 02:02:27 | post | 1 | 13983 | 23 | 0.203 | 68881.8 |
1178 | 2023-10-23 16:26:32 | post | 1 | 13983 | 23 | 0.203 | 68881.8 |
1177 | 2023-10-20 02:16:40 | post | 2 | 29872 | 344 | 0.890 | 33564.0 |
1176 | 2023-10-19 14:26:16 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1175 | 2023-10-18 10:58:22 | post | 2 | 29872 | 344 | 0.750 | 39829.3 |
1174 | 2023-10-17 02:54:26 | post | 2 | 29872 | 344 | 0.750 | 39829.3 |
1173 | 2023-10-16 19:25:56 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1172 | 2023-10-10 22:40:58 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1171 | 2023-10-03 22:58:41 | post | 2 | 29872 | 344 | 0.763 | 39150.7 |
1170 | 2023-10-03 08:33:35 | post | 1 | 13983 | 23 | 0.233 | 60012.9 |
1169 | 2023-09-19 10:42:28 | post | 2 | 29872 | 344 | 0.763 | 39150.7 |
1168 | 2023-09-18 19:17:44 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1167 | 2023-09-16 17:22:35 | post | 1 | 13983 | 23 | 0.216 | 64736.1 |
1166 | 2023-09-14 13:29:50 | post | 2 | 29872 | 344 | 0.860 | 34734.9 |
1165 | 2023-09-10 14:25:48 | post | 1 | 13983 | 23 | 0.233 | 60012.9 |
1164 | 2023-07-08 11:39:08 | post | 1 | 13983 | 23 | 0.216 | 64736.1 |
1163 | 2023-07-05 16:18:02 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1162 | 2023-04-17 20:31:22 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1161 | 2023-03-18 21:01:59 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1160 | 2023-02-09 18:23:29 | post | 1 | 13983 | 23 | 0.203 | 68881.8 |
1159 | 2022-12-29 16:44:45 | post | 1 | 13983 | 23 | 0.203 | 68881.8 |
1158 | 2022-12-07 17:52:21 | post | 1 | 13983 | 23 | 0.216 | 64736.1 |
1157 | 2022-11-30 17:57:09 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1156 | 2022-11-27 11:10:26 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1155 | 2022-10-30 13:28:52 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1154 | 2022-10-29 11:49:46 | post | 1 | 13983 | 23 | 0.203 | 68881.8 |
1153 | 2022-10-28 12:26:18 | post | 1 | 13983 | 23 | 0.233 | 60012.9 |
1152 | 2022-10-27 11:28:44 | post | 1 | 13983 | 23 | 0.216 | 64736.1 |
1151 | 2022-10-26 22:44:34 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1150 | 2022-10-25 09:55:59 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1149 | 2022-10-24 14:33:51 | post | 1 | 13983 | 23 | 0.236 | 59250.0 |
1148 | 2022-10-23 13:46:19 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1147 | 2022-10-22 11:31:39 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1146 | 2022-10-21 17:44:14 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1145 | 2022-10-20 16:35:31 | post | 1 | 13983 | 23 | 0.266 | 52567.7 |
1144 | 2022-10-19 14:11:04 | post | 1 | 13983 | 23 | 0.233 | 60012.9 |
1143 | 2022-10-18 22:06:30 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1142 | 2022-10-16 18:54:42 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1141 | 2022-10-15 20:20:04 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1140 | 2022-10-14 20:30:47 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1139 | 2022-10-13 13:03:59 | post | 1 | 13983 | 23 | 0.216 | 64736.1 |
1138 | 2022-10-12 17:31:11 | post | 1 | 13983 | 23 | 0.440 | 31779.5 |
1137 | 2022-10-11 14:21:57 | post | 1 | 13983 | 23 | 0.233 | 60012.9 |
1136 | 2022-10-10 22:46:29 | post | 1 | 13983 | 23 | 0.216 | 64736.1 |
1135 | 2022-10-09 17:31:39 | post | 1 | 13983 | 23 | 0.216 | 64736.1 |
1134 | 2022-10-08 14:42:19 | post | 1 | 13983 | 23 | 0.233 | 60012.9 |
1133 | 2022-10-07 16:20:20 | post | 1 | 13983 | 23 | 0.216 | 64736.1 |
1132 | 2022-09-01 09:10:51 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1131 | 2022-08-07 11:52:14 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1130 | 2022-08-07 02:52:13 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1129 | 2022-08-03 19:02:19 | post | 1 | 13983 | 23 | 0.233 | 60012.9 |
1128 | 2022-07-02 12:18:56 | post | 2 | 29872 | 344 | 0.733 | 40753.1 |
1127 | 2022-05-11 04:43:15 | post | 1 | 13983 | 23 | 0.563 | 24836.6 |
1126 | 2022-04-05 20:34:14 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1125 | 2022-04-01 07:23:43 | post | 1 | 13983 | 23 | 0.233 | 60012.9 |
1124 | 2022-02-10 19:23:16 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1123 | 2022-01-07 03:58:03 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1122 | 2021-12-21 22:31:15 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1121 | 2021-12-18 17:14:20 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |
1120 | 2021-11-09 12:21:12 | post | 1 | 13983 | 23 | 0.296 | 47239.9 |
1119 | 2021-11-07 10:35:48 | post | 1 | 13983 | 23 | 0.266 | 52567.7 |
1118 | 2021-11-06 20:50:26 | post | 1 | 13983 | 23 | 0.220 | 63559.1 |
1117 | 2021-10-29 21:36:06 | post | 1 | 13983 | 23 | 0.250 | 55932.0 |