History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"agene"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1316 | 2024-04-15 15:29:28 | agene | 1 | 28756 | 8 | 0.813 | 35370.2 |
1315 | 2024-04-06 14:32:07 | agene | 2 | 53800 | 90 | 3.266 | 16472.7 |
1314 | 2024-04-05 20:50:17 | agene | 1 | 28756 | 8 | 0.483 | 59536.2 |
1313 | 2024-04-03 06:05:28 | agene | 1 | 28756 | 8 | 0.550 | 52283.6 |
1312 | 2024-04-02 16:22:55 | agene | 1 | 28756 | 8 | 0.470 | 61183.0 |
1311 | 2024-03-31 11:13:22 | agene | 3 | 83667 | 1188 | 6.950 | 12038.4 |
1310 | 2024-03-31 11:13:23 | agene | 2 | 53800 | 90 | 3.953 | 13609.9 |
1309 | 2024-03-31 11:13:18 | agene | 1 | 28756 | 8 | 0.720 | 39938.9 |
1308 | 2024-03-31 11:13:09 | agene | 2 | 53800 | 90 | 2.966 | 18138.9 |
1307 | 2024-03-31 11:12:36 | agene | 3 | 83667 | 1188 | 4.640 | 18031.7 |
1306 | 2024-03-31 10:31:31 | agene | 3 | 83667 | 1188 | 10.000 | 8366.7 |
1305 | 2024-03-31 10:31:31 | agene | 2 | 53800 | 90 | 3.906 | 13773.7 |
1304 | 2024-03-31 08:10:42 | agene | 1 | 28756 | 8 | 0.546 | 52666.7 |
1303 | 2024-03-29 02:34:07 | agene | 1 | 28756 | 8 | 1.673 | 17188.3 |
1302 | 2024-03-04 01:20:32 | agene | 3 | 83667 | 1188 | 7.826 | 10690.9 |
1301 | 2024-03-04 01:20:31 | agene | 2 | 53800 | 90 | 1.716 | 31352.0 |
1300 | 2024-03-04 01:20:28 | agene | 1 | 28756 | 8 | 0.563 | 51076.4 |
1299 | 2024-03-01 05:13:33 | agene | 1 | 28756 | 8 | 0.580 | 49579.3 |
1298 | 2024-02-27 20:19:55 | agene | 1 | 28756 | 8 | 0.936 | 30722.2 |
1297 | 2024-02-21 15:55:20 | agene | 3 | 83667 | 1188 | 9.436 | 8866.8 |
1296 | 2024-02-17 17:23:31 | agene | 2 | 53800 | 90 | 1.936 | 27789.3 |
1295 | 2024-02-17 17:21:56 | agene | 3 | 83667 | 1188 | 3.733 | 22412.8 |
1294 | 2024-02-13 17:41:52 | agene | 3 | 83667 | 1188 | 6.140 | 13626.5 |
1293 | 2024-02-03 01:00:27 | agene | 1 | 28756 | 8 | 0.470 | 61183.0 |
1292 | 2024-01-28 23:31:19 | agene | 1 | 28756 | 8 | 0.486 | 59168.7 |
1291 | 2024-01-28 20:10:01 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1290 | 2024-01-16 23:33:09 | agene | 3 | 83667 | 1188 | 3.606 | 23202.2 |
1289 | 2024-01-10 01:24:25 | agene | 2 | 53800 | 90 | 1.376 | 39098.8 |
1288 | 2024-01-10 01:24:20 | agene | 3 | 83667 | 1188 | 3.453 | 24230.2 |
1287 | 2023-12-31 21:00:20 | agene | 2 | 53800 | 90 | 1.406 | 38264.6 |
1286 | 2023-12-31 21:00:13 | agene | 3 | 83667 | 1188 | 3.483 | 24021.5 |
1285 | 2023-12-27 03:22:20 | agene | 1 | 28756 | 8 | 0.470 | 61183.0 |
1284 | 2023-12-17 12:18:59 | agene | 1 | 28756 | 8 | 0.500 | 57512.0 |
1283 | 2023-12-10 11:35:19 | agene | 2 | 53800 | 90 | 1.406 | 38264.6 |
1282 | 2023-11-21 23:50:49 | agene | 1 | 28756 | 8 | 0.546 | 52666.7 |
1281 | 2023-11-19 15:43:34 | agene | 3 | 83667 | 1188 | 3.580 | 23370.7 |
1280 | 2023-11-19 15:43:36 | agene | 2 | 53800 | 90 | 1.593 | 33772.8 |
1279 | 2023-11-16 07:17:43 | agene | 3 | 83667 | 1188 | 4.016 | 20833.4 |
1278 | 2023-11-13 23:59:30 | agene | 1 | 28756 | 8 | 0.500 | 57512.0 |
1277 | 2023-11-09 02:07:59 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1276 | 2023-11-01 01:57:17 | agene | 1 | 28756 | 8 | 0.703 | 40904.7 |
1275 | 2023-10-21 20:58:18 | agene | 1 | 28756 | 8 | 0.516 | 55728.7 |
1274 | 2023-10-21 09:46:12 | agene | 1 | 28756 | 8 | 0.580 | 49579.3 |
1273 | 2023-10-18 15:01:20 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1272 | 2023-10-16 09:52:32 | agene | 1 | 28756 | 8 | 0.530 | 54256.6 |
1271 | 2023-10-14 07:42:52 | agene | 1 | 28756 | 8 | 0.483 | 59536.2 |
1270 | 2023-10-03 17:57:49 | agene | 1 | 28756 | 8 | 0.436 | 65954.1 |
1269 | 2023-09-29 01:57:35 | agene | 3 | 83667 | 1188 | 4.060 | 20607.6 |
1268 | 2023-09-24 02:36:13 | agene | 3 | 83667 | 1188 | 3.403 | 24586.2 |
1267 | 2023-09-23 23:20:22 | agene | 1 | 28756 | 8 | 0.516 | 55728.7 |
1266 | 2023-09-23 19:22:44 | agene | 1 | 28756 | 8 | 0.436 | 65954.1 |
1265 | 2023-09-19 02:47:34 | agene | 3 | 83667 | 1188 | 3.343 | 25027.5 |
1264 | 2023-09-12 16:46:36 | agene | 2 | 53800 | 90 | 1.483 | 36277.8 |
1263 | 2023-09-09 22:08:23 | agene | 2 | 53800 | 90 | 1.420 | 37887.3 |
1262 | 2023-09-07 09:33:36 | agene | 1 | 28756 | 8 | 0.516 | 55728.7 |
1261 | 2023-09-03 19:37:33 | agene | 1 | 28756 | 8 | 0.533 | 53951.2 |
1260 | 2023-08-18 06:31:44 | agene | 3 | 83667 | 1188 | 3.313 | 25254.2 |
1259 | 2023-08-12 10:33:32 | agene | 1 | 28756 | 8 | 0.516 | 55728.7 |
1258 | 2023-08-10 23:34:29 | agene | 1 | 28756 | 8 | 0.516 | 55728.7 |
1257 | 2023-06-29 01:42:35 | agene | 1 | 28756 | 8 | 0.436 | 65954.1 |
1256 | 2023-06-03 16:18:37 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1255 | 2023-05-31 06:20:41 | agene | 2 | 53800 | 90 | 1.563 | 34421.0 |
1254 | 2023-05-20 13:25:45 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1253 | 2023-05-16 11:01:11 | agene | 1 | 28756 | 8 | 0.436 | 65954.1 |
1252 | 2023-05-07 01:51:11 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1251 | 2023-05-02 08:03:44 | agene | 3 | 83667 | 1188 | 7.703 | 10861.6 |
1250 | 2023-03-26 23:05:51 | agene | 1 | 28756 | 8 | 0.436 | 65954.1 |
1249 | 2023-03-17 04:29:38 | agene | 1 | 28756 | 8 | 0.500 | 57512.0 |
1248 | 2023-03-12 03:49:40 | agene | 1 | 28756 | 8 | 0.440 | 65354.5 |
1247 | 2023-03-08 14:40:43 | agene | 2 | 53800 | 90 | 1.376 | 39098.8 |
1246 | 2023-03-03 18:01:44 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1245 | 2023-03-01 00:59:57 | agene | 1 | 28756 | 8 | 0.436 | 65954.1 |
1244 | 2023-02-05 19:04:31 | agene | 3 | 83667 | 1188 | 3.436 | 24350.1 |
1243 | 2023-01-11 13:58:12 | agene | 1 | 28756 | 8 | 0.420 | 68466.7 |
1242 | 2023-01-01 13:34:47 | agene | 1 | 28756 | 8 | 0.436 | 65954.1 |
1241 | 2022-12-14 12:41:02 | agene | 2 | 53800 | 90 | 1.640 | 32804.9 |
1240 | 2022-12-08 04:27:12 | agene | 1 | 28756 | 8 | 0.500 | 57512.0 |
1239 | 2022-11-27 05:41:19 | agene | 1 | 28756 | 8 | 0.436 | 65954.1 |
1238 | 2022-11-26 06:42:35 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1237 | 2022-11-22 21:57:34 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1236 | 2022-11-19 13:53:27 | agene | 3 | 83667 | 1188 | 3.440 | 24321.8 |
1235 | 2022-10-22 00:34:09 | agene | 1 | 28756 | 8 | 0.530 | 54256.6 |
1234 | 2022-10-11 02:13:26 | agene | 1 | 28756 | 8 | 0.440 | 65354.5 |
1233 | 2022-09-22 15:27:57 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1232 | 2022-09-11 20:44:43 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1231 | 2022-09-08 12:05:40 | agene | 1 | 28756 | 8 | 0.483 | 59536.2 |
1230 | 2022-09-03 13:19:00 | agene | 1 | 28756 | 8 | 0.890 | 32310.1 |
1229 | 2022-09-03 10:55:36 | agene | 1 | 28756 | 8 | 0.500 | 57512.0 |
1228 | 2022-08-28 11:58:45 | agene | 1 | 28756 | 8 | 0.486 | 59168.7 |
1227 | 2022-08-22 12:41:49 | agene | 1 | 28756 | 8 | 0.483 | 59536.2 |
1226 | 2022-08-18 23:19:22 | agene | 1 | 28756 | 8 | 0.470 | 61183.0 |
1225 | 2022-08-18 07:55:44 | agene | 1 | 28756 | 8 | 0.483 | 59536.2 |
1224 | 2022-08-10 13:00:05 | agene | 1 | 28756 | 8 | 0.516 | 55728.7 |
1223 | 2022-08-06 16:10:54 | agene | 1 | 28756 | 8 | 1.000 | 28756.0 |
1222 | 2022-08-04 17:09:00 | agene | 2 | 53800 | 90 | 1.576 | 34137.1 |
1221 | 2022-07-29 21:18:56 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |
1220 | 2022-07-18 11:03:48 | agene | 1 | 28756 | 8 | 0.500 | 57512.0 |
1219 | 2022-07-07 17:16:17 | agene | 1 | 28756 | 8 | 0.500 | 57512.0 |
1218 | 2022-07-03 04:36:30 | agene | 1 | 28756 | 8 | 0.470 | 61183.0 |
1217 | 2022-06-16 04:44:24 | agene | 1 | 28756 | 8 | 0.453 | 63479.0 |