History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hats"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1490 | 2024-04-26 17:28:00 | hats | 1 | 13983 | 43 | 0.483 | 28950.3 |
1489 | 2024-04-26 15:47:40 | hats | 2 | 29872 | 643 | 1.033 | 28917.7 |
1488 | 2024-04-25 05:29:21 | hats | 1 | 13983 | 43 | 0.653 | 21413.5 |
1487 | 2024-04-25 05:13:10 | hats | 1 | 13983 | 43 | 0.500 | 27966.0 |
1486 | 2024-04-25 05:12:28 | hats | 1 | 13983 | 43 | 0.313 | 44674.1 |
1485 | 2024-04-24 23:33:06 | hats | 1 | 13983 | 43 | 0.266 | 52567.7 |
1484 | 2024-04-09 18:45:34 | hats | 1 | 13983 | 43 | 0.280 | 49939.3 |
1483 | 2024-04-02 18:38:35 | hats | 1 | 13983 | 43 | 0.830 | 16847.0 |
1482 | 2024-04-01 16:43:06 | hats | 1 | 13983 | 43 | 0.280 | 49939.3 |
1481 | 2024-04-01 16:33:47 | hats | 1 | 13983 | 43 | 0.826 | 16928.6 |
1480 | 2024-03-31 00:12:03 | hats | 1 | 13983 | 43 | 1.110 | 12597.3 |
1479 | 2024-03-29 20:45:21 | hats | 1 | 13983 | 43 | 0.530 | 26383.0 |
1478 | 2024-03-26 20:21:56 | hats | 1 | 13983 | 43 | 1.203 | 11623.4 |
1477 | 2024-03-15 08:52:56 | hats | 1 | 13983 | 43 | 0.550 | 25423.6 |
1476 | 2024-03-02 14:17:26 | hats | 2 | 29872 | 643 | 3.063 | 9752.5 |
1475 | 2024-03-02 14:03:22 | hats | 1 | 13983 | 43 | 0.733 | 19076.4 |
1474 | 2024-03-01 07:26:32 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1473 | 2024-02-29 21:13:12 | hats | 1 | 13983 | 43 | 0.266 | 52567.7 |
1472 | 2024-01-28 15:52:51 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1471 | 2024-01-25 20:22:25 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1470 | 2024-01-23 12:00:10 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1469 | 2024-01-20 01:08:45 | hats | 1 | 13983 | 43 | 0.236 | 59250.0 |
1468 | 2024-01-17 14:01:47 | hats | 1 | 13983 | 43 | 0.236 | 59250.0 |
1467 | 2024-01-16 11:34:51 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1466 | 2023-12-30 13:34:57 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1465 | 2023-12-23 10:20:32 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1464 | 2023-12-04 00:22:37 | hats | 1 | 13983 | 43 | 0.313 | 44674.1 |
1463 | 2023-12-04 00:22:36 | hats | 1 | 13983 | 43 | 0.486 | 28771.6 |
1462 | 2023-11-25 17:12:30 | hats | 1 | 13983 | 43 | 0.266 | 52567.7 |
1461 | 2023-11-19 08:56:36 | hats | 2 | 29872 | 643 | 0.860 | 34734.9 |
1460 | 2023-11-17 10:12:00 | hats | 2 | 29872 | 643 | 0.920 | 32469.6 |
1459 | 2023-11-12 06:30:32 | hats | 2 | 29872 | 643 | 0.810 | 36879.0 |
1458 | 2023-11-10 21:52:06 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1457 | 2023-11-09 01:27:30 | hats | 1 | 13983 | 43 | 0.266 | 52567.7 |
1456 | 2023-11-08 19:35:25 | hats | 2 | 29872 | 643 | 0.766 | 38997.4 |
1455 | 2023-11-02 18:20:53 | hats | 2 | 29872 | 643 | 0.766 | 38997.4 |
1454 | 2023-10-26 02:46:44 | hats | 1 | 13983 | 43 | 0.263 | 53167.3 |
1453 | 2023-10-22 00:41:17 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1452 | 2023-10-19 22:23:28 | hats | 1 | 13983 | 43 | 0.236 | 59250.0 |
1451 | 2023-10-17 04:23:50 | hats | 1 | 13983 | 43 | 0.233 | 60012.9 |
1450 | 2023-10-11 09:53:01 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1449 | 2023-10-10 23:37:02 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1448 | 2023-10-05 14:46:44 | hats | 2 | 29872 | 643 | 1.593 | 18752.0 |
1447 | 2023-10-03 09:58:06 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1446 | 2023-09-27 09:42:57 | hats | 1 | 13983 | 43 | 0.326 | 42892.6 |
1445 | 2023-09-22 13:07:56 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1444 | 2023-09-20 21:39:44 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1443 | 2023-08-08 01:10:05 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1442 | 2023-06-27 01:50:11 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1441 | 2023-05-07 22:01:00 | hats | 1 | 13983 | 43 | 0.333 | 41991.0 |
1440 | 2023-04-22 17:55:49 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1439 | 2023-03-26 23:55:17 | hats | 1 | 13983 | 43 | 0.203 | 68881.8 |
1438 | 2023-03-21 03:55:17 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1437 | 2023-03-19 18:49:41 | hats | 1 | 13983 | 43 | 0.233 | 60012.9 |
1436 | 2023-03-03 23:49:20 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1435 | 2022-12-28 17:57:11 | hats | 1 | 13983 | 43 | 0.203 | 68881.8 |
1434 | 2022-12-16 01:23:22 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1433 | 2022-11-20 20:52:42 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1432 | 2022-11-16 22:38:03 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1431 | 2022-10-20 07:43:24 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1430 | 2022-09-19 22:28:05 | hats | 1 | 13983 | 43 | 0.233 | 60012.9 |
1429 | 2022-09-18 04:14:25 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1428 | 2022-09-17 17:31:36 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1427 | 2022-09-14 01:57:11 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1426 | 2022-09-08 16:24:54 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1425 | 2022-08-26 03:50:17 | hats | 1 | 13983 | 43 | 0.233 | 60012.9 |
1424 | 2022-08-14 20:11:28 | hats | 1 | 13983 | 43 | 0.233 | 60012.9 |
1423 | 2022-08-07 03:11:07 | hats | 1 | 13983 | 43 | 0.263 | 53167.3 |
1422 | 2022-07-30 04:00:49 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1421 | 2022-07-29 04:23:24 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1420 | 2022-07-28 23:33:19 | hats | 1 | 13983 | 43 | 0.313 | 44674.1 |
1419 | 2022-07-18 09:00:16 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1418 | 2022-07-03 11:13:56 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1417 | 2022-07-02 22:55:52 | hats | 1 | 13983 | 43 | 0.266 | 52567.7 |
1416 | 2022-06-16 11:13:20 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1415 | 2022-06-15 20:40:29 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1414 | 2022-06-08 16:52:37 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1413 | 2022-06-01 13:11:58 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1412 | 2022-05-30 12:37:00 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1411 | 2022-05-27 07:45:09 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1410 | 2022-05-26 03:15:55 | hats | 1 | 13983 | 43 | 0.280 | 49939.3 |
1409 | 2022-05-25 16:43:53 | hats | 1 | 13983 | 43 | 0.236 | 59250.0 |
1408 | 2022-03-20 04:29:28 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1407 | 2022-02-19 07:08:54 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1406 | 2021-12-28 06:07:06 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1405 | 2021-11-17 22:22:01 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1404 | 2021-10-28 21:32:24 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1403 | 2021-09-19 07:32:47 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1402 | 2021-08-18 09:43:00 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1401 | 2021-08-17 13:01:34 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1400 | 2021-08-15 09:01:50 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1399 | 2021-08-15 02:10:13 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1398 | 2021-08-12 12:23:02 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1397 | 2021-07-12 15:09:38 | hats | 1 | 13983 | 43 | 0.220 | 63559.1 |
1396 | 2021-06-30 00:49:59 | hats | 1 | 13983 | 43 | 0.216 | 64736.1 |
1395 | 2021-06-29 10:16:42 | hats | 1 | 13983 | 43 | 0.250 | 55932.0 |
1394 | 2021-06-28 23:13:40 | hats | 1 | 13983 | 43 | 0.266 | 52567.7 |
1393 | 2021-06-28 01:02:53 | hats | 1 | 13983 | 43 | 0.296 | 47239.9 |
1392 | 2021-06-21 21:26:39 | hats | 2 | 29872 | 643 | 0.780 | 38297.4 |
1391 | 2021-06-11 12:40:20 | hats | 1 | 13983 | 43 | 0.483 | 28950.3 |