History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lac"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2605 | 2024-04-25 07:43:26 | lac | 2 | 14084 | 473 | 1.313 | 10726.6 |
2604 | 2024-04-25 00:52:58 | lac | 2 | 14084 | 473 | 1.170 | 12037.6 |
2603 | 2024-04-24 23:31:01 | lac | 2 | 14084 | 473 | 0.500 | 28168.0 |
2602 | 2024-04-24 16:35:02 | lac | 1 | 5146 | 23 | 0.186 | 27666.7 |
2601 | 2024-04-21 09:54:23 | lac | 2 | 14084 | 473 | 0.780 | 18056.4 |
2600 | 2024-04-21 06:58:15 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2599 | 2024-04-19 05:28:11 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2598 | 2024-04-18 12:41:20 | lac | 1 | 5146 | 23 | 0.313 | 16440.9 |
2597 | 2024-04-17 18:32:08 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2596 | 2024-04-17 11:08:39 | lac | 1 | 5146 | 23 | 0.110 | 46781.8 |
2595 | 2024-04-17 11:03:56 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2594 | 2024-04-17 10:52:12 | lac | 1 | 5146 | 23 | 0.106 | 48547.2 |
2593 | 2024-04-17 10:51:39 | lac | 1 | 5146 | 23 | 0.096 | 53604.2 |
2592 | 2024-04-17 08:56:23 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2591 | 2024-04-13 14:19:49 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2590 | 2024-04-12 18:59:13 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2589 | 2024-04-11 05:58:53 | lac | 1 | 5146 | 23 | 0.096 | 53604.2 |
2588 | 2024-04-02 17:41:40 | lac | 1 | 5146 | 23 | 0.313 | 16440.9 |
2587 | 2024-03-30 20:25:00 | lac | 2 | 14084 | 473 | 0.406 | 34689.7 |
2586 | 2024-03-30 12:14:27 | lac | 2 | 14084 | 473 | 0.453 | 31090.5 |
2585 | 2024-03-30 11:49:30 | lac | 2 | 14084 | 473 | 0.440 | 32009.1 |
2584 | 2024-03-30 09:53:01 | lac | 1 | 5146 | 23 | 0.203 | 25349.8 |
2583 | 2024-03-29 13:15:25 | lac | 2 | 14084 | 473 | 0.470 | 29966.0 |
2582 | 2024-03-26 18:28:39 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2581 | 2024-03-12 19:26:19 | lac | 1 | 5146 | 23 | 0.096 | 53604.2 |
2580 | 2024-03-10 20:06:14 | lac | 2 | 14084 | 473 | 1.093 | 12885.6 |
2579 | 2024-03-08 11:56:24 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2578 | 2024-03-05 09:13:35 | lac | 1 | 5146 | 23 | 0.096 | 53604.2 |
2577 | 2024-03-02 16:12:45 | lac | 1 | 5146 | 23 | 0.110 | 46781.8 |
2576 | 2024-02-28 16:01:22 | lac | 1 | 5146 | 23 | 0.296 | 17385.1 |
2575 | 2024-02-25 15:52:03 | lac | 1 | 5146 | 23 | 0.096 | 53604.2 |
2574 | 2024-02-25 15:34:53 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2573 | 2024-02-21 07:23:01 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2572 | 2024-02-21 06:48:33 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2571 | 2024-02-11 18:12:20 | lac | 1 | 5146 | 23 | 0.110 | 46781.8 |
2570 | 2024-02-08 01:46:21 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2569 | 2024-02-07 21:45:57 | lac | 2 | 14084 | 473 | 0.390 | 36112.8 |
2568 | 2024-02-07 18:43:18 | lac | 2 | 14084 | 473 | 1.313 | 10726.6 |
2567 | 2024-01-26 13:29:05 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2566 | 2024-01-26 09:15:22 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2565 | 2024-01-25 17:39:25 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2564 | 2024-01-24 00:24:24 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2563 | 2024-01-19 09:09:04 | lac | 2 | 14084 | 473 | 0.406 | 34689.7 |
2562 | 2024-01-10 09:11:40 | lac | 1 | 5146 | 23 | 0.110 | 46781.8 |
2561 | 2024-01-07 17:32:14 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2560 | 2024-01-05 01:18:46 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2559 | 2023-12-30 08:44:13 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2558 | 2023-12-30 06:09:48 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2557 | 2023-12-29 04:38:38 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2556 | 2023-12-26 17:23:28 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2555 | 2023-12-21 21:39:23 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2554 | 2023-12-21 21:15:34 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2553 | 2023-12-15 10:03:24 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2552 | 2023-12-02 16:38:10 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2551 | 2023-11-09 17:32:44 | lac | 2 | 14084 | 473 | 0.376 | 37457.4 |
2550 | 2023-11-08 11:27:56 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2549 | 2023-11-08 02:16:24 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2548 | 2023-11-07 23:45:54 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2547 | 2023-11-07 13:16:58 | lac | 2 | 14084 | 473 | 0.343 | 41061.2 |
2546 | 2023-11-07 10:09:39 | lac | 1 | 5146 | 23 | 0.110 | 46781.8 |
2545 | 2023-11-07 07:25:00 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2544 | 2023-11-06 15:02:38 | lac | 1 | 5146 | 23 | 0.156 | 32987.2 |
2543 | 2023-11-05 17:38:37 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2542 | 2023-11-02 00:14:45 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2541 | 2023-11-01 00:50:05 | lac | 2 | 14084 | 473 | 0.343 | 41061.2 |
2540 | 2023-10-31 07:31:05 | lac | 2 | 14084 | 473 | 0.406 | 34689.7 |
2539 | 2023-10-26 03:32:52 | lac | 2 | 14084 | 473 | 0.390 | 36112.8 |
2538 | 2023-10-25 19:31:29 | lac | 1 | 5146 | 23 | 0.170 | 30270.6 |
2537 | 2023-10-24 22:37:12 | lac | 2 | 14084 | 473 | 0.326 | 43202.5 |
2536 | 2023-10-23 11:59:41 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2535 | 2023-10-20 02:27:35 | lac | 2 | 14084 | 473 | 0.406 | 34689.7 |
2534 | 2023-10-19 14:26:48 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2533 | 2023-10-17 23:50:27 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2532 | 2023-10-16 22:28:02 | lac | 2 | 14084 | 473 | 0.453 | 31090.5 |
2531 | 2023-10-16 18:15:41 | lac | 1 | 5146 | 23 | 0.173 | 29745.7 |
2530 | 2023-10-11 21:19:42 | lac | 2 | 14084 | 473 | 0.423 | 33295.5 |
2529 | 2023-10-11 14:05:06 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2528 | 2023-10-10 00:52:32 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2527 | 2023-10-03 11:56:06 | lac | 2 | 14084 | 473 | 0.376 | 37457.4 |
2526 | 2023-10-03 08:13:23 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2525 | 2023-09-25 10:39:08 | lac | 1 | 5146 | 23 | 0.186 | 27666.7 |
2524 | 2023-09-23 00:25:36 | lac | 2 | 14084 | 473 | 0.346 | 40705.2 |
2523 | 2023-09-18 21:58:54 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2522 | 2023-09-15 18:47:34 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2521 | 2023-09-10 15:30:24 | lac | 2 | 14084 | 473 | 0.406 | 34689.7 |
2520 | 2023-09-10 11:13:43 | lac | 1 | 5146 | 23 | 0.096 | 53604.2 |
2519 | 2023-09-09 07:52:30 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2518 | 2023-08-14 02:26:23 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2517 | 2023-08-11 21:53:23 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2516 | 2023-08-07 16:57:18 | lac | 2 | 14084 | 473 | 0.326 | 43202.5 |
2515 | 2023-07-26 10:37:24 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2514 | 2023-07-23 16:06:01 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2513 | 2023-07-23 13:49:41 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2512 | 2023-07-23 09:36:07 | lac | 1 | 5146 | 23 | 0.080 | 64325.0 |
2511 | 2023-07-17 02:21:10 | lac | 2 | 14084 | 473 | 0.390 | 36112.8 |
2510 | 2023-07-16 19:13:59 | lac | 1 | 5146 | 23 | 0.096 | 53604.2 |
2509 | 2023-07-16 18:18:52 | lac | 1 | 5146 | 23 | 0.093 | 55333.3 |
2508 | 2023-07-08 11:00:58 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2507 | 2023-07-05 13:49:26 | lac | 1 | 5146 | 23 | 0.076 | 67710.5 |
2506 | 2023-07-01 13:52:43 | lac | 2 | 14084 | 473 | 0.360 | 39122.2 |