History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hikes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
861 | 2024-05-02 12:19:07 | hikes | 1 | 28756 | 20 | 1.640 | 17534.1 |
860 | 2024-05-01 20:56:44 | hikes | 1 | 28756 | 20 | 0.576 | 49923.6 |
859 | 2024-04-30 16:01:47 | hikes | 1 | 28756 | 20 | 0.516 | 55728.7 |
858 | 2024-04-29 09:18:59 | hikes | 1 | 28756 | 20 | 1.156 | 24875.4 |
857 | 2024-04-27 20:43:35 | hikes | 2 | 53800 | 267 | 3.750 | 14346.7 |
856 | 2024-04-27 10:41:49 | hikes | 1 | 28756 | 20 | 0.563 | 51076.4 |
855 | 2024-04-24 08:54:40 | hikes | 1 | 28756 | 20 | 0.580 | 49579.3 |
854 | 2024-04-09 22:59:40 | hikes | 1 | 28756 | 20 | 0.750 | 38341.3 |
853 | 2024-04-02 20:29:53 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
852 | 2024-03-31 12:51:36 | hikes | 2 | 53800 | 267 | 5.750 | 9356.5 |
851 | 2024-03-31 12:41:45 | hikes | 1 | 28756 | 20 | 0.546 | 52666.7 |
850 | 2024-03-28 18:58:21 | hikes | 2 | 53800 | 267 | 1.873 | 28724.0 |
849 | 2024-03-28 18:10:58 | hikes | 1 | 28756 | 20 | 1.046 | 27491.4 |
848 | 2024-03-07 16:50:08 | hikes | 1 | 28756 | 20 | 0.486 | 59168.7 |
847 | 2024-03-03 18:55:57 | hikes | 1 | 28756 | 20 | 1.703 | 16885.5 |
846 | 2024-03-01 06:39:36 | hikes | 1 | 28756 | 20 | 0.533 | 53951.2 |
845 | 2024-02-26 07:44:08 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
844 | 2024-01-28 17:19:11 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
843 | 2024-01-27 05:25:01 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
842 | 2024-01-26 16:45:27 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
841 | 2024-01-25 21:03:32 | hikes | 1 | 28756 | 20 | 0.530 | 54256.6 |
840 | 2024-01-08 21:30:25 | hikes | 2 | 53800 | 267 | 1.453 | 37026.8 |
839 | 2023-12-26 09:36:06 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
838 | 2023-12-17 05:46:39 | hikes | 2 | 53800 | 267 | 1.593 | 33772.8 |
837 | 2023-12-13 19:16:02 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
836 | 2023-12-12 03:16:12 | hikes | 2 | 53800 | 267 | 1.720 | 31279.1 |
835 | 2023-12-07 11:10:54 | hikes | 2 | 53800 | 267 | 1.533 | 35094.6 |
834 | 2023-12-07 11:10:52 | hikes | 2 | 53800 | 267 | 1.546 | 34799.5 |
833 | 2023-11-24 14:51:31 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
832 | 2023-11-15 15:57:58 | hikes | 2 | 53800 | 267 | 1.436 | 37465.2 |
831 | 2023-11-11 23:35:42 | hikes | 2 | 53800 | 267 | 1.466 | 36698.5 |
830 | 2023-11-11 11:58:16 | hikes | 1 | 28756 | 20 | 0.466 | 61708.2 |
829 | 2023-11-08 02:23:12 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
828 | 2023-10-29 05:43:56 | hikes | 1 | 28756 | 20 | 0.420 | 68466.7 |
827 | 2023-10-21 10:30:05 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
826 | 2023-10-18 15:51:35 | hikes | 1 | 28756 | 20 | 0.486 | 59168.7 |
825 | 2023-10-17 05:03:48 | hikes | 2 | 53800 | 267 | 1.360 | 39558.8 |
824 | 2023-10-14 02:23:40 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
823 | 2023-10-11 01:15:16 | hikes | 1 | 28756 | 20 | 0.466 | 61708.2 |
822 | 2023-10-05 05:00:47 | hikes | 1 | 28756 | 20 | 0.423 | 67981.1 |
821 | 2023-09-29 17:32:17 | hikes | 1 | 28756 | 20 | 0.516 | 55728.7 |
820 | 2023-09-26 05:32:58 | hikes | 1 | 28756 | 20 | 0.420 | 68466.7 |
819 | 2023-09-24 11:19:53 | hikes | 1 | 28756 | 20 | 0.420 | 68466.7 |
818 | 2023-08-16 12:07:25 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
817 | 2023-07-28 06:32:51 | hikes | 2 | 53800 | 267 | 2.733 | 19685.3 |
816 | 2023-07-27 15:09:04 | hikes | 1 | 28756 | 20 | 0.486 | 59168.7 |
815 | 2023-07-01 08:17:20 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
814 | 2023-04-29 13:23:13 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
813 | 2023-04-06 13:03:42 | hikes | 2 | 53800 | 267 | 1.486 | 36204.6 |
812 | 2023-03-28 14:11:05 | hikes | 1 | 28756 | 20 | 0.486 | 59168.7 |
811 | 2023-02-18 20:34:47 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
810 | 2023-01-04 10:20:59 | hikes | 2 | 53800 | 267 | 1.326 | 40573.2 |
809 | 2022-12-23 10:04:45 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
808 | 2022-12-19 19:17:13 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
807 | 2022-12-17 07:35:50 | hikes | 1 | 28756 | 20 | 0.466 | 61708.2 |
806 | 2022-09-20 04:06:35 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
805 | 2022-09-11 14:55:06 | hikes | 2 | 53800 | 267 | 1.343 | 40059.6 |
804 | 2022-09-09 12:47:53 | hikes | 2 | 53800 | 267 | 1.326 | 40573.2 |
803 | 2022-09-09 04:28:19 | hikes | 1 | 28756 | 20 | 0.423 | 67981.1 |
802 | 2022-08-29 00:54:25 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
801 | 2022-08-14 22:31:45 | hikes | 1 | 28756 | 20 | 0.420 | 68466.7 |
800 | 2022-07-29 06:42:46 | hikes | 1 | 28756 | 20 | 0.420 | 68466.7 |
799 | 2022-07-11 05:36:18 | hikes | 2 | 53800 | 267 | 1.343 | 40059.6 |
798 | 2022-05-27 18:33:23 | hikes | 1 | 28756 | 20 | 0.440 | 65354.5 |
797 | 2022-05-06 23:45:26 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
796 | 2022-05-06 10:51:07 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
795 | 2022-05-05 17:35:29 | hikes | 1 | 28756 | 20 | 0.516 | 55728.7 |
794 | 2022-05-05 10:31:21 | hikes | 1 | 28756 | 20 | 0.533 | 53951.2 |
793 | 2022-05-04 22:44:01 | hikes | 1 | 28756 | 20 | 0.513 | 56054.6 |
792 | 2022-05-04 10:56:22 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
791 | 2022-05-04 01:05:47 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
790 | 2022-05-03 10:05:28 | hikes | 1 | 28756 | 20 | 0.610 | 47141.0 |
789 | 2022-04-08 10:16:53 | hikes | 2 | 53800 | 267 | 1.813 | 29674.6 |
788 | 2022-04-08 02:43:12 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
787 | 2022-04-07 14:12:50 | hikes | 1 | 28756 | 20 | 0.656 | 43835.4 |
786 | 2022-04-06 05:15:32 | hikes | 1 | 28756 | 20 | 0.500 | 57512.0 |
785 | 2022-04-05 18:09:39 | hikes | 1 | 28756 | 20 | 0.440 | 65354.5 |
784 | 2022-04-05 17:59:04 | hikes | 1 | 28756 | 20 | 0.656 | 43835.4 |
783 | 2022-04-04 22:31:47 | hikes | 1 | 28756 | 20 | 0.470 | 61183.0 |
782 | 2022-04-04 10:03:36 | hikes | 1 | 28756 | 20 | 0.530 | 54256.6 |
781 | 2022-04-03 14:24:25 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
780 | 2022-04-03 11:53:10 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
779 | 2022-04-02 15:59:16 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
778 | 2022-04-01 16:11:51 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
777 | 2022-04-01 00:38:54 | hikes | 1 | 28756 | 20 | 0.796 | 36125.6 |
776 | 2022-03-31 06:40:09 | hikes | 1 | 28756 | 20 | 0.453 | 63479.0 |
775 | 2022-03-30 20:08:37 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
774 | 2022-03-30 06:05:26 | hikes | 1 | 28756 | 20 | 0.453 | 63479.0 |
773 | 2022-03-29 21:02:14 | hikes | 1 | 28756 | 20 | 0.533 | 53951.2 |
772 | 2022-03-29 09:14:06 | hikes | 1 | 28756 | 20 | 0.720 | 39938.9 |
771 | 2022-03-28 22:49:52 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
770 | 2022-03-27 19:59:25 | hikes | 1 | 28756 | 20 | 0.483 | 59536.2 |
769 | 2022-03-27 07:23:21 | hikes | 1 | 28756 | 20 | 0.450 | 63902.2 |
768 | 2022-03-26 08:23:06 | hikes | 1 | 28756 | 20 | 0.436 | 65954.1 |
767 | 2022-03-25 14:21:51 | hikes | 1 | 28756 | 20 | 0.623 | 46157.3 |
766 | 2022-03-25 00:36:11 | hikes | 1 | 28756 | 20 | 0.623 | 46157.3 |
765 | 2022-03-24 09:55:18 | hikes | 1 | 28756 | 20 | 0.513 | 56054.6 |
764 | 2022-03-23 11:06:11 | hikes | 1 | 28756 | 20 | 0.690 | 41675.4 |
763 | 2022-03-22 22:29:38 | hikes | 1 | 28756 | 20 | 0.653 | 44036.8 |
762 | 2022-03-21 03:16:23 | hikes | 1 | 28756 | 20 | 0.513 | 56054.6 |