History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"woolies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1045 | 2024-04-12 09:19:58 | woolies | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 1044 | 2024-03-28 12:32:05 | woolies | 1 | 69583 | 8 | 1.483 | 46920.4 |
| 1043 | 2024-03-15 13:47:06 | woolies | 2 | 107671 | 86 | 3.296 | 32667.2 |
| 1042 | 2024-03-15 13:40:39 | woolies | 3 | 134027 | 654 | 8.000 | 16753.4 |
| 1041 | 2024-03-15 10:18:59 | woolies | 2 | 107671 | 86 | 3.453 | 31181.9 |
| 1040 | 2024-03-15 10:17:52 | woolies | 3 | 134027 | 654 | 7.046 | 19021.7 |
| 1039 | 2024-03-14 15:42:20 | woolies | 3 | 134027 | 654 | 16.546 | 8100.3 |
| 1038 | 2024-03-14 14:13:22 | woolies | 3 | 134027 | 654 | 18.640 | 7190.3 |
| 1037 | 2024-03-13 04:35:07 | woolies | 3 | 134027 | 654 | 22.236 | 6027.5 |
| 1036 | 2024-03-13 04:35:10 | woolies | 2 | 107671 | 86 | 10.610 | 10148.1 |
| 1035 | 2024-03-13 04:34:35 | woolies | 3 | 134027 | 654 | 11.436 | 11719.7 |
| 1034 | 2024-03-13 04:34:44 | woolies | 1 | 69583 | 8 | 3.283 | 21194.9 |
| 1033 | 2024-03-13 04:34:31 | woolies | 2 | 107671 | 86 | 7.643 | 14087.5 |
| 1032 | 2024-03-13 04:34:25 | woolies | 1 | 69583 | 8 | 2.580 | 26970.2 |
| 1031 | 2024-02-21 08:37:03 | woolies | 1 | 69583 | 8 | 3.220 | 21609.6 |
| 1030 | 2024-02-07 18:34:22 | woolies | 1 | 69583 | 8 | 3.970 | 17527.2 |
| 1029 | 2024-02-06 13:23:34 | woolies | 3 | 134027 | 654 | 6.860 | 19537.5 |
| 1028 | 2024-02-02 17:09:34 | woolies | 3 | 134027 | 654 | 6.390 | 20974.5 |
| 1027 | 2024-01-23 16:00:49 | woolies | 3 | 134027 | 654 | 31.783 | 4216.9 |
| 1026 | 2024-01-19 08:29:50 | woolies | 3 | 134027 | 654 | 6.733 | 19906.0 |
| 1025 | 2024-01-15 13:12:16 | woolies | 3 | 134027 | 654 | 7.470 | 17942.0 |
| 1024 | 2024-01-06 07:53:36 | woolies | 1 | 69583 | 8 | 1.126 | 61796.6 |
| 1023 | 2023-12-29 20:01:41 | woolies | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 1022 | 2023-12-13 02:17:04 | woolies | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 1021 | 2023-11-20 18:33:47 | woolies | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 1020 | 2023-11-19 19:34:14 | woolies | 1 | 69583 | 8 | 2.220 | 31343.7 |
| 1019 | 2023-11-11 09:20:27 | woolies | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 1018 | 2023-11-08 05:14:45 | woolies | 1 | 69583 | 8 | 1.013 | 68690.0 |
| 1017 | 2023-11-01 16:07:46 | woolies | 3 | 134027 | 654 | 6.406 | 20922.1 |
| 1016 | 2023-10-19 10:11:55 | woolies | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 1015 | 2023-10-14 04:11:56 | woolies | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 1014 | 2023-09-12 04:34:50 | woolies | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 1013 | 2023-08-16 12:19:53 | woolies | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 1012 | 2023-08-13 11:33:12 | woolies | 1 | 69583 | 8 | 1.170 | 59472.6 |
| 1011 | 2023-08-12 01:58:26 | woolies | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 1010 | 2023-07-30 19:48:31 | woolies | 3 | 134027 | 654 | 6.156 | 21771.8 |
| 1009 | 2023-05-17 12:30:08 | woolies | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 1008 | 2023-05-05 22:43:10 | woolies | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 1007 | 2023-05-01 15:37:26 | woolies | 3 | 134027 | 654 | 6.390 | 20974.5 |
| 1006 | 2023-04-21 08:24:09 | woolies | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 1005 | 2023-03-18 21:54:43 | woolies | 1 | 69583 | 8 | 1.033 | 67360.1 |
| 1004 | 2023-03-10 19:28:41 | woolies | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 1003 | 2023-02-13 12:10:20 | woolies | 3 | 134027 | 654 | 8.970 | 14941.7 |
| 1002 | 2023-01-31 11:29:29 | woolies | 3 | 134027 | 654 | 5.626 | 23822.8 |
| 1001 | 2023-01-02 09:36:55 | woolies | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 1000 | 2022-12-17 22:23:15 | woolies | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 999 | 2022-10-28 17:51:24 | woolies | 3 | 134027 | 654 | 5.986 | 22390.1 |
| 998 | 2022-09-25 16:41:45 | woolies | 1 | 69583 | 8 | 1.123 | 61961.7 |
| 997 | 2022-09-14 17:03:52 | woolies | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 996 | 2022-08-14 13:22:08 | woolies | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 995 | 2022-07-29 13:44:41 | woolies | 3 | 134027 | 654 | 7.140 | 18771.3 |
| 994 | 2022-07-25 23:42:29 | woolies | 3 | 134027 | 654 | 6.080 | 22043.9 |
| 993 | 2022-07-04 01:03:53 | woolies | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 992 | 2022-05-21 21:55:48 | woolies | 3 | 134027 | 654 | 5.750 | 23309.0 |
| 991 | 2022-05-18 12:18:16 | woolies | 3 | 134027 | 654 | 5.640 | 23763.7 |
| 990 | 2022-05-16 04:09:33 | woolies | 3 | 134027 | 654 | 5.753 | 23296.9 |
| 989 | 2022-05-07 13:40:55 | woolies | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 988 | 2022-04-23 10:08:13 | woolies | 3 | 134027 | 654 | 6.500 | 20619.5 |
| 987 | 2022-04-17 06:36:08 | woolies | 1 | 69583 | 8 | 1.106 | 62914.1 |
| 986 | 2022-04-10 20:13:27 | woolies | 1 | 69583 | 8 | 1.060 | 65644.3 |
| 985 | 2022-02-25 02:12:30 | woolies | 1 | 69583 | 8 | 1.576 | 44151.6 |
| 984 | 2022-02-08 20:05:02 | woolies | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 983 | 2022-01-26 13:01:09 | woolies | 1 | 69583 | 8 | 1.110 | 62687.4 |
| 982 | 2022-01-18 13:12:41 | woolies | 3 | 134027 | 654 | 5.936 | 22578.7 |
| 981 | 2022-01-15 04:48:52 | woolies | 3 | 134027 | 654 | 6.080 | 22043.9 |
| 980 | 2021-12-26 01:37:37 | woolies | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 979 | 2021-12-18 19:51:13 | woolies | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 978 | 2021-12-18 18:13:44 | woolies | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 977 | 2021-11-26 01:35:38 | woolies | 1 | 69583 | 8 | 1.060 | 65644.3 |
| 976 | 2021-10-21 04:28:51 | woolies | 3 | 134027 | 654 | 5.843 | 22938.0 |
| 975 | 2021-10-14 15:23:12 | woolies | 3 | 134027 | 654 | 5.986 | 22390.1 |
| 974 | 2021-10-07 16:10:53 | woolies | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 973 | 2021-10-05 12:58:32 | woolies | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 972 | 2021-09-16 10:22:35 | woolies | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 971 | 2021-09-15 15:53:01 | woolies | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 970 | 2021-09-14 05:42:41 | woolies | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 969 | 2021-09-05 16:27:55 | woolies | 1 | 69583 | 8 | 1.143 | 60877.5 |
| 968 | 2021-09-02 02:10:15 | woolies | 3 | 134027 | 654 | 5.593 | 23963.3 |
| 967 | 2021-08-29 19:01:41 | woolies | 3 | 134027 | 654 | 6.346 | 21119.9 |
| 966 | 2021-08-27 14:09:46 | woolies | 3 | 134027 | 654 | 5.843 | 22938.0 |
| 965 | 2021-08-06 04:55:27 | woolies | 3 | 134027 | 654 | 5.530 | 24236.3 |
| 964 | 2021-07-13 05:19:15 | woolies | 3 | 134027 | 654 | 6.593 | 20328.7 |
| 963 | 2021-07-12 07:30:57 | woolies | 3 | 134027 | 654 | 5.560 | 24105.6 |
| 962 | 2021-06-15 17:44:34 | woolies | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 961 | 2021-05-22 10:33:20 | woolies | 3 | 134027 | 654 | 5.966 | 22465.1 |
| 960 | 2021-05-19 01:32:36 | woolies | 1 | 69583 | 8 | 1.123 | 61961.7 |
| 959 | 2021-04-30 15:13:16 | woolies | 3 | 134027 | 654 | 6.503 | 20610.0 |
| 958 | 2021-04-14 11:54:57 | woolies | 1 | 69583 | 8 | 1.170 | 59472.6 |
| 957 | 2021-04-09 14:41:07 | woolies | 3 | 134027 | 654 | 7.406 | 18097.1 |
| 956 | 2021-03-18 04:27:02 | woolies | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 955 | 2021-03-16 08:42:23 | woolies | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 954 | 2021-02-21 00:54:57 | woolies | 1 | 69583 | 8 | 1.190 | 58473.1 |
| 953 | 2021-02-11 21:08:47 | woolies | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 952 | 2021-01-31 07:49:31 | woolies | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 951 | 2021-01-23 22:27:59 | woolies | 3 | 134027 | 654 | 6.156 | 21771.8 |
| 950 | 2021-01-13 14:43:52 | woolies | 3 | 134027 | 654 | 5.703 | 23501.1 |
| 949 | 2021-01-04 11:43:39 | woolies | 3 | 134027 | 654 | 9.360 | 14319.1 |
| 948 | 2021-01-01 02:10:09 | woolies | 3 | 134027 | 654 | 6.610 | 20276.4 |
| 947 | 2020-12-13 09:02:02 | woolies | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 946 | 2020-12-13 01:22:06 | woolies | 3 | 134027 | 654 | 6.016 | 22278.4 |