History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bannock"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
695 | 2024-05-14 21:44:31 | bannock | 4 | 151207 | 863 | 29.376 | 5147.3 |
694 | 2024-05-14 12:08:45 | bannock | 4 | 151207 | 863 | 16.643 | 9085.3 |
693 | 2024-05-12 19:57:24 | bannock | 4 | 151207 | 863 | 25.190 | 6002.7 |
692 | 2024-05-12 19:47:55 | bannock | 4 | 151207 | 863 | 24.080 | 6279.4 |
691 | 2024-05-08 02:42:29 | bannock | 1 | 69583 | 3 | 3.876 | 17952.3 |
690 | 2024-05-04 03:43:48 | bannock | 4 | 151207 | 863 | 19.393 | 7797.0 |
689 | 2024-05-02 18:44:48 | bannock | 4 | 151207 | 863 | 15.063 | 10038.3 |
688 | 2024-05-02 12:37:33 | bannock | 1 | 69583 | 3 | 2.123 | 32775.8 |
687 | 2024-05-02 10:21:55 | bannock | 4 | 151207 | 863 | 12.640 | 11962.6 |
686 | 2024-05-01 17:06:06 | bannock | 1 | 69583 | 3 | 3.843 | 18106.4 |
685 | 2024-04-28 07:02:39 | bannock | 1 | 69583 | 3 | 1.280 | 54361.7 |
684 | 2024-04-10 03:03:07 | bannock | 4 | 151207 | 863 | 13.406 | 11279.1 |
683 | 2024-04-07 23:23:28 | bannock | 1 | 69583 | 3 | 2.640 | 26357.2 |
682 | 2024-04-07 16:15:30 | bannock | 1 | 69583 | 3 | 3.190 | 21812.9 |
681 | 2024-04-06 20:53:31 | bannock | 4 | 151207 | 863 | 15.810 | 9564.0 |
680 | 2024-04-04 01:50:20 | bannock | 4 | 151207 | 863 | 29.876 | 5061.2 |
679 | 2024-04-04 01:50:23 | bannock | 3 | 134027 | 86 | 20.343 | 6588.4 |
678 | 2024-04-03 15:43:37 | bannock | 3 | 134027 | 86 | 23.453 | 5714.7 |
677 | 2024-04-02 03:18:33 | bannock | 4 | 151207 | 863 | 24.236 | 6238.9 |
676 | 2024-04-02 03:18:36 | bannock | 2 | 107671 | 6 | 7.766 | 13864.4 |
675 | 2024-04-02 03:18:34 | bannock | 3 | 134027 | 86 | 9.580 | 13990.3 |
674 | 2024-04-02 03:16:10 | bannock | 1 | 69583 | 3 | 1.310 | 53116.8 |
673 | 2024-03-31 14:29:15 | bannock | 1 | 69583 | 3 | 1.436 | 48456.1 |
672 | 2024-03-10 22:04:11 | bannock | 4 | 151207 | 863 | 26.016 | 5812.1 |
671 | 2024-03-07 19:42:01 | bannock | 4 | 151207 | 863 | 16.986 | 8901.9 |
670 | 2024-03-07 19:17:09 | bannock | 4 | 151207 | 863 | 24.800 | 6097.1 |
669 | 2024-03-07 19:17:13 | bannock | 2 | 107671 | 6 | 5.890 | 18280.3 |
668 | 2024-03-07 17:54:49 | bannock | 1 | 69583 | 3 | 3.123 | 22280.8 |
667 | 2024-03-05 09:43:36 | bannock | 3 | 134027 | 86 | 15.453 | 8673.2 |
666 | 2024-03-05 08:20:10 | bannock | 4 | 151207 | 863 | 15.296 | 9885.4 |
665 | 2024-03-04 16:39:39 | bannock | 4 | 151207 | 863 | 16.656 | 9078.2 |
664 | 2024-03-04 00:50:46 | bannock | 3 | 134027 | 86 | 12.656 | 10590.0 |
663 | 2024-03-04 00:50:45 | bannock | 2 | 107671 | 6 | 3.860 | 27894.0 |
662 | 2024-03-03 08:31:03 | bannock | 4 | 151207 | 863 | 12.640 | 11962.6 |
661 | 2024-03-03 02:30:37 | bannock | 4 | 151207 | 863 | 30.393 | 4975.1 |
660 | 2024-03-02 20:53:40 | bannock | 3 | 134027 | 86 | 16.313 | 8216.0 |
659 | 2024-03-02 20:53:38 | bannock | 4 | 151207 | 863 | 16.800 | 9000.4 |
658 | 2024-03-02 20:53:34 | bannock | 2 | 107671 | 6 | 5.860 | 18373.9 |
657 | 2024-03-02 20:53:16 | bannock | 1 | 69583 | 3 | 1.406 | 49490.0 |
656 | 2024-03-02 10:19:15 | bannock | 1 | 69583 | 3 | 1.406 | 49490.0 |
655 | 2024-02-16 01:30:53 | bannock | 3 | 134027 | 86 | 16.013 | 8369.9 |
654 | 2024-02-13 10:23:05 | bannock | 3 | 134027 | 86 | 20.016 | 6696.0 |
653 | 2024-02-09 20:25:01 | bannock | 4 | 151207 | 863 | 13.080 | 11560.2 |
652 | 2024-02-08 09:02:24 | bannock | 3 | 134027 | 86 | 8.640 | 15512.4 |
651 | 2024-02-05 17:49:52 | bannock | 4 | 151207 | 863 | 13.110 | 11533.7 |
650 | 2024-02-02 22:33:20 | bannock | 2 | 107671 | 6 | 2.830 | 38046.3 |
649 | 2024-02-01 07:43:44 | bannock | 2 | 107671 | 6 | 3.436 | 31336.1 |
648 | 2024-02-01 07:41:40 | bannock | 1 | 69583 | 3 | 1.280 | 54361.7 |
647 | 2024-01-23 03:07:29 | bannock | 4 | 151207 | 863 | 38.563 | 3921.0 |
646 | 2024-01-22 12:05:35 | bannock | 4 | 151207 | 863 | 13.893 | 10883.7 |
645 | 2024-01-17 03:07:57 | bannock | 4 | 151207 | 863 | 9.920 | 15242.6 |
644 | 2024-01-15 16:00:10 | bannock | 3 | 134027 | 86 | 6.156 | 21771.8 |
643 | 2024-01-12 04:21:02 | bannock | 1 | 69583 | 3 | 1.170 | 59472.6 |
642 | 2024-01-08 02:27:34 | bannock | 3 | 134027 | 86 | 8.716 | 15377.1 |
641 | 2024-01-02 07:23:20 | bannock | 1 | 69583 | 3 | 1.140 | 61037.7 |
640 | 2023-12-15 03:28:45 | bannock | 4 | 151207 | 863 | 11.610 | 13023.9 |
639 | 2023-12-12 21:28:16 | bannock | 4 | 151207 | 863 | 17.860 | 8466.2 |
638 | 2023-12-12 12:11:25 | bannock | 1 | 69583 | 3 | 1.220 | 57035.2 |
637 | 2023-12-10 18:18:04 | bannock | 1 | 69583 | 3 | 1.063 | 65459.1 |
636 | 2023-11-26 13:09:14 | bannock | 1 | 69583 | 3 | 1.216 | 57222.9 |
635 | 2023-11-15 13:07:53 | bannock | 3 | 134027 | 86 | 5.860 | 22871.5 |
634 | 2023-11-11 16:33:57 | bannock | 4 | 151207 | 863 | 10.423 | 14507.1 |
633 | 2023-10-25 08:48:52 | bannock | 1 | 69583 | 3 | 1.220 | 57035.2 |
632 | 2023-10-12 04:10:30 | bannock | 1 | 69583 | 3 | 1.140 | 61037.7 |
631 | 2023-09-27 02:31:03 | bannock | 1 | 69583 | 3 | 1.140 | 61037.7 |
630 | 2023-08-17 06:10:16 | bannock | 3 | 134027 | 86 | 7.156 | 18729.3 |
629 | 2023-08-14 17:38:03 | bannock | 4 | 151207 | 863 | 11.983 | 12618.5 |
628 | 2023-07-24 23:37:28 | bannock | 1 | 69583 | 3 | 1.140 | 61037.7 |
627 | 2023-06-18 11:03:34 | bannock | 1 | 69583 | 3 | 1.360 | 51164.0 |
626 | 2023-05-11 09:51:02 | bannock | 4 | 151207 | 863 | 10.420 | 14511.2 |
625 | 2023-05-02 01:30:34 | bannock | 3 | 134027 | 86 | 5.766 | 23244.4 |
624 | 2023-04-29 10:46:20 | bannock | 4 | 151207 | 863 | 10.500 | 14400.7 |
623 | 2023-04-23 11:59:25 | bannock | 1 | 69583 | 3 | 1.236 | 56296.9 |
622 | 2023-02-27 07:51:35 | bannock | 1 | 69583 | 3 | 1.186 | 58670.3 |
621 | 2023-02-16 01:19:59 | bannock | 1 | 69583 | 3 | 1.186 | 58670.3 |
620 | 2023-02-07 07:50:57 | bannock | 3 | 134027 | 86 | 6.546 | 20474.6 |
619 | 2023-02-03 16:33:21 | bannock | 4 | 151207 | 863 | 9.563 | 15811.7 |
618 | 2022-12-14 01:14:04 | bannock | 1 | 69583 | 3 | 1.063 | 65459.1 |
617 | 2022-11-18 01:33:24 | bannock | 3 | 134027 | 86 | 5.763 | 23256.5 |
616 | 2022-11-17 13:40:39 | bannock | 4 | 151207 | 863 | 10.373 | 14577.0 |
615 | 2022-11-09 01:20:06 | bannock | 4 | 151207 | 863 | 9.766 | 15483.0 |
614 | 2022-11-07 00:26:49 | bannock | 1 | 69583 | 3 | 1.080 | 64428.7 |
613 | 2022-11-05 15:19:13 | bannock | 4 | 151207 | 863 | 11.360 | 13310.5 |
612 | 2022-10-29 02:35:50 | bannock | 4 | 151207 | 863 | 12.220 | 12373.7 |
611 | 2022-10-01 12:22:55 | bannock | 4 | 151207 | 863 | 10.000 | 15120.7 |
610 | 2022-08-23 22:24:40 | bannock | 4 | 151207 | 863 | 10.643 | 14207.2 |
609 | 2022-08-20 21:33:08 | bannock | 1 | 69583 | 3 | 1.093 | 63662.4 |
608 | 2022-07-17 12:19:43 | bannock | 1 | 69583 | 3 | 1.140 | 61037.7 |
607 | 2022-07-13 17:54:39 | bannock | 1 | 69583 | 3 | 1.123 | 61961.7 |
606 | 2022-07-03 17:55:21 | bannock | 4 | 151207 | 863 | 9.796 | 15435.6 |
605 | 2022-06-21 05:23:17 | bannock | 4 | 151207 | 863 | 9.720 | 15556.3 |
604 | 2022-06-20 23:08:30 | bannock | 4 | 151207 | 863 | 11.266 | 13421.5 |
603 | 2022-06-13 14:30:22 | bannock | 4 | 151207 | 863 | 10.890 | 13884.9 |
602 | 2022-06-08 06:05:32 | bannock | 4 | 151207 | 863 | 10.203 | 14819.9 |
601 | 2022-05-12 21:59:16 | bannock | 4 | 151207 | 863 | 11.890 | 12717.2 |
600 | 2022-04-27 07:22:17 | bannock | 3 | 134027 | 86 | 7.030 | 19065.0 |
599 | 2022-04-12 20:08:51 | bannock | 1 | 69583 | 3 | 1.186 | 58670.3 |
598 | 2022-04-05 16:16:51 | bannock | 4 | 151207 | 863 | 19.220 | 7867.2 |
597 | 2022-03-13 08:15:20 | bannock | 1 | 69583 | 3 | 1.140 | 61037.7 |
596 | 2022-03-09 22:22:52 | bannock | 1 | 69583 | 3 | 1.483 | 46920.4 |