History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pits"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1397 | 2024-04-26 02:42:07 | pits | 2 | 29872 | 534 | 0.890 | 33564.0 |
1396 | 2024-04-25 15:52:31 | pits | 1 | 13983 | 35 | 0.393 | 35580.2 |
1395 | 2024-04-25 15:31:34 | pits | 1 | 13983 | 35 | 0.373 | 37487.9 |
1394 | 2024-04-18 23:01:12 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1393 | 2024-04-14 23:37:31 | pits | 1 | 13983 | 35 | 0.576 | 24276.0 |
1392 | 2024-04-06 13:51:11 | pits | 1 | 13983 | 35 | 0.266 | 52567.7 |
1391 | 2024-04-01 17:15:04 | pits | 2 | 29872 | 534 | 2.063 | 14479.9 |
1390 | 2024-04-01 16:40:01 | pits | 1 | 13983 | 35 | 0.560 | 24969.6 |
1389 | 2024-03-31 00:45:09 | pits | 2 | 29872 | 534 | 2.030 | 14715.3 |
1388 | 2024-03-30 23:48:07 | pits | 1 | 13983 | 35 | 0.546 | 25609.9 |
1387 | 2024-03-26 20:26:42 | pits | 1 | 13983 | 35 | 1.093 | 12793.2 |
1386 | 2024-03-22 20:24:30 | pits | 1 | 13983 | 35 | 0.440 | 31779.5 |
1385 | 2024-03-21 16:31:39 | pits | 1 | 13983 | 35 | 0.860 | 16259.3 |
1384 | 2024-03-20 22:33:54 | pits | 1 | 13983 | 35 | 0.593 | 23580.1 |
1383 | 2024-03-08 12:35:17 | pits | 1 | 13983 | 35 | 0.420 | 33292.9 |
1382 | 2024-03-07 05:04:24 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1381 | 2024-03-06 09:04:30 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1380 | 2024-03-02 14:20:01 | pits | 2 | 29872 | 534 | 3.143 | 9504.3 |
1379 | 2024-03-02 13:59:46 | pits | 1 | 13983 | 35 | 0.546 | 25609.9 |
1378 | 2024-02-25 16:59:37 | pits | 1 | 13983 | 35 | 0.560 | 24969.6 |
1377 | 2024-02-22 15:35:21 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1376 | 2024-02-21 01:24:38 | pits | 1 | 13983 | 35 | 0.986 | 14181.5 |
1375 | 2024-02-19 22:33:29 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1374 | 2024-02-19 02:32:03 | pits | 1 | 13983 | 35 | 0.533 | 26234.5 |
1373 | 2024-02-15 13:33:51 | pits | 1 | 13983 | 35 | 0.576 | 24276.0 |
1372 | 2024-02-14 13:09:43 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1371 | 2024-02-13 19:14:45 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1370 | 2024-02-12 23:49:28 | pits | 1 | 13983 | 35 | 0.233 | 60012.9 |
1369 | 2024-02-11 19:16:30 | pits | 1 | 13983 | 35 | 0.280 | 49939.3 |
1368 | 2024-02-11 03:02:57 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1367 | 2024-02-10 01:41:29 | pits | 1 | 13983 | 35 | 0.296 | 47239.9 |
1366 | 2024-02-09 02:51:08 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1365 | 2024-02-07 22:40:10 | pits | 1 | 13983 | 35 | 0.266 | 52567.7 |
1364 | 2024-02-07 02:26:26 | pits | 1 | 13983 | 35 | 0.266 | 52567.7 |
1363 | 2024-02-05 23:42:01 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1362 | 2024-02-04 01:21:10 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1361 | 2024-02-03 02:10:09 | pits | 1 | 13983 | 35 | 0.266 | 52567.7 |
1360 | 2024-02-01 10:41:23 | pits | 1 | 13983 | 35 | 0.516 | 27098.8 |
1359 | 2024-02-01 06:01:02 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1358 | 2024-01-31 09:13:38 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1357 | 2024-01-30 02:29:12 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1356 | 2024-01-28 23:04:26 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1355 | 2024-01-27 18:29:55 | pits | 1 | 13983 | 35 | 0.233 | 60012.9 |
1354 | 2024-01-26 22:27:03 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1353 | 2024-01-25 19:34:57 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1352 | 2024-01-15 02:51:39 | pits | 2 | 29872 | 534 | 0.780 | 38297.4 |
1351 | 2024-01-02 13:14:56 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1350 | 2023-12-27 09:27:58 | pits | 1 | 13983 | 35 | 0.236 | 59250.0 |
1349 | 2023-12-12 17:37:03 | pits | 2 | 29872 | 534 | 0.763 | 39150.7 |
1348 | 2023-12-03 07:15:36 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1347 | 2023-12-03 07:15:35 | pits | 1 | 13983 | 35 | 0.233 | 60012.9 |
1346 | 2023-11-30 18:24:38 | pits | 1 | 13983 | 35 | 0.203 | 68881.8 |
1345 | 2023-11-28 22:18:26 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1344 | 2023-11-26 00:43:16 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1343 | 2023-11-20 01:31:34 | pits | 2 | 29872 | 534 | 0.750 | 39829.3 |
1342 | 2023-11-11 20:01:32 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1341 | 2023-11-11 01:57:11 | pits | 1 | 13983 | 35 | 0.296 | 47239.9 |
1340 | 2023-11-08 23:52:23 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1339 | 2023-11-05 17:54:34 | pits | 1 | 13983 | 35 | 0.356 | 39278.1 |
1338 | 2023-11-02 13:10:37 | pits | 1 | 13983 | 35 | 0.236 | 59250.0 |
1337 | 2023-11-02 05:57:10 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1336 | 2023-10-28 01:36:57 | pits | 2 | 29872 | 534 | 0.860 | 34734.9 |
1335 | 2023-10-26 07:04:59 | pits | 2 | 29872 | 534 | 0.906 | 32971.3 |
1334 | 2023-10-25 22:01:05 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1333 | 2023-10-25 17:41:55 | pits | 2 | 29872 | 534 | 0.783 | 38150.7 |
1332 | 2023-10-23 03:00:15 | pits | 2 | 29872 | 534 | 0.750 | 39829.3 |
1331 | 2023-10-21 01:49:50 | pits | 2 | 29872 | 534 | 0.750 | 39829.3 |
1330 | 2023-10-19 15:15:24 | pits | 1 | 13983 | 35 | 0.216 | 64736.1 |
1329 | 2023-10-18 06:57:24 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1328 | 2023-10-17 17:19:35 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1327 | 2023-10-11 09:36:05 | pits | 1 | 13983 | 35 | 0.203 | 68881.8 |
1326 | 2023-10-03 20:12:28 | pits | 1 | 13983 | 35 | 0.343 | 40766.8 |
1325 | 2023-09-22 19:11:45 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1324 | 2023-09-22 03:37:40 | pits | 1 | 13983 | 35 | 0.233 | 60012.9 |
1323 | 2023-08-13 15:06:29 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1322 | 2023-08-08 17:37:25 | pits | 2 | 29872 | 534 | 0.843 | 35435.3 |
1321 | 2023-08-05 16:21:28 | pits | 2 | 29872 | 534 | 0.860 | 34734.9 |
1320 | 2023-07-25 17:58:51 | pits | 1 | 13983 | 35 | 0.236 | 59250.0 |
1319 | 2023-05-14 02:46:29 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1318 | 2023-04-21 05:51:29 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1317 | 2023-01-12 14:07:45 | pits | 1 | 13983 | 35 | 0.216 | 64736.1 |
1316 | 2022-11-25 08:44:15 | pits | 1 | 13983 | 35 | 0.203 | 68881.8 |
1315 | 2022-09-25 01:06:54 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1314 | 2022-07-10 02:20:56 | pits | 1 | 13983 | 35 | 0.236 | 59250.0 |
1313 | 2022-06-11 15:39:40 | pits | 1 | 13983 | 35 | 0.216 | 64736.1 |
1312 | 2022-05-13 18:32:31 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1311 | 2022-05-02 21:36:28 | pits | 1 | 13983 | 35 | 0.266 | 52567.7 |
1310 | 2022-05-01 19:08:27 | pits | 1 | 13983 | 35 | 0.236 | 59250.0 |
1309 | 2022-05-01 04:25:43 | pits | 1 | 13983 | 35 | 0.236 | 59250.0 |
1308 | 2022-04-30 14:24:32 | pits | 1 | 13983 | 35 | 0.233 | 60012.9 |
1307 | 2022-04-29 09:37:19 | pits | 1 | 13983 | 35 | 0.406 | 34440.9 |
1306 | 2022-04-28 23:29:30 | pits | 1 | 13983 | 35 | 0.216 | 64736.1 |
1305 | 2022-04-28 19:37:01 | pits | 2 | 29872 | 534 | 0.750 | 39829.3 |
1304 | 2022-04-28 13:45:04 | pits | 1 | 13983 | 35 | 0.296 | 47239.9 |
1303 | 2022-04-28 03:18:44 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1302 | 2022-04-27 11:12:52 | pits | 1 | 13983 | 35 | 0.233 | 60012.9 |
1301 | 2022-04-26 22:52:11 | pits | 1 | 13983 | 35 | 0.250 | 55932.0 |
1300 | 2022-04-26 07:16:23 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |
1299 | 2022-04-25 17:41:05 | pits | 1 | 13983 | 35 | 0.236 | 59250.0 |
1298 | 2022-04-25 05:58:08 | pits | 1 | 13983 | 35 | 0.220 | 63559.1 |