History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pics"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1333 | 2024-05-02 00:38:09 | pics | 2 | 29872 | 399 | 2.173 | 13746.9 |
1332 | 2024-05-01 21:16:18 | pics | 1 | 13983 | 22 | 0.546 | 25609.9 |
1331 | 2024-05-01 19:25:47 | pics | 1 | 13983 | 22 | 0.266 | 52567.7 |
1330 | 2024-05-01 04:07:30 | pics | 1 | 13983 | 22 | 0.280 | 49939.3 |
1329 | 2024-04-29 21:36:21 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1328 | 2024-04-29 04:05:42 | pics | 1 | 13983 | 22 | 0.640 | 21848.4 |
1327 | 2024-04-26 04:33:42 | pics | 1 | 13983 | 22 | 0.436 | 32071.1 |
1326 | 2024-04-25 15:25:58 | pics | 1 | 13983 | 22 | 0.283 | 49409.9 |
1325 | 2024-04-01 17:34:10 | pics | 2 | 29872 | 399 | 2.140 | 13958.9 |
1324 | 2024-04-01 16:26:24 | pics | 1 | 13983 | 22 | 0.563 | 24836.6 |
1323 | 2024-03-30 19:52:09 | pics | 2 | 29872 | 399 | 2.016 | 14817.5 |
1322 | 2024-03-30 18:41:36 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1321 | 2024-03-26 20:27:43 | pics | 1 | 13983 | 22 | 0.843 | 16587.2 |
1320 | 2024-03-18 03:50:50 | pics | 1 | 13983 | 22 | 0.266 | 52567.7 |
1319 | 2024-03-08 10:23:52 | pics | 1 | 13983 | 22 | 0.280 | 49939.3 |
1318 | 2024-03-02 14:52:30 | pics | 2 | 29872 | 399 | 2.076 | 14389.2 |
1317 | 2024-03-02 13:28:59 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1316 | 2024-02-27 23:02:49 | pics | 1 | 13983 | 22 | 0.280 | 49939.3 |
1315 | 2024-02-22 06:54:01 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1314 | 2024-01-02 17:43:32 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1313 | 2023-12-09 09:38:20 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1312 | 2023-11-27 20:24:34 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1311 | 2023-11-18 09:16:33 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1310 | 2023-11-14 13:26:42 | pics | 2 | 29872 | 399 | 0.716 | 41720.7 |
1309 | 2023-11-11 20:01:04 | pics | 2 | 29872 | 399 | 0.923 | 32364.0 |
1308 | 2023-11-08 03:48:03 | pics | 1 | 13983 | 22 | 0.280 | 49939.3 |
1307 | 2023-11-07 22:43:46 | pics | 1 | 13983 | 22 | 0.216 | 64736.1 |
1306 | 2023-10-29 06:17:12 | pics | 2 | 29872 | 399 | 0.766 | 38997.4 |
1305 | 2023-10-26 11:11:54 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1304 | 2023-10-25 21:58:51 | pics | 1 | 13983 | 22 | 0.453 | 30867.5 |
1303 | 2023-10-19 15:35:39 | pics | 2 | 29872 | 399 | 1.360 | 21964.7 |
1302 | 2023-10-19 15:14:51 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1301 | 2023-10-18 23:37:42 | pics | 2 | 29872 | 399 | 0.766 | 38997.4 |
1300 | 2023-10-16 19:54:34 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1299 | 2023-10-11 03:35:28 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1298 | 2023-10-03 20:02:48 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1297 | 2023-09-24 02:47:18 | pics | 1 | 13983 | 22 | 0.216 | 64736.1 |
1296 | 2023-09-23 15:25:22 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1295 | 2023-09-11 06:16:11 | pics | 1 | 13983 | 22 | 0.203 | 68881.8 |
1294 | 2023-07-20 23:33:47 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1293 | 2023-07-18 16:31:59 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1292 | 2023-04-18 23:01:03 | pics | 1 | 13983 | 22 | 0.216 | 64736.1 |
1291 | 2023-03-29 05:02:15 | pics | 1 | 13983 | 22 | 0.203 | 68881.8 |
1290 | 2023-02-06 20:08:48 | pics | 1 | 13983 | 22 | 0.203 | 68881.8 |
1289 | 2023-02-02 05:31:55 | pics | 2 | 29872 | 399 | 0.733 | 40753.1 |
1288 | 2023-01-08 16:22:37 | pics | 2 | 29872 | 399 | 0.736 | 40587.0 |
1287 | 2022-12-10 15:25:03 | pics | 1 | 13983 | 22 | 0.216 | 64736.1 |
1286 | 2022-12-10 09:24:37 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1285 | 2022-12-05 11:40:22 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1284 | 2022-11-28 12:53:39 | pics | 2 | 29872 | 399 | 0.783 | 38150.7 |
1283 | 2022-11-25 08:33:51 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1282 | 2022-11-13 06:27:32 | pics | 1 | 13983 | 22 | 0.206 | 67878.6 |
1281 | 2022-11-12 12:54:13 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1280 | 2022-11-11 01:24:00 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1279 | 2022-10-30 21:45:21 | pics | 1 | 13983 | 22 | 0.203 | 68881.8 |
1278 | 2022-10-29 20:07:03 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1277 | 2022-10-28 20:52:02 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1276 | 2022-10-27 19:45:03 | pics | 1 | 13983 | 22 | 0.200 | 69915.0 |
1275 | 2022-10-25 18:13:00 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1274 | 2022-10-24 22:46:39 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1273 | 2022-10-23 21:48:51 | pics | 1 | 13983 | 22 | 0.216 | 64736.1 |
1272 | 2022-10-22 19:49:33 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1271 | 2022-10-19 22:24:41 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1270 | 2022-10-13 21:16:46 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1269 | 2022-10-11 22:44:09 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1268 | 2022-10-08 22:57:24 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1267 | 2022-08-10 09:36:15 | pics | 1 | 13983 | 22 | 0.236 | 59250.0 |
1266 | 2022-08-02 03:47:12 | pics | 1 | 13983 | 22 | 0.216 | 64736.1 |
1265 | 2022-04-02 09:54:52 | pics | 1 | 13983 | 22 | 0.216 | 64736.1 |
1264 | 2022-03-29 22:38:17 | pics | 1 | 13983 | 22 | 0.330 | 42372.7 |
1263 | 2022-03-29 15:49:32 | pics | 1 | 13983 | 22 | 0.340 | 41126.5 |
1262 | 2022-01-04 12:07:25 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1261 | 2021-12-09 03:14:09 | pics | 1 | 13983 | 22 | 0.813 | 17199.3 |
1260 | 2021-11-14 14:43:53 | pics | 1 | 13983 | 22 | 0.236 | 59250.0 |
1259 | 2021-11-08 23:50:27 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1258 | 2021-11-06 22:19:15 | pics | 1 | 13983 | 22 | 0.203 | 68881.8 |
1257 | 2021-10-07 03:40:17 | pics | 1 | 13983 | 22 | 0.236 | 59250.0 |
1256 | 2021-09-05 01:38:00 | pics | 1 | 13983 | 22 | 0.263 | 53167.3 |
1255 | 2021-09-01 18:15:09 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1254 | 2021-08-31 11:54:46 | pics | 1 | 13983 | 22 | 0.283 | 49409.9 |
1253 | 2021-07-27 21:47:27 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1252 | 2021-05-25 09:39:07 | pics | 1 | 13983 | 22 | 0.266 | 52567.7 |
1251 | 2021-05-18 22:18:01 | pics | 1 | 13983 | 22 | 0.266 | 52567.7 |
1250 | 2021-05-14 07:26:29 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1249 | 2021-02-19 21:08:22 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1248 | 2021-02-19 09:19:39 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1247 | 2021-02-11 21:11:49 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1246 | 2021-01-31 09:46:35 | pics | 1 | 13983 | 22 | 0.250 | 55932.0 |
1245 | 2021-01-12 23:31:17 | pics | 2 | 29872 | 399 | 0.783 | 38150.7 |
1244 | 2021-01-03 12:36:59 | pics | 1 | 13983 | 22 | 0.216 | 64736.1 |
1243 | 2020-11-16 06:37:45 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1242 | 2020-10-29 21:26:01 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1241 | 2020-10-26 10:26:44 | pics | 1 | 13983 | 22 | 0.233 | 60012.9 |
1240 | 2020-10-26 04:32:00 | pics | 1 | 13983 | 22 | 0.500 | 27966.0 |
1239 | 2020-10-25 07:14:23 | pics | 2 | 29872 | 399 | 0.766 | 38997.4 |
1238 | 2020-10-14 15:33:37 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1237 | 2020-10-09 21:45:06 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1236 | 2020-09-23 11:27:26 | pics | 1 | 13983 | 22 | 0.203 | 68881.8 |
1235 | 2020-09-03 00:27:38 | pics | 1 | 13983 | 22 | 0.220 | 63559.1 |
1234 | 2020-08-23 03:22:45 | pics | 1 | 13983 | 22 | 0.203 | 68881.8 |