History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doe"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2951 | 2024-05-10 05:12:51 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
2950 | 2024-05-09 22:10:18 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2949 | 2024-05-09 09:55:04 | doe | 2 | 14084 | 602 | 0.410 | 34351.2 |
2948 | 2024-05-08 22:02:58 | doe | 2 | 14084 | 602 | 0.360 | 39122.2 |
2947 | 2024-05-08 21:20:54 | doe | 2 | 14084 | 602 | 0.330 | 42678.8 |
2946 | 2024-05-08 17:28:37 | doe | 2 | 14084 | 602 | 0.423 | 33295.5 |
2945 | 2024-05-08 09:55:03 | doe | 2 | 14084 | 602 | 0.453 | 31090.5 |
2944 | 2024-05-07 22:08:14 | doe | 2 | 14084 | 602 | 0.436 | 32302.8 |
2943 | 2024-05-06 22:04:42 | doe | 2 | 14084 | 602 | 0.423 | 33295.5 |
2942 | 2024-05-06 21:48:14 | doe | 2 | 14084 | 602 | 0.436 | 32302.8 |
2941 | 2024-05-06 21:48:00 | doe | 2 | 14084 | 602 | 0.410 | 34351.2 |
2940 | 2024-05-05 22:02:07 | doe | 2 | 14084 | 602 | 0.733 | 19214.2 |
2939 | 2024-05-04 21:35:43 | doe | 2 | 14084 | 602 | 0.436 | 32302.8 |
2938 | 2024-05-04 21:19:30 | doe | 2 | 14084 | 602 | 0.890 | 15824.7 |
2937 | 2024-05-04 21:19:02 | doe | 2 | 14084 | 602 | 0.453 | 31090.5 |
2936 | 2024-05-04 10:51:11 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2935 | 2024-05-03 22:01:07 | doe | 2 | 14084 | 602 | 0.453 | 31090.5 |
2934 | 2024-05-03 20:43:27 | doe | 1 | 5146 | 37 | 0.283 | 18183.7 |
2933 | 2024-05-03 10:06:37 | doe | 2 | 14084 | 602 | 0.966 | 14579.7 |
2932 | 2024-05-02 21:38:01 | doe | 2 | 14084 | 602 | 0.440 | 32009.1 |
2931 | 2024-05-02 21:28:58 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
2930 | 2024-05-01 21:56:15 | doe | 2 | 14084 | 602 | 1.033 | 13634.1 |
2929 | 2024-05-01 17:47:42 | doe | 1 | 5146 | 37 | 0.190 | 27084.2 |
2928 | 2024-05-01 17:47:28 | doe | 2 | 14084 | 602 | 0.423 | 33295.5 |
2927 | 2024-05-01 14:38:56 | doe | 2 | 14084 | 602 | 0.390 | 36112.8 |
2926 | 2024-04-30 14:34:52 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2925 | 2024-04-29 21:08:46 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
2924 | 2024-04-29 14:34:00 | doe | 2 | 14084 | 602 | 0.436 | 32302.8 |
2923 | 2024-04-28 22:35:10 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
2922 | 2024-04-28 22:13:05 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2921 | 2024-04-28 14:49:54 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2920 | 2024-04-28 11:22:07 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
2919 | 2024-04-27 16:09:45 | doe | 2 | 14084 | 602 | 0.500 | 28168.0 |
2918 | 2024-04-27 15:04:52 | doe | 2 | 14084 | 602 | 0.343 | 41061.2 |
2917 | 2024-04-27 13:17:22 | doe | 1 | 5146 | 37 | 0.076 | 67710.5 |
2916 | 2024-04-27 03:19:23 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2915 | 2024-04-26 16:28:35 | doe | 2 | 14084 | 602 | 0.420 | 33533.3 |
2914 | 2024-04-26 16:28:00 | doe | 2 | 14084 | 602 | 0.390 | 36112.8 |
2913 | 2024-04-26 03:55:19 | doe | 2 | 14084 | 602 | 0.326 | 43202.5 |
2912 | 2024-04-26 02:47:51 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
2911 | 2024-04-25 14:55:00 | doe | 2 | 14084 | 602 | 0.373 | 37758.7 |
2910 | 2024-04-25 14:34:44 | doe | 1 | 5146 | 37 | 0.173 | 29745.7 |
2909 | 2024-04-25 13:27:55 | doe | 2 | 14084 | 602 | 0.436 | 32302.8 |
2908 | 2024-04-25 12:44:02 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2907 | 2024-04-25 04:45:05 | doe | 2 | 14084 | 602 | 1.173 | 12006.8 |
2906 | 2024-04-24 12:31:52 | doe | 2 | 14084 | 602 | 1.110 | 12688.3 |
2905 | 2024-04-23 12:51:52 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2904 | 2024-04-22 23:36:18 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2903 | 2024-04-22 10:37:35 | doe | 2 | 14084 | 602 | 0.593 | 23750.4 |
2902 | 2024-04-21 23:30:20 | doe | 2 | 14084 | 602 | 0.626 | 22498.4 |
2901 | 2024-04-20 23:15:03 | doe | 2 | 14084 | 602 | 1.330 | 10589.5 |
2900 | 2024-04-19 17:04:55 | doe | 2 | 14084 | 602 | 1.330 | 10589.5 |
2899 | 2024-04-18 16:49:07 | doe | 2 | 14084 | 602 | 0.766 | 18386.4 |
2898 | 2024-04-18 13:25:37 | doe | 2 | 14084 | 602 | 0.436 | 32302.8 |
2897 | 2024-04-17 13:50:33 | doe | 2 | 14084 | 602 | 0.423 | 33295.5 |
2896 | 2024-04-16 16:20:24 | doe | 2 | 14084 | 602 | 2.346 | 6003.4 |
2895 | 2024-04-15 16:15:11 | doe | 2 | 14084 | 602 | 0.670 | 21020.9 |
2894 | 2024-04-14 16:02:24 | doe | 2 | 14084 | 602 | 1.216 | 11582.2 |
2893 | 2024-04-13 16:08:29 | doe | 2 | 14084 | 602 | 0.373 | 37758.7 |
2892 | 2024-04-13 11:04:21 | doe | 1 | 5146 | 37 | 0.096 | 53604.2 |
2891 | 2024-04-13 07:57:34 | doe | 2 | 14084 | 602 | 0.360 | 39122.2 |
2890 | 2024-04-12 16:06:13 | doe | 1 | 5146 | 37 | 0.250 | 20584.0 |
2889 | 2024-04-12 15:24:37 | doe | 1 | 5146 | 37 | 0.343 | 15002.9 |
2888 | 2024-04-12 12:12:01 | doe | 1 | 5146 | 37 | 0.580 | 8872.4 |
2887 | 2024-04-12 08:02:35 | doe | 2 | 14084 | 602 | 0.766 | 18386.4 |
2886 | 2024-04-11 23:02:14 | doe | 1 | 5146 | 37 | 0.236 | 21805.1 |
2885 | 2024-04-11 23:01:18 | doe | 1 | 5146 | 37 | 0.190 | 27084.2 |
2884 | 2024-04-11 08:10:14 | doe | 2 | 14084 | 602 | 0.390 | 36112.8 |
2883 | 2024-04-11 03:26:11 | doe | 1 | 5146 | 37 | 0.076 | 67710.5 |
2882 | 2024-04-10 19:35:14 | doe | 2 | 14084 | 602 | 0.906 | 15545.3 |
2881 | 2024-04-10 05:34:08 | doe | 2 | 14084 | 602 | 0.390 | 36112.8 |
2880 | 2024-04-10 01:48:57 | doe | 1 | 5146 | 37 | 0.200 | 25730.0 |
2879 | 2024-04-09 18:34:56 | doe | 2 | 14084 | 602 | 0.560 | 25150.0 |
2878 | 2024-04-09 08:18:51 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2877 | 2024-04-09 00:53:42 | doe | 1 | 5146 | 37 | 0.313 | 16440.9 |
2876 | 2024-04-08 19:34:42 | doe | 2 | 14084 | 602 | 0.436 | 32302.8 |
2875 | 2024-04-08 16:35:37 | doe | 2 | 14084 | 602 | 1.436 | 9807.8 |
2874 | 2024-04-08 03:18:00 | doe | 1 | 5146 | 37 | 0.110 | 46781.8 |
2873 | 2024-04-07 22:34:16 | doe | 1 | 5146 | 37 | 0.110 | 46781.8 |
2872 | 2024-04-07 18:28:58 | doe | 2 | 14084 | 602 | 1.313 | 10726.6 |
2871 | 2024-04-07 09:21:36 | doe | 1 | 5146 | 37 | 0.106 | 48547.2 |
2870 | 2024-04-06 19:41:59 | doe | 1 | 5146 | 37 | 0.296 | 17385.1 |
2869 | 2024-04-06 18:25:38 | doe | 2 | 14084 | 602 | 0.860 | 16376.7 |
2868 | 2024-04-05 19:12:21 | doe | 1 | 5146 | 37 | 0.170 | 30270.6 |
2867 | 2024-04-05 18:32:41 | doe | 2 | 14084 | 602 | 0.626 | 22498.4 |
2866 | 2024-04-04 16:51:21 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
2865 | 2024-04-04 13:41:59 | doe | 2 | 14084 | 602 | 0.393 | 35837.2 |
2864 | 2024-04-04 02:51:19 | doe | 1 | 5146 | 37 | 0.106 | 48547.2 |
2863 | 2024-04-03 23:46:31 | doe | 2 | 14084 | 602 | 0.453 | 31090.5 |
2862 | 2024-04-03 12:50:24 | doe | 1 | 5146 | 37 | 0.203 | 25349.8 |
2861 | 2024-04-03 04:39:23 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
2860 | 2024-04-02 17:27:18 | doe | 1 | 5146 | 37 | 0.080 | 64325.0 |
2859 | 2024-04-01 12:51:33 | doe | 2 | 14084 | 602 | 0.453 | 31090.5 |
2858 | 2024-03-30 18:33:00 | doe | 1 | 5146 | 37 | 0.420 | 12252.4 |
2857 | 2024-03-30 05:49:07 | doe | 2 | 14084 | 602 | 0.436 | 32302.8 |
2856 | 2024-03-28 21:20:56 | doe | 2 | 14084 | 602 | 0.450 | 31297.8 |
2855 | 2024-03-28 19:21:37 | doe | 1 | 5146 | 37 | 0.200 | 25730.0 |
2854 | 2024-03-28 13:15:00 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
2853 | 2024-03-28 12:13:28 | doe | 2 | 14084 | 602 | 0.376 | 37457.4 |
2852 | 2024-03-26 21:14:48 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |