History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pastry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
483 | 2024-04-26 18:15:09 | pastry | 1 | 48755 | 5 | 0.936 | 52088.7 |
482 | 2024-04-25 15:30:12 | pastry | 3 | 112716 | 547 | 5.936 | 18988.5 |
481 | 2024-04-22 16:34:58 | pastry | 1 | 48755 | 5 | 1.703 | 28628.9 |
480 | 2024-04-22 16:34:51 | pastry | 3 | 112716 | 547 | 6.593 | 17096.3 |
479 | 2024-04-22 16:34:52 | pastry | 2 | 82551 | 51 | 2.750 | 30018.5 |
478 | 2024-04-22 16:34:46 | pastry | 1 | 48755 | 5 | 0.936 | 52088.7 |
477 | 2024-04-06 00:00:55 | pastry | 1 | 48755 | 5 | 4.280 | 11391.4 |
476 | 2024-03-30 02:35:48 | pastry | 2 | 82551 | 51 | 3.703 | 22293.0 |
475 | 2024-03-29 21:12:06 | pastry | 2 | 82551 | 51 | 5.390 | 15315.6 |
474 | 2024-03-29 21:11:45 | pastry | 3 | 112716 | 547 | 6.343 | 17770.1 |
473 | 2024-03-27 22:45:32 | pastry | 3 | 112716 | 547 | 10.236 | 11011.7 |
472 | 2024-03-27 05:57:32 | pastry | 1 | 48755 | 5 | 0.810 | 60191.4 |
471 | 2024-03-25 02:09:30 | pastry | 3 | 112716 | 547 | 6.860 | 16430.9 |
470 | 2024-03-23 07:33:02 | pastry | 3 | 112716 | 547 | 6.470 | 17421.3 |
469 | 2024-03-23 07:33:03 | pastry | 2 | 82551 | 51 | 2.873 | 28733.4 |
468 | 2024-03-23 07:31:42 | pastry | 1 | 48755 | 5 | 0.796 | 61250.0 |
467 | 2024-03-07 04:50:48 | pastry | 2 | 82551 | 51 | 2.940 | 28078.6 |
466 | 2024-03-06 23:30:52 | pastry | 1 | 48755 | 5 | 2.906 | 16777.4 |
465 | 2024-03-06 08:05:55 | pastry | 2 | 82551 | 51 | 8.000 | 10318.9 |
464 | 2024-03-06 04:44:30 | pastry | 2 | 82551 | 51 | 4.750 | 17379.2 |
463 | 2024-02-21 20:43:50 | pastry | 1 | 48755 | 5 | 0.903 | 53992.2 |
462 | 2024-01-29 21:51:22 | pastry | 2 | 82551 | 51 | 2.623 | 31472.0 |
461 | 2024-01-29 21:50:26 | pastry | 3 | 112716 | 547 | 6.326 | 17817.9 |
460 | 2024-01-29 01:14:59 | pastry | 2 | 82551 | 51 | 2.436 | 33887.9 |
459 | 2024-01-29 01:14:36 | pastry | 3 | 112716 | 547 | 5.580 | 20200.0 |
458 | 2024-01-28 22:53:39 | pastry | 3 | 112716 | 547 | 6.050 | 18630.7 |
457 | 2024-01-02 17:30:17 | pastry | 1 | 48755 | 5 | 0.860 | 56691.9 |
456 | 2023-12-25 08:41:43 | pastry | 1 | 48755 | 5 | 0.763 | 63899.1 |
455 | 2023-12-24 02:11:08 | pastry | 3 | 112716 | 547 | 6.280 | 17948.4 |
454 | 2023-12-24 02:11:06 | pastry | 2 | 82551 | 51 | 2.703 | 30540.5 |
453 | 2023-12-14 06:17:43 | pastry | 3 | 112716 | 547 | 4.986 | 22606.5 |
452 | 2023-12-14 06:17:40 | pastry | 2 | 82551 | 51 | 2.280 | 36206.6 |
451 | 2023-11-27 20:33:32 | pastry | 2 | 82551 | 51 | 2.453 | 33653.1 |
450 | 2023-11-25 19:58:48 | pastry | 3 | 112716 | 547 | 5.736 | 19650.6 |
449 | 2023-11-12 07:58:20 | pastry | 1 | 48755 | 5 | 0.876 | 55656.4 |
448 | 2023-11-12 01:06:50 | pastry | 1 | 48755 | 5 | 0.750 | 65006.7 |
447 | 2023-11-11 09:41:24 | pastry | 1 | 48755 | 5 | 2.890 | 16870.2 |
446 | 2023-11-06 11:49:00 | pastry | 1 | 48755 | 5 | 0.860 | 56691.9 |
445 | 2023-10-24 11:11:53 | pastry | 1 | 48755 | 5 | 0.796 | 61250.0 |
444 | 2023-10-21 08:10:44 | pastry | 2 | 82551 | 51 | 2.296 | 35954.3 |
443 | 2023-10-21 08:10:35 | pastry | 3 | 112716 | 547 | 5.656 | 19928.6 |
442 | 2023-10-19 15:27:36 | pastry | 1 | 48755 | 5 | 0.906 | 53813.5 |
441 | 2023-10-11 07:18:57 | pastry | 1 | 48755 | 5 | 1.703 | 28628.9 |
440 | 2023-09-29 09:10:25 | pastry | 1 | 48755 | 5 | 0.846 | 57630.0 |
439 | 2023-09-22 19:05:53 | pastry | 1 | 48755 | 5 | 0.750 | 65006.7 |
438 | 2023-08-27 04:49:49 | pastry | 2 | 82551 | 51 | 2.140 | 38575.2 |
437 | 2023-08-26 06:30:07 | pastry | 1 | 48755 | 5 | 0.903 | 53992.2 |
436 | 2023-08-25 14:05:05 | pastry | 3 | 112716 | 547 | 4.893 | 23036.2 |
435 | 2023-08-22 18:43:50 | pastry | 1 | 48755 | 5 | 0.826 | 59025.4 |
434 | 2023-08-19 02:57:04 | pastry | 1 | 48755 | 5 | 0.843 | 57835.1 |
433 | 2023-05-20 18:59:44 | pastry | 1 | 48755 | 5 | 0.813 | 59969.2 |
432 | 2023-05-14 18:25:56 | pastry | 3 | 112716 | 547 | 4.813 | 23419.1 |
431 | 2023-05-13 17:49:47 | pastry | 2 | 82551 | 51 | 2.186 | 37763.5 |
430 | 2023-05-10 06:04:18 | pastry | 3 | 112716 | 547 | 4.670 | 24136.2 |
429 | 2023-05-01 16:07:06 | pastry | 1 | 48755 | 5 | 0.843 | 57835.1 |
428 | 2023-02-20 05:02:14 | pastry | 2 | 82551 | 51 | 2.186 | 37763.5 |
427 | 2023-02-15 08:04:43 | pastry | 3 | 112716 | 547 | 5.046 | 22337.7 |
426 | 2023-01-08 05:08:19 | pastry | 1 | 48755 | 5 | 0.860 | 56691.9 |
425 | 2023-01-03 05:24:51 | pastry | 1 | 48755 | 5 | 0.750 | 65006.7 |
424 | 2022-12-01 11:22:52 | pastry | 2 | 82551 | 51 | 2.186 | 37763.5 |
423 | 2022-11-27 16:30:41 | pastry | 3 | 112716 | 547 | 4.750 | 23729.7 |
422 | 2022-09-24 10:08:23 | pastry | 1 | 48755 | 5 | 0.766 | 63648.8 |
421 | 2022-09-06 12:07:53 | pastry | 1 | 48755 | 5 | 0.860 | 56691.9 |
420 | 2022-07-08 16:37:56 | pastry | 2 | 82551 | 51 | 2.170 | 38041.9 |
419 | 2022-07-05 10:36:25 | pastry | 3 | 112716 | 547 | 4.750 | 23729.7 |
418 | 2022-07-03 03:24:37 | pastry | 3 | 112716 | 547 | 4.733 | 23814.9 |
417 | 2022-05-08 21:39:42 | pastry | 1 | 48755 | 5 | 0.766 | 63648.8 |
416 | 2022-05-06 17:22:27 | pastry | 1 | 48755 | 5 | 0.780 | 62506.4 |
415 | 2022-04-26 19:55:56 | pastry | 1 | 48755 | 5 | 0.766 | 63648.8 |
414 | 2022-04-23 09:42:01 | pastry | 1 | 48755 | 5 | 0.843 | 57835.1 |
413 | 2022-04-19 22:56:03 | pastry | 1 | 48755 | 5 | 0.826 | 59025.4 |
412 | 2022-02-16 13:29:06 | pastry | 3 | 112716 | 547 | 4.830 | 23336.6 |
411 | 2022-01-27 22:53:42 | pastry | 1 | 48755 | 5 | 0.763 | 63899.1 |
410 | 2022-01-25 16:52:18 | pastry | 1 | 48755 | 5 | 0.893 | 54596.9 |
409 | 2022-01-02 22:04:11 | pastry | 2 | 82551 | 51 | 2.643 | 31233.8 |
408 | 2022-01-01 19:18:00 | pastry | 2 | 82551 | 51 | 2.873 | 28733.4 |
407 | 2022-01-01 02:40:42 | pastry | 2 | 82551 | 51 | 2.516 | 32810.4 |
406 | 2021-12-31 15:22:49 | pastry | 2 | 82551 | 51 | 3.110 | 26543.7 |
405 | 2021-12-30 21:10:42 | pastry | 2 | 82551 | 51 | 2.593 | 31836.1 |
404 | 2021-12-30 03:57:48 | pastry | 2 | 82551 | 51 | 2.376 | 34743.7 |
403 | 2021-12-29 19:53:31 | pastry | 2 | 82551 | 51 | 4.470 | 18467.8 |
402 | 2021-12-29 08:42:55 | pastry | 2 | 82551 | 51 | 4.906 | 16826.5 |
401 | 2021-12-28 19:15:38 | pastry | 2 | 82551 | 51 | 2.656 | 31080.9 |
400 | 2021-12-28 13:43:01 | pastry | 1 | 48755 | 5 | 0.890 | 54780.9 |
399 | 2021-12-28 01:12:11 | pastry | 2 | 82551 | 51 | 2.546 | 32423.8 |
398 | 2021-12-27 15:40:03 | pastry | 2 | 82551 | 51 | 2.626 | 31436.0 |
397 | 2021-12-26 23:31:19 | pastry | 2 | 82551 | 51 | 2.703 | 30540.5 |
396 | 2021-12-26 12:48:56 | pastry | 2 | 82551 | 51 | 2.673 | 30883.3 |
395 | 2021-12-25 13:12:36 | pastry | 2 | 82551 | 51 | 2.406 | 34310.5 |
394 | 2021-12-25 03:54:02 | pastry | 2 | 82551 | 51 | 2.546 | 32423.8 |
393 | 2021-12-24 15:05:18 | pastry | 2 | 82551 | 51 | 2.813 | 29346.2 |
392 | 2021-12-24 03:55:21 | pastry | 2 | 82551 | 51 | 2.326 | 35490.5 |
391 | 2021-12-23 20:12:27 | pastry | 2 | 82551 | 51 | 2.296 | 35954.3 |
390 | 2021-12-23 08:45:02 | pastry | 2 | 82551 | 51 | 2.720 | 30349.6 |
389 | 2021-12-23 00:11:53 | pastry | 2 | 82551 | 51 | 2.890 | 28564.4 |
388 | 2021-12-22 13:13:47 | pastry | 2 | 82551 | 51 | 2.313 | 35690.0 |
387 | 2021-12-22 01:43:29 | pastry | 2 | 82551 | 51 | 2.580 | 31996.5 |
386 | 2021-12-21 16:40:17 | pastry | 2 | 82551 | 51 | 2.610 | 31628.7 |
385 | 2021-12-21 06:41:47 | pastry | 2 | 82551 | 51 | 2.296 | 35954.3 |
384 | 2021-12-20 19:54:55 | pastry | 2 | 82551 | 51 | 2.560 | 32246.5 |