History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pams"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1314 | 2024-04-01 15:27:30 | pams | 2 | 29872 | 541 | 1.110 | 26911.7 |
1313 | 2024-04-01 15:27:10 | pams | 1 | 13983 | 27 | 0.546 | 25609.9 |
1312 | 2024-04-01 15:21:27 | pams | 1 | 13983 | 27 | 0.296 | 47239.9 |
1311 | 2024-03-30 19:44:31 | pams | 2 | 29872 | 541 | 2.470 | 12093.9 |
1310 | 2024-03-30 18:49:02 | pams | 1 | 13983 | 27 | 0.686 | 20383.4 |
1309 | 2024-03-02 12:58:36 | pams | 2 | 29872 | 541 | 2.076 | 14389.2 |
1308 | 2024-03-02 12:58:26 | pams | 1 | 13983 | 27 | 0.280 | 49939.3 |
1307 | 2024-03-02 12:58:13 | pams | 1 | 13983 | 27 | 0.563 | 24836.6 |
1306 | 2024-03-01 20:02:09 | pams | 1 | 13983 | 27 | 0.280 | 49939.3 |
1305 | 2024-02-19 16:09:00 | pams | 1 | 13983 | 27 | 0.486 | 28771.6 |
1304 | 2024-02-01 07:55:32 | pams | 2 | 29872 | 541 | 1.330 | 22460.2 |
1303 | 2024-02-01 07:55:19 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1302 | 2024-01-28 14:52:03 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1301 | 2024-01-18 16:38:22 | pams | 1 | 13983 | 27 | 0.236 | 59250.0 |
1300 | 2024-01-18 12:40:25 | pams | 2 | 29872 | 541 | 0.750 | 39829.3 |
1299 | 2024-01-11 13:40:49 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1298 | 2024-01-11 12:06:49 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1297 | 2024-01-02 07:07:41 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1296 | 2023-12-28 11:11:30 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1295 | 2023-12-16 00:06:05 | pams | 2 | 29872 | 541 | 0.763 | 39150.7 |
1294 | 2023-12-07 16:55:05 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1293 | 2023-12-07 16:55:04 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1292 | 2023-11-28 09:48:06 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1291 | 2023-11-24 09:45:54 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1290 | 2023-11-21 02:29:08 | pams | 2 | 29872 | 541 | 0.826 | 36164.6 |
1289 | 2023-11-12 01:28:59 | pams | 1 | 13983 | 27 | 0.236 | 59250.0 |
1288 | 2023-11-09 01:35:58 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1287 | 2023-11-07 14:11:42 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1286 | 2023-11-06 17:55:36 | pams | 1 | 13983 | 27 | 0.516 | 27098.8 |
1285 | 2023-11-05 01:50:23 | pams | 2 | 29872 | 541 | 0.843 | 35435.3 |
1284 | 2023-11-04 19:14:21 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1283 | 2023-11-03 03:41:37 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1282 | 2023-11-02 04:23:16 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1281 | 2023-10-31 11:46:09 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1280 | 2023-10-30 09:37:01 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1279 | 2023-10-29 15:04:11 | pams | 2 | 29872 | 541 | 0.923 | 32364.0 |
1278 | 2023-10-29 01:35:17 | pams | 1 | 13983 | 27 | 0.236 | 59250.0 |
1277 | 2023-10-26 08:53:24 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1276 | 2023-10-19 22:38:20 | pams | 1 | 13983 | 27 | 0.203 | 68881.8 |
1275 | 2023-10-17 04:25:15 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1274 | 2023-10-17 00:07:02 | pams | 1 | 13983 | 27 | 0.236 | 59250.0 |
1273 | 2023-10-11 05:47:47 | pams | 1 | 13983 | 27 | 0.203 | 68881.8 |
1272 | 2023-10-11 03:20:14 | pams | 1 | 13983 | 27 | 0.280 | 49939.3 |
1271 | 2023-10-07 21:23:17 | pams | 2 | 29872 | 541 | 0.906 | 32971.3 |
1270 | 2023-10-03 13:00:49 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1269 | 2023-10-01 18:03:40 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1268 | 2023-09-29 14:47:19 | pams | 1 | 13983 | 27 | 0.236 | 59250.0 |
1267 | 2023-09-26 18:18:03 | pams | 2 | 29872 | 541 | 1.576 | 18954.3 |
1266 | 2023-09-23 18:16:14 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1265 | 2023-09-21 19:33:11 | pams | 1 | 13983 | 27 | 0.236 | 59250.0 |
1264 | 2023-09-21 00:01:00 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1263 | 2023-09-12 13:46:38 | pams | 2 | 29872 | 541 | 0.810 | 36879.0 |
1262 | 2023-09-07 21:42:01 | pams | 1 | 13983 | 27 | 0.236 | 59250.0 |
1261 | 2023-08-26 13:37:54 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1260 | 2023-08-14 18:27:26 | pams | 2 | 29872 | 541 | 0.783 | 38150.7 |
1259 | 2023-08-10 22:06:02 | pams | 1 | 13983 | 27 | 0.266 | 52567.7 |
1258 | 2023-08-06 20:08:46 | pams | 2 | 29872 | 541 | 0.906 | 32971.3 |
1257 | 2023-07-30 20:13:46 | pams | 2 | 29872 | 541 | 0.780 | 38297.4 |
1256 | 2023-07-30 18:15:09 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1255 | 2023-07-24 00:26:51 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1254 | 2023-07-17 21:00:51 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1253 | 2023-07-16 22:42:55 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1252 | 2023-07-15 23:43:56 | pams | 1 | 13983 | 27 | 0.236 | 59250.0 |
1251 | 2023-07-15 01:49:42 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1250 | 2023-07-14 11:32:09 | pams | 1 | 13983 | 27 | 0.266 | 52567.7 |
1249 | 2023-06-27 05:15:47 | pams | 1 | 13983 | 27 | 0.203 | 68881.8 |
1248 | 2023-05-30 09:42:18 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1247 | 2023-04-17 16:34:53 | pams | 2 | 29872 | 541 | 0.830 | 35990.4 |
1246 | 2023-04-15 22:59:42 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1245 | 2023-03-31 14:04:20 | pams | 2 | 29872 | 541 | 0.750 | 39829.3 |
1244 | 2023-03-27 14:40:54 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1243 | 2023-03-24 04:42:12 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1242 | 2023-01-25 18:41:27 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1241 | 2023-01-24 06:50:53 | pams | 2 | 29872 | 541 | 0.750 | 39829.3 |
1240 | 2023-01-23 07:04:30 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1239 | 2023-01-21 15:15:05 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1238 | 2023-01-19 05:01:24 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1237 | 2023-01-16 14:19:41 | pams | 1 | 13983 | 27 | 0.203 | 68881.8 |
1236 | 2023-01-11 19:06:50 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1235 | 2023-01-10 21:25:07 | pams | 1 | 13983 | 27 | 0.236 | 59250.0 |
1234 | 2023-01-09 10:41:04 | pams | 1 | 13983 | 27 | 0.203 | 68881.8 |
1233 | 2023-01-08 11:42:43 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1232 | 2023-01-06 22:45:14 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1231 | 2023-01-04 07:41:57 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1230 | 2022-11-03 10:33:20 | pams | 2 | 29872 | 541 | 0.753 | 39670.7 |
1229 | 2022-10-13 12:19:36 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |
1228 | 2022-09-27 00:37:22 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1227 | 2022-09-01 07:48:05 | pams | 1 | 13983 | 27 | 0.220 | 63559.1 |
1226 | 2022-08-23 12:59:11 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1225 | 2022-08-12 08:44:36 | pams | 2 | 29872 | 541 | 0.876 | 34100.5 |
1224 | 2022-07-29 10:04:42 | pams | 1 | 13983 | 27 | 0.233 | 60012.9 |
1223 | 2022-06-22 02:58:53 | pams | 2 | 29872 | 541 | 1.030 | 29001.9 |
1222 | 2022-06-14 04:09:07 | pams | 2 | 29872 | 541 | 0.750 | 39829.3 |
1221 | 2022-06-13 16:13:14 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1220 | 2022-06-08 22:30:32 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1219 | 2022-06-05 09:09:48 | pams | 2 | 29872 | 541 | 0.780 | 38297.4 |
1218 | 2022-06-01 05:11:40 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1217 | 2022-05-30 00:05:39 | pams | 1 | 13983 | 27 | 0.216 | 64736.1 |
1216 | 2022-05-19 13:34:03 | pams | 2 | 29872 | 541 | 0.796 | 37527.6 |
1215 | 2022-05-19 00:53:21 | pams | 1 | 13983 | 27 | 0.250 | 55932.0 |