History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fecal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
710 | 2024-04-20 00:22:16 | fecal | 1 | 28756 | 9 | 1.436 | 20025.1 |
709 | 2024-04-20 00:14:46 | fecal | 1 | 28756 | 9 | 0.546 | 52666.7 |
708 | 2024-04-19 23:11:49 | fecal | 1 | 28756 | 9 | 0.673 | 42728.1 |
707 | 2024-04-03 05:59:22 | fecal | 1 | 28756 | 9 | 0.533 | 53951.2 |
706 | 2024-03-30 22:23:48 | fecal | 3 | 83667 | 993 | 6.640 | 12600.5 |
705 | 2024-03-30 22:23:47 | fecal | 2 | 53800 | 88 | 3.690 | 14579.9 |
704 | 2024-03-30 22:11:03 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
703 | 2024-03-29 02:36:02 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
702 | 2024-03-06 01:58:50 | fecal | 3 | 83667 | 993 | 4.346 | 19251.5 |
701 | 2024-03-04 11:14:25 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
700 | 2024-03-04 11:14:21 | fecal | 2 | 53800 | 88 | 1.656 | 32487.9 |
699 | 2024-03-04 11:13:43 | fecal | 3 | 83667 | 993 | 4.343 | 19264.8 |
698 | 2024-03-04 02:24:14 | fecal | 2 | 53800 | 88 | 2.330 | 23090.1 |
697 | 2024-03-04 02:24:13 | fecal | 3 | 83667 | 993 | 3.546 | 23594.8 |
696 | 2024-03-04 02:24:13 | fecal | 1 | 28756 | 9 | 0.466 | 61708.2 |
695 | 2024-02-27 20:01:15 | fecal | 1 | 28756 | 9 | 0.983 | 29253.3 |
694 | 2024-02-03 00:01:11 | fecal | 1 | 28756 | 9 | 0.470 | 61183.0 |
693 | 2024-01-30 01:03:13 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
692 | 2024-01-10 06:53:11 | fecal | 1 | 28756 | 9 | 0.453 | 63479.0 |
691 | 2023-12-22 19:22:44 | fecal | 1 | 28756 | 9 | 0.466 | 61708.2 |
690 | 2023-12-01 17:00:52 | fecal | 2 | 53800 | 88 | 1.643 | 32745.0 |
689 | 2023-11-30 21:54:25 | fecal | 2 | 53800 | 88 | 1.406 | 38264.6 |
688 | 2023-11-29 01:03:34 | fecal | 3 | 83667 | 993 | 4.080 | 20506.6 |
687 | 2023-11-27 01:58:35 | fecal | 3 | 83667 | 993 | 3.373 | 24804.9 |
686 | 2023-11-17 13:58:52 | fecal | 1 | 28756 | 9 | 0.423 | 67981.1 |
685 | 2023-11-12 07:37:59 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
684 | 2023-11-10 00:27:07 | fecal | 2 | 53800 | 88 | 1.343 | 40059.6 |
683 | 2023-11-10 00:27:00 | fecal | 3 | 83667 | 993 | 3.453 | 24230.2 |
682 | 2023-11-05 09:35:56 | fecal | 1 | 28756 | 9 | 0.423 | 67981.1 |
681 | 2023-11-03 05:31:47 | fecal | 1 | 28756 | 9 | 0.423 | 67981.1 |
680 | 2023-10-21 09:08:11 | fecal | 1 | 28756 | 9 | 0.440 | 65354.5 |
679 | 2023-10-19 01:18:37 | fecal | 1 | 28756 | 9 | 0.470 | 61183.0 |
678 | 2023-10-18 15:32:03 | fecal | 1 | 28756 | 9 | 0.440 | 65354.5 |
677 | 2023-10-12 01:02:08 | fecal | 1 | 28756 | 9 | 0.420 | 68466.7 |
676 | 2023-10-05 00:54:37 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
675 | 2023-09-27 18:45:28 | fecal | 1 | 28756 | 9 | 0.470 | 61183.0 |
674 | 2023-09-13 12:01:08 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
673 | 2023-08-26 07:27:58 | fecal | 1 | 28756 | 9 | 0.423 | 67981.1 |
672 | 2023-07-05 12:15:49 | fecal | 1 | 28756 | 9 | 0.440 | 65354.5 |
671 | 2023-05-29 20:15:15 | fecal | 1 | 28756 | 9 | 0.436 | 65954.1 |
670 | 2023-04-01 17:02:49 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
669 | 2023-03-23 19:49:54 | fecal | 1 | 28756 | 9 | 0.466 | 61708.2 |
668 | 2023-01-08 09:46:09 | fecal | 1 | 28756 | 9 | 0.436 | 65954.1 |
667 | 2022-12-23 20:21:09 | fecal | 1 | 28756 | 9 | 0.436 | 65954.1 |
666 | 2022-10-12 15:03:26 | fecal | 1 | 28756 | 9 | 0.436 | 65954.1 |
665 | 2022-09-09 14:01:00 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
664 | 2022-08-15 01:11:59 | fecal | 1 | 28756 | 9 | 0.453 | 63479.0 |
663 | 2022-07-29 09:17:06 | fecal | 1 | 28756 | 9 | 0.423 | 67981.1 |
662 | 2022-06-13 10:29:44 | fecal | 1 | 28756 | 9 | 0.470 | 61183.0 |
661 | 2022-06-02 07:40:42 | fecal | 1 | 28756 | 9 | 0.436 | 65954.1 |
660 | 2022-05-21 10:08:59 | fecal | 1 | 28756 | 9 | 0.466 | 61708.2 |
659 | 2022-05-18 00:13:50 | fecal | 1 | 28756 | 9 | 0.453 | 63479.0 |
658 | 2022-02-10 02:26:43 | fecal | 1 | 28756 | 9 | 0.516 | 55728.7 |
657 | 2022-02-09 17:12:54 | fecal | 1 | 28756 | 9 | 0.453 | 63479.0 |
656 | 2021-12-05 20:24:09 | fecal | 1 | 28756 | 9 | 0.513 | 56054.6 |
655 | 2021-11-08 19:47:14 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
654 | 2021-10-13 06:19:23 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
653 | 2021-10-11 03:54:13 | fecal | 1 | 28756 | 9 | 0.423 | 67981.1 |
652 | 2021-09-20 01:05:47 | fecal | 1 | 28756 | 9 | 0.423 | 67981.1 |
651 | 2021-09-17 21:36:01 | fecal | 1 | 28756 | 9 | 0.486 | 59168.7 |
650 | 2021-08-09 04:50:57 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
649 | 2021-08-05 17:54:20 | fecal | 1 | 28756 | 9 | 0.436 | 65954.1 |
648 | 2021-05-05 01:16:18 | fecal | 1 | 28756 | 9 | 0.970 | 29645.4 |
647 | 2021-02-27 19:40:44 | fecal | 1 | 28756 | 9 | 0.453 | 63479.0 |
646 | 2021-02-02 12:06:09 | fecal | 1 | 28756 | 9 | 0.436 | 65954.1 |
645 | 2021-01-30 12:06:49 | fecal | 2 | 53800 | 88 | 1.546 | 34799.5 |
644 | 2021-01-09 22:43:01 | fecal | 1 | 28756 | 9 | 0.470 | 61183.0 |
643 | 2020-11-18 12:27:05 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
642 | 2020-10-31 14:47:54 | fecal | 1 | 28756 | 9 | 0.516 | 55728.7 |
641 | 2020-10-28 13:33:35 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
640 | 2020-09-06 06:36:56 | fecal | 1 | 28756 | 9 | 0.436 | 65954.1 |
639 | 2020-08-28 13:23:25 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
638 | 2020-08-13 21:07:35 | fecal | 1 | 28756 | 9 | 0.456 | 63061.4 |
637 | 2020-08-03 18:19:25 | fecal | 1 | 28756 | 9 | 0.466 | 61708.2 |
636 | 2020-08-01 15:47:43 | fecal | 1 | 28756 | 9 | 0.453 | 63479.0 |
635 | 2020-07-31 17:27:28 | fecal | 1 | 28756 | 9 | 0.450 | 63902.2 |
634 | 2020-07-27 10:54:40 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
633 | 2020-07-22 12:16:10 | fecal | 1 | 28756 | 9 | 0.513 | 56054.6 |
632 | 2020-06-12 12:46:22 | fecal | 1 | 28756 | 9 | 0.436 | 65954.1 |
631 | 2020-05-29 01:38:54 | fecal | 1 | 28756 | 9 | 0.420 | 68466.7 |
630 | 2020-05-15 06:48:28 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
629 | 2020-04-30 04:31:31 | fecal | 1 | 28756 | 9 | 0.466 | 61708.2 |
628 | 2020-03-26 02:19:55 | fecal | 1 | 28756 | 9 | 0.470 | 61183.0 |
627 | 2020-03-24 22:04:12 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
626 | 2020-03-24 18:56:00 | fecal | 1 | 28756 | 9 | 0.450 | 63902.2 |
625 | 2020-03-21 19:42:53 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
624 | 2020-03-20 14:53:01 | fecal | 1 | 28756 | 9 | 0.486 | 59168.7 |
623 | 2020-03-19 22:30:18 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
622 | 2020-03-17 23:08:01 | fecal | 1 | 28756 | 9 | 0.483 | 59536.2 |
621 | 2020-03-02 10:07:15 | fecal | 1 | 28756 | 9 | 0.453 | 63479.0 |
620 | 2020-02-24 16:40:13 | fecal | 1 | 28756 | 9 | 0.453 | 63479.0 |
619 | 2020-02-18 12:43:19 | fecal | 1 | 28756 | 9 | 0.533 | 53951.2 |
618 | 2020-02-17 15:04:40 | fecal | 1 | 28756 | 9 | 1.140 | 25224.6 |
617 | 2020-02-11 13:17:03 | fecal | 1 | 28756 | 9 | 0.500 | 57512.0 |
616 | 2020-02-10 05:27:34 | fecal | 1 | 28756 | 9 | 1.716 | 16757.6 |
615 | 2020-02-08 06:32:11 | fecal | 1 | 28756 | 9 | 0.563 | 51076.4 |
614 | 2020-01-31 08:14:32 | fecal | 1 | 28756 | 9 | 0.546 | 52666.7 |
613 | 2020-01-29 05:57:49 | fecal | 1 | 28756 | 9 | 0.546 | 52666.7 |
612 | 2020-01-29 04:09:02 | fecal | 1 | 28756 | 9 | 0.843 | 34111.5 |
611 | 2020-01-28 23:43:28 | fecal | 1 | 28756 | 9 | 0.563 | 51076.4 |