History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"values"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
984 | 2024-03-23 17:33:31 | values | 2 | 82551 | 86 | 2.266 | 36430.3 |
983 | 2024-03-18 21:33:42 | values | 2 | 82551 | 86 | 6.640 | 12432.4 |
982 | 2024-03-18 20:38:08 | values | 3 | 112716 | 1263 | 6.436 | 17513.4 |
981 | 2024-03-14 13:29:56 | values | 3 | 112716 | 1263 | 4.906 | 22975.1 |
980 | 2024-03-11 23:18:20 | values | 2 | 82551 | 86 | 5.830 | 14159.7 |
979 | 2024-03-08 21:52:12 | values | 2 | 82551 | 86 | 4.890 | 16881.6 |
978 | 2024-03-08 18:58:24 | values | 3 | 112716 | 1263 | 12.706 | 8871.1 |
977 | 2024-03-08 04:07:47 | values | 3 | 112716 | 1263 | 13.360 | 8436.8 |
976 | 2024-03-07 20:04:37 | values | 2 | 82551 | 86 | 5.313 | 15537.5 |
975 | 2024-03-07 20:03:29 | values | 3 | 112716 | 1263 | 6.580 | 17130.1 |
974 | 2024-03-06 23:58:46 | values | 3 | 112716 | 1263 | 13.296 | 8477.4 |
973 | 2024-03-06 21:09:44 | values | 3 | 112716 | 1263 | 10.656 | 10577.7 |
972 | 2024-03-04 03:00:37 | values | 1 | 48755 | 8 | 1.890 | 25796.3 |
971 | 2024-01-28 13:39:25 | values | 1 | 48755 | 8 | 0.736 | 66243.2 |
970 | 2024-01-17 13:01:56 | values | 3 | 112716 | 1263 | 5.470 | 20606.2 |
969 | 2024-01-17 13:01:58 | values | 2 | 82551 | 86 | 2.593 | 31836.1 |
968 | 2024-01-03 04:43:14 | values | 1 | 48755 | 8 | 1.703 | 28628.9 |
967 | 2023-11-30 01:47:01 | values | 3 | 112716 | 1263 | 5.780 | 19501.0 |
966 | 2023-11-24 01:22:43 | values | 1 | 48755 | 8 | 0.813 | 59969.2 |
965 | 2023-11-20 02:13:46 | values | 1 | 48755 | 8 | 0.703 | 69352.8 |
964 | 2023-11-18 22:53:30 | values | 1 | 48755 | 8 | 0.750 | 65006.7 |
963 | 2023-11-16 22:52:37 | values | 1 | 48755 | 8 | 0.940 | 51867.0 |
962 | 2023-11-10 11:48:22 | values | 1 | 48755 | 8 | 0.843 | 57835.1 |
961 | 2023-11-03 16:43:09 | values | 1 | 48755 | 8 | 0.856 | 56956.8 |
960 | 2023-11-02 07:36:00 | values | 1 | 48755 | 8 | 1.796 | 27146.4 |
959 | 2023-10-23 10:39:37 | values | 1 | 48755 | 8 | 0.813 | 59969.2 |
958 | 2023-10-15 01:22:09 | values | 1 | 48755 | 8 | 0.830 | 58741.0 |
957 | 2023-10-11 22:15:10 | values | 1 | 48755 | 8 | 0.826 | 59025.4 |
956 | 2023-09-30 07:35:42 | values | 3 | 112716 | 1263 | 5.766 | 19548.4 |
955 | 2023-09-28 13:57:17 | values | 3 | 112716 | 1263 | 7.076 | 15929.3 |
954 | 2023-09-27 15:25:20 | values | 1 | 48755 | 8 | 0.783 | 62266.9 |
953 | 2023-09-23 10:16:26 | values | 1 | 48755 | 8 | 0.750 | 65006.7 |
952 | 2023-09-23 09:59:40 | values | 3 | 112716 | 1263 | 5.313 | 21215.1 |
951 | 2023-09-11 15:24:21 | values | 1 | 48755 | 8 | 0.733 | 66514.3 |
950 | 2023-09-04 14:57:03 | values | 3 | 112716 | 1263 | 5.656 | 19928.6 |
949 | 2023-09-02 06:08:49 | values | 3 | 112716 | 1263 | 4.643 | 24276.5 |
948 | 2023-08-29 10:37:56 | values | 3 | 112716 | 1263 | 5.016 | 22471.3 |
947 | 2023-06-15 08:13:14 | values | 1 | 48755 | 8 | 0.733 | 66514.3 |
946 | 2023-06-04 19:21:34 | values | 1 | 48755 | 8 | 0.813 | 59969.2 |
945 | 2023-05-15 07:42:06 | values | 3 | 112716 | 1263 | 4.783 | 23566.0 |
944 | 2023-03-30 12:58:27 | values | 1 | 48755 | 8 | 0.736 | 66243.2 |
943 | 2023-02-22 03:50:38 | values | 3 | 112716 | 1263 | 6.843 | 16471.7 |
942 | 2023-02-02 09:38:35 | values | 1 | 48755 | 8 | 0.733 | 66514.3 |
941 | 2023-01-15 02:39:53 | values | 1 | 48755 | 8 | 0.733 | 66514.3 |
940 | 2023-01-14 21:18:38 | values | 3 | 112716 | 1263 | 4.563 | 24702.2 |
939 | 2023-01-08 18:46:08 | values | 3 | 112716 | 1263 | 4.860 | 23192.6 |
938 | 2022-12-04 18:03:05 | values | 3 | 112716 | 1263 | 4.576 | 24632.0 |
937 | 2022-11-26 09:47:26 | values | 3 | 112716 | 1263 | 8.076 | 13956.9 |
936 | 2022-11-24 23:56:26 | values | 3 | 112716 | 1263 | 5.080 | 22188.2 |
935 | 2022-11-24 16:12:20 | values | 3 | 112716 | 1263 | 4.846 | 23259.6 |
934 | 2022-11-20 03:00:58 | values | 3 | 112716 | 1263 | 4.626 | 24365.8 |
933 | 2022-11-16 19:21:58 | values | 3 | 112716 | 1263 | 4.873 | 23130.7 |
932 | 2022-11-06 04:01:12 | values | 1 | 48755 | 8 | 0.826 | 59025.4 |
931 | 2022-10-12 03:20:52 | values | 1 | 48755 | 8 | 0.766 | 63648.8 |
930 | 2022-10-08 08:29:05 | values | 3 | 112716 | 1263 | 4.656 | 24208.8 |
929 | 2022-09-17 05:41:36 | values | 3 | 112716 | 1263 | 4.656 | 24208.8 |
928 | 2022-09-09 07:17:20 | values | 3 | 112716 | 1263 | 4.640 | 24292.2 |
927 | 2022-09-05 17:53:30 | values | 3 | 112716 | 1263 | 5.296 | 21283.2 |
926 | 2022-08-28 05:25:27 | values | 3 | 112716 | 1263 | 4.890 | 23050.3 |
925 | 2022-08-21 16:06:56 | values | 3 | 112716 | 1263 | 5.220 | 21593.1 |
924 | 2022-08-15 09:06:31 | values | 1 | 48755 | 8 | 0.843 | 57835.1 |
923 | 2022-08-14 01:51:43 | values | 1 | 48755 | 8 | 0.830 | 58741.0 |
922 | 2022-07-11 23:02:16 | values | 3 | 112716 | 1263 | 5.300 | 21267.2 |
921 | 2022-07-06 04:06:23 | values | 3 | 112716 | 1263 | 5.343 | 21096.0 |
920 | 2022-06-28 05:16:39 | values | 3 | 112716 | 1263 | 4.626 | 24365.8 |
919 | 2022-06-25 15:46:33 | values | 1 | 48755 | 8 | 0.733 | 66514.3 |
918 | 2022-06-23 11:45:19 | values | 1 | 48755 | 8 | 0.733 | 66514.3 |
917 | 2022-06-17 20:46:45 | values | 3 | 112716 | 1263 | 4.706 | 23951.6 |
916 | 2022-05-24 22:27:07 | values | 1 | 48755 | 8 | 0.826 | 59025.4 |
915 | 2022-05-18 12:33:01 | values | 3 | 112716 | 1263 | 4.906 | 22975.1 |
914 | 2022-04-29 10:19:15 | values | 3 | 112716 | 1263 | 6.123 | 18408.6 |
913 | 2022-04-25 13:32:28 | values | 3 | 112716 | 1263 | 6.000 | 18786.0 |
912 | 2022-04-15 20:12:09 | values | 3 | 112716 | 1263 | 5.186 | 21734.7 |
911 | 2022-03-31 02:52:09 | values | 3 | 112716 | 1263 | 5.390 | 20912.1 |
910 | 2022-03-30 23:46:49 | values | 3 | 112716 | 1263 | 5.673 | 19868.9 |
909 | 2022-03-22 07:53:13 | values | 3 | 112716 | 1263 | 4.860 | 23192.6 |
908 | 2022-03-01 11:25:45 | values | 3 | 112716 | 1263 | 9.643 | 11688.9 |
907 | 2022-02-26 12:32:38 | values | 1 | 48755 | 8 | 0.750 | 65006.7 |
906 | 2022-02-20 21:13:28 | values | 3 | 112716 | 1263 | 4.800 | 23482.5 |
905 | 2022-01-31 19:39:28 | values | 3 | 112716 | 1263 | 4.640 | 24292.2 |
904 | 2022-01-13 08:37:58 | values | 1 | 48755 | 8 | 0.733 | 66514.3 |
903 | 2022-01-02 23:53:17 | values | 3 | 112716 | 1263 | 4.780 | 23580.8 |
902 | 2022-01-01 21:07:34 | values | 3 | 112716 | 1263 | 5.016 | 22471.3 |
901 | 2021-12-30 08:46:58 | values | 3 | 112716 | 1263 | 4.970 | 22679.3 |
900 | 2021-12-17 14:12:47 | values | 1 | 48755 | 8 | 0.920 | 52994.6 |
899 | 2021-12-11 21:57:09 | values | 3 | 112716 | 1263 | 10.766 | 10469.6 |
898 | 2021-12-01 18:29:51 | values | 3 | 112716 | 1263 | 5.690 | 19809.5 |
897 | 2021-11-30 13:29:37 | values | 3 | 112716 | 1263 | 5.750 | 19602.8 |
896 | 2021-11-26 12:40:41 | values | 3 | 112716 | 1263 | 7.313 | 15413.1 |
895 | 2021-11-12 00:06:40 | values | 3 | 112716 | 1263 | 4.670 | 24136.2 |
894 | 2021-11-11 17:56:37 | values | 3 | 112716 | 1263 | 4.876 | 23116.5 |
893 | 2021-10-30 16:23:35 | values | 3 | 112716 | 1263 | 4.733 | 23814.9 |
892 | 2021-10-29 15:02:23 | values | 3 | 112716 | 1263 | 4.670 | 24136.2 |
891 | 2021-10-28 17:39:35 | values | 3 | 112716 | 1263 | 5.610 | 20092.0 |
890 | 2021-10-27 23:30:27 | values | 3 | 112716 | 1263 | 5.813 | 19390.3 |
889 | 2021-10-24 17:32:48 | values | 1 | 48755 | 8 | 0.846 | 57630.0 |
888 | 2021-09-17 22:21:11 | values | 1 | 48755 | 8 | 0.733 | 66514.3 |
887 | 2021-09-17 01:04:41 | values | 1 | 48755 | 8 | 0.906 | 53813.5 |
886 | 2021-08-30 12:35:28 | values | 1 | 48755 | 8 | 0.830 | 58741.0 |
885 | 2021-08-28 16:28:27 | values | 3 | 112716 | 1263 | 4.686 | 24053.8 |