History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drug"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
728 | 2025-05-11 02:22:47 | drug | 2 | 29872 | 126 | 2.203 | 13559.7 |
727 | 2025-05-10 08:35:03 | drug | 2 | 29872 | 126 | 2.283 | 13084.5 |
726 | 2025-05-05 22:05:06 | drug | 1 | 13983 | 10 | 1.093 | 12793.2 |
725 | 2025-05-03 11:49:26 | drug | 2 | 29872 | 126 | 0.860 | 34734.9 |
724 | 2025-05-03 07:25:17 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
723 | 2025-04-30 07:17:36 | drug | 1 | 13983 | 10 | 0.266 | 52567.7 |
722 | 2025-04-27 14:54:14 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
721 | 2025-04-27 14:48:06 | drug | 1 | 13983 | 10 | 0.500 | 27966.0 |
720 | 2025-04-16 09:06:44 | drug | 1 | 13983 | 10 | 0.796 | 17566.6 |
719 | 2025-04-15 19:57:44 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
718 | 2025-04-06 14:49:08 | drug | 1 | 13983 | 10 | 0.953 | 14672.6 |
717 | 2025-04-06 02:28:37 | drug | 2 | 29872 | 126 | 6.250 | 4779.5 |
716 | 2025-04-04 12:07:57 | drug | 2 | 29872 | 126 | 3.873 | 7712.9 |
715 | 2025-04-03 14:20:01 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
714 | 2025-04-02 21:13:35 | drug | 1 | 13983 | 10 | 1.046 | 13368.1 |
713 | 2025-03-29 09:02:24 | drug | 1 | 13983 | 10 | 0.860 | 16259.3 |
712 | 2025-03-14 21:20:47 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
711 | 2025-03-13 07:48:07 | drug | 1 | 13983 | 10 | 0.656 | 21315.5 |
710 | 2025-03-06 11:59:52 | drug | 2 | 29872 | 126 | 2.000 | 14936.0 |
709 | 2025-03-06 11:59:35 | drug | 1 | 13983 | 10 | 1.890 | 7398.4 |
708 | 2025-02-26 06:08:40 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
707 | 2025-02-25 12:36:20 | drug | 2 | 29872 | 126 | 6.456 | 4627.0 |
706 | 2025-02-25 09:10:17 | drug | 2 | 29872 | 126 | 3.110 | 9605.1 |
705 | 2025-02-25 08:52:09 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
704 | 2025-02-25 04:37:41 | drug | 1 | 13983 | 10 | 0.313 | 44674.1 |
703 | 2025-02-11 04:18:07 | drug | 2 | 29872 | 126 | 3.373 | 8856.2 |
702 | 2025-02-10 01:40:07 | drug | 2 | 29872 | 126 | 0.860 | 34734.9 |
701 | 2025-02-04 13:12:03 | drug | 2 | 29872 | 126 | 4.000 | 7468.0 |
700 | 2025-02-04 10:31:03 | drug | 2 | 29872 | 126 | 2.876 | 10386.6 |
699 | 2025-02-04 10:30:00 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
698 | 2025-01-26 11:32:18 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
697 | 2025-01-25 20:52:58 | drug | 2 | 29872 | 126 | 2.140 | 13958.9 |
696 | 2025-01-25 20:06:34 | drug | 2 | 29872 | 126 | 4.220 | 7078.7 |
695 | 2025-01-25 20:06:00 | drug | 1 | 13983 | 10 | 1.000 | 13983.0 |
694 | 2025-01-05 09:46:09 | drug | 1 | 13983 | 10 | 1.420 | 9847.2 |
693 | 2024-12-27 08:08:24 | drug | 1 | 13983 | 10 | 0.953 | 14672.6 |
692 | 2024-12-26 20:31:41 | drug | 1 | 13983 | 10 | 1.406 | 9945.2 |
691 | 2024-12-26 15:17:48 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
690 | 2024-12-12 14:18:41 | drug | 1 | 13983 | 10 | 0.936 | 14939.1 |
689 | 2024-12-06 07:38:07 | drug | 2 | 29872 | 126 | 6.236 | 4790.3 |
688 | 2024-12-06 07:14:19 | drug | 1 | 13983 | 10 | 0.206 | 67878.6 |
687 | 2024-11-27 11:27:38 | drug | 2 | 29872 | 126 | 5.236 | 5705.1 |
686 | 2024-11-27 05:17:36 | drug | 2 | 29872 | 126 | 4.343 | 6878.2 |
685 | 2024-11-27 03:52:32 | drug | 2 | 29872 | 126 | 2.860 | 10444.8 |
684 | 2024-11-27 03:33:48 | drug | 1 | 13983 | 10 | 0.890 | 15711.2 |
683 | 2024-11-26 12:08:58 | drug | 1 | 13983 | 10 | 1.096 | 12758.2 |
682 | 2024-11-06 07:14:02 | drug | 1 | 13983 | 10 | 0.673 | 20777.1 |
681 | 2024-10-29 00:22:49 | drug | 2 | 29872 | 126 | 2.250 | 13276.4 |
680 | 2024-10-28 08:38:05 | drug | 2 | 29872 | 126 | 3.266 | 9146.4 |
679 | 2024-10-28 03:36:36 | drug | 2 | 29872 | 126 | 5.783 | 5165.5 |
678 | 2024-10-28 01:50:41 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
677 | 2024-10-27 08:03:41 | drug | 1 | 13983 | 10 | 1.283 | 10898.7 |
676 | 2024-10-27 06:05:38 | drug | 1 | 13983 | 10 | 1.346 | 10388.6 |
675 | 2024-10-26 16:23:50 | drug | 1 | 13983 | 10 | 0.606 | 23074.3 |
674 | 2024-10-26 15:24:05 | drug | 1 | 13983 | 10 | 0.500 | 27966.0 |
673 | 2024-10-21 15:46:36 | drug | 1 | 13983 | 10 | 1.313 | 10649.7 |
672 | 2024-10-21 15:07:32 | drug | 1 | 13983 | 10 | 0.936 | 14939.1 |
671 | 2024-10-20 13:26:55 | drug | 1 | 13983 | 10 | 0.673 | 20777.1 |
670 | 2024-10-07 05:09:02 | drug | 1 | 13983 | 10 | 2.530 | 5526.9 |
669 | 2024-09-28 02:12:56 | drug | 2 | 29872 | 126 | 2.906 | 10279.4 |
668 | 2024-09-28 00:02:31 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
667 | 2024-09-27 07:02:03 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
666 | 2024-09-27 02:41:42 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
665 | 2024-09-06 23:14:47 | drug | 1 | 13983 | 10 | 1.640 | 8526.2 |
664 | 2024-08-30 02:41:18 | drug | 1 | 13983 | 10 | 0.890 | 15711.2 |
663 | 2024-08-29 07:45:07 | drug | 2 | 29872 | 126 | 3.046 | 9807.0 |
662 | 2024-08-29 01:46:07 | drug | 2 | 29872 | 126 | 6.250 | 4779.5 |
661 | 2024-08-28 23:28:00 | drug | 2 | 29872 | 126 | 6.063 | 4926.9 |
660 | 2024-08-28 22:31:26 | drug | 1 | 13983 | 10 | 0.236 | 59250.0 |
659 | 2024-08-27 18:53:51 | drug | 1 | 13983 | 10 | 0.266 | 52567.7 |
658 | 2024-08-26 16:57:34 | drug | 1 | 13983 | 10 | 1.983 | 7051.4 |
657 | 2024-08-18 09:27:39 | drug | 1 | 13983 | 10 | 2.403 | 5819.0 |
656 | 2024-08-12 12:03:04 | drug | 1 | 13983 | 10 | 1.076 | 12995.4 |
655 | 2024-08-07 22:53:09 | drug | 1 | 13983 | 10 | 0.830 | 16847.0 |
654 | 2024-08-03 15:04:38 | drug | 2 | 29872 | 126 | 1.796 | 16632.5 |
653 | 2024-08-03 08:15:03 | drug | 2 | 29872 | 126 | 1.466 | 20376.5 |
652 | 2024-08-02 05:01:42 | drug | 1 | 13983 | 10 | 1.686 | 8293.6 |
651 | 2024-07-30 01:36:20 | drug | 2 | 29872 | 126 | 2.843 | 10507.2 |
650 | 2024-07-29 21:39:15 | drug | 2 | 29872 | 126 | 4.126 | 7239.9 |
649 | 2024-07-29 21:21:51 | drug | 1 | 13983 | 10 | 0.466 | 30006.4 |
648 | 2024-07-29 10:43:25 | drug | 2 | 29872 | 126 | 3.920 | 7620.4 |
647 | 2024-07-28 08:26:03 | drug | 1 | 13983 | 10 | 0.736 | 18998.6 |
646 | 2024-07-27 15:21:28 | drug | 1 | 13983 | 10 | 1.203 | 11623.4 |
645 | 2024-07-19 01:31:07 | drug | 1 | 13983 | 10 | 0.560 | 24969.6 |
644 | 2024-07-14 07:12:22 | drug | 2 | 29872 | 126 | 1.936 | 15429.8 |
643 | 2024-07-08 17:33:41 | drug | 1 | 13983 | 10 | 0.953 | 14672.6 |
642 | 2024-07-04 18:50:34 | drug | 1 | 13983 | 10 | 0.656 | 21315.5 |
641 | 2024-07-03 04:54:51 | drug | 1 | 13983 | 10 | 1.173 | 11920.7 |
640 | 2024-07-02 06:04:14 | drug | 1 | 13983 | 10 | 0.610 | 22923.0 |
639 | 2024-06-29 19:22:05 | drug | 1 | 13983 | 10 | 0.936 | 14939.1 |
638 | 2024-06-29 18:44:54 | drug | 2 | 29872 | 126 | 3.360 | 8890.5 |
637 | 2024-06-29 17:58:00 | drug | 1 | 13983 | 10 | 0.766 | 18254.6 |
636 | 2024-06-29 16:30:26 | drug | 2 | 29872 | 126 | 5.440 | 5491.2 |
635 | 2024-06-29 05:46:26 | drug | 2 | 29872 | 126 | 1.860 | 16060.2 |
634 | 2024-06-28 03:39:36 | drug | 1 | 13983 | 10 | 0.733 | 19076.4 |
633 | 2024-06-27 13:54:32 | drug | 1 | 13983 | 10 | 1.376 | 10162.1 |
632 | 2024-06-27 02:54:42 | drug | 1 | 13983 | 10 | 0.923 | 15149.5 |
631 | 2024-06-16 00:55:23 | drug | 1 | 13983 | 10 | 1.140 | 12265.8 |
630 | 2024-06-04 03:38:32 | drug | 1 | 13983 | 10 | 0.563 | 24836.6 |
629 | 2024-06-03 18:45:25 | drug | 1 | 13983 | 10 | 1.030 | 13575.7 |