History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hardies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
681 | 2024-05-03 09:02:15 | hardies | 1 | 69583 | 7 | 1.313 | 52995.4 |
680 | 2024-04-26 16:28:25 | hardies | 1 | 69583 | 7 | 1.310 | 53116.8 |
679 | 2024-04-08 21:48:05 | hardies | 1 | 69583 | 7 | 1.266 | 54962.9 |
678 | 2024-04-04 07:00:15 | hardies | 2 | 107671 | 91 | 6.466 | 16651.9 |
677 | 2024-04-04 06:54:59 | hardies | 3 | 134027 | 978 | 7.813 | 17154.4 |
676 | 2024-04-04 04:11:09 | hardies | 3 | 134027 | 978 | 8.360 | 16031.9 |
675 | 2024-04-03 11:09:43 | hardies | 3 | 134027 | 978 | 23.516 | 5699.4 |
674 | 2024-04-03 08:50:21 | hardies | 2 | 107671 | 91 | 5.030 | 21405.8 |
673 | 2024-04-03 08:30:17 | hardies | 3 | 134027 | 978 | 20.533 | 6527.4 |
672 | 2024-04-03 08:30:19 | hardies | 2 | 107671 | 91 | 3.936 | 27355.4 |
671 | 2024-04-03 08:30:10 | hardies | 1 | 69583 | 7 | 1.500 | 46388.7 |
670 | 2024-03-05 08:23:19 | hardies | 3 | 134027 | 978 | 7.703 | 17399.3 |
669 | 2024-03-04 02:16:32 | hardies | 2 | 107671 | 91 | 3.516 | 30623.2 |
668 | 2024-03-04 02:15:34 | hardies | 3 | 134027 | 978 | 7.406 | 18097.1 |
667 | 2024-03-02 12:54:39 | hardies | 2 | 107671 | 91 | 6.266 | 17183.4 |
666 | 2024-03-02 03:52:08 | hardies | 3 | 134027 | 978 | 7.703 | 17399.3 |
665 | 2024-03-02 03:26:25 | hardies | 3 | 134027 | 978 | 14.220 | 9425.2 |
664 | 2024-03-02 03:26:26 | hardies | 2 | 107671 | 91 | 5.110 | 21070.6 |
663 | 2024-03-02 03:26:20 | hardies | 1 | 69583 | 7 | 1.343 | 51811.6 |
662 | 2024-02-21 21:28:08 | hardies | 1 | 69583 | 7 | 1.186 | 58670.3 |
661 | 2024-02-01 10:50:40 | hardies | 2 | 107671 | 91 | 3.423 | 31455.2 |
660 | 2024-01-31 15:04:03 | hardies | 2 | 107671 | 91 | 3.533 | 30475.8 |
659 | 2024-01-31 15:03:59 | hardies | 1 | 69583 | 7 | 1.250 | 55666.4 |
658 | 2024-01-24 12:02:46 | hardies | 3 | 134027 | 978 | 16.643 | 8053.1 |
657 | 2024-01-23 03:06:01 | hardies | 3 | 134027 | 978 | 17.283 | 7754.8 |
656 | 2024-01-16 03:26:09 | hardies | 3 | 134027 | 978 | 7.563 | 17721.4 |
655 | 2024-01-16 03:25:57 | hardies | 2 | 107671 | 91 | 3.626 | 29694.2 |
654 | 2024-01-06 21:02:55 | hardies | 1 | 69583 | 7 | 1.063 | 65459.1 |
653 | 2024-01-01 11:19:48 | hardies | 1 | 69583 | 7 | 1.110 | 62687.4 |
652 | 2023-12-27 20:46:41 | hardies | 1 | 69583 | 7 | 1.283 | 54234.6 |
651 | 2023-12-05 00:50:38 | hardies | 1 | 69583 | 7 | 1.173 | 59320.5 |
650 | 2023-11-26 20:19:47 | hardies | 1 | 69583 | 7 | 1.203 | 57841.2 |
649 | 2023-11-23 23:15:19 | hardies | 1 | 69583 | 7 | 1.140 | 61037.7 |
648 | 2023-11-23 22:41:08 | hardies | 1 | 69583 | 7 | 1.173 | 59320.5 |
647 | 2023-11-11 01:47:55 | hardies | 1 | 69583 | 7 | 1.143 | 60877.5 |
646 | 2023-11-02 02:08:07 | hardies | 1 | 69583 | 7 | 1.140 | 61037.7 |
645 | 2023-10-24 15:22:38 | hardies | 1 | 69583 | 7 | 1.186 | 58670.3 |
644 | 2023-10-11 11:13:30 | hardies | 1 | 69583 | 7 | 1.203 | 57841.2 |
643 | 2023-10-06 15:44:06 | hardies | 1 | 69583 | 7 | 1.076 | 64668.2 |
642 | 2023-09-27 20:29:39 | hardies | 1 | 69583 | 7 | 1.110 | 62687.4 |
641 | 2023-09-25 06:11:53 | hardies | 1 | 69583 | 7 | 1.283 | 54234.6 |
640 | 2023-09-24 08:09:59 | hardies | 1 | 69583 | 7 | 1.110 | 62687.4 |
639 | 2023-09-18 23:57:07 | hardies | 1 | 69583 | 7 | 2.110 | 32977.7 |
638 | 2023-07-10 14:43:01 | hardies | 1 | 69583 | 7 | 1.106 | 62914.1 |
637 | 2023-06-20 07:31:36 | hardies | 1 | 69583 | 7 | 1.063 | 65459.1 |
636 | 2023-04-16 07:21:32 | hardies | 1 | 69583 | 7 | 1.063 | 65459.1 |
635 | 2023-03-14 17:28:41 | hardies | 1 | 69583 | 7 | 1.220 | 57035.2 |
634 | 2023-02-10 01:24:30 | hardies | 1 | 69583 | 7 | 1.233 | 56433.9 |
633 | 2022-12-26 10:42:22 | hardies | 1 | 69583 | 7 | 1.186 | 58670.3 |
632 | 2022-12-07 17:30:20 | hardies | 1 | 69583 | 7 | 1.093 | 63662.4 |
631 | 2022-12-03 03:56:10 | hardies | 1 | 69583 | 7 | 1.216 | 57222.9 |
630 | 2022-11-23 23:18:08 | hardies | 1 | 69583 | 7 | 1.080 | 64428.7 |
629 | 2022-08-22 21:23:54 | hardies | 1 | 69583 | 7 | 1.203 | 57841.2 |
628 | 2022-08-09 12:35:56 | hardies | 1 | 69583 | 7 | 1.123 | 61961.7 |
627 | 2022-08-07 12:06:09 | hardies | 1 | 69583 | 7 | 1.093 | 63662.4 |
626 | 2022-05-10 09:50:17 | hardies | 1 | 69583 | 7 | 1.810 | 38443.6 |
625 | 2022-04-07 11:09:59 | hardies | 1 | 69583 | 7 | 1.436 | 48456.1 |
624 | 2022-04-05 08:06:04 | hardies | 1 | 69583 | 7 | 1.373 | 50679.5 |
623 | 2022-03-31 08:56:12 | hardies | 1 | 69583 | 7 | 1.360 | 51164.0 |
622 | 2022-03-30 13:22:00 | hardies | 1 | 69583 | 7 | 1.343 | 51811.6 |
621 | 2022-03-29 16:15:20 | hardies | 1 | 69583 | 7 | 1.343 | 51811.6 |
620 | 2022-03-28 22:55:44 | hardies | 1 | 69583 | 7 | 1.296 | 53690.6 |
619 | 2022-03-27 15:26:14 | hardies | 1 | 69583 | 7 | 1.220 | 57035.2 |
618 | 2022-03-26 23:17:41 | hardies | 1 | 69583 | 7 | 1.093 | 63662.4 |
617 | 2022-02-05 12:03:26 | hardies | 1 | 69583 | 7 | 1.280 | 54361.7 |
616 | 2022-01-02 15:18:28 | hardies | 1 | 69583 | 7 | 1.156 | 60192.9 |
615 | 2021-11-13 06:26:36 | hardies | 1 | 69583 | 7 | 1.110 | 62687.4 |
614 | 2021-11-11 17:42:10 | hardies | 1 | 69583 | 7 | 1.076 | 64668.2 |
613 | 2021-11-04 17:56:22 | hardies | 1 | 69583 | 7 | 1.280 | 54361.7 |
612 | 2021-10-29 22:49:54 | hardies | 1 | 69583 | 7 | 1.093 | 63662.4 |
611 | 2021-09-13 23:47:10 | hardies | 1 | 69583 | 7 | 1.060 | 65644.3 |
610 | 2021-08-25 05:49:24 | hardies | 1 | 69583 | 7 | 1.233 | 56433.9 |
609 | 2021-08-01 12:25:44 | hardies | 1 | 69583 | 7 | 1.093 | 63662.4 |
608 | 2021-06-05 13:24:29 | hardies | 1 | 69583 | 7 | 1.266 | 54962.9 |
607 | 2021-05-19 12:34:39 | hardies | 2 | 107671 | 91 | 2.906 | 37051.3 |
606 | 2021-05-11 11:18:07 | hardies | 1 | 69583 | 7 | 1.343 | 51811.6 |
605 | 2021-04-23 08:00:25 | hardies | 1 | 69583 | 7 | 2.220 | 31343.7 |
604 | 2021-04-19 11:50:05 | hardies | 2 | 107671 | 91 | 2.890 | 37256.4 |
603 | 2021-02-24 20:10:33 | hardies | 2 | 107671 | 91 | 3.843 | 28017.4 |
602 | 2021-01-14 23:29:55 | hardies | 1 | 69583 | 7 | 1.110 | 62687.4 |
601 | 2020-11-29 11:13:03 | hardies | 1 | 69583 | 7 | 1.076 | 64668.2 |
600 | 2020-10-29 14:58:56 | hardies | 1 | 69583 | 7 | 1.250 | 55666.4 |
599 | 2020-10-17 18:01:08 | hardies | 1 | 69583 | 7 | 1.233 | 56433.9 |
598 | 2020-10-15 01:42:50 | hardies | 1 | 69583 | 7 | 1.296 | 53690.6 |
597 | 2020-09-18 10:29:45 | hardies | 1 | 69583 | 7 | 1.110 | 62687.4 |
596 | 2020-09-14 18:57:54 | hardies | 1 | 69583 | 7 | 1.096 | 63488.1 |
595 | 2020-08-20 10:05:47 | hardies | 1 | 69583 | 7 | 1.250 | 55666.4 |
594 | 2020-07-22 06:17:33 | hardies | 1 | 69583 | 7 | 1.160 | 59985.3 |
593 | 2020-07-15 16:06:02 | hardies | 1 | 69583 | 7 | 1.203 | 57841.2 |
592 | 2020-05-16 07:13:41 | hardies | 1 | 69583 | 7 | 1.186 | 58670.3 |
591 | 2020-04-07 17:26:53 | hardies | 1 | 69583 | 7 | 1.360 | 51164.0 |
590 | 2020-03-27 22:12:13 | hardies | 1 | 69583 | 7 | 1.330 | 52318.0 |
589 | 2020-03-26 21:51:49 | hardies | 1 | 69583 | 7 | 1.220 | 57035.2 |
588 | 2020-03-24 10:09:25 | hardies | 1 | 69583 | 7 | 2.563 | 27149.0 |
587 | 2020-03-23 15:27:01 | hardies | 1 | 69583 | 7 | 1.093 | 63662.4 |
586 | 2020-03-20 01:13:10 | hardies | 1 | 69583 | 7 | 1.203 | 57841.2 |
585 | 2020-03-07 19:51:17 | hardies | 1 | 69583 | 7 | 1.080 | 64428.7 |
584 | 2020-03-06 00:36:31 | hardies | 1 | 69583 | 7 | 1.233 | 56433.9 |
583 | 2020-03-05 23:06:24 | hardies | 1 | 69583 | 7 | 1.250 | 55666.4 |
582 | 2020-02-26 09:40:54 | hardies | 1 | 69583 | 7 | 1.313 | 52995.4 |