History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mall"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1495 | 2024-04-27 04:22:34 | mall | 2 | 29872 | 312 | 2.470 | 12093.9 |
1494 | 2024-04-27 02:31:26 | mall | 1 | 13983 | 25 | 0.856 | 16335.3 |
1493 | 2024-04-27 00:04:15 | mall | 1 | 13983 | 25 | 0.236 | 59250.0 |
1492 | 2024-04-21 07:26:32 | mall | 1 | 13983 | 25 | 0.500 | 27966.0 |
1491 | 2024-04-21 07:26:17 | mall | 2 | 29872 | 312 | 2.046 | 14600.2 |
1490 | 2024-04-21 07:25:53 | mall | 1 | 13983 | 25 | 0.970 | 14415.5 |
1489 | 2024-04-19 02:52:32 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1488 | 2024-04-14 23:48:48 | mall | 1 | 13983 | 25 | 0.860 | 16259.3 |
1487 | 2024-04-14 23:47:14 | mall | 1 | 13983 | 25 | 1.860 | 7517.7 |
1486 | 2024-04-02 18:27:39 | mall | 1 | 13983 | 25 | 0.843 | 16587.2 |
1485 | 2024-04-01 15:45:56 | mall | 1 | 13983 | 25 | 0.843 | 16587.2 |
1484 | 2024-03-28 17:54:34 | mall | 1 | 13983 | 25 | 0.283 | 49409.9 |
1483 | 2024-03-27 22:14:17 | mall | 2 | 29872 | 312 | 0.796 | 37527.6 |
1482 | 2024-03-27 22:14:15 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1481 | 2024-03-21 22:55:31 | mall | 2 | 29872 | 312 | 1.000 | 29872.0 |
1480 | 2024-03-21 22:55:02 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1479 | 2024-03-02 17:43:54 | mall | 1 | 13983 | 25 | 0.280 | 49939.3 |
1478 | 2024-03-02 15:00:32 | mall | 2 | 29872 | 312 | 2.080 | 14361.5 |
1477 | 2024-03-02 13:25:33 | mall | 1 | 13983 | 25 | 0.546 | 25609.9 |
1476 | 2024-02-26 19:13:09 | mall | 2 | 29872 | 312 | 1.186 | 25187.2 |
1475 | 2024-02-26 19:10:34 | mall | 1 | 13983 | 25 | 0.813 | 17199.3 |
1474 | 2024-02-20 03:12:20 | mall | 1 | 13983 | 25 | 0.296 | 47239.9 |
1473 | 2024-02-08 13:04:45 | mall | 1 | 13983 | 25 | 0.420 | 33292.9 |
1472 | 2024-01-27 18:46:17 | mall | 1 | 13983 | 25 | 0.236 | 59250.0 |
1471 | 2024-01-27 02:20:17 | mall | 1 | 13983 | 25 | 0.500 | 27966.0 |
1470 | 2024-01-26 23:33:31 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1469 | 2024-01-20 22:58:29 | mall | 1 | 13983 | 25 | 0.263 | 53167.3 |
1468 | 2024-01-14 07:33:07 | mall | 1 | 13983 | 25 | 0.263 | 53167.3 |
1467 | 2024-01-04 07:24:20 | mall | 2 | 29872 | 312 | 0.860 | 34734.9 |
1466 | 2023-12-27 15:55:57 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1465 | 2023-12-18 03:37:23 | mall | 2 | 29872 | 312 | 0.936 | 31914.5 |
1464 | 2023-12-14 05:24:14 | mall | 2 | 29872 | 312 | 1.920 | 15558.3 |
1463 | 2023-11-15 04:34:25 | mall | 2 | 29872 | 312 | 0.766 | 38997.4 |
1462 | 2023-11-11 20:55:50 | mall | 1 | 13983 | 25 | 0.203 | 68881.8 |
1461 | 2023-11-11 14:20:04 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1460 | 2023-11-10 22:01:19 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1459 | 2023-10-31 08:27:52 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1458 | 2023-10-26 04:36:36 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1457 | 2023-10-23 01:25:34 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1456 | 2023-10-21 10:17:20 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1455 | 2023-10-18 11:19:47 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1454 | 2023-10-12 11:13:01 | mall | 1 | 13983 | 25 | 0.236 | 59250.0 |
1453 | 2023-10-03 17:05:54 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1452 | 2023-09-26 05:57:09 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1451 | 2023-09-23 11:07:35 | mall | 1 | 13983 | 25 | 0.216 | 64736.1 |
1450 | 2023-08-29 20:03:05 | mall | 1 | 13983 | 25 | 0.266 | 52567.7 |
1449 | 2023-08-22 21:08:14 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1448 | 2023-07-17 14:20:47 | mall | 1 | 13983 | 25 | 0.203 | 68881.8 |
1447 | 2023-06-29 20:18:38 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1446 | 2023-06-03 23:45:12 | mall | 1 | 13983 | 25 | 0.203 | 68881.8 |
1445 | 2023-04-06 03:48:34 | mall | 1 | 13983 | 25 | 0.263 | 53167.3 |
1444 | 2023-03-31 13:20:51 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1443 | 2023-03-26 01:53:20 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1442 | 2023-01-08 07:36:39 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1441 | 2022-12-31 22:05:01 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1440 | 2022-12-14 08:40:42 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1439 | 2022-11-25 21:05:59 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1438 | 2022-11-08 03:03:21 | mall | 1 | 13983 | 25 | 0.216 | 64736.1 |
1437 | 2022-10-12 12:02:16 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1436 | 2022-09-19 22:16:09 | mall | 1 | 13983 | 25 | 0.216 | 64736.1 |
1435 | 2022-09-18 16:26:49 | mall | 1 | 13983 | 25 | 0.263 | 53167.3 |
1434 | 2022-09-17 19:09:10 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1433 | 2022-09-17 10:15:53 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1432 | 2022-09-03 20:01:37 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1431 | 2022-08-14 04:38:51 | mall | 1 | 13983 | 25 | 0.236 | 59250.0 |
1430 | 2022-08-07 03:47:57 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1429 | 2022-07-30 04:28:21 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1428 | 2022-07-28 18:57:22 | mall | 1 | 13983 | 25 | 0.203 | 68881.8 |
1427 | 2022-07-17 22:24:57 | mall | 1 | 13983 | 25 | 0.216 | 64736.1 |
1426 | 2022-07-02 23:03:23 | mall | 1 | 13983 | 25 | 0.216 | 64736.1 |
1425 | 2022-06-04 01:12:00 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1424 | 2022-05-31 01:23:30 | mall | 1 | 13983 | 25 | 0.216 | 64736.1 |
1423 | 2022-04-27 10:24:23 | mall | 1 | 13983 | 25 | 0.313 | 44674.1 |
1422 | 2022-04-26 14:36:53 | mall | 1 | 13983 | 25 | 0.216 | 64736.1 |
1421 | 2022-04-26 02:19:23 | mall | 1 | 13983 | 25 | 0.236 | 59250.0 |
1420 | 2022-04-25 11:50:00 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1419 | 2022-04-24 19:12:17 | mall | 1 | 13983 | 25 | 0.220 | 63559.1 |
1418 | 2022-04-23 09:22:49 | mall | 1 | 13983 | 25 | 0.216 | 64736.1 |
1417 | 2022-04-22 12:23:08 | mall | 1 | 13983 | 25 | 0.296 | 47239.9 |
1416 | 2022-04-21 19:56:34 | mall | 1 | 13983 | 25 | 0.343 | 40766.8 |
1415 | 2022-04-21 03:43:50 | mall | 1 | 13983 | 25 | 0.216 | 64736.1 |
1414 | 2022-04-20 10:34:13 | mall | 1 | 13983 | 25 | 0.280 | 49939.3 |
1413 | 2022-04-19 16:01:00 | mall | 1 | 13983 | 25 | 0.343 | 40766.8 |
1412 | 2022-04-18 21:15:11 | mall | 1 | 13983 | 25 | 0.453 | 30867.5 |
1411 | 2022-04-17 20:38:02 | mall | 1 | 13983 | 25 | 0.236 | 59250.0 |
1410 | 2022-04-17 07:25:25 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1409 | 2022-04-16 11:51:40 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1408 | 2022-04-15 14:05:46 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1407 | 2022-04-14 20:04:24 | mall | 1 | 13983 | 25 | 0.330 | 42372.7 |
1406 | 2022-04-14 00:39:51 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1405 | 2022-04-11 22:57:03 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1404 | 2022-04-10 23:07:00 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1403 | 2022-04-08 06:05:06 | mall | 1 | 13983 | 25 | 0.203 | 68881.8 |
1402 | 2022-04-07 17:49:00 | mall | 1 | 13983 | 25 | 0.283 | 49409.9 |
1401 | 2022-04-07 05:29:47 | mall | 1 | 13983 | 25 | 0.236 | 59250.0 |
1400 | 2022-04-07 00:52:42 | mall | 1 | 13983 | 25 | 0.360 | 38841.7 |
1399 | 2022-04-06 06:05:37 | mall | 1 | 13983 | 25 | 0.250 | 55932.0 |
1398 | 2022-04-05 20:25:49 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |
1397 | 2022-04-04 20:41:39 | mall | 1 | 13983 | 25 | 0.313 | 44674.1 |
1396 | 2022-04-04 05:11:38 | mall | 1 | 13983 | 25 | 0.233 | 60012.9 |