History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"colza"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2912 | 2024-04-27 01:38:02 | colza | 3 | 83667 | 854 | 15.910 | 5258.8 |
2911 | 2024-04-26 01:32:41 | colza | 3 | 83667 | 854 | 6.190 | 13516.5 |
2910 | 2024-04-25 16:18:07 | colza | 3 | 83667 | 854 | 4.296 | 19475.6 |
2909 | 2024-04-25 05:01:46 | colza | 3 | 83667 | 854 | 10.796 | 7749.8 |
2908 | 2024-04-25 01:22:06 | colza | 3 | 83667 | 854 | 8.593 | 9736.6 |
2907 | 2024-04-24 01:08:39 | colza | 3 | 83667 | 854 | 4.983 | 16790.5 |
2906 | 2024-04-23 02:31:23 | colza | 3 | 83667 | 854 | 3.970 | 21074.8 |
2905 | 2024-04-23 01:05:47 | colza | 3 | 83667 | 854 | 7.843 | 10667.7 |
2904 | 2024-04-22 09:29:15 | colza | 1 | 28756 | 3 | 0.610 | 47141.0 |
2903 | 2024-04-22 02:48:59 | colza | 3 | 83667 | 854 | 7.406 | 11297.2 |
2902 | 2024-04-22 01:03:04 | colza | 3 | 83667 | 854 | 16.656 | 5023.2 |
2901 | 2024-04-21 01:09:35 | colza | 3 | 83667 | 854 | 15.093 | 5543.4 |
2900 | 2024-04-19 22:51:29 | colza | 3 | 83667 | 854 | 10.376 | 8063.5 |
2899 | 2024-04-19 11:43:32 | colza | 1 | 28756 | 3 | 1.080 | 26625.9 |
2898 | 2024-04-17 05:13:43 | colza | 3 | 83667 | 854 | 3.780 | 22134.1 |
2897 | 2024-04-13 10:12:35 | colza | 3 | 83667 | 854 | 3.700 | 22612.7 |
2896 | 2024-04-13 02:34:26 | colza | 3 | 83667 | 854 | 6.860 | 12196.4 |
2895 | 2024-04-12 02:42:48 | colza | 3 | 83667 | 854 | 16.440 | 5089.2 |
2894 | 2024-04-11 02:27:14 | colza | 3 | 83667 | 854 | 4.296 | 19475.6 |
2893 | 2024-04-10 09:15:58 | colza | 3 | 83667 | 854 | 8.533 | 9805.1 |
2892 | 2024-04-10 02:32:58 | colza | 3 | 83667 | 854 | 4.983 | 16790.5 |
2891 | 2024-04-09 02:19:35 | colza | 3 | 83667 | 854 | 4.453 | 18788.9 |
2890 | 2024-04-08 03:03:09 | colza | 3 | 83667 | 854 | 7.360 | 11367.8 |
2889 | 2024-04-07 02:21:03 | colza | 3 | 83667 | 854 | 12.096 | 6916.9 |
2888 | 2024-04-06 02:12:40 | colza | 3 | 83667 | 854 | 10.750 | 7783.0 |
2887 | 2024-04-05 02:17:58 | colza | 3 | 83667 | 854 | 6.236 | 13416.8 |
2886 | 2024-04-04 02:12:55 | colza | 3 | 83667 | 854 | 4.720 | 17726.1 |
2885 | 2024-04-03 02:22:11 | colza | 3 | 83667 | 854 | 6.063 | 13799.6 |
2884 | 2024-04-02 22:35:52 | colza | 2 | 53800 | 60 | 3.923 | 13714.0 |
2883 | 2024-04-02 21:16:24 | colza | 1 | 28756 | 3 | 0.500 | 57512.0 |
2882 | 2024-04-02 02:46:36 | colza | 3 | 83667 | 854 | 4.033 | 20745.6 |
2881 | 2024-04-01 05:52:17 | colza | 3 | 83667 | 854 | 11.763 | 7112.7 |
2880 | 2024-04-01 02:28:26 | colza | 3 | 83667 | 854 | 4.593 | 18216.2 |
2879 | 2024-03-31 08:18:44 | colza | 1 | 28756 | 3 | 1.046 | 27491.4 |
2878 | 2024-03-31 02:24:30 | colza | 3 | 83667 | 854 | 3.843 | 21771.3 |
2877 | 2024-03-30 02:20:44 | colza | 3 | 83667 | 854 | 4.000 | 20916.8 |
2876 | 2024-03-30 01:21:03 | colza | 3 | 83667 | 854 | 11.953 | 6999.7 |
2875 | 2024-03-29 02:24:46 | colza | 3 | 83667 | 854 | 3.826 | 21868.0 |
2874 | 2024-03-28 07:45:47 | colza | 3 | 83667 | 854 | 10.173 | 8224.4 |
2873 | 2024-03-28 02:26:51 | colza | 3 | 83667 | 854 | 3.516 | 23796.1 |
2872 | 2024-03-27 04:02:15 | colza | 1 | 28756 | 3 | 1.046 | 27491.4 |
2871 | 2024-03-27 02:26:59 | colza | 3 | 83667 | 854 | 13.970 | 5989.0 |
2870 | 2024-03-26 20:58:14 | colza | 1 | 28756 | 3 | 1.123 | 25606.4 |
2869 | 2024-03-26 20:57:42 | colza | 3 | 83667 | 854 | 3.766 | 22216.4 |
2868 | 2024-03-26 03:12:20 | colza | 1 | 28756 | 3 | 0.533 | 53951.2 |
2867 | 2024-03-26 02:03:35 | colza | 3 | 83667 | 854 | 4.266 | 19612.5 |
2866 | 2024-03-25 02:36:47 | colza | 3 | 83667 | 854 | 4.283 | 19534.7 |
2865 | 2024-03-24 01:56:39 | colza | 3 | 83667 | 854 | 4.080 | 20506.6 |
2864 | 2024-03-23 01:52:38 | colza | 3 | 83667 | 854 | 13.126 | 6374.1 |
2863 | 2024-03-22 02:08:30 | colza | 3 | 83667 | 854 | 7.500 | 11155.6 |
2862 | 2024-03-21 02:06:58 | colza | 3 | 83667 | 854 | 10.983 | 7617.9 |
2861 | 2024-03-20 01:51:58 | colza | 3 | 83667 | 854 | 3.876 | 21585.9 |
2860 | 2024-03-19 01:50:38 | colza | 3 | 83667 | 854 | 4.203 | 19906.5 |
2859 | 2024-03-17 23:54:53 | colza | 3 | 83667 | 854 | 6.766 | 12365.8 |
2858 | 2024-03-17 16:52:19 | colza | 3 | 83667 | 854 | 4.296 | 19475.6 |
2857 | 2024-03-17 00:05:41 | colza | 3 | 83667 | 854 | 3.703 | 22594.4 |
2856 | 2024-03-15 23:49:10 | colza | 3 | 83667 | 854 | 3.310 | 25277.0 |
2855 | 2024-03-14 23:45:35 | colza | 3 | 83667 | 854 | 13.623 | 6141.6 |
2854 | 2024-03-13 23:47:42 | colza | 3 | 83667 | 854 | 4.813 | 17383.5 |
2853 | 2024-03-11 04:16:19 | colza | 1 | 28756 | 3 | 0.436 | 65954.1 |
2852 | 2024-03-09 20:01:25 | colza | 3 | 83667 | 854 | 4.846 | 17265.2 |
2851 | 2024-03-04 15:57:13 | colza | 3 | 83667 | 854 | 4.046 | 20678.9 |
2850 | 2024-03-03 12:32:09 | colza | 3 | 83667 | 854 | 4.376 | 19119.5 |
2849 | 2024-03-02 16:41:28 | colza | 3 | 83667 | 854 | 4.093 | 20441.5 |
2848 | 2024-03-02 04:52:06 | colza | 2 | 53800 | 60 | 5.376 | 10007.4 |
2847 | 2024-03-02 04:26:21 | colza | 3 | 83667 | 854 | 4.453 | 18788.9 |
2846 | 2024-03-01 21:42:31 | colza | 3 | 83667 | 854 | 4.466 | 18734.2 |
2845 | 2024-02-27 14:37:59 | colza | 2 | 53800 | 60 | 1.593 | 33772.8 |
2844 | 2024-02-26 01:44:52 | colza | 1 | 28756 | 3 | 1.156 | 24875.4 |
2843 | 2024-02-25 18:41:47 | colza | 2 | 53800 | 60 | 1.716 | 31352.0 |
2842 | 2024-02-22 11:08:00 | colza | 3 | 83667 | 854 | 9.186 | 9108.1 |
2841 | 2024-02-19 16:54:54 | colza | 3 | 83667 | 854 | 10.643 | 7861.2 |
2840 | 2024-02-17 23:09:23 | colza | 3 | 83667 | 854 | 12.063 | 6935.8 |
2839 | 2024-01-29 07:29:55 | colza | 1 | 28756 | 3 | 0.516 | 55728.7 |
2838 | 2024-01-26 22:33:41 | colza | 1 | 28756 | 3 | 0.516 | 55728.7 |
2837 | 2024-01-18 14:43:35 | colza | 3 | 83667 | 854 | 4.110 | 20356.9 |
2836 | 2024-01-18 10:24:35 | colza | 3 | 83667 | 854 | 4.080 | 20506.6 |
2835 | 2024-01-15 07:56:59 | colza | 3 | 83667 | 854 | 3.546 | 23594.8 |
2834 | 2024-01-11 20:26:54 | colza | 2 | 53800 | 60 | 1.423 | 37807.4 |
2833 | 2024-01-11 00:13:19 | colza | 3 | 83667 | 854 | 3.343 | 25027.5 |
2832 | 2024-01-06 00:11:20 | colza | 3 | 83667 | 854 | 3.906 | 21420.1 |
2831 | 2024-01-01 02:48:02 | colza | 3 | 83667 | 854 | 9.030 | 9265.4 |
2830 | 2023-12-29 19:19:01 | colza | 3 | 83667 | 854 | 3.346 | 25005.1 |
2829 | 2023-12-19 20:59:42 | colza | 3 | 83667 | 854 | 3.826 | 21868.0 |
2828 | 2023-12-18 18:18:36 | colza | 1 | 28756 | 3 | 0.470 | 61183.0 |
2827 | 2023-12-18 02:24:54 | colza | 3 | 83667 | 854 | 3.483 | 24021.5 |
2826 | 2023-12-08 07:14:32 | colza | 3 | 83667 | 854 | 3.826 | 21868.0 |
2825 | 2023-12-05 20:11:48 | colza | 2 | 53800 | 60 | 1.373 | 39184.3 |
2824 | 2023-12-03 12:48:44 | colza | 1 | 28756 | 3 | 0.453 | 63479.0 |
2823 | 2023-12-03 12:48:43 | colza | 1 | 28756 | 3 | 0.436 | 65954.1 |
2822 | 2023-12-02 22:16:42 | colza | 3 | 83667 | 854 | 3.580 | 23370.7 |
2821 | 2023-12-02 22:16:43 | colza | 2 | 53800 | 60 | 1.610 | 33416.1 |
2820 | 2023-11-27 20:28:09 | colza | 3 | 83667 | 854 | 5.953 | 14054.6 |
2819 | 2023-11-27 19:18:42 | colza | 3 | 83667 | 854 | 3.923 | 21327.3 |
2818 | 2023-11-24 10:24:45 | colza | 3 | 83667 | 854 | 3.313 | 25254.2 |
2817 | 2023-11-16 14:27:24 | colza | 3 | 83667 | 854 | 3.563 | 23482.2 |
2816 | 2023-11-15 11:58:16 | colza | 1 | 28756 | 3 | 0.500 | 57512.0 |
2815 | 2023-11-10 20:22:22 | colza | 3 | 83667 | 854 | 4.030 | 20761.0 |
2814 | 2023-11-10 13:09:38 | colza | 1 | 28756 | 3 | 0.453 | 63479.0 |
2813 | 2023-11-08 11:48:37 | colza | 1 | 28756 | 3 | 0.440 | 65354.5 |