History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shoots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
763 | 2024-04-27 19:29:40 | shoots | 1 | 48755 | 15 | 0.860 | 56691.9 |
762 | 2024-04-27 14:21:18 | shoots | 1 | 48755 | 15 | 1.093 | 44606.6 |
761 | 2024-04-25 18:29:18 | shoots | 1 | 48755 | 15 | 0.966 | 50471.0 |
760 | 2024-04-24 07:27:54 | shoots | 1 | 48755 | 15 | 1.280 | 38089.8 |
759 | 2024-04-03 04:45:42 | shoots | 1 | 48755 | 15 | 1.000 | 48755.0 |
758 | 2024-04-02 10:17:12 | shoots | 1 | 48755 | 15 | 0.763 | 63899.1 |
757 | 2024-03-31 17:55:06 | shoots | 1 | 48755 | 15 | 1.200 | 40629.2 |
756 | 2024-03-04 21:00:37 | shoots | 2 | 82551 | 135 | 3.280 | 25168.0 |
755 | 2024-03-04 14:25:37 | shoots | 1 | 48755 | 15 | 2.923 | 16679.8 |
754 | 2024-03-04 14:17:00 | shoots | 2 | 82551 | 135 | 5.533 | 14919.8 |
753 | 2024-03-04 02:13:20 | shoots | 2 | 82551 | 135 | 2.450 | 33694.3 |
752 | 2024-03-04 02:13:20 | shoots | 1 | 48755 | 15 | 0.856 | 56956.8 |
751 | 2024-02-26 02:02:29 | shoots | 2 | 82551 | 135 | 8.626 | 9570.0 |
750 | 2024-02-25 22:19:16 | shoots | 1 | 48755 | 15 | 2.156 | 22613.6 |
749 | 2024-01-15 22:00:42 | shoots | 1 | 48755 | 15 | 0.893 | 54596.9 |
748 | 2023-12-29 07:19:21 | shoots | 1 | 48755 | 15 | 0.783 | 62266.9 |
747 | 2023-12-12 08:35:07 | shoots | 2 | 82551 | 135 | 2.220 | 37185.1 |
746 | 2023-12-09 02:47:32 | shoots | 2 | 82551 | 135 | 2.406 | 34310.5 |
745 | 2023-12-07 05:32:26 | shoots | 1 | 48755 | 15 | 0.876 | 55656.4 |
744 | 2023-11-23 23:58:55 | shoots | 2 | 82551 | 135 | 2.250 | 36689.3 |
743 | 2023-11-19 15:49:21 | shoots | 1 | 48755 | 15 | 0.890 | 54780.9 |
742 | 2023-11-18 12:24:10 | shoots | 1 | 48755 | 15 | 0.970 | 50262.9 |
741 | 2023-11-11 16:48:14 | shoots | 1 | 48755 | 15 | 0.736 | 66243.2 |
740 | 2023-11-10 16:46:06 | shoots | 1 | 48755 | 15 | 0.876 | 55656.4 |
739 | 2023-11-09 09:12:27 | shoots | 1 | 48755 | 15 | 0.860 | 56691.9 |
738 | 2023-10-28 14:47:15 | shoots | 1 | 48755 | 15 | 0.860 | 56691.9 |
737 | 2023-10-28 04:25:24 | shoots | 1 | 48755 | 15 | 1.813 | 26891.9 |
736 | 2023-10-25 15:59:40 | shoots | 1 | 48755 | 15 | 0.830 | 58741.0 |
735 | 2023-10-13 13:35:43 | shoots | 1 | 48755 | 15 | 0.876 | 55656.4 |
734 | 2023-10-09 07:04:56 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
733 | 2023-09-24 01:20:37 | shoots | 1 | 48755 | 15 | 0.876 | 55656.4 |
732 | 2023-09-22 06:44:58 | shoots | 1 | 48755 | 15 | 0.843 | 57835.1 |
731 | 2023-09-02 20:05:56 | shoots | 1 | 48755 | 15 | 0.800 | 60943.8 |
730 | 2023-08-31 08:55:02 | shoots | 1 | 48755 | 15 | 0.766 | 63648.8 |
729 | 2023-08-09 21:16:10 | shoots | 1 | 48755 | 15 | 0.813 | 59969.2 |
728 | 2023-08-08 22:07:16 | shoots | 1 | 48755 | 15 | 0.843 | 57835.1 |
727 | 2023-08-04 12:01:26 | shoots | 1 | 48755 | 15 | 0.843 | 57835.1 |
726 | 2023-07-08 06:42:39 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
725 | 2023-06-05 12:28:51 | shoots | 1 | 48755 | 15 | 0.826 | 59025.4 |
724 | 2023-05-23 12:20:29 | shoots | 1 | 48755 | 15 | 0.763 | 63899.1 |
723 | 2023-05-20 11:09:03 | shoots | 1 | 48755 | 15 | 0.780 | 62506.4 |
722 | 2023-05-15 11:36:34 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
721 | 2023-04-03 06:34:13 | shoots | 1 | 48755 | 15 | 0.856 | 56956.8 |
720 | 2023-03-27 13:33:30 | shoots | 1 | 48755 | 15 | 1.750 | 27860.0 |
719 | 2023-02-10 01:27:27 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
718 | 2023-01-31 05:33:47 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
717 | 2023-01-29 21:53:52 | shoots | 1 | 48755 | 15 | 0.766 | 63648.8 |
716 | 2023-01-27 16:52:29 | shoots | 1 | 48755 | 15 | 0.830 | 58741.0 |
715 | 2023-01-10 22:11:01 | shoots | 1 | 48755 | 15 | 0.733 | 66514.3 |
714 | 2022-12-22 14:09:02 | shoots | 1 | 48755 | 15 | 0.766 | 63648.8 |
713 | 2022-12-15 03:26:27 | shoots | 1 | 48755 | 15 | 0.843 | 57835.1 |
712 | 2022-11-05 16:02:40 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
711 | 2022-10-30 22:29:18 | shoots | 1 | 48755 | 15 | 0.843 | 57835.1 |
710 | 2022-10-29 20:51:31 | shoots | 1 | 48755 | 15 | 0.876 | 55656.4 |
709 | 2022-10-28 21:32:18 | shoots | 1 | 48755 | 15 | 0.763 | 63899.1 |
708 | 2022-10-28 16:28:12 | shoots | 1 | 48755 | 15 | 0.876 | 55656.4 |
707 | 2022-10-27 20:29:43 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
706 | 2022-10-25 18:57:12 | shoots | 1 | 48755 | 15 | 0.766 | 63648.8 |
705 | 2022-10-24 23:29:58 | shoots | 1 | 48755 | 15 | 0.860 | 56691.9 |
704 | 2022-10-23 22:41:34 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
703 | 2022-10-22 20:33:31 | shoots | 1 | 48755 | 15 | 0.830 | 58741.0 |
702 | 2022-10-19 23:09:04 | shoots | 1 | 48755 | 15 | 0.796 | 61250.0 |
701 | 2022-10-17 13:42:40 | shoots | 1 | 48755 | 15 | 0.830 | 58741.0 |
700 | 2022-10-13 22:01:24 | shoots | 1 | 48755 | 15 | 0.766 | 63648.8 |
699 | 2022-10-11 23:28:47 | shoots | 1 | 48755 | 15 | 0.783 | 62266.9 |
698 | 2022-10-09 17:40:59 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
697 | 2022-10-08 23:41:13 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
696 | 2022-09-21 20:59:34 | shoots | 1 | 48755 | 15 | 0.733 | 66514.3 |
695 | 2022-09-14 20:42:54 | shoots | 1 | 48755 | 15 | 0.766 | 63648.8 |
694 | 2022-09-09 00:38:35 | shoots | 1 | 48755 | 15 | 0.763 | 63899.1 |
693 | 2022-09-08 08:30:30 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
692 | 2022-09-04 06:01:01 | shoots | 1 | 48755 | 15 | 0.766 | 63648.8 |
691 | 2022-09-01 18:42:24 | shoots | 1 | 48755 | 15 | 0.813 | 59969.2 |
690 | 2022-08-06 14:59:46 | shoots | 1 | 48755 | 15 | 0.783 | 62266.9 |
689 | 2022-07-29 06:10:25 | shoots | 1 | 48755 | 15 | 0.860 | 56691.9 |
688 | 2022-07-26 02:28:36 | shoots | 1 | 48755 | 15 | 0.906 | 53813.5 |
687 | 2022-06-26 21:37:11 | shoots | 1 | 48755 | 15 | 0.766 | 63648.8 |
686 | 2022-06-08 06:14:10 | shoots | 1 | 48755 | 15 | 0.843 | 57835.1 |
685 | 2022-06-06 17:27:21 | shoots | 1 | 48755 | 15 | 0.936 | 52088.7 |
684 | 2022-05-24 05:11:34 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
683 | 2022-04-20 00:07:27 | shoots | 1 | 48755 | 15 | 0.970 | 50262.9 |
682 | 2022-04-05 07:38:49 | shoots | 1 | 48755 | 15 | 0.766 | 63648.8 |
681 | 2022-03-10 12:25:01 | shoots | 1 | 48755 | 15 | 1.123 | 43415.0 |
680 | 2022-02-18 03:30:38 | shoots | 1 | 48755 | 15 | 0.860 | 56691.9 |
679 | 2021-12-09 10:59:24 | shoots | 1 | 48755 | 15 | 0.843 | 57835.1 |
678 | 2021-11-26 18:54:16 | shoots | 1 | 48755 | 15 | 0.860 | 56691.9 |
677 | 2021-11-26 09:09:42 | shoots | 1 | 48755 | 15 | 0.843 | 57835.1 |
676 | 2021-10-24 23:09:41 | shoots | 1 | 48755 | 15 | 0.876 | 55656.4 |
675 | 2021-10-22 22:38:38 | shoots | 1 | 48755 | 15 | 0.876 | 55656.4 |
674 | 2021-10-22 13:06:02 | shoots | 1 | 48755 | 15 | 0.873 | 55847.7 |
673 | 2021-09-08 16:02:02 | shoots | 1 | 48755 | 15 | 0.860 | 56691.9 |
672 | 2021-08-24 06:04:44 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
671 | 2021-08-20 11:46:48 | shoots | 1 | 48755 | 15 | 1.093 | 44606.6 |
670 | 2021-07-28 19:59:40 | shoots | 1 | 48755 | 15 | 0.796 | 61250.0 |
669 | 2021-07-28 02:13:16 | shoots | 1 | 48755 | 15 | 0.813 | 59969.2 |
668 | 2021-07-27 11:14:22 | shoots | 1 | 48755 | 15 | 0.763 | 63899.1 |
667 | 2021-07-26 00:48:13 | shoots | 1 | 48755 | 15 | 0.750 | 65006.7 |
666 | 2021-07-24 02:10:19 | shoots | 1 | 48755 | 15 | 0.860 | 56691.9 |
665 | 2021-07-23 05:08:01 | shoots | 1 | 48755 | 15 | 0.890 | 54780.9 |
664 | 2021-07-22 09:59:50 | shoots | 1 | 48755 | 15 | 0.893 | 54596.9 |