History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"barns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1027 | 2024-05-04 01:21:30 | barns | 1 | 28756 | 23 | 1.096 | 26237.2 |
1026 | 2024-04-13 16:15:57 | barns | 1 | 28756 | 23 | 0.436 | 65954.1 |
1025 | 2024-04-03 09:09:30 | barns | 1 | 28756 | 23 | 1.580 | 18200.0 |
1024 | 2024-04-03 09:09:14 | barns | 2 | 53800 | 331 | 3.826 | 14061.7 |
1023 | 2024-04-03 03:34:27 | barns | 2 | 53800 | 331 | 3.670 | 14659.4 |
1022 | 2024-04-03 03:28:30 | barns | 1 | 28756 | 23 | 0.576 | 49923.6 |
1021 | 2024-04-02 04:06:48 | barns | 1 | 28756 | 23 | 0.576 | 49923.6 |
1020 | 2024-04-01 12:59:40 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
1019 | 2024-03-31 15:28:09 | barns | 1 | 28756 | 23 | 0.533 | 53951.2 |
1018 | 2024-03-31 02:34:29 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
1017 | 2024-03-30 21:30:59 | barns | 1 | 28756 | 23 | 1.733 | 16593.2 |
1016 | 2024-03-29 17:53:59 | barns | 1 | 28756 | 23 | 0.516 | 55728.7 |
1015 | 2024-03-28 01:48:00 | barns | 1 | 28756 | 23 | 0.516 | 55728.7 |
1014 | 2024-03-28 01:11:05 | barns | 1 | 28756 | 23 | 1.143 | 25158.4 |
1013 | 2024-03-27 01:50:53 | barns | 1 | 28756 | 23 | 0.533 | 53951.2 |
1012 | 2024-03-12 05:09:00 | barns | 1 | 28756 | 23 | 1.550 | 18552.3 |
1011 | 2024-03-04 07:36:20 | barns | 2 | 53800 | 331 | 1.983 | 27130.6 |
1010 | 2024-03-03 23:36:51 | barns | 2 | 53800 | 331 | 3.906 | 13773.7 |
1009 | 2024-03-03 22:11:40 | barns | 1 | 28756 | 23 | 0.610 | 47141.0 |
1008 | 2024-02-29 23:59:28 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
1007 | 2024-02-29 20:25:07 | barns | 1 | 28756 | 23 | 0.550 | 52283.6 |
1006 | 2024-02-25 17:58:49 | barns | 1 | 28756 | 23 | 0.560 | 51350.0 |
1005 | 2024-02-17 08:06:27 | barns | 1 | 28756 | 23 | 0.436 | 65954.1 |
1004 | 2024-02-16 09:31:44 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
1003 | 2024-02-15 01:35:07 | barns | 1 | 28756 | 23 | 1.170 | 24577.8 |
1002 | 2024-02-14 05:31:31 | barns | 1 | 28756 | 23 | 0.563 | 51076.4 |
1001 | 2024-02-13 09:40:43 | barns | 1 | 28756 | 23 | 0.563 | 51076.4 |
1000 | 2024-02-11 05:30:51 | barns | 1 | 28756 | 23 | 0.466 | 61708.2 |
999 | 2024-02-10 14:23:25 | barns | 1 | 28756 | 23 | 1.093 | 26309.2 |
998 | 2024-02-09 14:50:37 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
997 | 2024-02-08 20:50:04 | barns | 1 | 28756 | 23 | 0.560 | 51350.0 |
996 | 2024-01-17 13:41:27 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
995 | 2023-12-30 22:09:06 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
994 | 2023-12-22 06:47:39 | barns | 2 | 53800 | 331 | 1.436 | 37465.2 |
993 | 2023-12-19 17:54:29 | barns | 1 | 28756 | 23 | 0.890 | 32310.1 |
992 | 2023-12-19 14:24:58 | barns | 1 | 28756 | 23 | 0.750 | 38341.3 |
991 | 2023-12-18 04:52:28 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
990 | 2023-12-15 19:27:25 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
989 | 2023-12-15 14:57:23 | barns | 1 | 28756 | 23 | 0.516 | 55728.7 |
988 | 2023-12-14 12:22:32 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
987 | 2023-12-04 12:02:52 | barns | 2 | 53800 | 331 | 1.546 | 34799.5 |
986 | 2023-12-04 12:02:50 | barns | 2 | 53800 | 331 | 1.503 | 35795.1 |
985 | 2023-12-04 06:25:14 | barns | 2 | 53800 | 331 | 1.546 | 34799.5 |
984 | 2023-12-03 21:41:35 | barns | 1 | 28756 | 23 | 0.516 | 55728.7 |
983 | 2023-12-01 23:27:47 | barns | 1 | 28756 | 23 | 0.516 | 55728.7 |
982 | 2023-11-27 10:35:14 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
981 | 2023-11-26 01:15:32 | barns | 2 | 53800 | 331 | 1.406 | 38264.6 |
980 | 2023-11-14 09:57:59 | barns | 1 | 28756 | 23 | 0.486 | 59168.7 |
979 | 2023-11-12 02:13:44 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
978 | 2023-11-10 18:41:57 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
977 | 2023-11-02 07:05:36 | barns | 1 | 28756 | 23 | 1.123 | 25606.4 |
976 | 2023-11-02 07:05:24 | barns | 1 | 28756 | 23 | 0.673 | 42728.1 |
975 | 2023-11-01 13:40:21 | barns | 2 | 53800 | 331 | 1.563 | 34421.0 |
974 | 2023-10-27 10:16:48 | barns | 1 | 28756 | 23 | 0.483 | 59536.2 |
973 | 2023-10-21 22:41:27 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
972 | 2023-10-20 21:26:20 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
971 | 2023-10-17 21:05:27 | barns | 1 | 28756 | 23 | 0.533 | 53951.2 |
970 | 2023-10-17 15:37:55 | barns | 2 | 53800 | 331 | 1.706 | 31535.8 |
969 | 2023-10-11 00:24:22 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
968 | 2023-10-03 15:45:23 | barns | 1 | 28756 | 23 | 0.483 | 59536.2 |
967 | 2023-09-22 16:50:44 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
966 | 2023-09-12 11:39:55 | barns | 1 | 28756 | 23 | 0.546 | 52666.7 |
965 | 2023-08-26 12:18:46 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
964 | 2023-08-18 02:14:12 | barns | 1 | 28756 | 23 | 0.436 | 65954.1 |
963 | 2023-06-26 12:34:13 | barns | 1 | 28756 | 23 | 0.436 | 65954.1 |
962 | 2023-05-23 04:08:25 | barns | 1 | 28756 | 23 | 0.486 | 59168.7 |
961 | 2023-05-19 11:39:58 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
960 | 2023-03-26 22:12:08 | barns | 1 | 28756 | 23 | 0.483 | 59536.2 |
959 | 2023-03-17 13:31:15 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
958 | 2023-02-20 11:59:17 | barns | 1 | 28756 | 23 | 0.436 | 65954.1 |
957 | 2023-01-03 18:22:48 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
956 | 2022-11-17 15:52:26 | barns | 1 | 28756 | 23 | 0.470 | 61183.0 |
955 | 2022-11-14 01:04:23 | barns | 1 | 28756 | 23 | 0.533 | 53951.2 |
954 | 2022-09-29 07:07:40 | barns | 1 | 28756 | 23 | 0.516 | 55728.7 |
953 | 2022-09-01 15:05:38 | barns | 1 | 28756 | 23 | 0.453 | 63479.0 |
952 | 2022-08-27 17:21:43 | barns | 1 | 28756 | 23 | 0.436 | 65954.1 |
951 | 2022-08-23 04:41:29 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
950 | 2022-08-10 20:31:14 | barns | 1 | 28756 | 23 | 0.530 | 54256.6 |
949 | 2022-07-10 18:08:17 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
948 | 2022-05-31 08:33:13 | barns | 1 | 28756 | 23 | 0.483 | 59536.2 |
947 | 2022-05-18 11:21:46 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
946 | 2022-05-17 16:45:29 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
945 | 2022-05-16 20:59:52 | barns | 1 | 28756 | 23 | 0.826 | 34813.6 |
944 | 2022-05-16 02:19:37 | barns | 1 | 28756 | 23 | 0.530 | 54256.6 |
943 | 2022-05-14 19:17:03 | barns | 1 | 28756 | 23 | 0.466 | 61708.2 |
942 | 2022-05-14 01:25:21 | barns | 1 | 28756 | 23 | 0.673 | 42728.1 |
941 | 2022-05-12 20:15:05 | barns | 1 | 28756 | 23 | 0.703 | 40904.7 |
940 | 2022-05-11 14:15:36 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
939 | 2022-05-11 02:51:51 | barns | 1 | 28756 | 23 | 0.530 | 54256.6 |
938 | 2022-05-10 20:00:21 | barns | 1 | 28756 | 23 | 0.530 | 54256.6 |
937 | 2022-05-10 02:53:53 | barns | 1 | 28756 | 23 | 0.656 | 43835.4 |
936 | 2022-05-08 15:49:05 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
935 | 2022-05-08 06:59:19 | barns | 1 | 28756 | 23 | 0.906 | 31739.5 |
934 | 2022-05-08 03:39:17 | barns | 1 | 28756 | 23 | 0.500 | 57512.0 |
933 | 2022-05-07 21:57:03 | barns | 1 | 28756 | 23 | 0.470 | 61183.0 |
932 | 2022-05-06 20:08:48 | barns | 1 | 28756 | 23 | 0.516 | 55728.7 |
931 | 2022-05-05 21:40:29 | barns | 1 | 28756 | 23 | 0.450 | 63902.2 |
930 | 2022-05-05 11:46:43 | barns | 1 | 28756 | 23 | 0.530 | 54256.6 |
929 | 2022-05-04 12:42:31 | barns | 1 | 28756 | 23 | 0.576 | 49923.6 |
928 | 2022-05-04 02:58:54 | barns | 1 | 28756 | 23 | 0.593 | 48492.4 |