History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shoot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
880 | 2024-05-03 20:47:53 | shoot | 1 | 28756 | 17 | 1.143 | 25158.4 |
879 | 2024-04-30 08:23:58 | shoot | 1 | 28756 | 17 | 1.123 | 25606.4 |
878 | 2024-04-27 00:11:17 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
877 | 2024-04-04 06:39:26 | shoot | 1 | 28756 | 17 | 0.563 | 51076.4 |
876 | 2024-04-03 04:45:21 | shoot | 2 | 53800 | 147 | 5.763 | 9335.4 |
875 | 2024-04-03 04:38:28 | shoot | 1 | 28756 | 17 | 0.546 | 52666.7 |
874 | 2024-03-31 05:53:42 | shoot | 2 | 53800 | 147 | 4.000 | 13450.0 |
873 | 2024-03-31 03:46:54 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
872 | 2024-03-29 02:10:15 | shoot | 1 | 28756 | 17 | 0.533 | 53951.2 |
871 | 2024-03-28 00:21:36 | shoot | 1 | 28756 | 17 | 0.576 | 49923.6 |
870 | 2024-03-04 00:31:17 | shoot | 1 | 28756 | 17 | 0.513 | 56054.6 |
869 | 2024-02-27 20:28:28 | shoot | 1 | 28756 | 17 | 0.533 | 53951.2 |
868 | 2024-02-04 21:32:23 | shoot | 1 | 28756 | 17 | 0.936 | 30722.2 |
867 | 2024-02-03 00:25:55 | shoot | 1 | 28756 | 17 | 0.530 | 54256.6 |
866 | 2024-02-01 02:19:10 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
865 | 2024-01-28 22:45:09 | shoot | 1 | 28756 | 17 | 0.516 | 55728.7 |
864 | 2024-01-22 00:58:11 | shoot | 2 | 53800 | 147 | 1.376 | 39098.8 |
863 | 2024-01-18 05:50:30 | shoot | 2 | 53800 | 147 | 1.436 | 37465.2 |
862 | 2023-12-31 22:26:55 | shoot | 2 | 53800 | 147 | 1.546 | 34799.5 |
861 | 2023-12-25 21:08:51 | shoot | 1 | 28756 | 17 | 0.560 | 51350.0 |
860 | 2023-12-04 21:51:36 | shoot | 2 | 53800 | 147 | 1.563 | 34421.0 |
859 | 2023-11-17 15:56:18 | shoot | 1 | 28756 | 17 | 0.580 | 49579.3 |
858 | 2023-11-10 16:44:09 | shoot | 1 | 28756 | 17 | 0.486 | 59168.7 |
857 | 2023-10-30 20:34:22 | shoot | 1 | 28756 | 17 | 0.546 | 52666.7 |
856 | 2023-10-28 04:25:14 | shoot | 1 | 28756 | 17 | 1.140 | 25224.6 |
855 | 2023-10-19 08:45:43 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
854 | 2023-10-14 03:12:54 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
853 | 2023-10-11 11:47:12 | shoot | 1 | 28756 | 17 | 0.470 | 61183.0 |
852 | 2023-10-06 12:17:09 | shoot | 1 | 28756 | 17 | 0.440 | 65354.5 |
851 | 2023-10-06 02:33:38 | shoot | 1 | 28756 | 17 | 0.436 | 65954.1 |
850 | 2023-09-30 00:55:30 | shoot | 1 | 28756 | 17 | 0.906 | 31739.5 |
849 | 2023-09-26 06:54:23 | shoot | 1 | 28756 | 17 | 0.450 | 63902.2 |
848 | 2023-09-25 16:23:37 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
847 | 2023-09-14 01:56:13 | shoot | 1 | 28756 | 17 | 0.436 | 65954.1 |
846 | 2023-08-13 14:26:22 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
845 | 2023-08-09 21:12:20 | shoot | 1 | 28756 | 17 | 0.436 | 65954.1 |
844 | 2023-06-19 13:07:12 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
843 | 2023-05-10 08:58:13 | shoot | 1 | 28756 | 17 | 0.436 | 65954.1 |
842 | 2023-03-06 22:12:15 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
841 | 2023-02-25 01:21:23 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
840 | 2023-01-25 02:34:15 | shoot | 2 | 53800 | 147 | 1.670 | 32215.6 |
839 | 2022-12-28 22:04:35 | shoot | 1 | 28756 | 17 | 0.436 | 65954.1 |
838 | 2022-12-12 15:24:17 | shoot | 2 | 53800 | 147 | 1.640 | 32804.9 |
837 | 2022-11-14 12:02:23 | shoot | 1 | 28756 | 17 | 0.516 | 55728.7 |
836 | 2022-11-13 15:15:25 | shoot | 1 | 28756 | 17 | 0.436 | 65954.1 |
835 | 2022-11-01 04:47:49 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
834 | 2022-09-18 00:43:43 | shoot | 1 | 28756 | 17 | 0.440 | 65354.5 |
833 | 2022-07-29 05:21:59 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
832 | 2022-07-15 00:19:03 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
831 | 2022-07-05 05:59:55 | shoot | 1 | 28756 | 17 | 0.470 | 61183.0 |
830 | 2022-04-28 08:24:25 | shoot | 1 | 28756 | 17 | 0.466 | 61708.2 |
829 | 2022-03-07 17:49:03 | shoot | 1 | 28756 | 17 | 0.516 | 55728.7 |
828 | 2022-03-01 16:50:53 | shoot | 1 | 28756 | 17 | 0.640 | 44931.3 |
827 | 2022-03-01 00:12:44 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
826 | 2022-02-28 10:56:01 | shoot | 1 | 28756 | 17 | 0.750 | 38341.3 |
825 | 2022-02-27 16:20:16 | shoot | 1 | 28756 | 17 | 0.436 | 65954.1 |
824 | 2022-02-27 03:01:30 | shoot | 1 | 28756 | 17 | 0.486 | 59168.7 |
823 | 2022-02-26 10:39:35 | shoot | 1 | 28756 | 17 | 0.530 | 54256.6 |
822 | 2022-02-25 19:39:52 | shoot | 1 | 28756 | 17 | 0.516 | 55728.7 |
821 | 2022-02-25 10:58:10 | shoot | 1 | 28756 | 17 | 0.763 | 37688.1 |
820 | 2022-02-25 06:16:36 | shoot | 1 | 28756 | 17 | 0.516 | 55728.7 |
819 | 2022-02-24 13:35:00 | shoot | 1 | 28756 | 17 | 0.546 | 52666.7 |
818 | 2022-02-24 12:32:58 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
817 | 2022-02-24 00:19:13 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
816 | 2022-02-24 00:17:33 | shoot | 1 | 28756 | 17 | 0.686 | 41918.4 |
815 | 2022-02-23 16:44:20 | shoot | 1 | 28756 | 17 | 0.513 | 56054.6 |
814 | 2022-02-23 09:30:43 | shoot | 1 | 28756 | 17 | 0.530 | 54256.6 |
813 | 2022-02-23 06:59:39 | shoot | 1 | 28756 | 17 | 0.440 | 65354.5 |
812 | 2022-02-22 20:33:31 | shoot | 1 | 28756 | 17 | 0.513 | 56054.6 |
811 | 2022-02-22 18:02:35 | shoot | 1 | 28756 | 17 | 0.513 | 56054.6 |
810 | 2022-02-22 08:05:29 | shoot | 1 | 28756 | 17 | 0.470 | 61183.0 |
809 | 2022-02-22 04:42:49 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
808 | 2022-02-21 14:12:47 | shoot | 1 | 28756 | 17 | 0.513 | 56054.6 |
807 | 2022-02-21 08:52:07 | shoot | 1 | 28756 | 17 | 0.686 | 41918.4 |
806 | 2022-02-20 20:35:37 | shoot | 1 | 28756 | 17 | 0.530 | 54256.6 |
805 | 2022-02-20 19:44:02 | shoot | 1 | 28756 | 17 | 0.513 | 56054.6 |
804 | 2022-02-20 07:45:13 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
803 | 2022-02-20 07:14:54 | shoot | 1 | 28756 | 17 | 0.530 | 54256.6 |
802 | 2022-02-19 22:35:32 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
801 | 2022-02-19 18:52:21 | shoot | 1 | 28756 | 17 | 0.436 | 65954.1 |
800 | 2022-02-19 07:47:19 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
799 | 2022-02-19 07:11:44 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
798 | 2022-02-18 21:24:18 | shoot | 1 | 28756 | 17 | 0.530 | 54256.6 |
797 | 2022-02-18 19:51:21 | shoot | 1 | 28756 | 17 | 0.530 | 54256.6 |
796 | 2022-02-18 12:20:58 | shoot | 1 | 28756 | 17 | 0.546 | 52666.7 |
795 | 2022-02-18 05:57:29 | shoot | 1 | 28756 | 17 | 0.513 | 56054.6 |
794 | 2022-02-18 00:13:48 | shoot | 1 | 28756 | 17 | 0.560 | 51350.0 |
793 | 2022-02-17 19:37:21 | shoot | 1 | 28756 | 17 | 0.486 | 59168.7 |
792 | 2022-02-17 17:56:35 | shoot | 1 | 28756 | 17 | 0.530 | 54256.6 |
791 | 2022-02-17 09:26:25 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
790 | 2022-02-17 08:57:09 | shoot | 1 | 28756 | 17 | 0.436 | 65954.1 |
789 | 2022-02-16 17:51:04 | shoot | 1 | 28756 | 17 | 0.513 | 56054.6 |
788 | 2022-02-16 15:07:10 | shoot | 1 | 28756 | 17 | 0.546 | 52666.7 |
787 | 2022-02-16 07:33:31 | shoot | 1 | 28756 | 17 | 0.500 | 57512.0 |
786 | 2022-02-16 00:08:00 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
785 | 2022-02-15 10:41:22 | shoot | 1 | 28756 | 17 | 0.440 | 65354.5 |
784 | 2022-02-15 08:36:42 | shoot | 1 | 28756 | 17 | 0.453 | 63479.0 |
783 | 2022-02-14 18:32:27 | shoot | 1 | 28756 | 17 | 0.546 | 52666.7 |
782 | 2022-02-14 18:21:30 | shoot | 1 | 28756 | 17 | 0.533 | 53951.2 |
781 | 2022-02-14 06:25:07 | shoot | 1 | 28756 | 17 | 0.483 | 59536.2 |