History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roaster"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
721 | 2024-05-03 22:47:05 | roaster | 1 | 69583 | 13 | 1.983 | 35089.8 |
720 | 2024-04-26 03:33:42 | roaster | 2 | 107671 | 86 | 3.106 | 34665.5 |
719 | 2024-04-24 23:55:52 | roaster | 1 | 69583 | 13 | 1.876 | 37091.2 |
718 | 2024-04-04 11:33:58 | roaster | 2 | 107671 | 86 | 3.030 | 35535.0 |
717 | 2024-04-02 22:00:44 | roaster | 3 | 134027 | 764 | 12.613 | 10626.1 |
716 | 2024-04-01 05:31:30 | roaster | 1 | 69583 | 13 | 1.216 | 57222.9 |
715 | 2024-04-01 05:30:56 | roaster | 3 | 134027 | 764 | 9.140 | 14663.8 |
714 | 2024-03-28 18:17:54 | roaster | 3 | 134027 | 764 | 7.263 | 18453.4 |
713 | 2024-03-28 05:55:40 | roaster | 1 | 69583 | 13 | 1.200 | 57985.8 |
712 | 2024-03-20 15:07:35 | roaster | 1 | 69583 | 13 | 1.250 | 55666.4 |
711 | 2024-02-02 22:58:35 | roaster | 2 | 107671 | 86 | 3.826 | 28141.9 |
710 | 2024-02-02 22:51:19 | roaster | 3 | 134027 | 764 | 7.373 | 18178.1 |
709 | 2024-01-31 09:49:23 | roaster | 3 | 134027 | 764 | 6.346 | 21119.9 |
708 | 2024-01-22 10:56:23 | roaster | 1 | 69583 | 13 | 2.656 | 26198.4 |
707 | 2024-01-19 10:24:23 | roaster | 2 | 107671 | 86 | 3.143 | 34257.4 |
706 | 2024-01-19 04:08:38 | roaster | 3 | 134027 | 764 | 7.640 | 17542.8 |
705 | 2024-01-14 17:09:49 | roaster | 3 | 134027 | 764 | 9.440 | 14197.8 |
704 | 2024-01-09 13:45:52 | roaster | 3 | 134027 | 764 | 6.076 | 22058.4 |
703 | 2023-12-19 18:43:45 | roaster | 1 | 69583 | 13 | 1.093 | 63662.4 |
702 | 2023-12-06 20:50:27 | roaster | 2 | 107671 | 86 | 2.936 | 36672.7 |
701 | 2023-11-23 11:31:42 | roaster | 1 | 69583 | 13 | 1.076 | 64668.2 |
700 | 2023-11-17 00:49:04 | roaster | 1 | 69583 | 13 | 1.123 | 61961.7 |
699 | 2023-11-15 19:52:05 | roaster | 1 | 69583 | 13 | 1.096 | 63488.1 |
698 | 2023-11-02 13:27:04 | roaster | 3 | 134027 | 764 | 11.690 | 11465.1 |
697 | 2023-10-23 10:04:59 | roaster | 1 | 69583 | 13 | 1.233 | 56433.9 |
696 | 2023-10-19 22:55:16 | roaster | 1 | 69583 | 13 | 2.216 | 31400.3 |
695 | 2023-10-19 17:39:15 | roaster | 3 | 134027 | 764 | 15.843 | 8459.7 |
694 | 2023-10-18 05:35:17 | roaster | 3 | 134027 | 764 | 6.000 | 22337.8 |
693 | 2023-10-08 09:12:04 | roaster | 1 | 69583 | 13 | 1.236 | 56296.9 |
692 | 2023-09-23 10:59:34 | roaster | 1 | 69583 | 13 | 1.266 | 54962.9 |
691 | 2023-09-15 02:42:06 | roaster | 1 | 69583 | 13 | 1.233 | 56433.9 |
690 | 2023-09-05 10:25:10 | roaster | 2 | 107671 | 86 | 2.860 | 37647.2 |
689 | 2023-08-04 22:53:34 | roaster | 1 | 69583 | 13 | 1.076 | 64668.2 |
688 | 2023-07-30 07:13:08 | roaster | 3 | 134027 | 764 | 5.906 | 22693.4 |
687 | 2023-05-22 10:23:55 | roaster | 1 | 69583 | 13 | 1.076 | 64668.2 |
686 | 2023-05-06 03:07:03 | roaster | 1 | 69583 | 13 | 1.123 | 61961.7 |
685 | 2023-04-10 15:48:44 | roaster | 3 | 134027 | 764 | 5.860 | 22871.5 |
684 | 2023-02-27 20:52:07 | roaster | 1 | 69583 | 13 | 1.063 | 65459.1 |
683 | 2023-02-18 12:23:12 | roaster | 2 | 107671 | 86 | 2.843 | 37872.3 |
682 | 2023-01-29 19:49:50 | roaster | 1 | 69583 | 13 | 1.106 | 62914.1 |
681 | 2023-01-17 11:27:47 | roaster | 3 | 134027 | 764 | 6.500 | 20619.5 |
680 | 2022-12-23 03:39:49 | roaster | 1 | 69583 | 13 | 1.076 | 64668.2 |
679 | 2022-11-30 05:39:27 | roaster | 2 | 107671 | 86 | 2.873 | 37476.9 |
678 | 2022-10-28 03:31:20 | roaster | 3 | 134027 | 764 | 7.046 | 19021.7 |
677 | 2022-10-10 19:42:52 | roaster | 1 | 69583 | 13 | 1.203 | 57841.2 |
676 | 2022-10-04 16:55:29 | roaster | 1 | 69583 | 13 | 1.110 | 62687.4 |
675 | 2022-09-11 15:40:00 | roaster | 1 | 69583 | 13 | 1.093 | 63662.4 |
674 | 2022-07-08 20:53:21 | roaster | 2 | 107671 | 86 | 2.953 | 36461.6 |
673 | 2022-06-13 05:59:15 | roaster | 3 | 134027 | 764 | 6.030 | 22226.7 |
672 | 2022-05-28 00:59:20 | roaster | 1 | 69583 | 13 | 1.080 | 64428.7 |
671 | 2022-05-21 16:53:40 | roaster | 3 | 134027 | 764 | 6.000 | 22337.8 |
670 | 2022-05-18 18:04:59 | roaster | 1 | 69583 | 13 | 1.143 | 60877.5 |
669 | 2022-04-22 22:57:23 | roaster | 1 | 69583 | 13 | 1.186 | 58670.3 |
668 | 2022-02-17 20:33:00 | roaster | 2 | 107671 | 86 | 3.313 | 32499.5 |
667 | 2022-01-30 03:01:44 | roaster | 1 | 69583 | 13 | 1.123 | 61961.7 |
666 | 2022-01-26 16:18:43 | roaster | 1 | 69583 | 13 | 1.186 | 58670.3 |
665 | 2022-01-20 18:38:24 | roaster | 1 | 69583 | 13 | 1.233 | 56433.9 |
664 | 2022-01-16 18:55:41 | roaster | 3 | 134027 | 764 | 6.250 | 21444.3 |
663 | 2021-11-16 09:44:17 | roaster | 1 | 69583 | 13 | 1.090 | 63837.6 |
662 | 2021-10-23 01:56:54 | roaster | 3 | 134027 | 764 | 7.203 | 18607.1 |
661 | 2021-10-10 02:03:48 | roaster | 1 | 69583 | 13 | 1.220 | 57035.2 |
660 | 2021-09-29 23:03:23 | roaster | 1 | 69583 | 13 | 1.220 | 57035.2 |
659 | 2021-09-27 08:31:24 | roaster | 1 | 69583 | 13 | 1.203 | 57841.2 |
658 | 2021-08-28 10:43:20 | roaster | 1 | 69583 | 13 | 1.266 | 54962.9 |
657 | 2021-08-26 05:54:54 | roaster | 1 | 69583 | 13 | 1.220 | 57035.2 |
656 | 2021-07-25 10:10:55 | roaster | 1 | 69583 | 13 | 1.060 | 65644.3 |
655 | 2021-07-08 05:20:20 | roaster | 1 | 69583 | 13 | 1.236 | 56296.9 |
654 | 2021-07-02 14:14:09 | roaster | 3 | 134027 | 764 | 6.376 | 21020.5 |
653 | 2021-06-19 08:17:35 | roaster | 3 | 134027 | 764 | 5.970 | 22450.1 |
652 | 2021-06-02 07:21:37 | roaster | 3 | 134027 | 764 | 6.750 | 19855.9 |
651 | 2021-06-02 05:28:58 | roaster | 3 | 134027 | 764 | 6.533 | 20515.4 |
650 | 2021-05-15 15:57:02 | roaster | 1 | 69583 | 13 | 1.236 | 56296.9 |
649 | 2021-05-07 23:44:05 | roaster | 3 | 134027 | 764 | 6.750 | 19855.9 |
648 | 2021-04-15 08:31:56 | roaster | 3 | 134027 | 764 | 7.436 | 18024.1 |
647 | 2021-04-08 10:03:20 | roaster | 1 | 69583 | 13 | 1.250 | 55666.4 |
646 | 2021-04-04 06:11:03 | roaster | 1 | 69583 | 13 | 1.283 | 54234.6 |
645 | 2021-03-18 11:42:40 | roaster | 1 | 69583 | 13 | 1.283 | 54234.6 |
644 | 2021-02-03 15:36:30 | roaster | 1 | 69583 | 13 | 1.126 | 61796.6 |
643 | 2021-01-28 10:54:18 | roaster | 3 | 134027 | 764 | 7.983 | 16789.1 |
642 | 2021-01-28 08:26:59 | roaster | 1 | 69583 | 13 | 1.156 | 60192.9 |
641 | 2020-12-30 16:10:52 | roaster | 1 | 69583 | 13 | 1.093 | 63662.4 |
640 | 2020-12-30 05:48:34 | roaster | 1 | 69583 | 13 | 1.250 | 55666.4 |
639 | 2020-10-31 03:33:45 | roaster | 1 | 69583 | 13 | 1.266 | 54962.9 |
638 | 2020-10-31 01:33:45 | roaster | 1 | 69583 | 13 | 1.280 | 54361.7 |
637 | 2020-10-22 18:34:16 | roaster | 1 | 69583 | 13 | 1.076 | 64668.2 |
636 | 2020-10-09 13:27:00 | roaster | 1 | 69583 | 13 | 1.140 | 61037.7 |
635 | 2020-09-26 22:45:46 | roaster | 1 | 69583 | 13 | 1.110 | 62687.4 |
634 | 2020-09-17 03:02:47 | roaster | 1 | 69583 | 13 | 1.326 | 52475.9 |
633 | 2020-09-05 20:47:55 | roaster | 1 | 69583 | 13 | 1.063 | 65459.1 |
632 | 2020-07-23 00:52:55 | roaster | 1 | 69583 | 13 | 1.156 | 60192.9 |
631 | 2020-06-14 23:40:27 | roaster | 1 | 69583 | 13 | 1.110 | 62687.4 |
630 | 2020-06-12 00:04:46 | roaster | 1 | 69583 | 13 | 1.126 | 61796.6 |
629 | 2020-06-02 02:30:19 | roaster | 1 | 69583 | 13 | 1.143 | 60877.5 |
628 | 2020-03-28 04:02:14 | roaster | 1 | 69583 | 13 | 1.203 | 57841.2 |
627 | 2020-03-27 04:53:41 | roaster | 1 | 69583 | 13 | 1.190 | 58473.1 |
626 | 2020-03-25 19:29:30 | roaster | 1 | 69583 | 13 | 1.300 | 53525.4 |
625 | 2020-03-22 03:08:03 | roaster | 1 | 69583 | 13 | 1.203 | 57841.2 |
624 | 2020-03-20 01:44:40 | roaster | 1 | 69583 | 13 | 1.063 | 65459.1 |
623 | 2020-03-12 03:08:20 | roaster | 1 | 69583 | 13 | 1.200 | 57985.8 |
622 | 2020-03-04 14:10:06 | roaster | 1 | 69583 | 13 | 1.203 | 57841.2 |