History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"soils"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1515 | 2024-04-30 14:17:15 | soils | 1 | 28756 | 14 | 1.140 | 25224.6 |
1514 | 2024-04-29 10:02:27 | soils | 1 | 28756 | 14 | 0.546 | 52666.7 |
1513 | 2024-04-27 01:37:45 | soils | 1 | 28756 | 14 | 2.310 | 12448.5 |
1512 | 2024-04-26 03:55:48 | soils | 1 | 28756 | 14 | 0.513 | 56054.6 |
1511 | 2024-04-19 22:25:48 | soils | 1 | 28756 | 14 | 0.656 | 43835.4 |
1510 | 2024-04-06 06:08:44 | soils | 2 | 53800 | 278 | 1.703 | 31591.3 |
1509 | 2024-04-03 01:15:57 | soils | 2 | 53800 | 278 | 3.983 | 13507.4 |
1508 | 2024-04-03 00:17:10 | soils | 1 | 28756 | 14 | 1.173 | 24514.9 |
1507 | 2024-03-31 02:59:43 | soils | 1 | 28756 | 14 | 1.936 | 14853.3 |
1506 | 2024-03-27 07:05:17 | soils | 1 | 28756 | 14 | 0.483 | 59536.2 |
1505 | 2024-02-27 10:43:47 | soils | 1 | 28756 | 14 | 0.546 | 52666.7 |
1504 | 2024-02-25 22:08:41 | soils | 2 | 53800 | 278 | 5.873 | 9160.6 |
1503 | 2024-02-25 22:07:47 | soils | 1 | 28756 | 14 | 1.486 | 19351.3 |
1502 | 2024-02-12 09:50:27 | soils | 1 | 28756 | 14 | 0.500 | 57512.0 |
1501 | 2024-01-29 02:41:33 | soils | 1 | 28756 | 14 | 0.546 | 52666.7 |
1500 | 2024-01-29 00:57:51 | soils | 1 | 28756 | 14 | 0.436 | 65954.1 |
1499 | 2024-01-26 21:01:01 | soils | 1 | 28756 | 14 | 0.453 | 63479.0 |
1498 | 2024-01-22 09:26:04 | soils | 1 | 28756 | 14 | 0.530 | 54256.6 |
1497 | 2024-01-06 23:03:28 | soils | 2 | 53800 | 278 | 1.670 | 32215.6 |
1496 | 2024-01-03 05:28:51 | soils | 1 | 28756 | 14 | 0.516 | 55728.7 |
1495 | 2024-01-01 17:12:36 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1494 | 2023-12-28 00:21:46 | soils | 2 | 53800 | 278 | 1.673 | 32157.8 |
1493 | 2023-12-28 00:21:44 | soils | 1 | 28756 | 14 | 0.513 | 56054.6 |
1492 | 2023-12-18 16:28:01 | soils | 1 | 28756 | 14 | 0.500 | 57512.0 |
1491 | 2023-12-17 15:51:38 | soils | 2 | 53800 | 278 | 1.423 | 37807.4 |
1490 | 2023-12-07 01:40:36 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1489 | 2023-12-07 01:40:35 | soils | 1 | 28756 | 14 | 0.513 | 56054.6 |
1488 | 2023-12-05 03:19:07 | soils | 2 | 53800 | 278 | 1.453 | 37026.8 |
1487 | 2023-11-29 08:27:42 | soils | 2 | 53800 | 278 | 1.470 | 36598.6 |
1486 | 2023-11-17 17:31:30 | soils | 2 | 53800 | 278 | 1.546 | 34799.5 |
1485 | 2023-11-13 16:27:39 | soils | 1 | 28756 | 14 | 0.516 | 55728.7 |
1484 | 2023-11-10 05:56:07 | soils | 1 | 28756 | 14 | 0.500 | 57512.0 |
1483 | 2023-11-08 11:07:33 | soils | 1 | 28756 | 14 | 0.453 | 63479.0 |
1482 | 2023-10-30 06:07:28 | soils | 2 | 53800 | 278 | 1.750 | 30742.9 |
1481 | 2023-10-26 06:30:57 | soils | 2 | 53800 | 278 | 1.580 | 34050.6 |
1480 | 2023-10-25 22:57:29 | soils | 1 | 28756 | 14 | 0.500 | 57512.0 |
1479 | 2023-10-24 07:10:06 | soils | 1 | 28756 | 14 | 0.513 | 56054.6 |
1478 | 2023-10-23 06:18:09 | soils | 2 | 53800 | 278 | 1.673 | 32157.8 |
1477 | 2023-10-22 01:58:00 | soils | 1 | 28756 | 14 | 0.500 | 57512.0 |
1476 | 2023-10-17 01:24:15 | soils | 1 | 28756 | 14 | 0.516 | 55728.7 |
1475 | 2023-10-13 21:55:53 | soils | 2 | 53800 | 278 | 1.466 | 36698.5 |
1474 | 2023-10-11 06:20:01 | soils | 1 | 28756 | 14 | 0.500 | 57512.0 |
1473 | 2023-10-09 07:37:09 | soils | 2 | 53800 | 278 | 1.780 | 30224.7 |
1472 | 2023-10-03 15:30:20 | soils | 1 | 28756 | 14 | 0.530 | 54256.6 |
1471 | 2023-09-26 08:33:58 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1470 | 2023-09-04 05:49:47 | soils | 2 | 53800 | 278 | 1.766 | 30464.3 |
1469 | 2023-09-03 08:54:26 | soils | 2 | 53800 | 278 | 1.373 | 39184.3 |
1468 | 2023-08-30 13:40:21 | soils | 2 | 53800 | 278 | 1.610 | 33416.1 |
1467 | 2023-08-18 10:18:57 | soils | 1 | 28756 | 14 | 0.513 | 56054.6 |
1466 | 2023-07-19 08:24:51 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1465 | 2023-05-15 20:21:11 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1464 | 2023-04-04 02:27:56 | soils | 1 | 28756 | 14 | 0.453 | 63479.0 |
1463 | 2023-03-11 21:09:07 | soils | 1 | 28756 | 14 | 0.906 | 31739.5 |
1462 | 2023-02-01 16:32:13 | soils | 2 | 53800 | 278 | 1.420 | 37887.3 |
1461 | 2023-01-17 07:39:52 | soils | 2 | 53800 | 278 | 1.423 | 37807.4 |
1460 | 2022-12-31 06:39:12 | soils | 1 | 28756 | 14 | 0.513 | 56054.6 |
1459 | 2022-12-18 21:19:38 | soils | 1 | 28756 | 14 | 0.513 | 56054.6 |
1458 | 2022-10-28 13:55:24 | soils | 2 | 53800 | 278 | 1.373 | 39184.3 |
1457 | 2022-09-21 06:29:07 | soils | 1 | 28756 | 14 | 0.453 | 63479.0 |
1456 | 2022-08-26 14:31:45 | soils | 2 | 53800 | 278 | 1.436 | 37465.2 |
1455 | 2022-08-22 07:29:47 | soils | 1 | 28756 | 14 | 0.466 | 61708.2 |
1454 | 2022-08-19 14:21:01 | soils | 2 | 53800 | 278 | 1.406 | 38264.6 |
1453 | 2022-08-18 18:19:56 | soils | 1 | 28756 | 14 | 0.483 | 59536.2 |
1452 | 2022-07-29 05:37:38 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1451 | 2022-07-19 08:27:06 | soils | 2 | 53800 | 278 | 1.576 | 34137.1 |
1450 | 2022-07-18 19:40:00 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1449 | 2022-07-17 23:01:27 | soils | 1 | 28756 | 14 | 0.516 | 55728.7 |
1448 | 2022-07-06 22:26:19 | soils | 2 | 53800 | 278 | 1.406 | 38264.6 |
1447 | 2022-07-03 02:51:12 | soils | 1 | 28756 | 14 | 0.453 | 63479.0 |
1446 | 2022-06-08 22:59:37 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1445 | 2022-05-29 07:59:46 | soils | 2 | 53800 | 278 | 1.406 | 38264.6 |
1444 | 2022-05-24 22:33:13 | soils | 2 | 53800 | 278 | 1.453 | 37026.8 |
1443 | 2022-05-18 08:15:02 | soils | 1 | 28756 | 14 | 0.546 | 52666.7 |
1442 | 2022-05-17 13:35:53 | soils | 1 | 28756 | 14 | 0.690 | 41675.4 |
1441 | 2022-05-16 17:52:33 | soils | 1 | 28756 | 14 | 0.516 | 55728.7 |
1440 | 2022-05-15 23:10:10 | soils | 1 | 28756 | 14 | 0.513 | 56054.6 |
1439 | 2022-05-14 16:11:42 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1438 | 2022-05-13 22:18:57 | soils | 1 | 28756 | 14 | 0.530 | 54256.6 |
1437 | 2022-05-13 07:04:05 | soils | 1 | 28756 | 14 | 0.516 | 55728.7 |
1436 | 2022-05-06 11:28:52 | soils | 2 | 53800 | 278 | 1.983 | 27130.6 |
1435 | 2022-05-05 08:36:08 | soils | 2 | 53800 | 278 | 1.720 | 31279.1 |
1434 | 2022-05-04 06:57:17 | soils | 2 | 53800 | 278 | 1.716 | 31352.0 |
1433 | 2022-05-03 08:57:28 | soils | 2 | 53800 | 278 | 3.640 | 14780.2 |
1432 | 2022-05-03 02:25:28 | soils | 1 | 28756 | 14 | 0.500 | 57512.0 |
1431 | 2022-04-21 16:33:56 | soils | 1 | 28756 | 14 | 0.610 | 47141.0 |
1430 | 2022-04-12 07:40:39 | soils | 1 | 28756 | 14 | 0.453 | 63479.0 |
1429 | 2022-04-11 21:08:36 | soils | 1 | 28756 | 14 | 0.546 | 52666.7 |
1428 | 2022-04-11 09:15:07 | soils | 1 | 28756 | 14 | 0.500 | 57512.0 |
1427 | 2022-04-10 23:13:30 | soils | 1 | 28756 | 14 | 0.546 | 52666.7 |
1426 | 2022-04-10 05:30:18 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1425 | 2022-04-09 18:20:04 | soils | 1 | 28756 | 14 | 0.470 | 61183.0 |
1424 | 2022-04-09 01:14:16 | soils | 1 | 28756 | 14 | 0.530 | 54256.6 |
1423 | 2022-03-31 03:55:37 | soils | 2 | 53800 | 278 | 3.500 | 15371.4 |
1422 | 2022-03-30 09:42:53 | soils | 2 | 53800 | 278 | 1.766 | 30464.3 |
1421 | 2022-03-29 13:03:05 | soils | 2 | 53800 | 278 | 3.296 | 16322.8 |
1420 | 2022-03-28 23:11:27 | soils | 2 | 53800 | 278 | 1.720 | 31279.1 |
1419 | 2022-03-28 01:21:24 | soils | 2 | 53800 | 278 | 1.423 | 37807.4 |
1418 | 2022-03-27 09:12:52 | soils | 2 | 53800 | 278 | 1.750 | 30742.9 |
1417 | 2022-03-26 19:50:45 | soils | 2 | 53800 | 278 | 1.516 | 35488.1 |
1416 | 2022-03-25 15:57:25 | soils | 2 | 53800 | 278 | 1.656 | 32487.9 |