History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coarse"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1013 | 2024-04-26 10:40:22 | coarse | 1 | 48755 | 7 | 0.906 | 53813.5 |
| 1012 | 2024-04-23 08:19:17 | coarse | 3 | 112716 | 1039 | 12.236 | 9211.8 |
| 1011 | 2024-04-11 11:46:01 | coarse | 3 | 112716 | 1039 | 6.186 | 18221.1 |
| 1010 | 2024-03-31 21:20:32 | coarse | 3 | 112716 | 1039 | 12.160 | 9269.4 |
| 1009 | 2024-03-31 21:20:25 | coarse | 2 | 82551 | 68 | 6.063 | 13615.5 |
| 1008 | 2024-03-31 21:20:13 | coarse | 1 | 48755 | 7 | 2.000 | 24377.5 |
| 1007 | 2024-03-29 21:28:48 | coarse | 3 | 112716 | 1039 | 11.343 | 9937.1 |
| 1006 | 2024-03-29 03:40:42 | coarse | 3 | 112716 | 1039 | 17.720 | 6360.9 |
| 1005 | 2024-03-29 03:40:18 | coarse | 3 | 112716 | 1039 | 9.860 | 11431.6 |
| 1004 | 2024-03-04 04:11:07 | coarse | 1 | 48755 | 7 | 2.923 | 16679.8 |
| 1003 | 2024-02-25 07:25:53 | coarse | 1 | 48755 | 7 | 0.920 | 52994.6 |
| 1002 | 2024-02-20 02:43:52 | coarse | 1 | 48755 | 7 | 1.920 | 25393.2 |
| 1001 | 2024-02-06 07:00:55 | coarse | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 1000 | 2024-02-02 11:14:10 | coarse | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 999 | 2024-01-22 19:08:41 | coarse | 1 | 48755 | 7 | 0.986 | 49447.3 |
| 998 | 2024-01-16 00:09:59 | coarse | 3 | 112716 | 1039 | 4.876 | 23116.5 |
| 997 | 2024-01-16 00:09:57 | coarse | 2 | 82551 | 68 | 2.266 | 36430.3 |
| 996 | 2023-12-10 15:23:02 | coarse | 3 | 112716 | 1039 | 5.940 | 18975.8 |
| 995 | 2023-12-05 22:24:22 | coarse | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 994 | 2023-12-04 04:34:31 | coarse | 2 | 82551 | 68 | 2.326 | 35490.5 |
| 993 | 2023-12-01 06:07:19 | coarse | 3 | 112716 | 1039 | 5.466 | 20621.3 |
| 992 | 2023-11-19 04:15:47 | coarse | 2 | 82551 | 68 | 2.580 | 31996.5 |
| 991 | 2023-11-19 04:15:42 | coarse | 3 | 112716 | 1039 | 5.893 | 19127.1 |
| 990 | 2023-11-17 06:34:51 | coarse | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 989 | 2023-11-08 17:34:32 | coarse | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 988 | 2023-11-05 07:21:58 | coarse | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 987 | 2023-10-28 07:10:59 | coarse | 3 | 112716 | 1039 | 5.860 | 19234.8 |
| 986 | 2023-10-27 17:48:10 | coarse | 2 | 82551 | 68 | 2.470 | 33421.5 |
| 985 | 2023-10-27 17:48:01 | coarse | 3 | 112716 | 1039 | 5.890 | 19136.8 |
| 984 | 2023-10-19 20:25:30 | coarse | 1 | 48755 | 7 | 1.626 | 29984.6 |
| 983 | 2023-10-18 22:46:15 | coarse | 1 | 48755 | 7 | 0.970 | 50262.9 |
| 982 | 2023-10-18 07:22:39 | coarse | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 981 | 2023-10-13 16:07:57 | coarse | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 980 | 2023-10-08 13:40:04 | coarse | 1 | 48755 | 7 | 0.783 | 62266.9 |
| 979 | 2023-09-30 00:00:17 | coarse | 2 | 82551 | 68 | 2.483 | 33246.5 |
| 978 | 2023-09-26 04:29:00 | coarse | 3 | 112716 | 1039 | 4.860 | 23192.6 |
| 977 | 2023-09-24 21:32:28 | coarse | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 976 | 2023-09-20 20:15:04 | coarse | 1 | 48755 | 7 | 0.846 | 57630.0 |
| 975 | 2023-09-17 02:34:40 | coarse | 2 | 82551 | 68 | 2.530 | 32628.9 |
| 974 | 2023-09-15 20:22:07 | coarse | 3 | 112716 | 1039 | 5.596 | 20142.2 |
| 973 | 2023-09-11 22:15:58 | coarse | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 972 | 2023-09-10 17:10:56 | coarse | 3 | 112716 | 1039 | 6.030 | 18692.5 |
| 971 | 2023-09-08 23:44:54 | coarse | 3 | 112716 | 1039 | 4.733 | 23814.9 |
| 970 | 2023-07-13 23:14:02 | coarse | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 969 | 2023-07-12 16:20:33 | coarse | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 968 | 2023-05-27 14:05:39 | coarse | 3 | 112716 | 1039 | 4.750 | 23729.7 |
| 967 | 2023-04-16 23:35:16 | coarse | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 966 | 2023-04-08 21:30:34 | coarse | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 965 | 2023-03-06 06:08:09 | coarse | 3 | 112716 | 1039 | 4.906 | 22975.1 |
| 964 | 2023-02-08 16:17:51 | coarse | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 963 | 2023-01-07 09:57:37 | coarse | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 962 | 2023-01-03 15:55:13 | coarse | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 961 | 2022-12-19 19:55:17 | coarse | 3 | 112716 | 1039 | 5.766 | 19548.4 |
| 960 | 2022-12-18 11:52:48 | coarse | 3 | 112716 | 1039 | 5.423 | 20784.8 |
| 959 | 2022-12-17 16:43:26 | coarse | 3 | 112716 | 1039 | 6.016 | 18736.0 |
| 958 | 2022-12-16 19:41:54 | coarse | 3 | 112716 | 1039 | 6.063 | 18590.8 |
| 957 | 2022-12-14 12:06:07 | coarse | 3 | 112716 | 1039 | 5.330 | 21147.5 |
| 956 | 2022-12-13 11:07:11 | coarse | 3 | 112716 | 1039 | 5.720 | 19705.6 |
| 955 | 2022-12-12 15:29:34 | coarse | 3 | 112716 | 1039 | 5.033 | 22395.4 |
| 954 | 2022-12-11 15:19:21 | coarse | 3 | 112716 | 1039 | 5.483 | 20557.4 |
| 953 | 2022-12-09 14:04:04 | coarse | 3 | 112716 | 1039 | 6.733 | 16740.8 |
| 952 | 2022-12-08 19:51:59 | coarse | 3 | 112716 | 1039 | 5.890 | 19136.8 |
| 951 | 2022-12-06 18:24:21 | coarse | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 950 | 2022-11-02 03:35:57 | coarse | 3 | 112716 | 1039 | 4.766 | 23650.0 |
| 949 | 2022-09-20 01:12:15 | coarse | 1 | 48755 | 7 | 0.783 | 62266.9 |
| 948 | 2022-09-08 01:08:58 | coarse | 3 | 112716 | 1039 | 4.813 | 23419.1 |
| 947 | 2022-09-03 09:44:29 | coarse | 3 | 112716 | 1039 | 5.190 | 21717.9 |
| 946 | 2022-08-06 04:23:46 | coarse | 3 | 112716 | 1039 | 5.296 | 21283.2 |
| 945 | 2022-08-03 20:30:06 | coarse | 3 | 112716 | 1039 | 4.860 | 23192.6 |
| 944 | 2022-08-03 03:50:46 | coarse | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 943 | 2022-05-31 01:45:41 | coarse | 1 | 48755 | 7 | 0.783 | 62266.9 |
| 942 | 2022-04-01 15:53:31 | coarse | 1 | 48755 | 7 | 1.063 | 45865.5 |
| 941 | 2022-03-30 12:53:10 | coarse | 1 | 48755 | 7 | 1.186 | 41108.8 |
| 940 | 2022-03-05 07:22:23 | coarse | 3 | 112716 | 1039 | 4.903 | 22989.2 |
| 939 | 2022-02-16 11:59:26 | coarse | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 938 | 2022-01-01 03:08:51 | coarse | 1 | 48755 | 7 | 0.966 | 50471.0 |
| 937 | 2021-12-30 01:12:05 | coarse | 1 | 48755 | 7 | 0.903 | 53992.2 |
| 936 | 2021-12-01 13:50:58 | coarse | 3 | 112716 | 1039 | 5.970 | 18880.4 |
| 935 | 2021-11-18 03:09:03 | coarse | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 934 | 2021-11-15 03:48:32 | coarse | 1 | 48755 | 7 | 0.893 | 54596.9 |
| 933 | 2021-11-14 10:53:43 | coarse | 3 | 112716 | 1039 | 5.736 | 19650.6 |
| 932 | 2021-11-13 10:48:18 | coarse | 3 | 112716 | 1039 | 10.063 | 11201.0 |
| 931 | 2021-11-12 10:51:09 | coarse | 3 | 112716 | 1039 | 5.500 | 20493.8 |
| 930 | 2021-10-27 10:43:28 | coarse | 3 | 112716 | 1039 | 5.033 | 22395.4 |
| 929 | 2021-10-26 13:55:09 | coarse | 3 | 112716 | 1039 | 5.203 | 21663.7 |
| 928 | 2021-10-25 17:33:06 | coarse | 3 | 112716 | 1039 | 4.860 | 23192.6 |
| 927 | 2021-10-25 04:52:39 | coarse | 3 | 112716 | 1039 | 6.016 | 18736.0 |
| 926 | 2021-10-24 20:31:02 | coarse | 3 | 112716 | 1039 | 9.780 | 11525.2 |
| 925 | 2021-10-24 09:39:56 | coarse | 3 | 112716 | 1039 | 5.220 | 21593.1 |
| 924 | 2021-10-23 23:29:15 | coarse | 3 | 112716 | 1039 | 5.656 | 19928.6 |
| 923 | 2021-10-23 15:14:07 | coarse | 3 | 112716 | 1039 | 5.310 | 21227.1 |
| 922 | 2021-10-23 04:30:06 | coarse | 3 | 112716 | 1039 | 5.483 | 20557.4 |
| 921 | 2021-10-22 17:11:26 | coarse | 3 | 112716 | 1039 | 6.420 | 17557.0 |
| 920 | 2021-10-14 12:50:30 | coarse | 3 | 112716 | 1039 | 5.203 | 21663.7 |
| 919 | 2021-10-13 15:21:08 | coarse | 3 | 112716 | 1039 | 4.783 | 23566.0 |
| 918 | 2021-10-12 12:56:53 | coarse | 3 | 112716 | 1039 | 5.860 | 19234.8 |
| 917 | 2021-10-11 13:01:18 | coarse | 3 | 112716 | 1039 | 5.190 | 21717.9 |
| 916 | 2021-10-10 11:30:38 | coarse | 3 | 112716 | 1039 | 5.640 | 19985.1 |
| 915 | 2021-09-03 16:41:44 | coarse | 1 | 48755 | 7 | 0.923 | 52822.3 |
| 914 | 2021-08-19 08:13:40 | coarse | 1 | 48755 | 7 | 0.890 | 54780.9 |