History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"metro"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
994 | 2024-04-17 07:04:01 | metro | 1 | 28756 | 4 | 0.686 | 41918.4 |
993 | 2024-04-14 18:06:28 | metro | 1 | 28756 | 4 | 1.186 | 24246.2 |
992 | 2024-04-02 20:36:50 | metro | 1 | 28756 | 4 | 0.453 | 63479.0 |
991 | 2024-03-31 15:41:32 | metro | 1 | 28756 | 4 | 0.563 | 51076.4 |
990 | 2024-03-27 07:57:19 | metro | 1 | 28756 | 4 | 1.123 | 25606.4 |
989 | 2024-03-16 06:43:12 | metro | 1 | 28756 | 4 | 1.593 | 18051.5 |
988 | 2024-03-09 02:48:31 | metro | 1 | 28756 | 4 | 0.436 | 65954.1 |
987 | 2024-03-02 18:03:01 | metro | 3 | 83667 | 856 | 9.343 | 8955.0 |
986 | 2024-03-02 18:03:00 | metro | 2 | 53800 | 61 | 4.873 | 11040.4 |
985 | 2024-03-02 17:52:19 | metro | 1 | 28756 | 4 | 0.550 | 52283.6 |
984 | 2024-03-01 11:32:34 | metro | 1 | 28756 | 4 | 0.486 | 59168.7 |
983 | 2024-02-26 02:00:49 | metro | 1 | 28756 | 4 | 1.673 | 17188.3 |
982 | 2024-02-15 23:52:43 | metro | 1 | 28756 | 4 | 0.453 | 63479.0 |
981 | 2024-02-11 06:59:08 | metro | 2 | 53800 | 61 | 5.626 | 9562.7 |
980 | 2024-02-11 06:54:06 | metro | 3 | 83667 | 856 | 9.266 | 9029.5 |
979 | 2024-02-08 18:02:36 | metro | 2 | 53800 | 61 | 1.513 | 35558.5 |
978 | 2024-02-08 18:02:03 | metro | 3 | 83667 | 856 | 6.563 | 12748.3 |
977 | 2024-02-08 08:02:21 | metro | 3 | 83667 | 856 | 7.050 | 11867.7 |
976 | 2024-01-29 02:50:47 | metro | 1 | 28756 | 4 | 0.483 | 59536.2 |
975 | 2024-01-26 21:11:21 | metro | 1 | 28756 | 4 | 0.500 | 57512.0 |
974 | 2024-01-23 12:00:09 | metro | 1 | 28756 | 4 | 0.440 | 65354.5 |
973 | 2023-12-12 09:38:06 | metro | 3 | 83667 | 856 | 5.656 | 14792.6 |
972 | 2023-12-12 09:38:07 | metro | 2 | 53800 | 61 | 1.563 | 34421.0 |
971 | 2023-12-11 16:22:30 | metro | 3 | 83667 | 856 | 3.623 | 23093.3 |
970 | 2023-12-11 16:22:27 | metro | 2 | 53800 | 61 | 1.470 | 36598.6 |
969 | 2023-11-29 09:02:31 | metro | 3 | 83667 | 856 | 3.466 | 24139.4 |
968 | 2023-11-29 09:02:29 | metro | 2 | 53800 | 61 | 1.470 | 36598.6 |
967 | 2023-11-18 21:56:23 | metro | 1 | 28756 | 4 | 0.500 | 57512.0 |
966 | 2023-11-11 09:55:30 | metro | 1 | 28756 | 4 | 0.466 | 61708.2 |
965 | 2023-11-11 01:14:48 | metro | 1 | 28756 | 4 | 0.483 | 59536.2 |
964 | 2023-10-27 15:56:37 | metro | 1 | 28756 | 4 | 0.530 | 54256.6 |
963 | 2023-10-23 19:46:25 | metro | 1 | 28756 | 4 | 0.500 | 57512.0 |
962 | 2023-10-20 17:53:40 | metro | 1 | 28756 | 4 | 0.486 | 59168.7 |
961 | 2023-10-17 23:47:05 | metro | 1 | 28756 | 4 | 0.456 | 63061.4 |
960 | 2023-10-11 19:54:08 | metro | 1 | 28756 | 4 | 0.453 | 63479.0 |
959 | 2023-10-04 12:49:07 | metro | 1 | 28756 | 4 | 0.500 | 57512.0 |
958 | 2023-09-25 18:57:42 | metro | 1 | 28756 | 4 | 0.440 | 65354.5 |
957 | 2023-09-20 19:26:25 | metro | 1 | 28756 | 4 | 0.483 | 59536.2 |
956 | 2023-09-14 19:06:03 | metro | 2 | 53800 | 61 | 1.403 | 38346.4 |
955 | 2023-09-12 15:52:12 | metro | 3 | 83667 | 856 | 3.766 | 22216.4 |
954 | 2023-09-10 20:21:33 | metro | 3 | 83667 | 856 | 3.720 | 22491.1 |
953 | 2023-09-10 14:41:09 | metro | 3 | 83667 | 856 | 3.873 | 21602.6 |
952 | 2023-09-09 20:03:24 | metro | 3 | 83667 | 856 | 3.376 | 24782.9 |
951 | 2023-09-08 08:10:21 | metro | 3 | 83667 | 856 | 3.296 | 25384.4 |
950 | 2023-09-05 06:19:27 | metro | 1 | 28756 | 4 | 0.436 | 65954.1 |
949 | 2023-09-05 02:37:12 | metro | 3 | 83667 | 856 | 4.000 | 20916.8 |
948 | 2023-09-03 14:40:38 | metro | 3 | 83667 | 856 | 3.546 | 23594.8 |
947 | 2023-09-03 05:39:06 | metro | 3 | 83667 | 856 | 3.970 | 21074.8 |
946 | 2023-09-02 01:02:09 | metro | 3 | 83667 | 856 | 3.766 | 22216.4 |
945 | 2023-08-30 23:07:00 | metro | 3 | 83667 | 856 | 3.500 | 23904.9 |
944 | 2023-08-19 12:17:12 | metro | 3 | 83667 | 856 | 4.640 | 18031.7 |
943 | 2023-07-03 04:13:41 | metro | 1 | 28756 | 4 | 0.890 | 32310.1 |
942 | 2023-06-07 07:58:01 | metro | 1 | 28756 | 4 | 0.486 | 59168.7 |
941 | 2023-04-01 14:57:42 | metro | 3 | 83667 | 856 | 3.813 | 21942.6 |
940 | 2023-03-27 12:36:17 | metro | 1 | 28756 | 4 | 0.436 | 65954.1 |
939 | 2023-03-13 09:27:15 | metro | 1 | 28756 | 4 | 0.686 | 41918.4 |
938 | 2023-02-16 17:47:33 | metro | 3 | 83667 | 856 | 3.643 | 22966.5 |
937 | 2023-01-11 10:02:21 | metro | 1 | 28756 | 4 | 0.423 | 67981.1 |
936 | 2022-12-25 03:33:34 | metro | 3 | 83667 | 856 | 3.673 | 22778.9 |
935 | 2022-12-06 00:20:46 | metro | 2 | 53800 | 61 | 2.766 | 19450.5 |
934 | 2022-11-21 20:22:29 | metro | 1 | 28756 | 4 | 0.496 | 57975.8 |
933 | 2022-11-14 05:29:20 | metro | 3 | 83667 | 856 | 3.983 | 21006.0 |
932 | 2022-11-08 09:17:42 | metro | 3 | 83667 | 856 | 3.266 | 25617.6 |
931 | 2022-11-08 08:23:48 | metro | 3 | 83667 | 856 | 4.013 | 20849.0 |
930 | 2022-11-04 05:18:12 | metro | 3 | 83667 | 856 | 3.890 | 21508.2 |
929 | 2022-10-23 23:08:20 | metro | 2 | 53800 | 61 | 1.346 | 39970.3 |
928 | 2022-10-20 02:38:45 | metro | 1 | 28756 | 4 | 0.483 | 59536.2 |
927 | 2022-09-24 12:53:37 | metro | 3 | 83667 | 856 | 3.250 | 25743.7 |
926 | 2022-09-18 18:17:20 | metro | 2 | 53800 | 61 | 1.373 | 39184.3 |
925 | 2022-09-18 18:16:29 | metro | 3 | 83667 | 856 | 3.673 | 22778.9 |
924 | 2022-09-12 08:57:31 | metro | 1 | 28756 | 4 | 0.436 | 65954.1 |
923 | 2022-09-04 01:06:46 | metro | 3 | 83667 | 856 | 3.750 | 22311.2 |
922 | 2022-08-30 16:45:45 | metro | 3 | 83667 | 856 | 3.856 | 21697.9 |
921 | 2022-08-23 22:29:36 | metro | 2 | 53800 | 61 | 1.346 | 39970.3 |
920 | 2022-08-07 02:43:23 | metro | 3 | 83667 | 856 | 3.330 | 25125.2 |
919 | 2022-08-07 00:05:52 | metro | 1 | 28756 | 4 | 0.486 | 59168.7 |
918 | 2022-08-01 12:51:44 | metro | 1 | 28756 | 4 | 0.483 | 59536.2 |
917 | 2022-07-30 01:35:19 | metro | 1 | 28756 | 4 | 0.500 | 57512.0 |
916 | 2022-07-29 15:39:35 | metro | 3 | 83667 | 856 | 3.656 | 22884.8 |
915 | 2022-07-29 00:23:15 | metro | 1 | 28756 | 4 | 0.436 | 65954.1 |
914 | 2022-07-17 22:01:24 | metro | 1 | 28756 | 4 | 0.546 | 52666.7 |
913 | 2022-07-17 17:27:40 | metro | 1 | 28756 | 4 | 0.500 | 57512.0 |
912 | 2022-06-07 16:18:09 | metro | 1 | 28756 | 4 | 0.436 | 65954.1 |
911 | 2022-04-03 13:26:55 | metro | 1 | 28756 | 4 | 0.436 | 65954.1 |
910 | 2022-02-13 04:16:00 | metro | 1 | 28756 | 4 | 0.500 | 57512.0 |
909 | 2022-02-12 10:01:56 | metro | 1 | 28756 | 4 | 0.513 | 56054.6 |
908 | 2021-12-23 01:00:33 | metro | 1 | 28756 | 4 | 0.466 | 61708.2 |
907 | 2021-12-14 14:10:25 | metro | 1 | 28756 | 4 | 0.906 | 31739.5 |
906 | 2021-11-28 12:02:23 | metro | 1 | 28756 | 4 | 0.483 | 59536.2 |
905 | 2021-11-15 07:58:49 | metro | 1 | 28756 | 4 | 0.610 | 47141.0 |
904 | 2021-10-14 04:09:13 | metro | 1 | 28756 | 4 | 0.483 | 59536.2 |
903 | 2021-10-12 02:54:49 | metro | 1 | 28756 | 4 | 0.453 | 63479.0 |
902 | 2021-09-21 01:06:10 | metro | 1 | 28756 | 4 | 0.483 | 59536.2 |
901 | 2021-09-12 14:26:10 | metro | 1 | 28756 | 4 | 0.423 | 67981.1 |
900 | 2021-07-26 16:48:03 | metro | 1 | 28756 | 4 | 0.483 | 59536.2 |
899 | 2021-06-29 21:58:36 | metro | 2 | 53800 | 61 | 3.360 | 16011.9 |
898 | 2021-06-12 10:01:32 | metro | 1 | 28756 | 4 | 0.436 | 65954.1 |
897 | 2021-05-19 15:46:35 | metro | 2 | 53800 | 61 | 1.376 | 39098.8 |
896 | 2021-05-17 05:38:30 | metro | 1 | 28756 | 4 | 0.470 | 61183.0 |
895 | 2021-05-11 19:50:09 | metro | 1 | 28756 | 4 | 0.516 | 55728.7 |