History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"groats"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
535 | 2024-04-27 09:45:04 | groats | 1 | 48755 | 8 | 1.156 | 42175.6 |
534 | 2024-04-23 07:10:16 | groats | 2 | 82551 | 99 | 2.170 | 38041.9 |
533 | 2024-04-22 05:48:43 | groats | 2 | 82551 | 99 | 2.513 | 32849.6 |
532 | 2024-04-22 05:48:10 | groats | 3 | 112716 | 1054 | 5.296 | 21283.2 |
531 | 2024-04-20 23:34:58 | groats | 2 | 82551 | 99 | 10.063 | 8203.4 |
530 | 2024-04-20 23:19:49 | groats | 3 | 112716 | 1054 | 15.436 | 7302.2 |
529 | 2024-04-19 13:49:42 | groats | 2 | 82551 | 99 | 2.450 | 33694.3 |
528 | 2024-04-19 13:49:04 | groats | 3 | 112716 | 1054 | 4.860 | 23192.6 |
527 | 2024-04-19 13:38:21 | groats | 3 | 112716 | 1054 | 5.440 | 20719.9 |
526 | 2024-04-06 12:13:52 | groats | 1 | 48755 | 8 | 2.546 | 19149.6 |
525 | 2024-03-31 10:35:48 | groats | 1 | 48755 | 8 | 0.940 | 51867.0 |
524 | 2024-03-05 21:16:45 | groats | 1 | 48755 | 8 | 0.826 | 59025.4 |
523 | 2024-02-28 08:21:01 | groats | 1 | 48755 | 8 | 1.890 | 25796.3 |
522 | 2024-02-28 05:31:40 | groats | 1 | 48755 | 8 | 1.796 | 27146.4 |
521 | 2024-02-07 01:11:58 | groats | 2 | 82551 | 99 | 2.610 | 31628.7 |
520 | 2024-02-07 01:11:22 | groats | 3 | 112716 | 1054 | 5.376 | 20966.5 |
519 | 2024-02-05 10:16:44 | groats | 3 | 112716 | 1054 | 10.376 | 10863.1 |
518 | 2024-01-30 23:58:23 | groats | 2 | 82551 | 99 | 2.453 | 33653.1 |
517 | 2024-01-30 23:57:51 | groats | 3 | 112716 | 1054 | 7.703 | 14632.7 |
516 | 2024-01-30 08:06:34 | groats | 2 | 82551 | 99 | 2.516 | 32810.4 |
515 | 2024-01-30 08:05:30 | groats | 3 | 112716 | 1054 | 5.483 | 20557.4 |
514 | 2024-01-29 21:57:49 | groats | 2 | 82551 | 99 | 2.563 | 32208.7 |
513 | 2024-01-29 21:57:21 | groats | 3 | 112716 | 1054 | 6.046 | 18643.1 |
512 | 2024-01-27 23:05:24 | groats | 1 | 48755 | 8 | 0.720 | 67715.3 |
511 | 2024-01-17 07:05:03 | groats | 3 | 112716 | 1054 | 5.640 | 19985.1 |
510 | 2024-01-11 11:20:16 | groats | 3 | 112716 | 1054 | 5.563 | 20261.7 |
509 | 2024-01-11 11:20:17 | groats | 2 | 82551 | 99 | 2.750 | 30018.5 |
508 | 2023-12-23 08:00:51 | groats | 1 | 48755 | 8 | 0.813 | 59969.2 |
507 | 2023-12-17 13:52:36 | groats | 2 | 82551 | 99 | 2.653 | 31116.1 |
506 | 2023-12-14 10:03:30 | groats | 1 | 48755 | 8 | 0.733 | 66514.3 |
505 | 2023-11-20 19:07:17 | groats | 1 | 48755 | 8 | 0.846 | 57630.0 |
504 | 2023-11-17 09:08:34 | groats | 1 | 48755 | 8 | 1.046 | 46610.9 |
503 | 2023-11-15 14:21:41 | groats | 1 | 48755 | 8 | 0.736 | 66243.2 |
502 | 2023-11-10 12:22:54 | groats | 1 | 48755 | 8 | 1.673 | 29142.3 |
501 | 2023-10-29 23:51:55 | groats | 1 | 48755 | 8 | 0.813 | 59969.2 |
500 | 2023-10-26 16:55:24 | groats | 3 | 112716 | 1054 | 5.703 | 19764.3 |
499 | 2023-10-25 19:25:53 | groats | 3 | 112716 | 1054 | 8.670 | 13000.7 |
498 | 2023-10-24 21:48:11 | groats | 3 | 112716 | 1054 | 4.670 | 24136.2 |
497 | 2023-10-24 12:35:15 | groats | 3 | 112716 | 1054 | 5.420 | 20796.3 |
496 | 2023-10-19 22:52:25 | groats | 1 | 48755 | 8 | 0.810 | 60191.4 |
495 | 2023-10-19 18:04:56 | groats | 3 | 112716 | 1054 | 5.373 | 20978.2 |
494 | 2023-10-13 09:21:05 | groats | 1 | 48755 | 8 | 0.733 | 66514.3 |
493 | 2023-10-11 14:52:03 | groats | 1 | 48755 | 8 | 0.826 | 59025.4 |
492 | 2023-10-07 19:12:16 | groats | 1 | 48755 | 8 | 1.453 | 33554.7 |
491 | 2023-10-01 06:10:13 | groats | 1 | 48755 | 8 | 0.750 | 65006.7 |
490 | 2023-09-25 08:33:55 | groats | 1 | 48755 | 8 | 0.796 | 61250.0 |
489 | 2023-09-22 07:28:15 | groats | 1 | 48755 | 8 | 0.720 | 67715.3 |
488 | 2023-09-18 02:42:55 | groats | 1 | 48755 | 8 | 0.796 | 61250.0 |
487 | 2023-09-16 06:44:39 | groats | 2 | 82551 | 99 | 2.500 | 33020.4 |
486 | 2023-09-12 21:06:01 | groats | 3 | 112716 | 1054 | 6.000 | 18786.0 |
485 | 2023-08-31 00:26:42 | groats | 1 | 48755 | 8 | 0.733 | 66514.3 |
484 | 2023-08-27 22:28:32 | groats | 1 | 48755 | 8 | 0.720 | 67715.3 |
483 | 2023-08-03 06:49:59 | groats | 3 | 112716 | 1054 | 4.656 | 24208.8 |
482 | 2023-06-07 07:48:37 | groats | 2 | 82551 | 99 | 2.096 | 39385.0 |
481 | 2023-05-20 20:52:14 | groats | 1 | 48755 | 8 | 0.750 | 65006.7 |
480 | 2023-04-25 08:09:49 | groats | 1 | 48755 | 8 | 0.813 | 59969.2 |
479 | 2023-04-12 01:54:13 | groats | 3 | 112716 | 1054 | 4.563 | 24702.2 |
478 | 2023-03-12 20:43:13 | groats | 2 | 82551 | 99 | 2.080 | 39688.0 |
477 | 2023-02-15 06:14:11 | groats | 1 | 48755 | 8 | 0.830 | 58741.0 |
476 | 2023-02-07 15:57:11 | groats | 1 | 48755 | 8 | 0.720 | 67715.3 |
475 | 2023-01-27 08:37:37 | groats | 3 | 112716 | 1054 | 4.516 | 24959.3 |
474 | 2023-01-16 22:01:33 | groats | 3 | 112716 | 1054 | 4.593 | 24540.8 |
473 | 2022-12-15 20:28:51 | groats | 2 | 82551 | 99 | 2.060 | 40073.3 |
472 | 2022-12-11 20:41:31 | groats | 1 | 48755 | 8 | 0.720 | 67715.3 |
471 | 2022-10-27 14:18:12 | groats | 3 | 112716 | 1054 | 4.530 | 24882.1 |
470 | 2022-10-24 19:05:39 | groats | 1 | 48755 | 8 | 0.843 | 57835.1 |
469 | 2022-10-21 05:01:13 | groats | 1 | 48755 | 8 | 0.826 | 59025.4 |
468 | 2022-08-15 22:00:00 | groats | 1 | 48755 | 8 | 0.860 | 56691.9 |
467 | 2022-08-08 03:05:33 | groats | 1 | 48755 | 8 | 0.830 | 58741.0 |
466 | 2022-06-01 05:46:13 | groats | 3 | 112716 | 1054 | 4.593 | 24540.8 |
465 | 2022-05-27 14:20:29 | groats | 3 | 112716 | 1054 | 4.593 | 24540.8 |
464 | 2022-05-25 08:46:58 | groats | 3 | 112716 | 1054 | 4.986 | 22606.5 |
463 | 2022-04-10 10:16:06 | groats | 1 | 48755 | 8 | 0.780 | 62506.4 |
462 | 2022-03-21 04:30:01 | groats | 1 | 48755 | 8 | 0.733 | 66514.3 |
461 | 2022-03-17 17:55:36 | groats | 1 | 48755 | 8 | 0.783 | 62266.9 |
460 | 2022-01-16 02:05:40 | groats | 3 | 112716 | 1054 | 6.266 | 17988.5 |
459 | 2022-01-10 13:41:45 | groats | 1 | 48755 | 8 | 0.860 | 56691.9 |
458 | 2021-12-07 07:05:25 | groats | 1 | 48755 | 8 | 1.563 | 31193.2 |
457 | 2021-12-04 00:16:15 | groats | 1 | 48755 | 8 | 1.703 | 28628.9 |
456 | 2021-11-14 22:00:34 | groats | 1 | 48755 | 8 | 0.843 | 57835.1 |
455 | 2021-11-12 18:16:50 | groats | 1 | 48755 | 8 | 0.783 | 62266.9 |
454 | 2021-10-26 23:04:17 | groats | 3 | 112716 | 1054 | 5.266 | 21404.5 |
453 | 2021-10-26 09:56:30 | groats | 3 | 112716 | 1054 | 5.500 | 20493.8 |
452 | 2021-10-25 15:44:48 | groats | 3 | 112716 | 1054 | 5.110 | 22057.9 |
451 | 2021-10-24 15:52:20 | groats | 3 | 112716 | 1054 | 4.826 | 23356.0 |
450 | 2021-10-23 12:47:08 | groats | 3 | 112716 | 1054 | 5.436 | 20735.1 |
449 | 2021-10-22 19:16:02 | groats | 3 | 112716 | 1054 | 5.670 | 19879.4 |
448 | 2021-10-14 21:45:41 | groats | 2 | 82551 | 99 | 2.216 | 37252.3 |
447 | 2021-10-12 20:45:33 | groats | 2 | 82551 | 99 | 2.080 | 39688.0 |
446 | 2021-10-04 16:09:45 | groats | 1 | 48755 | 8 | 0.923 | 52822.3 |
445 | 2021-10-02 13:56:48 | groats | 1 | 48755 | 8 | 0.843 | 57835.1 |
444 | 2021-09-02 12:21:54 | groats | 3 | 112716 | 1054 | 5.046 | 22337.7 |
443 | 2021-08-31 02:42:32 | groats | 1 | 48755 | 8 | 0.733 | 66514.3 |
442 | 2021-08-30 22:11:13 | groats | 1 | 48755 | 8 | 0.843 | 57835.1 |
441 | 2021-08-27 23:58:24 | groats | 3 | 112716 | 1054 | 4.720 | 23880.5 |
440 | 2021-08-15 18:22:31 | groats | 2 | 82551 | 99 | 2.126 | 38829.3 |
439 | 2021-08-13 16:14:08 | groats | 1 | 48755 | 8 | 0.763 | 63899.1 |
438 | 2021-06-27 18:15:10 | groats | 1 | 48755 | 8 | 0.813 | 59969.2 |
437 | 2021-05-30 05:14:50 | groats | 1 | 48755 | 8 | 0.890 | 54780.9 |
436 | 2021-05-12 18:31:09 | groats | 1 | 48755 | 8 | 0.906 | 53813.5 |