History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1237 | 2024-04-03 03:37:51 | bates | 1 | 28756 | 30 | 1.750 | 16432.0 |
1236 | 2024-03-31 03:26:35 | bates | 1 | 28756 | 30 | 0.590 | 48739.0 |
1235 | 2024-03-28 23:55:12 | bates | 2 | 53800 | 515 | 5.830 | 9228.1 |
1234 | 2024-03-28 23:10:07 | bates | 1 | 28756 | 30 | 0.656 | 43835.4 |
1233 | 2024-03-28 21:58:49 | bates | 1 | 28756 | 30 | 1.173 | 24514.9 |
1232 | 2024-03-09 11:11:40 | bates | 1 | 28756 | 30 | 0.440 | 65354.5 |
1231 | 2024-03-03 22:49:45 | bates | 1 | 28756 | 30 | 1.170 | 24577.8 |
1230 | 2024-03-01 00:23:32 | bates | 1 | 28756 | 30 | 0.580 | 49579.3 |
1229 | 2024-02-29 23:20:47 | bates | 1 | 28756 | 30 | 0.530 | 54256.6 |
1228 | 2024-02-27 20:43:41 | bates | 1 | 28756 | 30 | 1.096 | 26237.2 |
1227 | 2024-02-24 11:07:51 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1226 | 2024-02-20 20:55:45 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1225 | 2024-02-14 02:32:43 | bates | 1 | 28756 | 30 | 0.626 | 45936.1 |
1224 | 2024-01-29 00:21:09 | bates | 1 | 28756 | 30 | 0.470 | 61183.0 |
1223 | 2024-01-20 17:40:55 | bates | 1 | 28756 | 30 | 0.486 | 59168.7 |
1222 | 2024-01-18 02:04:03 | bates | 1 | 28756 | 30 | 0.436 | 65954.1 |
1221 | 2023-12-29 11:35:26 | bates | 2 | 53800 | 515 | 1.580 | 34050.6 |
1220 | 2023-12-15 03:01:02 | bates | 1 | 28756 | 30 | 0.470 | 61183.0 |
1219 | 2023-12-06 08:18:34 | bates | 1 | 28756 | 30 | 0.450 | 63902.2 |
1218 | 2023-12-02 23:45:48 | bates | 1 | 28756 | 30 | 0.560 | 51350.0 |
1217 | 2023-11-27 14:49:57 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1216 | 2023-11-27 12:36:40 | bates | 1 | 28756 | 30 | 0.500 | 57512.0 |
1215 | 2023-11-23 23:35:25 | bates | 2 | 53800 | 515 | 1.406 | 38264.6 |
1214 | 2023-11-22 10:16:30 | bates | 2 | 53800 | 515 | 1.423 | 37807.4 |
1213 | 2023-11-17 06:15:07 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1212 | 2023-11-16 05:04:51 | bates | 2 | 53800 | 515 | 1.483 | 36277.8 |
1211 | 2023-11-15 09:10:06 | bates | 1 | 28756 | 30 | 0.500 | 57512.0 |
1210 | 2023-11-09 13:16:21 | bates | 1 | 28756 | 30 | 0.440 | 65354.5 |
1209 | 2023-11-09 03:51:19 | bates | 1 | 28756 | 30 | 1.033 | 27837.4 |
1208 | 2023-11-06 15:45:11 | bates | 1 | 28756 | 30 | 0.500 | 57512.0 |
1207 | 2023-10-30 12:27:10 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1206 | 2023-10-25 22:26:56 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1205 | 2023-10-21 14:44:48 | bates | 1 | 28756 | 30 | 0.436 | 65954.1 |
1204 | 2023-10-21 11:09:29 | bates | 1 | 28756 | 30 | 0.483 | 59536.2 |
1203 | 2023-10-18 13:38:55 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1202 | 2023-10-12 10:30:24 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1201 | 2023-10-05 03:17:57 | bates | 1 | 28756 | 30 | 0.440 | 65354.5 |
1200 | 2023-09-24 04:34:39 | bates | 1 | 28756 | 30 | 0.440 | 65354.5 |
1199 | 2023-09-21 08:04:37 | bates | 1 | 28756 | 30 | 0.500 | 57512.0 |
1198 | 2023-09-20 21:16:57 | bates | 2 | 53800 | 515 | 1.423 | 37807.4 |
1197 | 2023-09-11 19:00:20 | bates | 1 | 28756 | 30 | 0.516 | 55728.7 |
1196 | 2023-09-03 03:04:11 | bates | 1 | 28756 | 30 | 0.560 | 51350.0 |
1195 | 2023-08-31 05:56:00 | bates | 2 | 53800 | 515 | 1.766 | 30464.3 |
1194 | 2023-08-30 22:02:58 | bates | 1 | 28756 | 30 | 0.500 | 57512.0 |
1193 | 2023-08-19 00:10:20 | bates | 2 | 53800 | 515 | 1.406 | 38264.6 |
1192 | 2023-08-18 19:53:14 | bates | 2 | 53800 | 515 | 1.653 | 32546.9 |
1191 | 2023-08-17 01:16:27 | bates | 2 | 53800 | 515 | 1.500 | 35866.7 |
1190 | 2023-08-15 20:49:52 | bates | 2 | 53800 | 515 | 1.530 | 35163.4 |
1189 | 2023-08-14 06:03:10 | bates | 2 | 53800 | 515 | 1.736 | 30990.8 |
1188 | 2023-07-30 23:20:36 | bates | 2 | 53800 | 515 | 1.456 | 36950.5 |
1187 | 2023-07-08 19:17:10 | bates | 1 | 28756 | 30 | 0.436 | 65954.1 |
1186 | 2023-06-06 22:49:45 | bates | 1 | 28756 | 30 | 0.500 | 57512.0 |
1185 | 2023-05-30 15:56:29 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1184 | 2023-05-24 08:40:25 | bates | 1 | 28756 | 30 | 0.486 | 59168.7 |
1183 | 2023-04-20 08:24:37 | bates | 1 | 28756 | 30 | 0.546 | 52666.7 |
1182 | 2023-03-28 12:05:30 | bates | 1 | 28756 | 30 | 0.450 | 63902.2 |
1181 | 2023-03-26 23:17:04 | bates | 1 | 28756 | 30 | 0.436 | 65954.1 |
1180 | 2023-03-23 22:27:04 | bates | 1 | 28756 | 30 | 0.983 | 29253.3 |
1179 | 2023-02-24 19:19:01 | bates | 1 | 28756 | 30 | 0.436 | 65954.1 |
1178 | 2023-01-11 12:52:35 | bates | 1 | 28756 | 30 | 0.440 | 65354.5 |
1177 | 2022-11-25 13:01:33 | bates | 1 | 28756 | 30 | 0.486 | 59168.7 |
1176 | 2022-11-25 04:23:51 | bates | 1 | 28756 | 30 | 0.500 | 57512.0 |
1175 | 2022-11-12 17:59:58 | bates | 1 | 28756 | 30 | 0.436 | 65954.1 |
1174 | 2022-11-08 12:43:11 | bates | 2 | 53800 | 515 | 1.690 | 31834.3 |
1173 | 2022-11-07 18:40:35 | bates | 2 | 53800 | 515 | 1.703 | 31591.3 |
1172 | 2022-11-06 14:56:19 | bates | 2 | 53800 | 515 | 1.656 | 32487.9 |
1171 | 2022-11-05 06:39:41 | bates | 2 | 53800 | 515 | 1.406 | 38264.6 |
1170 | 2022-11-04 09:29:19 | bates | 2 | 53800 | 515 | 1.500 | 35866.7 |
1169 | 2022-11-03 14:17:31 | bates | 2 | 53800 | 515 | 1.406 | 38264.6 |
1168 | 2022-11-02 14:44:33 | bates | 2 | 53800 | 515 | 1.920 | 28020.8 |
1167 | 2022-11-01 16:18:08 | bates | 2 | 53800 | 515 | 1.796 | 29955.5 |
1166 | 2022-10-30 13:14:12 | bates | 1 | 28756 | 30 | 0.440 | 65354.5 |
1165 | 2022-10-29 11:34:54 | bates | 1 | 28756 | 30 | 0.440 | 65354.5 |
1164 | 2022-10-28 12:11:26 | bates | 1 | 28756 | 30 | 0.876 | 32826.5 |
1163 | 2022-10-27 11:14:31 | bates | 1 | 28756 | 30 | 0.436 | 65954.1 |
1162 | 2022-10-26 22:30:11 | bates | 1 | 28756 | 30 | 0.513 | 56054.6 |
1161 | 2022-10-25 09:41:27 | bates | 1 | 28756 | 30 | 0.470 | 61183.0 |
1160 | 2022-10-24 14:15:38 | bates | 1 | 28756 | 30 | 0.483 | 59536.2 |
1159 | 2022-10-23 13:31:28 | bates | 1 | 28756 | 30 | 0.436 | 65954.1 |
1158 | 2022-10-22 11:16:56 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1157 | 2022-10-21 17:29:13 | bates | 1 | 28756 | 30 | 0.466 | 61708.2 |
1156 | 2022-10-20 16:20:50 | bates | 1 | 28756 | 30 | 0.576 | 49923.6 |
1155 | 2022-10-19 13:56:19 | bates | 1 | 28756 | 30 | 0.626 | 45936.1 |
1154 | 2022-10-19 08:50:04 | bates | 1 | 28756 | 30 | 0.470 | 61183.0 |
1153 | 2022-10-18 21:50:41 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1152 | 2022-10-16 18:40:08 | bates | 1 | 28756 | 30 | 0.436 | 65954.1 |
1151 | 2022-10-15 20:05:00 | bates | 1 | 28756 | 30 | 0.466 | 61708.2 |
1150 | 2022-10-14 20:16:05 | bates | 1 | 28756 | 30 | 0.906 | 31739.5 |
1149 | 2022-10-13 12:49:17 | bates | 1 | 28756 | 30 | 0.450 | 63902.2 |
1148 | 2022-10-12 17:17:00 | bates | 1 | 28756 | 30 | 0.456 | 63061.4 |
1147 | 2022-10-11 14:07:12 | bates | 1 | 28756 | 30 | 0.440 | 65354.5 |
1146 | 2022-10-10 22:31:23 | bates | 1 | 28756 | 30 | 0.466 | 61708.2 |
1145 | 2022-10-09 17:13:19 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1144 | 2022-10-08 14:27:15 | bates | 1 | 28756 | 30 | 0.440 | 65354.5 |
1143 | 2022-10-07 16:02:01 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |
1142 | 2022-10-06 18:16:34 | bates | 2 | 53800 | 515 | 1.533 | 35094.6 |
1141 | 2022-09-27 21:06:16 | bates | 2 | 53800 | 515 | 1.610 | 33416.1 |
1140 | 2022-09-02 16:07:09 | bates | 2 | 53800 | 515 | 1.453 | 37026.8 |
1139 | 2022-09-01 19:37:17 | bates | 2 | 53800 | 515 | 1.436 | 37465.2 |
1138 | 2022-09-01 14:41:35 | bates | 1 | 28756 | 30 | 0.453 | 63479.0 |