History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"folio"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1320 | 2024-05-01 00:11:16 | folio | 1 | 28756 | 6 | 0.703 | 40904.7 |
| 1319 | 2024-04-26 16:25:23 | folio | 1 | 28756 | 6 | 0.516 | 55728.7 |
| 1318 | 2024-04-06 13:44:28 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1317 | 2024-03-31 06:55:32 | folio | 1 | 28756 | 6 | 0.546 | 52666.7 |
| 1316 | 2024-03-31 02:16:12 | folio | 2 | 53800 | 55 | 1.643 | 32745.0 |
| 1315 | 2024-03-31 02:16:11 | folio | 1 | 28756 | 6 | 0.516 | 55728.7 |
| 1314 | 2024-03-31 02:15:49 | folio | 3 | 83667 | 958 | 4.360 | 19189.7 |
| 1313 | 2024-03-30 20:07:52 | folio | 3 | 83667 | 958 | 4.703 | 17790.1 |
| 1312 | 2024-03-30 04:29:43 | folio | 3 | 83667 | 958 | 9.813 | 8526.1 |
| 1311 | 2024-03-29 16:27:26 | folio | 3 | 83667 | 958 | 9.563 | 8749.0 |
| 1310 | 2024-03-29 16:27:18 | folio | 2 | 53800 | 55 | 7.593 | 7085.5 |
| 1309 | 2024-03-29 16:26:14 | folio | 1 | 28756 | 6 | 0.560 | 51350.0 |
| 1308 | 2024-03-18 05:10:10 | folio | 1 | 28756 | 6 | 0.906 | 31739.5 |
| 1307 | 2024-03-14 06:43:43 | folio | 1 | 28756 | 6 | 0.516 | 55728.7 |
| 1306 | 2024-03-07 05:26:03 | folio | 3 | 83667 | 958 | 9.080 | 9214.4 |
| 1305 | 2024-03-07 05:26:06 | folio | 2 | 53800 | 55 | 3.720 | 14462.4 |
| 1304 | 2024-03-07 05:07:51 | folio | 1 | 28756 | 6 | 1.063 | 27051.7 |
| 1303 | 2024-02-28 19:11:04 | folio | 2 | 53800 | 55 | 1.623 | 33148.5 |
| 1302 | 2024-02-28 18:55:45 | folio | 3 | 83667 | 958 | 3.486 | 24000.9 |
| 1301 | 2024-02-28 10:41:17 | folio | 2 | 53800 | 55 | 2.420 | 22231.4 |
| 1300 | 2024-02-28 10:40:59 | folio | 3 | 83667 | 958 | 4.360 | 19189.7 |
| 1299 | 2024-02-28 07:57:13 | folio | 3 | 83667 | 958 | 8.593 | 9736.6 |
| 1298 | 2024-02-28 07:57:12 | folio | 2 | 53800 | 55 | 1.750 | 30742.9 |
| 1297 | 2024-02-28 07:57:00 | folio | 1 | 28756 | 6 | 0.530 | 54256.6 |
| 1296 | 2024-02-03 19:22:27 | folio | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 1295 | 2024-01-29 06:58:15 | folio | 1 | 28756 | 6 | 0.470 | 61183.0 |
| 1294 | 2024-01-29 03:17:41 | folio | 1 | 28756 | 6 | 0.423 | 67981.1 |
| 1293 | 2024-01-14 08:40:14 | folio | 3 | 83667 | 958 | 3.406 | 24564.6 |
| 1292 | 2024-01-14 08:40:07 | folio | 2 | 53800 | 55 | 1.390 | 38705.0 |
| 1291 | 2024-01-12 06:44:26 | folio | 3 | 83667 | 958 | 3.766 | 22216.4 |
| 1290 | 2024-01-12 06:44:25 | folio | 2 | 53800 | 55 | 1.546 | 34799.5 |
| 1289 | 2023-12-16 13:00:15 | folio | 1 | 28756 | 6 | 0.440 | 65354.5 |
| 1288 | 2023-12-07 07:13:52 | folio | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 1287 | 2023-11-17 05:30:24 | folio | 1 | 28756 | 6 | 0.440 | 65354.5 |
| 1286 | 2023-11-15 20:13:32 | folio | 1 | 28756 | 6 | 0.516 | 55728.7 |
| 1285 | 2023-11-04 01:28:53 | folio | 1 | 28756 | 6 | 0.466 | 61708.2 |
| 1284 | 2023-10-23 00:38:04 | folio | 1 | 28756 | 6 | 0.470 | 61183.0 |
| 1283 | 2023-10-19 18:10:14 | folio | 1 | 28756 | 6 | 0.513 | 56054.6 |
| 1282 | 2023-10-13 13:58:32 | folio | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 1281 | 2023-10-04 16:42:34 | folio | 1 | 28756 | 6 | 0.453 | 63479.0 |
| 1280 | 2023-10-04 04:06:14 | folio | 1 | 28756 | 6 | 0.580 | 49579.3 |
| 1279 | 2023-09-26 09:17:34 | folio | 1 | 28756 | 6 | 0.486 | 59168.7 |
| 1278 | 2023-09-22 08:24:43 | folio | 1 | 28756 | 6 | 0.470 | 61183.0 |
| 1277 | 2023-08-11 11:09:29 | folio | 1 | 28756 | 6 | 0.483 | 59536.2 |
| 1276 | 2023-08-07 19:35:50 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1275 | 2023-08-01 03:04:38 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1274 | 2023-04-30 05:32:19 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1273 | 2023-04-29 06:57:22 | folio | 1 | 28756 | 6 | 0.453 | 63479.0 |
| 1272 | 2023-03-10 07:41:23 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1271 | 2023-02-20 12:33:41 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1270 | 2023-01-17 22:40:10 | folio | 1 | 28756 | 6 | 0.466 | 61708.2 |
| 1269 | 2022-12-18 18:32:12 | folio | 1 | 28756 | 6 | 0.420 | 68466.7 |
| 1268 | 2022-10-03 20:33:23 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1267 | 2022-09-30 05:56:26 | folio | 1 | 28756 | 6 | 0.440 | 65354.5 |
| 1266 | 2022-09-02 23:00:15 | folio | 1 | 28756 | 6 | 0.483 | 59536.2 |
| 1265 | 2022-06-21 22:23:55 | folio | 1 | 28756 | 6 | 0.466 | 61708.2 |
| 1264 | 2022-06-13 06:31:04 | folio | 1 | 28756 | 6 | 0.453 | 63479.0 |
| 1263 | 2022-04-18 07:41:19 | folio | 1 | 28756 | 6 | 0.450 | 63902.2 |
| 1262 | 2022-02-26 02:49:27 | folio | 1 | 28756 | 6 | 0.453 | 63479.0 |
| 1261 | 2022-02-22 16:52:37 | folio | 1 | 28756 | 6 | 0.513 | 56054.6 |
| 1260 | 2022-01-16 03:27:29 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1259 | 2022-01-13 23:42:02 | folio | 1 | 28756 | 6 | 0.440 | 65354.5 |
| 1258 | 2021-11-17 21:58:09 | folio | 1 | 28756 | 6 | 0.546 | 52666.7 |
| 1257 | 2021-11-09 21:58:45 | folio | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 1256 | 2021-09-25 09:37:24 | folio | 1 | 28756 | 6 | 0.470 | 61183.0 |
| 1255 | 2021-08-23 17:57:58 | folio | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 1254 | 2021-08-21 13:08:00 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1253 | 2021-08-18 09:01:15 | folio | 1 | 28756 | 6 | 0.420 | 68466.7 |
| 1252 | 2021-08-15 01:40:22 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1251 | 2021-06-24 08:34:13 | folio | 3 | 83667 | 958 | 3.236 | 25855.1 |
| 1250 | 2021-06-06 03:55:48 | folio | 2 | 53800 | 55 | 1.626 | 33087.3 |
| 1249 | 2021-05-14 09:58:11 | folio | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 1248 | 2021-05-12 03:52:48 | folio | 2 | 53800 | 55 | 1.830 | 29398.9 |
| 1247 | 2021-02-19 07:55:18 | folio | 3 | 83667 | 958 | 3.750 | 22311.2 |
| 1246 | 2021-02-11 16:26:14 | folio | 3 | 83667 | 958 | 3.453 | 24230.2 |
| 1245 | 2021-02-11 05:14:14 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1244 | 2021-02-06 09:30:54 | folio | 1 | 28756 | 6 | 0.533 | 53951.2 |
| 1243 | 2021-02-06 09:03:20 | folio | 1 | 28756 | 6 | 0.483 | 59536.2 |
| 1242 | 2021-02-06 08:38:02 | folio | 1 | 28756 | 6 | 0.483 | 59536.2 |
| 1241 | 2021-02-06 08:14:38 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1240 | 2021-01-25 06:28:51 | folio | 2 | 53800 | 55 | 1.623 | 33148.5 |
| 1239 | 2021-01-20 19:10:40 | folio | 3 | 83667 | 958 | 3.283 | 25484.9 |
| 1238 | 2020-11-19 16:52:33 | folio | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 1237 | 2020-11-09 04:54:17 | folio | 3 | 83667 | 958 | 4.233 | 19765.4 |
| 1236 | 2020-11-06 16:50:23 | folio | 3 | 83667 | 958 | 5.626 | 14871.5 |
| 1235 | 2020-11-05 13:35:03 | folio | 2 | 53800 | 55 | 1.470 | 36598.6 |
| 1234 | 2020-11-04 08:26:53 | folio | 1 | 28756 | 6 | 0.483 | 59536.2 |
| 1233 | 2020-10-23 08:57:26 | folio | 3 | 83667 | 958 | 3.250 | 25743.7 |
| 1232 | 2020-10-07 22:46:00 | folio | 1 | 28756 | 6 | 0.440 | 65354.5 |
| 1231 | 2020-10-06 00:34:04 | folio | 3 | 83667 | 958 | 3.953 | 21165.4 |
| 1230 | 2020-09-03 03:24:30 | folio | 1 | 28756 | 6 | 0.466 | 61708.2 |
| 1229 | 2020-08-02 12:06:30 | folio | 3 | 83667 | 958 | 3.453 | 24230.2 |
| 1228 | 2020-07-31 19:34:21 | folio | 1 | 28756 | 6 | 0.440 | 65354.5 |
| 1227 | 2020-07-27 09:15:04 | folio | 1 | 28756 | 6 | 0.470 | 61183.0 |
| 1226 | 2020-05-23 09:00:07 | folio | 3 | 83667 | 958 | 3.233 | 25879.1 |
| 1225 | 2020-05-22 00:37:13 | folio | 2 | 53800 | 55 | 1.390 | 38705.0 |
| 1224 | 2020-04-29 08:23:19 | folio | 1 | 28756 | 6 | 0.453 | 63479.0 |
| 1223 | 2020-04-14 21:26:51 | folio | 3 | 83667 | 958 | 3.356 | 24930.6 |
| 1222 | 2020-04-06 18:28:10 | folio | 3 | 83667 | 958 | 3.313 | 25254.2 |
| 1221 | 2020-03-28 07:52:55 | folio | 3 | 83667 | 958 | 3.796 | 22040.8 |