History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"asset"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1649 | 2024-04-28 03:17:15 | asset | 2 | 53800 | 86 | 5.626 | 9562.7 |
1648 | 2024-04-27 06:28:26 | asset | 1 | 28756 | 7 | 1.126 | 25538.2 |
1647 | 2024-04-19 02:57:20 | asset | 3 | 83667 | 1315 | 4.076 | 20526.7 |
1646 | 2024-04-05 14:53:25 | asset | 2 | 53800 | 86 | 3.376 | 15936.0 |
1645 | 2024-04-05 14:51:19 | asset | 3 | 83667 | 1315 | 4.610 | 18149.0 |
1644 | 2024-04-03 06:33:17 | asset | 2 | 53800 | 86 | 6.033 | 8917.6 |
1643 | 2024-04-03 06:33:17 | asset | 3 | 83667 | 1315 | 5.080 | 16469.9 |
1642 | 2024-04-03 06:19:58 | asset | 1 | 28756 | 7 | 0.593 | 48492.4 |
1641 | 2024-03-31 05:01:04 | asset | 3 | 83667 | 1315 | 12.813 | 6529.9 |
1640 | 2024-03-31 05:00:59 | asset | 2 | 53800 | 86 | 3.596 | 14961.1 |
1639 | 2024-03-31 04:11:54 | asset | 1 | 28756 | 7 | 0.873 | 32939.3 |
1638 | 2024-03-30 00:23:05 | asset | 3 | 83667 | 1315 | 6.453 | 12965.6 |
1637 | 2024-03-29 06:42:21 | asset | 3 | 83667 | 1315 | 11.673 | 7167.6 |
1636 | 2024-03-29 06:42:26 | asset | 2 | 53800 | 86 | 2.046 | 26295.2 |
1635 | 2024-03-29 06:41:56 | asset | 3 | 83667 | 1315 | 13.030 | 6421.1 |
1634 | 2024-03-29 06:42:04 | asset | 1 | 28756 | 7 | 1.173 | 24514.9 |
1633 | 2024-03-29 06:41:57 | asset | 2 | 53800 | 86 | 2.030 | 26502.5 |
1632 | 2024-03-29 06:41:27 | asset | 1 | 28756 | 7 | 1.093 | 26309.2 |
1631 | 2024-03-28 01:39:09 | asset | 1 | 28756 | 7 | 0.486 | 59168.7 |
1630 | 2024-03-07 12:14:45 | asset | 1 | 28756 | 7 | 0.546 | 52666.7 |
1629 | 2024-03-04 01:40:29 | asset | 2 | 53800 | 86 | 1.640 | 32804.9 |
1628 | 2024-03-04 01:20:15 | asset | 1 | 28756 | 7 | 0.453 | 63479.0 |
1627 | 2024-03-01 02:27:45 | asset | 1 | 28756 | 7 | 0.560 | 51350.0 |
1626 | 2024-02-28 02:49:04 | asset | 1 | 28756 | 7 | 0.453 | 63479.0 |
1625 | 2024-02-25 08:00:41 | asset | 1 | 28756 | 7 | 0.546 | 52666.7 |
1624 | 2024-02-02 23:49:15 | asset | 1 | 28756 | 7 | 0.516 | 55728.7 |
1623 | 2024-01-29 01:49:44 | asset | 1 | 28756 | 7 | 1.080 | 26625.9 |
1622 | 2024-01-29 01:34:37 | asset | 1 | 28756 | 7 | 0.500 | 57512.0 |
1621 | 2024-01-26 03:11:46 | asset | 1 | 28756 | 7 | 0.466 | 61708.2 |
1620 | 2024-01-12 13:14:26 | asset | 3 | 83667 | 1315 | 4.046 | 20678.9 |
1619 | 2024-01-12 13:14:27 | asset | 2 | 53800 | 86 | 1.673 | 32157.8 |
1618 | 2024-01-10 04:17:05 | asset | 3 | 83667 | 1315 | 3.343 | 25027.5 |
1617 | 2024-01-10 03:42:19 | asset | 2 | 53800 | 86 | 1.390 | 38705.0 |
1616 | 2024-01-09 20:27:08 | asset | 3 | 83667 | 1315 | 3.576 | 23396.8 |
1615 | 2024-01-09 20:27:04 | asset | 2 | 53800 | 86 | 1.376 | 39098.8 |
1614 | 2024-01-06 09:15:28 | asset | 2 | 53800 | 86 | 1.640 | 32804.9 |
1613 | 2023-12-26 01:38:45 | asset | 1 | 28756 | 7 | 0.500 | 57512.0 |
1612 | 2023-12-04 18:49:20 | asset | 1 | 28756 | 7 | 0.453 | 63479.0 |
1611 | 2023-12-03 23:10:01 | asset | 1 | 28756 | 7 | 0.516 | 55728.7 |
1610 | 2023-12-03 23:10:00 | asset | 1 | 28756 | 7 | 0.500 | 57512.0 |
1609 | 2023-12-03 23:05:01 | asset | 1 | 28756 | 7 | 1.390 | 20687.8 |
1608 | 2023-11-27 04:27:59 | asset | 2 | 53800 | 86 | 1.563 | 34421.0 |
1607 | 2023-11-26 04:06:15 | asset | 1 | 28756 | 7 | 0.516 | 55728.7 |
1606 | 2023-11-23 16:14:55 | asset | 3 | 83667 | 1315 | 9.483 | 8822.8 |
1605 | 2023-11-18 02:48:59 | asset | 1 | 28756 | 7 | 0.450 | 63902.2 |
1604 | 2023-11-15 03:21:38 | asset | 1 | 28756 | 7 | 0.436 | 65954.1 |
1603 | 2023-10-31 13:40:40 | asset | 1 | 28756 | 7 | 0.466 | 61708.2 |
1602 | 2023-10-24 02:31:05 | asset | 3 | 83667 | 1315 | 8.643 | 9680.3 |
1601 | 2023-10-23 16:17:45 | asset | 1 | 28756 | 7 | 0.500 | 57512.0 |
1600 | 2023-10-20 11:40:31 | asset | 3 | 83667 | 1315 | 3.813 | 21942.6 |
1599 | 2023-10-20 04:28:26 | asset | 1 | 28756 | 7 | 0.453 | 63479.0 |
1598 | 2023-10-19 02:51:52 | asset | 1 | 28756 | 7 | 0.453 | 63479.0 |
1597 | 2023-10-18 05:06:31 | asset | 3 | 83667 | 1315 | 3.826 | 21868.0 |
1596 | 2023-10-17 03:44:56 | asset | 2 | 53800 | 86 | 1.393 | 38621.7 |
1595 | 2023-10-14 14:18:28 | asset | 1 | 28756 | 7 | 0.483 | 59536.2 |
1594 | 2023-10-05 21:54:55 | asset | 1 | 28756 | 7 | 0.513 | 56054.6 |
1593 | 2023-09-29 18:27:03 | asset | 3 | 83667 | 1315 | 3.910 | 21398.2 |
1592 | 2023-09-28 23:12:32 | asset | 1 | 28756 | 7 | 0.516 | 55728.7 |
1591 | 2023-09-21 15:43:47 | asset | 1 | 28756 | 7 | 1.313 | 21901.0 |
1590 | 2023-09-19 19:36:48 | asset | 1 | 28756 | 7 | 0.500 | 57512.0 |
1589 | 2023-09-16 10:19:47 | asset | 1 | 28756 | 7 | 0.453 | 63479.0 |
1588 | 2023-08-11 13:14:54 | asset | 3 | 83667 | 1315 | 3.903 | 21436.6 |
1587 | 2023-07-29 10:29:24 | asset | 2 | 53800 | 86 | 1.406 | 38264.6 |
1586 | 2023-07-29 07:00:21 | asset | 3 | 83667 | 1315 | 3.373 | 24804.9 |
1585 | 2023-07-14 12:19:27 | asset | 1 | 28756 | 7 | 0.500 | 57512.0 |
1584 | 2023-06-09 02:41:08 | asset | 1 | 28756 | 7 | 0.436 | 65954.1 |
1583 | 2023-06-05 20:23:25 | asset | 1 | 28756 | 7 | 0.500 | 57512.0 |
1582 | 2023-04-19 14:29:30 | asset | 1 | 28756 | 7 | 0.440 | 65354.5 |
1581 | 2023-04-11 03:32:14 | asset | 3 | 83667 | 1315 | 4.000 | 20916.8 |
1580 | 2023-04-06 13:26:08 | asset | 2 | 53800 | 86 | 1.376 | 39098.8 |
1579 | 2023-03-31 18:37:08 | asset | 3 | 83667 | 1315 | 3.483 | 24021.5 |
1578 | 2023-03-28 22:27:49 | asset | 3 | 83667 | 1315 | 3.826 | 21868.0 |
1577 | 2023-03-10 06:26:02 | asset | 3 | 83667 | 1315 | 3.343 | 25027.5 |
1576 | 2023-02-27 20:53:44 | asset | 1 | 28756 | 7 | 0.436 | 65954.1 |
1575 | 2023-02-27 15:57:49 | asset | 3 | 83667 | 1315 | 3.936 | 21256.9 |
1574 | 2023-02-09 02:31:14 | asset | 1 | 28756 | 7 | 0.500 | 57512.0 |
1573 | 2023-01-16 13:37:27 | asset | 3 | 83667 | 1315 | 3.703 | 22594.4 |
1572 | 2023-01-12 06:21:46 | asset | 3 | 83667 | 1315 | 3.280 | 25508.2 |
1571 | 2023-01-04 21:13:49 | asset | 2 | 53800 | 86 | 1.376 | 39098.8 |
1570 | 2022-12-08 13:33:02 | asset | 1 | 28756 | 7 | 0.456 | 63061.4 |
1569 | 2022-11-18 06:06:58 | asset | 1 | 28756 | 7 | 0.483 | 59536.2 |
1568 | 2022-11-13 01:02:31 | asset | 3 | 83667 | 1315 | 3.830 | 21845.2 |
1567 | 2022-10-27 11:55:38 | asset | 3 | 83667 | 1315 | 3.313 | 25254.2 |
1566 | 2022-09-11 04:25:13 | asset | 3 | 83667 | 1315 | 3.720 | 22491.1 |
1565 | 2022-09-10 12:40:16 | asset | 2 | 53800 | 86 | 1.406 | 38264.6 |
1564 | 2022-09-07 17:25:39 | asset | 3 | 83667 | 1315 | 3.343 | 25027.5 |
1563 | 2022-09-07 15:41:55 | asset | 3 | 83667 | 1315 | 3.453 | 24230.2 |
1562 | 2022-08-11 15:30:07 | asset | 3 | 83667 | 1315 | 3.406 | 24564.6 |
1561 | 2022-08-11 09:59:00 | asset | 1 | 28756 | 7 | 0.470 | 61183.0 |
1560 | 2022-08-08 19:14:25 | asset | 1 | 28756 | 7 | 0.453 | 63479.0 |
1559 | 2022-08-06 11:47:40 | asset | 1 | 28756 | 7 | 0.436 | 65954.1 |
1558 | 2022-07-28 01:25:54 | asset | 3 | 83667 | 1315 | 3.360 | 24900.9 |
1557 | 2022-07-26 09:50:05 | asset | 3 | 83667 | 1315 | 3.750 | 22311.2 |
1556 | 2022-07-09 05:14:17 | asset | 3 | 83667 | 1315 | 3.350 | 24975.2 |
1555 | 2022-06-12 08:45:59 | asset | 3 | 83667 | 1315 | 3.733 | 22412.8 |
1554 | 2022-06-10 09:15:45 | asset | 3 | 83667 | 1315 | 4.123 | 20292.7 |
1553 | 2022-06-08 13:07:48 | asset | 3 | 83667 | 1315 | 3.346 | 25005.1 |
1552 | 2022-06-04 22:12:29 | asset | 3 | 83667 | 1315 | 3.390 | 24680.5 |
1551 | 2022-06-03 23:47:29 | asset | 3 | 83667 | 1315 | 3.686 | 22698.6 |
1550 | 2022-05-25 11:20:50 | asset | 3 | 83667 | 1315 | 3.563 | 23482.2 |