History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wines"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1074 | 2024-04-27 07:43:56 | wines | 1 | 28756 | 38 | 0.486 | 59168.7 |
1073 | 2024-04-24 18:07:52 | wines | 1 | 28756 | 38 | 0.516 | 55728.7 |
1072 | 2024-04-08 16:23:33 | wines | 1 | 28756 | 38 | 1.203 | 23903.6 |
1071 | 2024-04-03 01:35:08 | wines | 1 | 28756 | 38 | 1.690 | 17015.4 |
1070 | 2024-03-31 02:12:20 | wines | 1 | 28756 | 38 | 0.560 | 51350.0 |
1069 | 2024-03-28 19:00:35 | wines | 2 | 53800 | 460 | 3.593 | 14973.6 |
1068 | 2024-03-28 18:08:46 | wines | 1 | 28756 | 38 | 1.280 | 22465.6 |
1067 | 2024-03-26 02:45:41 | wines | 1 | 28756 | 38 | 1.046 | 27491.4 |
1066 | 2024-03-25 17:55:46 | wines | 1 | 28756 | 38 | 0.500 | 57512.0 |
1065 | 2024-03-22 06:21:10 | wines | 1 | 28756 | 38 | 0.440 | 65354.5 |
1064 | 2024-03-08 03:58:20 | wines | 1 | 28756 | 38 | 1.076 | 26724.9 |
1063 | 2024-03-08 03:57:53 | wines | 2 | 53800 | 460 | 4.063 | 13241.4 |
1062 | 2024-03-08 03:57:41 | wines | 1 | 28756 | 38 | 1.140 | 25224.6 |
1061 | 2024-03-03 22:36:53 | wines | 1 | 28756 | 38 | 1.140 | 25224.6 |
1060 | 2024-03-01 10:41:55 | wines | 1 | 28756 | 38 | 1.076 | 26724.9 |
1059 | 2024-02-26 22:33:35 | wines | 2 | 53800 | 460 | 1.576 | 34137.1 |
1058 | 2024-02-26 19:42:40 | wines | 1 | 28756 | 38 | 0.420 | 68466.7 |
1057 | 2024-02-23 10:57:11 | wines | 2 | 53800 | 460 | 1.360 | 39558.8 |
1056 | 2024-02-11 23:06:40 | wines | 1 | 28756 | 38 | 0.530 | 54256.6 |
1055 | 2024-02-05 15:32:34 | wines | 2 | 53800 | 460 | 1.673 | 32157.8 |
1054 | 2024-02-05 15:32:30 | wines | 1 | 28756 | 38 | 0.513 | 56054.6 |
1053 | 2024-01-29 00:42:51 | wines | 2 | 53800 | 460 | 1.423 | 37807.4 |
1052 | 2024-01-27 18:10:21 | wines | 1 | 28756 | 38 | 0.513 | 56054.6 |
1051 | 2024-01-26 13:36:33 | wines | 1 | 28756 | 38 | 0.516 | 55728.7 |
1050 | 2024-01-21 17:46:44 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1049 | 2024-01-06 10:47:10 | wines | 1 | 28756 | 38 | 0.500 | 57512.0 |
1048 | 2023-12-16 12:14:05 | wines | 2 | 53800 | 460 | 2.046 | 26295.2 |
1047 | 2023-12-12 06:36:40 | wines | 1 | 28756 | 38 | 0.856 | 33593.5 |
1046 | 2023-12-07 19:45:37 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1045 | 2023-12-07 19:45:36 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1044 | 2023-12-01 13:22:02 | wines | 2 | 53800 | 460 | 1.530 | 35163.4 |
1043 | 2023-11-30 09:45:22 | wines | 1 | 28756 | 38 | 0.453 | 63479.0 |
1042 | 2023-11-23 08:13:46 | wines | 1 | 28756 | 38 | 0.466 | 61708.2 |
1041 | 2023-11-18 01:16:26 | wines | 2 | 53800 | 460 | 1.483 | 36277.8 |
1040 | 2023-11-12 00:06:08 | wines | 1 | 28756 | 38 | 0.703 | 40904.7 |
1039 | 2023-11-10 01:32:20 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1038 | 2023-10-29 23:46:21 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1037 | 2023-10-29 20:47:59 | wines | 2 | 53800 | 460 | 1.530 | 35163.4 |
1036 | 2023-10-26 12:53:58 | wines | 2 | 53800 | 460 | 1.716 | 31352.0 |
1035 | 2023-10-25 16:20:44 | wines | 2 | 53800 | 460 | 1.703 | 31591.3 |
1034 | 2023-10-22 22:46:19 | wines | 2 | 53800 | 460 | 1.720 | 31279.1 |
1033 | 2023-10-22 20:57:30 | wines | 1 | 28756 | 38 | 0.483 | 59536.2 |
1032 | 2023-10-20 18:32:18 | wines | 1 | 28756 | 38 | 0.423 | 67981.1 |
1031 | 2023-10-17 01:06:57 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1030 | 2023-10-11 03:20:13 | wines | 1 | 28756 | 38 | 0.440 | 65354.5 |
1029 | 2023-10-05 04:50:09 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1028 | 2023-09-27 12:17:58 | wines | 1 | 28756 | 38 | 0.423 | 67981.1 |
1027 | 2023-09-26 05:42:48 | wines | 1 | 28756 | 38 | 0.516 | 55728.7 |
1026 | 2023-09-23 07:24:26 | wines | 1 | 28756 | 38 | 0.440 | 65354.5 |
1025 | 2023-09-14 23:44:35 | wines | 1 | 28756 | 38 | 1.093 | 26309.2 |
1024 | 2023-08-19 07:36:33 | wines | 2 | 53800 | 460 | 1.373 | 39184.3 |
1023 | 2023-07-01 18:18:55 | wines | 1 | 28756 | 38 | 0.500 | 57512.0 |
1022 | 2023-06-13 19:30:50 | wines | 1 | 28756 | 38 | 0.486 | 59168.7 |
1021 | 2023-05-14 20:26:00 | wines | 2 | 53800 | 460 | 1.343 | 40059.6 |
1020 | 2023-05-01 15:54:04 | wines | 2 | 53800 | 460 | 1.360 | 39558.8 |
1019 | 2023-04-08 06:00:21 | wines | 1 | 28756 | 38 | 0.466 | 61708.2 |
1018 | 2023-03-02 23:28:40 | wines | 1 | 28756 | 38 | 0.470 | 61183.0 |
1017 | 2023-03-01 08:31:07 | wines | 1 | 28756 | 38 | 0.423 | 67981.1 |
1016 | 2023-02-07 08:45:04 | wines | 2 | 53800 | 460 | 1.453 | 37026.8 |
1015 | 2023-01-22 17:57:10 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1014 | 2022-11-19 14:52:45 | wines | 1 | 28756 | 38 | 0.466 | 61708.2 |
1013 | 2022-11-17 19:55:37 | wines | 2 | 53800 | 460 | 1.516 | 35488.1 |
1012 | 2022-11-12 12:04:31 | wines | 1 | 28756 | 38 | 0.453 | 63479.0 |
1011 | 2022-09-19 17:07:16 | wines | 1 | 28756 | 38 | 0.440 | 65354.5 |
1010 | 2022-09-12 07:08:11 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1009 | 2022-08-31 03:29:07 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1008 | 2022-08-14 17:51:12 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1007 | 2022-07-30 05:38:27 | wines | 1 | 28756 | 38 | 0.440 | 65354.5 |
1006 | 2022-07-29 02:04:09 | wines | 1 | 28756 | 38 | 0.453 | 63479.0 |
1005 | 2022-07-19 15:28:51 | wines | 1 | 28756 | 38 | 0.470 | 61183.0 |
1004 | 2022-07-17 22:33:09 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1003 | 2022-07-11 07:08:41 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
1002 | 2022-07-10 23:02:08 | wines | 2 | 53800 | 460 | 1.343 | 40059.6 |
1001 | 2022-07-10 09:54:34 | wines | 1 | 28756 | 38 | 0.876 | 32826.5 |
1000 | 2022-07-09 01:52:11 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
999 | 2022-07-02 19:23:32 | wines | 1 | 28756 | 38 | 0.423 | 67981.1 |
998 | 2022-07-02 02:33:53 | wines | 2 | 53800 | 460 | 1.530 | 35163.4 |
997 | 2022-06-21 14:53:03 | wines | 2 | 53800 | 460 | 1.500 | 35866.7 |
996 | 2022-04-08 19:01:54 | wines | 1 | 28756 | 38 | 0.513 | 56054.6 |
995 | 2022-04-07 21:39:08 | wines | 1 | 28756 | 38 | 0.876 | 32826.5 |
994 | 2022-04-06 18:49:24 | wines | 1 | 28756 | 38 | 0.483 | 59536.2 |
993 | 2022-04-01 19:20:26 | wines | 1 | 28756 | 38 | 0.483 | 59536.2 |
992 | 2022-03-22 03:25:24 | wines | 1 | 28756 | 38 | 0.483 | 59536.2 |
991 | 2022-03-18 16:56:58 | wines | 1 | 28756 | 38 | 0.420 | 68466.7 |
990 | 2022-03-12 01:14:48 | wines | 1 | 28756 | 38 | 0.440 | 65354.5 |
989 | 2022-03-11 12:28:45 | wines | 1 | 28756 | 38 | 0.500 | 57512.0 |
988 | 2022-03-10 23:43:21 | wines | 1 | 28756 | 38 | 0.533 | 53951.2 |
987 | 2022-03-10 16:50:33 | wines | 1 | 28756 | 38 | 0.483 | 59536.2 |
986 | 2022-03-10 01:09:05 | wines | 1 | 28756 | 38 | 0.733 | 39230.6 |
985 | 2022-03-09 12:15:59 | wines | 1 | 28756 | 38 | 0.610 | 47141.0 |
984 | 2022-03-09 10:02:09 | wines | 1 | 28756 | 38 | 0.610 | 47141.0 |
983 | 2022-03-08 16:11:03 | wines | 1 | 28756 | 38 | 0.593 | 48492.4 |
982 | 2022-03-07 18:57:05 | wines | 1 | 28756 | 38 | 0.470 | 61183.0 |
981 | 2022-03-07 08:06:33 | wines | 1 | 28756 | 38 | 0.420 | 68466.7 |
980 | 2022-03-06 12:43:12 | wines | 1 | 28756 | 38 | 0.453 | 63479.0 |
979 | 2022-03-05 21:24:25 | wines | 1 | 28756 | 38 | 0.500 | 57512.0 |
978 | 2022-03-05 11:13:15 | wines | 1 | 28756 | 38 | 0.436 | 65954.1 |
977 | 2022-03-04 19:18:14 | wines | 1 | 28756 | 38 | 0.483 | 59536.2 |
976 | 2022-03-04 04:47:50 | wines | 1 | 28756 | 38 | 0.483 | 59536.2 |
975 | 2022-03-03 13:53:59 | wines | 1 | 28756 | 38 | 0.610 | 47141.0 |