History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"avant"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
783 | 2024-04-19 15:10:35 | avant | 1 | 28756 | 5 | 1.406 | 20452.3 |
782 | 2024-04-13 04:45:51 | avant | 2 | 53800 | 65 | 3.656 | 14715.5 |
781 | 2024-04-13 04:45:45 | avant | 2 | 53800 | 65 | 1.800 | 29888.9 |
780 | 2024-04-13 04:45:41 | avant | 1 | 28756 | 5 | 0.703 | 40904.7 |
779 | 2024-04-13 04:45:15 | avant | 3 | 83667 | 969 | 3.856 | 21697.9 |
778 | 2024-04-11 12:06:40 | avant | 3 | 83667 | 969 | 4.250 | 19686.4 |
777 | 2024-04-04 16:04:50 | avant | 3 | 83667 | 969 | 9.796 | 8540.9 |
776 | 2024-04-03 07:56:20 | avant | 2 | 53800 | 65 | 3.826 | 14061.7 |
775 | 2024-04-03 07:56:18 | avant | 3 | 83667 | 969 | 4.873 | 17169.5 |
774 | 2024-04-03 07:27:11 | avant | 1 | 28756 | 5 | 0.483 | 59536.2 |
773 | 2024-03-31 15:07:01 | avant | 1 | 28756 | 5 | 0.546 | 52666.7 |
772 | 2024-03-29 09:20:03 | avant | 1 | 28756 | 5 | 0.533 | 53951.2 |
771 | 2024-03-17 03:33:42 | avant | 1 | 28756 | 5 | 0.436 | 65954.1 |
770 | 2024-03-04 16:15:43 | avant | 2 | 53800 | 65 | 5.686 | 9461.8 |
769 | 2024-03-04 16:14:33 | avant | 3 | 83667 | 969 | 4.923 | 16995.1 |
768 | 2024-03-04 12:25:47 | avant | 2 | 53800 | 65 | 1.796 | 29955.5 |
767 | 2024-03-04 12:25:46 | avant | 1 | 28756 | 5 | 1.046 | 27491.4 |
766 | 2024-03-04 12:25:17 | avant | 3 | 83667 | 969 | 4.033 | 20745.6 |
765 | 2024-03-04 03:09:13 | avant | 3 | 83667 | 969 | 3.843 | 21771.3 |
764 | 2024-03-04 03:09:15 | avant | 2 | 53800 | 65 | 1.610 | 33416.1 |
763 | 2024-03-04 03:09:09 | avant | 1 | 28756 | 5 | 0.873 | 32939.3 |
762 | 2024-03-01 12:31:02 | avant | 1 | 28756 | 5 | 0.436 | 65954.1 |
761 | 2024-02-28 02:30:00 | avant | 1 | 28756 | 5 | 0.576 | 49923.6 |
760 | 2024-02-19 07:10:55 | avant | 2 | 53800 | 65 | 1.860 | 28924.7 |
759 | 2024-02-03 02:18:35 | avant | 1 | 28756 | 5 | 0.470 | 61183.0 |
758 | 2024-01-29 02:27:37 | avant | 1 | 28756 | 5 | 0.530 | 54256.6 |
757 | 2024-01-29 00:33:00 | avant | 1 | 28756 | 5 | 0.516 | 55728.7 |
756 | 2024-01-20 15:36:24 | avant | 1 | 28756 | 5 | 0.516 | 55728.7 |
755 | 2024-01-14 17:31:08 | avant | 2 | 53800 | 65 | 1.576 | 34137.1 |
754 | 2024-01-09 17:09:49 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
753 | 2024-01-06 12:03:58 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
752 | 2023-12-18 23:46:26 | avant | 2 | 53800 | 65 | 1.656 | 32487.9 |
751 | 2023-12-18 23:46:23 | avant | 3 | 83667 | 969 | 4.360 | 19189.7 |
750 | 2023-12-12 01:37:33 | avant | 3 | 83667 | 969 | 3.326 | 25155.4 |
749 | 2023-11-19 18:06:23 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
748 | 2023-11-17 21:25:48 | avant | 1 | 28756 | 5 | 0.516 | 55728.7 |
747 | 2023-11-17 03:12:17 | avant | 2 | 53800 | 65 | 1.453 | 37026.8 |
746 | 2023-11-11 22:12:39 | avant | 1 | 28756 | 5 | 0.440 | 65354.5 |
745 | 2023-11-03 11:22:41 | avant | 1 | 28756 | 5 | 0.543 | 52957.6 |
744 | 2023-10-29 22:36:32 | avant | 1 | 28756 | 5 | 0.486 | 59168.7 |
743 | 2023-10-21 09:46:16 | avant | 1 | 28756 | 5 | 1.123 | 25606.4 |
742 | 2023-10-17 17:09:45 | avant | 1 | 28756 | 5 | 0.486 | 59168.7 |
741 | 2023-10-13 14:30:28 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
740 | 2023-10-09 15:05:12 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
739 | 2023-10-05 16:24:28 | avant | 1 | 28756 | 5 | 0.500 | 57512.0 |
738 | 2023-10-05 16:09:51 | avant | 3 | 83667 | 969 | 5.263 | 15897.2 |
737 | 2023-09-30 21:55:15 | avant | 3 | 83667 | 969 | 6.640 | 12600.5 |
736 | 2023-09-26 22:09:12 | avant | 3 | 83667 | 969 | 4.250 | 19686.4 |
735 | 2023-09-26 07:34:18 | avant | 1 | 28756 | 5 | 0.500 | 57512.0 |
734 | 2023-09-14 09:28:19 | avant | 1 | 28756 | 5 | 0.516 | 55728.7 |
733 | 2023-09-10 19:14:01 | avant | 3 | 83667 | 969 | 4.140 | 20209.4 |
732 | 2023-08-24 09:43:11 | avant | 1 | 28756 | 5 | 0.533 | 53951.2 |
731 | 2023-08-17 22:02:28 | avant | 2 | 53800 | 65 | 1.530 | 35163.4 |
730 | 2023-07-16 19:59:23 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
729 | 2023-07-03 15:03:57 | avant | 1 | 28756 | 5 | 0.500 | 57512.0 |
728 | 2023-06-02 18:27:41 | avant | 3 | 83667 | 969 | 3.296 | 25384.4 |
727 | 2023-05-24 07:02:57 | avant | 1 | 28756 | 5 | 0.436 | 65954.1 |
726 | 2023-04-28 03:12:59 | avant | 2 | 53800 | 65 | 1.393 | 38621.7 |
725 | 2023-03-26 21:47:54 | avant | 1 | 28756 | 5 | 0.483 | 59536.2 |
724 | 2023-03-23 16:06:29 | avant | 1 | 28756 | 5 | 0.436 | 65954.1 |
723 | 2023-03-21 12:26:28 | avant | 1 | 28756 | 5 | 0.440 | 65354.5 |
722 | 2023-03-10 12:48:53 | avant | 3 | 83667 | 969 | 3.313 | 25254.2 |
721 | 2023-02-04 05:03:17 | avant | 2 | 53800 | 65 | 1.560 | 34487.2 |
720 | 2023-01-08 00:52:02 | avant | 1 | 28756 | 5 | 0.436 | 65954.1 |
719 | 2022-12-15 21:46:23 | avant | 3 | 83667 | 969 | 3.296 | 25384.4 |
718 | 2022-12-12 02:21:40 | avant | 1 | 28756 | 5 | 0.530 | 54256.6 |
717 | 2022-11-15 16:45:55 | avant | 2 | 53800 | 65 | 1.423 | 37807.4 |
716 | 2022-09-29 23:33:53 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
715 | 2022-09-04 07:58:29 | avant | 1 | 28756 | 5 | 0.486 | 59168.7 |
714 | 2022-08-06 13:33:26 | avant | 3 | 83667 | 969 | 3.343 | 25027.5 |
713 | 2022-06-20 05:05:00 | avant | 2 | 53800 | 65 | 1.373 | 39184.3 |
712 | 2022-05-23 03:51:13 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
711 | 2022-05-21 14:53:26 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
710 | 2022-05-19 17:40:09 | avant | 1 | 28756 | 5 | 0.466 | 61708.2 |
709 | 2022-05-13 17:14:38 | avant | 1 | 28756 | 5 | 0.703 | 40904.7 |
708 | 2022-03-14 07:42:55 | avant | 3 | 83667 | 969 | 3.343 | 25027.5 |
707 | 2022-02-25 21:19:52 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
706 | 2022-02-15 01:39:42 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
705 | 2022-02-12 22:43:10 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
704 | 2022-02-11 12:41:14 | avant | 1 | 28756 | 5 | 0.500 | 57512.0 |
703 | 2022-01-30 11:41:47 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
702 | 2021-11-27 18:50:37 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
701 | 2021-11-25 15:27:40 | avant | 1 | 28756 | 5 | 0.546 | 52666.7 |
700 | 2021-11-23 18:23:53 | avant | 1 | 28756 | 5 | 0.500 | 57512.0 |
699 | 2021-11-10 12:02:44 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
698 | 2021-11-07 02:21:27 | avant | 1 | 28756 | 5 | 0.563 | 51076.4 |
697 | 2021-10-09 07:05:30 | avant | 1 | 28756 | 5 | 0.440 | 65354.5 |
696 | 2021-10-07 05:47:17 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
695 | 2021-09-02 20:30:47 | avant | 1 | 28756 | 5 | 0.483 | 59536.2 |
694 | 2021-08-16 08:22:46 | avant | 1 | 28756 | 5 | 0.470 | 61183.0 |
693 | 2021-08-04 00:07:17 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
692 | 2021-06-15 00:07:48 | avant | 1 | 28756 | 5 | 0.516 | 55728.7 |
691 | 2021-04-29 15:10:24 | avant | 1 | 28756 | 5 | 0.516 | 55728.7 |
690 | 2021-03-25 09:16:45 | avant | 1 | 28756 | 5 | 0.500 | 57512.0 |
689 | 2021-02-28 00:13:08 | avant | 1 | 28756 | 5 | 0.500 | 57512.0 |
688 | 2021-01-25 04:57:56 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
687 | 2021-01-08 12:09:28 | avant | 1 | 28756 | 5 | 0.516 | 55728.7 |
686 | 2020-10-27 23:59:36 | avant | 1 | 28756 | 5 | 0.453 | 63479.0 |
685 | 2020-10-27 10:51:00 | avant | 1 | 28756 | 5 | 0.550 | 52283.6 |
684 | 2020-10-26 00:27:35 | avant | 2 | 53800 | 65 | 1.390 | 38705.0 |