History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"picot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
834 | 2024-04-24 23:46:00 | picot | 1 | 28756 | 6 | 0.500 | 57512.0 |
833 | 2024-04-22 07:04:42 | picot | 1 | 28756 | 6 | 1.156 | 24875.4 |
832 | 2024-04-04 19:56:37 | picot | 2 | 53800 | 59 | 2.623 | 20510.9 |
831 | 2024-04-04 16:03:16 | picot | 2 | 53800 | 59 | 1.830 | 29398.9 |
830 | 2024-04-04 16:03:16 | picot | 1 | 28756 | 6 | 0.560 | 51350.0 |
829 | 2024-04-04 16:02:44 | picot | 3 | 83667 | 880 | 5.080 | 16469.9 |
828 | 2024-04-03 13:12:29 | picot | 3 | 83667 | 880 | 10.376 | 8063.5 |
827 | 2024-04-03 13:12:26 | picot | 2 | 53800 | 59 | 3.890 | 13830.3 |
826 | 2024-04-03 13:12:08 | picot | 1 | 28756 | 6 | 1.263 | 22768.0 |
825 | 2024-03-31 15:03:21 | picot | 1 | 28756 | 6 | 1.000 | 28756.0 |
824 | 2024-03-27 04:58:15 | picot | 1 | 28756 | 6 | 0.466 | 61708.2 |
823 | 2024-03-04 07:48:24 | picot | 3 | 83667 | 880 | 4.126 | 20278.0 |
822 | 2024-03-04 07:48:25 | picot | 2 | 53800 | 59 | 1.670 | 32215.6 |
821 | 2024-03-04 07:48:12 | picot | 1 | 28756 | 6 | 0.533 | 53951.2 |
820 | 2024-03-01 11:34:31 | picot | 1 | 28756 | 6 | 0.483 | 59536.2 |
819 | 2024-02-25 19:08:07 | picot | 1 | 28756 | 6 | 0.470 | 61183.0 |
818 | 2024-02-03 04:12:39 | picot | 1 | 28756 | 6 | 0.500 | 57512.0 |
817 | 2024-01-28 21:35:59 | picot | 1 | 28756 | 6 | 0.436 | 65954.1 |
816 | 2024-01-25 22:58:57 | picot | 1 | 28756 | 6 | 0.500 | 57512.0 |
815 | 2024-01-13 11:43:43 | picot | 3 | 83667 | 880 | 3.466 | 24139.4 |
814 | 2024-01-02 20:44:57 | picot | 1 | 28756 | 6 | 0.516 | 55728.7 |
813 | 2023-12-27 15:29:19 | picot | 3 | 83667 | 880 | 3.623 | 23093.3 |
812 | 2023-12-23 12:54:14 | picot | 2 | 53800 | 59 | 1.466 | 36698.5 |
811 | 2023-12-20 16:19:06 | picot | 3 | 83667 | 880 | 4.126 | 20278.0 |
810 | 2023-12-20 06:27:01 | picot | 3 | 83667 | 880 | 4.016 | 20833.4 |
809 | 2023-12-20 06:27:03 | picot | 2 | 53800 | 59 | 1.720 | 31279.1 |
808 | 2023-12-20 00:10:36 | picot | 1 | 28756 | 6 | 0.516 | 55728.7 |
807 | 2023-12-16 01:07:53 | picot | 3 | 83667 | 880 | 3.716 | 22515.3 |
806 | 2023-11-18 01:49:44 | picot | 1 | 28756 | 6 | 0.513 | 56054.6 |
805 | 2023-11-12 12:44:33 | picot | 3 | 83667 | 880 | 3.376 | 24782.9 |
804 | 2023-11-12 12:44:35 | picot | 2 | 53800 | 59 | 1.563 | 34421.0 |
803 | 2023-11-12 02:52:06 | picot | 1 | 28756 | 6 | 0.436 | 65954.1 |
802 | 2023-11-02 08:01:19 | picot | 2 | 53800 | 59 | 1.483 | 36277.8 |
801 | 2023-11-02 08:01:16 | picot | 3 | 83667 | 880 | 3.406 | 24564.6 |
800 | 2023-10-26 02:10:21 | picot | 1 | 28756 | 6 | 0.513 | 56054.6 |
799 | 2023-10-24 11:09:23 | picot | 1 | 28756 | 6 | 0.500 | 57512.0 |
798 | 2023-10-21 10:32:03 | picot | 1 | 28756 | 6 | 0.483 | 59536.2 |
797 | 2023-10-18 21:06:39 | picot | 1 | 28756 | 6 | 0.436 | 65954.1 |
796 | 2023-10-13 14:51:51 | picot | 1 | 28756 | 6 | 0.470 | 61183.0 |
795 | 2023-10-05 05:14:19 | picot | 1 | 28756 | 6 | 0.440 | 65354.5 |
794 | 2023-09-30 08:49:53 | picot | 3 | 83667 | 880 | 4.780 | 17503.6 |
793 | 2023-09-30 08:49:54 | picot | 2 | 53800 | 59 | 2.733 | 19685.3 |
792 | 2023-09-26 18:16:11 | picot | 3 | 83667 | 880 | 3.453 | 24230.2 |
791 | 2023-09-26 18:16:09 | picot | 2 | 53800 | 59 | 1.436 | 37465.2 |
790 | 2023-09-23 22:29:21 | picot | 1 | 28756 | 6 | 0.483 | 59536.2 |
789 | 2023-09-12 18:36:40 | picot | 1 | 28756 | 6 | 0.436 | 65954.1 |
788 | 2023-09-03 01:27:14 | picot | 1 | 28756 | 6 | 0.453 | 63479.0 |
787 | 2023-08-18 19:50:49 | picot | 1 | 28756 | 6 | 0.483 | 59536.2 |
786 | 2023-08-09 09:24:26 | picot | 3 | 83667 | 880 | 3.750 | 22311.2 |
785 | 2023-08-09 08:08:44 | picot | 3 | 83667 | 880 | 3.343 | 25027.5 |
784 | 2023-05-24 00:56:00 | picot | 1 | 28756 | 6 | 0.423 | 67981.1 |
783 | 2023-05-16 18:11:43 | picot | 1 | 28756 | 6 | 0.483 | 59536.2 |
782 | 2023-05-04 08:39:01 | picot | 3 | 83667 | 880 | 3.783 | 22116.6 |
781 | 2023-05-01 19:08:55 | picot | 3 | 83667 | 880 | 3.876 | 21585.9 |
780 | 2023-04-30 12:35:59 | picot | 3 | 83667 | 880 | 3.876 | 21585.9 |
779 | 2023-04-29 19:56:53 | picot | 3 | 83667 | 880 | 3.920 | 21343.6 |
778 | 2023-04-28 10:21:37 | picot | 3 | 83667 | 880 | 3.810 | 21959.8 |
777 | 2023-04-27 08:55:24 | picot | 3 | 83667 | 880 | 3.733 | 22412.8 |
776 | 2023-04-25 14:22:11 | picot | 3 | 83667 | 880 | 3.690 | 22674.0 |
775 | 2023-04-24 21:00:14 | picot | 3 | 83667 | 880 | 4.030 | 20761.0 |
774 | 2023-03-12 11:15:10 | picot | 1 | 28756 | 6 | 0.440 | 65354.5 |
773 | 2023-02-11 02:40:08 | picot | 1 | 28756 | 6 | 0.436 | 65954.1 |
772 | 2023-01-01 18:58:00 | picot | 1 | 28756 | 6 | 0.436 | 65954.1 |
771 | 2022-11-27 04:27:01 | picot | 3 | 83667 | 880 | 3.203 | 26121.4 |
770 | 2022-10-30 06:14:31 | picot | 3 | 83667 | 880 | 3.236 | 25855.1 |
769 | 2022-10-24 15:05:43 | picot | 1 | 28756 | 6 | 0.470 | 61183.0 |
768 | 2022-10-21 00:49:59 | picot | 1 | 28756 | 6 | 0.453 | 63479.0 |
767 | 2022-10-11 00:44:57 | picot | 3 | 83667 | 880 | 3.326 | 25155.4 |
766 | 2022-09-21 05:59:28 | picot | 1 | 28756 | 6 | 0.436 | 65954.1 |
765 | 2022-09-12 15:14:21 | picot | 3 | 83667 | 880 | 3.453 | 24230.2 |
764 | 2022-09-06 07:10:55 | picot | 3 | 83667 | 880 | 3.686 | 22698.6 |
763 | 2022-07-09 14:12:52 | picot | 1 | 28756 | 6 | 0.436 | 65954.1 |
762 | 2022-06-13 12:29:02 | picot | 1 | 28756 | 6 | 0.516 | 55728.7 |
761 | 2022-05-02 06:52:50 | picot | 1 | 28756 | 6 | 0.440 | 65354.5 |
760 | 2022-03-24 11:14:07 | picot | 1 | 28756 | 6 | 0.530 | 54256.6 |
759 | 2022-01-23 10:13:45 | picot | 1 | 28756 | 6 | 0.513 | 56054.6 |
758 | 2022-01-21 07:18:56 | picot | 1 | 28756 | 6 | 0.483 | 59536.2 |
757 | 2021-12-13 15:00:48 | picot | 1 | 28756 | 6 | 0.453 | 63479.0 |
756 | 2021-11-10 15:56:52 | picot | 1 | 28756 | 6 | 0.533 | 53951.2 |
755 | 2021-11-06 13:56:07 | picot | 1 | 28756 | 6 | 0.500 | 57512.0 |
754 | 2021-09-09 14:07:23 | picot | 1 | 28756 | 6 | 0.453 | 63479.0 |
753 | 2021-08-15 10:43:20 | picot | 3 | 83667 | 880 | 3.640 | 22985.4 |
752 | 2021-08-06 18:02:18 | picot | 3 | 83667 | 880 | 3.453 | 24230.2 |
751 | 2021-07-03 15:19:00 | picot | 1 | 28756 | 6 | 0.483 | 59536.2 |
750 | 2021-07-01 05:44:30 | picot | 1 | 28756 | 6 | 0.533 | 53951.2 |
749 | 2021-06-30 15:31:04 | picot | 3 | 83667 | 880 | 4.000 | 20916.8 |
748 | 2021-06-26 15:52:34 | picot | 3 | 83667 | 880 | 3.796 | 22040.8 |
747 | 2021-06-22 00:10:48 | picot | 3 | 83667 | 880 | 3.580 | 23370.7 |
746 | 2021-06-20 13:18:25 | picot | 3 | 83667 | 880 | 3.906 | 21420.1 |
745 | 2021-06-08 14:54:47 | picot | 1 | 28756 | 6 | 0.486 | 59168.7 |
744 | 2021-06-08 13:50:44 | picot | 3 | 83667 | 880 | 3.220 | 25983.5 |
743 | 2021-06-07 16:28:31 | picot | 3 | 83667 | 880 | 3.220 | 25983.5 |
742 | 2021-06-03 17:25:09 | picot | 3 | 83667 | 880 | 3.656 | 22884.8 |
741 | 2021-06-03 17:12:54 | picot | 3 | 83667 | 880 | 3.813 | 21942.6 |
740 | 2021-06-02 22:08:21 | picot | 3 | 83667 | 880 | 4.313 | 19398.8 |
739 | 2021-06-02 07:15:34 | picot | 3 | 83667 | 880 | 3.263 | 25641.1 |
738 | 2021-06-01 16:01:57 | picot | 3 | 83667 | 880 | 3.796 | 22040.8 |
737 | 2021-05-26 03:27:24 | picot | 3 | 83667 | 880 | 3.876 | 21585.9 |
736 | 2021-05-25 03:23:24 | picot | 3 | 83667 | 880 | 5.030 | 16633.6 |
735 | 2021-05-24 03:21:54 | picot | 3 | 83667 | 880 | 3.783 | 22116.6 |