History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bakery"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
379 | 2024-04-13 17:15:11 | bakery | 1 | 48755 | 4 | 0.843 | 57835.1 |
378 | 2024-03-30 21:35:45 | bakery | 2 | 82551 | 60 | 8.046 | 10259.9 |
377 | 2024-03-30 20:06:30 | bakery | 3 | 112716 | 785 | 11.813 | 9541.7 |
376 | 2024-03-30 12:15:49 | bakery | 2 | 82551 | 60 | 2.830 | 29170.0 |
375 | 2024-03-30 12:15:22 | bakery | 3 | 112716 | 785 | 6.093 | 18499.3 |
374 | 2024-03-29 03:10:29 | bakery | 3 | 112716 | 785 | 12.093 | 9320.8 |
373 | 2024-03-29 03:10:28 | bakery | 2 | 82551 | 60 | 2.843 | 29036.6 |
372 | 2024-03-29 03:02:26 | bakery | 1 | 48755 | 4 | 1.033 | 47197.5 |
371 | 2024-03-29 03:02:18 | bakery | 3 | 112716 | 785 | 6.326 | 17817.9 |
370 | 2024-03-29 03:02:18 | bakery | 2 | 82551 | 60 | 2.780 | 29694.6 |
369 | 2024-03-29 03:02:18 | bakery | 1 | 48755 | 4 | 0.983 | 49598.2 |
368 | 2024-03-13 16:12:08 | bakery | 1 | 48755 | 4 | 1.953 | 24964.2 |
367 | 2024-01-18 01:46:49 | bakery | 3 | 112716 | 785 | 5.403 | 20861.7 |
366 | 2024-01-18 01:46:50 | bakery | 2 | 82551 | 60 | 2.516 | 32810.4 |
365 | 2024-01-11 07:35:08 | bakery | 2 | 82551 | 60 | 5.013 | 16467.4 |
364 | 2024-01-11 07:35:07 | bakery | 3 | 112716 | 785 | 5.623 | 20045.5 |
363 | 2023-12-31 11:11:47 | bakery | 1 | 48755 | 4 | 0.860 | 56691.9 |
362 | 2023-12-06 18:07:19 | bakery | 1 | 48755 | 4 | 0.860 | 56691.9 |
361 | 2023-11-17 16:11:13 | bakery | 1 | 48755 | 4 | 0.860 | 56691.9 |
360 | 2023-11-16 10:56:43 | bakery | 1 | 48755 | 4 | 0.813 | 59969.2 |
359 | 2023-11-04 23:53:24 | bakery | 1 | 48755 | 4 | 0.733 | 66514.3 |
358 | 2023-10-24 07:51:09 | bakery | 1 | 48755 | 4 | 0.890 | 54780.9 |
357 | 2023-10-19 20:18:10 | bakery | 1 | 48755 | 4 | 0.766 | 63648.8 |
356 | 2023-10-19 06:53:56 | bakery | 1 | 48755 | 4 | 1.000 | 48755.0 |
355 | 2023-10-13 17:47:51 | bakery | 1 | 48755 | 4 | 0.826 | 59025.4 |
354 | 2023-10-05 03:52:21 | bakery | 1 | 48755 | 4 | 0.826 | 59025.4 |
353 | 2023-09-23 22:23:31 | bakery | 1 | 48755 | 4 | 0.860 | 56691.9 |
352 | 2023-09-12 20:21:19 | bakery | 1 | 48755 | 4 | 0.796 | 61250.0 |
351 | 2023-08-21 00:04:49 | bakery | 1 | 48755 | 4 | 0.860 | 56691.9 |
350 | 2023-08-15 22:14:04 | bakery | 1 | 48755 | 4 | 0.780 | 62506.4 |
349 | 2023-05-15 07:36:54 | bakery | 1 | 48755 | 4 | 0.750 | 65006.7 |
348 | 2023-05-10 14:46:21 | bakery | 1 | 48755 | 4 | 0.763 | 63899.1 |
347 | 2023-04-22 01:36:39 | bakery | 1 | 48755 | 4 | 0.830 | 58741.0 |
346 | 2023-03-24 12:01:45 | bakery | 1 | 48755 | 4 | 0.750 | 65006.7 |
345 | 2023-03-11 08:41:31 | bakery | 1 | 48755 | 4 | 0.810 | 60191.4 |
344 | 2023-01-28 10:27:42 | bakery | 1 | 48755 | 4 | 0.860 | 56691.9 |
343 | 2023-01-24 19:06:09 | bakery | 1 | 48755 | 4 | 0.750 | 65006.7 |
342 | 2022-12-30 15:31:19 | bakery | 1 | 48755 | 4 | 0.733 | 66514.3 |
341 | 2022-10-06 20:40:52 | bakery | 1 | 48755 | 4 | 0.763 | 63899.1 |
340 | 2022-10-03 06:32:51 | bakery | 1 | 48755 | 4 | 0.796 | 61250.0 |
339 | 2022-09-19 01:18:44 | bakery | 1 | 48755 | 4 | 0.766 | 63648.8 |
338 | 2022-08-27 17:33:44 | bakery | 1 | 48755 | 4 | 0.873 | 55847.7 |
337 | 2022-06-20 02:43:03 | bakery | 1 | 48755 | 4 | 0.763 | 63899.1 |
336 | 2022-05-01 11:07:23 | bakery | 1 | 48755 | 4 | 0.750 | 65006.7 |
335 | 2022-03-04 09:40:36 | bakery | 1 | 48755 | 4 | 1.046 | 46610.9 |
334 | 2022-02-28 23:36:56 | bakery | 1 | 48755 | 4 | 0.813 | 59969.2 |
333 | 2022-01-24 19:42:33 | bakery | 1 | 48755 | 4 | 1.000 | 48755.0 |
332 | 2021-11-18 04:01:01 | bakery | 1 | 48755 | 4 | 0.953 | 51159.5 |
331 | 2021-11-17 09:49:18 | bakery | 1 | 48755 | 4 | 0.783 | 62266.9 |
330 | 2021-10-01 19:00:00 | bakery | 1 | 48755 | 4 | 0.876 | 55656.4 |
329 | 2021-09-14 16:54:11 | bakery | 1 | 48755 | 4 | 0.763 | 63899.1 |
328 | 2021-08-11 04:25:11 | bakery | 1 | 48755 | 4 | 0.766 | 63648.8 |
327 | 2021-05-26 21:11:21 | bakery | 1 | 48755 | 4 | 0.860 | 56691.9 |
326 | 2021-05-10 07:45:21 | bakery | 1 | 48755 | 4 | 0.920 | 52994.6 |
325 | 2021-05-06 21:47:31 | bakery | 1 | 48755 | 4 | 0.876 | 55656.4 |
324 | 2021-03-30 10:03:24 | bakery | 1 | 48755 | 4 | 0.780 | 62506.4 |
323 | 2021-03-13 20:27:28 | bakery | 1 | 48755 | 4 | 0.750 | 65006.7 |
322 | 2021-01-31 18:03:02 | bakery | 1 | 48755 | 4 | 0.766 | 63648.8 |
321 | 2021-01-14 00:34:31 | bakery | 1 | 48755 | 4 | 1.030 | 47335.0 |
320 | 2020-11-11 19:36:48 | bakery | 1 | 48755 | 4 | 0.780 | 62506.4 |
319 | 2020-10-29 11:26:36 | bakery | 1 | 48755 | 4 | 0.763 | 63899.1 |
318 | 2020-10-04 18:21:42 | bakery | 1 | 48755 | 4 | 0.750 | 65006.7 |
317 | 2020-09-30 10:33:10 | bakery | 1 | 48755 | 4 | 0.813 | 59969.2 |
316 | 2020-09-10 15:42:01 | bakery | 1 | 48755 | 4 | 0.733 | 66514.3 |
315 | 2020-08-05 13:47:10 | bakery | 1 | 48755 | 4 | 0.766 | 63648.8 |
314 | 2020-08-03 02:10:23 | bakery | 1 | 48755 | 4 | 0.766 | 63648.8 |
313 | 2020-07-24 18:41:07 | bakery | 1 | 48755 | 4 | 0.796 | 61250.0 |
312 | 2020-07-22 20:31:50 | bakery | 1 | 48755 | 4 | 0.813 | 59969.2 |
311 | 2020-05-03 12:51:00 | bakery | 1 | 48755 | 4 | 0.783 | 62266.9 |
310 | 2020-04-22 13:40:54 | bakery | 1 | 48755 | 4 | 0.826 | 59025.4 |
309 | 2020-03-28 10:24:57 | bakery | 1 | 48755 | 4 | 0.860 | 56691.9 |
308 | 2020-03-27 16:09:06 | bakery | 1 | 48755 | 4 | 0.873 | 55847.7 |
307 | 2020-03-24 16:47:26 | bakery | 1 | 48755 | 4 | 0.906 | 53813.5 |
306 | 2020-03-23 21:00:46 | bakery | 1 | 48755 | 4 | 0.890 | 54780.9 |
305 | 2020-03-22 13:26:58 | bakery | 1 | 48755 | 4 | 0.890 | 54780.9 |
304 | 2020-03-18 08:57:37 | bakery | 1 | 48755 | 4 | 1.076 | 45311.3 |
303 | 2020-02-24 08:43:36 | bakery | 1 | 48755 | 4 | 0.906 | 53813.5 |
302 | 2020-02-20 14:24:17 | bakery | 1 | 48755 | 4 | 1.046 | 46610.9 |
301 | 2020-02-19 13:34:30 | bakery | 1 | 48755 | 4 | 1.140 | 42767.5 |
300 | 2020-02-07 22:31:57 | bakery | 3 | 112716 | 785 | 8.250 | 13662.5 |
299 | 2020-02-07 19:06:49 | bakery | 3 | 112716 | 785 | 6.063 | 18590.8 |
298 | 2020-02-07 09:44:19 | bakery | 3 | 112716 | 785 | 10.766 | 10469.6 |
297 | 2020-02-07 08:44:56 | bakery | 3 | 112716 | 785 | 6.466 | 17432.1 |
296 | 2020-02-06 11:17:29 | bakery | 3 | 112716 | 785 | 10.736 | 10498.9 |
295 | 2020-02-03 19:09:46 | bakery | 1 | 48755 | 4 | 0.856 | 56956.8 |
294 | 2020-02-02 23:10:11 | bakery | 1 | 48755 | 4 | 0.923 | 52822.3 |
293 | 2020-02-02 04:31:54 | bakery | 1 | 48755 | 4 | 1.470 | 33166.7 |
292 | 2020-01-31 15:08:28 | bakery | 1 | 48755 | 4 | 2.813 | 17332.0 |
291 | 2020-01-26 21:58:49 | bakery | 1 | 48755 | 4 | 1.796 | 27146.4 |
290 | 2020-01-22 06:58:03 | bakery | 1 | 48755 | 4 | 0.923 | 52822.3 |
289 | 2020-01-22 02:11:03 | bakery | 1 | 48755 | 4 | 0.950 | 51321.1 |
288 | 2020-01-20 11:37:47 | bakery | 2 | 82551 | 60 | 3.093 | 26689.6 |
287 | 2020-01-14 03:30:57 | bakery | 1 | 48755 | 4 | 1.750 | 27860.0 |
286 | 2020-01-13 17:39:43 | bakery | 1 | 48755 | 4 | 1.953 | 24964.2 |
285 | 2020-01-12 04:59:06 | bakery | 2 | 82551 | 60 | 4.373 | 18877.4 |
284 | 2020-01-12 03:01:46 | bakery | 3 | 112716 | 785 | 6.156 | 18309.9 |
283 | 2020-01-12 01:58:30 | bakery | 3 | 112716 | 785 | 5.936 | 18988.5 |
282 | 2020-01-11 22:34:10 | bakery | 2 | 82551 | 60 | 4.170 | 19796.4 |
281 | 2020-01-11 22:34:03 | bakery | 3 | 112716 | 785 | 6.390 | 17639.4 |
280 | 2020-01-11 18:20:35 | bakery | 1 | 48755 | 4 | 0.986 | 49447.3 |