History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trump"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
812 | 2024-04-19 13:35:58 | trump | 1 | 28756 | 10 | 0.626 | 45936.1 |
811 | 2024-04-03 06:17:19 | trump | 1 | 28756 | 10 | 1.220 | 23570.5 |
810 | 2024-03-31 07:19:00 | trump | 1 | 28756 | 10 | 0.483 | 59536.2 |
809 | 2024-03-28 18:39:23 | trump | 1 | 28756 | 10 | 1.686 | 17055.8 |
808 | 2024-03-25 06:37:23 | trump | 2 | 53800 | 90 | 2.330 | 23090.1 |
807 | 2024-03-25 06:36:55 | trump | 3 | 83667 | 712 | 4.186 | 19987.3 |
806 | 2024-03-23 01:07:29 | trump | 3 | 83667 | 712 | 4.736 | 17666.2 |
805 | 2024-03-05 18:24:40 | trump | 3 | 83667 | 712 | 10.360 | 8076.0 |
804 | 2024-03-04 16:39:55 | trump | 3 | 83667 | 712 | 12.016 | 6963.0 |
803 | 2024-03-04 16:39:56 | trump | 2 | 53800 | 90 | 5.686 | 9461.8 |
802 | 2024-03-04 16:19:09 | trump | 2 | 53800 | 90 | 5.013 | 10732.1 |
801 | 2024-03-04 16:19:11 | trump | 1 | 28756 | 10 | 0.593 | 48492.4 |
800 | 2024-03-04 16:18:38 | trump | 3 | 83667 | 712 | 4.280 | 19548.4 |
799 | 2024-03-03 23:34:21 | trump | 3 | 83667 | 712 | 13.876 | 6029.6 |
798 | 2024-03-03 23:34:22 | trump | 2 | 53800 | 90 | 5.593 | 9619.2 |
797 | 2024-03-03 22:13:08 | trump | 1 | 28756 | 10 | 0.500 | 57512.0 |
796 | 2024-03-01 04:34:16 | trump | 1 | 28756 | 10 | 1.063 | 27051.7 |
795 | 2024-02-26 19:27:10 | trump | 1 | 28756 | 10 | 1.110 | 25906.3 |
794 | 2024-02-11 22:59:05 | trump | 1 | 28756 | 10 | 0.516 | 55728.7 |
793 | 2024-02-02 19:02:03 | trump | 1 | 28756 | 10 | 0.453 | 63479.0 |
792 | 2024-01-29 02:16:35 | trump | 1 | 28756 | 10 | 0.483 | 59536.2 |
791 | 2024-01-17 20:10:49 | trump | 2 | 53800 | 90 | 1.656 | 32487.9 |
790 | 2024-01-17 17:37:41 | trump | 3 | 83667 | 712 | 3.296 | 25384.4 |
789 | 2024-01-15 04:44:07 | trump | 2 | 53800 | 90 | 1.466 | 36698.5 |
788 | 2024-01-12 14:19:06 | trump | 1 | 28756 | 10 | 0.483 | 59536.2 |
787 | 2024-01-10 17:29:34 | trump | 3 | 83667 | 712 | 3.890 | 21508.2 |
786 | 2024-01-01 20:33:24 | trump | 1 | 28756 | 10 | 0.486 | 59168.7 |
785 | 2023-12-30 22:48:16 | trump | 3 | 83667 | 712 | 4.030 | 20761.0 |
784 | 2023-12-30 22:48:18 | trump | 2 | 53800 | 90 | 1.656 | 32487.9 |
783 | 2023-12-01 16:50:04 | trump | 3 | 83667 | 712 | 3.373 | 24804.9 |
782 | 2023-11-30 20:35:28 | trump | 1 | 28756 | 10 | 0.470 | 61183.0 |
781 | 2023-11-18 23:09:41 | trump | 1 | 28756 | 10 | 0.483 | 59536.2 |
780 | 2023-11-17 10:16:01 | trump | 3 | 83667 | 712 | 3.673 | 22778.9 |
779 | 2023-11-13 05:57:10 | trump | 1 | 28756 | 10 | 0.436 | 65954.1 |
778 | 2023-11-10 16:05:09 | trump | 1 | 28756 | 10 | 0.483 | 59536.2 |
777 | 2023-11-04 03:34:32 | trump | 1 | 28756 | 10 | 0.436 | 65954.1 |
776 | 2023-11-02 07:33:06 | trump | 3 | 83667 | 712 | 3.766 | 22216.4 |
775 | 2023-11-02 07:33:04 | trump | 2 | 53800 | 90 | 1.733 | 31044.4 |
774 | 2023-11-02 06:26:34 | trump | 1 | 28756 | 10 | 0.436 | 65954.1 |
773 | 2023-10-23 19:00:02 | trump | 2 | 53800 | 90 | 1.390 | 38705.0 |
772 | 2023-10-21 09:40:57 | trump | 1 | 28756 | 10 | 0.673 | 42728.1 |
771 | 2023-10-19 22:37:08 | trump | 1 | 28756 | 10 | 0.513 | 56054.6 |
770 | 2023-10-19 21:33:20 | trump | 1 | 28756 | 10 | 0.500 | 57512.0 |
769 | 2023-10-13 09:52:24 | trump | 1 | 28756 | 10 | 0.483 | 59536.2 |
768 | 2023-10-05 01:31:26 | trump | 1 | 28756 | 10 | 0.516 | 55728.7 |
767 | 2023-09-24 01:31:48 | trump | 1 | 28756 | 10 | 0.436 | 65954.1 |
766 | 2023-09-14 21:39:56 | trump | 1 | 28756 | 10 | 0.546 | 52666.7 |
765 | 2023-09-13 14:06:48 | trump | 1 | 28756 | 10 | 0.483 | 59536.2 |
764 | 2023-09-09 14:11:49 | trump | 1 | 28756 | 10 | 0.453 | 63479.0 |
763 | 2023-08-30 12:01:14 | trump | 3 | 83667 | 712 | 3.530 | 23701.7 |
762 | 2023-08-03 02:15:29 | trump | 2 | 53800 | 90 | 1.373 | 39184.3 |
761 | 2023-07-01 18:59:24 | trump | 1 | 28756 | 10 | 0.436 | 65954.1 |
760 | 2023-05-16 05:57:11 | trump | 3 | 83667 | 712 | 3.250 | 25743.7 |
759 | 2023-05-13 07:36:45 | trump | 1 | 28756 | 10 | 0.453 | 63479.0 |
758 | 2023-04-13 02:16:25 | trump | 2 | 53800 | 90 | 1.453 | 37026.8 |
757 | 2023-04-08 04:37:45 | trump | 1 | 28756 | 10 | 0.436 | 65954.1 |
756 | 2023-03-01 08:07:37 | trump | 3 | 83667 | 712 | 3.736 | 22394.8 |
755 | 2023-02-22 11:11:18 | trump | 3 | 83667 | 712 | 3.440 | 24321.8 |
754 | 2023-01-28 04:13:03 | trump | 1 | 28756 | 10 | 0.420 | 68466.7 |
753 | 2023-01-20 02:48:43 | trump | 1 | 28756 | 10 | 0.420 | 68466.7 |
752 | 2023-01-19 10:32:32 | trump | 2 | 53800 | 90 | 1.546 | 34799.5 |
751 | 2022-12-05 14:02:47 | trump | 3 | 83667 | 712 | 3.263 | 25641.1 |
750 | 2022-11-26 13:45:31 | trump | 1 | 28756 | 10 | 0.420 | 68466.7 |
749 | 2022-11-25 23:14:02 | trump | 1 | 28756 | 10 | 0.516 | 55728.7 |
748 | 2022-10-29 12:04:03 | trump | 2 | 53800 | 90 | 1.343 | 40059.6 |
747 | 2022-10-03 16:36:47 | trump | 1 | 28756 | 10 | 0.440 | 65354.5 |
746 | 2022-10-02 06:11:14 | trump | 1 | 28756 | 10 | 0.470 | 61183.0 |
745 | 2022-09-07 03:34:33 | trump | 1 | 28756 | 10 | 0.640 | 44931.3 |
744 | 2022-07-21 03:27:05 | trump | 1 | 28756 | 10 | 0.470 | 61183.0 |
743 | 2022-06-26 10:25:54 | trump | 1 | 28756 | 10 | 0.423 | 67981.1 |
742 | 2022-05-31 15:04:14 | trump | 2 | 53800 | 90 | 1.360 | 39558.8 |
741 | 2022-05-17 21:07:08 | trump | 1 | 28756 | 10 | 0.453 | 63479.0 |
740 | 2022-05-01 09:59:09 | trump | 1 | 28756 | 10 | 0.906 | 31739.5 |
739 | 2022-04-15 07:39:10 | trump | 3 | 83667 | 712 | 3.326 | 25155.4 |
738 | 2022-04-01 12:30:14 | trump | 3 | 83667 | 712 | 3.253 | 25720.0 |
737 | 2022-03-20 13:45:31 | trump | 1 | 28756 | 10 | 0.453 | 63479.0 |
736 | 2022-01-04 12:58:45 | trump | 1 | 28756 | 10 | 1.080 | 26625.9 |
735 | 2021-12-30 18:13:15 | trump | 1 | 28756 | 10 | 0.533 | 53951.2 |
734 | 2021-12-10 22:04:17 | trump | 3 | 83667 | 712 | 3.296 | 25384.4 |
733 | 2021-11-13 06:41:01 | trump | 1 | 28756 | 10 | 0.440 | 65354.5 |
732 | 2021-11-10 17:52:13 | trump | 1 | 28756 | 10 | 0.516 | 55728.7 |
731 | 2021-11-04 10:14:09 | trump | 1 | 28756 | 10 | 0.500 | 57512.0 |
730 | 2021-09-21 20:19:16 | trump | 1 | 28756 | 10 | 0.500 | 57512.0 |
729 | 2021-09-21 08:20:04 | trump | 1 | 28756 | 10 | 0.516 | 55728.7 |
728 | 2021-09-20 20:33:20 | trump | 1 | 28756 | 10 | 0.453 | 63479.0 |
727 | 2021-09-20 03:17:59 | trump | 1 | 28756 | 10 | 0.423 | 67981.1 |
726 | 2021-09-18 20:19:32 | trump | 1 | 28756 | 10 | 0.486 | 59168.7 |
725 | 2021-09-14 02:10:02 | trump | 1 | 28756 | 10 | 0.453 | 63479.0 |
724 | 2021-09-04 12:52:37 | trump | 1 | 28756 | 10 | 0.436 | 65954.1 |
723 | 2021-09-02 06:26:38 | trump | 1 | 28756 | 10 | 0.453 | 63479.0 |
722 | 2021-08-31 04:45:47 | trump | 1 | 28756 | 10 | 0.453 | 63479.0 |
721 | 2021-06-30 11:14:13 | trump | 3 | 83667 | 712 | 3.280 | 25508.2 |
720 | 2021-06-26 22:13:45 | trump | 3 | 83667 | 712 | 4.686 | 17854.7 |
719 | 2021-06-15 17:17:35 | trump | 1 | 28756 | 10 | 0.513 | 56054.6 |
718 | 2021-05-18 04:31:56 | trump | 1 | 28756 | 10 | 0.440 | 65354.5 |
717 | 2021-05-10 21:42:31 | trump | 3 | 83667 | 712 | 3.750 | 22311.2 |
716 | 2021-04-30 18:54:51 | trump | 1 | 28756 | 10 | 0.483 | 59536.2 |
715 | 2021-04-18 04:55:34 | trump | 1 | 28756 | 10 | 0.530 | 54256.6 |
714 | 2021-03-16 07:54:50 | trump | 1 | 28756 | 10 | 0.610 | 47141.0 |
713 | 2021-01-27 07:49:21 | trump | 1 | 28756 | 10 | 0.470 | 61183.0 |