History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fids"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1489 | 2024-04-22 14:18:47 | fids | 2 | 29872 | 385 | 0.953 | 31345.2 |
1488 | 2024-04-22 13:50:19 | fids | 1 | 13983 | 24 | 0.250 | 55932.0 |
1487 | 2024-04-22 13:49:27 | fids | 2 | 29872 | 385 | 0.780 | 38297.4 |
1486 | 2024-04-22 13:48:42 | fids | 1 | 13983 | 24 | 0.296 | 47239.9 |
1485 | 2024-04-22 13:44:11 | fids | 1 | 13983 | 24 | 0.266 | 52567.7 |
1484 | 2024-04-19 08:33:11 | fids | 2 | 29872 | 385 | 0.766 | 38997.4 |
1483 | 2024-04-15 08:37:54 | fids | 1 | 13983 | 24 | 0.236 | 59250.0 |
1482 | 2024-04-15 01:46:07 | fids | 1 | 13983 | 24 | 0.783 | 17858.2 |
1481 | 2024-04-02 23:46:16 | fids | 1 | 13983 | 24 | 0.563 | 24836.6 |
1480 | 2024-04-01 17:36:37 | fids | 2 | 29872 | 385 | 2.080 | 14361.5 |
1479 | 2024-04-01 16:24:18 | fids | 1 | 13983 | 24 | 0.763 | 18326.3 |
1478 | 2024-03-31 00:37:20 | fids | 1 | 13983 | 24 | 0.796 | 17566.6 |
1477 | 2024-03-30 06:59:40 | fids | 2 | 29872 | 385 | 1.983 | 15064.0 |
1476 | 2024-03-29 23:46:06 | fids | 2 | 29872 | 385 | 2.106 | 14184.2 |
1475 | 2024-03-03 20:28:30 | fids | 1 | 13983 | 24 | 0.263 | 53167.3 |
1474 | 2024-03-02 14:48:00 | fids | 2 | 29872 | 385 | 3.093 | 9657.9 |
1473 | 2024-03-02 13:31:44 | fids | 1 | 13983 | 24 | 0.563 | 24836.6 |
1472 | 2024-02-27 04:39:17 | fids | 2 | 29872 | 385 | 1.016 | 29401.6 |
1471 | 2024-02-23 06:14:51 | fids | 1 | 13983 | 24 | 0.236 | 59250.0 |
1470 | 2024-02-22 13:35:33 | fids | 2 | 29872 | 385 | 2.000 | 14936.0 |
1469 | 2024-02-20 05:50:32 | fids | 2 | 29872 | 385 | 0.986 | 30296.1 |
1468 | 2024-02-18 08:12:36 | fids | 1 | 13983 | 24 | 0.800 | 17478.8 |
1467 | 2024-02-13 22:32:48 | fids | 2 | 29872 | 385 | 2.266 | 13182.7 |
1466 | 2024-01-28 13:20:47 | fids | 1 | 13983 | 24 | 0.216 | 64736.1 |
1465 | 2024-01-18 03:22:39 | fids | 1 | 13983 | 24 | 0.250 | 55932.0 |
1464 | 2024-01-13 03:28:52 | fids | 2 | 29872 | 385 | 0.796 | 37527.6 |
1463 | 2024-01-13 00:16:03 | fids | 1 | 13983 | 24 | 0.200 | 69915.0 |
1462 | 2024-01-10 19:06:54 | fids | 2 | 29872 | 385 | 0.890 | 33564.0 |
1461 | 2024-01-05 11:26:08 | fids | 1 | 13983 | 24 | 0.236 | 59250.0 |
1460 | 2023-12-29 08:38:18 | fids | 1 | 13983 | 24 | 0.233 | 60012.9 |
1459 | 2023-12-12 16:56:29 | fids | 2 | 29872 | 385 | 0.813 | 36742.9 |
1458 | 2023-11-28 08:59:31 | fids | 2 | 29872 | 385 | 0.733 | 40753.1 |
1457 | 2023-11-27 11:45:12 | fids | 1 | 13983 | 24 | 0.216 | 64736.1 |
1456 | 2023-11-19 16:42:39 | fids | 2 | 29872 | 385 | 0.716 | 41720.7 |
1455 | 2023-11-11 15:59:49 | fids | 1 | 13983 | 24 | 0.220 | 63559.1 |
1454 | 2023-11-08 23:18:11 | fids | 1 | 13983 | 24 | 0.233 | 60012.9 |
1453 | 2023-11-07 10:44:25 | fids | 1 | 13983 | 24 | 0.813 | 17199.3 |
1452 | 2023-11-07 10:44:03 | fids | 1 | 13983 | 24 | 0.533 | 26234.5 |
1451 | 2023-11-04 16:57:20 | fids | 2 | 29872 | 385 | 0.813 | 36742.9 |
1450 | 2023-11-03 01:51:38 | fids | 2 | 29872 | 385 | 0.720 | 41488.9 |
1449 | 2023-10-26 03:15:15 | fids | 1 | 13983 | 24 | 0.236 | 59250.0 |
1448 | 2023-10-19 21:29:48 | fids | 1 | 13983 | 24 | 0.203 | 68881.8 |
1447 | 2023-10-19 15:53:00 | fids | 2 | 29872 | 385 | 0.843 | 35435.3 |
1446 | 2023-10-19 12:50:18 | fids | 2 | 29872 | 385 | 0.890 | 33564.0 |
1445 | 2023-10-19 00:20:41 | fids | 1 | 13983 | 24 | 0.203 | 68881.8 |
1444 | 2023-10-17 02:45:38 | fids | 1 | 13983 | 24 | 0.266 | 52567.7 |
1443 | 2023-10-16 20:38:13 | fids | 2 | 29872 | 385 | 0.750 | 39829.3 |
1442 | 2023-10-11 09:30:06 | fids | 2 | 29872 | 385 | 0.953 | 31345.2 |
1441 | 2023-10-10 10:23:38 | fids | 1 | 13983 | 24 | 0.216 | 64736.1 |
1440 | 2023-10-05 01:05:04 | fids | 1 | 13983 | 24 | 0.220 | 63559.1 |
1439 | 2023-09-29 18:02:29 | fids | 1 | 13983 | 24 | 0.233 | 60012.9 |
1438 | 2023-09-22 17:47:06 | fids | 1 | 13983 | 24 | 0.206 | 67878.6 |
1437 | 2023-09-13 22:37:23 | fids | 2 | 29872 | 385 | 0.873 | 34217.6 |
1436 | 2023-09-10 13:52:14 | fids | 1 | 13983 | 24 | 0.233 | 60012.9 |
1435 | 2023-08-14 04:09:00 | fids | 1 | 13983 | 24 | 0.200 | 69915.0 |
1434 | 2023-08-13 11:28:33 | fids | 2 | 29872 | 385 | 0.720 | 41488.9 |
1433 | 2023-08-06 21:05:10 | fids | 2 | 29872 | 385 | 0.843 | 35435.3 |
1432 | 2023-08-05 01:06:19 | fids | 2 | 29872 | 385 | 0.736 | 40587.0 |
1431 | 2023-08-02 23:04:09 | fids | 2 | 29872 | 385 | 0.750 | 39829.3 |
1430 | 2023-08-01 20:28:38 | fids | 2 | 29872 | 385 | 0.733 | 40753.1 |
1429 | 2023-07-30 14:04:57 | fids | 2 | 29872 | 385 | 0.763 | 39150.7 |
1428 | 2023-07-29 02:12:47 | fids | 2 | 29872 | 385 | 0.720 | 41488.9 |
1427 | 2023-07-27 14:21:56 | fids | 2 | 29872 | 385 | 0.813 | 36742.9 |
1426 | 2023-07-27 02:08:31 | fids | 2 | 29872 | 385 | 0.720 | 41488.9 |
1425 | 2023-07-26 03:16:56 | fids | 2 | 29872 | 385 | 1.623 | 18405.4 |
1424 | 2023-07-25 02:14:25 | fids | 2 | 29872 | 385 | 0.873 | 34217.6 |
1423 | 2023-07-23 19:01:16 | fids | 2 | 29872 | 385 | 0.780 | 38297.4 |
1422 | 2023-07-22 15:50:10 | fids | 2 | 29872 | 385 | 0.813 | 36742.9 |
1421 | 2023-07-21 03:56:57 | fids | 2 | 29872 | 385 | 0.750 | 39829.3 |
1420 | 2023-07-19 17:15:49 | fids | 2 | 29872 | 385 | 0.780 | 38297.4 |
1419 | 2023-07-18 15:40:44 | fids | 1 | 13983 | 24 | 0.200 | 69915.0 |
1418 | 2023-07-16 23:41:49 | fids | 2 | 29872 | 385 | 0.716 | 41720.7 |
1417 | 2023-07-15 15:56:36 | fids | 2 | 29872 | 385 | 0.810 | 36879.0 |
1416 | 2023-07-14 19:47:12 | fids | 2 | 29872 | 385 | 0.720 | 41488.9 |
1415 | 2023-07-13 22:55:42 | fids | 2 | 29872 | 385 | 0.720 | 41488.9 |
1414 | 2023-07-09 04:49:46 | fids | 2 | 29872 | 385 | 0.800 | 37340.0 |
1413 | 2023-07-08 10:20:58 | fids | 2 | 29872 | 385 | 0.716 | 41720.7 |
1412 | 2023-07-06 21:25:33 | fids | 2 | 29872 | 385 | 0.826 | 36164.6 |
1411 | 2023-07-06 03:14:04 | fids | 2 | 29872 | 385 | 0.750 | 39829.3 |
1410 | 2023-07-05 08:27:14 | fids | 2 | 29872 | 385 | 0.813 | 36742.9 |
1409 | 2023-07-04 19:49:26 | fids | 2 | 29872 | 385 | 0.750 | 39829.3 |
1408 | 2023-07-04 04:57:07 | fids | 2 | 29872 | 385 | 0.750 | 39829.3 |
1407 | 2023-07-03 06:55:21 | fids | 2 | 29872 | 385 | 0.813 | 36742.9 |
1406 | 2023-07-02 13:57:58 | fids | 2 | 29872 | 385 | 0.813 | 36742.9 |
1405 | 2023-07-01 19:31:40 | fids | 2 | 29872 | 385 | 0.860 | 34734.9 |
1404 | 2023-07-01 02:12:42 | fids | 2 | 29872 | 385 | 0.720 | 41488.9 |
1403 | 2023-06-30 06:58:33 | fids | 2 | 29872 | 385 | 0.826 | 36164.6 |
1402 | 2023-06-29 17:13:36 | fids | 2 | 29872 | 385 | 0.766 | 38997.4 |
1401 | 2023-06-29 15:16:29 | fids | 1 | 13983 | 24 | 0.500 | 27966.0 |
1400 | 2023-06-28 03:24:37 | fids | 2 | 29872 | 385 | 0.830 | 35990.4 |
1399 | 2023-06-27 08:08:25 | fids | 2 | 29872 | 385 | 0.720 | 41488.9 |
1398 | 2023-06-27 06:47:51 | fids | 2 | 29872 | 385 | 0.750 | 39829.3 |
1397 | 2023-06-26 18:56:58 | fids | 2 | 29872 | 385 | 0.856 | 34897.2 |
1396 | 2023-06-25 21:45:15 | fids | 2 | 29872 | 385 | 0.800 | 37340.0 |
1395 | 2023-06-25 02:23:26 | fids | 2 | 29872 | 385 | 0.813 | 36742.9 |
1394 | 2023-06-24 06:40:32 | fids | 2 | 29872 | 385 | 0.736 | 40587.0 |
1393 | 2023-06-23 17:50:59 | fids | 2 | 29872 | 385 | 0.906 | 32971.3 |
1392 | 2023-06-22 18:09:58 | fids | 2 | 29872 | 385 | 0.750 | 39829.3 |
1391 | 2023-06-21 23:51:03 | fids | 2 | 29872 | 385 | 0.720 | 41488.9 |
1390 | 2023-06-21 05:56:28 | fids | 2 | 29872 | 385 | 0.750 | 39829.3 |