History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"male"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1659 | 2024-04-27 00:06:24 | male | 1 | 13983 | 33 | 0.266 | 52567.7 |
1658 | 2024-04-05 05:48:27 | male | 2 | 29872 | 514 | 1.376 | 21709.3 |
1657 | 2024-04-05 05:46:11 | male | 1 | 13983 | 33 | 0.810 | 17263.0 |
1656 | 2024-04-05 01:22:41 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1655 | 2024-04-02 18:36:01 | male | 1 | 13983 | 33 | 0.313 | 44674.1 |
1654 | 2024-03-26 08:22:31 | male | 1 | 13983 | 33 | 0.253 | 55268.8 |
1653 | 2024-03-12 08:43:51 | male | 1 | 13983 | 33 | 0.470 | 29751.1 |
1652 | 2024-03-05 20:42:29 | male | 1 | 13983 | 33 | 0.830 | 16847.0 |
1651 | 2024-03-05 16:55:11 | male | 2 | 29872 | 514 | 3.140 | 9513.4 |
1650 | 2024-03-05 16:53:42 | male | 1 | 13983 | 33 | 0.233 | 60012.9 |
1649 | 2024-02-26 16:33:07 | male | 1 | 13983 | 33 | 0.280 | 49939.3 |
1648 | 2024-02-05 15:36:46 | male | 2 | 29872 | 514 | 0.953 | 31345.2 |
1647 | 2024-02-04 14:33:58 | male | 2 | 29872 | 514 | 1.030 | 29001.9 |
1646 | 2024-02-04 14:33:10 | male | 1 | 13983 | 33 | 0.670 | 20870.1 |
1645 | 2024-01-26 03:30:52 | male | 1 | 13983 | 33 | 0.516 | 27098.8 |
1644 | 2024-01-25 18:35:25 | male | 1 | 13983 | 33 | 0.546 | 25609.9 |
1643 | 2024-01-21 10:36:30 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1642 | 2024-01-05 13:04:03 | male | 1 | 13983 | 33 | 0.216 | 64736.1 |
1641 | 2023-12-30 10:25:32 | male | 2 | 29872 | 514 | 0.843 | 35435.3 |
1640 | 2023-12-28 03:02:49 | male | 2 | 29872 | 514 | 0.906 | 32971.3 |
1639 | 2023-12-27 21:25:29 | male | 1 | 13983 | 33 | 0.266 | 52567.7 |
1638 | 2023-12-15 06:07:23 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1637 | 2023-12-03 11:43:46 | male | 1 | 13983 | 33 | 0.236 | 59250.0 |
1636 | 2023-12-03 11:43:46 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1635 | 2023-11-26 22:15:04 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1634 | 2023-11-23 00:51:12 | male | 1 | 13983 | 33 | 0.563 | 24836.6 |
1633 | 2023-11-22 18:53:35 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1632 | 2023-11-18 00:06:04 | male | 1 | 13983 | 33 | 0.216 | 64736.1 |
1631 | 2023-11-14 02:08:50 | male | 2 | 29872 | 514 | 0.763 | 39150.7 |
1630 | 2023-11-11 14:20:07 | male | 2 | 29872 | 514 | 0.890 | 33564.0 |
1629 | 2023-11-08 03:24:12 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1628 | 2023-11-07 21:47:34 | male | 1 | 13983 | 33 | 0.233 | 60012.9 |
1627 | 2023-11-07 11:02:05 | male | 1 | 13983 | 33 | 0.813 | 17199.3 |
1626 | 2023-11-07 11:02:03 | male | 1 | 13983 | 33 | 0.533 | 26234.5 |
1625 | 2023-11-02 02:46:21 | male | 2 | 29872 | 514 | 0.953 | 31345.2 |
1624 | 2023-11-01 15:31:30 | male | 2 | 29872 | 514 | 0.766 | 38997.4 |
1623 | 2023-10-26 01:27:50 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1622 | 2023-10-23 15:47:20 | male | 1 | 13983 | 33 | 0.326 | 42892.6 |
1621 | 2023-10-20 05:00:50 | male | 2 | 29872 | 514 | 0.860 | 34734.9 |
1620 | 2023-10-19 15:57:49 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1619 | 2023-10-18 19:12:54 | male | 2 | 29872 | 514 | 0.890 | 33564.0 |
1618 | 2023-10-16 19:44:12 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1617 | 2023-10-14 19:37:36 | male | 1 | 13983 | 33 | 0.296 | 47239.9 |
1616 | 2023-10-11 17:16:10 | male | 1 | 13983 | 33 | 0.216 | 64736.1 |
1615 | 2023-10-03 16:24:26 | male | 1 | 13983 | 33 | 0.216 | 64736.1 |
1614 | 2023-10-03 11:58:45 | male | 2 | 29872 | 514 | 1.920 | 15558.3 |
1613 | 2023-10-01 22:30:20 | male | 2 | 29872 | 514 | 0.750 | 39829.3 |
1612 | 2023-09-23 22:35:00 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1611 | 2023-09-23 15:18:49 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1610 | 2023-09-05 20:37:18 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1609 | 2023-07-23 15:47:42 | male | 2 | 29872 | 514 | 1.096 | 27255.5 |
1608 | 2023-07-12 09:46:09 | male | 2 | 29872 | 514 | 0.780 | 38297.4 |
1607 | 2023-07-12 05:37:02 | male | 1 | 13983 | 33 | 0.233 | 60012.9 |
1606 | 2023-07-09 02:13:40 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1605 | 2023-06-10 04:18:08 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1604 | 2023-04-05 07:50:50 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1603 | 2023-04-02 18:38:56 | male | 2 | 29872 | 514 | 0.846 | 35309.7 |
1602 | 2023-03-31 13:39:16 | male | 1 | 13983 | 33 | 0.233 | 60012.9 |
1601 | 2023-03-29 20:19:01 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1600 | 2023-01-12 12:12:24 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1599 | 2022-12-31 14:50:16 | male | 2 | 29872 | 514 | 0.736 | 40587.0 |
1598 | 2022-12-27 09:22:14 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1597 | 2022-12-01 12:48:23 | male | 2 | 29872 | 514 | 0.860 | 34734.9 |
1596 | 2022-11-25 15:15:22 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1595 | 2022-10-31 00:29:24 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1594 | 2022-09-28 23:14:15 | male | 2 | 29872 | 514 | 0.800 | 37340.0 |
1593 | 2022-09-19 19:08:28 | male | 1 | 13983 | 33 | 0.216 | 64736.1 |
1592 | 2022-09-18 14:12:47 | male | 1 | 13983 | 33 | 0.216 | 64736.1 |
1591 | 2022-09-16 15:38:44 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1590 | 2022-09-12 08:09:34 | male | 1 | 13983 | 33 | 0.280 | 49939.3 |
1589 | 2022-09-09 11:56:09 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1588 | 2022-09-05 04:58:13 | male | 2 | 29872 | 514 | 0.763 | 39150.7 |
1587 | 2022-09-05 04:10:38 | male | 2 | 29872 | 514 | 0.750 | 39829.3 |
1586 | 2022-08-23 19:33:13 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1585 | 2022-08-06 23:33:59 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1584 | 2022-07-30 01:09:26 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1583 | 2022-07-28 18:50:55 | male | 1 | 13983 | 33 | 0.500 | 27966.0 |
1582 | 2022-07-17 18:52:45 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1581 | 2022-07-03 09:31:04 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1580 | 2022-06-25 21:12:07 | male | 1 | 13983 | 33 | 0.233 | 60012.9 |
1579 | 2022-06-24 19:38:11 | male | 1 | 13983 | 33 | 0.233 | 60012.9 |
1578 | 2022-06-20 02:23:32 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1577 | 2022-06-17 21:33:03 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1576 | 2022-06-16 09:28:45 | male | 1 | 13983 | 33 | 0.216 | 64736.1 |
1575 | 2022-06-08 22:35:23 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1574 | 2022-06-08 19:25:13 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1573 | 2022-06-06 19:49:51 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1572 | 2022-06-01 21:20:41 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1571 | 2022-05-28 03:02:53 | male | 2 | 29872 | 514 | 0.750 | 39829.3 |
1570 | 2022-04-27 17:21:42 | male | 1 | 13983 | 33 | 0.313 | 44674.1 |
1569 | 2022-04-27 05:15:53 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1568 | 2022-04-26 14:18:48 | male | 1 | 13983 | 33 | 0.266 | 52567.7 |
1567 | 2022-04-26 02:54:01 | male | 1 | 13983 | 33 | 0.220 | 63559.1 |
1566 | 2022-04-25 16:30:21 | male | 1 | 13983 | 33 | 0.296 | 47239.9 |
1565 | 2022-04-25 05:28:28 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1564 | 2022-04-24 13:07:55 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |
1563 | 2022-04-23 14:41:48 | male | 1 | 13983 | 33 | 0.233 | 60012.9 |
1562 | 2022-04-22 19:28:48 | male | 1 | 13983 | 33 | 0.346 | 40413.3 |
1561 | 2022-04-22 00:52:51 | male | 1 | 13983 | 33 | 0.403 | 34697.3 |
1560 | 2022-04-21 11:06:36 | male | 1 | 13983 | 33 | 0.250 | 55932.0 |