History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"vicars"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
817 | 2024-04-23 18:07:28 | vicars | 3 | 112716 | 678 | 5.406 | 20850.2 |
816 | 2024-04-21 21:21:27 | vicars | 3 | 112716 | 678 | 12.266 | 9189.3 |
815 | 2024-04-11 15:33:08 | vicars | 1 | 48755 | 2 | 0.716 | 68093.6 |
814 | 2024-04-11 01:03:12 | vicars | 3 | 112716 | 678 | 5.203 | 21663.7 |
813 | 2024-04-08 04:15:15 | vicars | 3 | 112716 | 678 | 7.593 | 14844.7 |
812 | 2024-04-06 13:18:48 | vicars | 3 | 112716 | 678 | 11.063 | 10188.6 |
811 | 2024-04-06 13:18:50 | vicars | 2 | 82551 | 54 | 2.513 | 32849.6 |
810 | 2024-04-06 13:18:47 | vicars | 1 | 48755 | 2 | 1.486 | 32809.6 |
809 | 2024-03-31 11:09:53 | vicars | 1 | 48755 | 2 | 2.703 | 18037.4 |
808 | 2024-03-31 00:43:34 | vicars | 2 | 82551 | 54 | 7.593 | 10872.0 |
807 | 2024-03-30 23:15:04 | vicars | 2 | 82551 | 54 | 2.470 | 33421.5 |
806 | 2024-03-29 14:29:32 | vicars | 3 | 112716 | 678 | 5.373 | 20978.2 |
805 | 2024-03-29 06:20:05 | vicars | 1 | 48755 | 2 | 1.830 | 26642.1 |
804 | 2024-03-27 16:56:25 | vicars | 3 | 112716 | 678 | 6.690 | 16848.4 |
803 | 2024-03-27 14:19:57 | vicars | 2 | 82551 | 54 | 2.283 | 36159.0 |
802 | 2024-03-27 14:19:30 | vicars | 3 | 112716 | 678 | 5.220 | 21593.1 |
801 | 2024-03-27 14:19:25 | vicars | 1 | 48755 | 2 | 0.860 | 56691.9 |
800 | 2024-03-27 14:18:57 | vicars | 3 | 112716 | 678 | 5.326 | 21163.3 |
799 | 2024-03-26 23:43:43 | vicars | 3 | 112716 | 678 | 5.736 | 19650.6 |
798 | 2024-02-28 00:19:44 | vicars | 2 | 82551 | 54 | 2.516 | 32810.4 |
797 | 2024-02-22 13:32:09 | vicars | 3 | 112716 | 678 | 6.516 | 17298.3 |
796 | 2024-02-19 20:04:39 | vicars | 3 | 112716 | 678 | 9.690 | 11632.2 |
795 | 2024-02-18 14:14:39 | vicars | 3 | 112716 | 678 | 5.250 | 21469.7 |
794 | 2024-02-05 09:55:06 | vicars | 2 | 82551 | 54 | 4.873 | 16940.5 |
793 | 2024-02-05 09:54:02 | vicars | 3 | 112716 | 678 | 5.780 | 19501.0 |
792 | 2024-02-05 06:07:10 | vicars | 1 | 48755 | 2 | 1.656 | 29441.4 |
791 | 2024-02-05 05:09:13 | vicars | 3 | 112716 | 678 | 12.216 | 9226.9 |
790 | 2024-02-05 00:02:48 | vicars | 3 | 112716 | 678 | 6.423 | 17548.8 |
789 | 2024-02-04 22:09:58 | vicars | 3 | 112716 | 678 | 4.673 | 24120.7 |
788 | 2024-02-04 21:54:43 | vicars | 3 | 112716 | 678 | 5.360 | 21029.1 |
787 | 2024-02-04 21:14:59 | vicars | 3 | 112716 | 678 | 6.516 | 17298.3 |
786 | 2024-01-12 02:08:27 | vicars | 2 | 82551 | 54 | 2.453 | 33653.1 |
785 | 2024-01-08 11:44:35 | vicars | 3 | 112716 | 678 | 6.376 | 17678.2 |
784 | 2023-12-28 18:51:56 | vicars | 1 | 48755 | 2 | 0.720 | 67715.3 |
783 | 2023-12-28 05:56:14 | vicars | 3 | 112716 | 678 | 4.686 | 24053.8 |
782 | 2023-12-28 05:56:09 | vicars | 2 | 82551 | 54 | 2.466 | 33475.7 |
781 | 2023-12-17 06:04:54 | vicars | 3 | 112716 | 678 | 4.690 | 24033.3 |
780 | 2023-12-05 06:01:55 | vicars | 2 | 82551 | 54 | 2.326 | 35490.5 |
779 | 2023-11-19 18:38:01 | vicars | 3 | 112716 | 678 | 4.966 | 22697.5 |
778 | 2023-11-18 00:16:04 | vicars | 3 | 112716 | 678 | 5.063 | 22262.7 |
777 | 2023-11-18 00:15:59 | vicars | 2 | 82551 | 54 | 2.250 | 36689.3 |
776 | 2023-11-17 07:26:54 | vicars | 1 | 48755 | 2 | 0.720 | 67715.3 |
775 | 2023-11-16 09:50:18 | vicars | 3 | 112716 | 678 | 4.780 | 23580.8 |
774 | 2023-11-13 15:52:07 | vicars | 1 | 48755 | 2 | 0.736 | 66243.2 |
773 | 2023-11-03 16:43:27 | vicars | 1 | 48755 | 2 | 0.736 | 66243.2 |
772 | 2023-10-21 12:39:26 | vicars | 1 | 48755 | 2 | 0.796 | 61250.0 |
771 | 2023-10-18 23:19:40 | vicars | 1 | 48755 | 2 | 1.640 | 29728.7 |
770 | 2023-10-18 11:33:54 | vicars | 1 | 48755 | 2 | 0.720 | 67715.3 |
769 | 2023-10-12 22:17:50 | vicars | 1 | 48755 | 2 | 0.720 | 67715.3 |
768 | 2023-10-05 17:29:08 | vicars | 1 | 48755 | 2 | 0.736 | 66243.2 |
767 | 2023-09-27 08:39:19 | vicars | 1 | 48755 | 2 | 0.720 | 67715.3 |
766 | 2023-09-23 20:53:42 | vicars | 1 | 48755 | 2 | 0.703 | 69352.8 |
765 | 2023-09-23 06:35:18 | vicars | 1 | 48755 | 2 | 0.796 | 61250.0 |
764 | 2023-09-02 17:50:25 | vicars | 2 | 82551 | 54 | 3.500 | 23586.0 |
763 | 2023-08-18 15:12:45 | vicars | 3 | 112716 | 678 | 4.453 | 25312.4 |
762 | 2023-08-15 08:32:44 | vicars | 1 | 48755 | 2 | 0.893 | 54596.9 |
761 | 2023-05-24 15:49:56 | vicars | 1 | 48755 | 2 | 0.750 | 65006.7 |
760 | 2023-05-21 09:22:10 | vicars | 2 | 82551 | 54 | 2.326 | 35490.5 |
759 | 2023-05-18 18:54:31 | vicars | 1 | 48755 | 2 | 0.703 | 69352.8 |
758 | 2023-05-03 23:40:27 | vicars | 3 | 112716 | 678 | 14.203 | 7936.1 |
757 | 2023-03-14 14:20:12 | vicars | 1 | 48755 | 2 | 0.703 | 69352.8 |
756 | 2023-03-01 16:50:48 | vicars | 2 | 82551 | 54 | 2.016 | 40947.9 |
755 | 2023-02-14 13:52:57 | vicars | 3 | 112716 | 678 | 4.500 | 25048.0 |
754 | 2023-02-06 19:15:30 | vicars | 3 | 112716 | 678 | 4.453 | 25312.4 |
753 | 2023-02-02 03:04:23 | vicars | 1 | 48755 | 2 | 0.720 | 67715.3 |
752 | 2023-01-25 00:25:56 | vicars | 1 | 48755 | 2 | 0.716 | 68093.6 |
751 | 2023-01-02 01:39:12 | vicars | 1 | 48755 | 2 | 0.813 | 59969.2 |
750 | 2022-12-17 07:52:16 | vicars | 1 | 48755 | 2 | 0.703 | 69352.8 |
749 | 2022-12-09 10:38:23 | vicars | 2 | 82551 | 54 | 2.610 | 31628.7 |
748 | 2022-11-22 23:19:57 | vicars | 1 | 48755 | 2 | 0.810 | 60191.4 |
747 | 2022-11-18 23:43:21 | vicars | 3 | 112716 | 678 | 4.530 | 24882.1 |
746 | 2022-11-10 07:20:52 | vicars | 1 | 48755 | 2 | 0.750 | 65006.7 |
745 | 2022-11-09 02:16:56 | vicars | 1 | 48755 | 2 | 0.716 | 68093.6 |
744 | 2022-09-25 03:15:53 | vicars | 1 | 48755 | 2 | 0.750 | 65006.7 |
743 | 2022-09-19 02:07:44 | vicars | 1 | 48755 | 2 | 0.750 | 65006.7 |
742 | 2022-08-07 15:37:18 | vicars | 1 | 48755 | 2 | 0.796 | 61250.0 |
741 | 2022-07-24 03:08:35 | vicars | 2 | 82551 | 54 | 2.050 | 40268.8 |
740 | 2022-05-12 15:53:23 | vicars | 3 | 112716 | 678 | 5.783 | 19490.9 |
739 | 2022-05-09 09:22:37 | vicars | 1 | 48755 | 2 | 1.016 | 47987.2 |
738 | 2022-05-07 11:02:02 | vicars | 3 | 112716 | 678 | 4.516 | 24959.3 |
737 | 2022-05-02 13:25:54 | vicars | 1 | 48755 | 2 | 0.733 | 66514.3 |
736 | 2022-02-27 15:09:34 | vicars | 2 | 82551 | 54 | 2.233 | 36968.7 |
735 | 2022-01-21 21:46:30 | vicars | 1 | 48755 | 2 | 0.860 | 56691.9 |
734 | 2022-01-09 05:18:46 | vicars | 3 | 112716 | 678 | 4.656 | 24208.8 |
733 | 2022-01-02 08:07:36 | vicars | 1 | 48755 | 2 | 0.890 | 54780.9 |
732 | 2021-11-21 14:25:31 | vicars | 1 | 48755 | 2 | 0.736 | 66243.2 |
731 | 2021-11-19 12:01:39 | vicars | 1 | 48755 | 2 | 0.736 | 66243.2 |
730 | 2021-11-15 18:15:30 | vicars | 1 | 48755 | 2 | 0.906 | 53813.5 |
729 | 2021-09-16 15:39:18 | vicars | 1 | 48755 | 2 | 0.750 | 65006.7 |
728 | 2021-08-01 18:43:32 | vicars | 3 | 112716 | 678 | 4.500 | 25048.0 |
727 | 2021-06-24 20:53:56 | vicars | 3 | 112716 | 678 | 5.420 | 20796.3 |
726 | 2021-06-19 22:54:22 | vicars | 1 | 48755 | 2 | 0.843 | 57835.1 |
725 | 2021-06-06 17:10:52 | vicars | 1 | 48755 | 2 | 0.873 | 55847.7 |
724 | 2021-06-06 06:51:30 | vicars | 1 | 48755 | 2 | 0.750 | 65006.7 |
723 | 2021-06-05 11:28:19 | vicars | 3 | 112716 | 678 | 5.656 | 19928.6 |
722 | 2021-03-31 06:21:59 | vicars | 1 | 48755 | 2 | 0.830 | 58741.0 |
721 | 2021-02-18 18:12:56 | vicars | 1 | 48755 | 2 | 0.766 | 63648.8 |
720 | 2021-02-18 06:03:45 | vicars | 1 | 48755 | 2 | 0.733 | 66514.3 |
719 | 2021-02-09 00:06:24 | vicars | 1 | 48755 | 2 | 0.750 | 65006.7 |
718 | 2020-11-18 22:26:55 | vicars | 1 | 48755 | 2 | 0.766 | 63648.8 |