History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"beers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
853 | 2024-04-21 21:56:02 | beers | 1 | 28756 | 15 | 1.080 | 26625.9 |
852 | 2024-04-03 02:46:20 | beers | 1 | 28756 | 15 | 1.750 | 16432.0 |
851 | 2024-03-31 22:10:58 | beers | 1 | 28756 | 15 | 0.563 | 51076.4 |
850 | 2024-03-31 09:52:00 | beers | 2 | 53800 | 268 | 6.953 | 7737.7 |
849 | 2024-03-31 05:17:51 | beers | 2 | 53800 | 268 | 5.530 | 9728.8 |
848 | 2024-03-31 04:04:20 | beers | 1 | 28756 | 15 | 1.110 | 25906.3 |
847 | 2024-03-29 01:17:26 | beers | 1 | 28756 | 15 | 1.140 | 25224.6 |
846 | 2024-03-12 22:19:42 | beers | 1 | 28756 | 15 | 0.466 | 61708.2 |
845 | 2024-03-03 20:55:12 | beers | 1 | 28756 | 15 | 1.016 | 28303.1 |
844 | 2024-02-27 20:12:53 | beers | 1 | 28756 | 15 | 0.530 | 54256.6 |
843 | 2024-02-16 23:10:06 | beers | 1 | 28756 | 15 | 0.560 | 51350.0 |
842 | 2024-02-01 17:35:55 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
841 | 2024-01-28 18:09:41 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
840 | 2024-01-20 04:52:32 | beers | 2 | 53800 | 268 | 1.563 | 34421.0 |
839 | 2023-12-31 15:22:57 | beers | 2 | 53800 | 268 | 1.390 | 38705.0 |
838 | 2023-12-28 12:16:00 | beers | 2 | 53800 | 268 | 1.373 | 39184.3 |
837 | 2023-12-22 08:24:00 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
836 | 2023-12-04 00:38:58 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
835 | 2023-12-01 14:54:01 | beers | 2 | 53800 | 268 | 1.470 | 36598.6 |
834 | 2023-11-18 09:36:33 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
833 | 2023-11-13 09:17:11 | beers | 1 | 28756 | 15 | 0.516 | 55728.7 |
832 | 2023-11-07 05:37:52 | beers | 1 | 28756 | 15 | 1.013 | 28387.0 |
831 | 2023-11-07 05:37:48 | beers | 1 | 28756 | 15 | 0.580 | 49579.3 |
830 | 2023-11-04 10:17:09 | beers | 1 | 28756 | 15 | 0.483 | 59536.2 |
829 | 2023-11-03 08:41:49 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
828 | 2023-11-02 06:06:11 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
827 | 2023-10-30 19:38:41 | beers | 1 | 28756 | 15 | 0.483 | 59536.2 |
826 | 2023-10-22 07:10:17 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
825 | 2023-10-17 01:44:46 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
824 | 2023-10-14 01:25:23 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
823 | 2023-10-10 14:49:47 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
822 | 2023-10-05 00:16:42 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
821 | 2023-09-24 04:35:09 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
820 | 2023-09-12 14:43:46 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
819 | 2023-09-06 07:15:25 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
818 | 2023-09-04 00:19:38 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
817 | 2023-08-31 19:28:10 | beers | 1 | 28756 | 15 | 0.440 | 65354.5 |
816 | 2023-08-07 05:33:20 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
815 | 2023-07-12 19:06:20 | beers | 1 | 28756 | 15 | 1.013 | 28387.0 |
814 | 2023-05-31 13:44:18 | beers | 1 | 28756 | 15 | 0.420 | 68466.7 |
813 | 2023-05-28 07:51:59 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
812 | 2023-05-08 16:16:55 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
811 | 2023-03-31 14:44:18 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
810 | 2023-02-25 21:04:01 | beers | 1 | 28756 | 15 | 0.440 | 65354.5 |
809 | 2023-02-22 09:07:50 | beers | 1 | 28756 | 15 | 0.483 | 59536.2 |
808 | 2022-12-24 06:27:21 | beers | 1 | 28756 | 15 | 0.530 | 54256.6 |
807 | 2022-11-19 15:45:31 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
806 | 2022-09-10 03:44:29 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
805 | 2022-08-19 04:17:15 | beers | 1 | 28756 | 15 | 0.440 | 65354.5 |
804 | 2022-08-15 20:56:58 | beers | 1 | 28756 | 15 | 0.466 | 61708.2 |
803 | 2022-05-10 06:40:51 | beers | 1 | 28756 | 15 | 0.483 | 59536.2 |
802 | 2022-04-19 05:16:26 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
801 | 2022-02-05 08:15:24 | beers | 1 | 28756 | 15 | 0.483 | 59536.2 |
800 | 2022-01-19 05:56:30 | beers | 1 | 28756 | 15 | 0.546 | 52666.7 |
799 | 2021-11-17 00:38:40 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
798 | 2021-11-15 04:31:20 | beers | 1 | 28756 | 15 | 0.530 | 54256.6 |
797 | 2021-11-04 14:18:57 | beers | 1 | 28756 | 15 | 0.470 | 61183.0 |
796 | 2021-10-06 21:36:59 | beers | 1 | 28756 | 15 | 0.483 | 59536.2 |
795 | 2021-09-02 10:53:53 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
794 | 2021-08-18 03:40:49 | beers | 1 | 28756 | 15 | 0.440 | 65354.5 |
793 | 2021-08-15 23:01:50 | beers | 1 | 28756 | 15 | 0.440 | 65354.5 |
792 | 2021-08-01 09:11:33 | beers | 1 | 28756 | 15 | 0.440 | 65354.5 |
791 | 2021-06-28 13:23:39 | beers | 1 | 28756 | 15 | 0.450 | 63902.2 |
790 | 2021-04-26 22:49:32 | beers | 1 | 28756 | 15 | 0.516 | 55728.7 |
789 | 2021-04-10 14:13:14 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
788 | 2021-03-03 02:02:18 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
787 | 2021-02-26 04:11:02 | beers | 1 | 28756 | 15 | 0.440 | 65354.5 |
786 | 2021-02-17 20:29:25 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
785 | 2021-02-05 09:37:04 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
784 | 2021-01-24 23:26:26 | beers | 1 | 28756 | 15 | 0.440 | 65354.5 |
783 | 2021-01-22 09:38:06 | beers | 1 | 28756 | 15 | 0.483 | 59536.2 |
782 | 2020-11-29 18:08:11 | beers | 1 | 28756 | 15 | 0.466 | 61708.2 |
781 | 2020-10-29 12:58:02 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
780 | 2020-10-20 03:09:54 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |
779 | 2020-09-07 11:16:52 | beers | 1 | 28756 | 15 | 0.546 | 52666.7 |
778 | 2020-08-26 12:12:25 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
777 | 2020-08-21 06:09:27 | beers | 1 | 28756 | 15 | 0.470 | 61183.0 |
776 | 2020-08-21 06:09:08 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
775 | 2020-08-17 15:14:16 | beers | 1 | 28756 | 15 | 0.486 | 59168.7 |
774 | 2020-08-14 14:29:36 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
773 | 2020-08-06 23:49:15 | beers | 1 | 28756 | 15 | 0.516 | 55728.7 |
772 | 2020-08-05 11:15:33 | beers | 1 | 28756 | 15 | 0.466 | 61708.2 |
771 | 2020-07-29 00:04:13 | beers | 1 | 28756 | 15 | 0.470 | 61183.0 |
770 | 2020-07-20 13:13:14 | beers | 1 | 28756 | 15 | 0.546 | 52666.7 |
769 | 2020-07-18 15:22:02 | beers | 1 | 28756 | 15 | 0.516 | 55728.7 |
768 | 2020-07-18 09:16:58 | beers | 1 | 28756 | 15 | 0.470 | 61183.0 |
767 | 2020-07-17 18:25:45 | beers | 1 | 28756 | 15 | 0.466 | 61708.2 |
766 | 2020-07-16 08:47:06 | beers | 1 | 28756 | 15 | 0.470 | 61183.0 |
765 | 2020-06-17 05:41:36 | beers | 1 | 28756 | 15 | 0.500 | 57512.0 |
764 | 2020-06-15 10:35:34 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
763 | 2020-06-14 07:06:56 | beers | 1 | 28756 | 15 | 0.593 | 48492.4 |
762 | 2020-06-13 09:27:14 | beers | 1 | 28756 | 15 | 0.470 | 61183.0 |
761 | 2020-06-10 03:59:54 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
760 | 2020-06-09 04:36:24 | beers | 1 | 28756 | 15 | 0.483 | 59536.2 |
759 | 2020-06-08 04:39:47 | beers | 1 | 28756 | 15 | 0.486 | 59168.7 |
758 | 2020-06-02 02:32:36 | beers | 1 | 28756 | 15 | 0.420 | 68466.7 |
757 | 2020-06-01 12:34:26 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
756 | 2020-06-01 03:10:21 | beers | 1 | 28756 | 15 | 0.453 | 63479.0 |
755 | 2020-05-29 07:21:59 | beers | 1 | 28756 | 15 | 0.440 | 65354.5 |
754 | 2020-05-26 08:41:12 | beers | 1 | 28756 | 15 | 0.436 | 65954.1 |