History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lyricists"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1657 | 2024-03-14 15:15:10 | lyricists | 4 | 165329 | 202 | 35.846 | 4612.2 |
1656 | 2024-03-14 15:15:09 | lyricists | 3 | 148641 | 31 | 14.766 | 10066.4 |
1655 | 2024-03-14 15:15:13 | lyricists | 2 | 121436 | 9 | 4.250 | 28573.2 |
1654 | 2024-03-14 13:35:19 | lyricists | 1 | 81242 | 4 | 1.330 | 61084.2 |
1653 | 2024-03-12 09:19:51 | lyricists | 4 | 165329 | 202 | 40.220 | 4110.6 |
1652 | 2024-03-12 09:19:56 | lyricists | 3 | 148641 | 31 | 17.673 | 8410.6 |
1651 | 2024-03-12 09:19:54 | lyricists | 2 | 121436 | 9 | 7.986 | 15206.1 |
1650 | 2024-03-12 06:58:31 | lyricists | 1 | 81242 | 4 | 1.406 | 57782.4 |
1649 | 2024-03-07 17:48:17 | lyricists | 1 | 81242 | 4 | 1.373 | 59171.2 |
1648 | 2024-03-07 05:19:28 | lyricists | 3 | 148641 | 31 | 9.516 | 15620.1 |
1647 | 2024-03-05 09:32:36 | lyricists | 1 | 81242 | 4 | 2.406 | 33766.4 |
1646 | 2024-03-02 07:40:28 | lyricists | 1 | 81242 | 4 | 1.440 | 56418.1 |
1645 | 2024-02-27 14:12:48 | lyricists | 1 | 81242 | 4 | 1.406 | 57782.4 |
1644 | 2024-02-26 13:17:47 | lyricists | 1 | 81242 | 4 | 1.376 | 59042.2 |
1643 | 2024-02-25 16:03:16 | lyricists | 1 | 81242 | 4 | 1.203 | 67532.8 |
1642 | 2024-01-29 17:10:54 | lyricists | 1 | 81242 | 4 | 1.153 | 70461.4 |
1641 | 2024-01-29 14:23:59 | lyricists | 1 | 81242 | 4 | 1.373 | 59171.2 |
1640 | 2024-01-28 12:45:11 | lyricists | 1 | 81242 | 4 | 1.313 | 61875.1 |
1639 | 2024-01-26 13:47:34 | lyricists | 1 | 81242 | 4 | 1.360 | 59736.8 |
1638 | 2024-01-26 01:50:53 | lyricists | 1 | 81242 | 4 | 2.720 | 29868.4 |
1637 | 2024-01-24 00:40:56 | lyricists | 1 | 81242 | 4 | 1.266 | 64172.2 |
1636 | 2024-01-12 12:26:44 | lyricists | 3 | 148641 | 31 | 6.186 | 24028.6 |
1635 | 2024-01-12 04:24:00 | lyricists | 2 | 121436 | 9 | 2.970 | 40887.5 |
1634 | 2023-12-29 17:20:23 | lyricists | 1 | 81242 | 4 | 1.173 | 69260.0 |
1633 | 2023-12-29 04:54:29 | lyricists | 1 | 81242 | 4 | 1.280 | 63470.3 |
1632 | 2023-12-23 02:23:22 | lyricists | 1 | 81242 | 4 | 1.203 | 67532.8 |
1631 | 2023-12-21 23:37:17 | lyricists | 4 | 165329 | 202 | 11.796 | 14015.7 |
1630 | 2023-12-15 10:21:32 | lyricists | 1 | 81242 | 4 | 1.170 | 69437.6 |
1629 | 2023-12-14 04:17:01 | lyricists | 4 | 165329 | 202 | 10.343 | 15984.6 |
1628 | 2023-11-25 13:25:57 | lyricists | 3 | 148641 | 31 | 10.140 | 14658.9 |
1627 | 2023-11-11 07:54:18 | lyricists | 3 | 148641 | 31 | 9.750 | 15245.2 |
1626 | 2023-11-11 07:54:13 | lyricists | 4 | 165329 | 202 | 11.360 | 14553.6 |
1625 | 2023-11-11 07:54:02 | lyricists | 2 | 121436 | 9 | 3.063 | 39646.1 |
1624 | 2023-11-10 06:18:23 | lyricists | 3 | 148641 | 31 | 5.766 | 25778.9 |
1623 | 2023-11-10 06:07:16 | lyricists | 2 | 121436 | 9 | 3.610 | 33638.8 |
1622 | 2023-11-10 06:06:33 | lyricists | 4 | 165329 | 202 | 17.813 | 9281.4 |
1621 | 2023-11-08 11:22:24 | lyricists | 1 | 81242 | 4 | 1.343 | 60492.9 |
1620 | 2023-11-08 02:57:42 | lyricists | 1 | 81242 | 4 | 1.313 | 61875.1 |
1619 | 2023-11-08 02:39:42 | lyricists | 1 | 81242 | 4 | 1.173 | 69260.0 |
1618 | 2023-11-07 08:58:17 | lyricists | 1 | 81242 | 4 | 1.300 | 62493.8 |
1617 | 2023-11-06 20:21:18 | lyricists | 1 | 81242 | 4 | 1.453 | 55913.3 |
1616 | 2023-11-06 15:14:27 | lyricists | 1 | 81242 | 4 | 1.313 | 61875.1 |
1615 | 2023-11-05 18:15:04 | lyricists | 1 | 81242 | 4 | 1.186 | 68500.8 |
1614 | 2023-11-04 12:54:02 | lyricists | 4 | 165329 | 202 | 11.750 | 14070.6 |
1613 | 2023-11-04 12:53:52 | lyricists | 4 | 165329 | 202 | 11.733 | 14090.9 |
1612 | 2023-11-04 12:53:49 | lyricists | 2 | 121436 | 9 | 3.233 | 37561.4 |
1611 | 2023-11-04 08:24:40 | lyricists | 1 | 81242 | 4 | 2.186 | 37164.7 |
1610 | 2023-11-03 09:14:35 | lyricists | 1 | 81242 | 4 | 1.173 | 69260.0 |
1609 | 2023-10-29 23:55:28 | lyricists | 1 | 81242 | 4 | 1.453 | 55913.3 |
1608 | 2023-10-26 20:46:14 | lyricists | 4 | 165329 | 202 | 10.470 | 15790.7 |
1607 | 2023-10-26 20:46:08 | lyricists | 3 | 148641 | 31 | 6.266 | 23721.8 |
1606 | 2023-10-26 20:41:04 | lyricists | 2 | 121436 | 9 | 3.970 | 30588.4 |
1605 | 2023-10-25 19:48:53 | lyricists | 1 | 81242 | 4 | 1.326 | 61268.5 |
1604 | 2023-10-23 12:53:52 | lyricists | 1 | 81242 | 4 | 1.483 | 54782.2 |
1603 | 2023-10-22 21:55:33 | lyricists | 2 | 121436 | 9 | 3.250 | 37364.9 |
1602 | 2023-10-20 13:58:25 | lyricists | 4 | 165329 | 202 | 22.500 | 7348.0 |
1601 | 2023-10-20 13:58:38 | lyricists | 2 | 121436 | 9 | 3.890 | 31217.5 |
1600 | 2023-10-20 13:58:18 | lyricists | 3 | 148641 | 31 | 18.953 | 7842.6 |
1599 | 2023-10-19 14:50:25 | lyricists | 1 | 81242 | 4 | 1.390 | 58447.5 |
1598 | 2023-10-19 00:31:38 | lyricists | 1 | 81242 | 4 | 1.313 | 61875.1 |
1597 | 2023-10-17 10:34:07 | lyricists | 4 | 165329 | 202 | 31.770 | 5203.9 |
1596 | 2023-10-17 10:34:03 | lyricists | 2 | 121436 | 9 | 11.190 | 10852.2 |
1595 | 2023-10-17 10:33:55 | lyricists | 3 | 148641 | 31 | 11.563 | 12854.9 |
1594 | 2023-10-16 18:35:04 | lyricists | 1 | 81242 | 4 | 1.186 | 68500.8 |
1593 | 2023-10-11 07:55:01 | lyricists | 3 | 148641 | 31 | 15.033 | 9887.6 |
1592 | 2023-10-11 07:54:43 | lyricists | 4 | 165329 | 202 | 28.846 | 5731.4 |
1591 | 2023-10-11 07:54:57 | lyricists | 2 | 121436 | 9 | 5.030 | 24142.3 |
1590 | 2023-10-09 23:26:56 | lyricists | 1 | 81242 | 4 | 1.170 | 69437.6 |
1589 | 2023-10-04 01:53:06 | lyricists | 4 | 165329 | 202 | 20.423 | 8095.2 |
1588 | 2023-10-04 01:53:07 | lyricists | 3 | 148641 | 31 | 16.393 | 9067.3 |
1587 | 2023-10-04 01:53:06 | lyricists | 2 | 121436 | 9 | 8.203 | 14803.9 |
1586 | 2023-10-03 08:37:39 | lyricists | 1 | 81242 | 4 | 1.360 | 59736.8 |
1585 | 2023-09-25 12:09:07 | lyricists | 1 | 81242 | 4 | 1.313 | 61875.1 |
1584 | 2023-09-22 22:50:39 | lyricists | 4 | 165329 | 202 | 13.580 | 12174.4 |
1583 | 2023-09-22 22:50:40 | lyricists | 2 | 121436 | 9 | 7.673 | 15826.4 |
1582 | 2023-09-22 22:50:36 | lyricists | 3 | 148641 | 31 | 8.080 | 18396.2 |
1581 | 2023-09-18 21:53:12 | lyricists | 1 | 81242 | 4 | 1.173 | 69260.0 |
1580 | 2023-09-15 19:18:06 | lyricists | 1 | 81242 | 4 | 1.203 | 67532.8 |
1579 | 2023-09-10 19:24:03 | lyricists | 4 | 165329 | 202 | 13.156 | 12566.8 |
1578 | 2023-09-10 19:10:25 | lyricists | 3 | 148641 | 31 | 11.860 | 12533.0 |
1577 | 2023-09-10 19:10:22 | lyricists | 2 | 121436 | 9 | 7.983 | 15211.8 |
1576 | 2023-09-10 19:08:40 | lyricists | 4 | 165329 | 202 | 19.220 | 8601.9 |
1575 | 2023-09-10 11:20:41 | lyricists | 1 | 81242 | 4 | 1.296 | 62686.7 |
1574 | 2023-09-05 23:15:18 | lyricists | 4 | 165329 | 202 | 10.906 | 15159.5 |
1573 | 2023-08-25 09:04:23 | lyricists | 3 | 148641 | 31 | 6.373 | 23323.6 |
1572 | 2023-08-20 10:35:20 | lyricists | 1 | 81242 | 4 | 1.313 | 61875.1 |
1571 | 2023-08-17 02:05:08 | lyricists | 1 | 81242 | 4 | 1.233 | 65889.7 |
1570 | 2023-08-15 12:39:40 | lyricists | 1 | 81242 | 4 | 1.313 | 61875.1 |
1569 | 2023-08-01 17:26:49 | lyricists | 2 | 121436 | 9 | 3.080 | 39427.3 |
1568 | 2023-07-28 17:06:07 | lyricists | 4 | 165329 | 202 | 12.080 | 13686.2 |
1567 | 2023-07-26 10:53:35 | lyricists | 1 | 81242 | 4 | 1.186 | 68500.8 |
1566 | 2023-07-23 16:20:41 | lyricists | 1 | 81242 | 4 | 1.313 | 61875.1 |
1565 | 2023-07-23 09:46:30 | lyricists | 1 | 81242 | 4 | 1.406 | 57782.4 |
1564 | 2023-07-18 01:49:35 | lyricists | 3 | 148641 | 31 | 6.280 | 23668.9 |
1563 | 2023-07-16 19:27:44 | lyricists | 1 | 81242 | 4 | 1.313 | 61875.1 |
1562 | 2023-07-04 08:41:56 | lyricists | 4 | 165329 | 202 | 10.516 | 15721.7 |
1561 | 2023-07-03 11:44:19 | lyricists | 4 | 165329 | 202 | 11.703 | 14127.1 |
1560 | 2023-07-02 08:03:22 | lyricists | 4 | 165329 | 202 | 10.326 | 16010.9 |
1559 | 2023-07-01 07:06:11 | lyricists | 4 | 165329 | 202 | 11.720 | 14106.6 |
1558 | 2023-06-30 08:08:36 | lyricists | 4 | 165329 | 202 | 10.363 | 15953.8 |