History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"haggis"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
904 | 2024-04-27 09:57:31 | haggis | 1 | 48755 | 2 | 0.923 | 52822.3 |
903 | 2024-04-14 22:31:00 | haggis | 1 | 48755 | 2 | 0.826 | 59025.4 |
902 | 2024-04-06 01:45:21 | haggis | 1 | 48755 | 2 | 3.750 | 13001.3 |
901 | 2024-04-05 04:56:55 | haggis | 1 | 48755 | 2 | 0.953 | 51159.5 |
900 | 2024-03-04 18:25:31 | haggis | 1 | 48755 | 2 | 2.516 | 19378.0 |
899 | 2024-03-01 10:40:26 | haggis | 1 | 48755 | 2 | 1.703 | 28628.9 |
898 | 2024-02-29 04:05:24 | haggis | 2 | 82551 | 29 | 3.750 | 22013.6 |
897 | 2024-02-29 04:05:01 | haggis | 3 | 112716 | 589 | 9.343 | 12064.2 |
896 | 2024-02-28 07:16:28 | haggis | 2 | 82551 | 29 | 2.656 | 31080.9 |
895 | 2024-02-28 07:16:08 | haggis | 3 | 112716 | 589 | 7.860 | 14340.5 |
894 | 2024-02-28 06:49:23 | haggis | 2 | 82551 | 29 | 2.876 | 28703.4 |
893 | 2024-02-27 17:25:17 | haggis | 2 | 82551 | 29 | 2.953 | 27955.0 |
892 | 2024-02-27 17:24:42 | haggis | 3 | 112716 | 589 | 5.686 | 19823.4 |
891 | 2024-02-24 19:19:23 | haggis | 3 | 112716 | 589 | 6.173 | 18259.5 |
890 | 2024-01-21 01:14:45 | haggis | 2 | 82551 | 29 | 2.220 | 37185.1 |
889 | 2024-01-11 18:19:07 | haggis | 2 | 82551 | 29 | 2.156 | 38289.0 |
888 | 2023-12-26 23:55:43 | haggis | 3 | 112716 | 589 | 12.046 | 9357.1 |
887 | 2023-12-26 04:55:58 | haggis | 1 | 48755 | 2 | 0.923 | 52822.3 |
886 | 2023-12-25 09:47:01 | haggis | 1 | 48755 | 2 | 0.876 | 55656.4 |
885 | 2023-12-24 17:10:54 | haggis | 2 | 82551 | 29 | 2.203 | 37472.1 |
884 | 2023-12-03 17:47:53 | haggis | 1 | 48755 | 2 | 0.843 | 57835.1 |
883 | 2023-12-03 17:47:52 | haggis | 1 | 48755 | 2 | 1.076 | 45311.3 |
882 | 2023-12-01 14:47:16 | haggis | 2 | 82551 | 29 | 2.250 | 36689.3 |
881 | 2023-11-27 08:51:34 | haggis | 3 | 112716 | 589 | 8.733 | 12906.9 |
880 | 2023-11-20 15:13:22 | haggis | 3 | 112716 | 589 | 4.796 | 23502.1 |
879 | 2023-11-19 12:01:17 | haggis | 1 | 48755 | 2 | 0.846 | 57630.0 |
878 | 2023-11-15 19:55:34 | haggis | 1 | 48755 | 2 | 0.906 | 53813.5 |
877 | 2023-11-12 19:58:21 | haggis | 3 | 112716 | 589 | 6.126 | 18399.6 |
876 | 2023-11-04 23:17:40 | haggis | 1 | 48755 | 2 | 0.813 | 59969.2 |
875 | 2023-11-04 04:00:33 | haggis | 1 | 48755 | 2 | 0.796 | 61250.0 |
874 | 2023-11-02 20:06:12 | haggis | 3 | 112716 | 589 | 6.393 | 17631.2 |
873 | 2023-10-22 02:50:40 | haggis | 2 | 82551 | 29 | 2.533 | 32590.2 |
872 | 2023-10-22 02:50:21 | haggis | 3 | 112716 | 589 | 5.063 | 22262.7 |
871 | 2023-10-17 00:23:03 | haggis | 1 | 48755 | 2 | 1.783 | 27344.4 |
870 | 2023-10-13 19:29:31 | haggis | 1 | 48755 | 2 | 0.796 | 61250.0 |
869 | 2023-10-13 15:00:36 | haggis | 1 | 48755 | 2 | 0.766 | 63648.8 |
868 | 2023-10-05 20:22:19 | haggis | 1 | 48755 | 2 | 0.733 | 66514.3 |
867 | 2023-09-26 19:02:44 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
866 | 2023-09-16 04:03:51 | haggis | 1 | 48755 | 2 | 1.703 | 28628.9 |
865 | 2023-09-02 22:07:34 | haggis | 1 | 48755 | 2 | 1.500 | 32503.3 |
864 | 2023-08-24 01:15:45 | haggis | 3 | 112716 | 589 | 4.736 | 23799.8 |
863 | 2023-08-20 12:30:01 | haggis | 3 | 112716 | 589 | 4.593 | 24540.8 |
862 | 2023-08-09 06:59:39 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
861 | 2023-06-11 19:27:10 | haggis | 3 | 112716 | 589 | 4.546 | 24794.5 |
860 | 2023-05-20 12:41:01 | haggis | 1 | 48755 | 2 | 0.763 | 63899.1 |
859 | 2023-05-09 23:48:57 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
858 | 2023-05-06 05:22:19 | haggis | 3 | 112716 | 589 | 4.640 | 24292.2 |
857 | 2023-03-06 11:33:35 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
856 | 2023-02-12 16:08:24 | haggis | 3 | 112716 | 589 | 5.173 | 21789.3 |
855 | 2023-02-07 07:24:55 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
854 | 2022-12-30 01:11:20 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
853 | 2022-11-23 05:38:59 | haggis | 3 | 112716 | 589 | 4.546 | 24794.5 |
852 | 2022-10-13 12:17:24 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
851 | 2022-09-18 21:54:20 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
850 | 2022-06-30 20:06:26 | haggis | 1 | 48755 | 2 | 0.736 | 66243.2 |
849 | 2022-05-02 11:37:15 | haggis | 1 | 48755 | 2 | 0.983 | 49598.2 |
848 | 2022-05-01 01:55:47 | haggis | 3 | 112716 | 589 | 5.076 | 22205.7 |
847 | 2022-03-13 23:52:36 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
846 | 2022-01-21 14:16:19 | haggis | 1 | 48755 | 2 | 0.843 | 57835.1 |
845 | 2021-11-29 13:52:45 | haggis | 1 | 48755 | 2 | 0.830 | 58741.0 |
844 | 2021-11-26 20:13:42 | haggis | 1 | 48755 | 2 | 0.826 | 59025.4 |
843 | 2021-08-20 13:36:46 | haggis | 1 | 48755 | 2 | 0.856 | 56956.8 |
842 | 2021-07-09 20:11:16 | haggis | 1 | 48755 | 2 | 0.766 | 63648.8 |
841 | 2021-06-22 17:35:31 | haggis | 1 | 48755 | 2 | 0.766 | 63648.8 |
840 | 2021-05-25 09:13:53 | haggis | 1 | 48755 | 2 | 0.813 | 59969.2 |
839 | 2021-05-19 22:31:08 | haggis | 1 | 48755 | 2 | 0.876 | 55656.4 |
838 | 2021-04-28 22:39:42 | haggis | 1 | 48755 | 2 | 0.860 | 56691.9 |
837 | 2021-04-04 21:28:35 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
836 | 2021-03-28 16:02:51 | haggis | 1 | 48755 | 2 | 0.846 | 57630.0 |
835 | 2021-02-17 02:51:56 | haggis | 1 | 48755 | 2 | 0.766 | 63648.8 |
834 | 2021-01-12 01:11:03 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
833 | 2020-11-12 20:07:57 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
832 | 2020-11-02 06:24:38 | haggis | 3 | 112716 | 589 | 5.643 | 19974.5 |
831 | 2020-10-31 10:02:41 | haggis | 1 | 48755 | 2 | 1.796 | 27146.4 |
830 | 2020-10-30 01:51:28 | haggis | 1 | 48755 | 2 | 0.953 | 51159.5 |
829 | 2020-10-28 00:33:21 | haggis | 1 | 48755 | 2 | 0.750 | 65006.7 |
828 | 2020-10-24 17:49:32 | haggis | 1 | 48755 | 2 | 0.813 | 59969.2 |
827 | 2020-10-23 17:25:51 | haggis | 1 | 48755 | 2 | 0.873 | 55847.7 |
826 | 2020-08-02 23:52:06 | haggis | 1 | 48755 | 2 | 0.796 | 61250.0 |
825 | 2020-05-04 16:37:19 | haggis | 1 | 48755 | 2 | 0.780 | 62506.4 |
824 | 2020-03-26 04:44:52 | haggis | 1 | 48755 | 2 | 0.893 | 54596.9 |
823 | 2020-03-26 00:02:31 | haggis | 1 | 48755 | 2 | 0.766 | 63648.8 |
822 | 2020-03-24 16:53:00 | haggis | 1 | 48755 | 2 | 0.843 | 57835.1 |
821 | 2020-03-23 07:16:27 | haggis | 1 | 48755 | 2 | 0.906 | 53813.5 |
820 | 2020-03-21 12:05:15 | haggis | 1 | 48755 | 2 | 0.780 | 62506.4 |
819 | 2020-03-18 07:52:03 | haggis | 1 | 48755 | 2 | 0.736 | 66243.2 |
818 | 2020-02-23 18:32:42 | haggis | 1 | 48755 | 2 | 1.733 | 28133.3 |
817 | 2020-02-21 03:17:55 | haggis | 1 | 48755 | 2 | 0.953 | 51159.5 |
816 | 2020-02-12 21:54:09 | haggis | 1 | 48755 | 2 | 0.953 | 51159.5 |
815 | 2020-02-06 21:10:05 | haggis | 1 | 48755 | 2 | 0.906 | 53813.5 |
814 | 2020-02-04 11:53:26 | haggis | 1 | 48755 | 2 | 1.780 | 27390.4 |
813 | 2020-02-02 10:53:38 | haggis | 1 | 48755 | 2 | 0.873 | 55847.7 |
812 | 2020-02-01 05:12:41 | haggis | 1 | 48755 | 2 | 1.906 | 25579.7 |
811 | 2020-02-01 02:53:34 | haggis | 1 | 48755 | 2 | 0.940 | 51867.0 |
810 | 2020-01-26 19:59:15 | haggis | 1 | 48755 | 2 | 1.673 | 29142.3 |
809 | 2020-01-22 03:18:33 | haggis | 1 | 48755 | 2 | 2.890 | 16870.2 |
808 | 2020-01-15 19:27:46 | haggis | 1 | 48755 | 2 | 0.923 | 52822.3 |
807 | 2020-01-14 11:17:52 | haggis | 1 | 48755 | 2 | 1.843 | 26454.2 |
806 | 2020-01-14 10:34:38 | haggis | 1 | 48755 | 2 | 0.940 | 51867.0 |
805 | 2020-01-12 00:57:16 | haggis | 1 | 48755 | 2 | 0.970 | 50262.9 |