History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"store"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1175 | 2024-05-09 14:19:39 | store | 2 | 53800 | 237 | 1.580 | 34050.6 |
1174 | 2024-04-29 21:53:30 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1173 | 2024-04-29 09:35:41 | store | 1 | 28756 | 24 | 0.513 | 56054.6 |
1172 | 2024-04-27 07:44:16 | store | 1 | 28756 | 24 | 0.483 | 59536.2 |
1171 | 2024-04-27 07:19:22 | store | 1 | 28756 | 24 | 1.000 | 28756.0 |
1170 | 2024-04-11 16:44:51 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1169 | 2024-04-03 03:22:21 | store | 1 | 28756 | 24 | 1.720 | 16718.6 |
1168 | 2024-03-31 02:40:13 | store | 1 | 28756 | 24 | 0.533 | 53951.2 |
1167 | 2024-03-03 20:57:17 | store | 1 | 28756 | 24 | 0.810 | 35501.2 |
1166 | 2024-02-25 17:43:42 | store | 1 | 28756 | 24 | 0.440 | 65354.5 |
1165 | 2024-02-08 22:56:21 | store | 1 | 28756 | 24 | 0.890 | 32310.1 |
1164 | 2024-01-26 16:40:37 | store | 1 | 28756 | 24 | 0.560 | 51350.0 |
1163 | 2024-01-12 19:19:30 | store | 1 | 28756 | 24 | 1.063 | 27051.7 |
1162 | 2024-01-01 22:44:12 | store | 2 | 53800 | 237 | 1.406 | 38264.6 |
1161 | 2023-12-30 10:46:26 | store | 2 | 53800 | 237 | 1.530 | 35163.4 |
1160 | 2023-12-03 12:17:46 | store | 1 | 28756 | 24 | 0.530 | 54256.6 |
1159 | 2023-12-03 12:17:45 | store | 1 | 28756 | 24 | 0.530 | 54256.6 |
1158 | 2023-12-02 22:00:19 | store | 2 | 53800 | 237 | 1.703 | 31591.3 |
1157 | 2023-12-01 17:18:48 | store | 2 | 53800 | 237 | 1.596 | 33709.3 |
1156 | 2023-11-29 13:56:27 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1155 | 2023-11-29 06:08:29 | store | 1 | 28756 | 24 | 0.470 | 61183.0 |
1154 | 2023-11-18 03:14:09 | store | 2 | 53800 | 237 | 1.596 | 33709.3 |
1153 | 2023-11-14 20:56:51 | store | 1 | 28756 | 24 | 0.530 | 54256.6 |
1152 | 2023-11-13 19:41:08 | store | 1 | 28756 | 24 | 0.440 | 65354.5 |
1151 | 2023-11-08 13:07:33 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1150 | 2023-10-27 21:54:41 | store | 1 | 28756 | 24 | 0.983 | 29253.3 |
1149 | 2023-10-26 15:01:16 | store | 1 | 28756 | 24 | 0.516 | 55728.7 |
1148 | 2023-10-22 05:08:57 | store | 1 | 28756 | 24 | 0.483 | 59536.2 |
1147 | 2023-10-19 03:17:54 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1146 | 2023-10-11 17:29:10 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1145 | 2023-10-06 07:23:38 | store | 2 | 53800 | 237 | 1.466 | 36698.5 |
1144 | 2023-10-05 06:09:57 | store | 1 | 28756 | 24 | 0.486 | 59168.7 |
1143 | 2023-09-28 04:30:50 | store | 1 | 28756 | 24 | 0.516 | 55728.7 |
1142 | 2023-09-25 15:02:50 | store | 1 | 28756 | 24 | 0.483 | 59536.2 |
1141 | 2023-09-20 15:42:00 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1140 | 2023-09-13 07:54:14 | store | 1 | 28756 | 24 | 0.436 | 65954.1 |
1139 | 2023-09-13 02:31:18 | store | 1 | 28756 | 24 | 0.673 | 42728.1 |
1138 | 2023-09-09 18:40:34 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1137 | 2023-08-18 08:54:56 | store | 1 | 28756 | 24 | 0.483 | 59536.2 |
1136 | 2023-07-17 08:07:04 | store | 2 | 53800 | 237 | 1.440 | 37361.1 |
1135 | 2023-06-30 01:30:16 | store | 1 | 28756 | 24 | 0.470 | 61183.0 |
1134 | 2023-05-23 19:37:38 | store | 1 | 28756 | 24 | 0.450 | 63902.2 |
1133 | 2023-04-08 22:18:11 | store | 1 | 28756 | 24 | 0.440 | 65354.5 |
1132 | 2023-04-05 10:46:20 | store | 2 | 53800 | 237 | 1.343 | 40059.6 |
1131 | 2023-02-03 15:26:30 | store | 1 | 28756 | 24 | 0.423 | 67981.1 |
1130 | 2023-01-23 09:19:11 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1129 | 2023-01-03 19:02:50 | store | 2 | 53800 | 237 | 1.360 | 39558.8 |
1128 | 2022-11-21 12:41:41 | store | 1 | 28756 | 24 | 0.483 | 59536.2 |
1127 | 2022-10-13 10:39:03 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1126 | 2022-09-08 12:28:48 | store | 2 | 53800 | 237 | 1.530 | 35163.4 |
1125 | 2022-07-19 11:52:59 | store | 2 | 53800 | 237 | 1.390 | 38705.0 |
1124 | 2022-07-18 19:54:35 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1123 | 2022-07-17 23:46:02 | store | 1 | 28756 | 24 | 0.436 | 65954.1 |
1122 | 2022-07-12 02:45:17 | store | 1 | 28756 | 24 | 0.436 | 65954.1 |
1121 | 2022-07-03 03:50:47 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1120 | 2022-06-26 21:22:32 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1119 | 2022-06-08 23:32:37 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1118 | 2022-05-19 01:29:39 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1117 | 2022-05-11 12:59:13 | store | 1 | 28756 | 24 | 0.560 | 51350.0 |
1116 | 2022-05-11 01:36:33 | store | 1 | 28756 | 24 | 0.593 | 48492.4 |
1115 | 2022-05-10 18:43:54 | store | 1 | 28756 | 24 | 0.546 | 52666.7 |
1114 | 2022-05-10 01:38:18 | store | 1 | 28756 | 24 | 0.483 | 59536.2 |
1113 | 2022-05-08 14:33:12 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1112 | 2022-05-08 02:24:13 | store | 1 | 28756 | 24 | 0.466 | 61708.2 |
1111 | 2022-05-07 20:41:39 | store | 1 | 28756 | 24 | 0.436 | 65954.1 |
1110 | 2022-04-15 21:30:57 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1109 | 2022-04-14 22:08:35 | store | 1 | 28756 | 24 | 0.593 | 48492.4 |
1108 | 2022-04-14 02:14:53 | store | 1 | 28756 | 24 | 0.546 | 52666.7 |
1107 | 2022-04-08 19:35:39 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1106 | 2022-04-08 03:25:46 | store | 1 | 28756 | 24 | 0.673 | 42728.1 |
1105 | 2022-04-07 11:41:38 | store | 1 | 28756 | 24 | 0.623 | 46157.3 |
1104 | 2022-04-06 19:19:23 | store | 1 | 28756 | 24 | 0.716 | 40162.0 |
1103 | 2022-04-06 02:44:19 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1102 | 2022-04-05 14:38:07 | store | 1 | 28756 | 24 | 1.170 | 24577.8 |
1101 | 2022-04-04 20:04:52 | store | 1 | 28756 | 24 | 0.466 | 61708.2 |
1100 | 2022-04-03 15:32:59 | store | 1 | 28756 | 24 | 0.436 | 65954.1 |
1099 | 2022-04-02 19:31:58 | store | 1 | 28756 | 24 | 0.516 | 55728.7 |
1098 | 2022-04-02 01:33:43 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1097 | 2022-04-01 09:51:24 | store | 1 | 28756 | 24 | 0.483 | 59536.2 |
1096 | 2022-03-31 19:57:24 | store | 1 | 28756 | 24 | 0.690 | 41675.4 |
1095 | 2022-03-30 23:16:51 | store | 1 | 28756 | 24 | 0.530 | 54256.6 |
1094 | 2022-03-30 11:19:51 | store | 1 | 28756 | 24 | 0.593 | 48492.4 |
1093 | 2022-03-29 20:41:08 | store | 1 | 28756 | 24 | 0.486 | 59168.7 |
1092 | 2022-03-29 08:14:47 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1091 | 2022-03-28 09:07:27 | store | 1 | 28756 | 24 | 0.686 | 41918.4 |
1090 | 2022-03-27 17:03:46 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1089 | 2022-03-26 22:19:09 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1088 | 2022-03-26 03:23:22 | store | 1 | 28756 | 24 | 0.486 | 59168.7 |
1087 | 2022-03-25 15:55:29 | store | 1 | 28756 | 24 | 0.436 | 65954.1 |
1086 | 2022-03-25 00:46:34 | store | 1 | 28756 | 24 | 0.530 | 54256.6 |
1085 | 2022-03-23 19:03:22 | store | 1 | 28756 | 24 | 0.606 | 47452.1 |
1084 | 2022-03-23 06:08:54 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1083 | 2022-03-22 21:19:23 | store | 1 | 28756 | 24 | 0.530 | 54256.6 |
1082 | 2022-03-22 07:59:58 | store | 1 | 28756 | 24 | 0.530 | 54256.6 |
1081 | 2022-03-21 14:22:47 | store | 1 | 28756 | 24 | 0.626 | 45936.1 |
1080 | 2022-03-20 23:46:44 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1079 | 2022-03-20 06:01:43 | store | 1 | 28756 | 24 | 0.530 | 54256.6 |
1078 | 2022-03-15 07:06:20 | store | 1 | 28756 | 24 | 0.546 | 52666.7 |
1077 | 2022-03-14 08:33:17 | store | 1 | 28756 | 24 | 0.656 | 43835.4 |
1076 | 2022-03-13 14:42:07 | store | 1 | 28756 | 24 | 0.436 | 65954.1 |