History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"query"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
865 | 2024-12-27 12:18:13 | query | 2 | 53800 | 59 | 6.856 | 7847.1 |
864 | 2024-12-27 12:16:37 | query | 1 | 28756 | 3 | 1.533 | 18758.0 |
863 | 2024-12-11 03:10:48 | query | 1 | 28756 | 3 | 1.733 | 16593.2 |
862 | 2024-12-07 00:54:34 | query | 2 | 53800 | 59 | 7.716 | 6972.5 |
861 | 2024-12-07 00:54:33 | query | 1 | 28756 | 3 | 3.406 | 8442.7 |
860 | 2024-11-28 22:15:38 | query | 3 | 83667 | 893 | 19.830 | 4219.2 |
859 | 2024-11-27 21:20:12 | query | 3 | 83667 | 893 | 14.956 | 5594.2 |
858 | 2024-11-27 19:47:08 | query | 3 | 83667 | 893 | 26.033 | 3213.9 |
857 | 2024-11-27 18:14:48 | query | 3 | 83667 | 893 | 20.500 | 4081.3 |
856 | 2024-11-27 18:14:25 | query | 2 | 53800 | 59 | 5.296 | 10158.6 |
855 | 2024-11-27 18:14:11 | query | 1 | 28756 | 3 | 2.406 | 11951.8 |
854 | 2024-11-27 08:17:16 | query | 1 | 28756 | 3 | 2.140 | 13437.4 |
853 | 2024-11-06 22:10:07 | query | 1 | 28756 | 3 | 3.153 | 9120.2 |
852 | 2024-11-04 21:53:43 | query | 1 | 28756 | 3 | 1.890 | 15214.8 |
851 | 2024-10-28 18:06:42 | query | 1 | 28756 | 3 | 1.406 | 20452.3 |
850 | 2024-10-28 16:04:18 | query | 3 | 83667 | 893 | 28.720 | 2913.2 |
849 | 2024-10-28 15:42:04 | query | 3 | 83667 | 893 | 17.316 | 4831.8 |
848 | 2024-10-28 08:35:40 | query | 2 | 53800 | 59 | 6.546 | 8218.8 |
847 | 2024-10-28 07:02:30 | query | 1 | 28756 | 3 | 0.486 | 59168.7 |
846 | 2024-10-28 05:25:40 | query | 3 | 83667 | 893 | 23.593 | 3546.3 |
845 | 2024-10-27 04:58:58 | query | 3 | 83667 | 893 | 18.813 | 4447.3 |
844 | 2024-10-27 04:57:03 | query | 1 | 28756 | 3 | 3.060 | 9397.4 |
843 | 2024-10-10 13:54:40 | query | 3 | 83667 | 893 | 17.816 | 4696.2 |
842 | 2024-10-07 21:09:47 | query | 1 | 28756 | 3 | 3.766 | 7635.7 |
841 | 2024-09-29 00:10:17 | query | 1 | 28756 | 3 | 4.580 | 6278.6 |
840 | 2024-09-28 12:10:39 | query | 2 | 53800 | 59 | 6.796 | 7916.4 |
839 | 2024-09-28 12:08:58 | query | 1 | 28756 | 3 | 1.516 | 18968.3 |
838 | 2024-09-28 11:33:54 | query | 3 | 83667 | 893 | 22.626 | 3697.8 |
837 | 2024-09-28 11:16:12 | query | 3 | 83667 | 893 | 35.863 | 2333.0 |
836 | 2024-09-28 06:45:45 | query | 3 | 83667 | 893 | 30.360 | 2755.8 |
835 | 2024-09-28 06:45:44 | query | 2 | 53800 | 59 | 16.470 | 3266.5 |
834 | 2024-09-28 05:13:02 | query | 1 | 28756 | 3 | 0.466 | 61708.2 |
833 | 2024-09-08 10:22:59 | query | 3 | 83667 | 893 | 15.173 | 5514.2 |
832 | 2024-09-07 13:44:14 | query | 3 | 83667 | 893 | 34.940 | 2394.6 |
831 | 2024-09-07 13:44:14 | query | 2 | 53800 | 59 | 17.140 | 3138.9 |
830 | 2024-09-07 13:44:07 | query | 1 | 28756 | 3 | 5.750 | 5001.0 |
829 | 2024-08-30 05:11:12 | query | 1 | 28756 | 3 | 5.826 | 4935.8 |
828 | 2024-08-29 11:25:10 | query | 2 | 53800 | 59 | 14.973 | 3593.1 |
827 | 2024-08-29 11:23:21 | query | 1 | 28756 | 3 | 2.843 | 10114.7 |
826 | 2024-08-29 08:59:29 | query | 3 | 83667 | 893 | 37.126 | 2253.6 |
825 | 2024-08-29 08:44:09 | query | 3 | 83667 | 893 | 29.550 | 2831.4 |
824 | 2024-08-29 04:59:00 | query | 3 | 83667 | 893 | 19.346 | 4324.8 |
823 | 2024-08-29 04:59:02 | query | 2 | 53800 | 59 | 14.860 | 3620.5 |
822 | 2024-08-29 04:20:48 | query | 1 | 28756 | 3 | 0.766 | 37540.5 |
821 | 2024-08-29 00:47:11 | query | 1 | 28756 | 3 | 0.470 | 61183.0 |
820 | 2024-08-27 10:07:16 | query | 1 | 28756 | 3 | 2.470 | 11642.1 |
819 | 2024-08-10 07:51:48 | query | 1 | 28756 | 3 | 0.593 | 48492.4 |
818 | 2024-08-09 09:56:04 | query | 1 | 28756 | 3 | 1.156 | 24875.4 |
817 | 2024-08-08 09:33:54 | query | 1 | 28756 | 3 | 1.720 | 16718.6 |
816 | 2024-08-01 04:57:28 | query | 1 | 28756 | 3 | 1.826 | 15748.1 |
815 | 2024-07-30 08:20:33 | query | 2 | 53800 | 59 | 7.970 | 6750.3 |
814 | 2024-07-30 08:15:20 | query | 1 | 28756 | 3 | 0.470 | 61183.0 |
813 | 2024-07-29 21:56:36 | query | 1 | 28756 | 3 | 0.470 | 61183.0 |
812 | 2024-07-28 14:39:06 | query | 1 | 28756 | 3 | 2.686 | 10705.9 |
811 | 2024-07-28 04:46:01 | query | 1 | 28756 | 3 | 0.563 | 51076.4 |
810 | 2024-07-12 17:00:10 | query | 3 | 83667 | 893 | 25.576 | 3271.3 |
809 | 2024-07-11 20:09:20 | query | 2 | 53800 | 59 | 7.780 | 6915.2 |
808 | 2024-07-11 20:05:05 | query | 3 | 83667 | 893 | 9.623 | 8694.5 |
807 | 2024-07-11 18:33:10 | query | 3 | 83667 | 893 | 19.893 | 4205.9 |
806 | 2024-07-11 18:33:05 | query | 2 | 53800 | 59 | 7.423 | 7247.7 |
805 | 2024-07-10 07:29:43 | query | 3 | 83667 | 893 | 16.716 | 5005.2 |
804 | 2024-07-10 02:36:03 | query | 3 | 83667 | 893 | 19.656 | 4256.6 |
803 | 2024-07-10 02:35:54 | query | 2 | 53800 | 59 | 8.250 | 6521.2 |
802 | 2024-07-10 02:31:55 | query | 1 | 28756 | 3 | 2.236 | 12860.5 |
801 | 2024-07-07 02:08:36 | query | 1 | 28756 | 3 | 2.500 | 11502.4 |
800 | 2024-07-05 12:56:46 | query | 1 | 28756 | 3 | 1.046 | 27491.4 |
799 | 2024-06-29 22:54:11 | query | 1 | 28756 | 3 | 1.436 | 20025.1 |
798 | 2024-06-29 21:37:56 | query | 1 | 28756 | 3 | 1.720 | 16718.6 |
797 | 2024-06-28 07:03:12 | query | 1 | 28756 | 3 | 1.783 | 16127.9 |
796 | 2024-06-27 14:27:47 | query | 1 | 28756 | 3 | 2.436 | 11804.6 |
795 | 2024-06-16 22:50:01 | query | 1 | 28756 | 3 | 1.763 | 16310.8 |
794 | 2024-06-11 04:31:19 | query | 1 | 28756 | 3 | 1.643 | 17502.1 |
793 | 2024-06-03 17:45:24 | query | 3 | 83667 | 893 | 15.113 | 5536.1 |
792 | 2024-06-03 17:45:16 | query | 2 | 53800 | 59 | 5.500 | 9781.8 |
791 | 2024-06-03 16:33:32 | query | 1 | 28756 | 3 | 0.530 | 54256.6 |
790 | 2024-05-30 06:19:10 | query | 1 | 28756 | 3 | 2.063 | 13938.9 |
789 | 2024-05-29 20:35:46 | query | 1 | 28756 | 3 | 0.906 | 31739.5 |
788 | 2024-05-28 11:03:02 | query | 1 | 28756 | 3 | 2.016 | 14263.9 |
787 | 2024-05-15 16:28:08 | query | 1 | 28756 | 3 | 0.610 | 47141.0 |
786 | 2024-05-13 23:40:34 | query | 3 | 83667 | 893 | 15.096 | 5542.3 |
785 | 2024-05-12 08:37:47 | query | 1 | 28756 | 3 | 1.123 | 25606.4 |
784 | 2024-05-12 08:36:33 | query | 3 | 83667 | 893 | 4.576 | 18283.9 |
783 | 2024-05-11 07:14:44 | query | 3 | 83667 | 893 | 12.406 | 6744.1 |
782 | 2024-05-11 01:17:12 | query | 3 | 83667 | 893 | 4.250 | 19686.4 |
781 | 2024-05-10 06:45:23 | query | 1 | 28756 | 3 | 0.516 | 55728.7 |
780 | 2024-05-04 11:37:20 | query | 1 | 28756 | 3 | 0.483 | 59536.2 |
779 | 2024-05-01 15:00:12 | query | 1 | 28756 | 3 | 0.546 | 52666.7 |
778 | 2024-04-30 18:27:06 | query | 2 | 53800 | 59 | 1.453 | 37026.8 |
777 | 2024-04-28 10:39:47 | query | 1 | 28756 | 3 | 0.686 | 41918.4 |
776 | 2024-04-17 11:27:53 | query | 1 | 28756 | 3 | 0.420 | 68466.7 |
775 | 2024-04-11 02:54:36 | query | 1 | 28756 | 3 | 1.016 | 28303.1 |
774 | 2024-04-03 05:54:23 | query | 1 | 28756 | 3 | 1.063 | 27051.7 |
773 | 2024-03-31 02:00:42 | query | 1 | 28756 | 3 | 0.470 | 61183.0 |
772 | 2024-03-28 18:27:27 | query | 1 | 28756 | 3 | 1.593 | 18051.5 |
771 | 2024-03-18 21:37:41 | query | 3 | 83667 | 893 | 10.406 | 8040.3 |
770 | 2024-03-04 09:33:15 | query | 3 | 83667 | 893 | 8.860 | 9443.2 |
769 | 2024-03-04 09:33:14 | query | 1 | 28756 | 3 | 1.733 | 16593.2 |
768 | 2024-03-04 09:33:09 | query | 2 | 53800 | 59 | 1.703 | 31591.3 |
767 | 2024-03-01 16:19:10 | query | 2 | 53800 | 59 | 4.110 | 13090.0 |
766 | 2024-02-28 11:24:16 | query | 2 | 53800 | 59 | 1.656 | 32487.9 |