History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shop"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1545 | 2024-04-27 11:52:30 | shop | 1 | 13983 | 17 | 0.876 | 15962.3 |
1544 | 2024-04-25 22:25:55 | shop | 2 | 29872 | 223 | 0.826 | 36164.6 |
1543 | 2024-04-24 08:50:29 | shop | 1 | 13983 | 17 | 0.860 | 16259.3 |
1542 | 2024-04-20 21:59:44 | shop | 1 | 13983 | 17 | 0.436 | 32071.1 |
1541 | 2024-04-19 09:29:20 | shop | 1 | 13983 | 17 | 0.360 | 38841.7 |
1540 | 2024-04-16 19:40:11 | shop | 1 | 13983 | 17 | 0.326 | 42892.6 |
1539 | 2024-04-15 02:45:04 | shop | 1 | 13983 | 17 | 0.266 | 52567.7 |
1538 | 2024-04-02 18:06:35 | shop | 1 | 13983 | 17 | 0.843 | 16587.2 |
1537 | 2024-04-01 16:12:46 | shop | 1 | 13983 | 17 | 0.530 | 26383.0 |
1536 | 2024-03-31 00:41:34 | shop | 2 | 29872 | 223 | 3.750 | 7965.9 |
1535 | 2024-03-26 21:00:39 | shop | 1 | 13983 | 17 | 0.686 | 20383.4 |
1534 | 2024-03-21 21:41:28 | shop | 1 | 13983 | 17 | 0.216 | 64736.1 |
1533 | 2024-03-20 18:21:40 | shop | 1 | 13983 | 17 | 0.233 | 60012.9 |
1532 | 2024-03-17 10:53:08 | shop | 1 | 13983 | 17 | 0.546 | 25609.9 |
1531 | 2024-03-15 14:54:53 | shop | 1 | 13983 | 17 | 0.220 | 63559.1 |
1530 | 2024-03-02 14:27:42 | shop | 2 | 29872 | 223 | 2.483 | 12030.6 |
1529 | 2024-03-02 13:49:26 | shop | 1 | 13983 | 17 | 0.813 | 17199.3 |
1528 | 2024-02-25 16:52:42 | shop | 1 | 13983 | 17 | 0.453 | 30867.5 |
1527 | 2024-02-20 02:51:14 | shop | 2 | 29872 | 223 | 3.013 | 9914.4 |
1526 | 2024-02-19 17:09:56 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1525 | 2024-02-17 00:49:10 | shop | 1 | 13983 | 17 | 0.280 | 49939.3 |
1524 | 2024-01-30 00:08:26 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1523 | 2024-01-26 02:11:01 | shop | 1 | 13983 | 17 | 0.530 | 26383.0 |
1522 | 2024-01-19 17:41:18 | shop | 1 | 13983 | 17 | 0.220 | 63559.1 |
1521 | 2024-01-15 14:48:14 | shop | 1 | 13983 | 17 | 0.220 | 63559.1 |
1520 | 2024-01-01 21:01:20 | shop | 1 | 13983 | 17 | 0.203 | 68881.8 |
1519 | 2023-12-30 08:24:04 | shop | 1 | 13983 | 17 | 0.233 | 60012.9 |
1518 | 2023-12-19 23:07:06 | shop | 2 | 29872 | 223 | 0.923 | 32364.0 |
1517 | 2023-12-19 05:36:11 | shop | 2 | 29872 | 223 | 0.906 | 32971.3 |
1516 | 2023-12-18 22:56:21 | shop | 2 | 29872 | 223 | 0.970 | 30795.9 |
1515 | 2023-12-18 01:52:16 | shop | 2 | 29872 | 223 | 0.846 | 35309.7 |
1514 | 2023-12-17 08:30:38 | shop | 2 | 29872 | 223 | 0.810 | 36879.0 |
1513 | 2023-12-12 20:32:20 | shop | 2 | 29872 | 223 | 0.763 | 39150.7 |
1512 | 2023-12-11 20:29:50 | shop | 2 | 29872 | 223 | 0.830 | 35990.4 |
1511 | 2023-12-10 22:11:08 | shop | 2 | 29872 | 223 | 0.750 | 39829.3 |
1510 | 2023-12-10 10:18:05 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1509 | 2023-12-09 22:01:40 | shop | 2 | 29872 | 223 | 0.846 | 35309.7 |
1508 | 2023-11-30 17:04:00 | shop | 2 | 29872 | 223 | 0.736 | 40587.0 |
1507 | 2023-11-29 14:06:46 | shop | 2 | 29872 | 223 | 0.876 | 34100.5 |
1506 | 2023-11-28 15:01:19 | shop | 2 | 29872 | 223 | 0.750 | 39829.3 |
1505 | 2023-11-28 08:47:04 | shop | 2 | 29872 | 223 | 0.783 | 38150.7 |
1504 | 2023-11-27 19:36:19 | shop | 2 | 29872 | 223 | 0.826 | 36164.6 |
1503 | 2023-11-27 17:26:00 | shop | 2 | 29872 | 223 | 0.783 | 38150.7 |
1502 | 2023-11-22 02:06:16 | shop | 2 | 29872 | 223 | 0.936 | 31914.5 |
1501 | 2023-11-13 03:26:03 | shop | 1 | 13983 | 17 | 0.216 | 64736.1 |
1500 | 2023-11-12 08:28:21 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1499 | 2023-11-11 12:06:57 | shop | 1 | 13983 | 17 | 0.216 | 64736.1 |
1498 | 2023-11-09 20:17:15 | shop | 2 | 29872 | 223 | 0.750 | 39829.3 |
1497 | 2023-11-09 06:54:35 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1496 | 2023-11-05 01:57:23 | shop | 1 | 13983 | 17 | 0.203 | 68881.8 |
1495 | 2023-11-03 18:24:01 | shop | 1 | 13983 | 17 | 0.220 | 63559.1 |
1494 | 2023-10-27 14:40:01 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1493 | 2023-10-26 14:34:17 | shop | 1 | 13983 | 17 | 0.216 | 64736.1 |
1492 | 2023-10-21 08:19:01 | shop | 1 | 13983 | 17 | 0.236 | 59250.0 |
1491 | 2023-10-17 19:48:13 | shop | 1 | 13983 | 17 | 0.233 | 60012.9 |
1490 | 2023-10-14 06:11:23 | shop | 1 | 13983 | 17 | 0.203 | 68881.8 |
1489 | 2023-10-11 17:25:06 | shop | 2 | 29872 | 223 | 1.516 | 19704.5 |
1488 | 2023-10-09 03:12:55 | shop | 2 | 29872 | 223 | 0.826 | 36164.6 |
1487 | 2023-10-03 15:20:04 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1486 | 2023-09-19 17:25:40 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1485 | 2023-09-19 15:25:09 | shop | 2 | 29872 | 223 | 0.920 | 32469.6 |
1484 | 2023-09-18 00:58:46 | shop | 2 | 29872 | 223 | 0.843 | 35435.3 |
1483 | 2023-09-12 10:30:06 | shop | 1 | 13983 | 17 | 0.220 | 63559.1 |
1482 | 2023-08-31 03:08:36 | shop | 1 | 13983 | 17 | 0.266 | 52567.7 |
1481 | 2023-08-18 03:40:24 | shop | 2 | 29872 | 223 | 0.813 | 36742.9 |
1480 | 2023-07-22 01:15:10 | shop | 2 | 29872 | 223 | 0.843 | 35435.3 |
1479 | 2023-07-13 09:17:33 | shop | 1 | 13983 | 17 | 0.236 | 59250.0 |
1478 | 2023-06-21 05:40:29 | shop | 2 | 29872 | 223 | 0.763 | 39150.7 |
1477 | 2023-06-04 21:02:32 | shop | 1 | 13983 | 17 | 0.203 | 68881.8 |
1476 | 2023-05-08 21:30:52 | shop | 1 | 13983 | 17 | 0.216 | 64736.1 |
1475 | 2023-03-29 08:14:26 | shop | 1 | 13983 | 17 | 0.220 | 63559.1 |
1474 | 2023-03-22 06:01:23 | shop | 1 | 13983 | 17 | 0.236 | 59250.0 |
1473 | 2023-03-20 14:19:01 | shop | 1 | 13983 | 17 | 0.216 | 64736.1 |
1472 | 2023-03-17 05:13:51 | shop | 2 | 29872 | 223 | 0.783 | 38150.7 |
1471 | 2023-01-12 03:50:50 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1470 | 2022-12-20 00:13:30 | shop | 2 | 29872 | 223 | 0.750 | 39829.3 |
1469 | 2022-12-04 04:17:27 | shop | 1 | 13983 | 17 | 0.203 | 68881.8 |
1468 | 2022-11-11 05:04:17 | shop | 1 | 13983 | 17 | 0.216 | 64736.1 |
1467 | 2022-10-24 02:26:39 | shop | 1 | 13983 | 17 | 0.220 | 63559.1 |
1466 | 2022-08-29 08:08:20 | shop | 1 | 13983 | 17 | 0.233 | 60012.9 |
1465 | 2022-08-16 22:21:14 | shop | 2 | 29872 | 223 | 0.750 | 39829.3 |
1464 | 2022-08-14 13:17:37 | shop | 2 | 29872 | 223 | 0.763 | 39150.7 |
1463 | 2022-08-07 06:04:55 | shop | 1 | 13983 | 17 | 0.250 | 55932.0 |
1462 | 2022-08-03 22:36:03 | shop | 1 | 13983 | 17 | 0.216 | 64736.1 |
1461 | 2022-07-29 03:36:08 | shop | 1 | 13983 | 17 | 0.220 | 63559.1 |
1460 | 2022-07-19 11:45:11 | shop | 2 | 29872 | 223 | 0.826 | 36164.6 |
1459 | 2022-06-13 23:40:59 | shop | 1 | 13983 | 17 | 0.236 | 59250.0 |
1458 | 2022-06-11 20:33:02 | shop | 1 | 13983 | 17 | 0.220 | 63559.1 |
1457 | 2022-05-18 17:35:12 | shop | 2 | 29872 | 223 | 0.860 | 34734.9 |
1456 | 2022-05-18 06:49:57 | shop | 2 | 29872 | 223 | 0.783 | 38150.7 |
1455 | 2022-05-17 16:26:09 | shop | 2 | 29872 | 223 | 0.876 | 34100.5 |
1454 | 2022-05-16 22:46:32 | shop | 2 | 29872 | 223 | 1.236 | 24168.3 |
1453 | 2022-05-16 10:34:26 | shop | 2 | 29872 | 223 | 0.953 | 31345.2 |
1452 | 2022-05-15 21:06:51 | shop | 2 | 29872 | 223 | 0.780 | 38297.4 |
1451 | 2022-05-14 03:52:15 | shop | 2 | 29872 | 223 | 0.920 | 32469.6 |
1450 | 2022-05-13 20:49:46 | shop | 2 | 29872 | 223 | 0.733 | 40753.1 |
1449 | 2022-05-13 10:53:49 | shop | 2 | 29872 | 223 | 0.936 | 31914.5 |
1448 | 2022-05-13 01:38:46 | shop | 2 | 29872 | 223 | 0.783 | 38150.7 |
1447 | 2022-05-12 12:29:26 | shop | 2 | 29872 | 223 | 0.903 | 33080.8 |
1446 | 2022-05-11 14:14:07 | shop | 2 | 29872 | 223 | 1.266 | 23595.6 |