History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"distillery"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 204 | 2024-05-11 21:05:17 | distillery | 1 | 67641 | 3 | 3.563 | 18984.3 |
| 203 | 2024-05-07 08:36:50 | distillery | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 202 | 2024-05-04 16:21:11 | distillery | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 201 | 2024-04-25 15:03:29 | distillery | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 200 | 2024-04-18 22:37:38 | distillery | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 199 | 2024-04-17 00:22:52 | distillery | 4 | 161450 | 112 | 36.333 | 4443.6 |
| 198 | 2024-04-17 00:22:52 | distillery | 3 | 140603 | 17 | 10.093 | 13930.7 |
| 197 | 2024-04-17 00:22:51 | distillery | 2 | 108824 | 4 | 8.173 | 13315.1 |
| 196 | 2024-04-17 00:06:47 | distillery | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 195 | 2024-04-15 21:56:54 | distillery | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 194 | 2024-04-11 09:02:38 | distillery | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 193 | 2024-04-05 18:44:11 | distillery | 3 | 140603 | 17 | 7.140 | 19692.3 |
| 192 | 2024-04-04 10:18:00 | distillery | 4 | 161450 | 112 | 24.703 | 6535.6 |
| 191 | 2024-04-04 10:17:59 | distillery | 3 | 140603 | 17 | 17.800 | 7899.0 |
| 190 | 2024-04-04 10:17:59 | distillery | 2 | 108824 | 4 | 10.816 | 10061.4 |
| 189 | 2024-04-04 09:43:35 | distillery | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 188 | 2024-03-14 18:19:50 | distillery | 4 | 161450 | 112 | 10.330 | 15629.2 |
| 187 | 2024-03-05 11:26:58 | distillery | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 186 | 2024-03-01 08:27:10 | distillery | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 185 | 2024-03-01 08:27:06 | distillery | 1 | 67641 | 3 | 2.300 | 29409.1 |
| 184 | 2024-02-03 19:43:29 | distillery | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 183 | 2024-01-31 06:45:42 | distillery | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 182 | 2024-01-30 10:46:12 | distillery | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 181 | 2024-01-14 06:32:58 | distillery | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 180 | 2023-12-28 01:48:23 | distillery | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 179 | 2023-12-23 21:40:19 | distillery | 1 | 67641 | 3 | 1.153 | 58665.2 |
| 178 | 2023-12-09 00:22:42 | distillery | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 177 | 2023-12-08 11:10:33 | distillery | 3 | 140603 | 17 | 5.593 | 25139.1 |
| 176 | 2023-11-28 12:20:32 | distillery | 4 | 161450 | 112 | 9.890 | 16324.6 |
| 175 | 2023-11-25 15:18:14 | distillery | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 174 | 2023-11-07 20:36:35 | distillery | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 173 | 2023-11-06 10:28:08 | distillery | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 172 | 2023-09-04 22:30:26 | distillery | 3 | 140603 | 17 | 5.280 | 26629.4 |
| 171 | 2023-08-28 15:54:36 | distillery | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 170 | 2023-08-28 04:05:29 | distillery | 4 | 161450 | 112 | 9.453 | 17079.2 |
| 169 | 2023-07-17 19:55:45 | distillery | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 168 | 2023-05-29 08:43:34 | distillery | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 167 | 2023-05-21 13:46:15 | distillery | 3 | 140603 | 17 | 5.343 | 26315.4 |
| 166 | 2023-05-12 14:40:07 | distillery | 4 | 161450 | 112 | 10.343 | 15609.6 |
| 165 | 2023-03-25 16:44:12 | distillery | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 164 | 2023-03-12 22:13:45 | distillery | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 163 | 2023-03-01 12:40:44 | distillery | 3 | 140603 | 17 | 5.873 | 23940.6 |
| 162 | 2023-02-21 05:58:59 | distillery | 4 | 161450 | 112 | 9.500 | 16994.7 |
| 161 | 2023-01-11 02:51:47 | distillery | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 160 | 2022-12-10 19:08:33 | distillery | 3 | 140603 | 17 | 6.156 | 22840.0 |
| 159 | 2022-12-03 05:56:58 | distillery | 4 | 161450 | 112 | 10.013 | 16124.0 |
| 158 | 2022-11-03 15:16:00 | distillery | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 157 | 2022-10-10 09:30:34 | distillery | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 156 | 2022-09-04 10:53:32 | distillery | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 155 | 2022-07-25 04:34:41 | distillery | 3 | 140603 | 17 | 5.423 | 25927.2 |
| 154 | 2022-07-22 20:34:59 | distillery | 3 | 140603 | 17 | 5.373 | 26168.4 |
| 153 | 2022-06-26 08:21:19 | distillery | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 152 | 2022-05-28 05:47:07 | distillery | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 151 | 2022-04-09 06:44:41 | distillery | 4 | 161450 | 112 | 10.626 | 15193.9 |
| 150 | 2022-03-13 14:58:33 | distillery | 3 | 140603 | 17 | 5.423 | 25927.2 |
| 149 | 2022-02-11 14:56:30 | distillery | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 148 | 2022-02-10 13:04:56 | distillery | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 147 | 2021-12-01 03:11:24 | distillery | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 146 | 2021-11-29 01:45:30 | distillery | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 145 | 2021-10-14 17:15:28 | distillery | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 144 | 2021-10-14 04:50:39 | distillery | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 143 | 2021-10-10 22:35:25 | distillery | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 142 | 2021-09-23 17:25:59 | distillery | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 141 | 2021-07-09 06:41:40 | distillery | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 140 | 2021-05-07 19:49:10 | distillery | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 139 | 2021-04-05 09:59:00 | distillery | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 138 | 2021-04-01 06:10:05 | distillery | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 137 | 2021-02-22 10:53:59 | distillery | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 136 | 2021-01-21 11:11:38 | distillery | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 135 | 2020-12-27 16:12:16 | distillery | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 134 | 2020-12-22 03:50:30 | distillery | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 133 | 2020-09-24 01:44:37 | distillery | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 132 | 2020-09-13 12:41:17 | distillery | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 131 | 2020-07-18 04:47:17 | distillery | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 130 | 2020-06-22 02:43:22 | distillery | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 129 | 2020-06-21 03:14:33 | distillery | 1 | 67641 | 3 | 1.563 | 43276.4 |
| 128 | 2020-06-20 03:03:22 | distillery | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 127 | 2020-06-14 03:15:37 | distillery | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 126 | 2020-06-13 03:18:11 | distillery | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 125 | 2020-04-18 07:36:37 | distillery | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 124 | 2020-04-17 08:21:27 | distillery | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 123 | 2020-04-16 08:18:56 | distillery | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 122 | 2020-04-15 07:41:39 | distillery | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 121 | 2020-03-27 03:20:12 | distillery | 1 | 67641 | 3 | 1.466 | 46139.8 |
| 120 | 2020-03-13 10:24:39 | distillery | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 119 | 2020-03-12 10:43:46 | distillery | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 118 | 2020-03-11 10:04:24 | distillery | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 117 | 2020-03-09 08:24:32 | distillery | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 116 | 2020-03-08 07:07:07 | distillery | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 115 | 2020-03-05 13:55:24 | distillery | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 114 | 2020-03-04 13:17:25 | distillery | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 113 | 2020-03-03 13:00:58 | distillery | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 112 | 2020-03-01 11:22:17 | distillery | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 111 | 2020-02-29 10:37:25 | distillery | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 110 | 2020-02-28 12:46:33 | distillery | 1 | 67641 | 3 | 2.110 | 32057.3 |
| 109 | 2020-02-25 14:12:38 | distillery | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 108 | 2020-02-22 01:10:12 | distillery | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 107 | 2020-02-21 01:02:15 | distillery | 1 | 67641 | 3 | 2.563 | 26391.3 |
| 106 | 2020-02-19 09:02:43 | distillery | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 105 | 2020-02-12 03:12:12 | distillery | 1 | 67641 | 3 | 2.593 | 26086.0 |