History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canned"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
709 | 2024-04-23 20:55:32 | canned | 1 | 48755 | 15 | 1.030 | 47335.0 |
708 | 2024-04-08 02:27:42 | canned | 1 | 48755 | 15 | 2.016 | 24184.0 |
707 | 2024-04-08 02:26:39 | canned | 1 | 48755 | 15 | 2.296 | 21234.8 |
706 | 2024-03-28 01:01:44 | canned | 1 | 48755 | 15 | 1.096 | 44484.5 |
705 | 2024-01-31 12:42:38 | canned | 1 | 48755 | 15 | 0.890 | 54780.9 |
704 | 2024-01-11 06:14:34 | canned | 1 | 48755 | 15 | 0.936 | 52088.7 |
703 | 2024-01-06 21:30:15 | canned | 2 | 82551 | 186 | 2.670 | 30918.0 |
702 | 2023-12-27 13:16:57 | canned | 1 | 48755 | 15 | 0.780 | 62506.4 |
701 | 2023-12-10 22:26:58 | canned | 2 | 82551 | 186 | 2.576 | 32046.2 |
700 | 2023-11-27 10:11:56 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
699 | 2023-11-21 03:54:54 | canned | 1 | 48755 | 15 | 0.783 | 62266.9 |
698 | 2023-11-18 21:20:23 | canned | 1 | 48755 | 15 | 0.923 | 52822.3 |
697 | 2023-11-06 14:33:56 | canned | 2 | 82551 | 186 | 2.563 | 32208.7 |
696 | 2023-10-31 14:55:19 | canned | 1 | 48755 | 15 | 0.920 | 52994.6 |
695 | 2023-10-21 05:38:52 | canned | 1 | 48755 | 15 | 0.826 | 59025.4 |
694 | 2023-10-20 04:09:59 | canned | 1 | 48755 | 15 | 0.876 | 55656.4 |
693 | 2023-10-19 10:44:26 | canned | 1 | 48755 | 15 | 0.843 | 57835.1 |
692 | 2023-10-15 21:37:37 | canned | 1 | 48755 | 15 | 0.940 | 51867.0 |
691 | 2023-10-14 22:35:56 | canned | 1 | 48755 | 15 | 0.906 | 53813.5 |
690 | 2023-09-26 02:38:13 | canned | 1 | 48755 | 15 | 0.873 | 55847.7 |
689 | 2023-09-16 14:18:16 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
688 | 2023-09-12 21:07:29 | canned | 1 | 48755 | 15 | 0.966 | 50471.0 |
687 | 2023-09-11 22:50:21 | canned | 2 | 82551 | 186 | 2.593 | 31836.1 |
686 | 2023-09-11 02:31:39 | canned | 1 | 48755 | 15 | 0.890 | 54780.9 |
685 | 2023-09-07 22:13:45 | canned | 2 | 82551 | 186 | 2.453 | 33653.1 |
684 | 2023-09-05 08:57:43 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
683 | 2023-08-16 23:49:48 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
682 | 2023-08-14 11:14:52 | canned | 1 | 48755 | 15 | 0.750 | 65006.7 |
681 | 2023-08-12 17:01:14 | canned | 1 | 48755 | 15 | 0.893 | 54596.9 |
680 | 2023-08-12 04:27:48 | canned | 1 | 48755 | 15 | 0.843 | 57835.1 |
679 | 2023-08-11 04:56:21 | canned | 1 | 48755 | 15 | 1.750 | 27860.0 |
678 | 2023-08-08 14:39:20 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
677 | 2023-08-06 21:56:45 | canned | 1 | 48755 | 15 | 0.890 | 54780.9 |
676 | 2023-07-28 17:25:57 | canned | 1 | 48755 | 15 | 1.796 | 27146.4 |
675 | 2023-07-27 00:16:16 | canned | 1 | 48755 | 15 | 0.843 | 57835.1 |
674 | 2023-07-26 00:01:49 | canned | 1 | 48755 | 15 | 0.843 | 57835.1 |
673 | 2023-07-23 21:23:06 | canned | 1 | 48755 | 15 | 0.860 | 56691.9 |
672 | 2023-07-22 18:28:21 | canned | 1 | 48755 | 15 | 0.780 | 62506.4 |
671 | 2023-07-21 06:50:46 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
670 | 2023-07-21 00:42:39 | canned | 1 | 48755 | 15 | 0.783 | 62266.9 |
669 | 2023-07-19 12:24:14 | canned | 1 | 48755 | 15 | 0.780 | 62506.4 |
668 | 2023-07-11 14:38:00 | canned | 1 | 48755 | 15 | 0.780 | 62506.4 |
667 | 2023-07-10 18:28:19 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
666 | 2023-07-10 04:35:13 | canned | 1 | 48755 | 15 | 0.783 | 62266.9 |
665 | 2023-06-16 08:15:57 | canned | 1 | 48755 | 15 | 0.846 | 57630.0 |
664 | 2023-05-25 06:34:04 | canned | 2 | 82551 | 186 | 2.156 | 38289.0 |
663 | 2023-05-15 06:33:48 | canned | 1 | 48755 | 15 | 0.780 | 62506.4 |
662 | 2023-05-12 00:40:45 | canned | 1 | 48755 | 15 | 0.750 | 65006.7 |
661 | 2023-05-05 19:17:12 | canned | 1 | 48755 | 15 | 0.843 | 57835.1 |
660 | 2023-05-04 22:10:38 | canned | 1 | 48755 | 15 | 0.750 | 65006.7 |
659 | 2023-04-28 02:57:17 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
658 | 2023-04-06 23:20:09 | canned | 1 | 48755 | 15 | 0.860 | 56691.9 |
657 | 2023-03-25 11:31:21 | canned | 1 | 48755 | 15 | 0.890 | 54780.9 |
656 | 2023-03-04 18:18:12 | canned | 2 | 82551 | 186 | 2.156 | 38289.0 |
655 | 2023-03-04 00:41:36 | canned | 1 | 48755 | 15 | 0.750 | 65006.7 |
654 | 2023-01-13 22:02:58 | canned | 1 | 48755 | 15 | 0.750 | 65006.7 |
653 | 2023-01-05 07:54:26 | canned | 1 | 48755 | 15 | 0.750 | 65006.7 |
652 | 2023-01-01 17:15:39 | canned | 1 | 48755 | 15 | 0.763 | 63899.1 |
651 | 2022-12-27 20:42:54 | canned | 1 | 48755 | 15 | 0.750 | 65006.7 |
650 | 2022-12-26 19:02:59 | canned | 2 | 82551 | 186 | 2.406 | 34310.5 |
649 | 2022-12-11 23:59:56 | canned | 2 | 82551 | 186 | 2.750 | 30018.5 |
648 | 2022-11-29 19:21:10 | canned | 1 | 48755 | 15 | 0.843 | 57835.1 |
647 | 2022-11-22 21:18:32 | canned | 2 | 82551 | 186 | 2.593 | 31836.1 |
646 | 2022-11-21 20:30:08 | canned | 1 | 48755 | 15 | 0.873 | 55847.7 |
645 | 2022-11-20 19:49:11 | canned | 2 | 82551 | 186 | 2.203 | 37472.1 |
644 | 2022-11-10 04:32:55 | canned | 2 | 82551 | 186 | 2.500 | 33020.4 |
643 | 2022-11-04 04:27:20 | canned | 2 | 82551 | 186 | 2.220 | 37185.1 |
642 | 2022-10-13 12:02:02 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
641 | 2022-10-05 19:28:56 | canned | 1 | 48755 | 15 | 0.783 | 62266.9 |
640 | 2022-10-04 22:46:36 | canned | 2 | 82551 | 186 | 2.236 | 36919.1 |
639 | 2022-09-21 19:39:13 | canned | 1 | 48755 | 15 | 0.763 | 63899.1 |
638 | 2022-09-14 13:59:49 | canned | 1 | 48755 | 15 | 0.923 | 52822.3 |
637 | 2022-09-01 18:37:56 | canned | 1 | 48755 | 15 | 0.813 | 59969.2 |
636 | 2022-08-31 07:58:49 | canned | 1 | 48755 | 15 | 0.873 | 55847.7 |
635 | 2022-08-22 00:25:22 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
634 | 2022-08-14 20:52:09 | canned | 1 | 48755 | 15 | 0.780 | 62506.4 |
633 | 2022-08-06 14:08:32 | canned | 1 | 48755 | 15 | 0.826 | 59025.4 |
632 | 2022-07-12 21:25:24 | canned | 2 | 82551 | 186 | 2.190 | 37694.5 |
631 | 2022-07-10 11:28:48 | canned | 1 | 48755 | 15 | 0.796 | 61250.0 |
630 | 2022-07-03 05:06:59 | canned | 1 | 48755 | 15 | 0.780 | 62506.4 |
629 | 2022-07-02 03:36:21 | canned | 1 | 48755 | 15 | 0.763 | 63899.1 |
628 | 2022-06-26 13:25:38 | canned | 1 | 48755 | 15 | 0.796 | 61250.0 |
627 | 2022-06-19 10:19:44 | canned | 1 | 48755 | 15 | 0.783 | 62266.9 |
626 | 2022-05-23 02:32:08 | canned | 1 | 48755 | 15 | 0.796 | 61250.0 |
625 | 2022-05-13 21:57:31 | canned | 1 | 48755 | 15 | 1.220 | 39963.1 |
624 | 2022-04-27 17:02:36 | canned | 1 | 48755 | 15 | 0.986 | 49447.3 |
623 | 2022-04-27 00:37:43 | canned | 1 | 48755 | 15 | 0.780 | 62506.4 |
622 | 2022-04-26 13:00:16 | canned | 1 | 48755 | 15 | 0.813 | 59969.2 |
621 | 2022-04-26 01:28:10 | canned | 1 | 48755 | 15 | 1.013 | 48129.3 |
620 | 2022-04-25 10:43:26 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
619 | 2022-04-24 19:21:16 | canned | 1 | 48755 | 15 | 1.516 | 32160.3 |
618 | 2022-04-23 07:57:01 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
617 | 2022-04-22 10:37:55 | canned | 1 | 48755 | 15 | 0.766 | 63648.8 |
616 | 2022-04-21 16:31:24 | canned | 1 | 48755 | 15 | 0.970 | 50262.9 |
615 | 2022-04-21 03:27:49 | canned | 1 | 48755 | 15 | 0.876 | 55656.4 |
614 | 2022-04-20 11:03:28 | canned | 1 | 48755 | 15 | 0.986 | 49447.3 |
613 | 2022-04-19 22:00:07 | canned | 1 | 48755 | 15 | 1.190 | 40970.6 |
612 | 2022-04-19 10:37:58 | canned | 1 | 48755 | 15 | 1.156 | 42175.6 |
611 | 2022-04-18 15:02:20 | canned | 1 | 48755 | 15 | 0.843 | 57835.1 |
610 | 2022-04-17 20:36:26 | canned | 1 | 48755 | 15 | 0.953 | 51159.5 |