History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"biggy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
867 | 2024-05-01 18:12:32 | biggy | 1 | 28756 | 9 | 0.483 | 59536.2 |
866 | 2024-05-01 12:18:30 | biggy | 1 | 28756 | 9 | 0.920 | 31256.5 |
865 | 2024-04-29 14:11:53 | biggy | 1 | 28756 | 9 | 0.530 | 54256.6 |
864 | 2024-04-28 11:11:03 | biggy | 1 | 28756 | 9 | 0.500 | 57512.0 |
863 | 2024-04-09 03:39:06 | biggy | 1 | 28756 | 9 | 1.560 | 18433.3 |
862 | 2024-04-03 07:18:30 | biggy | 1 | 28756 | 9 | 0.466 | 61708.2 |
861 | 2024-03-31 03:05:39 | biggy | 1 | 28756 | 9 | 1.766 | 16283.1 |
860 | 2024-03-30 06:58:51 | biggy | 1 | 28756 | 9 | 0.783 | 36725.4 |
859 | 2024-03-28 20:52:01 | biggy | 1 | 28756 | 9 | 0.546 | 52666.7 |
858 | 2024-03-09 18:41:46 | biggy | 1 | 28756 | 9 | 0.563 | 51076.4 |
857 | 2024-03-03 21:42:39 | biggy | 1 | 28756 | 9 | 0.453 | 63479.0 |
856 | 2024-03-02 05:07:36 | biggy | 2 | 53800 | 71 | 3.796 | 14172.8 |
855 | 2024-02-27 22:53:28 | biggy | 3 | 83667 | 705 | 5.016 | 16680.0 |
854 | 2024-02-27 22:53:26 | biggy | 2 | 53800 | 71 | 1.780 | 30224.7 |
853 | 2024-02-27 22:32:40 | biggy | 3 | 83667 | 705 | 6.956 | 12028.0 |
852 | 2024-02-27 22:32:39 | biggy | 2 | 53800 | 71 | 2.110 | 25497.6 |
851 | 2024-02-27 20:55:11 | biggy | 1 | 28756 | 9 | 0.516 | 55728.7 |
850 | 2024-02-24 18:27:49 | biggy | 1 | 28756 | 9 | 0.436 | 65954.1 |
849 | 2024-01-28 20:06:55 | biggy | 1 | 28756 | 9 | 0.560 | 51350.0 |
848 | 2024-01-09 12:46:24 | biggy | 1 | 28756 | 9 | 0.466 | 61708.2 |
847 | 2024-01-09 05:49:13 | biggy | 1 | 28756 | 9 | 0.466 | 61708.2 |
846 | 2024-01-01 19:31:56 | biggy | 3 | 83667 | 705 | 3.736 | 22394.8 |
845 | 2023-12-25 03:09:22 | biggy | 3 | 83667 | 705 | 4.033 | 20745.6 |
844 | 2023-12-25 03:09:23 | biggy | 2 | 53800 | 71 | 1.670 | 32215.6 |
843 | 2023-12-07 21:38:42 | biggy | 3 | 83667 | 705 | 7.753 | 10791.6 |
842 | 2023-12-07 21:38:44 | biggy | 2 | 53800 | 71 | 1.656 | 32487.9 |
841 | 2023-11-21 13:42:51 | biggy | 2 | 53800 | 71 | 1.343 | 40059.6 |
840 | 2023-11-12 13:23:16 | biggy | 1 | 28756 | 9 | 0.470 | 61183.0 |
839 | 2023-11-11 01:34:27 | biggy | 1 | 28756 | 9 | 0.500 | 57512.0 |
838 | 2023-11-08 09:51:52 | biggy | 1 | 28756 | 9 | 0.486 | 59168.7 |
837 | 2023-11-04 02:23:59 | biggy | 1 | 28756 | 9 | 0.436 | 65954.1 |
836 | 2023-11-03 08:44:00 | biggy | 3 | 83667 | 705 | 3.860 | 21675.4 |
835 | 2023-11-01 18:51:43 | biggy | 1 | 28756 | 9 | 0.483 | 59536.2 |
834 | 2023-10-31 22:02:53 | biggy | 3 | 83667 | 705 | 3.876 | 21585.9 |
833 | 2023-10-30 20:42:12 | biggy | 3 | 83667 | 705 | 4.110 | 20356.9 |
832 | 2023-10-29 03:12:52 | biggy | 1 | 28756 | 9 | 0.500 | 57512.0 |
831 | 2023-10-25 23:07:37 | biggy | 3 | 83667 | 705 | 5.186 | 16133.2 |
830 | 2023-10-25 23:07:35 | biggy | 2 | 53800 | 71 | 3.173 | 16955.6 |
829 | 2023-10-23 16:36:59 | biggy | 1 | 28756 | 9 | 0.453 | 63479.0 |
828 | 2023-10-22 09:42:04 | biggy | 2 | 53800 | 71 | 1.593 | 33772.8 |
827 | 2023-10-19 19:16:51 | biggy | 1 | 28756 | 9 | 0.500 | 57512.0 |
826 | 2023-10-17 00:37:25 | biggy | 1 | 28756 | 9 | 0.440 | 65354.5 |
825 | 2023-10-16 19:29:33 | biggy | 3 | 83667 | 705 | 8.953 | 9345.1 |
824 | 2023-10-16 02:57:35 | biggy | 3 | 83667 | 705 | 3.483 | 24021.5 |
823 | 2023-10-13 14:49:11 | biggy | 1 | 28756 | 9 | 0.436 | 65954.1 |
822 | 2023-10-11 15:12:16 | biggy | 3 | 83667 | 705 | 5.143 | 16268.1 |
821 | 2023-10-08 07:06:37 | biggy | 3 | 83667 | 705 | 3.310 | 25277.0 |
820 | 2023-10-04 04:59:21 | biggy | 1 | 28756 | 9 | 0.546 | 52666.7 |
819 | 2023-09-23 02:53:13 | biggy | 1 | 28756 | 9 | 0.486 | 59168.7 |
818 | 2023-09-22 01:50:36 | biggy | 1 | 28756 | 9 | 0.436 | 65954.1 |
817 | 2023-08-24 22:06:01 | biggy | 1 | 28756 | 9 | 0.530 | 54256.6 |
816 | 2023-08-22 00:28:30 | biggy | 2 | 53800 | 71 | 1.343 | 40059.6 |
815 | 2023-07-20 14:14:16 | biggy | 1 | 28756 | 9 | 0.453 | 63479.0 |
814 | 2023-07-19 14:42:26 | biggy | 3 | 83667 | 705 | 3.423 | 24442.6 |
813 | 2023-07-19 10:53:14 | biggy | 1 | 28756 | 9 | 0.470 | 61183.0 |
812 | 2023-06-03 00:33:24 | biggy | 3 | 83667 | 705 | 3.623 | 23093.3 |
811 | 2023-06-01 11:35:46 | biggy | 1 | 28756 | 9 | 0.420 | 68466.7 |
810 | 2023-05-25 04:09:14 | biggy | 1 | 28756 | 9 | 0.436 | 65954.1 |
809 | 2023-05-07 09:58:52 | biggy | 2 | 53800 | 71 | 1.343 | 40059.6 |
808 | 2023-04-10 02:19:32 | biggy | 3 | 83667 | 705 | 3.483 | 24021.5 |
807 | 2023-04-09 01:51:07 | biggy | 1 | 28756 | 9 | 0.423 | 67981.1 |
806 | 2023-04-03 07:52:31 | biggy | 3 | 83667 | 705 | 7.390 | 11321.7 |
805 | 2023-03-31 13:57:06 | biggy | 1 | 28756 | 9 | 0.500 | 57512.0 |
804 | 2023-03-20 01:20:57 | biggy | 1 | 28756 | 9 | 0.483 | 59536.2 |
803 | 2023-03-16 11:05:39 | biggy | 3 | 83667 | 705 | 3.390 | 24680.5 |
802 | 2023-02-13 07:49:37 | biggy | 2 | 53800 | 71 | 1.326 | 40573.2 |
801 | 2023-01-20 07:20:04 | biggy | 3 | 83667 | 705 | 3.733 | 22412.8 |
800 | 2023-01-07 09:53:21 | biggy | 1 | 28756 | 9 | 0.436 | 65954.1 |
799 | 2023-01-02 10:12:17 | biggy | 3 | 83667 | 705 | 3.233 | 25879.1 |
798 | 2022-12-27 09:44:27 | biggy | 1 | 28756 | 9 | 0.436 | 65954.1 |
797 | 2022-11-25 15:49:38 | biggy | 2 | 53800 | 71 | 1.346 | 39970.3 |
796 | 2022-11-25 04:53:59 | biggy | 1 | 28756 | 9 | 0.513 | 56054.6 |
795 | 2022-10-01 08:42:15 | biggy | 1 | 28756 | 9 | 0.440 | 65354.5 |
794 | 2022-09-09 10:48:38 | biggy | 1 | 28756 | 9 | 0.440 | 65354.5 |
793 | 2022-09-07 01:35:58 | biggy | 3 | 83667 | 705 | 3.266 | 25617.6 |
792 | 2022-09-01 17:34:30 | biggy | 1 | 28756 | 9 | 0.500 | 57512.0 |
791 | 2022-06-26 20:17:37 | biggy | 3 | 83667 | 705 | 3.266 | 25617.6 |
790 | 2022-06-11 17:11:19 | biggy | 3 | 83667 | 705 | 3.250 | 25743.7 |
789 | 2022-06-10 06:56:43 | biggy | 3 | 83667 | 705 | 3.500 | 23904.9 |
788 | 2022-06-02 07:58:15 | biggy | 3 | 83667 | 705 | 3.216 | 26015.9 |
787 | 2022-05-21 06:46:41 | biggy | 1 | 28756 | 9 | 0.436 | 65954.1 |
786 | 2022-05-17 20:51:43 | biggy | 1 | 28756 | 9 | 0.456 | 63061.4 |
785 | 2022-05-15 09:05:05 | biggy | 1 | 28756 | 9 | 0.500 | 57512.0 |
784 | 2022-05-14 11:38:04 | biggy | 1 | 28756 | 9 | 0.436 | 65954.1 |
783 | 2022-04-30 19:45:36 | biggy | 2 | 53800 | 71 | 1.390 | 38705.0 |
782 | 2022-02-09 13:47:15 | biggy | 1 | 28756 | 9 | 0.470 | 61183.0 |
781 | 2022-02-01 04:14:12 | biggy | 1 | 28756 | 9 | 0.470 | 61183.0 |
780 | 2022-01-29 23:31:20 | biggy | 1 | 28756 | 9 | 0.593 | 48492.4 |
779 | 2022-01-02 17:16:38 | biggy | 2 | 53800 | 71 | 1.610 | 33416.1 |
778 | 2021-12-08 12:58:59 | biggy | 1 | 28756 | 9 | 1.093 | 26309.2 |
777 | 2021-11-20 23:50:45 | biggy | 1 | 28756 | 9 | 0.516 | 55728.7 |
776 | 2021-11-19 00:24:08 | biggy | 1 | 28756 | 9 | 0.470 | 61183.0 |
775 | 2021-11-05 08:09:04 | biggy | 1 | 28756 | 9 | 0.500 | 57512.0 |
774 | 2021-10-11 14:55:04 | biggy | 2 | 53800 | 71 | 1.576 | 34137.1 |
773 | 2021-10-04 19:03:17 | biggy | 3 | 83667 | 705 | 3.703 | 22594.4 |
772 | 2021-10-02 12:21:26 | biggy | 1 | 28756 | 9 | 0.486 | 59168.7 |
771 | 2021-09-02 07:51:12 | biggy | 1 | 28756 | 9 | 0.440 | 65354.5 |
770 | 2021-08-31 01:54:26 | biggy | 1 | 28756 | 9 | 0.420 | 68466.7 |
769 | 2021-08-18 03:40:22 | biggy | 3 | 83667 | 705 | 3.360 | 24900.9 |
768 | 2021-08-18 00:46:27 | biggy | 1 | 28756 | 9 | 0.486 | 59168.7 |