History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"retail"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1514 | 2024-04-20 14:25:47 | retail | 1 | 48755 | 9 | 1.030 | 47335.0 |
1513 | 2024-04-19 12:31:25 | retail | 1 | 48755 | 9 | 1.780 | 27390.4 |
1512 | 2024-04-05 03:53:36 | retail | 1 | 48755 | 9 | 1.280 | 38089.8 |
1511 | 2024-03-14 16:09:23 | retail | 1 | 48755 | 9 | 0.890 | 54780.9 |
1510 | 2024-02-29 00:53:36 | retail | 2 | 82551 | 76 | 2.656 | 31080.9 |
1509 | 2024-02-29 00:53:16 | retail | 3 | 112716 | 655 | 6.013 | 18745.4 |
1508 | 2024-02-28 05:21:10 | retail | 3 | 112716 | 655 | 12.423 | 9073.2 |
1507 | 2024-02-28 05:21:14 | retail | 2 | 82551 | 76 | 6.000 | 13758.5 |
1506 | 2024-02-28 02:07:45 | retail | 2 | 82551 | 76 | 2.720 | 30349.6 |
1505 | 2024-02-28 02:07:25 | retail | 3 | 112716 | 655 | 6.580 | 17130.1 |
1504 | 2024-02-26 15:26:00 | retail | 3 | 112716 | 655 | 5.673 | 19868.9 |
1503 | 2024-02-26 15:26:01 | retail | 2 | 82551 | 76 | 2.483 | 33246.5 |
1502 | 2024-01-29 04:49:26 | retail | 2 | 82551 | 76 | 2.516 | 32810.4 |
1501 | 2024-01-29 04:46:18 | retail | 3 | 112716 | 655 | 6.033 | 18683.2 |
1500 | 2024-01-29 03:12:11 | retail | 2 | 82551 | 76 | 2.843 | 29036.6 |
1499 | 2024-01-29 00:35:59 | retail | 2 | 82551 | 76 | 2.233 | 36968.7 |
1498 | 2024-01-29 00:35:23 | retail | 3 | 112716 | 655 | 5.736 | 19650.6 |
1497 | 2024-01-27 10:25:29 | retail | 3 | 112716 | 655 | 8.860 | 12721.9 |
1496 | 2024-01-27 10:25:33 | retail | 2 | 82551 | 76 | 2.500 | 33020.4 |
1495 | 2024-01-12 17:11:16 | retail | 1 | 48755 | 9 | 0.763 | 63899.1 |
1494 | 2024-01-10 22:19:41 | retail | 2 | 82551 | 76 | 2.203 | 37472.1 |
1493 | 2023-12-21 19:03:43 | retail | 3 | 112716 | 655 | 5.890 | 19136.8 |
1492 | 2023-12-21 19:03:46 | retail | 2 | 82551 | 76 | 2.610 | 31628.7 |
1491 | 2023-12-14 19:08:29 | retail | 3 | 112716 | 655 | 5.143 | 21916.4 |
1490 | 2023-12-14 02:01:45 | retail | 3 | 112716 | 655 | 4.890 | 23050.3 |
1489 | 2023-12-12 02:48:23 | retail | 3 | 112716 | 655 | 6.156 | 18309.9 |
1488 | 2023-12-12 02:48:25 | retail | 2 | 82551 | 76 | 2.830 | 29170.0 |
1487 | 2023-12-11 06:30:48 | retail | 1 | 48755 | 9 | 0.846 | 57630.0 |
1486 | 2023-11-12 09:18:24 | retail | 1 | 48755 | 9 | 1.673 | 29142.3 |
1485 | 2023-11-10 23:11:40 | retail | 1 | 48755 | 9 | 0.766 | 63648.8 |
1484 | 2023-11-05 22:31:20 | retail | 1 | 48755 | 9 | 0.766 | 63648.8 |
1483 | 2023-11-05 01:40:04 | retail | 3 | 112716 | 655 | 5.890 | 19136.8 |
1482 | 2023-11-02 02:03:26 | retail | 1 | 48755 | 9 | 0.783 | 62266.9 |
1481 | 2023-11-01 16:55:16 | retail | 3 | 112716 | 655 | 5.046 | 22337.7 |
1480 | 2023-11-01 16:55:15 | retail | 2 | 82551 | 76 | 2.326 | 35490.5 |
1479 | 2023-10-28 08:13:14 | retail | 3 | 112716 | 655 | 6.046 | 18643.1 |
1478 | 2023-10-28 08:13:09 | retail | 2 | 82551 | 76 | 2.453 | 33653.1 |
1477 | 2023-10-25 21:04:39 | retail | 1 | 48755 | 9 | 0.766 | 63648.8 |
1476 | 2023-10-21 02:53:44 | retail | 2 | 82551 | 76 | 2.563 | 32208.7 |
1475 | 2023-10-20 18:02:41 | retail | 1 | 48755 | 9 | 0.966 | 50471.0 |
1474 | 2023-10-19 00:47:55 | retail | 2 | 82551 | 76 | 2.250 | 36689.3 |
1473 | 2023-10-17 23:52:34 | retail | 1 | 48755 | 9 | 0.843 | 57835.1 |
1472 | 2023-10-11 19:30:33 | retail | 1 | 48755 | 9 | 0.800 | 60943.8 |
1471 | 2023-10-04 12:56:53 | retail | 1 | 48755 | 9 | 0.766 | 63648.8 |
1470 | 2023-09-25 16:45:36 | retail | 1 | 48755 | 9 | 0.876 | 55656.4 |
1469 | 2023-09-20 18:34:34 | retail | 1 | 48755 | 9 | 0.766 | 63648.8 |
1468 | 2023-09-13 23:23:01 | retail | 3 | 112716 | 655 | 6.750 | 16698.7 |
1467 | 2023-09-13 20:43:35 | retail | 3 | 112716 | 655 | 5.093 | 22131.6 |
1466 | 2023-09-03 23:29:53 | retail | 3 | 112716 | 655 | 5.093 | 22131.6 |
1465 | 2023-08-27 03:52:53 | retail | 1 | 48755 | 9 | 0.830 | 58741.0 |
1464 | 2023-08-15 04:06:33 | retail | 1 | 48755 | 9 | 0.780 | 62506.4 |
1463 | 2023-07-30 16:12:56 | retail | 2 | 82551 | 76 | 3.156 | 26156.8 |
1462 | 2023-06-27 10:54:56 | retail | 3 | 112716 | 655 | 6.236 | 18075.0 |
1461 | 2023-06-23 18:50:18 | retail | 3 | 112716 | 655 | 7.890 | 14285.9 |
1460 | 2023-06-15 13:32:12 | retail | 3 | 112716 | 655 | 4.810 | 23433.7 |
1459 | 2023-05-29 10:40:00 | retail | 1 | 48755 | 9 | 0.860 | 56691.9 |
1458 | 2023-04-30 14:10:57 | retail | 1 | 48755 | 9 | 0.873 | 55847.7 |
1457 | 2023-04-08 03:09:19 | retail | 2 | 82551 | 76 | 2.173 | 37989.4 |
1456 | 2023-03-23 11:23:50 | retail | 1 | 48755 | 9 | 0.750 | 65006.7 |
1455 | 2023-03-16 08:08:26 | retail | 3 | 112716 | 655 | 4.813 | 23419.1 |
1454 | 2023-01-14 14:13:47 | retail | 1 | 48755 | 9 | 0.750 | 65006.7 |
1453 | 2023-01-08 04:21:26 | retail | 1 | 48755 | 9 | 0.750 | 65006.7 |
1452 | 2023-01-06 04:26:32 | retail | 2 | 82551 | 76 | 2.423 | 34069.7 |
1451 | 2022-12-19 08:12:52 | retail | 3 | 112716 | 655 | 5.046 | 22337.7 |
1450 | 2022-10-06 13:23:24 | retail | 1 | 48755 | 9 | 0.766 | 63648.8 |
1449 | 2022-09-26 23:54:33 | retail | 1 | 48755 | 9 | 0.766 | 63648.8 |
1448 | 2022-09-12 09:23:16 | retail | 2 | 82551 | 76 | 2.233 | 36968.7 |
1447 | 2022-09-10 13:18:26 | retail | 1 | 48755 | 9 | 0.843 | 57835.1 |
1446 | 2022-08-23 02:49:23 | retail | 3 | 112716 | 655 | 5.690 | 19809.5 |
1445 | 2022-08-15 20:32:24 | retail | 1 | 48755 | 9 | 0.873 | 55847.7 |
1444 | 2022-08-14 22:21:22 | retail | 3 | 112716 | 655 | 5.560 | 20272.7 |
1443 | 2022-07-18 12:44:13 | retail | 1 | 48755 | 9 | 0.766 | 63648.8 |
1442 | 2022-07-17 22:13:31 | retail | 1 | 48755 | 9 | 0.830 | 58741.0 |
1441 | 2022-06-28 16:56:26 | retail | 2 | 82551 | 76 | 2.216 | 37252.3 |
1440 | 2022-06-25 08:15:48 | retail | 1 | 48755 | 9 | 0.953 | 51159.5 |
1439 | 2022-06-24 20:25:17 | retail | 1 | 48755 | 9 | 0.750 | 65006.7 |
1438 | 2022-06-10 00:36:35 | retail | 1 | 48755 | 9 | 0.890 | 54780.9 |
1437 | 2022-05-23 10:29:50 | retail | 1 | 48755 | 9 | 0.826 | 59025.4 |
1436 | 2022-05-21 06:14:23 | retail | 1 | 48755 | 9 | 0.843 | 57835.1 |
1435 | 2022-03-05 08:02:51 | retail | 1 | 48755 | 9 | 0.780 | 62506.4 |
1434 | 2022-02-12 03:33:23 | retail | 2 | 82551 | 76 | 2.186 | 37763.5 |
1433 | 2022-01-31 12:05:24 | retail | 1 | 48755 | 9 | 0.940 | 51867.0 |
1432 | 2021-12-14 07:58:35 | retail | 1 | 48755 | 9 | 0.923 | 52822.3 |
1431 | 2021-12-13 07:50:14 | retail | 1 | 48755 | 9 | 0.796 | 61250.0 |
1430 | 2021-11-18 05:45:06 | retail | 1 | 48755 | 9 | 0.876 | 55656.4 |
1429 | 2021-11-16 05:59:43 | retail | 1 | 48755 | 9 | 0.830 | 58741.0 |
1428 | 2021-11-10 21:10:49 | retail | 2 | 82551 | 76 | 2.656 | 31080.9 |
1427 | 2021-09-29 17:59:18 | retail | 1 | 48755 | 9 | 1.796 | 27146.4 |
1426 | 2021-08-26 01:36:42 | retail | 1 | 48755 | 9 | 0.763 | 63899.1 |
1425 | 2021-08-23 21:44:16 | retail | 1 | 48755 | 9 | 0.750 | 65006.7 |
1424 | 2021-08-18 17:23:15 | retail | 1 | 48755 | 9 | 0.800 | 60943.8 |
1423 | 2021-06-03 15:16:41 | retail | 1 | 48755 | 9 | 0.923 | 52822.3 |
1422 | 2021-05-21 09:56:03 | retail | 3 | 112716 | 655 | 5.000 | 22543.2 |
1421 | 2021-05-14 18:19:29 | retail | 1 | 48755 | 9 | 0.843 | 57835.1 |
1420 | 2021-05-09 09:14:07 | retail | 1 | 48755 | 9 | 1.140 | 42767.5 |
1419 | 2021-05-02 12:46:27 | retail | 1 | 48755 | 9 | 0.890 | 54780.9 |
1418 | 2021-02-25 02:28:47 | retail | 2 | 82551 | 76 | 2.720 | 30349.6 |
1417 | 2021-02-14 19:25:42 | retail | 3 | 112716 | 655 | 9.000 | 12524.0 |
1416 | 2021-02-11 18:43:41 | retail | 1 | 48755 | 9 | 0.766 | 63648.8 |
1415 | 2021-02-06 21:12:50 | retail | 3 | 112716 | 655 | 5.250 | 21469.7 |