History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"activates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
972 | 2024-05-31 16:09:07 | activates | 1 | 81242 | 3 | 7.686 | 10570.1 |
971 | 2024-05-30 21:26:43 | activates | 1 | 81242 | 3 | 1.330 | 61084.2 |
970 | 2024-05-11 12:15:44 | activates | 1 | 81242 | 3 | 3.250 | 24997.5 |
969 | 2024-05-07 15:13:17 | activates | 1 | 81242 | 3 | 1.593 | 50999.4 |
968 | 2024-05-04 21:10:24 | activates | 4 | 165329 | 636 | 38.940 | 4245.7 |
967 | 2024-05-03 12:55:17 | activates | 4 | 165329 | 636 | 15.436 | 10710.6 |
966 | 2024-05-01 11:20:11 | activates | 1 | 81242 | 3 | 4.453 | 18244.3 |
965 | 2024-04-30 16:54:18 | activates | 4 | 165329 | 636 | 13.656 | 12106.7 |
964 | 2024-04-29 00:47:59 | activates | 1 | 81242 | 3 | 1.640 | 49537.8 |
963 | 2024-04-19 13:22:08 | activates | 1 | 81242 | 3 | 2.203 | 36877.9 |
962 | 2024-04-11 13:52:58 | activates | 4 | 165329 | 636 | 23.893 | 6919.6 |
961 | 2024-04-09 21:03:23 | activates | 1 | 81242 | 3 | 3.610 | 22504.7 |
960 | 2024-04-06 19:44:22 | activates | 3 | 148641 | 95 | 24.093 | 6169.5 |
959 | 2024-04-04 10:31:45 | activates | 3 | 148641 | 95 | 23.110 | 6431.9 |
958 | 2024-04-04 10:31:46 | activates | 2 | 121436 | 17 | 11.940 | 10170.5 |
957 | 2024-04-04 10:29:01 | activates | 1 | 81242 | 3 | 3.266 | 24875.1 |
956 | 2024-04-03 12:18:52 | activates | 4 | 165329 | 636 | 16.160 | 10230.8 |
955 | 2024-04-03 09:57:15 | activates | 4 | 165329 | 636 | 33.033 | 5005.0 |
954 | 2024-03-31 01:13:49 | activates | 4 | 165329 | 636 | 26.516 | 6235.1 |
953 | 2024-03-30 21:27:16 | activates | 4 | 165329 | 636 | 19.656 | 8411.1 |
952 | 2024-03-30 21:27:15 | activates | 3 | 148641 | 95 | 13.533 | 10983.6 |
951 | 2024-03-30 21:27:17 | activates | 2 | 121436 | 17 | 8.563 | 14181.5 |
950 | 2024-03-30 21:24:50 | activates | 1 | 81242 | 3 | 3.296 | 24648.7 |
949 | 2024-03-29 10:19:14 | activates | 1 | 81242 | 3 | 2.983 | 27235.0 |
948 | 2024-03-06 03:08:08 | activates | 1 | 81242 | 3 | 3.080 | 26377.3 |
947 | 2024-03-06 02:16:33 | activates | 4 | 165329 | 636 | 22.253 | 7429.5 |
946 | 2024-03-05 00:49:58 | activates | 2 | 121436 | 17 | 4.173 | 29100.4 |
945 | 2024-03-03 11:50:00 | activates | 2 | 121436 | 17 | 5.656 | 21470.3 |
944 | 2024-03-03 09:51:28 | activates | 1 | 81242 | 3 | 1.436 | 56575.2 |
943 | 2024-03-01 08:56:17 | activates | 1 | 81242 | 3 | 1.500 | 54161.3 |
942 | 2024-02-29 18:58:07 | activates | 1 | 81242 | 3 | 1.376 | 59042.2 |
941 | 2024-02-29 11:11:09 | activates | 4 | 165329 | 636 | 16.033 | 10311.8 |
940 | 2024-02-28 09:21:16 | activates | 4 | 165329 | 636 | 32.160 | 5140.8 |
939 | 2024-02-28 09:21:14 | activates | 3 | 148641 | 95 | 13.513 | 10999.9 |
938 | 2024-02-28 07:54:32 | activates | 1 | 81242 | 3 | 1.280 | 63470.3 |
937 | 2024-02-17 09:27:25 | activates | 1 | 81242 | 3 | 1.233 | 65889.7 |
936 | 2024-01-29 18:06:22 | activates | 1 | 81242 | 3 | 1.486 | 54671.6 |
935 | 2024-01-29 07:56:51 | activates | 1 | 81242 | 3 | 1.203 | 67532.8 |
934 | 2024-01-24 21:07:23 | activates | 1 | 81242 | 3 | 1.250 | 64993.6 |
933 | 2023-12-28 06:00:04 | activates | 1 | 81242 | 3 | 1.330 | 61084.2 |
932 | 2023-12-26 20:58:26 | activates | 4 | 165329 | 636 | 12.470 | 13258.1 |
931 | 2023-12-05 17:33:11 | activates | 1 | 81242 | 3 | 1.250 | 64993.6 |
930 | 2023-11-24 18:20:58 | activates | 4 | 165329 | 636 | 45.033 | 3671.3 |
929 | 2023-11-19 12:30:28 | activates | 1 | 81242 | 3 | 1.266 | 64172.2 |
928 | 2023-10-22 23:18:16 | activates | 3 | 148641 | 95 | 6.110 | 24327.5 |
927 | 2023-10-11 22:53:29 | activates | 1 | 81242 | 3 | 1.343 | 60492.9 |
926 | 2023-09-13 01:27:55 | activates | 4 | 165329 | 636 | 10.546 | 15676.9 |
925 | 2023-09-06 15:19:12 | activates | 1 | 81242 | 3 | 1.360 | 59736.8 |
924 | 2023-08-26 17:15:57 | activates | 4 | 165329 | 636 | 11.313 | 14614.1 |
923 | 2023-08-16 07:03:31 | activates | 4 | 165329 | 636 | 11.220 | 14735.2 |
922 | 2023-07-23 15:50:32 | activates | 4 | 165329 | 636 | 11.623 | 14224.3 |
921 | 2023-07-23 15:44:08 | activates | 4 | 165329 | 636 | 10.360 | 15958.4 |
920 | 2023-07-15 21:28:03 | activates | 4 | 165329 | 636 | 11.423 | 14473.3 |
919 | 2023-06-24 20:24:38 | activates | 1 | 81242 | 3 | 1.373 | 59171.2 |
918 | 2023-06-23 09:02:49 | activates | 3 | 148641 | 95 | 7.063 | 21045.0 |
917 | 2023-06-17 02:18:52 | activates | 3 | 148641 | 95 | 6.093 | 24395.4 |
916 | 2023-06-15 18:15:26 | activates | 3 | 148641 | 95 | 6.436 | 23095.2 |
915 | 2023-06-14 21:20:37 | activates | 3 | 148641 | 95 | 6.780 | 21923.5 |
914 | 2023-06-13 17:13:52 | activates | 3 | 148641 | 95 | 7.406 | 20070.3 |
913 | 2023-06-11 21:28:09 | activates | 3 | 148641 | 95 | 13.156 | 11298.3 |
912 | 2023-06-09 20:11:41 | activates | 1 | 81242 | 3 | 1.376 | 59042.2 |
911 | 2023-05-28 17:39:00 | activates | 4 | 165329 | 636 | 10.966 | 15076.5 |
910 | 2023-04-17 11:56:38 | activates | 4 | 165329 | 636 | 10.250 | 16129.7 |
909 | 2023-03-29 05:50:05 | activates | 1 | 81242 | 3 | 2.703 | 30056.2 |
908 | 2023-03-12 14:47:38 | activates | 1 | 81242 | 3 | 1.360 | 59736.8 |
907 | 2023-02-15 04:27:34 | activates | 4 | 165329 | 636 | 19.330 | 8553.0 |
906 | 2023-02-08 14:13:19 | activates | 4 | 165329 | 636 | 11.376 | 14533.1 |
905 | 2023-01-24 01:51:11 | activates | 4 | 165329 | 636 | 10.420 | 15866.5 |
904 | 2023-01-11 23:44:35 | activates | 1 | 81242 | 3 | 1.220 | 66591.8 |
903 | 2022-12-26 20:38:14 | activates | 4 | 165329 | 636 | 11.736 | 14087.3 |
902 | 2022-12-06 05:05:32 | activates | 4 | 165329 | 636 | 11.923 | 13866.4 |
901 | 2022-12-05 20:58:10 | activates | 4 | 165329 | 636 | 15.233 | 10853.3 |
900 | 2022-11-21 01:20:48 | activates | 1 | 81242 | 3 | 1.236 | 65729.8 |
899 | 2022-11-17 22:23:27 | activates | 4 | 165329 | 636 | 10.580 | 15626.6 |
898 | 2022-11-16 10:34:43 | activates | 4 | 165329 | 636 | 12.063 | 13705.5 |
897 | 2022-11-10 06:07:52 | activates | 4 | 165329 | 636 | 10.406 | 15887.9 |
896 | 2022-11-07 11:16:28 | activates | 4 | 165329 | 636 | 11.080 | 14921.4 |
895 | 2022-10-20 23:13:31 | activates | 1 | 81242 | 3 | 1.420 | 57212.7 |
894 | 2022-10-19 07:33:41 | activates | 4 | 165329 | 636 | 11.860 | 13940.1 |
893 | 2022-09-19 10:30:14 | activates | 4 | 165329 | 636 | 11.233 | 14718.2 |
892 | 2022-09-14 08:09:54 | activates | 1 | 81242 | 3 | 1.250 | 64993.6 |
891 | 2022-09-08 16:44:52 | activates | 4 | 165329 | 636 | 11.596 | 14257.4 |
890 | 2022-09-05 15:25:52 | activates | 4 | 165329 | 636 | 12.470 | 13258.1 |
889 | 2022-08-28 05:18:48 | activates | 1 | 81242 | 3 | 1.326 | 61268.5 |
888 | 2022-08-19 11:29:13 | activates | 4 | 165329 | 636 | 10.250 | 16129.7 |
887 | 2022-07-28 06:23:04 | activates | 1 | 81242 | 3 | 1.233 | 65889.7 |
886 | 2022-07-15 12:01:55 | activates | 4 | 165329 | 636 | 10.986 | 15049.1 |
885 | 2022-07-09 00:37:42 | activates | 4 | 165329 | 636 | 11.063 | 14944.3 |
884 | 2022-06-11 16:23:37 | activates | 1 | 81242 | 3 | 1.300 | 62493.8 |
883 | 2022-06-09 19:34:16 | activates | 3 | 148641 | 95 | 7.030 | 21143.8 |
882 | 2022-06-09 10:46:04 | activates | 1 | 81242 | 3 | 1.220 | 66591.8 |
881 | 2022-06-04 10:52:19 | activates | 4 | 165329 | 636 | 10.720 | 15422.5 |
880 | 2022-05-28 11:13:57 | activates | 4 | 165329 | 636 | 10.373 | 15938.4 |
879 | 2022-05-26 01:05:42 | activates | 4 | 165329 | 636 | 10.483 | 15771.2 |
878 | 2022-05-15 20:21:26 | activates | 3 | 148641 | 95 | 6.173 | 24079.2 |
877 | 2022-05-12 01:37:48 | activates | 3 | 148641 | 95 | 7.126 | 20859.0 |
876 | 2022-05-10 07:12:30 | activates | 4 | 165329 | 636 | 11.563 | 14298.1 |
875 | 2022-04-27 04:31:50 | activates | 4 | 165329 | 636 | 12.360 | 13376.1 |
874 | 2022-04-26 11:26:35 | activates | 4 | 165329 | 636 | 10.893 | 15177.5 |
873 | 2022-04-24 04:42:59 | activates | 4 | 165329 | 636 | 10.466 | 15796.8 |