History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oca"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
821 | 2024-04-27 11:10:48 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
820 | 2024-04-27 01:04:32 | oca | 1 | 5146 | 11 | 0.296 | 17385.1 |
819 | 2024-04-26 10:29:54 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
818 | 2024-04-05 00:28:41 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
817 | 2024-04-04 18:14:20 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
816 | 2024-04-02 17:26:43 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
815 | 2024-03-31 00:54:21 | oca | 2 | 14084 | 267 | 1.373 | 10257.8 |
814 | 2024-03-31 00:50:04 | oca | 2 | 14084 | 267 | 0.893 | 15771.6 |
813 | 2024-03-30 23:42:07 | oca | 1 | 5146 | 11 | 0.190 | 27084.2 |
812 | 2024-03-05 19:42:41 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
811 | 2024-03-02 16:16:21 | oca | 1 | 5146 | 11 | 0.190 | 27084.2 |
810 | 2024-02-29 17:51:10 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
809 | 2024-02-25 15:50:00 | oca | 1 | 5146 | 11 | 0.156 | 32987.2 |
808 | 2024-02-25 15:45:34 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
807 | 2024-02-03 00:47:18 | oca | 1 | 5146 | 11 | 0.203 | 25349.8 |
806 | 2024-02-01 09:55:39 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
805 | 2024-01-28 12:16:19 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
804 | 2024-01-25 23:53:29 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
803 | 2024-01-05 20:52:23 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
802 | 2023-12-30 16:20:09 | oca | 2 | 14084 | 267 | 0.346 | 40705.2 |
801 | 2023-12-28 01:36:15 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
800 | 2023-12-26 23:57:29 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
799 | 2023-12-25 12:42:41 | oca | 2 | 14084 | 267 | 0.326 | 43202.5 |
798 | 2023-12-23 19:17:07 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
797 | 2023-12-23 02:22:32 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
796 | 2023-12-06 21:18:55 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
795 | 2023-12-06 21:18:55 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
794 | 2023-11-28 01:54:25 | oca | 2 | 14084 | 267 | 0.343 | 41061.2 |
793 | 2023-11-27 11:20:16 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
792 | 2023-11-22 05:42:27 | oca | 2 | 14084 | 267 | 0.360 | 39122.2 |
791 | 2023-11-14 01:47:49 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
790 | 2023-11-13 23:18:50 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
789 | 2023-11-09 05:43:33 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
788 | 2023-10-30 07:26:12 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
787 | 2023-10-27 14:21:28 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
786 | 2023-10-23 17:50:01 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
785 | 2023-10-20 09:44:37 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
784 | 2023-10-19 21:31:54 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
783 | 2023-10-17 07:56:38 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
782 | 2023-10-14 08:43:59 | oca | 2 | 14084 | 267 | 0.343 | 41061.2 |
781 | 2023-10-10 18:56:22 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
780 | 2023-10-07 06:11:32 | oca | 2 | 14084 | 267 | 0.390 | 36112.8 |
779 | 2023-10-03 11:42:43 | oca | 1 | 5146 | 11 | 0.090 | 57177.8 |
778 | 2023-09-26 06:22:47 | oca | 2 | 14084 | 267 | 0.390 | 36112.8 |
777 | 2023-09-23 04:45:51 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
776 | 2023-09-21 15:07:39 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
775 | 2023-08-28 03:33:03 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
774 | 2023-08-23 21:01:07 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
773 | 2023-07-05 03:32:33 | oca | 2 | 14084 | 267 | 0.326 | 43202.5 |
772 | 2023-05-25 16:26:01 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
771 | 2023-05-14 13:17:42 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
770 | 2023-03-23 07:58:23 | oca | 2 | 14084 | 267 | 0.343 | 41061.2 |
769 | 2023-03-22 23:12:04 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
768 | 2023-02-01 04:05:55 | oca | 1 | 5146 | 11 | 0.156 | 32987.2 |
767 | 2023-01-09 10:25:41 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
766 | 2022-12-22 11:43:17 | oca | 2 | 14084 | 267 | 0.373 | 37758.7 |
765 | 2022-10-21 18:45:40 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
764 | 2022-10-06 23:05:38 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
763 | 2022-09-19 21:54:43 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
762 | 2022-09-18 16:12:39 | oca | 1 | 5146 | 11 | 0.156 | 32987.2 |
761 | 2022-09-17 18:48:07 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
760 | 2022-09-10 15:12:46 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
759 | 2022-08-31 02:40:22 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
758 | 2022-08-23 00:32:49 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
757 | 2022-08-19 19:13:05 | oca | 2 | 14084 | 267 | 0.343 | 41061.2 |
756 | 2022-08-09 20:36:57 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
755 | 2022-08-03 00:46:45 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
754 | 2022-07-01 19:43:57 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
753 | 2022-05-25 15:40:25 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
752 | 2022-03-15 13:19:21 | oca | 2 | 14084 | 267 | 0.406 | 34689.7 |
751 | 2022-03-11 10:10:12 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
750 | 2022-02-11 06:25:43 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
749 | 2022-02-09 02:25:19 | oca | 1 | 5146 | 11 | 0.156 | 32987.2 |
748 | 2021-11-28 16:16:00 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
747 | 2021-11-27 16:01:24 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
746 | 2021-10-08 04:16:12 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
745 | 2021-10-06 02:16:18 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
744 | 2021-09-27 01:26:27 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
743 | 2021-09-21 02:40:23 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
742 | 2021-09-01 15:00:50 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
741 | 2021-08-24 20:08:46 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
740 | 2021-08-15 03:37:06 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
739 | 2021-06-23 04:04:40 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
738 | 2021-05-20 18:59:37 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
737 | 2021-04-07 15:23:08 | oca | 2 | 14084 | 267 | 0.390 | 36112.8 |
736 | 2021-02-18 06:12:16 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
735 | 2021-02-15 09:45:51 | oca | 2 | 14084 | 267 | 0.810 | 17387.7 |
734 | 2021-02-04 13:27:12 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
733 | 2021-01-19 01:13:32 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
732 | 2020-12-23 16:09:46 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
731 | 2020-11-14 03:56:33 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
730 | 2020-10-26 02:55:16 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
729 | 2020-10-22 05:19:16 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
728 | 2020-10-12 19:50:41 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
727 | 2020-09-13 22:12:24 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
726 | 2020-09-13 08:08:50 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
725 | 2020-09-09 18:13:26 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
724 | 2020-08-24 02:34:17 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
723 | 2020-08-12 18:55:38 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
722 | 2020-08-04 20:05:40 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |