History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hogan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
914 | 2024-04-12 07:34:58 | hogan | 1 | 28756 | 5 | 0.610 | 47141.0 |
913 | 2024-04-06 05:50:10 | hogan | 1 | 28756 | 5 | 0.546 | 52666.7 |
912 | 2024-03-31 14:45:34 | hogan | 3 | 83667 | 1001 | 6.560 | 12754.1 |
911 | 2024-03-31 14:45:34 | hogan | 2 | 53800 | 68 | 5.766 | 9330.6 |
910 | 2024-03-31 14:44:21 | hogan | 1 | 28756 | 5 | 1.673 | 17188.3 |
909 | 2024-03-29 23:34:57 | hogan | 2 | 53800 | 68 | 3.606 | 14919.6 |
908 | 2024-03-29 23:34:16 | hogan | 3 | 83667 | 1001 | 6.766 | 12365.8 |
907 | 2024-03-28 19:07:08 | hogan | 3 | 83667 | 1001 | 4.986 | 16780.4 |
906 | 2024-03-28 18:43:55 | hogan | 2 | 53800 | 68 | 3.656 | 14715.5 |
905 | 2024-03-28 18:21:53 | hogan | 1 | 28756 | 5 | 0.483 | 59536.2 |
904 | 2024-03-27 15:18:25 | hogan | 2 | 53800 | 68 | 1.436 | 37465.2 |
903 | 2024-03-27 15:17:57 | hogan | 3 | 83667 | 1001 | 3.483 | 24021.5 |
902 | 2024-03-23 13:05:43 | hogan | 3 | 83667 | 1001 | 3.263 | 25641.1 |
901 | 2024-03-12 07:50:10 | hogan | 1 | 28756 | 5 | 0.513 | 56054.6 |
900 | 2024-03-07 20:12:05 | hogan | 3 | 83667 | 1001 | 3.953 | 21165.4 |
899 | 2024-03-07 06:42:34 | hogan | 3 | 83667 | 1001 | 4.406 | 18989.3 |
898 | 2024-03-07 06:42:35 | hogan | 2 | 53800 | 68 | 1.766 | 30464.3 |
897 | 2024-03-07 04:43:00 | hogan | 1 | 28756 | 5 | 0.483 | 59536.2 |
896 | 2024-03-01 08:35:49 | hogan | 1 | 28756 | 5 | 0.560 | 51350.0 |
895 | 2024-02-26 03:44:21 | hogan | 2 | 53800 | 68 | 1.690 | 31834.3 |
894 | 2024-02-26 03:43:37 | hogan | 3 | 83667 | 1001 | 5.250 | 15936.6 |
893 | 2024-02-25 18:46:54 | hogan | 3 | 83667 | 1001 | 9.000 | 9296.3 |
892 | 2024-02-25 18:46:52 | hogan | 2 | 53800 | 68 | 1.830 | 29398.9 |
891 | 2024-02-25 18:43:17 | hogan | 1 | 28756 | 5 | 1.076 | 26724.9 |
890 | 2024-02-03 18:59:19 | hogan | 1 | 28756 | 5 | 0.466 | 61708.2 |
889 | 2024-01-29 02:57:51 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
888 | 2024-01-26 05:45:13 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
887 | 2023-12-31 23:17:41 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
886 | 2023-12-16 18:25:06 | hogan | 3 | 83667 | 1001 | 3.360 | 24900.9 |
885 | 2023-12-16 18:25:05 | hogan | 2 | 53800 | 68 | 1.533 | 35094.6 |
884 | 2023-12-02 01:59:49 | hogan | 1 | 28756 | 5 | 0.513 | 56054.6 |
883 | 2023-12-01 17:09:00 | hogan | 3 | 83667 | 1001 | 3.843 | 21771.3 |
882 | 2023-11-26 22:17:01 | hogan | 2 | 53800 | 68 | 1.610 | 33416.1 |
881 | 2023-11-26 22:16:58 | hogan | 3 | 83667 | 1001 | 3.920 | 21343.6 |
880 | 2023-11-13 00:14:55 | hogan | 2 | 53800 | 68 | 1.546 | 34799.5 |
879 | 2023-11-13 00:14:50 | hogan | 3 | 83667 | 1001 | 3.343 | 25027.5 |
878 | 2023-11-11 21:24:47 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
877 | 2023-11-09 22:42:20 | hogan | 1 | 28756 | 5 | 0.436 | 65954.1 |
876 | 2023-10-26 18:17:33 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
875 | 2023-10-22 02:02:17 | hogan | 1 | 28756 | 5 | 0.453 | 63479.0 |
874 | 2023-10-20 10:21:48 | hogan | 1 | 28756 | 5 | 0.533 | 53951.2 |
873 | 2023-10-17 06:49:08 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
872 | 2023-10-16 20:56:23 | hogan | 3 | 83667 | 1001 | 7.156 | 11691.9 |
871 | 2023-10-16 03:52:50 | hogan | 3 | 83667 | 1001 | 3.250 | 25743.7 |
870 | 2023-10-14 16:39:17 | hogan | 2 | 53800 | 68 | 3.356 | 16031.0 |
869 | 2023-10-10 20:05:56 | hogan | 1 | 28756 | 5 | 0.466 | 61708.2 |
868 | 2023-10-04 00:25:03 | hogan | 1 | 28756 | 5 | 0.486 | 59168.7 |
867 | 2023-09-23 06:47:27 | hogan | 1 | 28756 | 5 | 0.483 | 59536.2 |
866 | 2023-09-11 03:52:19 | hogan | 1 | 28756 | 5 | 0.483 | 59536.2 |
865 | 2023-08-31 00:58:57 | hogan | 3 | 83667 | 1001 | 3.186 | 26260.8 |
864 | 2023-08-18 08:06:29 | hogan | 1 | 28756 | 5 | 0.486 | 59168.7 |
863 | 2023-08-13 02:55:01 | hogan | 1 | 28756 | 5 | 0.516 | 55728.7 |
862 | 2023-07-15 14:32:14 | hogan | 3 | 83667 | 1001 | 6.626 | 12627.1 |
861 | 2023-07-14 17:15:34 | hogan | 3 | 83667 | 1001 | 3.236 | 25855.1 |
860 | 2023-05-21 00:59:17 | hogan | 1 | 28756 | 5 | 0.486 | 59168.7 |
859 | 2023-05-17 06:57:44 | hogan | 3 | 83667 | 1001 | 3.266 | 25617.6 |
858 | 2023-05-02 00:25:13 | hogan | 1 | 28756 | 5 | 0.483 | 59536.2 |
857 | 2023-04-25 15:03:09 | hogan | 3 | 83667 | 1001 | 3.563 | 23482.2 |
856 | 2023-03-29 08:11:13 | hogan | 3 | 83667 | 1001 | 3.516 | 23796.1 |
855 | 2023-03-16 13:08:10 | hogan | 1 | 28756 | 5 | 0.483 | 59536.2 |
854 | 2023-02-25 01:57:38 | hogan | 3 | 83667 | 1001 | 3.576 | 23396.8 |
853 | 2023-01-19 17:25:54 | hogan | 1 | 28756 | 5 | 0.453 | 63479.0 |
852 | 2023-01-03 00:14:27 | hogan | 1 | 28756 | 5 | 0.436 | 65954.1 |
851 | 2022-12-06 01:48:59 | hogan | 3 | 83667 | 1001 | 6.423 | 13026.2 |
850 | 2022-10-01 23:33:25 | hogan | 1 | 28756 | 5 | 0.483 | 59536.2 |
849 | 2022-09-23 23:29:01 | hogan | 1 | 28756 | 5 | 0.423 | 67981.1 |
848 | 2022-09-19 10:53:21 | hogan | 1 | 28756 | 5 | 0.436 | 65954.1 |
847 | 2022-08-14 15:05:31 | hogan | 1 | 28756 | 5 | 0.436 | 65954.1 |
846 | 2022-08-14 01:55:58 | hogan | 1 | 28756 | 5 | 0.483 | 59536.2 |
845 | 2022-08-06 19:32:45 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
844 | 2022-07-30 00:32:48 | hogan | 1 | 28756 | 5 | 0.516 | 55728.7 |
843 | 2022-07-28 23:18:08 | hogan | 1 | 28756 | 5 | 0.470 | 61183.0 |
842 | 2022-07-03 07:13:29 | hogan | 1 | 28756 | 5 | 0.440 | 65354.5 |
841 | 2022-06-16 07:14:45 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
840 | 2022-06-11 08:53:40 | hogan | 1 | 28756 | 5 | 0.436 | 65954.1 |
839 | 2022-05-06 06:02:27 | hogan | 1 | 28756 | 5 | 0.436 | 65954.1 |
838 | 2022-04-08 10:32:53 | hogan | 3 | 83667 | 1001 | 3.313 | 25254.2 |
837 | 2022-04-06 07:15:28 | hogan | 3 | 83667 | 1001 | 3.186 | 26260.8 |
836 | 2022-02-27 18:46:33 | hogan | 1 | 28756 | 5 | 0.516 | 55728.7 |
835 | 2022-01-27 08:10:49 | hogan | 1 | 28756 | 5 | 0.453 | 63479.0 |
834 | 2021-12-13 11:41:53 | hogan | 3 | 83667 | 1001 | 4.140 | 20209.4 |
833 | 2021-11-26 22:28:18 | hogan | 1 | 28756 | 5 | 0.486 | 59168.7 |
832 | 2021-11-19 12:02:20 | hogan | 1 | 28756 | 5 | 0.453 | 63479.0 |
831 | 2021-10-08 10:38:45 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
830 | 2021-10-06 08:11:01 | hogan | 1 | 28756 | 5 | 0.486 | 59168.7 |
829 | 2021-10-04 03:51:01 | hogan | 3 | 83667 | 1001 | 3.640 | 22985.4 |
828 | 2021-09-01 21:50:18 | hogan | 1 | 28756 | 5 | 0.470 | 61183.0 |
827 | 2021-08-15 09:16:18 | hogan | 3 | 83667 | 1001 | 3.656 | 22884.8 |
826 | 2021-08-13 08:15:12 | hogan | 1 | 28756 | 5 | 0.436 | 65954.1 |
825 | 2021-08-13 05:55:59 | hogan | 1 | 28756 | 5 | 0.453 | 63479.0 |
824 | 2021-06-05 04:21:28 | hogan | 1 | 28756 | 5 | 0.436 | 65954.1 |
823 | 2021-05-12 14:55:48 | hogan | 1 | 28756 | 5 | 0.483 | 59536.2 |
822 | 2021-02-21 11:57:12 | hogan | 2 | 53800 | 68 | 1.376 | 39098.8 |
821 | 2021-02-19 16:19:27 | hogan | 1 | 28756 | 5 | 0.753 | 38188.6 |
820 | 2021-02-08 14:59:14 | hogan | 1 | 28756 | 5 | 0.453 | 63479.0 |
819 | 2021-01-24 09:32:20 | hogan | 1 | 28756 | 5 | 0.436 | 65954.1 |
818 | 2021-01-17 19:58:35 | hogan | 3 | 83667 | 1001 | 3.266 | 25617.6 |
817 | 2020-11-29 03:47:40 | hogan | 1 | 28756 | 5 | 0.530 | 54256.6 |
816 | 2020-11-06 20:50:34 | hogan | 1 | 28756 | 5 | 0.466 | 61708.2 |
815 | 2020-10-30 03:48:57 | hogan | 2 | 53800 | 68 | 1.640 | 32804.9 |