History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"filer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
883 | 2024-05-10 19:10:09 | filer | 2 | 53800 | 286 | 1.813 | 29674.6 |
882 | 2024-05-10 14:26:14 | filer | 2 | 53800 | 286 | 1.576 | 34137.1 |
881 | 2024-05-09 05:45:03 | filer | 2 | 53800 | 286 | 1.906 | 28226.7 |
880 | 2024-05-08 17:18:31 | filer | 1 | 28756 | 21 | 1.140 | 25224.6 |
879 | 2024-05-07 04:47:23 | filer | 1 | 28756 | 21 | 1.110 | 25906.3 |
878 | 2024-05-04 10:18:07 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
877 | 2024-04-29 08:43:02 | filer | 1 | 28756 | 21 | 1.096 | 26237.2 |
876 | 2024-04-28 04:17:37 | filer | 1 | 28756 | 21 | 0.486 | 59168.7 |
875 | 2024-04-27 11:24:46 | filer | 1 | 28756 | 21 | 1.763 | 16310.8 |
874 | 2024-04-27 11:24:12 | filer | 2 | 53800 | 286 | 2.186 | 24611.2 |
873 | 2024-04-27 01:05:10 | filer | 2 | 53800 | 286 | 8.470 | 6351.8 |
872 | 2024-04-26 05:45:01 | filer | 1 | 28756 | 21 | 0.486 | 59168.7 |
871 | 2024-04-26 05:44:34 | filer | 1 | 28756 | 21 | 0.423 | 67981.1 |
870 | 2024-04-26 05:26:53 | filer | 1 | 28756 | 21 | 0.516 | 55728.7 |
869 | 2024-04-20 21:18:44 | filer | 2 | 53800 | 286 | 7.503 | 7170.5 |
868 | 2024-04-20 21:17:08 | filer | 1 | 28756 | 21 | 0.970 | 29645.4 |
867 | 2024-04-13 11:47:12 | filer | 1 | 28756 | 21 | 0.530 | 54256.6 |
866 | 2024-04-08 16:29:04 | filer | 1 | 28756 | 21 | 1.906 | 15087.1 |
865 | 2024-04-03 02:42:40 | filer | 1 | 28756 | 21 | 0.563 | 51076.4 |
864 | 2024-03-28 23:52:36 | filer | 2 | 53800 | 286 | 5.516 | 9753.4 |
863 | 2024-03-28 23:14:06 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
862 | 2024-03-17 19:34:39 | filer | 1 | 28756 | 21 | 0.440 | 65354.5 |
861 | 2024-03-08 03:59:08 | filer | 1 | 28756 | 21 | 1.280 | 22465.6 |
860 | 2024-03-03 21:40:51 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
859 | 2024-03-01 10:09:29 | filer | 2 | 53800 | 286 | 5.080 | 10590.6 |
858 | 2024-02-27 19:41:34 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
857 | 2024-02-26 21:35:33 | filer | 1 | 28756 | 21 | 0.516 | 55728.7 |
856 | 2024-02-16 09:11:33 | filer | 1 | 28756 | 21 | 1.093 | 26309.2 |
855 | 2024-02-06 02:38:38 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
854 | 2024-02-05 20:19:02 | filer | 2 | 53800 | 286 | 1.716 | 31352.0 |
853 | 2024-02-02 19:51:27 | filer | 1 | 28756 | 21 | 0.516 | 55728.7 |
852 | 2024-01-28 18:51:36 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
851 | 2024-01-17 03:20:57 | filer | 1 | 28756 | 21 | 0.440 | 65354.5 |
850 | 2024-01-07 01:48:27 | filer | 1 | 28756 | 21 | 0.483 | 59536.2 |
849 | 2023-12-31 01:42:28 | filer | 1 | 28756 | 21 | 0.450 | 63902.2 |
848 | 2023-12-28 03:11:24 | filer | 1 | 28756 | 21 | 0.516 | 55728.7 |
847 | 2023-12-25 13:23:20 | filer | 2 | 53800 | 286 | 1.626 | 33087.3 |
846 | 2023-12-14 18:39:57 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
845 | 2023-12-11 05:12:23 | filer | 2 | 53800 | 286 | 1.390 | 38705.0 |
844 | 2023-12-08 18:26:50 | filer | 2 | 53800 | 286 | 1.516 | 35488.1 |
843 | 2023-12-03 18:59:50 | filer | 1 | 28756 | 21 | 0.453 | 63479.0 |
842 | 2023-12-03 18:59:49 | filer | 1 | 28756 | 21 | 0.766 | 37540.5 |
841 | 2023-11-15 07:28:26 | filer | 2 | 53800 | 286 | 1.360 | 39558.8 |
840 | 2023-11-11 16:47:18 | filer | 1 | 28756 | 21 | 0.513 | 56054.6 |
839 | 2023-11-11 10:51:41 | filer | 1 | 28756 | 21 | 0.470 | 61183.0 |
838 | 2023-11-11 08:38:41 | filer | 2 | 53800 | 286 | 1.580 | 34050.6 |
837 | 2023-11-07 11:12:28 | filer | 1 | 28756 | 21 | 0.483 | 59536.2 |
836 | 2023-10-30 01:43:30 | filer | 1 | 28756 | 21 | 0.893 | 32201.6 |
835 | 2023-10-29 11:37:23 | filer | 1 | 28756 | 21 | 0.513 | 56054.6 |
834 | 2023-10-23 05:49:00 | filer | 1 | 28756 | 21 | 0.890 | 32310.1 |
833 | 2023-10-21 10:28:34 | filer | 1 | 28756 | 21 | 0.483 | 59536.2 |
832 | 2023-10-18 14:49:56 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
831 | 2023-10-12 00:18:04 | filer | 1 | 28756 | 21 | 0.440 | 65354.5 |
830 | 2023-10-05 02:25:30 | filer | 1 | 28756 | 21 | 0.453 | 63479.0 |
829 | 2023-09-23 07:34:22 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
828 | 2023-09-12 10:14:44 | filer | 1 | 28756 | 21 | 0.466 | 61708.2 |
827 | 2023-08-19 02:49:30 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
826 | 2023-07-13 07:32:31 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
825 | 2023-05-20 22:52:46 | filer | 1 | 28756 | 21 | 0.420 | 68466.7 |
824 | 2023-04-01 23:35:22 | filer | 1 | 28756 | 21 | 0.470 | 61183.0 |
823 | 2023-03-16 14:15:25 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
822 | 2023-02-03 01:26:49 | filer | 2 | 53800 | 286 | 1.500 | 35866.7 |
821 | 2023-01-03 04:30:53 | filer | 1 | 28756 | 21 | 0.423 | 67981.1 |
820 | 2022-12-24 02:30:14 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
819 | 2022-12-18 03:08:18 | filer | 2 | 53800 | 286 | 1.500 | 35866.7 |
818 | 2022-11-27 21:25:48 | filer | 2 | 53800 | 286 | 1.516 | 35488.1 |
817 | 2022-11-21 01:12:27 | filer | 2 | 53800 | 286 | 1.563 | 34421.0 |
816 | 2022-10-31 12:28:10 | filer | 2 | 53800 | 286 | 1.623 | 33148.5 |
815 | 2022-10-26 06:04:50 | filer | 2 | 53800 | 286 | 1.483 | 36277.8 |
814 | 2022-09-27 12:31:18 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
813 | 2022-09-19 16:27:00 | filer | 2 | 53800 | 286 | 1.516 | 35488.1 |
812 | 2022-09-09 19:55:40 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
811 | 2022-08-21 18:50:33 | filer | 2 | 53800 | 286 | 1.360 | 39558.8 |
810 | 2022-05-21 15:09:16 | filer | 1 | 28756 | 21 | 0.516 | 55728.7 |
809 | 2022-05-18 05:16:50 | filer | 1 | 28756 | 21 | 0.440 | 65354.5 |
808 | 2022-05-13 14:21:25 | filer | 1 | 28756 | 21 | 0.593 | 48492.4 |
807 | 2022-04-08 20:16:28 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
806 | 2022-04-08 04:12:34 | filer | 1 | 28756 | 21 | 0.466 | 61708.2 |
805 | 2022-04-07 13:02:56 | filer | 1 | 28756 | 21 | 0.563 | 51076.4 |
804 | 2022-04-06 20:15:48 | filer | 1 | 28756 | 21 | 0.466 | 61708.2 |
803 | 2022-04-06 04:22:46 | filer | 1 | 28756 | 21 | 0.546 | 52666.7 |
802 | 2022-04-05 15:43:47 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
801 | 2022-04-04 14:13:09 | filer | 1 | 28756 | 21 | 0.686 | 41918.4 |
800 | 2022-04-03 21:47:33 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
799 | 2022-04-02 03:21:37 | filer | 1 | 28756 | 21 | 0.516 | 55728.7 |
798 | 2022-04-01 10:58:22 | filer | 1 | 28756 | 21 | 0.483 | 59536.2 |
797 | 2022-03-25 05:59:45 | filer | 1 | 28756 | 21 | 0.466 | 61708.2 |
796 | 2022-03-24 15:27:31 | filer | 1 | 28756 | 21 | 0.546 | 52666.7 |
795 | 2022-03-23 15:01:14 | filer | 1 | 28756 | 21 | 0.453 | 63479.0 |
794 | 2022-03-23 02:29:02 | filer | 1 | 28756 | 21 | 0.513 | 56054.6 |
793 | 2022-03-22 17:10:32 | filer | 1 | 28756 | 21 | 0.483 | 59536.2 |
792 | 2022-03-19 11:40:34 | filer | 2 | 53800 | 286 | 1.376 | 39098.8 |
791 | 2022-02-24 03:20:36 | filer | 1 | 28756 | 21 | 0.483 | 59536.2 |
790 | 2022-02-23 13:43:11 | filer | 1 | 28756 | 21 | 0.546 | 52666.7 |
789 | 2022-02-22 11:44:42 | filer | 1 | 28756 | 21 | 0.610 | 47141.0 |
788 | 2022-02-21 04:22:13 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |
787 | 2022-02-20 06:48:08 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
786 | 2022-02-19 05:51:12 | filer | 1 | 28756 | 21 | 0.436 | 65954.1 |
785 | 2022-02-18 05:59:33 | filer | 1 | 28756 | 21 | 0.483 | 59536.2 |
784 | 2022-02-17 06:52:43 | filer | 1 | 28756 | 21 | 0.500 | 57512.0 |