History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rows"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1532 | 2025-01-04 21:54:05 | rows | 1 | 13983 | 30 | 1.296 | 10789.4 |
1531 | 2024-12-31 03:20:50 | rows | 1 | 13983 | 30 | 1.093 | 12793.2 |
1530 | 2024-12-27 13:35:15 | rows | 1 | 13983 | 30 | 2.173 | 6434.9 |
1529 | 2024-12-26 23:49:04 | rows | 1 | 13983 | 30 | 0.216 | 64736.1 |
1528 | 2024-12-26 07:29:27 | rows | 1 | 13983 | 30 | 1.156 | 12096.0 |
1527 | 2024-12-21 08:13:59 | rows | 1 | 13983 | 30 | 0.280 | 49939.3 |
1526 | 2024-12-11 02:14:26 | rows | 2 | 29872 | 476 | 4.533 | 6589.9 |
1525 | 2024-12-06 18:53:19 | rows | 2 | 29872 | 476 | 3.330 | 8970.6 |
1524 | 2024-12-06 13:41:29 | rows | 2 | 29872 | 476 | 4.936 | 6051.9 |
1523 | 2024-12-06 09:35:42 | rows | 2 | 29872 | 476 | 2.296 | 13010.5 |
1522 | 2024-12-06 09:35:14 | rows | 2 | 29872 | 476 | 4.703 | 6351.7 |
1521 | 2024-12-06 09:14:25 | rows | 1 | 13983 | 30 | 0.546 | 25609.9 |
1520 | 2024-11-26 23:25:24 | rows | 1 | 13983 | 30 | 1.093 | 12793.2 |
1519 | 2024-11-26 05:48:37 | rows | 1 | 13983 | 30 | 2.000 | 6991.5 |
1518 | 2024-11-26 01:37:41 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
1517 | 2024-11-17 16:00:50 | rows | 1 | 13983 | 30 | 1.470 | 9512.2 |
1516 | 2024-11-06 09:24:39 | rows | 2 | 29872 | 476 | 4.453 | 6708.3 |
1515 | 2024-11-06 06:14:45 | rows | 2 | 29872 | 476 | 4.623 | 6461.6 |
1514 | 2024-11-06 03:54:57 | rows | 2 | 29872 | 476 | 6.393 | 4672.6 |
1513 | 2024-11-06 03:30:05 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
1512 | 2024-10-27 19:03:59 | rows | 1 | 13983 | 30 | 1.360 | 10281.6 |
1511 | 2024-10-27 04:29:49 | rows | 1 | 13983 | 30 | 1.936 | 7222.6 |
1510 | 2024-10-27 00:36:44 | rows | 1 | 13983 | 30 | 0.343 | 40766.8 |
1509 | 2024-10-24 12:31:08 | rows | 1 | 13983 | 30 | 1.876 | 7453.6 |
1508 | 2024-10-20 05:08:29 | rows | 2 | 29872 | 476 | 2.406 | 12415.6 |
1507 | 2024-10-07 02:35:41 | rows | 1 | 13983 | 30 | 2.750 | 5084.7 |
1506 | 2024-09-27 15:07:23 | rows | 2 | 29872 | 476 | 4.546 | 6571.1 |
1505 | 2024-09-27 14:59:28 | rows | 2 | 29872 | 476 | 5.246 | 5694.2 |
1504 | 2024-09-27 14:49:01 | rows | 1 | 13983 | 30 | 0.296 | 47239.9 |
1503 | 2024-09-27 02:29:31 | rows | 1 | 13983 | 30 | 1.783 | 7842.4 |
1502 | 2024-09-26 19:32:40 | rows | 1 | 13983 | 30 | 1.780 | 7855.6 |
1501 | 2024-09-10 11:38:50 | rows | 1 | 13983 | 30 | 2.110 | 6627.0 |
1500 | 2024-09-06 20:31:19 | rows | 1 | 13983 | 30 | 1.173 | 11920.7 |
1499 | 2024-08-30 13:08:39 | rows | 1 | 13983 | 30 | 2.436 | 5740.1 |
1498 | 2024-08-27 18:38:30 | rows | 1 | 13983 | 30 | 0.606 | 23074.3 |
1497 | 2024-08-15 00:42:25 | rows | 1 | 13983 | 30 | 1.470 | 9512.2 |
1496 | 2024-08-08 23:47:32 | rows | 2 | 29872 | 476 | 3.453 | 8651.0 |
1495 | 2024-08-08 17:56:29 | rows | 1 | 13983 | 30 | 0.280 | 49939.3 |
1494 | 2024-08-08 07:40:48 | rows | 2 | 29872 | 476 | 1.906 | 15672.6 |
1493 | 2024-08-07 22:23:42 | rows | 2 | 29872 | 476 | 4.423 | 6753.8 |
1492 | 2024-08-07 20:49:12 | rows | 1 | 13983 | 30 | 1.060 | 13191.5 |
1491 | 2024-08-02 07:32:49 | rows | 1 | 13983 | 30 | 0.906 | 15433.8 |
1490 | 2024-07-29 18:58:54 | rows | 1 | 13983 | 30 | 0.670 | 20870.1 |
1489 | 2024-07-29 08:19:06 | rows | 2 | 29872 | 476 | 3.203 | 9326.3 |
1488 | 2024-07-29 05:38:55 | rows | 2 | 29872 | 476 | 3.313 | 9016.6 |
1487 | 2024-07-29 03:58:03 | rows | 2 | 29872 | 476 | 5.233 | 5708.4 |
1486 | 2024-07-29 03:45:54 | rows | 1 | 13983 | 30 | 0.733 | 19076.4 |
1485 | 2024-07-28 18:22:00 | rows | 1 | 13983 | 30 | 0.686 | 20383.4 |
1484 | 2024-07-28 00:24:13 | rows | 1 | 13983 | 30 | 0.280 | 49939.3 |
1483 | 2024-07-08 09:22:26 | rows | 1 | 13983 | 30 | 0.296 | 47239.9 |
1482 | 2024-07-06 14:57:29 | rows | 1 | 13983 | 30 | 0.970 | 14415.5 |
1481 | 2024-07-06 00:20:20 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
1480 | 2024-07-06 00:15:52 | rows | 1 | 13983 | 30 | 0.296 | 47239.9 |
1479 | 2024-07-03 03:03:21 | rows | 1 | 13983 | 30 | 0.330 | 42372.7 |
1478 | 2024-06-30 20:15:56 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
1477 | 2024-06-29 03:28:20 | rows | 1 | 13983 | 30 | 0.906 | 15433.8 |
1476 | 2024-06-28 14:33:28 | rows | 1 | 13983 | 30 | 0.936 | 14939.1 |
1475 | 2024-06-27 14:01:28 | rows | 1 | 13983 | 30 | 1.516 | 9223.6 |
1474 | 2024-06-24 14:06:30 | rows | 1 | 13983 | 30 | 0.563 | 24836.6 |
1473 | 2024-06-16 01:05:01 | rows | 1 | 13983 | 30 | 0.560 | 24969.6 |
1472 | 2024-06-13 04:47:02 | rows | 1 | 13983 | 30 | 1.266 | 11045.0 |
1471 | 2024-06-12 06:05:53 | rows | 1 | 13983 | 30 | 0.376 | 37188.8 |
1470 | 2024-06-03 06:29:12 | rows | 2 | 29872 | 476 | 0.890 | 33564.0 |
1469 | 2024-06-03 00:47:28 | rows | 1 | 13983 | 30 | 1.093 | 12793.2 |
1468 | 2024-05-30 03:06:41 | rows | 1 | 13983 | 30 | 1.610 | 8685.1 |
1467 | 2024-05-29 09:44:50 | rows | 1 | 13983 | 30 | 1.220 | 11461.5 |
1466 | 2024-05-18 10:25:45 | rows | 2 | 29872 | 476 | 1.080 | 27659.3 |
1465 | 2024-05-16 23:50:35 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
1464 | 2024-05-16 07:57:08 | rows | 2 | 29872 | 476 | 0.983 | 30388.6 |
1463 | 2024-05-14 05:42:22 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
1462 | 2024-05-09 18:10:01 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
1461 | 2024-04-29 03:12:53 | rows | 1 | 13983 | 30 | 1.000 | 13983.0 |
1460 | 2024-04-26 16:01:26 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
1459 | 2024-04-08 15:43:05 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
1458 | 2024-04-02 20:44:36 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
1457 | 2024-04-01 16:36:43 | rows | 1 | 13983 | 30 | 0.296 | 47239.9 |
1456 | 2024-03-30 23:16:53 | rows | 1 | 13983 | 30 | 0.800 | 17478.8 |
1455 | 2024-03-26 19:33:02 | rows | 1 | 13983 | 30 | 1.110 | 12597.3 |
1454 | 2024-03-11 23:30:13 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
1453 | 2024-03-03 20:40:21 | rows | 1 | 13983 | 30 | 0.546 | 25609.9 |
1452 | 2024-03-02 14:04:34 | rows | 1 | 13983 | 30 | 0.283 | 49409.9 |
1451 | 2024-02-29 22:51:54 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
1450 | 2024-02-25 16:26:36 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
1449 | 2024-01-28 16:47:47 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
1448 | 2024-01-26 09:30:33 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
1447 | 2024-01-17 08:04:16 | rows | 2 | 29872 | 476 | 0.750 | 39829.3 |
1446 | 2024-01-06 14:24:30 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
1445 | 2024-01-03 16:18:42 | rows | 1 | 13983 | 30 | 0.500 | 27966.0 |
1444 | 2023-12-16 01:14:53 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
1443 | 2023-11-28 03:11:34 | rows | 1 | 13983 | 30 | 0.406 | 34440.9 |
1442 | 2023-11-27 18:44:04 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
1441 | 2023-11-24 09:38:31 | rows | 2 | 29872 | 476 | 0.890 | 33564.0 |
1440 | 2023-11-24 02:08:16 | rows | 2 | 29872 | 476 | 0.966 | 30923.4 |
1439 | 2023-11-14 05:28:03 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
1438 | 2023-11-09 18:13:23 | rows | 2 | 29872 | 476 | 0.890 | 33564.0 |
1437 | 2023-11-07 08:22:48 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
1436 | 2023-11-03 17:56:02 | rows | 2 | 29872 | 476 | 0.783 | 38150.7 |
1435 | 2023-10-28 09:21:40 | rows | 2 | 29872 | 476 | 0.873 | 34217.6 |
1434 | 2023-10-27 19:26:50 | rows | 2 | 29872 | 476 | 0.923 | 32364.0 |
1433 | 2023-10-27 07:58:15 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |