History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"abcd"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
3964 | 2024-05-03 00:10:23 | abcd | 2 | 29872 | 63 | 0.923 | 32364.0 |
3963 | 2024-05-02 09:33:15 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3962 | 2024-04-30 19:12:04 | abcd | 2 | 29872 | 63 | 0.860 | 34734.9 |
3961 | 2024-04-30 19:11:59 | abcd | 3 | 53901 | 1304 | 4.093 | 13169.1 |
3960 | 2024-04-30 19:11:51 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3959 | 2024-04-30 12:55:14 | abcd | 2 | 29872 | 63 | 1.156 | 25840.8 |
3958 | 2024-04-27 18:18:10 | abcd | 1 | 13983 | 1 | 0.266 | 52567.7 |
3957 | 2024-04-24 15:10:09 | abcd | 2 | 29872 | 63 | 2.436 | 12262.7 |
3956 | 2024-04-24 15:05:35 | abcd | 2 | 29872 | 63 | 2.123 | 14070.7 |
3955 | 2024-04-24 14:57:57 | abcd | 1 | 13983 | 1 | 0.280 | 49939.3 |
3954 | 2024-04-24 11:19:25 | abcd | 1 | 13983 | 1 | 0.670 | 20870.1 |
3953 | 2024-04-22 23:10:53 | abcd | 1 | 13983 | 1 | 0.220 | 63559.1 |
3952 | 2024-04-21 14:18:41 | abcd | 1 | 13983 | 1 | 0.906 | 15433.8 |
3951 | 2024-04-21 14:18:32 | abcd | 1 | 13983 | 1 | 0.903 | 15485.0 |
3950 | 2024-04-21 06:37:55 | abcd | 1 | 13983 | 1 | 0.296 | 47239.9 |
3949 | 2024-04-19 19:45:00 | abcd | 1 | 13983 | 1 | 0.263 | 53167.3 |
3948 | 2024-04-19 14:59:03 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3947 | 2024-04-17 21:41:58 | abcd | 2 | 29872 | 63 | 2.470 | 12093.9 |
3946 | 2024-04-17 19:01:06 | abcd | 3 | 53901 | 1304 | 9.003 | 5987.0 |
3945 | 2024-04-17 10:20:15 | abcd | 3 | 53901 | 1304 | 2.970 | 18148.5 |
3944 | 2024-04-17 10:20:13 | abcd | 2 | 29872 | 63 | 1.063 | 28101.6 |
3943 | 2024-04-17 08:36:56 | abcd | 1 | 13983 | 1 | 0.233 | 60012.9 |
3942 | 2024-04-13 15:18:47 | abcd | 3 | 53901 | 1304 | 2.453 | 21973.5 |
3941 | 2024-04-13 15:18:46 | abcd | 2 | 29872 | 63 | 0.890 | 33564.0 |
3940 | 2024-04-13 14:06:26 | abcd | 1 | 13983 | 1 | 0.283 | 49409.9 |
3939 | 2024-04-11 05:41:54 | abcd | 1 | 13983 | 1 | 0.533 | 26234.5 |
3938 | 2024-04-09 17:38:05 | abcd | 1 | 13983 | 1 | 1.033 | 13536.3 |
3937 | 2024-03-28 16:18:35 | abcd | 2 | 29872 | 63 | 1.173 | 25466.3 |
3936 | 2024-03-23 12:16:16 | abcd | 2 | 29872 | 63 | 0.890 | 33564.0 |
3935 | 2024-03-23 12:16:14 | abcd | 3 | 53901 | 1304 | 2.330 | 23133.5 |
3934 | 2024-03-23 12:16:09 | abcd | 1 | 13983 | 1 | 0.220 | 63559.1 |
3933 | 2024-03-08 10:41:06 | abcd | 1 | 13983 | 1 | 0.296 | 47239.9 |
3932 | 2024-03-05 20:00:54 | abcd | 1 | 13983 | 1 | 0.546 | 25609.9 |
3931 | 2024-03-05 20:00:49 | abcd | 3 | 53901 | 1304 | 4.360 | 12362.6 |
3930 | 2024-03-05 20:00:49 | abcd | 2 | 29872 | 63 | 1.376 | 21709.3 |
3929 | 2024-03-05 10:26:05 | abcd | 3 | 53901 | 1304 | 2.123 | 25389.1 |
3928 | 2024-03-05 10:26:04 | abcd | 2 | 29872 | 63 | 0.906 | 32971.3 |
3927 | 2024-03-05 08:48:30 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3926 | 2024-03-05 03:09:13 | abcd | 1 | 13983 | 1 | 0.560 | 24969.6 |
3925 | 2024-03-05 03:09:10 | abcd | 2 | 29872 | 63 | 1.936 | 15429.8 |
3924 | 2024-03-05 03:09:04 | abcd | 1 | 13983 | 1 | 0.563 | 24836.6 |
3923 | 2024-03-05 02:32:05 | abcd | 3 | 53901 | 1304 | 5.720 | 9423.3 |
3922 | 2024-03-04 18:47:12 | abcd | 3 | 53901 | 1304 | 8.686 | 6205.5 |
3921 | 2024-03-04 18:10:48 | abcd | 3 | 53901 | 1304 | 2.466 | 21857.7 |
3920 | 2024-02-25 16:21:23 | abcd | 3 | 53901 | 1304 | 2.126 | 25353.2 |
3919 | 2024-02-25 16:21:23 | abcd | 2 | 29872 | 63 | 0.873 | 34217.6 |
3918 | 2024-02-25 15:48:04 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3917 | 2024-02-21 07:11:40 | abcd | 1 | 13983 | 1 | 0.830 | 16847.0 |
3916 | 2024-02-06 01:51:34 | abcd | 1 | 13983 | 1 | 0.236 | 59250.0 |
3915 | 2024-02-06 01:51:30 | abcd | 2 | 29872 | 63 | 0.906 | 32971.3 |
3914 | 2024-02-06 01:42:46 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3913 | 2024-02-06 01:42:22 | abcd | 3 | 53901 | 1304 | 3.860 | 13964.0 |
3912 | 2024-02-05 15:19:06 | abcd | 3 | 53901 | 1304 | 2.690 | 20037.5 |
3911 | 2024-02-05 09:24:56 | abcd | 3 | 53901 | 1304 | 2.406 | 22402.7 |
3910 | 2024-01-26 14:30:22 | abcd | 3 | 53901 | 1304 | 2.470 | 21822.3 |
3909 | 2024-01-26 14:30:20 | abcd | 2 | 29872 | 63 | 0.940 | 31778.7 |
3908 | 2024-01-26 13:11:22 | abcd | 1 | 13983 | 1 | 0.543 | 25751.4 |
3907 | 2024-01-25 06:09:26 | abcd | 1 | 13983 | 1 | 0.220 | 63559.1 |
3906 | 2024-01-24 01:19:29 | abcd | 3 | 53901 | 1304 | 2.016 | 26736.6 |
3905 | 2024-01-24 01:19:28 | abcd | 2 | 29872 | 63 | 0.813 | 36742.9 |
3904 | 2024-01-24 00:03:35 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3903 | 2024-01-23 13:40:48 | abcd | 3 | 53901 | 1304 | 2.343 | 23005.1 |
3902 | 2024-01-19 02:04:54 | abcd | 3 | 53901 | 1304 | 2.280 | 23640.8 |
3901 | 2024-01-07 17:19:05 | abcd | 1 | 13983 | 1 | 0.203 | 68881.8 |
3900 | 2024-01-06 23:56:36 | abcd | 1 | 13983 | 1 | 0.216 | 64736.1 |
3899 | 2024-01-03 21:22:43 | abcd | 1 | 13983 | 1 | 0.296 | 47239.9 |
3898 | 2024-01-02 04:46:23 | abcd | 3 | 53901 | 1304 | 2.530 | 21304.7 |
3897 | 2023-12-31 16:00:06 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3896 | 2023-12-29 05:31:21 | abcd | 3 | 53901 | 1304 | 2.326 | 23173.3 |
3895 | 2023-12-29 05:31:20 | abcd | 2 | 29872 | 63 | 0.856 | 34897.2 |
3894 | 2023-12-29 04:25:02 | abcd | 1 | 13983 | 1 | 0.220 | 63559.1 |
3893 | 2023-12-26 01:27:44 | abcd | 3 | 53901 | 1304 | 1.983 | 27181.5 |
3892 | 2023-12-21 13:21:22 | abcd | 3 | 53901 | 1304 | 2.156 | 25000.5 |
3891 | 2023-12-17 18:14:26 | abcd | 3 | 53901 | 1304 | 2.483 | 21708.0 |
3890 | 2023-12-15 11:05:35 | abcd | 3 | 53901 | 1304 | 2.203 | 24467.1 |
3889 | 2023-12-15 11:05:34 | abcd | 2 | 29872 | 63 | 0.733 | 40753.1 |
3888 | 2023-12-15 09:47:13 | abcd | 1 | 13983 | 1 | 0.220 | 63559.1 |
3887 | 2023-12-09 14:12:38 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3886 | 2023-12-08 06:20:55 | abcd | 3 | 53901 | 1304 | 2.266 | 23786.8 |
3885 | 2023-12-08 06:20:52 | abcd | 3 | 53901 | 1304 | 2.376 | 22685.6 |
3884 | 2023-12-08 06:17:57 | abcd | 1 | 13983 | 1 | 0.216 | 64736.1 |
3883 | 2023-12-08 06:17:56 | abcd | 1 | 13983 | 1 | 0.216 | 64736.1 |
3882 | 2023-12-06 21:09:47 | abcd | 3 | 53901 | 1304 | 2.000 | 26950.5 |
3881 | 2023-12-06 21:09:44 | abcd | 3 | 53901 | 1304 | 2.203 | 24467.1 |
3880 | 2023-12-06 21:01:51 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3879 | 2023-12-06 21:01:51 | abcd | 1 | 13983 | 1 | 0.233 | 60012.9 |
3878 | 2023-12-03 01:59:22 | abcd | 3 | 53901 | 1304 | 1.986 | 27140.5 |
3877 | 2023-12-03 01:59:19 | abcd | 3 | 53901 | 1304 | 1.986 | 27140.5 |
3876 | 2023-12-02 16:26:40 | abcd | 1 | 13983 | 1 | 0.500 | 27966.0 |
3875 | 2023-12-01 22:14:52 | abcd | 3 | 53901 | 1304 | 2.000 | 26950.5 |
3874 | 2023-11-28 16:23:16 | abcd | 3 | 53901 | 1304 | 2.160 | 24954.2 |
3873 | 2023-11-26 09:18:53 | abcd | 1 | 13983 | 1 | 0.203 | 68881.8 |
3872 | 2023-11-23 23:50:49 | abcd | 1 | 13983 | 1 | 0.263 | 53167.3 |
3871 | 2023-11-16 03:31:06 | abcd | 1 | 13983 | 1 | 0.233 | 60012.9 |
3870 | 2023-11-14 21:47:09 | abcd | 1 | 13983 | 1 | 0.216 | 64736.1 |
3869 | 2023-11-12 17:51:37 | abcd | 3 | 53901 | 1304 | 2.343 | 23005.1 |
3868 | 2023-11-08 13:04:47 | abcd | 3 | 53901 | 1304 | 2.000 | 26950.5 |
3867 | 2023-11-08 13:04:44 | abcd | 2 | 29872 | 63 | 0.846 | 35309.7 |
3866 | 2023-11-08 11:33:58 | abcd | 3 | 53901 | 1304 | 5.033 | 10709.5 |
3865 | 2023-11-08 11:33:17 | abcd | 2 | 29872 | 63 | 0.983 | 30388.6 |