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 |
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 |
3864 | 2023-11-08 08:12:16 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3863 | 2023-11-08 02:05:01 | abcd | 1 | 13983 | 1 | 0.203 | 68881.8 |
3862 | 2023-11-07 22:03:36 | abcd | 1 | 13983 | 1 | 0.220 | 63559.1 |
3861 | 2023-11-07 18:54:42 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3860 | 2023-11-07 09:24:52 | abcd | 3 | 53901 | 1304 | 2.390 | 22552.7 |
3859 | 2023-11-07 09:24:19 | abcd | 2 | 29872 | 63 | 0.890 | 33564.0 |
3858 | 2023-11-07 07:10:08 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3857 | 2023-11-07 06:02:43 | abcd | 3 | 53901 | 1304 | 4.703 | 11461.0 |
3856 | 2023-11-07 06:02:42 | abcd | 2 | 29872 | 63 | 1.016 | 29401.6 |
3855 | 2023-11-07 04:46:39 | abcd | 1 | 13983 | 1 | 0.220 | 63559.1 |
3854 | 2023-11-06 20:15:46 | abcd | 2 | 29872 | 63 | 0.873 | 34217.6 |
3853 | 2023-11-06 19:10:01 | abcd | 3 | 53901 | 1304 | 2.516 | 21423.3 |
3852 | 2023-11-06 15:47:20 | abcd | 2 | 29872 | 63 | 0.843 | 35435.3 |
3851 | 2023-11-06 15:46:56 | abcd | 3 | 53901 | 1304 | 2.203 | 24467.1 |
3850 | 2023-11-06 12:53:17 | abcd | 1 | 13983 | 1 | 0.233 | 60012.9 |
3849 | 2023-11-06 10:17:30 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3848 | 2023-11-05 19:00:52 | abcd | 3 | 53901 | 1304 | 2.440 | 22090.6 |
3847 | 2023-11-05 19:00:51 | abcd | 2 | 29872 | 63 | 0.920 | 32469.6 |
3846 | 2023-11-05 17:20:26 | abcd | 1 | 13983 | 1 | 0.233 | 60012.9 |
3845 | 2023-11-05 13:07:54 | abcd | 1 | 13983 | 1 | 0.233 | 60012.9 |
3844 | 2023-11-02 06:47:51 | abcd | 1 | 13983 | 1 | 0.266 | 52567.7 |
3843 | 2023-10-31 20:09:55 | abcd | 1 | 13983 | 1 | 0.280 | 49939.3 |
3842 | 2023-10-29 23:17:55 | abcd | 1 | 13983 | 1 | 0.250 | 55932.0 |
3841 | 2023-10-25 20:37:58 | abcd | 2 | 29872 | 63 | 0.906 | 32971.3 |
3840 | 2023-10-25 20:37:53 | abcd | 3 | 53901 | 1304 | 2.546 | 21170.9 |
3839 | 2023-10-25 19:11:18 | abcd | 1 | 13983 | 1 | 0.233 | 60012.9 |
3838 | 2023-10-23 15:17:56 | abcd | 1 | 13983 | 1 | 0.233 | 60012.9 |