History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"proteid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1341 | 2025-04-11 01:47:41 | proteid | 1 | 69583 | 6 | 4.420 | 15742.8 |
1340 | 2025-04-06 15:20:43 | proteid | 1 | 69583 | 6 | 5.670 | 12272.1 |
1339 | 2025-04-04 07:09:50 | proteid | 1 | 69583 | 6 | 5.610 | 12403.4 |
1338 | 2025-04-03 15:27:28 | proteid | 1 | 69583 | 6 | 1.200 | 57985.8 |
1337 | 2025-03-31 20:58:43 | proteid | 1 | 69583 | 6 | 5.266 | 13213.6 |
1336 | 2025-03-31 07:16:10 | proteid | 2 | 107671 | 28 | 24.813 | 4339.3 |
1335 | 2025-03-29 18:23:48 | proteid | 2 | 107671 | 28 | 26.330 | 4089.3 |
1334 | 2025-03-25 08:21:29 | proteid | 2 | 107671 | 28 | 15.986 | 6735.3 |
1333 | 2025-03-24 14:30:04 | proteid | 1 | 69583 | 6 | 1.200 | 57985.8 |
1332 | 2025-03-20 10:48:00 | proteid | 1 | 69583 | 6 | 6.516 | 10678.8 |
1331 | 2025-03-06 20:39:40 | proteid | 3 | 134027 | 298 | 41.816 | 3205.2 |
1330 | 2025-03-06 13:11:44 | proteid | 3 | 134027 | 298 | 31.986 | 4190.2 |
1329 | 2025-03-06 06:33:08 | proteid | 3 | 134027 | 298 | 31.550 | 4248.1 |
1328 | 2025-03-06 00:44:39 | proteid | 3 | 134027 | 298 | 31.516 | 4252.7 |
1327 | 2025-03-05 19:11:01 | proteid | 3 | 134027 | 298 | 34.360 | 3900.7 |
1326 | 2025-03-05 05:05:27 | proteid | 1 | 69583 | 6 | 2.903 | 23969.3 |
1325 | 2025-02-28 20:54:47 | proteid | 1 | 69583 | 6 | 3.313 | 21003.0 |
1324 | 2025-02-24 18:49:29 | proteid | 1 | 69583 | 6 | 6.250 | 11133.3 |
1323 | 2025-02-03 22:27:06 | proteid | 3 | 134027 | 298 | 31.236 | 4290.8 |
1322 | 2025-02-02 04:59:29 | proteid | 3 | 134027 | 298 | 36.453 | 3676.7 |
1321 | 2025-02-02 04:59:39 | proteid | 2 | 107671 | 28 | 16.470 | 6537.4 |
1320 | 2025-02-02 04:59:16 | proteid | 1 | 69583 | 6 | 5.533 | 12576.0 |
1319 | 2025-01-25 15:07:51 | proteid | 1 | 69583 | 6 | 5.643 | 12330.9 |
1318 | 2024-12-30 15:16:16 | proteid | 1 | 69583 | 6 | 8.810 | 7898.2 |
1317 | 2024-12-26 08:26:16 | proteid | 1 | 69583 | 6 | 3.610 | 19275.1 |
1316 | 2024-12-08 01:18:38 | proteid | 1 | 69583 | 6 | 2.936 | 23699.9 |
1315 | 2024-11-24 05:29:22 | proteid | 3 | 134027 | 298 | 34.170 | 3922.4 |
1314 | 2024-11-23 23:12:00 | proteid | 3 | 134027 | 298 | 41.610 | 3221.0 |
1313 | 2024-11-22 11:06:10 | proteid | 3 | 134027 | 298 | 34.140 | 3925.8 |
1312 | 2024-11-21 14:30:32 | proteid | 3 | 134027 | 298 | 16.720 | 8016.0 |
1311 | 2024-11-21 14:30:36 | proteid | 2 | 107671 | 28 | 12.736 | 8454.1 |
1310 | 2024-11-21 14:27:22 | proteid | 1 | 69583 | 6 | 2.860 | 24329.7 |
1309 | 2024-11-07 05:21:42 | proteid | 1 | 69583 | 6 | 5.780 | 12038.6 |
1308 | 2024-10-26 21:14:02 | proteid | 1 | 69583 | 6 | 2.953 | 23563.5 |
1307 | 2024-10-23 18:29:44 | proteid | 1 | 69583 | 6 | 6.906 | 10075.7 |
1306 | 2024-10-23 18:22:00 | proteid | 1 | 69583 | 6 | 6.406 | 10862.2 |
1305 | 2024-10-23 18:15:21 | proteid | 1 | 69583 | 6 | 6.733 | 10334.6 |
1304 | 2024-10-17 22:34:45 | proteid | 1 | 69583 | 6 | 6.046 | 11508.9 |
1303 | 2024-10-08 03:54:27 | proteid | 1 | 69583 | 6 | 9.560 | 7278.6 |
1302 | 2024-09-23 18:44:04 | proteid | 1 | 69583 | 6 | 8.983 | 7746.1 |
1301 | 2024-09-10 01:48:05 | proteid | 1 | 69583 | 6 | 8.906 | 7813.0 |
1300 | 2024-08-28 01:24:07 | proteid | 1 | 69583 | 6 | 9.673 | 7193.5 |
1299 | 2024-08-25 16:19:39 | proteid | 1 | 69583 | 6 | 10.423 | 6675.9 |
1298 | 2024-08-17 01:52:55 | proteid | 1 | 69583 | 6 | 12.640 | 5505.0 |
1297 | 2024-08-13 14:58:16 | proteid | 1 | 69583 | 6 | 8.750 | 7952.3 |
1296 | 2024-08-10 07:50:55 | proteid | 1 | 69583 | 6 | 6.046 | 11508.9 |
1295 | 2024-08-07 22:28:49 | proteid | 1 | 69583 | 6 | 4.563 | 15249.4 |
1294 | 2024-07-31 16:28:53 | proteid | 2 | 107671 | 28 | 10.750 | 10015.9 |
1293 | 2024-07-30 21:28:48 | proteid | 2 | 107671 | 28 | 5.296 | 20330.6 |
1292 | 2024-07-27 14:09:57 | proteid | 1 | 69583 | 6 | 2.236 | 31119.4 |
1291 | 2024-07-26 21:02:03 | proteid | 1 | 69583 | 6 | 2.813 | 24736.2 |
1290 | 2024-07-24 03:11:30 | proteid | 1 | 69583 | 6 | 4.153 | 16754.9 |
1289 | 2024-07-21 13:02:20 | proteid | 3 | 134027 | 298 | 28.046 | 4778.8 |
1288 | 2024-07-18 09:48:44 | proteid | 1 | 69583 | 6 | 7.470 | 9315.0 |
1287 | 2024-07-17 22:07:39 | proteid | 3 | 134027 | 298 | 14.470 | 9262.4 |
1286 | 2024-07-17 19:38:10 | proteid | 3 | 134027 | 298 | 21.160 | 6334.0 |
1285 | 2024-07-17 13:11:03 | proteid | 3 | 134027 | 298 | 12.500 | 10722.2 |
1284 | 2024-07-17 10:47:16 | proteid | 3 | 134027 | 298 | 18.830 | 7117.7 |
1283 | 2024-07-17 10:47:05 | proteid | 2 | 107671 | 28 | 12.593 | 8550.1 |
1282 | 2024-07-17 10:46:07 | proteid | 1 | 69583 | 6 | 2.483 | 28023.8 |
1281 | 2024-07-12 10:12:52 | proteid | 1 | 69583 | 6 | 7.486 | 9295.1 |
1280 | 2024-07-11 04:39:08 | proteid | 1 | 69583 | 6 | 5.500 | 12651.5 |
1279 | 2024-06-29 15:47:38 | proteid | 1 | 69583 | 6 | 2.330 | 29863.9 |
1278 | 2024-06-26 17:15:05 | proteid | 1 | 69583 | 6 | 4.280 | 16257.7 |
1277 | 2024-06-18 08:56:45 | proteid | 1 | 69583 | 6 | 3.110 | 22374.0 |
1276 | 2024-06-16 20:19:19 | proteid | 1 | 69583 | 6 | 3.610 | 19275.1 |
1275 | 2024-06-14 19:18:27 | proteid | 1 | 69583 | 6 | 5.013 | 13880.5 |
1274 | 2024-06-07 05:57:06 | proteid | 1 | 69583 | 6 | 1.220 | 57035.2 |
1273 | 2024-06-04 15:36:00 | proteid | 3 | 134027 | 298 | 30.983 | 4325.8 |
1272 | 2024-05-29 10:23:50 | proteid | 1 | 69583 | 6 | 4.050 | 17181.0 |
1271 | 2024-05-14 00:38:43 | proteid | 2 | 107671 | 28 | 3.516 | 30623.2 |
1270 | 2024-05-12 10:39:00 | proteid | 3 | 134027 | 298 | 14.093 | 9510.2 |
1269 | 2024-05-12 03:16:45 | proteid | 3 | 134027 | 298 | 17.503 | 7657.4 |
1268 | 2024-05-11 06:19:53 | proteid | 2 | 107671 | 28 | 8.033 | 13403.6 |
1267 | 2024-05-11 06:19:52 | proteid | 3 | 134027 | 298 | 8.220 | 16305.0 |
1266 | 2024-05-11 06:19:46 | proteid | 1 | 69583 | 6 | 1.890 | 36816.4 |
1265 | 2024-05-11 06:19:23 | proteid | 3 | 134027 | 298 | 7.250 | 18486.5 |
1264 | 2024-05-10 16:09:58 | proteid | 3 | 134027 | 298 | 6.516 | 20568.9 |
1263 | 2024-05-07 04:08:37 | proteid | 1 | 69583 | 6 | 2.670 | 26061.0 |
1262 | 2024-05-01 09:00:18 | proteid | 1 | 69583 | 6 | 3.720 | 18705.1 |
1261 | 2024-04-28 06:51:28 | proteid | 2 | 107671 | 28 | 3.953 | 27237.8 |
1260 | 2024-04-28 06:03:39 | proteid | 1 | 69583 | 6 | 4.143 | 16795.3 |
1259 | 2024-03-28 06:33:19 | proteid | 1 | 69583 | 6 | 1.280 | 54361.7 |
1258 | 2024-03-13 04:26:55 | proteid | 1 | 69583 | 6 | 1.280 | 54361.7 |
1257 | 2024-03-08 23:49:57 | proteid | 3 | 134027 | 298 | 12.733 | 10526.0 |
1256 | 2024-03-08 23:48:58 | proteid | 3 | 134027 | 298 | 22.813 | 5875.0 |
1255 | 2024-03-07 23:54:28 | proteid | 3 | 134027 | 298 | 6.750 | 19855.9 |
1254 | 2024-03-07 05:33:44 | proteid | 3 | 134027 | 298 | 19.846 | 6753.4 |
1253 | 2024-03-07 05:33:42 | proteid | 2 | 107671 | 28 | 3.923 | 27446.1 |
1252 | 2024-03-07 00:54:41 | proteid | 1 | 69583 | 6 | 1.093 | 63662.4 |
1251 | 2024-01-19 16:13:31 | proteid | 3 | 134027 | 298 | 6.673 | 20085.0 |
1250 | 2024-01-16 05:45:38 | proteid | 1 | 69583 | 6 | 1.266 | 54962.9 |
1249 | 2024-01-10 19:36:19 | proteid | 1 | 69583 | 6 | 1.080 | 64428.7 |
1248 | 2024-01-09 02:04:13 | proteid | 2 | 107671 | 28 | 3.563 | 30219.2 |
1247 | 2023-12-18 01:07:07 | proteid | 1 | 69583 | 6 | 1.063 | 65459.1 |
1246 | 2023-12-16 16:13:45 | proteid | 2 | 107671 | 28 | 6.093 | 17671.3 |
1245 | 2023-12-16 08:17:53 | proteid | 3 | 134027 | 298 | 6.420 | 20876.5 |
1244 | 2023-12-08 14:38:05 | proteid | 1 | 69583 | 6 | 1.173 | 59320.5 |
1243 | 2023-11-19 21:38:39 | proteid | 1 | 69583 | 6 | 1.203 | 57841.2 |
1242 | 2023-11-11 17:59:54 | proteid | 3 | 134027 | 298 | 7.253 | 18478.8 |