History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"viola"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
746 | 2024-04-02 22:43:11 | viola | 3 | 83667 | 790 | 10.656 | 7851.6 |
745 | 2024-04-02 22:43:11 | viola | 2 | 53800 | 63 | 3.750 | 14346.7 |
744 | 2024-04-02 21:06:32 | viola | 1 | 28756 | 6 | 0.456 | 63061.4 |
743 | 2024-03-31 12:21:33 | viola | 2 | 53800 | 63 | 1.860 | 28924.7 |
742 | 2024-03-31 12:21:03 | viola | 3 | 83667 | 790 | 5.126 | 16322.1 |
741 | 2024-03-30 22:36:14 | viola | 2 | 53800 | 63 | 2.906 | 18513.4 |
740 | 2024-03-30 22:34:57 | viola | 3 | 83667 | 790 | 4.360 | 19189.7 |
739 | 2024-03-30 22:34:48 | viola | 1 | 28756 | 6 | 0.513 | 56054.6 |
738 | 2024-03-30 22:34:39 | viola | 3 | 83667 | 790 | 4.203 | 19906.5 |
737 | 2024-03-30 22:34:39 | viola | 2 | 53800 | 63 | 1.690 | 31834.3 |
736 | 2024-03-30 21:46:41 | viola | 1 | 28756 | 6 | 1.000 | 28756.0 |
735 | 2024-03-29 09:24:46 | viola | 1 | 28756 | 6 | 1.030 | 27918.4 |
734 | 2024-03-04 09:47:05 | viola | 1 | 28756 | 6 | 1.126 | 25538.2 |
733 | 2024-02-28 07:26:15 | viola | 1 | 28756 | 6 | 0.483 | 59536.2 |
732 | 2024-01-31 01:59:11 | viola | 2 | 53800 | 63 | 1.533 | 35094.6 |
731 | 2024-01-31 01:57:12 | viola | 3 | 83667 | 790 | 3.860 | 21675.4 |
730 | 2024-01-29 06:00:21 | viola | 1 | 28756 | 6 | 0.470 | 61183.0 |
729 | 2024-01-23 04:57:17 | viola | 3 | 83667 | 790 | 5.690 | 14704.2 |
728 | 2024-01-22 12:09:59 | viola | 3 | 83667 | 790 | 4.610 | 18149.0 |
727 | 2024-01-20 17:33:22 | viola | 2 | 53800 | 63 | 1.560 | 34487.2 |
726 | 2024-01-20 12:04:32 | viola | 3 | 83667 | 790 | 3.733 | 22412.8 |
725 | 2024-01-20 04:31:34 | viola | 1 | 28756 | 6 | 0.420 | 68466.7 |
724 | 2023-12-11 12:10:55 | viola | 1 | 28756 | 6 | 0.423 | 67981.1 |
723 | 2023-12-05 09:34:45 | viola | 1 | 28756 | 6 | 1.623 | 17717.8 |
722 | 2023-11-26 09:20:00 | viola | 3 | 83667 | 790 | 3.610 | 23176.5 |
721 | 2023-11-26 09:19:58 | viola | 2 | 53800 | 63 | 1.423 | 37807.4 |
720 | 2023-11-18 10:00:07 | viola | 1 | 28756 | 6 | 0.483 | 59536.2 |
719 | 2023-11-03 07:13:24 | viola | 1 | 28756 | 6 | 0.423 | 67981.1 |
718 | 2023-10-22 02:46:09 | viola | 1 | 28756 | 6 | 0.436 | 65954.1 |
717 | 2023-10-19 00:27:18 | viola | 1 | 28756 | 6 | 0.500 | 57512.0 |
716 | 2023-10-14 23:10:19 | viola | 1 | 28756 | 6 | 0.470 | 61183.0 |
715 | 2023-10-09 05:15:30 | viola | 1 | 28756 | 6 | 0.466 | 61708.2 |
714 | 2023-09-28 11:22:58 | viola | 1 | 28756 | 6 | 0.470 | 61183.0 |
713 | 2023-09-28 00:51:55 | viola | 1 | 28756 | 6 | 0.420 | 68466.7 |
712 | 2023-09-12 14:33:24 | viola | 1 | 28756 | 6 | 0.516 | 55728.7 |
711 | 2023-08-30 14:58:18 | viola | 1 | 28756 | 6 | 0.436 | 65954.1 |
710 | 2023-07-24 19:23:44 | viola | 1 | 28756 | 6 | 0.436 | 65954.1 |
709 | 2023-04-22 18:25:12 | viola | 1 | 28756 | 6 | 0.423 | 67981.1 |
708 | 2023-04-21 12:58:03 | viola | 1 | 28756 | 6 | 0.500 | 57512.0 |
707 | 2023-02-11 15:33:56 | viola | 1 | 28756 | 6 | 0.453 | 63479.0 |
706 | 2022-12-11 17:15:48 | viola | 1 | 28756 | 6 | 0.423 | 67981.1 |
705 | 2022-12-07 18:33:58 | viola | 1 | 28756 | 6 | 0.466 | 61708.2 |
704 | 2022-09-19 21:56:59 | viola | 1 | 28756 | 6 | 0.453 | 63479.0 |
703 | 2022-09-12 09:19:33 | viola | 1 | 28756 | 6 | 0.420 | 68466.7 |
702 | 2022-08-15 10:16:25 | viola | 1 | 28756 | 6 | 0.453 | 63479.0 |
701 | 2022-08-14 19:57:23 | viola | 1 | 28756 | 6 | 0.423 | 67981.1 |
700 | 2022-08-14 03:06:19 | viola | 1 | 28756 | 6 | 0.423 | 67981.1 |
699 | 2022-08-06 01:50:56 | viola | 1 | 28756 | 6 | 0.440 | 65354.5 |
698 | 2022-07-29 04:10:33 | viola | 1 | 28756 | 6 | 0.470 | 61183.0 |
697 | 2022-07-25 13:42:01 | viola | 1 | 28756 | 6 | 0.436 | 65954.1 |
696 | 2022-03-28 20:33:46 | viola | 1 | 28756 | 6 | 0.516 | 55728.7 |
695 | 2022-03-07 03:35:59 | viola | 1 | 28756 | 6 | 0.903 | 31845.0 |
694 | 2022-03-03 17:15:18 | viola | 1 | 28756 | 6 | 0.470 | 61183.0 |
693 | 2022-01-03 19:03:32 | viola | 1 | 28756 | 6 | 0.500 | 57512.0 |
692 | 2022-01-01 15:07:25 | viola | 1 | 28756 | 6 | 0.513 | 56054.6 |
691 | 2021-10-31 00:09:45 | viola | 1 | 28756 | 6 | 0.436 | 65954.1 |
690 | 2021-10-30 21:52:09 | viola | 1 | 28756 | 6 | 0.466 | 61708.2 |
689 | 2021-09-17 05:36:55 | viola | 1 | 28756 | 6 | 0.500 | 57512.0 |
688 | 2021-09-01 22:47:49 | viola | 1 | 28756 | 6 | 0.470 | 61183.0 |
687 | 2021-07-25 14:50:32 | viola | 1 | 28756 | 6 | 0.453 | 63479.0 |
686 | 2021-07-09 20:46:37 | viola | 1 | 28756 | 6 | 0.483 | 59536.2 |
685 | 2021-05-16 01:25:05 | viola | 3 | 83667 | 790 | 3.640 | 22985.4 |
684 | 2021-05-15 22:54:06 | viola | 1 | 28756 | 6 | 0.470 | 61183.0 |
683 | 2021-05-07 18:55:41 | viola | 1 | 28756 | 6 | 0.466 | 61708.2 |
682 | 2021-04-15 12:25:01 | viola | 1 | 28756 | 6 | 0.576 | 49923.6 |
681 | 2021-04-06 00:37:53 | viola | 1 | 28756 | 6 | 0.466 | 61708.2 |
680 | 2021-04-01 20:19:44 | viola | 1 | 28756 | 6 | 0.513 | 56054.6 |
679 | 2021-02-21 14:35:02 | viola | 1 | 28756 | 6 | 0.436 | 65954.1 |
678 | 2020-12-30 22:55:02 | viola | 1 | 28756 | 6 | 0.423 | 67981.1 |
677 | 2020-12-20 22:05:40 | viola | 1 | 28756 | 6 | 0.470 | 61183.0 |
676 | 2020-11-10 12:19:40 | viola | 1 | 28756 | 6 | 0.436 | 65954.1 |
675 | 2020-11-07 09:21:49 | viola | 1 | 28756 | 6 | 0.453 | 63479.0 |
674 | 2020-10-16 11:39:06 | viola | 1 | 28756 | 6 | 0.500 | 57512.0 |
673 | 2020-09-16 23:18:00 | viola | 1 | 28756 | 6 | 0.953 | 30174.2 |
672 | 2020-07-24 21:17:13 | viola | 1 | 28756 | 6 | 0.516 | 55728.7 |
671 | 2020-05-26 04:08:07 | viola | 1 | 28756 | 6 | 0.436 | 65954.1 |
670 | 2020-04-05 14:49:50 | viola | 1 | 28756 | 6 | 0.500 | 57512.0 |
669 | 2020-03-25 05:59:19 | viola | 1 | 28756 | 6 | 0.486 | 59168.7 |
668 | 2020-03-23 19:23:05 | viola | 1 | 28756 | 6 | 0.420 | 68466.7 |
667 | 2020-03-23 10:35:19 | viola | 1 | 28756 | 6 | 1.080 | 26625.9 |
666 | 2020-03-22 09:36:36 | viola | 1 | 28756 | 6 | 1.140 | 25224.6 |
665 | 2020-03-21 12:06:50 | viola | 1 | 28756 | 6 | 0.440 | 65354.5 |
664 | 2020-03-18 02:27:57 | viola | 1 | 28756 | 6 | 0.470 | 61183.0 |
663 | 2020-02-25 18:56:36 | viola | 1 | 28756 | 6 | 0.436 | 65954.1 |
662 | 2020-02-24 21:53:43 | viola | 1 | 28756 | 6 | 0.533 | 53951.2 |
661 | 2020-02-21 02:37:20 | viola | 1 | 28756 | 6 | 0.500 | 57512.0 |
660 | 2020-02-17 02:00:07 | viola | 1 | 28756 | 6 | 1.156 | 24875.4 |
659 | 2020-02-13 22:52:33 | viola | 1 | 28756 | 6 | 1.173 | 24514.9 |
658 | 2020-02-10 06:42:48 | viola | 1 | 28756 | 6 | 0.996 | 28871.5 |
657 | 2020-02-03 10:49:03 | viola | 1 | 28756 | 6 | 0.546 | 52666.7 |
656 | 2020-01-30 07:48:54 | viola | 1 | 28756 | 6 | 0.520 | 55300.0 |
655 | 2020-01-30 04:03:45 | viola | 1 | 28756 | 6 | 0.516 | 55728.7 |
654 | 2020-01-27 11:33:01 | viola | 1 | 28756 | 6 | 0.533 | 53951.2 |
653 | 2020-01-26 17:24:24 | viola | 1 | 28756 | 6 | 0.783 | 36725.4 |
652 | 2020-01-25 17:55:57 | viola | 1 | 28756 | 6 | 1.080 | 26625.9 |
651 | 2020-01-24 04:34:52 | viola | 1 | 28756 | 6 | 0.500 | 57512.0 |
650 | 2020-01-21 12:11:28 | viola | 1 | 28756 | 6 | 0.673 | 42728.1 |
649 | 2020-01-14 00:20:38 | viola | 1 | 28756 | 6 | 1.063 | 27051.7 |
648 | 2020-01-11 21:31:59 | viola | 1 | 28756 | 6 | 0.546 | 52666.7 |
647 | 2020-01-09 16:53:03 | viola | 1 | 28756 | 6 | 0.420 | 68466.7 |