History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"barny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
867 | 2024-04-15 07:29:27 | barny | 1 | 28756 | 8 | 1.703 | 16885.5 |
866 | 2024-04-11 00:30:23 | barny | 1 | 28756 | 8 | 0.516 | 55728.7 |
865 | 2024-04-06 05:38:50 | barny | 1 | 28756 | 8 | 0.546 | 52666.7 |
864 | 2024-03-31 06:49:26 | barny | 2 | 53800 | 156 | 1.953 | 27547.4 |
863 | 2024-03-31 06:43:42 | barny | 1 | 28756 | 8 | 1.030 | 27918.4 |
862 | 2024-03-29 02:58:22 | barny | 1 | 28756 | 8 | 0.546 | 52666.7 |
861 | 2024-03-25 10:49:12 | barny | 1 | 28756 | 8 | 0.533 | 53951.2 |
860 | 2024-03-07 05:53:38 | barny | 2 | 53800 | 156 | 3.720 | 14462.4 |
859 | 2024-03-07 04:31:39 | barny | 1 | 28756 | 8 | 0.580 | 49579.3 |
858 | 2024-03-03 15:58:24 | barny | 1 | 28756 | 8 | 1.173 | 24514.9 |
857 | 2024-02-27 20:10:29 | barny | 1 | 28756 | 8 | 0.530 | 54256.6 |
856 | 2024-02-03 18:22:27 | barny | 1 | 28756 | 8 | 0.440 | 65354.5 |
855 | 2024-01-29 02:02:55 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
854 | 2024-01-28 18:38:53 | barny | 1 | 28756 | 8 | 0.466 | 61708.2 |
853 | 2024-01-19 15:41:40 | barny | 1 | 28756 | 8 | 0.470 | 61183.0 |
852 | 2024-01-05 06:38:58 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
851 | 2024-01-01 16:33:06 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
850 | 2023-12-31 11:22:06 | barny | 1 | 28756 | 8 | 0.516 | 55728.7 |
849 | 2023-12-29 09:13:43 | barny | 2 | 53800 | 156 | 1.593 | 33772.8 |
848 | 2023-12-21 15:39:49 | barny | 2 | 53800 | 156 | 1.436 | 37465.2 |
847 | 2023-11-16 04:57:37 | barny | 2 | 53800 | 156 | 1.423 | 37807.4 |
846 | 2023-11-14 08:40:52 | barny | 1 | 28756 | 8 | 0.450 | 63902.2 |
845 | 2023-11-12 02:14:14 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
844 | 2023-11-03 10:30:31 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
843 | 2023-10-21 11:09:32 | barny | 1 | 28756 | 8 | 0.436 | 65954.1 |
842 | 2023-10-21 07:30:54 | barny | 1 | 28756 | 8 | 0.486 | 59168.7 |
841 | 2023-10-17 16:20:18 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
840 | 2023-10-17 15:38:05 | barny | 2 | 53800 | 156 | 1.623 | 33148.5 |
839 | 2023-10-11 00:24:23 | barny | 1 | 28756 | 8 | 0.440 | 65354.5 |
838 | 2023-10-04 15:10:17 | barny | 1 | 28756 | 8 | 0.486 | 59168.7 |
837 | 2023-09-26 04:20:25 | barny | 1 | 28756 | 8 | 0.533 | 53951.2 |
836 | 2023-09-25 13:55:17 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
835 | 2023-09-25 11:42:00 | barny | 1 | 28756 | 8 | 0.513 | 56054.6 |
834 | 2023-08-16 18:37:41 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
833 | 2023-07-16 07:54:19 | barny | 1 | 28756 | 8 | 0.486 | 59168.7 |
832 | 2023-06-22 03:37:28 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
831 | 2023-05-20 07:35:13 | barny | 1 | 28756 | 8 | 0.436 | 65954.1 |
830 | 2023-03-27 01:13:36 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
829 | 2023-03-18 07:17:50 | barny | 1 | 28756 | 8 | 0.486 | 59168.7 |
828 | 2023-03-13 07:45:57 | barny | 1 | 28756 | 8 | 0.516 | 55728.7 |
827 | 2023-01-06 04:36:35 | barny | 1 | 28756 | 8 | 0.530 | 54256.6 |
826 | 2022-12-01 18:06:30 | barny | 1 | 28756 | 8 | 0.470 | 61183.0 |
825 | 2022-11-28 11:06:24 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
824 | 2022-10-03 04:01:41 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
823 | 2022-08-27 17:16:46 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
822 | 2022-08-24 23:13:10 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
821 | 2022-08-23 04:36:09 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
820 | 2022-07-10 18:02:01 | barny | 1 | 28756 | 8 | 0.906 | 31739.5 |
819 | 2022-05-22 15:10:05 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
818 | 2022-05-19 05:31:16 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
817 | 2022-05-17 11:38:41 | barny | 1 | 28756 | 8 | 0.593 | 48492.4 |
816 | 2022-02-14 13:12:35 | barny | 1 | 28756 | 8 | 0.936 | 30722.2 |
815 | 2022-01-29 23:34:45 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
814 | 2021-12-21 13:38:50 | barny | 1 | 28756 | 8 | 0.470 | 61183.0 |
813 | 2021-11-21 00:13:12 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
812 | 2021-11-13 08:41:14 | barny | 1 | 28756 | 8 | 0.516 | 55728.7 |
811 | 2021-11-03 23:45:53 | barny | 1 | 28756 | 8 | 0.533 | 53951.2 |
810 | 2021-10-10 21:17:50 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
809 | 2021-09-02 06:40:09 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
808 | 2021-08-15 19:20:17 | barny | 1 | 28756 | 8 | 0.436 | 65954.1 |
807 | 2021-08-10 10:26:28 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
806 | 2021-05-23 18:36:02 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
805 | 2021-05-09 12:51:45 | barny | 1 | 28756 | 8 | 0.530 | 54256.6 |
804 | 2021-04-26 15:40:44 | barny | 1 | 28756 | 8 | 0.516 | 55728.7 |
803 | 2021-03-26 21:18:19 | barny | 1 | 28756 | 8 | 1.016 | 28303.1 |
802 | 2021-03-01 00:13:01 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
801 | 2021-02-03 23:58:37 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
800 | 2021-01-10 04:31:05 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
799 | 2020-12-11 18:58:08 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
798 | 2020-11-02 09:43:09 | barny | 1 | 28756 | 8 | 0.546 | 52666.7 |
797 | 2020-10-17 16:43:37 | barny | 1 | 28756 | 8 | 0.513 | 56054.6 |
796 | 2020-09-07 06:33:16 | barny | 1 | 28756 | 8 | 0.440 | 65354.5 |
795 | 2020-08-31 03:02:29 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
794 | 2020-08-16 04:06:25 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
793 | 2020-07-30 13:23:02 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
792 | 2020-07-21 06:59:04 | barny | 1 | 28756 | 8 | 0.516 | 55728.7 |
791 | 2020-05-01 08:49:59 | barny | 1 | 28756 | 8 | 0.530 | 54256.6 |
790 | 2020-03-30 13:12:42 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
789 | 2020-03-30 04:00:23 | barny | 1 | 28756 | 8 | 0.563 | 51076.4 |
788 | 2020-03-24 13:27:08 | barny | 1 | 28756 | 8 | 0.593 | 48492.4 |
787 | 2020-03-24 10:49:23 | barny | 1 | 28756 | 8 | 0.516 | 55728.7 |
786 | 2020-03-22 20:05:46 | barny | 1 | 28756 | 8 | 0.546 | 52666.7 |
785 | 2020-03-22 14:06:25 | barny | 1 | 28756 | 8 | 0.533 | 53951.2 |
784 | 2020-03-22 04:47:33 | barny | 1 | 28756 | 8 | 0.546 | 52666.7 |
783 | 2020-03-21 05:14:50 | barny | 1 | 28756 | 8 | 0.453 | 63479.0 |
782 | 2020-03-17 23:07:03 | barny | 1 | 28756 | 8 | 0.436 | 65954.1 |
781 | 2020-02-29 21:28:27 | barny | 1 | 28756 | 8 | 1.110 | 25906.3 |
780 | 2020-02-22 16:50:04 | barny | 1 | 28756 | 8 | 0.533 | 53951.2 |
779 | 2020-02-20 02:40:48 | barny | 1 | 28756 | 8 | 1.123 | 25606.4 |
778 | 2020-02-16 23:59:57 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
777 | 2020-02-12 23:05:38 | barny | 1 | 28756 | 8 | 1.143 | 25158.4 |
776 | 2020-02-10 22:52:17 | barny | 1 | 28756 | 8 | 0.533 | 53951.2 |
775 | 2020-02-07 01:39:07 | barny | 1 | 28756 | 8 | 0.623 | 46157.3 |
774 | 2020-01-30 07:40:46 | barny | 1 | 28756 | 8 | 1.046 | 27491.4 |
773 | 2020-01-27 08:15:59 | barny | 1 | 28756 | 8 | 0.546 | 52666.7 |
772 | 2020-01-27 02:43:23 | barny | 1 | 28756 | 8 | 0.546 | 52666.7 |
771 | 2020-01-26 19:51:21 | barny | 1 | 28756 | 8 | 0.513 | 56054.6 |
770 | 2020-01-25 15:55:02 | barny | 1 | 28756 | 8 | 0.576 | 49923.6 |
769 | 2020-01-23 00:07:35 | barny | 1 | 28756 | 8 | 1.750 | 16432.0 |
768 | 2020-01-21 00:36:55 | barny | 1 | 28756 | 8 | 1.186 | 24246.2 |