History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"potteries"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
276 | 2024-04-27 23:52:42 | potteries | 1 | 81242 | 2 | 2.940 | 27633.3 |
275 | 2024-04-18 02:30:41 | potteries | 3 | 148641 | 160 | 26.266 | 5659.1 |
274 | 2024-04-16 12:05:13 | potteries | 3 | 148641 | 160 | 18.470 | 8047.7 |
273 | 2024-04-15 23:23:01 | potteries | 3 | 148641 | 160 | 23.360 | 6363.1 |
272 | 2024-04-14 04:01:23 | potteries | 3 | 148641 | 160 | 19.486 | 7628.1 |
271 | 2024-04-14 04:01:18 | potteries | 2 | 121436 | 15 | 6.610 | 18371.6 |
270 | 2024-04-14 04:00:20 | potteries | 1 | 81242 | 2 | 3.233 | 25129.0 |
269 | 2024-03-28 18:03:25 | potteries | 1 | 81242 | 2 | 3.783 | 21475.5 |
268 | 2024-03-26 15:28:46 | potteries | 1 | 81242 | 2 | 1.390 | 58447.5 |
267 | 2024-03-23 08:13:24 | potteries | 1 | 81242 | 2 | 1.656 | 49059.2 |
266 | 2024-03-06 17:12:16 | potteries | 1 | 81242 | 2 | 3.766 | 21572.5 |
265 | 2024-03-05 13:28:03 | potteries | 1 | 81242 | 2 | 1.546 | 52549.8 |
264 | 2024-02-27 16:33:11 | potteries | 1 | 81242 | 2 | 1.500 | 54161.3 |
263 | 2024-02-21 04:35:17 | potteries | 1 | 81242 | 2 | 1.576 | 51549.5 |
262 | 2024-02-01 16:17:00 | potteries | 1 | 81242 | 2 | 1.266 | 64172.2 |
261 | 2024-01-31 16:29:36 | potteries | 1 | 81242 | 2 | 1.390 | 58447.5 |
260 | 2024-01-28 14:22:03 | potteries | 1 | 81242 | 2 | 1.423 | 57092.1 |
259 | 2023-12-31 05:03:20 | potteries | 1 | 81242 | 2 | 1.283 | 63321.9 |
258 | 2023-12-19 12:04:53 | potteries | 1 | 81242 | 2 | 1.266 | 64172.2 |
257 | 2023-12-18 02:28:47 | potteries | 1 | 81242 | 2 | 1.360 | 59736.8 |
256 | 2023-12-12 13:13:39 | potteries | 1 | 81242 | 2 | 1.233 | 65889.7 |
255 | 2023-10-16 03:22:26 | potteries | 1 | 81242 | 2 | 1.470 | 55266.7 |
254 | 2023-10-05 15:50:52 | potteries | 1 | 81242 | 2 | 1.266 | 64172.2 |
253 | 2023-08-02 16:10:26 | potteries | 1 | 81242 | 2 | 1.233 | 65889.7 |
252 | 2023-06-29 04:57:41 | potteries | 1 | 81242 | 2 | 1.436 | 56575.2 |
251 | 2023-04-28 09:47:13 | potteries | 1 | 81242 | 2 | 1.280 | 63470.3 |
250 | 2023-03-16 11:12:50 | potteries | 1 | 81242 | 2 | 1.326 | 61268.5 |
249 | 2023-02-18 00:39:59 | potteries | 1 | 81242 | 2 | 2.533 | 32073.4 |
248 | 2023-01-04 23:17:56 | potteries | 1 | 81242 | 2 | 1.233 | 65889.7 |
247 | 2022-12-16 17:12:03 | potteries | 1 | 81242 | 2 | 1.343 | 60492.9 |
246 | 2022-11-22 00:17:25 | potteries | 1 | 81242 | 2 | 1.326 | 61268.5 |
245 | 2022-11-21 15:25:51 | potteries | 1 | 81242 | 2 | 1.216 | 66810.9 |
244 | 2022-10-29 08:27:23 | potteries | 3 | 148641 | 160 | 7.016 | 21186.0 |
243 | 2022-08-25 19:46:32 | potteries | 1 | 81242 | 2 | 1.313 | 61875.1 |
242 | 2022-08-01 07:20:21 | potteries | 1 | 81242 | 2 | 1.266 | 64172.2 |
241 | 2022-07-28 19:50:58 | potteries | 1 | 81242 | 2 | 1.250 | 64993.6 |
240 | 2022-05-28 18:50:03 | potteries | 3 | 148641 | 160 | 6.076 | 24463.6 |
239 | 2022-05-16 06:01:58 | potteries | 1 | 81242 | 2 | 1.390 | 58447.5 |
238 | 2022-04-12 22:01:16 | potteries | 1 | 81242 | 2 | 1.280 | 63470.3 |
237 | 2022-04-09 06:21:16 | potteries | 1 | 81242 | 2 | 1.250 | 64993.6 |
236 | 2022-04-06 18:39:29 | potteries | 1 | 81242 | 2 | 1.330 | 61084.2 |
235 | 2021-12-23 14:19:08 | potteries | 1 | 81242 | 2 | 1.563 | 51978.2 |
234 | 2021-12-22 20:16:11 | potteries | 1 | 81242 | 2 | 1.763 | 46081.7 |
233 | 2021-09-19 15:00:56 | potteries | 1 | 81242 | 2 | 1.420 | 57212.7 |
232 | 2021-09-13 07:08:34 | potteries | 1 | 81242 | 2 | 1.250 | 64993.6 |
231 | 2021-09-12 09:48:39 | potteries | 1 | 81242 | 2 | 1.453 | 55913.3 |
230 | 2021-06-14 16:09:19 | potteries | 1 | 81242 | 2 | 1.423 | 57092.1 |
229 | 2021-06-12 04:09:57 | potteries | 1 | 81242 | 2 | 2.920 | 27822.6 |
228 | 2021-03-25 18:15:30 | potteries | 3 | 148641 | 160 | 6.903 | 21532.8 |
227 | 2021-03-24 06:19:09 | potteries | 1 | 81242 | 2 | 2.983 | 27235.0 |
226 | 2021-03-09 02:46:34 | potteries | 1 | 81242 | 2 | 1.390 | 58447.5 |
225 | 2021-03-05 21:34:32 | potteries | 1 | 81242 | 2 | 1.376 | 59042.2 |
224 | 2021-03-05 21:19:12 | potteries | 1 | 81242 | 2 | 1.250 | 64993.6 |
223 | 2021-02-04 00:45:44 | potteries | 3 | 148641 | 160 | 6.346 | 23422.8 |
222 | 2020-12-01 10:02:29 | potteries | 1 | 81242 | 2 | 1.376 | 59042.2 |
221 | 2020-11-19 05:56:38 | potteries | 1 | 81242 | 2 | 1.390 | 58447.5 |
220 | 2020-11-11 07:35:49 | potteries | 1 | 81242 | 2 | 1.263 | 64324.6 |
219 | 2020-11-03 02:52:16 | potteries | 1 | 81242 | 2 | 1.280 | 63470.3 |
218 | 2020-11-01 06:48:55 | potteries | 1 | 81242 | 2 | 1.500 | 54161.3 |
217 | 2020-10-26 15:58:48 | potteries | 1 | 81242 | 2 | 1.326 | 61268.5 |
216 | 2020-10-25 21:35:42 | potteries | 1 | 81242 | 2 | 1.483 | 54782.2 |
215 | 2020-08-27 11:44:40 | potteries | 1 | 81242 | 2 | 1.263 | 64324.6 |
214 | 2020-05-25 23:47:35 | potteries | 1 | 81242 | 2 | 1.266 | 64172.2 |
213 | 2020-03-28 23:40:49 | potteries | 1 | 81242 | 2 | 1.500 | 54161.3 |
212 | 2020-03-25 23:33:44 | potteries | 1 | 81242 | 2 | 1.296 | 62686.7 |
211 | 2020-03-24 16:41:32 | potteries | 1 | 81242 | 2 | 1.436 | 56575.2 |
210 | 2020-03-20 14:10:21 | potteries | 1 | 81242 | 2 | 1.420 | 57212.7 |
209 | 2020-02-29 09:08:43 | potteries | 3 | 148641 | 160 | 8.093 | 18366.6 |
208 | 2020-02-29 05:29:22 | potteries | 3 | 148641 | 160 | 7.453 | 19943.8 |
207 | 2020-02-29 04:03:06 | potteries | 3 | 148641 | 160 | 8.300 | 17908.6 |
206 | 2020-02-29 01:38:47 | potteries | 3 | 148641 | 160 | 13.813 | 10760.9 |
205 | 2020-02-28 21:04:40 | potteries | 3 | 148641 | 160 | 11.223 | 13244.3 |
204 | 2020-02-28 20:03:38 | potteries | 3 | 148641 | 160 | 7.593 | 19576.1 |
203 | 2020-02-28 05:48:53 | potteries | 3 | 148641 | 160 | 12.486 | 11904.6 |
202 | 2020-02-26 04:10:59 | potteries | 1 | 81242 | 2 | 1.626 | 49964.3 |
201 | 2020-02-25 14:27:17 | potteries | 1 | 81242 | 2 | 1.343 | 60492.9 |
200 | 2020-02-25 13:05:35 | potteries | 1 | 81242 | 2 | 2.216 | 36661.6 |
199 | 2020-02-22 23:25:19 | potteries | 1 | 81242 | 2 | 3.533 | 22995.2 |
198 | 2020-02-19 19:24:56 | potteries | 1 | 81242 | 2 | 1.436 | 56575.2 |
197 | 2020-02-11 02:36:10 | potteries | 1 | 81242 | 2 | 1.623 | 50056.7 |
196 | 2020-02-10 22:51:35 | potteries | 1 | 81242 | 2 | 1.483 | 54782.2 |
195 | 2020-02-02 11:26:18 | potteries | 1 | 81242 | 2 | 1.783 | 45564.8 |
194 | 2020-02-02 08:31:40 | potteries | 1 | 81242 | 2 | 4.123 | 19704.6 |
193 | 2020-02-02 06:40:47 | potteries | 1 | 81242 | 2 | 1.690 | 48072.2 |
192 | 2020-01-30 08:42:41 | potteries | 1 | 81242 | 2 | 1.813 | 44810.8 |
191 | 2020-01-26 20:23:49 | potteries | 1 | 81242 | 2 | 1.483 | 54782.2 |
190 | 2020-01-22 04:21:04 | potteries | 1 | 81242 | 2 | 4.796 | 16939.5 |
189 | 2020-01-19 14:08:54 | potteries | 1 | 81242 | 2 | 1.500 | 54161.3 |
188 | 2020-01-13 17:18:48 | potteries | 3 | 148641 | 160 | 10.813 | 13746.5 |
187 | 2020-01-13 14:38:32 | potteries | 3 | 148641 | 160 | 7.860 | 18911.1 |
186 | 2020-01-13 09:23:43 | potteries | 3 | 148641 | 160 | 11.000 | 13512.8 |
185 | 2020-01-13 09:23:38 | potteries | 2 | 121436 | 15 | 11.813 | 10279.9 |
184 | 2020-01-13 08:16:04 | potteries | 1 | 81242 | 2 | 1.470 | 55266.7 |
183 | 2020-01-08 05:32:03 | potteries | 1 | 81242 | 2 | 1.250 | 64993.6 |
182 | 2019-12-31 11:46:30 | potteries | 1 | 81242 | 2 | 2.640 | 30773.5 |
181 | 2019-12-30 22:17:30 | potteries | 1 | 81242 | 2 | 1.423 | 57092.1 |
180 | 2019-12-28 14:32:15 | potteries | 1 | 81242 | 2 | 1.640 | 49537.8 |
179 | 2019-11-20 16:09:30 | potteries | 1 | 81242 | 2 | 1.390 | 58447.5 |
178 | 2019-08-21 23:53:59 | potteries | 1 | 81242 | 2 | 1.333 | 60946.7 |
177 | 2019-05-22 06:59:09 | potteries | 1 | 81242 | 2 | 1.316 | 61734.0 |