History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"field"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
971 | 2024-04-06 05:58:00 | field | 1 | 28756 | 9 | 0.533 | 53951.2 |
970 | 2024-03-31 15:14:18 | field | 1 | 28756 | 9 | 0.513 | 56054.6 |
969 | 2024-03-31 09:08:50 | field | 2 | 53800 | 99 | 3.563 | 15099.6 |
968 | 2024-03-30 20:10:01 | field | 3 | 83667 | 1141 | 13.750 | 6084.9 |
967 | 2024-03-30 13:23:24 | field | 2 | 53800 | 99 | 1.690 | 31834.3 |
966 | 2024-03-30 13:22:57 | field | 3 | 83667 | 1141 | 3.923 | 21327.3 |
965 | 2024-03-29 05:21:00 | field | 3 | 83667 | 1141 | 4.326 | 19340.5 |
964 | 2024-03-29 05:21:01 | field | 2 | 53800 | 99 | 1.733 | 31044.4 |
963 | 2024-03-29 05:20:30 | field | 1 | 28756 | 9 | 0.513 | 56054.6 |
962 | 2024-03-29 05:20:20 | field | 3 | 83667 | 1141 | 6.156 | 13591.1 |
961 | 2024-03-29 05:20:22 | field | 2 | 53800 | 99 | 3.470 | 15504.3 |
960 | 2024-03-29 05:20:18 | field | 1 | 28756 | 9 | 0.516 | 55728.7 |
959 | 2024-03-07 04:29:18 | field | 1 | 28756 | 9 | 1.670 | 17219.2 |
958 | 2024-03-01 12:13:50 | field | 1 | 28756 | 9 | 0.436 | 65954.1 |
957 | 2024-02-29 06:51:19 | field | 2 | 53800 | 99 | 3.233 | 16640.9 |
956 | 2024-02-29 06:50:45 | field | 3 | 83667 | 1141 | 7.000 | 11952.4 |
955 | 2024-02-28 01:49:07 | field | 2 | 53800 | 99 | 1.656 | 32487.9 |
954 | 2024-02-27 22:52:45 | field | 3 | 83667 | 1141 | 10.750 | 7783.0 |
953 | 2024-02-27 22:51:24 | field | 3 | 83667 | 1141 | 6.203 | 13488.2 |
952 | 2024-02-27 22:51:22 | field | 2 | 53800 | 99 | 3.750 | 14346.7 |
951 | 2024-02-27 20:44:56 | field | 1 | 28756 | 9 | 0.500 | 57512.0 |
950 | 2024-02-03 20:40:43 | field | 1 | 28756 | 9 | 0.486 | 59168.7 |
949 | 2024-01-29 08:10:11 | field | 1 | 28756 | 9 | 0.470 | 61183.0 |
948 | 2024-01-28 17:14:53 | field | 1 | 28756 | 9 | 0.440 | 65354.5 |
947 | 2024-01-14 05:58:44 | field | 1 | 28756 | 9 | 0.986 | 29164.3 |
946 | 2024-01-12 12:10:28 | field | 1 | 28756 | 9 | 0.500 | 57512.0 |
945 | 2024-01-05 15:32:20 | field | 3 | 83667 | 1141 | 3.250 | 25743.7 |
944 | 2024-01-02 13:12:49 | field | 3 | 83667 | 1141 | 3.563 | 23482.2 |
943 | 2023-12-29 20:11:53 | field | 3 | 83667 | 1141 | 3.750 | 22311.2 |
942 | 2023-12-26 19:16:22 | field | 2 | 53800 | 99 | 1.670 | 32215.6 |
941 | 2023-12-25 22:10:35 | field | 2 | 53800 | 99 | 1.763 | 30516.2 |
940 | 2023-12-25 18:19:45 | field | 3 | 83667 | 1141 | 3.576 | 23396.8 |
939 | 2023-12-23 08:31:44 | field | 3 | 83667 | 1141 | 3.283 | 25484.9 |
938 | 2023-11-18 18:01:09 | field | 3 | 83667 | 1141 | 3.483 | 24021.5 |
937 | 2023-11-13 23:46:37 | field | 1 | 28756 | 9 | 0.453 | 63479.0 |
936 | 2023-11-13 04:10:00 | field | 1 | 28756 | 9 | 0.466 | 61708.2 |
935 | 2023-11-12 19:44:36 | field | 3 | 83667 | 1141 | 3.623 | 23093.3 |
934 | 2023-11-12 19:44:30 | field | 2 | 53800 | 99 | 1.593 | 33772.8 |
933 | 2023-11-06 09:40:06 | field | 1 | 28756 | 9 | 0.423 | 67981.1 |
932 | 2023-11-04 02:24:30 | field | 1 | 28756 | 9 | 0.610 | 47141.0 |
931 | 2023-10-21 09:08:22 | field | 1 | 28756 | 9 | 0.483 | 59536.2 |
930 | 2023-10-17 20:12:05 | field | 1 | 28756 | 9 | 1.076 | 26724.9 |
929 | 2023-10-13 20:34:31 | field | 1 | 28756 | 9 | 0.500 | 57512.0 |
928 | 2023-10-05 02:25:00 | field | 1 | 28756 | 9 | 0.440 | 65354.5 |
927 | 2023-09-24 06:38:06 | field | 1 | 28756 | 9 | 0.436 | 65954.1 |
926 | 2023-09-23 23:50:26 | field | 1 | 28756 | 9 | 0.470 | 61183.0 |
925 | 2023-09-22 15:47:11 | field | 1 | 28756 | 9 | 0.453 | 63479.0 |
924 | 2023-08-29 05:43:07 | field | 1 | 28756 | 9 | 0.436 | 65954.1 |
923 | 2023-06-10 12:03:39 | field | 1 | 28756 | 9 | 0.470 | 61183.0 |
922 | 2023-06-10 11:58:30 | field | 1 | 28756 | 9 | 0.420 | 68466.7 |
921 | 2023-05-29 13:19:30 | field | 1 | 28756 | 9 | 0.423 | 67981.1 |
920 | 2023-03-24 07:01:26 | field | 1 | 28756 | 9 | 0.500 | 57512.0 |
919 | 2023-02-25 17:54:42 | field | 1 | 28756 | 9 | 0.470 | 61183.0 |
918 | 2023-01-09 03:00:51 | field | 1 | 28756 | 9 | 0.436 | 65954.1 |
917 | 2022-11-08 22:16:13 | field | 1 | 28756 | 9 | 0.453 | 63479.0 |
916 | 2022-10-13 23:27:31 | field | 1 | 28756 | 9 | 0.423 | 67981.1 |
915 | 2022-07-19 14:18:03 | field | 1 | 28756 | 9 | 0.436 | 65954.1 |
914 | 2022-07-05 05:03:25 | field | 2 | 53800 | 99 | 1.330 | 40451.1 |
913 | 2022-05-30 21:23:39 | field | 1 | 28756 | 9 | 0.423 | 67981.1 |
912 | 2022-04-19 02:40:47 | field | 3 | 83667 | 1141 | 4.203 | 19906.5 |
911 | 2022-03-22 02:45:37 | field | 1 | 28756 | 9 | 0.596 | 48248.3 |
910 | 2022-03-18 16:19:09 | field | 1 | 28756 | 9 | 0.453 | 63479.0 |
909 | 2022-02-16 09:04:52 | field | 1 | 28756 | 9 | 0.436 | 65954.1 |
908 | 2022-01-27 08:14:49 | field | 3 | 83667 | 1141 | 3.653 | 22903.6 |
907 | 2022-01-06 11:07:18 | field | 1 | 28756 | 9 | 0.546 | 52666.7 |
906 | 2021-12-26 20:11:07 | field | 3 | 83667 | 1141 | 3.420 | 24464.0 |
905 | 2021-12-08 05:02:59 | field | 1 | 28756 | 9 | 0.420 | 68466.7 |
904 | 2021-12-03 14:24:37 | field | 1 | 28756 | 9 | 0.513 | 56054.6 |
903 | 2021-11-12 17:11:05 | field | 3 | 83667 | 1141 | 4.016 | 20833.4 |
902 | 2021-10-13 01:39:22 | field | 1 | 28756 | 9 | 0.420 | 68466.7 |
901 | 2021-10-09 22:42:02 | field | 3 | 83667 | 1141 | 3.736 | 22394.8 |
900 | 2021-10-09 09:25:38 | field | 3 | 83667 | 1141 | 4.750 | 17614.1 |
899 | 2021-10-08 18:54:18 | field | 3 | 83667 | 1141 | 3.626 | 23074.2 |
898 | 2021-10-08 09:35:00 | field | 3 | 83667 | 1141 | 3.720 | 22491.1 |
897 | 2021-10-07 18:12:45 | field | 3 | 83667 | 1141 | 3.220 | 25983.5 |
896 | 2021-10-07 12:10:47 | field | 3 | 83667 | 1141 | 4.623 | 18098.0 |
895 | 2021-10-07 12:06:47 | field | 3 | 83667 | 1141 | 3.736 | 22394.8 |
894 | 2021-10-06 19:07:29 | field | 3 | 83667 | 1141 | 3.250 | 25743.7 |
893 | 2021-10-06 12:35:01 | field | 3 | 83667 | 1141 | 4.233 | 19765.4 |
892 | 2021-10-05 16:49:57 | field | 3 | 83667 | 1141 | 3.753 | 22293.4 |
891 | 2021-10-05 14:26:02 | field | 3 | 83667 | 1141 | 4.143 | 20194.8 |
890 | 2021-10-04 21:33:46 | field | 3 | 83667 | 1141 | 3.516 | 23796.1 |
889 | 2021-10-04 12:36:25 | field | 3 | 83667 | 1141 | 3.813 | 21942.6 |
888 | 2021-10-03 18:33:00 | field | 3 | 83667 | 1141 | 3.706 | 22576.1 |
887 | 2021-10-03 09:30:04 | field | 3 | 83667 | 1141 | 3.250 | 25743.7 |
886 | 2021-10-02 18:14:50 | field | 3 | 83667 | 1141 | 3.766 | 22216.4 |
885 | 2021-10-02 10:54:34 | field | 3 | 83667 | 1141 | 5.593 | 14959.2 |
884 | 2021-09-30 10:00:24 | field | 3 | 83667 | 1141 | 4.013 | 20849.0 |
883 | 2021-09-08 20:18:40 | field | 3 | 83667 | 1141 | 3.203 | 26121.4 |
882 | 2021-09-07 08:55:01 | field | 1 | 28756 | 9 | 0.486 | 59168.7 |
881 | 2021-09-04 17:16:04 | field | 1 | 28756 | 9 | 0.420 | 68466.7 |
880 | 2021-09-03 19:43:30 | field | 3 | 83667 | 1141 | 3.703 | 22594.4 |
879 | 2021-09-02 10:48:18 | field | 1 | 28756 | 9 | 0.436 | 65954.1 |
878 | 2021-08-18 03:30:01 | field | 1 | 28756 | 9 | 0.470 | 61183.0 |
877 | 2021-08-15 22:40:01 | field | 1 | 28756 | 9 | 0.453 | 63479.0 |
876 | 2021-08-09 19:24:48 | field | 3 | 83667 | 1141 | 3.330 | 25125.2 |
875 | 2021-08-05 21:23:11 | field | 3 | 83667 | 1141 | 3.670 | 22797.5 |
874 | 2021-07-14 06:20:24 | field | 2 | 53800 | 99 | 1.560 | 34487.2 |
873 | 2021-06-21 22:27:39 | field | 1 | 28756 | 9 | 0.453 | 63479.0 |
872 | 2021-06-11 08:20:20 | field | 3 | 83667 | 1141 | 3.190 | 26227.9 |