History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"join"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1644 | 2024-12-06 10:43:52 | join | 1 | 13983 | 8 | 1.563 | 8946.3 |
1643 | 2024-11-29 08:07:39 | join | 2 | 29872 | 205 | 2.986 | 10004.0 |
1642 | 2024-11-29 04:33:09 | join | 2 | 29872 | 205 | 2.016 | 14817.5 |
1641 | 2024-11-29 03:22:23 | join | 1 | 13983 | 8 | 1.580 | 8850.0 |
1640 | 2024-11-25 06:52:03 | join | 1 | 13983 | 8 | 0.953 | 14672.6 |
1639 | 2024-11-20 21:41:39 | join | 2 | 29872 | 205 | 4.190 | 7129.4 |
1638 | 2024-11-06 09:19:02 | join | 2 | 29872 | 205 | 2.093 | 14272.3 |
1637 | 2024-11-06 07:49:37 | join | 1 | 13983 | 8 | 1.390 | 10059.7 |
1636 | 2024-10-30 02:47:22 | join | 2 | 29872 | 205 | 3.750 | 7965.9 |
1635 | 2024-10-30 02:36:33 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1634 | 2024-10-27 13:43:30 | join | 2 | 29872 | 205 | 2.170 | 13765.9 |
1633 | 2024-10-27 13:31:35 | join | 1 | 13983 | 8 | 1.123 | 12451.5 |
1632 | 2024-10-26 04:18:54 | join | 1 | 13983 | 8 | 0.906 | 15433.8 |
1631 | 2024-10-24 01:31:43 | join | 1 | 13983 | 8 | 1.470 | 9512.2 |
1630 | 2024-10-22 16:09:14 | join | 1 | 13983 | 8 | 1.360 | 10281.6 |
1629 | 2024-10-22 01:34:00 | join | 1 | 13983 | 8 | 1.470 | 9512.2 |
1628 | 2024-10-07 10:03:20 | join | 2 | 29872 | 205 | 6.076 | 4916.4 |
1627 | 2024-10-07 08:29:53 | join | 1 | 13983 | 8 | 0.220 | 63559.1 |
1626 | 2024-09-30 01:15:40 | join | 2 | 29872 | 205 | 5.440 | 5491.2 |
1625 | 2024-09-30 00:02:03 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1624 | 2024-09-27 12:00:05 | join | 2 | 29872 | 205 | 6.733 | 4436.7 |
1623 | 2024-09-27 10:56:51 | join | 1 | 13983 | 8 | 1.143 | 12233.6 |
1622 | 2024-09-26 01:07:54 | join | 1 | 13983 | 8 | 3.033 | 4610.3 |
1621 | 2024-09-07 06:24:46 | join | 1 | 13983 | 8 | 1.013 | 13803.6 |
1620 | 2024-08-30 21:57:57 | join | 2 | 29872 | 205 | 4.533 | 6589.9 |
1619 | 2024-08-30 21:16:12 | join | 1 | 13983 | 8 | 0.266 | 52567.7 |
1618 | 2024-08-30 09:41:36 | join | 1 | 13983 | 8 | 2.626 | 5324.8 |
1617 | 2024-08-29 01:41:34 | join | 1 | 13983 | 8 | 0.266 | 52567.7 |
1616 | 2024-08-28 09:40:43 | join | 1 | 13983 | 8 | 0.203 | 68881.8 |
1615 | 2024-08-26 17:23:32 | join | 1 | 13983 | 8 | 0.703 | 19890.5 |
1614 | 2024-08-14 18:44:53 | join | 1 | 13983 | 8 | 0.283 | 49409.9 |
1613 | 2024-08-09 05:58:44 | join | 2 | 29872 | 205 | 3.436 | 8693.8 |
1612 | 2024-08-08 09:11:10 | join | 2 | 29872 | 205 | 4.843 | 6168.1 |
1611 | 2024-08-08 06:06:12 | join | 2 | 29872 | 205 | 4.436 | 6734.0 |
1610 | 2024-08-08 06:04:43 | join | 1 | 13983 | 8 | 0.266 | 52567.7 |
1609 | 2024-08-02 04:48:12 | join | 1 | 13983 | 8 | 0.266 | 52567.7 |
1608 | 2024-07-31 11:47:37 | join | 1 | 13983 | 8 | 0.280 | 49939.3 |
1607 | 2024-07-31 02:43:08 | join | 2 | 29872 | 205 | 3.813 | 7834.3 |
1606 | 2024-07-31 02:05:47 | join | 1 | 13983 | 8 | 0.216 | 64736.1 |
1605 | 2024-07-31 01:38:13 | join | 2 | 29872 | 205 | 4.920 | 6071.5 |
1604 | 2024-07-31 00:14:14 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1603 | 2024-07-29 09:36:48 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1602 | 2024-07-27 14:29:18 | join | 1 | 13983 | 8 | 0.830 | 16847.0 |
1601 | 2024-07-15 23:11:38 | join | 1 | 13983 | 8 | 1.093 | 12793.2 |
1600 | 2024-07-07 07:55:54 | join | 2 | 29872 | 205 | 1.796 | 16632.5 |
1599 | 2024-07-05 01:23:27 | join | 1 | 13983 | 8 | 0.656 | 21315.5 |
1598 | 2024-07-05 01:18:57 | join | 1 | 13983 | 8 | 0.766 | 18254.6 |
1597 | 2024-07-03 05:36:42 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1596 | 2024-07-02 08:20:31 | join | 1 | 13983 | 8 | 1.033 | 13536.3 |
1595 | 2024-06-30 10:18:18 | join | 2 | 29872 | 205 | 3.270 | 9135.2 |
1594 | 2024-06-30 09:41:15 | join | 2 | 29872 | 205 | 3.906 | 7647.7 |
1593 | 2024-06-30 09:33:44 | join | 1 | 13983 | 8 | 0.530 | 26383.0 |
1592 | 2024-06-29 04:59:05 | join | 1 | 13983 | 8 | 0.783 | 17858.2 |
1591 | 2024-06-27 14:22:46 | join | 1 | 13983 | 8 | 1.470 | 9512.2 |
1590 | 2024-06-23 01:33:09 | join | 2 | 29872 | 205 | 1.810 | 16503.9 |
1589 | 2024-06-22 01:11:55 | join | 2 | 29872 | 205 | 2.936 | 10174.4 |
1588 | 2024-06-13 18:39:36 | join | 2 | 29872 | 205 | 2.643 | 11302.3 |
1587 | 2024-06-13 16:35:25 | join | 2 | 29872 | 205 | 1.376 | 21709.3 |
1586 | 2024-06-09 16:40:59 | join | 1 | 13983 | 8 | 0.326 | 42892.6 |
1585 | 2024-06-09 01:29:42 | join | 1 | 13983 | 8 | 0.720 | 19420.8 |
1584 | 2024-06-09 01:26:39 | join | 1 | 13983 | 8 | 1.096 | 12758.2 |
1583 | 2024-06-09 01:20:31 | join | 1 | 13983 | 8 | 1.266 | 11045.0 |
1582 | 2024-06-09 01:15:33 | join | 1 | 13983 | 8 | 0.813 | 17199.3 |
1581 | 2024-06-08 05:25:28 | join | 2 | 29872 | 205 | 1.406 | 21246.1 |
1580 | 2024-06-06 19:43:56 | join | 2 | 29872 | 205 | 0.953 | 31345.2 |
1579 | 2024-06-04 05:22:40 | join | 2 | 29872 | 205 | 1.593 | 18752.0 |
1578 | 2024-06-04 05:17:26 | join | 1 | 13983 | 8 | 1.000 | 13983.0 |
1577 | 2024-06-04 01:47:49 | join | 1 | 13983 | 8 | 0.330 | 42372.7 |
1576 | 2024-06-03 04:14:43 | join | 1 | 13983 | 8 | 0.216 | 64736.1 |
1575 | 2024-05-30 22:21:04 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1574 | 2024-05-29 19:55:49 | join | 1 | 13983 | 8 | 1.390 | 10059.7 |
1573 | 2024-05-28 11:40:37 | join | 1 | 13983 | 8 | 0.876 | 15962.3 |
1572 | 2024-05-27 21:12:34 | join | 2 | 29872 | 205 | 2.423 | 12328.5 |
1571 | 2024-05-27 11:41:32 | join | 2 | 29872 | 205 | 0.953 | 31345.2 |
1570 | 2024-05-19 03:31:09 | join | 1 | 13983 | 8 | 0.266 | 52567.7 |
1569 | 2024-05-10 10:26:53 | join | 1 | 13983 | 8 | 0.283 | 49409.9 |
1568 | 2024-05-05 15:44:24 | join | 2 | 29872 | 205 | 0.843 | 35435.3 |
1567 | 2024-05-05 04:47:17 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1566 | 2024-05-03 21:41:51 | join | 1 | 13983 | 8 | 0.783 | 17858.2 |
1565 | 2024-04-30 16:13:36 | join | 1 | 13983 | 8 | 0.266 | 52567.7 |
1564 | 2024-04-30 05:49:16 | join | 1 | 13983 | 8 | 0.283 | 49409.9 |
1563 | 2024-04-27 16:19:56 | join | 1 | 13983 | 8 | 0.296 | 47239.9 |
1562 | 2024-04-26 17:10:53 | join | 1 | 13983 | 8 | 0.263 | 53167.3 |
1561 | 2024-04-17 09:04:27 | join | 1 | 13983 | 8 | 0.220 | 63559.1 |
1560 | 2024-04-13 05:44:57 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1559 | 2024-04-13 05:44:45 | join | 2 | 29872 | 205 | 2.533 | 11793.1 |
1558 | 2024-04-13 01:10:54 | join | 1 | 13983 | 8 | 0.360 | 38841.7 |
1557 | 2024-04-12 09:01:05 | join | 2 | 29872 | 205 | 0.736 | 40587.0 |
1556 | 2024-04-11 18:05:37 | join | 2 | 29872 | 205 | 0.940 | 31778.7 |
1555 | 2024-04-10 11:13:54 | join | 2 | 29872 | 205 | 0.826 | 36164.6 |
1554 | 2024-04-09 15:07:57 | join | 2 | 29872 | 205 | 2.106 | 14184.2 |
1553 | 2024-04-08 14:23:26 | join | 2 | 29872 | 205 | 1.030 | 29001.9 |
1552 | 2024-04-05 01:30:49 | join | 1 | 13983 | 8 | 0.203 | 68881.8 |
1551 | 2024-04-02 22:50:55 | join | 2 | 29872 | 205 | 2.983 | 10014.1 |
1550 | 2024-04-02 20:57:03 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1549 | 2024-03-31 10:38:52 | join | 2 | 29872 | 205 | 1.970 | 15163.5 |
1548 | 2024-03-31 08:03:39 | join | 1 | 13983 | 8 | 0.500 | 27966.0 |
1547 | 2024-03-27 07:23:43 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1546 | 2024-03-23 10:27:45 | join | 2 | 29872 | 205 | 0.953 | 31345.2 |
1545 | 2024-03-22 21:11:52 | join | 2 | 29872 | 205 | 1.923 | 15534.1 |