History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pills"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
723 | 2024-03-27 03:17:14 | pills | 1 | 28756 | 27 | 0.610 | 47141.0 |
722 | 2024-03-20 12:13:28 | pills | 1 | 28756 | 27 | 0.563 | 51076.4 |
721 | 2024-03-03 21:45:00 | pills | 1 | 28756 | 27 | 0.560 | 51350.0 |
720 | 2024-02-25 17:59:30 | pills | 1 | 28756 | 27 | 0.486 | 59168.7 |
719 | 2024-01-25 22:22:53 | pills | 1 | 28756 | 27 | 0.533 | 53951.2 |
718 | 2024-01-22 12:52:53 | pills | 1 | 28756 | 27 | 0.440 | 65354.5 |
717 | 2024-01-02 19:58:46 | pills | 2 | 53800 | 265 | 1.750 | 30742.9 |
716 | 2023-12-26 17:00:28 | pills | 2 | 53800 | 265 | 1.406 | 38264.6 |
715 | 2023-12-18 04:11:51 | pills | 1 | 28756 | 27 | 0.530 | 54256.6 |
714 | 2023-11-29 11:13:18 | pills | 2 | 53800 | 265 | 1.516 | 35488.1 |
713 | 2023-11-26 18:41:10 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
712 | 2023-11-14 01:12:14 | pills | 1 | 28756 | 27 | 0.530 | 54256.6 |
711 | 2023-11-13 23:15:42 | pills | 1 | 28756 | 27 | 0.500 | 57512.0 |
710 | 2023-11-13 22:50:39 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
709 | 2023-10-30 04:53:04 | pills | 2 | 53800 | 265 | 1.390 | 38705.0 |
708 | 2023-10-26 04:46:15 | pills | 1 | 28756 | 27 | 0.530 | 54256.6 |
707 | 2023-10-25 22:54:39 | pills | 1 | 28756 | 27 | 0.440 | 65354.5 |
706 | 2023-10-24 08:23:02 | pills | 1 | 28756 | 27 | 0.873 | 32939.3 |
705 | 2023-10-22 02:06:56 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
704 | 2023-10-19 00:26:46 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
703 | 2023-10-13 04:56:16 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
702 | 2023-10-06 23:42:09 | pills | 1 | 28756 | 27 | 0.750 | 38341.3 |
701 | 2023-10-05 04:08:58 | pills | 1 | 28756 | 27 | 0.470 | 61183.0 |
700 | 2023-09-24 23:19:25 | pills | 1 | 28756 | 27 | 0.470 | 61183.0 |
699 | 2023-09-23 11:18:42 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
698 | 2023-09-21 18:31:03 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
697 | 2023-09-21 10:21:03 | pills | 1 | 28756 | 27 | 0.456 | 63061.4 |
696 | 2023-08-02 13:49:43 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
695 | 2023-06-01 08:55:54 | pills | 1 | 28756 | 27 | 0.440 | 65354.5 |
694 | 2023-05-02 04:26:41 | pills | 1 | 28756 | 27 | 1.000 | 28756.0 |
693 | 2023-02-22 18:36:52 | pills | 1 | 28756 | 27 | 0.440 | 65354.5 |
692 | 2023-02-16 09:37:28 | pills | 1 | 28756 | 27 | 0.423 | 67981.1 |
691 | 2022-12-21 18:15:07 | pills | 1 | 28756 | 27 | 0.420 | 68466.7 |
690 | 2022-10-26 12:07:47 | pills | 1 | 28756 | 27 | 0.516 | 55728.7 |
689 | 2022-09-06 06:56:07 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
688 | 2022-08-26 09:56:46 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
687 | 2022-08-15 02:16:29 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
686 | 2022-08-09 11:53:14 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
685 | 2022-07-10 11:07:39 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
684 | 2022-07-02 20:16:39 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
683 | 2022-06-29 06:15:34 | pills | 1 | 28756 | 27 | 0.440 | 65354.5 |
682 | 2022-06-15 22:10:05 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
681 | 2022-04-28 08:44:06 | pills | 1 | 28756 | 27 | 0.546 | 52666.7 |
680 | 2022-03-05 20:33:38 | pills | 1 | 28756 | 27 | 0.986 | 29164.3 |
679 | 2022-01-19 14:01:28 | pills | 1 | 28756 | 27 | 0.546 | 52666.7 |
678 | 2022-01-02 17:39:50 | pills | 1 | 28756 | 27 | 0.513 | 56054.6 |
677 | 2022-01-01 12:23:48 | pills | 1 | 28756 | 27 | 1.046 | 27491.4 |
676 | 2021-12-25 23:32:41 | pills | 1 | 28756 | 27 | 0.450 | 63902.2 |
675 | 2021-12-24 23:59:25 | pills | 1 | 28756 | 27 | 0.530 | 54256.6 |
674 | 2021-12-14 09:07:35 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
673 | 2021-12-13 23:17:58 | pills | 1 | 28756 | 27 | 0.546 | 52666.7 |
672 | 2021-12-13 11:07:07 | pills | 1 | 28756 | 27 | 1.093 | 26309.2 |
671 | 2021-12-13 00:02:12 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
670 | 2021-12-12 13:31:29 | pills | 1 | 28756 | 27 | 0.500 | 57512.0 |
669 | 2021-12-12 02:21:23 | pills | 1 | 28756 | 27 | 0.440 | 65354.5 |
668 | 2021-12-07 20:11:23 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
667 | 2021-12-07 12:55:50 | pills | 1 | 28756 | 27 | 0.466 | 61708.2 |
666 | 2021-12-07 00:33:08 | pills | 1 | 28756 | 27 | 0.533 | 53951.2 |
665 | 2021-12-06 16:42:48 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
664 | 2021-12-06 02:49:18 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
663 | 2021-12-05 18:03:54 | pills | 1 | 28756 | 27 | 0.530 | 54256.6 |
662 | 2021-12-05 10:28:41 | pills | 1 | 28756 | 27 | 0.500 | 57512.0 |
661 | 2021-12-05 03:01:36 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
660 | 2021-12-04 14:58:25 | pills | 1 | 28756 | 27 | 0.516 | 55728.7 |
659 | 2021-12-04 03:46:28 | pills | 1 | 28756 | 27 | 0.890 | 32310.1 |
658 | 2021-12-03 11:08:51 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
657 | 2021-12-03 01:26:34 | pills | 1 | 28756 | 27 | 1.046 | 27491.4 |
656 | 2021-12-02 18:24:13 | pills | 1 | 28756 | 27 | 0.533 | 53951.2 |
655 | 2021-11-28 16:01:13 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
654 | 2021-11-28 02:10:52 | pills | 1 | 28756 | 27 | 0.500 | 57512.0 |
653 | 2021-11-27 08:21:15 | pills | 1 | 28756 | 27 | 0.516 | 55728.7 |
652 | 2021-11-25 13:02:12 | pills | 1 | 28756 | 27 | 0.640 | 44931.3 |
651 | 2021-11-18 22:34:02 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
650 | 2021-11-18 10:36:52 | pills | 1 | 28756 | 27 | 0.533 | 53951.2 |
649 | 2021-11-18 03:34:11 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
648 | 2021-11-17 14:13:54 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
647 | 2021-11-17 08:54:42 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
646 | 2021-10-23 16:35:59 | pills | 1 | 28756 | 27 | 0.486 | 59168.7 |
645 | 2021-10-21 15:45:30 | pills | 1 | 28756 | 27 | 0.500 | 57512.0 |
644 | 2021-10-14 17:10:10 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
643 | 2021-10-13 20:23:59 | pills | 1 | 28756 | 27 | 1.030 | 27918.4 |
642 | 2021-10-12 22:46:17 | pills | 1 | 28756 | 27 | 0.513 | 56054.6 |
641 | 2021-10-12 12:56:28 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
640 | 2021-10-11 15:46:48 | pills | 1 | 28756 | 27 | 0.500 | 57512.0 |
639 | 2021-10-10 22:40:34 | pills | 1 | 28756 | 27 | 0.500 | 57512.0 |
638 | 2021-10-10 12:49:56 | pills | 1 | 28756 | 27 | 0.486 | 59168.7 |
637 | 2021-09-27 11:10:26 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
636 | 2021-09-26 20:42:56 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
635 | 2021-09-22 11:11:52 | pills | 1 | 28756 | 27 | 0.500 | 57512.0 |
634 | 2021-09-21 22:53:25 | pills | 1 | 28756 | 27 | 0.450 | 63902.2 |
633 | 2021-09-21 20:33:15 | pills | 1 | 28756 | 27 | 0.530 | 54256.6 |
632 | 2021-09-21 08:38:37 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
631 | 2021-09-20 21:47:08 | pills | 1 | 28756 | 27 | 0.546 | 52666.7 |
630 | 2021-09-20 13:39:31 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
629 | 2021-09-20 05:03:08 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
628 | 2021-09-19 11:33:08 | pills | 1 | 28756 | 27 | 0.500 | 57512.0 |
627 | 2021-09-19 06:08:40 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |
626 | 2021-09-18 19:16:53 | pills | 1 | 28756 | 27 | 0.483 | 59536.2 |
625 | 2021-09-18 15:53:13 | pills | 1 | 28756 | 27 | 0.453 | 63479.0 |
624 | 2021-09-18 12:22:44 | pills | 1 | 28756 | 27 | 0.436 | 65954.1 |