History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"actor"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1265 | 2024-04-23 08:57:08 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1264 | 2024-04-06 10:59:03 | actor | 1 | 28756 | 3 | 1.783 | 16127.9 |
1263 | 2024-04-03 09:30:26 | actor | 1 | 28756 | 3 | 0.533 | 53951.2 |
1262 | 2024-03-31 15:10:04 | actor | 1 | 28756 | 3 | 0.546 | 52666.7 |
1261 | 2024-03-28 20:16:52 | actor | 1 | 28756 | 3 | 0.563 | 51076.4 |
1260 | 2024-03-07 10:39:47 | actor | 3 | 83667 | 860 | 11.236 | 7446.3 |
1259 | 2024-03-07 10:39:49 | actor | 2 | 53800 | 66 | 6.576 | 8181.3 |
1258 | 2024-03-07 05:46:57 | actor | 1 | 28756 | 3 | 0.483 | 59536.2 |
1257 | 2024-03-03 08:05:00 | actor | 1 | 28756 | 3 | 0.626 | 45936.1 |
1256 | 2024-03-01 11:33:04 | actor | 1 | 28756 | 3 | 0.486 | 59168.7 |
1255 | 2024-02-28 11:08:20 | actor | 2 | 53800 | 66 | 1.720 | 31279.1 |
1254 | 2024-02-28 11:07:56 | actor | 3 | 83667 | 860 | 7.063 | 11845.8 |
1253 | 2024-02-25 21:36:38 | actor | 3 | 83667 | 860 | 4.876 | 17158.9 |
1252 | 2024-02-25 21:36:41 | actor | 2 | 53800 | 66 | 1.873 | 28724.0 |
1251 | 2024-02-25 19:31:39 | actor | 1 | 28756 | 3 | 0.563 | 51076.4 |
1250 | 2024-02-05 15:19:01 | actor | 2 | 53800 | 66 | 3.703 | 14528.8 |
1249 | 2024-02-05 15:18:22 | actor | 3 | 83667 | 860 | 14.716 | 5685.4 |
1248 | 2024-02-03 23:36:39 | actor | 2 | 53800 | 66 | 1.783 | 30173.9 |
1247 | 2024-02-03 23:35:31 | actor | 1 | 28756 | 3 | 0.486 | 59168.7 |
1246 | 2024-01-29 06:50:51 | actor | 1 | 28756 | 3 | 0.486 | 59168.7 |
1245 | 2024-01-26 06:22:09 | actor | 1 | 28756 | 3 | 0.440 | 65354.5 |
1244 | 2024-01-12 00:45:55 | actor | 1 | 28756 | 3 | 0.486 | 59168.7 |
1243 | 2024-01-01 15:12:12 | actor | 2 | 53800 | 66 | 1.546 | 34799.5 |
1242 | 2023-12-18 06:47:29 | actor | 1 | 28756 | 3 | 0.513 | 56054.6 |
1241 | 2023-12-15 00:02:41 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1240 | 2023-11-27 12:18:23 | actor | 3 | 83667 | 860 | 4.033 | 20745.6 |
1239 | 2023-11-27 12:18:24 | actor | 2 | 53800 | 66 | 1.670 | 32215.6 |
1238 | 2023-11-27 02:20:22 | actor | 3 | 83667 | 860 | 3.453 | 24230.2 |
1237 | 2023-11-27 02:20:21 | actor | 2 | 53800 | 66 | 1.436 | 37465.2 |
1236 | 2023-11-26 11:11:38 | actor | 3 | 83667 | 860 | 4.063 | 20592.4 |
1235 | 2023-11-20 00:10:07 | actor | 3 | 83667 | 860 | 3.673 | 22778.9 |
1234 | 2023-11-20 00:10:06 | actor | 2 | 53800 | 66 | 1.530 | 35163.4 |
1233 | 2023-11-10 01:07:17 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1232 | 2023-11-08 19:30:52 | actor | 1 | 28756 | 3 | 0.530 | 54256.6 |
1231 | 2023-11-07 07:58:47 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1230 | 2023-11-07 02:14:30 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1229 | 2023-10-27 12:03:27 | actor | 1 | 28756 | 3 | 1.673 | 17188.3 |
1228 | 2023-10-20 00:02:51 | actor | 1 | 28756 | 3 | 0.516 | 55728.7 |
1227 | 2023-10-17 16:33:26 | actor | 1 | 28756 | 3 | 0.516 | 55728.7 |
1226 | 2023-10-13 05:09:11 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1225 | 2023-10-07 02:42:50 | actor | 2 | 53800 | 66 | 1.593 | 33772.8 |
1224 | 2023-10-04 07:38:09 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1223 | 2023-09-25 01:17:20 | actor | 2 | 53800 | 66 | 1.406 | 38264.6 |
1222 | 2023-09-24 20:51:18 | actor | 3 | 83667 | 860 | 3.876 | 21585.9 |
1221 | 2023-09-19 21:06:10 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1220 | 2023-09-19 11:38:36 | actor | 2 | 53800 | 66 | 1.593 | 33772.8 |
1219 | 2023-09-19 11:38:33 | actor | 3 | 83667 | 860 | 3.923 | 21327.3 |
1218 | 2023-09-10 17:52:12 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1217 | 2023-09-08 06:22:45 | actor | 1 | 28756 | 3 | 0.560 | 51350.0 |
1216 | 2023-08-28 06:14:04 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1215 | 2023-08-22 10:16:39 | actor | 3 | 83667 | 860 | 3.376 | 24782.9 |
1214 | 2023-07-16 23:31:16 | actor | 2 | 53800 | 66 | 1.436 | 37465.2 |
1213 | 2023-07-08 15:32:48 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1212 | 2023-06-07 16:35:41 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1211 | 2023-06-01 22:25:35 | actor | 1 | 28756 | 3 | 0.440 | 65354.5 |
1210 | 2023-04-07 08:00:26 | actor | 3 | 83667 | 860 | 3.453 | 24230.2 |
1209 | 2023-04-03 01:05:44 | actor | 2 | 53800 | 66 | 1.436 | 37465.2 |
1208 | 2023-03-31 13:42:13 | actor | 3 | 83667 | 860 | 3.643 | 22966.5 |
1207 | 2023-03-26 22:43:17 | actor | 1 | 28756 | 3 | 0.483 | 59536.2 |
1206 | 2023-03-26 10:40:38 | actor | 1 | 28756 | 3 | 0.436 | 65954.1 |
1205 | 2023-03-08 13:35:08 | actor | 1 | 28756 | 3 | 0.530 | 54256.6 |
1204 | 2023-02-04 11:52:14 | actor | 1 | 28756 | 3 | 0.483 | 59536.2 |
1203 | 2023-01-17 08:47:07 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1202 | 2023-01-10 07:42:35 | actor | 1 | 28756 | 3 | 0.440 | 65354.5 |
1201 | 2023-01-02 08:06:35 | actor | 2 | 53800 | 66 | 1.390 | 38705.0 |
1200 | 2022-12-19 09:09:34 | actor | 1 | 28756 | 3 | 0.503 | 57169.0 |
1199 | 2022-12-03 14:18:28 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1198 | 2022-11-26 02:30:06 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1197 | 2022-11-10 00:30:38 | actor | 1 | 28756 | 3 | 0.483 | 59536.2 |
1196 | 2022-10-16 23:54:20 | actor | 1 | 28756 | 3 | 0.436 | 65954.1 |
1195 | 2022-09-07 10:22:25 | actor | 2 | 53800 | 66 | 1.453 | 37026.8 |
1194 | 2022-09-05 07:45:49 | actor | 2 | 53800 | 66 | 1.376 | 39098.8 |
1193 | 2022-09-03 05:19:12 | actor | 2 | 53800 | 66 | 1.376 | 39098.8 |
1192 | 2022-08-23 08:42:54 | actor | 1 | 28756 | 3 | 0.450 | 63902.2 |
1191 | 2022-06-04 03:29:31 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1190 | 2022-06-01 21:50:43 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1189 | 2022-05-14 04:47:07 | actor | 1 | 28756 | 3 | 0.516 | 55728.7 |
1188 | 2022-05-10 19:50:27 | actor | 1 | 28756 | 3 | 0.593 | 48492.4 |
1187 | 2022-03-30 21:07:24 | actor | 2 | 53800 | 66 | 1.530 | 35163.4 |
1186 | 2022-02-09 17:27:00 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1185 | 2022-02-07 12:50:18 | actor | 1 | 28756 | 3 | 0.436 | 65954.1 |
1184 | 2022-02-06 00:34:37 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1183 | 2021-12-01 05:24:52 | actor | 1 | 28756 | 3 | 0.500 | 57512.0 |
1182 | 2021-11-25 02:12:21 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1181 | 2021-11-01 18:31:08 | actor | 1 | 28756 | 3 | 0.576 | 49923.6 |
1180 | 2021-10-04 13:15:31 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1179 | 2021-10-02 11:04:20 | actor | 1 | 28756 | 3 | 0.436 | 65954.1 |
1178 | 2021-09-24 16:48:37 | actor | 1 | 28756 | 3 | 0.516 | 55728.7 |
1177 | 2021-08-30 23:21:23 | actor | 1 | 28756 | 3 | 0.436 | 65954.1 |
1176 | 2021-08-17 22:17:49 | actor | 1 | 28756 | 3 | 0.486 | 59168.7 |
1175 | 2021-08-15 18:12:27 | actor | 1 | 28756 | 3 | 0.453 | 63479.0 |
1174 | 2021-08-01 23:20:25 | actor | 1 | 28756 | 3 | 0.436 | 65954.1 |
1173 | 2021-06-05 12:39:56 | actor | 3 | 83667 | 860 | 3.550 | 23568.2 |
1172 | 2021-05-28 08:09:23 | actor | 1 | 28756 | 3 | 0.516 | 55728.7 |
1171 | 2021-05-02 13:29:07 | actor | 1 | 28756 | 3 | 0.533 | 53951.2 |
1170 | 2021-05-01 08:56:41 | actor | 1 | 28756 | 3 | 0.533 | 53951.2 |
1169 | 2021-04-29 12:28:08 | actor | 3 | 83667 | 860 | 4.250 | 19686.4 |
1168 | 2021-03-03 08:18:19 | actor | 3 | 83667 | 860 | 3.393 | 24658.7 |
1167 | 2021-02-23 19:49:46 | actor | 3 | 83667 | 860 | 3.360 | 24900.9 |
1166 | 2021-02-21 06:01:22 | actor | 3 | 83667 | 860 | 3.393 | 24658.7 |