History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aspen"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
933 | 2024-03-29 02:47:18 | aspen | 1 | 28756 | 5 | 0.546 | 52666.7 |
932 | 2024-03-19 08:12:28 | aspen | 3 | 83667 | 1197 | 4.923 | 16995.1 |
931 | 2024-03-18 18:29:13 | aspen | 3 | 83667 | 1197 | 13.763 | 6079.1 |
930 | 2024-03-17 15:21:36 | aspen | 3 | 83667 | 1197 | 4.516 | 18526.8 |
929 | 2024-03-15 22:21:45 | aspen | 3 | 83667 | 1197 | 8.626 | 9699.4 |
928 | 2024-03-13 17:32:27 | aspen | 3 | 83667 | 1197 | 9.253 | 9042.1 |
927 | 2024-03-11 03:50:18 | aspen | 1 | 28756 | 5 | 1.126 | 25538.2 |
926 | 2024-03-04 03:57:01 | aspen | 3 | 83667 | 1197 | 10.813 | 7737.6 |
925 | 2024-03-04 00:19:54 | aspen | 3 | 83667 | 1197 | 16.330 | 5123.5 |
924 | 2024-03-04 00:19:54 | aspen | 2 | 53800 | 71 | 3.813 | 14109.6 |
923 | 2024-03-04 00:11:04 | aspen | 1 | 28756 | 5 | 0.530 | 54256.6 |
922 | 2024-03-01 02:26:32 | aspen | 1 | 28756 | 5 | 0.530 | 54256.6 |
921 | 2024-02-27 19:43:53 | aspen | 1 | 28756 | 5 | 0.456 | 63061.4 |
920 | 2024-02-02 22:53:07 | aspen | 1 | 28756 | 5 | 1.030 | 27918.4 |
919 | 2024-01-28 19:12:31 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
918 | 2024-01-28 17:55:45 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
917 | 2024-01-25 02:26:59 | aspen | 3 | 83667 | 1197 | 3.390 | 24680.5 |
916 | 2024-01-20 21:04:15 | aspen | 1 | 28756 | 5 | 0.516 | 55728.7 |
915 | 2024-01-08 21:30:28 | aspen | 3 | 83667 | 1197 | 3.986 | 20990.2 |
914 | 2023-12-15 14:29:49 | aspen | 3 | 83667 | 1197 | 3.953 | 21165.4 |
913 | 2023-12-15 14:29:50 | aspen | 2 | 53800 | 71 | 1.656 | 32487.9 |
912 | 2023-12-14 22:16:02 | aspen | 2 | 53800 | 71 | 1.656 | 32487.9 |
911 | 2023-12-13 23:48:30 | aspen | 1 | 28756 | 5 | 0.530 | 54256.6 |
910 | 2023-12-13 19:35:51 | aspen | 1 | 28756 | 5 | 0.436 | 65954.1 |
909 | 2023-12-01 11:48:06 | aspen | 2 | 53800 | 71 | 1.393 | 38621.7 |
908 | 2023-11-19 11:33:16 | aspen | 1 | 28756 | 5 | 0.546 | 52666.7 |
907 | 2023-11-14 18:50:23 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
906 | 2023-11-11 21:59:45 | aspen | 1 | 28756 | 5 | 0.516 | 55728.7 |
905 | 2023-11-05 03:04:56 | aspen | 3 | 83667 | 1197 | 6.560 | 12754.1 |
904 | 2023-11-03 16:19:24 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
903 | 2023-10-23 18:14:20 | aspen | 3 | 83667 | 1197 | 3.436 | 24350.1 |
902 | 2023-10-22 14:29:57 | aspen | 1 | 28756 | 5 | 0.516 | 55728.7 |
901 | 2023-10-22 04:58:23 | aspen | 1 | 28756 | 5 | 0.516 | 55728.7 |
900 | 2023-10-21 08:26:01 | aspen | 3 | 83667 | 1197 | 5.970 | 14014.6 |
899 | 2023-10-19 04:25:20 | aspen | 1 | 28756 | 5 | 0.436 | 65954.1 |
898 | 2023-10-17 20:11:31 | aspen | 3 | 83667 | 1197 | 3.470 | 24111.5 |
897 | 2023-10-13 17:00:04 | aspen | 1 | 28756 | 5 | 0.546 | 52666.7 |
896 | 2023-10-13 08:05:37 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
895 | 2023-10-09 19:53:43 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
894 | 2023-10-03 17:55:08 | aspen | 1 | 28756 | 5 | 0.486 | 59168.7 |
893 | 2023-09-29 14:06:19 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
892 | 2023-09-26 14:47:46 | aspen | 1 | 28756 | 5 | 0.530 | 54256.6 |
891 | 2023-09-25 15:22:24 | aspen | 1 | 28756 | 5 | 0.483 | 59536.2 |
890 | 2023-09-23 18:31:23 | aspen | 1 | 28756 | 5 | 0.513 | 56054.6 |
889 | 2023-09-13 12:38:52 | aspen | 2 | 53800 | 71 | 1.686 | 31909.8 |
888 | 2023-08-26 16:13:54 | aspen | 3 | 83667 | 1197 | 4.110 | 20356.9 |
887 | 2023-08-22 14:48:16 | aspen | 3 | 83667 | 1197 | 3.813 | 21942.6 |
886 | 2023-07-28 20:20:11 | aspen | 3 | 83667 | 1197 | 4.343 | 19264.8 |
885 | 2023-07-28 01:23:34 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
884 | 2023-07-03 20:56:27 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
883 | 2023-06-11 10:58:46 | aspen | 3 | 83667 | 1197 | 3.406 | 24564.6 |
882 | 2023-06-09 11:28:08 | aspen | 2 | 53800 | 71 | 1.593 | 33772.8 |
881 | 2023-05-27 11:06:58 | aspen | 3 | 83667 | 1197 | 4.110 | 20356.9 |
880 | 2023-05-05 21:09:07 | aspen | 3 | 83667 | 1197 | 3.373 | 24804.9 |
879 | 2023-04-25 13:59:40 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
878 | 2023-04-09 09:57:42 | aspen | 3 | 83667 | 1197 | 3.313 | 25254.2 |
877 | 2023-03-31 13:44:21 | aspen | 1 | 28756 | 5 | 0.486 | 59168.7 |
876 | 2023-03-23 20:43:05 | aspen | 1 | 28756 | 5 | 0.483 | 59536.2 |
875 | 2023-03-12 09:45:10 | aspen | 2 | 53800 | 71 | 1.390 | 38705.0 |
874 | 2023-02-17 19:16:44 | aspen | 1 | 28756 | 5 | 0.420 | 68466.7 |
873 | 2023-01-15 02:54:30 | aspen | 3 | 83667 | 1197 | 3.626 | 23074.2 |
872 | 2022-12-17 13:26:21 | aspen | 1 | 28756 | 5 | 0.450 | 63902.2 |
871 | 2022-12-15 10:07:48 | aspen | 2 | 53800 | 71 | 1.390 | 38705.0 |
870 | 2022-12-12 07:05:19 | aspen | 1 | 28756 | 5 | 0.516 | 55728.7 |
869 | 2022-10-27 16:08:52 | aspen | 3 | 83667 | 1197 | 3.813 | 21942.6 |
868 | 2022-09-01 07:42:29 | aspen | 1 | 28756 | 5 | 0.986 | 29164.3 |
867 | 2022-08-28 00:40:58 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
866 | 2022-08-25 15:26:50 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
865 | 2022-08-01 13:31:02 | aspen | 2 | 53800 | 71 | 1.406 | 38264.6 |
864 | 2022-07-31 03:50:41 | aspen | 3 | 83667 | 1197 | 3.780 | 22134.1 |
863 | 2022-06-24 02:51:24 | aspen | 3 | 83667 | 1197 | 3.326 | 25155.4 |
862 | 2022-05-26 10:02:30 | aspen | 3 | 83667 | 1197 | 3.330 | 25125.2 |
861 | 2022-05-23 09:00:41 | aspen | 1 | 28756 | 5 | 0.483 | 59536.2 |
860 | 2022-04-14 22:50:09 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
859 | 2022-02-15 06:58:02 | aspen | 1 | 28756 | 5 | 0.516 | 55728.7 |
858 | 2022-02-11 18:05:57 | aspen | 1 | 28756 | 5 | 1.000 | 28756.0 |
857 | 2022-01-21 08:45:47 | aspen | 3 | 83667 | 1197 | 4.500 | 18592.7 |
856 | 2022-01-17 02:54:54 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
855 | 2021-12-22 13:55:31 | aspen | 1 | 28756 | 5 | 0.530 | 54256.6 |
854 | 2021-11-26 23:52:19 | aspen | 3 | 83667 | 1197 | 5.923 | 14125.8 |
853 | 2021-11-25 18:30:10 | aspen | 3 | 83667 | 1197 | 3.953 | 21165.4 |
852 | 2021-11-22 09:33:48 | aspen | 1 | 28756 | 5 | 0.516 | 55728.7 |
851 | 2021-11-12 22:30:54 | aspen | 1 | 28756 | 5 | 0.483 | 59536.2 |
850 | 2021-11-07 07:34:12 | aspen | 1 | 28756 | 5 | 0.483 | 59536.2 |
849 | 2021-10-02 17:25:33 | aspen | 1 | 28756 | 5 | 0.546 | 52666.7 |
848 | 2021-09-15 17:00:52 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
847 | 2021-09-03 21:51:04 | aspen | 3 | 83667 | 1197 | 4.096 | 20426.5 |
846 | 2021-08-04 05:38:30 | aspen | 1 | 28756 | 5 | 0.436 | 65954.1 |
845 | 2021-06-19 19:08:58 | aspen | 3 | 83667 | 1197 | 3.720 | 22491.1 |
844 | 2021-05-23 07:49:50 | aspen | 1 | 28756 | 5 | 0.450 | 63902.2 |
843 | 2021-05-15 14:54:50 | aspen | 3 | 83667 | 1197 | 4.063 | 20592.4 |
842 | 2021-05-03 12:38:39 | aspen | 1 | 28756 | 5 | 0.513 | 56054.6 |
841 | 2021-04-29 21:03:04 | aspen | 1 | 28756 | 5 | 0.450 | 63902.2 |
840 | 2021-04-24 13:50:45 | aspen | 1 | 28756 | 5 | 0.516 | 55728.7 |
839 | 2021-04-19 23:39:20 | aspen | 3 | 83667 | 1197 | 8.220 | 10178.5 |
838 | 2021-04-18 19:24:14 | aspen | 3 | 83667 | 1197 | 4.156 | 20131.6 |
837 | 2021-04-17 19:04:31 | aspen | 3 | 83667 | 1197 | 8.173 | 10237.0 |
836 | 2021-04-13 16:12:08 | aspen | 3 | 83667 | 1197 | 3.800 | 22017.6 |
835 | 2021-04-12 18:25:06 | aspen | 3 | 83667 | 1197 | 3.953 | 21165.4 |
834 | 2021-03-31 00:56:50 | aspen | 3 | 83667 | 1197 | 4.156 | 20131.6 |