History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"names"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1684 | 2024-04-17 10:21:11 | names | 1 | 28756 | 20 | 0.640 | 44931.3 |
1683 | 2024-04-17 08:40:41 | names | 1 | 28756 | 20 | 0.516 | 55728.7 |
1682 | 2024-04-17 08:34:27 | names | 1 | 28756 | 20 | 0.656 | 43835.4 |
1681 | 2024-04-11 02:24:40 | names | 2 | 53800 | 347 | 1.546 | 34799.5 |
1680 | 2024-04-03 04:47:27 | names | 1 | 28756 | 20 | 1.123 | 25606.4 |
1679 | 2024-03-31 03:07:22 | names | 1 | 28756 | 20 | 1.436 | 20025.1 |
1678 | 2024-03-28 11:36:53 | names | 1 | 28756 | 20 | 0.500 | 57512.0 |
1677 | 2024-03-28 11:36:42 | names | 2 | 53800 | 347 | 1.466 | 36698.5 |
1676 | 2024-03-27 19:13:11 | names | 2 | 53800 | 347 | 1.796 | 29955.5 |
1675 | 2024-03-27 02:05:03 | names | 1 | 28756 | 20 | 0.420 | 68466.7 |
1674 | 2024-03-13 08:59:55 | names | 1 | 28756 | 20 | 0.436 | 65954.1 |
1673 | 2024-03-04 02:10:56 | names | 2 | 53800 | 347 | 1.423 | 37807.4 |
1672 | 2024-03-04 02:10:32 | names | 1 | 28756 | 20 | 0.486 | 59168.7 |
1671 | 2024-03-01 01:21:49 | names | 1 | 28756 | 20 | 0.513 | 56054.6 |
1670 | 2024-02-29 19:20:58 | names | 2 | 53800 | 347 | 1.533 | 35094.6 |
1669 | 2024-02-29 19:03:14 | names | 2 | 53800 | 347 | 1.626 | 33087.3 |
1668 | 2024-02-28 12:45:21 | names | 2 | 53800 | 347 | 1.703 | 31591.3 |
1667 | 2024-02-27 04:49:51 | names | 2 | 53800 | 347 | 3.750 | 14346.7 |
1666 | 2024-02-26 14:30:52 | names | 2 | 53800 | 347 | 2.233 | 24093.1 |
1665 | 2024-02-25 18:34:37 | names | 2 | 53800 | 347 | 3.656 | 14715.5 |
1664 | 2024-02-25 17:27:27 | names | 1 | 28756 | 20 | 1.250 | 23004.8 |
1663 | 2024-02-24 22:51:55 | names | 2 | 53800 | 347 | 1.670 | 32215.6 |
1662 | 2024-02-23 19:45:53 | names | 2 | 53800 | 347 | 1.500 | 35866.7 |
1661 | 2024-02-22 20:33:19 | names | 2 | 53800 | 347 | 1.436 | 37465.2 |
1660 | 2024-02-02 22:12:23 | names | 1 | 28756 | 20 | 1.046 | 27491.4 |
1659 | 2024-01-30 11:48:51 | names | 1 | 28756 | 20 | 0.516 | 55728.7 |
1658 | 2024-01-26 06:12:50 | names | 1 | 28756 | 20 | 0.516 | 55728.7 |
1657 | 2024-01-25 21:28:41 | names | 1 | 28756 | 20 | 0.500 | 57512.0 |
1656 | 2024-01-15 08:34:59 | names | 2 | 53800 | 347 | 1.376 | 39098.8 |
1655 | 2023-12-28 17:40:38 | names | 1 | 28756 | 20 | 0.453 | 63479.0 |
1654 | 2023-12-22 17:46:54 | names | 2 | 53800 | 347 | 1.390 | 38705.0 |
1653 | 2023-12-20 22:28:09 | names | 2 | 53800 | 347 | 2.546 | 21131.2 |
1652 | 2023-12-16 23:30:58 | names | 2 | 53800 | 347 | 1.563 | 34421.0 |
1651 | 2023-12-15 11:59:22 | names | 2 | 53800 | 347 | 1.703 | 31591.3 |
1650 | 2023-12-12 01:39:36 | names | 2 | 53800 | 347 | 1.403 | 38346.4 |
1649 | 2023-12-11 00:39:01 | names | 2 | 53800 | 347 | 1.406 | 38264.6 |
1648 | 2023-12-10 00:43:41 | names | 2 | 53800 | 347 | 1.406 | 38264.6 |
1647 | 2023-12-09 12:06:16 | names | 2 | 53800 | 347 | 1.516 | 35488.1 |
1646 | 2023-12-06 14:31:00 | names | 2 | 53800 | 347 | 1.733 | 31044.4 |
1645 | 2023-12-05 19:00:29 | names | 2 | 53800 | 347 | 1.563 | 34421.0 |
1644 | 2023-12-04 14:17:45 | names | 2 | 53800 | 347 | 1.420 | 37887.3 |
1643 | 2023-12-03 02:49:37 | names | 2 | 53800 | 347 | 1.563 | 34421.0 |
1642 | 2023-12-02 04:57:11 | names | 1 | 28756 | 20 | 0.546 | 52666.7 |
1641 | 2023-12-01 11:24:48 | names | 2 | 53800 | 347 | 1.656 | 32487.9 |
1640 | 2023-11-27 07:36:42 | names | 2 | 53800 | 347 | 1.406 | 38264.6 |
1639 | 2023-11-25 23:36:59 | names | 2 | 53800 | 347 | 1.593 | 33772.8 |
1638 | 2023-11-25 23:30:44 | names | 2 | 53800 | 347 | 1.703 | 31591.3 |
1637 | 2023-11-25 04:28:45 | names | 2 | 53800 | 347 | 1.500 | 35866.7 |
1636 | 2023-11-24 03:30:23 | names | 2 | 53800 | 347 | 1.390 | 38705.0 |
1635 | 2023-11-23 04:14:00 | names | 2 | 53800 | 347 | 1.563 | 34421.0 |
1634 | 2023-11-22 17:59:30 | names | 2 | 53800 | 347 | 1.423 | 37807.4 |
1633 | 2023-11-22 12:11:19 | names | 1 | 28756 | 20 | 0.436 | 65954.1 |
1632 | 2023-11-21 15:55:44 | names | 2 | 53800 | 347 | 1.453 | 37026.8 |
1631 | 2023-11-20 01:46:13 | names | 2 | 53800 | 347 | 1.656 | 32487.9 |
1630 | 2023-11-19 02:25:15 | names | 2 | 53800 | 347 | 1.690 | 31834.3 |
1629 | 2023-11-17 20:40:22 | names | 2 | 53800 | 347 | 2.390 | 22510.5 |
1628 | 2023-11-15 22:10:19 | names | 2 | 53800 | 347 | 1.390 | 38705.0 |
1627 | 2023-11-15 01:19:04 | names | 2 | 53800 | 347 | 1.843 | 29191.5 |
1626 | 2023-11-14 01:13:01 | names | 2 | 53800 | 347 | 1.436 | 37465.2 |
1625 | 2023-11-13 12:38:58 | names | 1 | 28756 | 20 | 0.486 | 59168.7 |
1624 | 2023-11-11 13:32:58 | names | 1 | 28756 | 20 | 1.013 | 28387.0 |
1623 | 2023-11-10 18:09:40 | names | 2 | 53800 | 347 | 1.640 | 32804.9 |
1622 | 2023-11-10 02:41:55 | names | 1 | 28756 | 20 | 0.483 | 59536.2 |
1621 | 2023-11-09 17:12:09 | names | 2 | 53800 | 347 | 1.516 | 35488.1 |
1620 | 2023-11-09 04:05:36 | names | 1 | 28756 | 20 | 0.470 | 61183.0 |
1619 | 2023-11-08 00:00:36 | names | 2 | 53800 | 347 | 1.390 | 38705.0 |
1618 | 2023-11-06 19:56:19 | names | 2 | 53800 | 347 | 1.606 | 33499.4 |
1617 | 2023-11-04 18:44:26 | names | 2 | 53800 | 347 | 1.623 | 33148.5 |
1616 | 2023-11-04 13:55:51 | names | 1 | 28756 | 20 | 0.440 | 65354.5 |
1615 | 2023-11-04 07:15:03 | names | 2 | 53800 | 347 | 1.406 | 38264.6 |
1614 | 2023-11-03 16:33:31 | names | 1 | 28756 | 20 | 0.966 | 29768.1 |
1613 | 2023-11-03 01:28:12 | names | 2 | 53800 | 347 | 1.420 | 37887.3 |
1612 | 2023-11-01 01:10:00 | names | 2 | 53800 | 347 | 1.610 | 33416.1 |
1611 | 2023-10-30 01:55:36 | names | 2 | 53800 | 347 | 1.423 | 37807.4 |
1610 | 2023-10-27 00:44:56 | names | 1 | 28756 | 20 | 0.923 | 31154.9 |
1609 | 2023-10-26 10:12:43 | names | 2 | 53800 | 347 | 1.703 | 31591.3 |
1608 | 2023-10-26 06:08:49 | names | 2 | 53800 | 347 | 1.516 | 35488.1 |
1607 | 2023-10-25 06:00:01 | names | 2 | 53800 | 347 | 1.470 | 36598.6 |
1606 | 2023-10-23 06:03:05 | names | 2 | 53800 | 347 | 1.390 | 38705.0 |
1605 | 2023-10-22 09:50:26 | names | 2 | 53800 | 347 | 1.563 | 34421.0 |
1604 | 2023-10-20 09:46:48 | names | 1 | 28756 | 20 | 0.436 | 65954.1 |
1603 | 2023-10-20 09:39:55 | names | 2 | 53800 | 347 | 1.703 | 31591.3 |
1602 | 2023-10-18 03:43:26 | names | 2 | 53800 | 347 | 1.373 | 39184.3 |
1601 | 2023-10-17 08:46:57 | names | 1 | 28756 | 20 | 0.436 | 65954.1 |
1600 | 2023-10-17 08:12:55 | names | 2 | 53800 | 347 | 1.733 | 31044.4 |
1599 | 2023-10-14 06:01:02 | names | 2 | 53800 | 347 | 1.733 | 31044.4 |
1598 | 2023-10-11 15:47:00 | names | 1 | 28756 | 20 | 0.440 | 65354.5 |
1597 | 2023-10-11 14:49:49 | names | 2 | 53800 | 347 | 1.483 | 36277.8 |
1596 | 2023-10-11 10:59:48 | names | 2 | 53800 | 347 | 1.393 | 38621.7 |
1595 | 2023-10-09 22:09:17 | names | 2 | 53800 | 347 | 1.423 | 37807.4 |
1594 | 2023-10-06 12:42:43 | names | 2 | 53800 | 347 | 1.393 | 38621.7 |
1593 | 2023-10-04 00:11:47 | names | 1 | 28756 | 20 | 0.436 | 65954.1 |
1592 | 2023-10-03 22:07:39 | names | 2 | 53800 | 347 | 2.950 | 18237.3 |
1591 | 2023-10-03 21:47:09 | names | 2 | 53800 | 347 | 1.593 | 33772.8 |
1590 | 2023-10-01 18:47:53 | names | 2 | 53800 | 347 | 1.423 | 37807.4 |
1589 | 2023-09-29 15:05:22 | names | 2 | 53800 | 347 | 1.373 | 39184.3 |
1588 | 2023-09-27 05:11:01 | names | 2 | 53800 | 347 | 1.656 | 32487.9 |
1587 | 2023-09-25 22:55:16 | names | 2 | 53800 | 347 | 1.530 | 35163.4 |
1586 | 2023-09-23 21:30:12 | names | 2 | 53800 | 347 | 1.530 | 35163.4 |
1585 | 2023-09-23 06:28:46 | names | 1 | 28756 | 20 | 0.436 | 65954.1 |