History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sold"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1603 | 2024-12-07 11:35:46 | sold | 2 | 29872 | 303 | 0.936 | 31914.5 |
1602 | 2024-12-06 13:12:41 | sold | 2 | 29872 | 303 | 2.283 | 13084.5 |
1601 | 2024-12-06 12:40:51 | sold | 1 | 13983 | 24 | 1.376 | 10162.1 |
1600 | 2024-11-27 10:47:12 | sold | 2 | 29872 | 303 | 3.923 | 7614.6 |
1599 | 2024-11-27 10:42:53 | sold | 2 | 29872 | 303 | 6.563 | 4551.6 |
1598 | 2024-11-27 08:34:20 | sold | 1 | 13983 | 24 | 0.733 | 19076.4 |
1597 | 2024-11-27 08:33:09 | sold | 1 | 13983 | 24 | 0.690 | 20265.2 |
1596 | 2024-11-21 17:22:54 | sold | 1 | 13983 | 24 | 1.280 | 10924.2 |
1595 | 2024-11-06 09:27:24 | sold | 2 | 29872 | 303 | 2.266 | 13182.7 |
1594 | 2024-11-06 07:40:30 | sold | 1 | 13983 | 24 | 0.233 | 60012.9 |
1593 | 2024-10-28 07:17:14 | sold | 1 | 13983 | 24 | 0.250 | 55932.0 |
1592 | 2024-10-28 05:25:23 | sold | 2 | 29872 | 303 | 7.250 | 4120.3 |
1591 | 2024-10-28 03:01:06 | sold | 2 | 29872 | 303 | 5.156 | 5793.6 |
1590 | 2024-10-28 02:55:37 | sold | 1 | 13983 | 24 | 1.310 | 10674.0 |
1589 | 2024-10-26 04:19:19 | sold | 1 | 13983 | 24 | 0.826 | 16928.6 |
1588 | 2024-10-17 07:56:12 | sold | 1 | 13983 | 24 | 1.580 | 8850.0 |
1587 | 2024-10-11 16:01:12 | sold | 1 | 13983 | 24 | 1.610 | 8685.1 |
1586 | 2024-10-07 09:13:45 | sold | 1 | 13983 | 24 | 2.546 | 5492.1 |
1585 | 2024-09-28 14:50:50 | sold | 2 | 29872 | 303 | 2.983 | 10014.1 |
1584 | 2024-09-27 23:55:35 | sold | 1 | 13983 | 24 | 0.220 | 63559.1 |
1583 | 2024-09-27 23:33:11 | sold | 2 | 29872 | 303 | 5.673 | 5265.6 |
1582 | 2024-09-27 23:00:16 | sold | 1 | 13983 | 24 | 0.686 | 20383.4 |
1581 | 2024-09-26 01:26:19 | sold | 1 | 13983 | 24 | 1.656 | 8443.8 |
1580 | 2024-09-07 03:58:42 | sold | 1 | 13983 | 24 | 0.873 | 16017.2 |
1579 | 2024-08-30 13:15:37 | sold | 1 | 13983 | 24 | 1.093 | 12793.2 |
1578 | 2024-08-28 19:16:54 | sold | 2 | 29872 | 303 | 2.873 | 10397.5 |
1577 | 2024-08-28 18:24:34 | sold | 2 | 29872 | 303 | 8.076 | 3698.9 |
1576 | 2024-08-28 17:25:19 | sold | 1 | 13983 | 24 | 0.250 | 55932.0 |
1575 | 2024-08-28 17:07:21 | sold | 1 | 13983 | 24 | 0.250 | 55932.0 |
1574 | 2024-08-26 17:23:44 | sold | 1 | 13983 | 24 | 1.373 | 10184.3 |
1573 | 2024-08-25 03:58:52 | sold | 1 | 13983 | 24 | 1.190 | 11750.4 |
1572 | 2024-08-20 15:04:33 | sold | 1 | 13983 | 24 | 2.453 | 5700.4 |
1571 | 2024-08-09 13:45:02 | sold | 1 | 13983 | 24 | 0.860 | 16259.3 |
1570 | 2024-08-07 22:17:44 | sold | 2 | 29872 | 303 | 3.686 | 8104.2 |
1569 | 2024-08-07 21:01:13 | sold | 1 | 13983 | 24 | 1.453 | 9623.5 |
1568 | 2024-08-02 11:07:32 | sold | 2 | 29872 | 303 | 2.123 | 14070.7 |
1567 | 2024-08-02 02:10:41 | sold | 1 | 13983 | 24 | 0.263 | 53167.3 |
1566 | 2024-07-30 14:00:47 | sold | 2 | 29872 | 303 | 4.203 | 7107.3 |
1565 | 2024-07-29 19:01:53 | sold | 2 | 29872 | 303 | 1.843 | 16208.4 |
1564 | 2024-07-29 11:00:38 | sold | 2 | 29872 | 303 | 5.030 | 5938.8 |
1563 | 2024-07-29 10:44:59 | sold | 2 | 29872 | 303 | 3.016 | 9904.5 |
1562 | 2024-07-29 09:38:26 | sold | 1 | 13983 | 24 | 0.220 | 63559.1 |
1561 | 2024-07-29 09:33:21 | sold | 1 | 13983 | 24 | 0.233 | 60012.9 |
1560 | 2024-07-27 15:12:17 | sold | 1 | 13983 | 24 | 0.500 | 27966.0 |
1559 | 2024-07-23 11:39:37 | sold | 1 | 13983 | 24 | 1.373 | 10184.3 |
1558 | 2024-07-06 15:25:37 | sold | 1 | 13983 | 24 | 0.606 | 23074.3 |
1557 | 2024-07-06 09:56:37 | sold | 1 | 13983 | 24 | 0.436 | 32071.1 |
1556 | 2024-07-04 15:32:53 | sold | 2 | 29872 | 303 | 1.873 | 15948.7 |
1555 | 2024-07-03 00:26:19 | sold | 1 | 13983 | 24 | 1.216 | 11499.2 |
1554 | 2024-06-30 20:32:54 | sold | 1 | 13983 | 24 | 1.533 | 9121.3 |
1553 | 2024-06-29 08:23:48 | sold | 1 | 13983 | 24 | 0.936 | 14939.1 |
1552 | 2024-06-29 05:11:33 | sold | 1 | 13983 | 24 | 1.266 | 11045.0 |
1551 | 2024-06-27 12:12:52 | sold | 1 | 13983 | 24 | 1.046 | 13368.1 |
1550 | 2024-06-25 20:50:21 | sold | 1 | 13983 | 24 | 0.690 | 20265.2 |
1549 | 2024-06-25 20:32:19 | sold | 1 | 13983 | 24 | 0.593 | 23580.1 |
1548 | 2024-06-17 21:11:36 | sold | 1 | 13983 | 24 | 0.843 | 16587.2 |
1547 | 2024-06-11 19:53:22 | sold | 1 | 13983 | 24 | 0.890 | 15711.2 |
1546 | 2024-05-30 04:29:06 | sold | 1 | 13983 | 24 | 0.906 | 15433.8 |
1545 | 2024-05-30 01:02:48 | sold | 2 | 29872 | 303 | 4.393 | 6799.9 |
1544 | 2024-05-29 22:47:32 | sold | 2 | 29872 | 303 | 1.660 | 17995.2 |
1543 | 2024-05-29 22:27:56 | sold | 1 | 13983 | 24 | 0.580 | 24108.6 |
1542 | 2024-05-28 13:16:55 | sold | 1 | 13983 | 24 | 0.856 | 16335.3 |
1541 | 2024-05-21 19:43:04 | sold | 1 | 13983 | 24 | 0.593 | 23580.1 |
1540 | 2024-05-03 21:37:32 | sold | 1 | 13983 | 24 | 0.266 | 52567.7 |
1539 | 2024-05-03 14:42:36 | sold | 1 | 13983 | 24 | 0.266 | 52567.7 |
1538 | 2024-05-01 18:27:09 | sold | 1 | 13983 | 24 | 0.876 | 15962.3 |
1537 | 2024-04-29 21:48:21 | sold | 1 | 13983 | 24 | 0.486 | 28771.6 |
1536 | 2024-04-26 06:11:05 | sold | 2 | 29872 | 303 | 1.000 | 29872.0 |
1535 | 2024-04-10 05:46:32 | sold | 1 | 13983 | 24 | 0.263 | 53167.3 |
1534 | 2024-04-01 16:01:59 | sold | 1 | 13983 | 24 | 0.610 | 22923.0 |
1533 | 2024-03-30 20:46:26 | sold | 2 | 29872 | 303 | 0.796 | 37527.6 |
1532 | 2024-03-30 19:32:13 | sold | 2 | 29872 | 303 | 4.220 | 7078.7 |
1531 | 2024-03-30 19:03:45 | sold | 1 | 13983 | 24 | 0.860 | 16259.3 |
1530 | 2024-03-28 17:58:51 | sold | 1 | 13983 | 24 | 0.860 | 16259.3 |
1529 | 2024-03-02 12:57:12 | sold | 1 | 13983 | 24 | 0.606 | 23074.3 |
1528 | 2024-02-26 19:17:05 | sold | 1 | 13983 | 24 | 0.283 | 49409.9 |
1527 | 2024-01-27 18:25:57 | sold | 1 | 13983 | 24 | 0.233 | 60012.9 |
1526 | 2024-01-16 23:48:19 | sold | 2 | 29872 | 303 | 1.983 | 15064.0 |
1525 | 2023-12-25 21:23:52 | sold | 1 | 13983 | 24 | 0.266 | 52567.7 |
1524 | 2023-12-20 10:30:27 | sold | 1 | 13983 | 24 | 0.360 | 38841.7 |
1523 | 2023-12-17 11:56:08 | sold | 2 | 29872 | 303 | 0.966 | 30923.4 |
1522 | 2023-12-04 21:38:16 | sold | 2 | 29872 | 303 | 0.766 | 38997.4 |
1521 | 2023-11-18 05:04:27 | sold | 1 | 13983 | 24 | 0.250 | 55932.0 |
1520 | 2023-11-11 21:43:05 | sold | 1 | 13983 | 24 | 0.233 | 60012.9 |
1519 | 2023-11-03 06:51:32 | sold | 1 | 13983 | 24 | 0.220 | 63559.1 |
1518 | 2023-10-22 04:24:14 | sold | 2 | 29872 | 303 | 0.893 | 33451.3 |
1517 | 2023-10-19 21:47:05 | sold | 2 | 29872 | 303 | 1.813 | 16476.6 |
1516 | 2023-10-19 21:14:01 | sold | 1 | 13983 | 24 | 0.250 | 55932.0 |
1515 | 2023-10-19 15:44:20 | sold | 2 | 29872 | 303 | 0.906 | 32971.3 |
1514 | 2023-10-17 09:29:09 | sold | 1 | 13983 | 24 | 0.313 | 44674.1 |
1513 | 2023-10-15 07:43:27 | sold | 2 | 29872 | 303 | 0.890 | 33564.0 |
1512 | 2023-10-13 20:24:39 | sold | 1 | 13983 | 24 | 0.220 | 63559.1 |
1511 | 2023-10-12 16:25:15 | sold | 1 | 13983 | 24 | 0.220 | 63559.1 |
1510 | 2023-10-03 16:56:51 | sold | 1 | 13983 | 24 | 0.233 | 60012.9 |
1509 | 2023-09-28 18:00:50 | sold | 2 | 29872 | 303 | 1.390 | 21490.6 |
1508 | 2023-09-25 16:31:22 | sold | 1 | 13983 | 24 | 0.236 | 59250.0 |
1507 | 2023-09-23 16:08:08 | sold | 1 | 13983 | 24 | 0.283 | 49409.9 |
1506 | 2023-09-23 11:22:08 | sold | 2 | 29872 | 303 | 0.780 | 38297.4 |
1505 | 2023-09-18 15:01:29 | sold | 2 | 29872 | 303 | 0.923 | 32364.0 |
1504 | 2023-09-15 00:15:45 | sold | 2 | 29872 | 303 | 0.766 | 38997.4 |