History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"strains"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1511 | 2025-09-07 20:32:17 | strains | 1 | 69583 | 6 | 1.233 | 56433.9 |
1510 | 2025-09-03 08:26:14 | strains | 3 | 134027 | 659 | 6.030 | 22226.7 |
1509 | 2025-08-31 09:30:17 | strains | 3 | 134027 | 659 | 7.000 | 19146.7 |
1508 | 2025-08-27 05:24:03 | strains | 1 | 69583 | 6 | 1.266 | 54962.9 |
1507 | 2025-08-22 10:04:37 | strains | 1 | 69583 | 6 | 1.096 | 63488.1 |
1506 | 2025-08-17 16:38:34 | strains | 1 | 69583 | 6 | 4.390 | 15850.3 |
1505 | 2025-08-16 07:26:30 | strains | 3 | 134027 | 659 | 7.313 | 18327.2 |
1504 | 2025-08-14 08:27:25 | strains | 3 | 134027 | 659 | 11.733 | 11423.1 |
1503 | 2025-08-04 13:42:10 | strains | 1 | 69583 | 6 | 1.296 | 53690.6 |
1502 | 2025-08-01 20:20:31 | strains | 3 | 134027 | 659 | 25.516 | 5252.7 |
1501 | 2025-08-01 08:51:28 | strains | 1 | 69583 | 6 | 5.470 | 12720.8 |
1500 | 2025-08-01 02:37:26 | strains | 3 | 134027 | 659 | 34.203 | 3918.6 |
1499 | 2025-07-31 04:45:41 | strains | 1 | 69583 | 6 | 1.140 | 61037.7 |
1498 | 2025-07-30 21:14:57 | strains | 3 | 134027 | 659 | 11.453 | 11702.3 |
1497 | 2025-07-30 12:38:02 | strains | 3 | 134027 | 659 | 34.206 | 3918.2 |
1496 | 2025-07-26 11:53:06 | strains | 2 | 107671 | 67 | 5.156 | 20882.7 |
1495 | 2025-07-26 04:18:37 | strains | 1 | 69583 | 6 | 1.263 | 55093.4 |
1494 | 2025-07-25 06:05:17 | strains | 1 | 69583 | 6 | 5.550 | 12537.5 |
1493 | 2025-07-24 18:58:10 | strains | 2 | 107671 | 67 | 15.203 | 7082.2 |
1492 | 2025-07-24 06:23:58 | strains | 1 | 69583 | 6 | 4.733 | 14701.7 |
1491 | 2025-07-23 06:39:34 | strains | 1 | 69583 | 6 | 7.376 | 9433.7 |
1490 | 2025-07-23 02:53:50 | strains | 1 | 69583 | 6 | 3.766 | 18476.6 |
1489 | 2025-07-23 00:11:02 | strains | 1 | 69583 | 6 | 7.466 | 9320.0 |
1488 | 2025-07-22 21:35:45 | strains | 1 | 69583 | 6 | 5.580 | 12470.1 |
1487 | 2025-07-22 03:27:44 | strains | 2 | 107671 | 67 | 4.626 | 23275.2 |
1486 | 2025-07-18 08:07:03 | strains | 3 | 134027 | 659 | 42.453 | 3157.1 |
1485 | 2025-07-17 21:39:27 | strains | 3 | 134027 | 659 | 24.453 | 5481.0 |
1484 | 2025-07-17 07:10:05 | strains | 3 | 134027 | 659 | 29.813 | 4495.6 |
1483 | 2025-07-15 15:41:38 | strains | 1 | 69583 | 6 | 6.516 | 10678.8 |
1482 | 2025-07-15 08:23:47 | strains | 2 | 107671 | 67 | 17.376 | 6196.5 |
1481 | 2025-07-15 07:57:43 | strains | 3 | 134027 | 659 | 31.220 | 4293.0 |
1480 | 2025-07-13 17:49:58 | strains | 1 | 69583 | 6 | 1.780 | 39091.6 |
1479 | 2025-07-07 08:00:04 | strains | 1 | 69583 | 6 | 8.530 | 8157.4 |
1478 | 2025-07-05 01:47:36 | strains | 1 | 69583 | 6 | 3.000 | 23194.3 |
1477 | 2025-06-30 13:35:57 | strains | 1 | 69583 | 6 | 6.360 | 10940.7 |
1476 | 2025-06-30 00:45:14 | strains | 1 | 69583 | 6 | 9.093 | 7652.4 |
1475 | 2025-06-28 07:33:55 | strains | 1 | 69583 | 6 | 6.156 | 11303.3 |
1474 | 2025-06-23 17:35:05 | strains | 1 | 69583 | 6 | 2.470 | 28171.3 |
1473 | 2025-06-20 08:09:19 | strains | 1 | 69583 | 6 | 7.110 | 9786.6 |
1472 | 2025-06-17 10:14:12 | strains | 1 | 69583 | 6 | 6.313 | 11022.2 |
1471 | 2025-06-15 19:35:37 | strains | 2 | 107671 | 67 | 17.266 | 6236.0 |
1470 | 2025-06-15 15:46:46 | strains | 3 | 134027 | 659 | 8.486 | 15793.9 |
1469 | 2025-06-15 05:50:49 | strains | 3 | 134027 | 659 | 9.466 | 14158.8 |
1468 | 2025-06-15 03:28:22 | strains | 3 | 134027 | 659 | 25.046 | 5351.2 |
1467 | 2025-06-13 15:39:27 | strains | 3 | 134027 | 659 | 23.220 | 5772.0 |
1466 | 2025-06-12 17:10:24 | strains | 1 | 69583 | 6 | 1.500 | 46388.7 |
1465 | 2025-06-12 00:57:38 | strains | 1 | 69583 | 6 | 3.266 | 21305.3 |
1464 | 2025-06-10 10:45:20 | strains | 1 | 69583 | 6 | 7.483 | 9298.8 |
1463 | 2025-06-07 20:54:51 | strains | 1 | 69583 | 6 | 3.126 | 22259.4 |
1462 | 2025-06-06 12:26:57 | strains | 1 | 69583 | 6 | 3.533 | 19695.2 |
1461 | 2025-06-04 06:42:23 | strains | 1 | 69583 | 6 | 5.796 | 12005.3 |
1460 | 2025-06-04 01:50:52 | strains | 1 | 69583 | 6 | 7.843 | 8872.0 |
1459 | 2025-06-02 00:00:13 | strains | 2 | 107671 | 67 | 10.470 | 10283.8 |
1458 | 2025-05-30 08:02:44 | strains | 1 | 69583 | 6 | 8.953 | 7772.0 |
1457 | 2025-05-29 06:39:41 | strains | 1 | 69583 | 6 | 5.110 | 13617.0 |
1456 | 2025-05-28 08:35:37 | strains | 3 | 134027 | 659 | 7.373 | 18178.1 |
1455 | 2025-05-27 18:30:02 | strains | 1 | 69583 | 6 | 1.233 | 56433.9 |
1454 | 2025-05-20 06:56:47 | strains | 1 | 69583 | 6 | 2.953 | 23563.5 |
1453 | 2025-05-18 13:38:37 | strains | 2 | 107671 | 67 | 14.596 | 7376.7 |
1452 | 2025-05-14 17:55:36 | strains | 1 | 69583 | 6 | 5.920 | 11753.9 |
1451 | 2025-05-14 15:31:11 | strains | 3 | 134027 | 659 | 35.450 | 3780.7 |
1450 | 2025-05-14 11:13:54 | strains | 1 | 69583 | 6 | 3.826 | 18186.9 |
1449 | 2025-05-13 11:15:23 | strains | 2 | 107671 | 67 | 16.453 | 6544.2 |
1448 | 2025-05-12 05:51:32 | strains | 3 | 134027 | 659 | 27.640 | 4849.0 |
1447 | 2025-05-11 07:20:31 | strains | 3 | 134027 | 659 | 47.773 | 2805.5 |
1446 | 2025-05-10 12:50:10 | strains | 3 | 134027 | 659 | 27.360 | 4898.6 |
1445 | 2025-05-09 01:44:44 | strains | 1 | 69583 | 6 | 1.390 | 50059.7 |
1444 | 2025-05-04 01:31:20 | strains | 1 | 69583 | 6 | 3.406 | 20429.5 |
1443 | 2025-05-02 11:55:18 | strains | 1 | 69583 | 6 | 4.156 | 16742.8 |
1442 | 2025-04-30 13:24:21 | strains | 2 | 107671 | 67 | 9.390 | 11466.6 |
1441 | 2025-04-29 11:53:40 | strains | 1 | 69583 | 6 | 2.843 | 24475.2 |
1440 | 2025-04-27 03:36:13 | strains | 1 | 69583 | 6 | 5.063 | 13743.4 |
1439 | 2025-04-25 07:39:07 | strains | 3 | 134027 | 659 | 33.970 | 3945.5 |
1438 | 2025-04-23 06:39:23 | strains | 3 | 134027 | 659 | 29.046 | 4614.3 |
1437 | 2025-04-23 03:41:01 | strains | 3 | 134027 | 659 | 42.760 | 3134.4 |
1436 | 2025-04-21 22:42:07 | strains | 3 | 134027 | 659 | 6.516 | 20568.9 |
1435 | 2025-04-21 01:24:40 | strains | 2 | 107671 | 67 | 11.783 | 9137.8 |
1434 | 2025-04-20 05:26:24 | strains | 1 | 69583 | 6 | 7.750 | 8978.5 |
1433 | 2025-04-20 02:10:21 | strains | 1 | 69583 | 6 | 3.563 | 19529.3 |
1432 | 2025-04-09 16:59:41 | strains | 1 | 69583 | 6 | 5.533 | 12576.0 |
1431 | 2025-04-03 16:10:28 | strains | 3 | 134027 | 659 | 32.066 | 4179.7 |
1430 | 2025-04-02 05:35:15 | strains | 3 | 134027 | 659 | 21.313 | 6288.5 |
1429 | 2025-04-02 01:34:38 | strains | 1 | 69583 | 6 | 5.580 | 12470.1 |
1428 | 2025-04-01 19:27:54 | strains | 2 | 107671 | 67 | 24.220 | 4445.5 |
1427 | 2025-03-31 17:37:59 | strains | 3 | 134027 | 659 | 31.146 | 4303.2 |
1426 | 2025-03-31 09:28:02 | strains | 3 | 134027 | 659 | 36.470 | 3675.0 |
1425 | 2025-03-31 09:28:08 | strains | 2 | 107671 | 67 | 16.830 | 6397.6 |
1424 | 2025-03-29 07:18:22 | strains | 3 | 134027 | 659 | 48.843 | 2744.0 |
1423 | 2025-03-29 01:23:54 | strains | 2 | 107671 | 67 | 11.140 | 9665.3 |
1422 | 2025-03-28 08:37:17 | strains | 1 | 69583 | 6 | 5.720 | 12164.9 |
1421 | 2025-03-20 06:25:22 | strains | 1 | 69583 | 6 | 3.406 | 20429.5 |
1420 | 2025-03-15 11:31:46 | strains | 3 | 134027 | 659 | 39.706 | 3375.5 |
1419 | 2025-03-15 10:14:20 | strains | 3 | 134027 | 659 | 34.406 | 3895.5 |
1418 | 2025-03-14 22:29:55 | strains | 1 | 69583 | 6 | 4.423 | 15732.1 |
1417 | 2025-03-14 18:09:21 | strains | 3 | 134027 | 659 | 34.770 | 3854.7 |
1416 | 2025-03-14 18:05:50 | strains | 1 | 69583 | 6 | 4.016 | 17326.4 |
1415 | 2025-03-12 14:32:41 | strains | 1 | 69583 | 6 | 5.970 | 11655.4 |
1414 | 2025-03-10 04:58:51 | strains | 1 | 69583 | 6 | 5.016 | 13872.2 |
1413 | 2025-03-06 20:13:23 | strains | 1 | 69583 | 6 | 4.343 | 16021.9 |
1412 | 2025-03-02 04:26:10 | strains | 1 | 69583 | 6 | 6.106 | 11395.8 |