History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pupae"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
959 | 2024-04-23 05:04:48 | pupae | 2 | 53800 | 55 | 1.406 | 38264.6 |
958 | 2024-04-08 06:15:59 | pupae | 1 | 28756 | 5 | 0.513 | 56054.6 |
957 | 2024-04-03 05:02:03 | pupae | 1 | 28756 | 5 | 0.640 | 44931.3 |
956 | 2024-03-31 06:46:15 | pupae | 1 | 28756 | 5 | 1.703 | 16885.5 |
955 | 2024-03-29 03:43:42 | pupae | 1 | 28756 | 5 | 1.080 | 26625.9 |
954 | 2024-03-28 16:00:16 | pupae | 2 | 53800 | 55 | 1.436 | 37465.2 |
953 | 2024-03-28 16:00:15 | pupae | 1 | 28756 | 5 | 0.453 | 63479.0 |
952 | 2024-03-28 15:59:44 | pupae | 3 | 83667 | 936 | 3.956 | 21149.4 |
951 | 2024-03-28 15:27:00 | pupae | 3 | 83667 | 936 | 3.440 | 24321.8 |
950 | 2024-03-08 21:09:58 | pupae | 1 | 28756 | 5 | 1.140 | 25224.6 |
949 | 2024-03-01 03:26:08 | pupae | 1 | 28756 | 5 | 0.483 | 59536.2 |
948 | 2024-02-28 02:12:00 | pupae | 3 | 83667 | 936 | 3.923 | 21327.3 |
947 | 2024-02-28 02:11:49 | pupae | 1 | 28756 | 5 | 0.513 | 56054.6 |
946 | 2024-02-12 01:10:05 | pupae | 2 | 53800 | 55 | 4.393 | 12246.8 |
945 | 2024-02-09 21:05:04 | pupae | 2 | 53800 | 55 | 1.720 | 31279.1 |
944 | 2024-02-09 20:56:29 | pupae | 3 | 83667 | 936 | 4.080 | 20506.6 |
943 | 2024-02-07 17:52:37 | pupae | 3 | 83667 | 936 | 5.906 | 14166.4 |
942 | 2024-02-07 14:44:22 | pupae | 2 | 53800 | 55 | 1.606 | 33499.4 |
941 | 2024-02-07 14:43:38 | pupae | 3 | 83667 | 936 | 3.643 | 22966.5 |
940 | 2024-02-05 04:15:26 | pupae | 2 | 53800 | 55 | 3.533 | 15227.9 |
939 | 2024-02-05 04:14:42 | pupae | 3 | 83667 | 936 | 3.610 | 23176.5 |
938 | 2024-02-04 23:23:33 | pupae | 3 | 83667 | 936 | 4.016 | 20833.4 |
937 | 2024-01-28 21:37:01 | pupae | 1 | 28756 | 5 | 0.516 | 55728.7 |
936 | 2023-12-29 02:18:19 | pupae | 1 | 28756 | 5 | 0.550 | 52283.6 |
935 | 2023-12-22 03:18:39 | pupae | 2 | 53800 | 55 | 1.563 | 34421.0 |
934 | 2023-12-21 05:34:25 | pupae | 2 | 53800 | 55 | 1.393 | 38621.7 |
933 | 2023-12-16 03:55:07 | pupae | 3 | 83667 | 936 | 3.360 | 24900.9 |
932 | 2023-12-14 13:56:53 | pupae | 3 | 83667 | 936 | 5.456 | 15334.9 |
931 | 2023-12-14 04:11:48 | pupae | 3 | 83667 | 936 | 4.436 | 18860.9 |
930 | 2023-12-11 11:00:51 | pupae | 2 | 53800 | 55 | 1.373 | 39184.3 |
929 | 2023-11-20 11:21:52 | pupae | 1 | 28756 | 5 | 0.516 | 55728.7 |
928 | 2023-11-13 17:15:48 | pupae | 1 | 28756 | 5 | 0.440 | 65354.5 |
927 | 2023-11-12 07:32:29 | pupae | 1 | 28756 | 5 | 0.483 | 59536.2 |
926 | 2023-11-12 04:12:42 | pupae | 2 | 53800 | 55 | 1.330 | 40451.1 |
925 | 2023-11-11 15:14:30 | pupae | 3 | 83667 | 936 | 3.236 | 25855.1 |
924 | 2023-11-03 13:28:16 | pupae | 1 | 28756 | 5 | 0.420 | 68466.7 |
923 | 2023-10-30 05:29:13 | pupae | 3 | 83667 | 936 | 3.906 | 21420.1 |
922 | 2023-10-26 04:17:10 | pupae | 3 | 83667 | 936 | 3.750 | 22311.2 |
921 | 2023-10-25 10:10:19 | pupae | 3 | 83667 | 936 | 3.830 | 21845.2 |
920 | 2023-10-21 18:18:58 | pupae | 3 | 83667 | 936 | 4.250 | 19686.4 |
919 | 2023-10-21 09:58:41 | pupae | 1 | 28756 | 5 | 0.453 | 63479.0 |
918 | 2023-10-21 00:48:55 | pupae | 3 | 83667 | 936 | 5.750 | 14550.8 |
917 | 2023-10-18 21:51:29 | pupae | 1 | 28756 | 5 | 0.440 | 65354.5 |
916 | 2023-10-17 18:20:03 | pupae | 3 | 83667 | 936 | 3.940 | 21235.3 |
915 | 2023-10-16 17:40:03 | pupae | 1 | 28756 | 5 | 0.500 | 57512.0 |
914 | 2023-10-16 03:12:12 | pupae | 1 | 28756 | 5 | 0.483 | 59536.2 |
913 | 2023-10-14 06:50:52 | pupae | 1 | 28756 | 5 | 0.456 | 63061.4 |
912 | 2023-10-05 01:00:26 | pupae | 1 | 28756 | 5 | 0.486 | 59168.7 |
911 | 2023-09-29 16:01:28 | pupae | 1 | 28756 | 5 | 0.436 | 65954.1 |
910 | 2023-09-23 16:02:54 | pupae | 1 | 28756 | 5 | 0.876 | 32826.5 |
909 | 2023-09-09 15:50:56 | pupae | 2 | 53800 | 55 | 1.330 | 40451.1 |
908 | 2023-08-14 09:59:03 | pupae | 3 | 83667 | 936 | 3.966 | 21096.1 |
907 | 2023-08-11 22:22:58 | pupae | 1 | 28756 | 5 | 0.483 | 59536.2 |
906 | 2023-06-18 19:44:41 | pupae | 1 | 28756 | 5 | 0.420 | 68466.7 |
905 | 2023-05-29 19:04:33 | pupae | 2 | 53800 | 55 | 1.376 | 39098.8 |
904 | 2023-05-07 18:21:53 | pupae | 1 | 28756 | 5 | 0.436 | 65954.1 |
903 | 2023-04-27 20:05:28 | pupae | 3 | 83667 | 936 | 3.250 | 25743.7 |
902 | 2023-03-07 21:11:08 | pupae | 2 | 53800 | 55 | 1.326 | 40573.2 |
901 | 2023-03-01 01:32:14 | pupae | 1 | 28756 | 5 | 0.436 | 65954.1 |
900 | 2023-02-24 07:07:33 | pupae | 1 | 28756 | 5 | 0.436 | 65954.1 |
899 | 2023-02-20 22:51:07 | pupae | 1 | 28756 | 5 | 0.423 | 67981.1 |
898 | 2023-02-17 12:06:13 | pupae | 1 | 28756 | 5 | 0.436 | 65954.1 |
897 | 2023-02-12 09:48:56 | pupae | 3 | 83667 | 936 | 4.080 | 20506.6 |
896 | 2023-02-08 21:56:58 | pupae | 3 | 83667 | 936 | 3.190 | 26227.9 |
895 | 2023-02-02 12:15:47 | pupae | 3 | 83667 | 936 | 3.563 | 23482.2 |
894 | 2022-12-26 23:17:12 | pupae | 1 | 28756 | 5 | 0.423 | 67981.1 |
893 | 2022-12-14 04:05:26 | pupae | 2 | 53800 | 55 | 1.546 | 34799.5 |
892 | 2022-11-14 19:25:27 | pupae | 3 | 83667 | 936 | 3.220 | 25983.5 |
891 | 2022-10-13 05:00:50 | pupae | 1 | 28756 | 5 | 0.500 | 57512.0 |
890 | 2022-09-13 14:38:59 | pupae | 1 | 28756 | 5 | 0.440 | 65354.5 |
889 | 2022-08-07 19:30:03 | pupae | 1 | 28756 | 5 | 0.436 | 65954.1 |
888 | 2022-08-03 06:03:38 | pupae | 2 | 53800 | 55 | 1.360 | 39558.8 |
887 | 2022-06-21 01:52:44 | pupae | 3 | 83667 | 936 | 3.610 | 23176.5 |
886 | 2022-06-16 13:01:53 | pupae | 3 | 83667 | 936 | 4.233 | 19765.4 |
885 | 2022-06-04 11:46:13 | pupae | 1 | 28756 | 5 | 0.436 | 65954.1 |
884 | 2022-04-17 22:03:01 | pupae | 1 | 28756 | 5 | 0.420 | 68466.7 |
883 | 2022-03-13 10:47:37 | pupae | 2 | 53800 | 55 | 1.360 | 39558.8 |
882 | 2022-01-31 08:15:59 | pupae | 1 | 28756 | 5 | 0.530 | 54256.6 |
881 | 2022-01-22 06:17:30 | pupae | 1 | 28756 | 5 | 0.450 | 63902.2 |
880 | 2022-01-20 02:46:26 | pupae | 1 | 28756 | 5 | 0.610 | 47141.0 |
879 | 2021-11-21 14:01:52 | pupae | 3 | 83667 | 936 | 3.266 | 25617.6 |
878 | 2021-11-15 19:04:39 | pupae | 1 | 28756 | 5 | 0.436 | 65954.1 |
877 | 2021-10-14 11:16:57 | pupae | 1 | 28756 | 5 | 0.500 | 57512.0 |
876 | 2021-10-11 04:47:41 | pupae | 1 | 28756 | 5 | 0.420 | 68466.7 |
875 | 2021-10-10 11:49:19 | pupae | 3 | 83667 | 936 | 3.923 | 21327.3 |
874 | 2021-10-03 12:13:39 | pupae | 1 | 28756 | 5 | 0.440 | 65354.5 |
873 | 2021-09-21 14:29:19 | pupae | 3 | 83667 | 936 | 7.030 | 11901.4 |
872 | 2021-09-21 06:16:12 | pupae | 1 | 28756 | 5 | 0.516 | 55728.7 |
871 | 2021-09-16 11:17:59 | pupae | 1 | 28756 | 5 | 0.500 | 57512.0 |
870 | 2021-09-13 20:34:04 | pupae | 1 | 28756 | 5 | 0.440 | 65354.5 |
869 | 2021-07-09 14:54:51 | pupae | 1 | 28756 | 5 | 0.486 | 59168.7 |
868 | 2021-05-21 09:15:56 | pupae | 3 | 83667 | 936 | 3.750 | 22311.2 |
867 | 2021-04-05 18:18:54 | pupae | 1 | 28756 | 5 | 0.466 | 61708.2 |
866 | 2021-04-01 14:08:33 | pupae | 1 | 28756 | 5 | 0.470 | 61183.0 |
865 | 2021-02-20 10:04:03 | pupae | 1 | 28756 | 5 | 0.436 | 65954.1 |
864 | 2021-02-01 19:56:26 | pupae | 3 | 83667 | 936 | 3.640 | 22985.4 |
863 | 2021-01-14 15:15:33 | pupae | 1 | 28756 | 5 | 0.453 | 63479.0 |
862 | 2021-01-04 04:13:48 | pupae | 3 | 83667 | 936 | 3.360 | 24900.9 |
861 | 2020-12-24 08:09:33 | pupae | 1 | 28756 | 5 | 0.483 | 59536.2 |
860 | 2020-12-07 05:25:50 | pupae | 3 | 83667 | 936 | 3.766 | 22216.4 |