History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"road"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1542 | 2024-03-26 23:27:23 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1541 | 2024-03-05 20:09:50 | road | 1 | 13983 | 15 | 0.280 | 49939.3 |
1540 | 2024-03-02 18:06:03 | road | 2 | 29872 | 264 | 3.063 | 9752.5 |
1539 | 2024-03-02 17:46:08 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1538 | 2024-02-29 09:40:58 | road | 2 | 29872 | 264 | 1.750 | 17069.7 |
1537 | 2024-02-26 22:07:37 | road | 1 | 13983 | 15 | 0.266 | 52567.7 |
1536 | 2024-02-25 20:33:57 | road | 2 | 29872 | 264 | 1.593 | 18752.0 |
1535 | 2024-02-25 20:33:32 | road | 1 | 13983 | 15 | 0.280 | 49939.3 |
1534 | 2024-02-08 19:56:40 | road | 1 | 13983 | 15 | 0.280 | 49939.3 |
1533 | 2024-02-07 00:07:26 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1532 | 2024-01-28 20:49:59 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1531 | 2024-01-28 13:29:47 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1530 | 2024-01-26 17:30:21 | road | 1 | 13983 | 15 | 0.263 | 53167.3 |
1529 | 2024-01-17 16:43:42 | road | 2 | 29872 | 264 | 0.873 | 34217.6 |
1528 | 2023-12-25 05:39:52 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1527 | 2023-12-17 20:25:33 | road | 2 | 29872 | 264 | 0.953 | 31345.2 |
1526 | 2023-12-16 11:55:44 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1525 | 2023-12-07 07:10:36 | road | 2 | 29872 | 264 | 0.843 | 35435.3 |
1524 | 2023-12-03 13:02:08 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1523 | 2023-12-03 13:02:08 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1522 | 2023-11-22 22:46:57 | road | 1 | 13983 | 15 | 0.266 | 52567.7 |
1521 | 2023-11-18 08:58:24 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1520 | 2023-11-18 07:04:43 | road | 2 | 29872 | 264 | 1.030 | 29001.9 |
1519 | 2023-11-12 01:12:36 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1518 | 2023-11-11 21:48:40 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1517 | 2023-11-05 12:49:12 | road | 1 | 13983 | 15 | 0.266 | 52567.7 |
1516 | 2023-10-29 11:40:23 | road | 2 | 29872 | 264 | 0.893 | 33451.3 |
1515 | 2023-10-28 05:30:28 | road | 1 | 13983 | 15 | 0.216 | 64736.1 |
1514 | 2023-10-25 21:33:48 | road | 1 | 13983 | 15 | 0.266 | 52567.7 |
1513 | 2023-10-19 21:27:50 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1512 | 2023-10-18 23:56:38 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1511 | 2023-10-15 05:43:45 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1510 | 2023-10-11 22:22:52 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1509 | 2023-10-11 19:18:12 | road | 1 | 13983 | 15 | 0.253 | 55268.8 |
1508 | 2023-10-05 03:51:39 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1507 | 2023-09-27 05:20:31 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1506 | 2023-09-14 16:17:49 | road | 2 | 29872 | 264 | 0.810 | 36879.0 |
1505 | 2023-09-11 06:29:26 | road | 1 | 13983 | 15 | 0.516 | 27098.8 |
1504 | 2023-08-21 05:05:08 | road | 2 | 29872 | 264 | 0.780 | 38297.4 |
1503 | 2023-08-07 15:44:49 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1502 | 2023-06-21 05:09:59 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1501 | 2023-05-31 01:04:28 | road | 1 | 13983 | 15 | 0.216 | 64736.1 |
1500 | 2023-05-07 11:02:18 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1499 | 2023-05-04 21:43:53 | road | 2 | 29872 | 264 | 0.750 | 39829.3 |
1498 | 2023-03-05 19:28:14 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1497 | 2023-02-28 14:35:01 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1496 | 2023-02-11 06:31:55 | road | 2 | 29872 | 264 | 0.970 | 30795.9 |
1495 | 2022-12-26 12:14:48 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1494 | 2022-11-26 07:41:50 | road | 2 | 29872 | 264 | 0.750 | 39829.3 |
1493 | 2022-11-23 10:40:49 | road | 2 | 29872 | 264 | 1.576 | 18954.3 |
1492 | 2022-11-13 14:36:16 | road | 1 | 13983 | 15 | 0.216 | 64736.1 |
1491 | 2022-09-19 23:58:50 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1490 | 2022-09-18 16:42:34 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1489 | 2022-09-17 19:14:02 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1488 | 2022-09-14 12:31:27 | road | 1 | 13983 | 15 | 0.216 | 64736.1 |
1487 | 2022-09-12 06:33:56 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1486 | 2022-08-31 02:43:05 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1485 | 2022-08-18 22:15:28 | road | 2 | 29872 | 264 | 0.750 | 39829.3 |
1484 | 2022-08-15 00:40:57 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1483 | 2022-08-14 11:53:37 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1482 | 2022-08-08 22:15:39 | road | 2 | 29872 | 264 | 0.890 | 33564.0 |
1481 | 2022-08-07 03:49:39 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1480 | 2022-08-06 21:42:02 | road | 2 | 29872 | 264 | 0.766 | 38997.4 |
1479 | 2022-08-05 22:51:10 | road | 2 | 29872 | 264 | 0.783 | 38150.7 |
1478 | 2022-08-04 00:00:48 | road | 2 | 29872 | 264 | 0.763 | 39150.7 |
1477 | 2022-07-30 04:30:02 | road | 1 | 13983 | 15 | 0.216 | 64736.1 |
1476 | 2022-07-26 23:16:24 | road | 2 | 29872 | 264 | 0.796 | 37527.6 |
1475 | 2022-07-22 21:57:23 | road | 2 | 29872 | 264 | 0.796 | 37527.6 |
1474 | 2022-07-20 17:54:55 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1473 | 2022-07-19 22:26:17 | road | 2 | 29872 | 264 | 0.860 | 34734.9 |
1472 | 2022-07-17 19:58:46 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1471 | 2022-07-17 00:48:39 | road | 1 | 13983 | 15 | 0.236 | 59250.0 |
1470 | 2022-07-15 22:09:50 | road | 2 | 29872 | 264 | 0.796 | 37527.6 |
1469 | 2022-07-11 09:36:01 | road | 2 | 29872 | 264 | 0.780 | 38297.4 |
1468 | 2022-07-03 11:31:46 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1467 | 2022-07-02 07:27:44 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1466 | 2022-06-16 11:31:32 | road | 1 | 13983 | 15 | 0.203 | 68881.8 |
1465 | 2022-05-30 01:13:13 | road | 2 | 29872 | 264 | 0.796 | 37527.6 |
1464 | 2022-05-26 03:30:24 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1463 | 2022-05-18 10:45:25 | road | 2 | 29872 | 264 | 0.800 | 37340.0 |
1462 | 2022-05-17 18:29:07 | road | 2 | 29872 | 264 | 0.780 | 38297.4 |
1461 | 2022-05-17 09:11:35 | road | 2 | 29872 | 264 | 1.313 | 22751.0 |
1460 | 2022-05-16 15:19:58 | road | 2 | 29872 | 264 | 1.000 | 29872.0 |
1459 | 2022-05-15 22:19:28 | road | 2 | 29872 | 264 | 0.826 | 36164.6 |
1458 | 2022-05-15 03:32:33 | road | 2 | 29872 | 264 | 0.966 | 30923.4 |
1457 | 2022-05-14 09:53:53 | road | 2 | 29872 | 264 | 0.780 | 38297.4 |
1456 | 2022-05-13 17:29:12 | road | 2 | 29872 | 264 | 0.780 | 38297.4 |
1455 | 2022-05-13 07:14:17 | road | 2 | 29872 | 264 | 5.016 | 5955.3 |
1454 | 2022-05-12 21:52:18 | road | 2 | 29872 | 264 | 1.160 | 25751.7 |
1453 | 2022-05-06 23:27:38 | road | 2 | 29872 | 264 | 0.766 | 38997.4 |
1452 | 2022-05-06 11:25:23 | road | 2 | 29872 | 264 | 0.876 | 34100.5 |
1451 | 2022-05-05 18:45:16 | road | 2 | 29872 | 264 | 0.876 | 34100.5 |
1450 | 2022-05-05 11:03:32 | road | 2 | 29872 | 264 | 1.000 | 29872.0 |
1449 | 2022-05-04 19:58:35 | road | 2 | 29872 | 264 | 0.920 | 32469.6 |
1448 | 2022-05-04 08:33:01 | road | 2 | 29872 | 264 | 1.733 | 17237.2 |
1447 | 2022-05-03 22:30:43 | road | 2 | 29872 | 264 | 1.123 | 26600.2 |
1446 | 2022-05-03 05:30:47 | road | 2 | 29872 | 264 | 0.966 | 30923.4 |
1445 | 2022-05-02 14:17:35 | road | 2 | 29872 | 264 | 0.766 | 38997.4 |
1444 | 2022-04-28 17:00:17 | road | 2 | 29872 | 264 | 1.156 | 25840.8 |
1443 | 2022-04-26 12:13:46 | road | 2 | 29872 | 264 | 1.000 | 29872.0 |