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 |
| 995 | 2024-05-07 03:29:22 | values | 1 | 48755 | 8 | 0.923 | 52822.3 |
| 994 | 2024-05-01 11:29:29 | values | 3 | 112716 | 1263 | 6.690 | 16848.4 |
| 993 | 2024-04-30 07:49:25 | values | 3 | 112716 | 1263 | 5.470 | 20606.2 |
| 992 | 2024-04-30 07:24:17 | values | 3 | 112716 | 1263 | 6.610 | 17052.3 |
| 991 | 2024-04-28 04:22:38 | values | 3 | 112716 | 1263 | 15.736 | 7162.9 |
| 990 | 2024-04-27 16:35:47 | values | 3 | 112716 | 1263 | 7.640 | 14753.4 |
| 989 | 2024-04-27 12:21:16 | values | 1 | 48755 | 8 | 0.953 | 51159.5 |
| 988 | 2024-04-27 11:39:56 | values | 1 | 48755 | 8 | 1.080 | 45143.5 |
| 987 | 2024-04-27 11:39:41 | values | 3 | 112716 | 1263 | 6.843 | 16471.7 |
| 986 | 2024-04-27 11:39:23 | values | 2 | 82551 | 86 | 6.296 | 13111.7 |
| 985 | 2024-04-27 07:21:48 | values | 2 | 82551 | 86 | 6.360 | 12979.7 |
| 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 |