History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"block"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1548 | 2024-04-22 08:56:19 | block | 1 | 28756 | 11 | 1.936 | 14853.3 |
1547 | 2024-04-03 02:49:27 | block | 1 | 28756 | 11 | 1.170 | 24577.8 |
1546 | 2024-03-31 03:45:30 | block | 1 | 28756 | 11 | 0.483 | 59536.2 |
1545 | 2024-03-30 03:19:08 | block | 3 | 83667 | 847 | 13.360 | 6262.5 |
1544 | 2024-03-29 07:19:15 | block | 1 | 28756 | 11 | 1.596 | 18017.5 |
1543 | 2024-03-29 03:08:56 | block | 2 | 53800 | 99 | 1.936 | 27789.3 |
1542 | 2024-03-28 22:32:00 | block | 1 | 28756 | 11 | 0.563 | 51076.4 |
1541 | 2024-03-28 18:51:23 | block | 2 | 53800 | 99 | 4.216 | 12760.9 |
1540 | 2024-03-28 18:14:39 | block | 1 | 28756 | 11 | 1.140 | 25224.6 |
1539 | 2024-03-28 10:10:23 | block | 3 | 83667 | 847 | 5.703 | 14670.7 |
1538 | 2024-03-25 19:15:31 | block | 2 | 53800 | 99 | 4.233 | 12709.7 |
1537 | 2024-03-25 19:00:01 | block | 2 | 53800 | 99 | 1.706 | 31535.8 |
1536 | 2024-03-25 18:59:58 | block | 1 | 28756 | 11 | 0.530 | 54256.6 |
1535 | 2024-03-25 18:59:26 | block | 3 | 83667 | 847 | 6.173 | 13553.7 |
1534 | 2024-03-23 13:46:49 | block | 3 | 83667 | 847 | 3.843 | 21771.3 |
1533 | 2024-03-23 05:25:54 | block | 3 | 83667 | 847 | 4.093 | 20441.5 |
1532 | 2024-02-27 08:26:42 | block | 3 | 83667 | 847 | 4.516 | 18526.8 |
1531 | 2024-02-26 22:51:43 | block | 3 | 83667 | 847 | 3.986 | 20990.2 |
1530 | 2024-02-26 22:51:44 | block | 2 | 53800 | 99 | 1.703 | 31591.3 |
1529 | 2024-02-26 19:32:47 | block | 1 | 28756 | 11 | 0.440 | 65354.5 |
1528 | 2024-02-24 02:59:41 | block | 1 | 28756 | 11 | 0.436 | 65954.1 |
1527 | 2024-02-01 07:38:04 | block | 2 | 53800 | 99 | 1.626 | 33087.3 |
1526 | 2024-01-30 16:19:12 | block | 2 | 53800 | 99 | 1.376 | 39098.8 |
1525 | 2024-01-30 16:16:40 | block | 3 | 83667 | 847 | 3.830 | 21845.2 |
1524 | 2024-01-30 15:46:51 | block | 3 | 83667 | 847 | 3.846 | 21754.3 |
1523 | 2024-01-26 21:03:07 | block | 1 | 28756 | 11 | 0.483 | 59536.2 |
1522 | 2024-01-23 05:55:30 | block | 3 | 83667 | 847 | 3.170 | 26393.4 |
1521 | 2024-01-17 08:24:26 | block | 3 | 83667 | 847 | 3.670 | 22797.5 |
1520 | 2024-01-14 04:54:24 | block | 3 | 83667 | 847 | 3.923 | 21327.3 |
1519 | 2024-01-13 09:34:31 | block | 3 | 83667 | 847 | 3.983 | 21006.0 |
1518 | 2024-01-07 21:01:35 | block | 3 | 83667 | 847 | 3.470 | 24111.5 |
1517 | 2024-01-04 03:38:17 | block | 3 | 83667 | 847 | 5.126 | 16322.1 |
1516 | 2023-12-21 15:30:57 | block | 2 | 53800 | 99 | 1.406 | 38264.6 |
1515 | 2023-12-20 03:54:21 | block | 3 | 83667 | 847 | 3.940 | 21235.3 |
1514 | 2023-12-14 02:08:42 | block | 2 | 53800 | 99 | 1.550 | 34709.7 |
1513 | 2023-12-05 18:48:30 | block | 1 | 28756 | 11 | 0.500 | 57512.0 |
1512 | 2023-12-05 16:53:54 | block | 2 | 53800 | 99 | 1.453 | 37026.8 |
1511 | 2023-12-03 05:18:10 | block | 2 | 53800 | 99 | 1.470 | 36598.6 |
1510 | 2023-11-27 07:24:12 | block | 3 | 83667 | 847 | 3.266 | 25617.6 |
1509 | 2023-11-22 13:52:30 | block | 3 | 83667 | 847 | 3.280 | 25508.2 |
1508 | 2023-11-17 22:31:15 | block | 3 | 83667 | 847 | 3.703 | 22594.4 |
1507 | 2023-11-14 13:54:08 | block | 3 | 83667 | 847 | 3.220 | 25983.5 |
1506 | 2023-11-12 07:45:37 | block | 1 | 28756 | 11 | 0.486 | 59168.7 |
1505 | 2023-11-11 14:27:42 | block | 1 | 28756 | 11 | 0.503 | 57169.0 |
1504 | 2023-11-08 11:55:22 | block | 3 | 83667 | 847 | 3.483 | 24021.5 |
1503 | 2023-11-04 01:50:48 | block | 1 | 28756 | 11 | 0.440 | 65354.5 |
1502 | 2023-11-01 00:00:05 | block | 3 | 83667 | 847 | 3.250 | 25743.7 |
1501 | 2023-10-30 22:48:29 | block | 3 | 83667 | 847 | 3.626 | 23074.2 |
1500 | 2023-10-27 12:10:53 | block | 3 | 83667 | 847 | 5.860 | 14277.6 |
1499 | 2023-10-27 12:10:55 | block | 2 | 53800 | 99 | 3.373 | 15950.2 |
1498 | 2023-10-26 11:09:26 | block | 1 | 28756 | 11 | 1.000 | 28756.0 |
1497 | 2023-10-19 20:17:43 | block | 1 | 28756 | 11 | 1.013 | 28387.0 |
1496 | 2023-10-18 12:36:19 | block | 1 | 28756 | 11 | 0.500 | 57512.0 |
1495 | 2023-10-13 14:20:45 | block | 1 | 28756 | 11 | 0.436 | 65954.1 |
1494 | 2023-10-07 12:20:15 | block | 1 | 28756 | 11 | 0.500 | 57512.0 |
1493 | 2023-09-30 04:23:55 | block | 3 | 83667 | 847 | 3.266 | 25617.6 |
1492 | 2023-09-28 00:38:28 | block | 3 | 83667 | 847 | 4.283 | 19534.7 |
1491 | 2023-09-25 09:07:33 | block | 1 | 28756 | 11 | 0.440 | 65354.5 |
1490 | 2023-09-20 11:33:23 | block | 3 | 83667 | 847 | 3.216 | 26015.9 |
1489 | 2023-09-19 10:24:54 | block | 1 | 28756 | 11 | 0.483 | 59536.2 |
1488 | 2023-09-12 13:23:56 | block | 1 | 28756 | 11 | 0.483 | 59536.2 |
1487 | 2023-09-01 14:51:37 | block | 2 | 53800 | 99 | 1.533 | 35094.6 |
1486 | 2023-08-27 11:51:34 | block | 3 | 83667 | 847 | 3.690 | 22674.0 |
1485 | 2023-08-13 07:38:08 | block | 3 | 83667 | 847 | 3.983 | 21006.0 |
1484 | 2023-08-08 22:18:20 | block | 3 | 83667 | 847 | 3.966 | 21096.1 |
1483 | 2023-07-15 20:23:44 | block | 3 | 83667 | 847 | 3.450 | 24251.3 |
1482 | 2023-07-14 23:15:54 | block | 3 | 83667 | 847 | 3.923 | 21327.3 |
1481 | 2023-07-13 14:57:01 | block | 1 | 28756 | 11 | 0.440 | 65354.5 |
1480 | 2023-07-08 03:57:50 | block | 1 | 28756 | 11 | 0.486 | 59168.7 |
1479 | 2023-06-29 20:28:25 | block | 3 | 83667 | 847 | 3.656 | 22884.8 |
1478 | 2023-06-23 04:23:05 | block | 3 | 83667 | 847 | 3.233 | 25879.1 |
1477 | 2023-05-18 08:48:40 | block | 2 | 53800 | 99 | 1.343 | 40059.6 |
1476 | 2023-04-26 21:22:42 | block | 3 | 83667 | 847 | 3.220 | 25983.5 |
1475 | 2023-04-11 17:06:28 | block | 1 | 28756 | 11 | 0.420 | 68466.7 |
1474 | 2023-04-06 01:27:00 | block | 1 | 28756 | 11 | 0.530 | 54256.6 |
1473 | 2023-02-26 10:13:01 | block | 2 | 53800 | 99 | 1.343 | 40059.6 |
1472 | 2023-02-22 17:23:49 | block | 3 | 83667 | 847 | 3.233 | 25879.1 |
1471 | 2023-01-30 16:44:29 | block | 3 | 83667 | 847 | 3.220 | 25983.5 |
1470 | 2023-01-23 08:38:30 | block | 1 | 28756 | 11 | 0.423 | 67981.1 |
1469 | 2023-01-04 17:22:40 | block | 3 | 83667 | 847 | 3.533 | 23681.6 |
1468 | 2023-01-02 08:34:00 | block | 3 | 83667 | 847 | 3.203 | 26121.4 |
1467 | 2022-12-28 02:25:50 | block | 1 | 28756 | 11 | 0.436 | 65954.1 |
1466 | 2022-12-07 20:12:58 | block | 2 | 53800 | 99 | 1.346 | 39970.3 |
1465 | 2022-11-27 03:49:58 | block | 3 | 83667 | 847 | 4.360 | 19189.7 |
1464 | 2022-11-25 05:54:39 | block | 1 | 28756 | 11 | 0.416 | 69125.0 |
1463 | 2022-11-20 01:36:40 | block | 1 | 28756 | 11 | 0.483 | 59536.2 |
1462 | 2022-11-18 07:10:35 | block | 3 | 83667 | 847 | 3.263 | 25641.1 |
1461 | 2022-11-12 00:45:39 | block | 3 | 83667 | 847 | 3.296 | 25384.4 |
1460 | 2022-10-27 21:54:32 | block | 3 | 83667 | 847 | 3.593 | 23286.1 |
1459 | 2022-10-21 05:21:28 | block | 3 | 83667 | 847 | 3.266 | 25617.6 |
1458 | 2022-10-02 20:06:00 | block | 3 | 83667 | 847 | 3.783 | 22116.6 |
1457 | 2022-09-21 22:10:23 | block | 3 | 83667 | 847 | 4.140 | 20209.4 |
1456 | 2022-09-12 09:20:09 | block | 1 | 28756 | 11 | 0.436 | 65954.1 |
1455 | 2022-09-10 02:59:15 | block | 1 | 28756 | 11 | 0.436 | 65954.1 |
1454 | 2022-08-22 14:02:42 | block | 3 | 83667 | 847 | 3.733 | 22412.8 |
1453 | 2022-07-14 04:55:43 | block | 1 | 28756 | 11 | 0.500 | 57512.0 |
1452 | 2022-07-11 17:42:59 | block | 1 | 28756 | 11 | 0.453 | 63479.0 |
1451 | 2022-06-23 13:03:32 | block | 3 | 83667 | 847 | 3.203 | 26121.4 |
1450 | 2022-06-13 18:57:25 | block | 3 | 83667 | 847 | 3.156 | 26510.5 |
1449 | 2022-05-15 01:06:14 | block | 1 | 28756 | 11 | 0.453 | 63479.0 |