History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hose"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1507 | 2024-04-23 23:33:00 | hose | 1 | 13983 | 30 | 0.656 | 21315.5 |
1506 | 2024-04-18 07:08:43 | hose | 1 | 13983 | 30 | 0.500 | 27966.0 |
1505 | 2024-04-15 12:50:36 | hose | 1 | 13983 | 30 | 0.296 | 47239.9 |
1504 | 2024-04-11 12:39:56 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1503 | 2024-04-05 17:59:10 | hose | 1 | 13983 | 30 | 0.236 | 59250.0 |
1502 | 2024-04-02 18:28:08 | hose | 1 | 13983 | 30 | 0.516 | 27098.8 |
1501 | 2024-04-01 16:30:37 | hose | 1 | 13983 | 30 | 0.860 | 16259.3 |
1500 | 2024-03-26 23:43:23 | hose | 1 | 13983 | 30 | 0.533 | 26234.5 |
1499 | 2024-03-19 05:57:16 | hose | 1 | 13983 | 30 | 0.843 | 16587.2 |
1498 | 2024-03-17 20:00:06 | hose | 2 | 29872 | 419 | 3.030 | 9858.7 |
1497 | 2024-03-10 00:56:23 | hose | 1 | 13983 | 30 | 0.623 | 22444.6 |
1496 | 2024-03-02 16:09:00 | hose | 2 | 29872 | 419 | 0.903 | 33080.8 |
1495 | 2024-03-02 14:36:53 | hose | 2 | 29872 | 419 | 1.280 | 23337.5 |
1494 | 2024-03-02 13:40:53 | hose | 1 | 13983 | 30 | 0.266 | 52567.7 |
1493 | 2024-02-25 20:41:31 | hose | 1 | 13983 | 30 | 0.283 | 49409.9 |
1492 | 2024-02-24 11:23:03 | hose | 1 | 13983 | 30 | 0.203 | 68881.8 |
1491 | 2024-02-17 19:04:56 | hose | 1 | 13983 | 30 | 0.500 | 27966.0 |
1490 | 2024-02-14 16:43:10 | hose | 2 | 29872 | 419 | 0.783 | 38150.7 |
1489 | 2024-02-14 06:24:55 | hose | 1 | 13983 | 30 | 0.423 | 33056.7 |
1488 | 2024-02-01 10:38:15 | hose | 1 | 13983 | 30 | 0.546 | 25609.9 |
1487 | 2024-01-26 17:44:45 | hose | 1 | 13983 | 30 | 0.516 | 27098.8 |
1486 | 2024-01-21 07:35:37 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1485 | 2024-01-18 14:51:05 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1484 | 2024-01-16 23:26:49 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1483 | 2024-01-15 22:39:24 | hose | 1 | 13983 | 30 | 0.266 | 52567.7 |
1482 | 2024-01-15 19:43:21 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1481 | 2023-12-31 20:01:06 | hose | 2 | 29872 | 419 | 0.826 | 36164.6 |
1480 | 2023-12-07 10:25:14 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1479 | 2023-12-01 00:52:34 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1478 | 2023-11-28 12:20:58 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1477 | 2023-11-27 23:57:21 | hose | 2 | 29872 | 419 | 1.873 | 15948.7 |
1476 | 2023-11-22 12:07:57 | hose | 2 | 29872 | 419 | 0.750 | 39829.3 |
1475 | 2023-11-12 20:27:04 | hose | 2 | 29872 | 419 | 0.813 | 36742.9 |
1474 | 2023-11-11 05:02:22 | hose | 2 | 29872 | 419 | 0.813 | 36742.9 |
1473 | 2023-11-09 08:41:32 | hose | 2 | 29872 | 419 | 0.890 | 33564.0 |
1472 | 2023-11-08 11:09:44 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1471 | 2023-11-08 04:19:13 | hose | 1 | 13983 | 30 | 0.236 | 59250.0 |
1470 | 2023-11-08 03:07:57 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1469 | 2023-11-07 10:27:50 | hose | 2 | 29872 | 419 | 0.860 | 34734.9 |
1468 | 2023-11-07 10:09:04 | hose | 1 | 13983 | 30 | 0.263 | 53167.3 |
1467 | 2023-11-04 12:34:37 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1466 | 2023-11-02 07:32:23 | hose | 1 | 13983 | 30 | 0.500 | 27966.0 |
1465 | 2023-10-27 06:10:15 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1464 | 2023-10-19 17:03:48 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1463 | 2023-10-19 16:24:17 | hose | 2 | 29872 | 419 | 0.826 | 36164.6 |
1462 | 2023-10-19 12:41:58 | hose | 2 | 29872 | 419 | 0.846 | 35309.7 |
1461 | 2023-10-16 20:38:32 | hose | 1 | 13983 | 30 | 0.266 | 52567.7 |
1460 | 2023-10-13 04:22:00 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1459 | 2023-10-07 21:12:53 | hose | 1 | 13983 | 30 | 0.233 | 60012.9 |
1458 | 2023-10-04 06:03:31 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1457 | 2023-10-02 19:13:04 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1456 | 2023-09-23 14:34:09 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1455 | 2023-09-22 03:28:56 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1454 | 2023-09-12 07:27:01 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1453 | 2023-09-04 10:29:44 | hose | 1 | 13983 | 30 | 0.203 | 68881.8 |
1452 | 2023-08-22 09:30:09 | hose | 2 | 29872 | 419 | 0.906 | 32971.3 |
1451 | 2023-08-15 21:50:28 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1450 | 2023-07-19 07:35:25 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1449 | 2023-06-27 20:38:11 | hose | 1 | 13983 | 30 | 0.233 | 60012.9 |
1448 | 2023-04-21 02:40:39 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1447 | 2023-03-21 20:09:13 | hose | 1 | 13983 | 30 | 0.233 | 60012.9 |
1446 | 2023-02-14 01:07:55 | hose | 1 | 13983 | 30 | 0.203 | 68881.8 |
1445 | 2022-12-11 21:57:49 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1444 | 2022-12-10 08:13:46 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1443 | 2022-11-11 02:43:34 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1442 | 2022-11-09 06:02:22 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1441 | 2022-09-19 06:42:49 | hose | 1 | 13983 | 30 | 0.203 | 68881.8 |
1440 | 2022-09-01 01:25:04 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1439 | 2022-08-27 02:21:31 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1438 | 2022-08-23 04:34:34 | hose | 1 | 13983 | 30 | 0.236 | 59250.0 |
1437 | 2022-08-15 23:09:18 | hose | 1 | 13983 | 30 | 0.203 | 68881.8 |
1436 | 2022-08-14 22:09:32 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1435 | 2022-08-14 13:47:47 | hose | 1 | 13983 | 30 | 0.233 | 60012.9 |
1434 | 2022-07-30 09:04:51 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1433 | 2022-07-28 20:48:55 | hose | 1 | 13983 | 30 | 0.233 | 60012.9 |
1432 | 2022-07-10 09:17:02 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1431 | 2022-06-25 05:48:14 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1430 | 2022-05-14 08:28:12 | hose | 1 | 13983 | 30 | 0.203 | 68881.8 |
1429 | 2022-05-10 22:37:33 | hose | 1 | 13983 | 30 | 0.313 | 44674.1 |
1428 | 2022-04-11 16:27:40 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1427 | 2022-04-08 01:27:52 | hose | 1 | 13983 | 30 | 0.283 | 49409.9 |
1426 | 2022-03-29 11:47:06 | hose | 1 | 13983 | 30 | 0.356 | 39278.1 |
1425 | 2022-03-19 23:44:19 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1424 | 2022-03-19 04:51:11 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1423 | 2022-03-18 06:29:22 | hose | 1 | 13983 | 30 | 0.216 | 64736.1 |
1422 | 2022-03-17 12:09:49 | hose | 1 | 13983 | 30 | 0.296 | 47239.9 |
1421 | 2022-03-16 23:20:44 | hose | 1 | 13983 | 30 | 0.263 | 53167.3 |
1420 | 2022-03-16 04:30:38 | hose | 1 | 13983 | 30 | 0.313 | 44674.1 |
1419 | 2022-03-15 07:24:47 | hose | 1 | 13983 | 30 | 0.483 | 28950.3 |
1418 | 2022-03-14 16:54:48 | hose | 1 | 13983 | 30 | 0.283 | 49409.9 |
1417 | 2022-03-13 11:42:33 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1416 | 2022-03-12 15:16:43 | hose | 1 | 13983 | 30 | 0.263 | 53167.3 |
1415 | 2022-03-11 18:00:11 | hose | 1 | 13983 | 30 | 0.236 | 59250.0 |
1414 | 2022-03-11 10:02:23 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1413 | 2022-03-10 23:08:14 | hose | 1 | 13983 | 30 | 0.250 | 55932.0 |
1412 | 2022-03-10 07:36:13 | hose | 1 | 13983 | 30 | 0.220 | 63559.1 |
1411 | 2022-03-09 15:27:53 | hose | 1 | 13983 | 30 | 0.326 | 42892.6 |
1410 | 2022-03-08 23:40:40 | hose | 1 | 13983 | 30 | 0.300 | 46610.0 |
1409 | 2022-03-08 10:09:51 | hose | 1 | 13983 | 30 | 0.283 | 49409.9 |
1408 | 2022-03-07 18:37:30 | hose | 1 | 13983 | 30 | 0.236 | 59250.0 |