History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"based"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1536 | 2024-03-27 02:05:51 | based | 1 | 28756 | 21 | 0.953 | 30174.2 |
1535 | 2024-02-25 17:30:50 | based | 1 | 28756 | 21 | 0.533 | 53951.2 |
1534 | 2024-02-24 22:38:02 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1533 | 2024-01-26 06:03:43 | based | 1 | 28756 | 21 | 0.593 | 48492.4 |
1532 | 2023-12-11 08:26:53 | based | 2 | 53800 | 340 | 2.546 | 21131.2 |
1531 | 2023-12-06 10:32:15 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1530 | 2023-11-27 07:30:54 | based | 2 | 53800 | 340 | 1.406 | 38264.6 |
1529 | 2023-11-26 18:16:48 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1528 | 2023-11-26 09:14:40 | based | 2 | 53800 | 340 | 1.673 | 32157.8 |
1527 | 2023-11-10 17:46:32 | based | 1 | 28756 | 21 | 0.483 | 59536.2 |
1526 | 2023-11-09 23:35:09 | based | 2 | 53800 | 340 | 1.406 | 38264.6 |
1525 | 2023-11-09 22:00:30 | based | 1 | 28756 | 21 | 0.503 | 57169.0 |
1524 | 2023-10-26 15:04:39 | based | 1 | 28756 | 21 | 0.470 | 61183.0 |
1523 | 2023-10-20 11:45:21 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1522 | 2023-10-17 07:23:39 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1521 | 2023-10-11 20:59:54 | based | 1 | 28756 | 21 | 0.470 | 61183.0 |
1520 | 2023-10-11 10:02:29 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1519 | 2023-10-03 23:58:25 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1518 | 2023-09-22 22:19:33 | based | 1 | 28756 | 21 | 0.516 | 55728.7 |
1517 | 2023-09-20 20:52:29 | based | 2 | 53800 | 340 | 1.703 | 31591.3 |
1516 | 2023-09-20 18:32:26 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1515 | 2023-09-17 03:33:45 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1514 | 2023-09-11 05:16:13 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1513 | 2023-09-10 16:39:56 | based | 2 | 53800 | 340 | 2.033 | 26463.4 |
1512 | 2023-09-09 02:10:17 | based | 2 | 53800 | 340 | 1.393 | 38621.7 |
1511 | 2023-09-05 13:07:47 | based | 2 | 53800 | 340 | 1.643 | 32745.0 |
1510 | 2023-08-27 10:50:57 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1509 | 2023-08-24 07:44:07 | based | 2 | 53800 | 340 | 1.406 | 38264.6 |
1508 | 2023-07-07 09:29:12 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1507 | 2023-07-03 04:03:17 | based | 2 | 53800 | 340 | 1.406 | 38264.6 |
1506 | 2023-07-01 17:21:21 | based | 1 | 28756 | 21 | 1.076 | 26724.9 |
1505 | 2023-05-28 20:28:40 | based | 2 | 53800 | 340 | 1.376 | 39098.8 |
1504 | 2023-04-09 13:09:38 | based | 1 | 28756 | 21 | 0.440 | 65354.5 |
1503 | 2023-03-31 14:43:38 | based | 2 | 53800 | 340 | 1.546 | 34799.5 |
1502 | 2023-03-28 23:02:08 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1501 | 2023-03-27 00:24:53 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1500 | 2023-03-06 19:16:34 | based | 2 | 53800 | 340 | 1.406 | 38264.6 |
1499 | 2023-01-23 17:57:54 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1498 | 2022-12-23 19:12:12 | based | 1 | 28756 | 21 | 0.516 | 55728.7 |
1497 | 2022-12-13 11:55:56 | based | 2 | 53800 | 340 | 1.593 | 33772.8 |
1496 | 2022-11-19 02:31:16 | based | 1 | 28756 | 21 | 0.483 | 59536.2 |
1495 | 2022-09-09 13:14:09 | based | 1 | 28756 | 21 | 0.466 | 61708.2 |
1494 | 2022-08-02 06:37:20 | based | 2 | 53800 | 340 | 1.436 | 37465.2 |
1493 | 2022-07-13 13:51:48 | based | 1 | 28756 | 21 | 0.440 | 65354.5 |
1492 | 2022-07-11 03:46:52 | based | 1 | 28756 | 21 | 0.450 | 63902.2 |
1491 | 2022-07-08 23:10:58 | based | 1 | 28756 | 21 | 0.436 | 65954.1 |
1490 | 2022-05-24 19:02:27 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1489 | 2022-05-21 09:22:02 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1488 | 2022-03-11 15:07:22 | based | 1 | 28756 | 21 | 0.513 | 56054.6 |
1487 | 2022-02-13 05:57:49 | based | 1 | 28756 | 21 | 0.436 | 65954.1 |
1486 | 2021-12-19 19:49:22 | based | 1 | 28756 | 21 | 0.516 | 55728.7 |
1485 | 2021-12-17 17:38:58 | based | 1 | 28756 | 21 | 0.530 | 54256.6 |
1484 | 2021-11-12 02:46:27 | based | 1 | 28756 | 21 | 0.470 | 61183.0 |
1483 | 2021-10-20 18:44:19 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1482 | 2021-09-10 17:44:47 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1481 | 2021-09-08 12:36:19 | based | 1 | 28756 | 21 | 0.483 | 59536.2 |
1480 | 2021-08-24 02:12:57 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1479 | 2021-08-21 21:49:10 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1478 | 2021-08-12 13:32:14 | based | 1 | 28756 | 21 | 0.500 | 57512.0 |
1477 | 2021-07-06 12:27:05 | based | 2 | 53800 | 340 | 1.686 | 31909.8 |
1476 | 2021-06-15 00:45:27 | based | 2 | 53800 | 340 | 1.406 | 38264.6 |
1475 | 2021-06-13 20:31:51 | based | 2 | 53800 | 340 | 1.436 | 37465.2 |
1474 | 2021-06-13 15:04:09 | based | 2 | 53800 | 340 | 2.983 | 18035.5 |
1473 | 2021-06-11 04:53:27 | based | 2 | 53800 | 340 | 1.406 | 38264.6 |
1472 | 2021-06-09 17:34:49 | based | 2 | 53800 | 340 | 1.623 | 33148.5 |
1471 | 2021-06-09 01:10:14 | based | 2 | 53800 | 340 | 1.656 | 32487.9 |
1470 | 2021-05-23 19:23:18 | based | 1 | 28756 | 21 | 0.453 | 63479.0 |
1469 | 2021-05-17 07:03:42 | based | 2 | 53800 | 340 | 1.500 | 35866.7 |
1468 | 2021-05-11 07:35:00 | based | 2 | 53800 | 340 | 1.720 | 31279.1 |
1467 | 2021-05-08 02:20:10 | based | 2 | 53800 | 340 | 1.690 | 31834.3 |
1466 | 2021-05-01 15:40:10 | based | 1 | 28756 | 21 | 0.466 | 61708.2 |
1465 | 2021-04-30 13:29:30 | based | 1 | 28756 | 21 | 1.000 | 28756.0 |
1464 | 2021-04-20 15:03:36 | based | 2 | 53800 | 340 | 1.690 | 31834.3 |
1463 | 2021-04-18 03:09:16 | based | 2 | 53800 | 340 | 1.780 | 30224.7 |
1462 | 2021-04-17 07:24:39 | based | 2 | 53800 | 340 | 1.626 | 33087.3 |
1461 | 2021-04-13 19:42:59 | based | 2 | 53800 | 340 | 1.593 | 33772.8 |
1460 | 2021-04-13 02:33:53 | based | 2 | 53800 | 340 | 1.703 | 31591.3 |
1459 | 2021-04-12 10:02:42 | based | 2 | 53800 | 340 | 1.453 | 37026.8 |
1458 | 2021-04-11 18:36:49 | based | 2 | 53800 | 340 | 1.580 | 34050.6 |
1457 | 2021-04-10 01:51:57 | based | 2 | 53800 | 340 | 3.203 | 16796.8 |
1456 | 2021-04-08 03:23:04 | based | 2 | 53800 | 340 | 1.593 | 33772.8 |
1455 | 2021-04-07 10:01:17 | based | 2 | 53800 | 340 | 1.610 | 33416.1 |
1454 | 2021-04-07 02:38:39 | based | 2 | 53800 | 340 | 1.436 | 37465.2 |
1453 | 2021-04-06 12:18:42 | based | 2 | 53800 | 340 | 1.483 | 36277.8 |
1452 | 2021-04-05 12:52:55 | based | 2 | 53800 | 340 | 1.656 | 32487.9 |
1451 | 2021-04-03 05:59:53 | based | 2 | 53800 | 340 | 1.563 | 34421.0 |
1450 | 2021-04-02 15:17:10 | based | 2 | 53800 | 340 | 1.580 | 34050.6 |
1449 | 2021-04-01 22:02:39 | based | 2 | 53800 | 340 | 1.376 | 39098.8 |
1448 | 2021-03-31 17:30:38 | based | 2 | 53800 | 340 | 1.576 | 34137.1 |
1447 | 2021-03-31 02:45:02 | based | 2 | 53800 | 340 | 1.420 | 37887.3 |
1446 | 2021-03-30 10:46:42 | based | 2 | 53800 | 340 | 1.423 | 37807.4 |
1445 | 2021-03-29 20:33:32 | based | 2 | 53800 | 340 | 1.390 | 38705.0 |
1444 | 2021-03-27 20:44:40 | based | 2 | 53800 | 340 | 1.390 | 38705.0 |
1443 | 2021-03-23 05:01:37 | based | 2 | 53800 | 340 | 1.423 | 37807.4 |
1442 | 2021-03-21 07:37:26 | based | 2 | 53800 | 340 | 1.423 | 37807.4 |
1441 | 2021-03-20 02:01:50 | based | 2 | 53800 | 340 | 1.640 | 32804.9 |
1440 | 2021-03-18 10:21:19 | based | 2 | 53800 | 340 | 1.690 | 31834.3 |
1439 | 2021-03-17 15:57:21 | based | 2 | 53800 | 340 | 1.390 | 38705.0 |
1438 | 2021-03-17 05:46:33 | based | 2 | 53800 | 340 | 1.406 | 38264.6 |
1437 | 2021-03-16 21:35:12 | based | 2 | 53800 | 340 | 1.563 | 34421.0 |