History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2723 | 2024-04-27 10:27:15 | aid | 2 | 14084 | 525 | 1.016 | 13862.2 |
2722 | 2024-04-27 08:23:46 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2721 | 2024-04-27 08:23:04 | aid | 1 | 5146 | 36 | 0.096 | 53604.2 |
2720 | 2024-04-27 02:43:20 | aid | 2 | 14084 | 525 | 1.330 | 10589.5 |
2719 | 2024-04-26 02:39:30 | aid | 2 | 14084 | 525 | 0.356 | 39561.8 |
2718 | 2024-04-25 22:54:59 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2717 | 2024-04-25 02:42:05 | aid | 2 | 14084 | 525 | 1.470 | 9581.0 |
2716 | 2024-04-21 07:54:22 | aid | 2 | 14084 | 525 | 0.936 | 15047.0 |
2715 | 2024-04-21 01:31:08 | aid | 2 | 14084 | 525 | 0.373 | 37758.7 |
2714 | 2024-04-20 16:11:15 | aid | 2 | 14084 | 525 | 2.030 | 6937.9 |
2713 | 2024-04-20 02:09:28 | aid | 2 | 14084 | 525 | 1.626 | 8661.7 |
2712 | 2024-04-19 16:38:22 | aid | 2 | 14084 | 525 | 0.810 | 17387.7 |
2711 | 2024-04-19 02:07:21 | aid | 2 | 14084 | 525 | 0.500 | 28168.0 |
2710 | 2024-04-18 12:23:15 | aid | 2 | 14084 | 525 | 0.593 | 23750.4 |
2709 | 2024-04-18 02:08:17 | aid | 2 | 14084 | 525 | 1.440 | 9780.6 |
2708 | 2024-04-18 00:30:28 | aid | 2 | 14084 | 525 | 0.826 | 17050.8 |
2707 | 2024-04-17 03:37:45 | aid | 2 | 14084 | 525 | 0.423 | 33295.5 |
2706 | 2024-04-16 03:31:47 | aid | 2 | 14084 | 525 | 1.126 | 12508.0 |
2705 | 2024-04-15 12:55:20 | aid | 1 | 5146 | 36 | 0.110 | 46781.8 |
2704 | 2024-04-14 02:29:25 | aid | 2 | 14084 | 525 | 0.596 | 23630.9 |
2703 | 2024-04-13 15:05:47 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2702 | 2024-04-13 14:31:52 | aid | 2 | 14084 | 525 | 0.826 | 17050.8 |
2701 | 2024-04-13 05:04:33 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2700 | 2024-04-13 05:04:17 | aid | 2 | 14084 | 525 | 0.390 | 36112.8 |
2699 | 2024-04-12 16:47:27 | aid | 2 | 14084 | 525 | 2.140 | 6581.3 |
2698 | 2024-04-11 22:38:18 | aid | 2 | 14084 | 525 | 0.420 | 33533.3 |
2697 | 2024-04-10 21:29:16 | aid | 2 | 14084 | 525 | 0.390 | 36112.8 |
2696 | 2024-04-09 20:31:56 | aid | 2 | 14084 | 525 | 0.920 | 15308.7 |
2695 | 2024-04-08 22:54:06 | aid | 2 | 14084 | 525 | 0.403 | 34947.9 |
2694 | 2024-04-08 08:20:10 | aid | 2 | 14084 | 525 | 0.436 | 32302.8 |
2693 | 2024-04-07 13:13:00 | aid | 2 | 14084 | 525 | 0.953 | 14778.6 |
2692 | 2024-04-06 05:48:02 | aid | 2 | 14084 | 525 | 0.903 | 15596.9 |
2691 | 2024-04-05 13:19:26 | aid | 2 | 14084 | 525 | 0.920 | 15308.7 |
2690 | 2024-04-04 20:06:08 | aid | 2 | 14084 | 525 | 1.343 | 10487.0 |
2689 | 2024-04-04 15:22:46 | aid | 2 | 14084 | 525 | 0.500 | 28168.0 |
2688 | 2024-04-03 21:35:35 | aid | 2 | 14084 | 525 | 0.483 | 29159.4 |
2687 | 2024-04-02 17:18:34 | aid | 1 | 5146 | 36 | 0.200 | 25730.0 |
2686 | 2024-03-30 18:30:20 | aid | 1 | 5146 | 36 | 0.203 | 25349.8 |
2685 | 2024-03-26 17:54:11 | aid | 1 | 5146 | 36 | 0.096 | 53604.2 |
2684 | 2024-03-26 01:58:25 | aid | 2 | 14084 | 525 | 0.423 | 33295.5 |
2683 | 2024-03-25 00:46:40 | aid | 2 | 14084 | 525 | 0.406 | 34689.7 |
2682 | 2024-03-23 15:38:04 | aid | 2 | 14084 | 525 | 0.360 | 39122.2 |
2681 | 2024-03-23 01:26:32 | aid | 2 | 14084 | 525 | 0.500 | 28168.0 |
2680 | 2024-03-21 23:02:24 | aid | 2 | 14084 | 525 | 0.826 | 17050.8 |
2679 | 2024-03-21 16:52:43 | aid | 2 | 14084 | 525 | 0.530 | 26573.6 |
2678 | 2024-03-21 10:25:42 | aid | 2 | 14084 | 525 | 0.470 | 29966.0 |
2677 | 2024-03-20 13:01:37 | aid | 2 | 14084 | 525 | 0.360 | 39122.2 |
2676 | 2024-03-19 18:46:05 | aid | 2 | 14084 | 525 | 0.950 | 14825.3 |
2675 | 2024-03-18 23:50:47 | aid | 2 | 14084 | 525 | 1.423 | 9897.4 |
2674 | 2024-03-17 14:38:34 | aid | 2 | 14084 | 525 | 0.343 | 41061.2 |
2673 | 2024-03-13 04:31:26 | aid | 1 | 5146 | 36 | 0.296 | 17385.1 |
2672 | 2024-03-13 04:30:28 | aid | 2 | 14084 | 525 | 0.393 | 35837.2 |
2671 | 2024-03-12 11:47:22 | aid | 2 | 14084 | 525 | 0.470 | 29966.0 |
2670 | 2024-03-02 16:15:13 | aid | 1 | 5146 | 36 | 0.313 | 16440.9 |
2669 | 2024-02-29 18:51:17 | aid | 1 | 5146 | 36 | 0.110 | 46781.8 |
2668 | 2024-02-28 22:23:03 | aid | 1 | 5146 | 36 | 0.110 | 46781.8 |
2667 | 2024-02-25 15:57:59 | aid | 1 | 5146 | 36 | 0.076 | 67710.5 |
2666 | 2024-02-20 20:52:39 | aid | 2 | 14084 | 525 | 0.403 | 34947.9 |
2665 | 2024-02-20 15:04:34 | aid | 2 | 14084 | 525 | 0.420 | 33533.3 |
2664 | 2024-02-19 23:11:24 | aid | 2 | 14084 | 525 | 0.500 | 28168.0 |
2663 | 2024-02-16 01:14:39 | aid | 2 | 14084 | 525 | 0.423 | 33295.5 |
2662 | 2024-02-07 14:16:21 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2661 | 2024-02-05 17:35:34 | aid | 2 | 14084 | 525 | 0.440 | 32009.1 |
2660 | 2024-02-05 04:08:34 | aid | 2 | 14084 | 525 | 0.893 | 15771.6 |
2659 | 2024-02-04 18:47:38 | aid | 2 | 14084 | 525 | 0.483 | 29159.4 |
2658 | 2024-01-24 17:38:04 | aid | 1 | 5146 | 36 | 0.096 | 53604.2 |
2657 | 2024-01-24 04:44:34 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2656 | 2024-01-10 21:19:51 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2655 | 2024-01-06 03:40:35 | aid | 2 | 14084 | 525 | 0.343 | 41061.2 |
2654 | 2024-01-05 13:40:56 | aid | 2 | 14084 | 525 | 0.436 | 32302.8 |
2653 | 2024-01-04 21:52:58 | aid | 2 | 14084 | 525 | 0.373 | 37758.7 |
2652 | 2024-01-03 14:35:43 | aid | 2 | 14084 | 525 | 0.470 | 29966.0 |
2651 | 2024-01-02 19:23:12 | aid | 2 | 14084 | 525 | 0.356 | 39561.8 |
2650 | 2023-12-30 04:10:22 | aid | 2 | 14084 | 525 | 0.390 | 36112.8 |
2649 | 2023-12-29 02:12:26 | aid | 2 | 14084 | 525 | 0.393 | 35837.2 |
2648 | 2023-12-28 15:45:11 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2647 | 2023-12-26 08:28:54 | aid | 1 | 5146 | 36 | 0.096 | 53604.2 |
2646 | 2023-12-20 06:12:07 | aid | 1 | 5146 | 36 | 0.076 | 67710.5 |
2645 | 2023-12-18 13:30:55 | aid | 1 | 5146 | 36 | 0.080 | 64325.0 |
2644 | 2023-12-17 01:35:58 | aid | 2 | 14084 | 525 | 0.906 | 15545.3 |
2643 | 2023-12-16 00:03:00 | aid | 2 | 14084 | 525 | 0.360 | 39122.2 |
2642 | 2023-12-14 10:41:29 | aid | 1 | 5146 | 36 | 0.076 | 67710.5 |
2641 | 2023-12-12 21:06:31 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2640 | 2023-12-12 04:56:00 | aid | 2 | 14084 | 525 | 0.360 | 39122.2 |
2639 | 2023-12-11 04:04:23 | aid | 2 | 14084 | 525 | 0.390 | 36112.8 |
2638 | 2023-12-10 03:57:31 | aid | 2 | 14084 | 525 | 0.486 | 28979.4 |
2637 | 2023-12-08 23:17:50 | aid | 2 | 14084 | 525 | 0.360 | 39122.2 |
2636 | 2023-12-08 00:48:50 | aid | 2 | 14084 | 525 | 0.390 | 36112.8 |
2635 | 2023-12-07 23:26:13 | aid | 2 | 14084 | 525 | 0.813 | 17323.5 |
2634 | 2023-12-07 00:54:44 | aid | 2 | 14084 | 525 | 0.436 | 32302.8 |
2633 | 2023-12-06 00:42:23 | aid | 2 | 14084 | 525 | 0.406 | 34689.7 |
2632 | 2023-12-03 04:50:49 | aid | 2 | 14084 | 525 | 0.360 | 39122.2 |
2631 | 2023-12-02 01:46:05 | aid | 2 | 14084 | 525 | 0.343 | 41061.2 |
2630 | 2023-12-01 06:09:35 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2629 | 2023-12-01 05:42:15 | aid | 2 | 14084 | 525 | 0.450 | 31297.8 |
2628 | 2023-11-29 22:29:56 | aid | 2 | 14084 | 525 | 0.906 | 15545.3 |
2627 | 2023-11-29 00:32:22 | aid | 2 | 14084 | 525 | 0.403 | 34947.9 |
2626 | 2023-11-27 10:42:43 | aid | 1 | 5146 | 36 | 0.096 | 53604.2 |
2625 | 2023-11-27 02:11:40 | aid | 1 | 5146 | 36 | 0.093 | 55333.3 |
2624 | 2023-11-27 00:45:15 | aid | 2 | 14084 | 525 | 0.360 | 39122.2 |