History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aphtha"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1367 | 2024-05-05 14:31:09 | aphtha | 4 | 135143 | 1256 | 13.346 | 10126.1 |
1366 | 2024-05-05 07:54:38 | aphtha | 4 | 135143 | 1256 | 26.673 | 5066.7 |
1365 | 2024-05-05 03:51:49 | aphtha | 4 | 135143 | 1256 | 20.220 | 6683.6 |
1364 | 2024-05-04 03:19:54 | aphtha | 1 | 48755 | 3 | 0.953 | 51159.5 |
1363 | 2024-05-02 02:43:47 | aphtha | 3 | 112716 | 80 | 10.360 | 10879.9 |
1362 | 2024-05-02 02:43:51 | aphtha | 2 | 82551 | 5 | 2.643 | 31233.8 |
1361 | 2024-05-02 02:43:42 | aphtha | 1 | 48755 | 3 | 0.876 | 55656.4 |
1360 | 2024-05-01 20:42:35 | aphtha | 2 | 82551 | 5 | 5.640 | 14636.7 |
1359 | 2024-05-01 20:42:31 | aphtha | 3 | 112716 | 80 | 9.470 | 11902.4 |
1358 | 2024-05-01 20:42:27 | aphtha | 1 | 48755 | 3 | 1.800 | 27086.1 |
1357 | 2024-05-01 20:42:20 | aphtha | 2 | 82551 | 5 | 5.736 | 14391.7 |
1356 | 2024-05-01 20:42:08 | aphtha | 3 | 112716 | 80 | 6.390 | 17639.4 |
1355 | 2024-05-01 16:28:50 | aphtha | 3 | 112716 | 80 | 10.656 | 10577.7 |
1354 | 2024-05-01 08:42:41 | aphtha | 3 | 112716 | 80 | 16.690 | 6753.5 |
1353 | 2024-04-29 04:53:06 | aphtha | 4 | 135143 | 1256 | 10.623 | 12721.7 |
1352 | 2024-04-29 02:01:31 | aphtha | 4 | 135143 | 1256 | 13.580 | 9951.6 |
1351 | 2024-04-25 12:13:13 | aphtha | 4 | 135143 | 1256 | 27.376 | 4936.6 |
1350 | 2024-04-19 14:06:45 | aphtha | 4 | 135143 | 1256 | 22.046 | 6130.0 |
1349 | 2024-04-19 14:06:12 | aphtha | 4 | 135143 | 1256 | 13.376 | 10103.4 |
1348 | 2024-04-18 11:19:54 | aphtha | 1 | 48755 | 3 | 1.936 | 25183.4 |
1347 | 2024-04-12 12:18:43 | aphtha | 1 | 48755 | 3 | 1.143 | 42655.3 |
1346 | 2024-04-12 12:12:43 | aphtha | 1 | 48755 | 3 | 1.156 | 42175.6 |
1345 | 2024-04-12 12:11:32 | aphtha | 1 | 48755 | 3 | 1.096 | 44484.5 |
1344 | 2024-04-12 11:59:23 | aphtha | 1 | 48755 | 3 | 2.966 | 16438.0 |
1343 | 2024-04-12 04:24:37 | aphtha | 1 | 48755 | 3 | 2.030 | 24017.2 |
1342 | 2024-04-05 23:53:14 | aphtha | 4 | 135143 | 1256 | 35.656 | 3790.2 |
1341 | 2024-04-05 11:49:15 | aphtha | 4 | 135143 | 1256 | 14.003 | 9651.0 |
1340 | 2024-04-04 07:14:13 | aphtha | 4 | 135143 | 1256 | 16.733 | 8076.4 |
1339 | 2024-03-30 02:35:06 | aphtha | 1 | 48755 | 3 | 1.093 | 44606.6 |
1338 | 2024-03-30 01:27:08 | aphtha | 1 | 48755 | 3 | 1.936 | 25183.4 |
1337 | 2024-03-29 03:03:31 | aphtha | 4 | 135143 | 1256 | 20.330 | 6647.5 |
1336 | 2024-03-29 03:03:45 | aphtha | 1 | 48755 | 3 | 2.046 | 23829.4 |
1335 | 2024-03-29 03:03:32 | aphtha | 3 | 112716 | 80 | 8.860 | 12721.9 |
1334 | 2024-03-29 03:03:29 | aphtha | 2 | 82551 | 5 | 3.233 | 25533.9 |
1333 | 2024-03-08 12:25:47 | aphtha | 3 | 112716 | 80 | 14.860 | 7585.2 |
1332 | 2024-03-08 12:25:24 | aphtha | 4 | 135143 | 1256 | 19.800 | 6825.4 |
1331 | 2024-03-08 00:06:05 | aphtha | 3 | 112716 | 80 | 11.330 | 9948.5 |
1330 | 2024-03-06 21:40:38 | aphtha | 4 | 135143 | 1256 | 33.596 | 4022.6 |
1329 | 2024-03-06 11:37:47 | aphtha | 4 | 135143 | 1256 | 31.740 | 4257.8 |
1328 | 2024-03-06 05:10:19 | aphtha | 4 | 135143 | 1256 | 26.140 | 5170.0 |
1327 | 2024-03-06 02:29:15 | aphtha | 1 | 48755 | 3 | 1.970 | 24748.7 |
1326 | 2024-03-05 15:07:44 | aphtha | 3 | 112716 | 80 | 5.970 | 18880.4 |
1325 | 2024-03-05 15:07:46 | aphtha | 2 | 82551 | 5 | 2.720 | 30349.6 |
1324 | 2024-03-02 07:02:38 | aphtha | 4 | 135143 | 1256 | 23.346 | 5788.7 |
1323 | 2024-02-27 12:14:46 | aphtha | 4 | 135143 | 1256 | 10.033 | 13469.8 |
1322 | 2024-02-09 21:03:09 | aphtha | 4 | 135143 | 1256 | 8.720 | 15498.1 |
1321 | 2024-02-03 23:32:27 | aphtha | 1 | 48755 | 3 | 0.813 | 59969.2 |
1320 | 2024-02-03 23:32:03 | aphtha | 2 | 82551 | 5 | 2.500 | 33020.4 |
1319 | 2024-02-03 09:26:02 | aphtha | 2 | 82551 | 5 | 2.266 | 36430.3 |
1318 | 2024-02-03 09:25:54 | aphtha | 3 | 112716 | 80 | 5.343 | 21096.0 |
1317 | 2024-02-03 09:25:29 | aphtha | 4 | 135143 | 1256 | 10.126 | 13346.1 |
1316 | 2024-02-02 15:27:12 | aphtha | 2 | 82551 | 5 | 2.390 | 34540.2 |
1315 | 2024-02-02 15:27:00 | aphtha | 3 | 112716 | 80 | 4.830 | 23336.6 |
1314 | 2024-02-01 04:04:51 | aphtha | 2 | 82551 | 5 | 2.593 | 31836.1 |
1313 | 2024-02-01 04:04:44 | aphtha | 3 | 112716 | 80 | 5.513 | 20445.5 |
1312 | 2024-01-31 12:27:18 | aphtha | 2 | 82551 | 5 | 2.453 | 33653.1 |
1311 | 2024-01-31 12:27:14 | aphtha | 3 | 112716 | 80 | 4.936 | 22835.5 |
1310 | 2024-01-25 18:52:07 | aphtha | 4 | 135143 | 1256 | 19.660 | 6874.0 |
1309 | 2024-01-25 16:38:39 | aphtha | 4 | 135143 | 1256 | 9.780 | 13818.3 |
1308 | 2024-01-22 18:27:57 | aphtha | 4 | 135143 | 1256 | 14.830 | 9112.8 |
1307 | 2024-01-21 09:46:12 | aphtha | 1 | 48755 | 3 | 0.736 | 66243.2 |
1306 | 2024-01-18 22:35:37 | aphtha | 4 | 135143 | 1256 | 9.423 | 14341.8 |
1305 | 2023-12-05 10:39:55 | aphtha | 1 | 48755 | 3 | 0.826 | 59025.4 |
1304 | 2023-11-28 15:02:26 | aphtha | 4 | 135143 | 1256 | 8.173 | 16535.3 |
1303 | 2023-11-28 12:37:45 | aphtha | 1 | 48755 | 3 | 0.750 | 65006.7 |
1302 | 2023-11-23 14:08:38 | aphtha | 1 | 48755 | 3 | 0.923 | 52822.3 |
1301 | 2023-11-21 12:33:42 | aphtha | 1 | 48755 | 3 | 0.813 | 59969.2 |
1300 | 2023-11-17 06:39:03 | aphtha | 1 | 48755 | 3 | 0.843 | 57835.1 |
1299 | 2023-11-07 03:32:05 | aphtha | 1 | 48755 | 3 | 0.843 | 57835.1 |
1298 | 2023-10-20 10:58:59 | aphtha | 1 | 48755 | 3 | 0.766 | 63648.8 |
1297 | 2023-10-06 07:49:23 | aphtha | 1 | 48755 | 3 | 0.903 | 53992.2 |
1296 | 2023-09-24 12:34:19 | aphtha | 1 | 48755 | 3 | 0.750 | 65006.7 |
1295 | 2023-09-15 22:28:52 | aphtha | 1 | 48755 | 3 | 0.876 | 55656.4 |
1294 | 2023-09-03 07:42:53 | aphtha | 1 | 48755 | 3 | 0.750 | 65006.7 |
1293 | 2023-08-30 02:45:55 | aphtha | 4 | 135143 | 1256 | 8.766 | 15416.7 |
1292 | 2023-08-28 09:16:56 | aphtha | 4 | 135143 | 1256 | 8.233 | 16414.8 |
1291 | 2023-08-14 23:46:22 | aphtha | 4 | 135143 | 1256 | 10.096 | 13385.8 |
1290 | 2023-07-15 19:33:54 | aphtha | 1 | 48755 | 3 | 0.813 | 59969.2 |
1289 | 2023-07-12 13:23:53 | aphtha | 4 | 135143 | 1256 | 8.033 | 16823.5 |
1288 | 2023-07-07 17:05:26 | aphtha | 4 | 135143 | 1256 | 9.736 | 13880.8 |
1287 | 2023-06-08 06:09:47 | aphtha | 1 | 48755 | 3 | 0.750 | 65006.7 |
1286 | 2023-03-27 20:17:28 | aphtha | 1 | 48755 | 3 | 0.733 | 66514.3 |
1285 | 2023-03-24 09:09:00 | aphtha | 1 | 48755 | 3 | 0.826 | 59025.4 |
1284 | 2023-01-11 06:35:34 | aphtha | 1 | 48755 | 3 | 0.736 | 66243.2 |
1283 | 2022-12-02 22:22:47 | aphtha | 1 | 48755 | 3 | 0.826 | 59025.4 |
1282 | 2022-11-29 15:34:32 | aphtha | 1 | 48755 | 3 | 0.736 | 66243.2 |
1281 | 2022-10-16 11:22:43 | aphtha | 1 | 48755 | 3 | 0.750 | 65006.7 |
1280 | 2022-08-27 21:50:58 | aphtha | 1 | 48755 | 3 | 0.763 | 63899.1 |
1279 | 2022-08-23 14:37:54 | aphtha | 4 | 135143 | 1256 | 9.843 | 13729.9 |
1278 | 2022-08-03 05:18:06 | aphtha | 4 | 135143 | 1256 | 8.313 | 16256.8 |
1277 | 2022-08-02 17:22:33 | aphtha | 1 | 48755 | 3 | 0.750 | 65006.7 |
1276 | 2022-07-28 01:27:57 | aphtha | 4 | 135143 | 1256 | 8.516 | 15869.3 |
1275 | 2022-07-16 15:23:04 | aphtha | 2 | 82551 | 5 | 2.123 | 38884.1 |
1274 | 2022-07-03 02:35:46 | aphtha | 3 | 112716 | 80 | 4.610 | 24450.3 |
1273 | 2022-06-03 23:02:09 | aphtha | 1 | 48755 | 3 | 1.873 | 26030.4 |
1272 | 2022-06-01 03:20:51 | aphtha | 1 | 48755 | 3 | 0.843 | 57835.1 |
1271 | 2022-05-04 20:27:26 | aphtha | 1 | 48755 | 3 | 0.766 | 63648.8 |
1270 | 2022-03-28 18:57:38 | aphtha | 1 | 48755 | 3 | 0.966 | 50471.0 |
1269 | 2022-02-18 04:18:43 | aphtha | 1 | 48755 | 3 | 0.780 | 62506.4 |
1268 | 2021-12-14 11:40:26 | aphtha | 1 | 48755 | 3 | 1.780 | 27390.4 |