History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hockey"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
921 | 2024-04-28 00:40:48 | hockey | 1 | 48755 | 9 | 1.720 | 28345.9 |
920 | 2024-04-22 19:56:47 | hockey | 1 | 48755 | 9 | 0.813 | 59969.2 |
919 | 2024-03-31 11:11:12 | hockey | 1 | 48755 | 9 | 1.343 | 36303.1 |
918 | 2024-03-07 23:33:23 | hockey | 1 | 48755 | 9 | 0.830 | 58741.0 |
917 | 2024-03-02 02:54:46 | hockey | 3 | 112716 | 678 | 13.860 | 8132.5 |
916 | 2024-02-28 05:07:09 | hockey | 2 | 82551 | 83 | 8.250 | 10006.2 |
915 | 2024-02-28 04:59:58 | hockey | 1 | 48755 | 9 | 2.673 | 18239.8 |
914 | 2024-02-28 04:49:09 | hockey | 3 | 112716 | 678 | 21.020 | 5362.3 |
913 | 2024-02-27 18:52:35 | hockey | 3 | 112716 | 678 | 5.170 | 21801.9 |
912 | 2024-02-27 18:52:36 | hockey | 2 | 82551 | 83 | 2.453 | 33653.1 |
911 | 2024-02-27 18:52:34 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
910 | 2024-01-27 15:06:00 | hockey | 2 | 82551 | 83 | 2.453 | 33653.1 |
909 | 2024-01-05 16:47:16 | hockey | 3 | 112716 | 678 | 10.016 | 11253.6 |
908 | 2023-12-28 08:17:35 | hockey | 3 | 112716 | 678 | 4.673 | 24120.7 |
907 | 2023-12-24 20:50:04 | hockey | 3 | 112716 | 678 | 5.970 | 18880.4 |
906 | 2023-12-14 21:17:20 | hockey | 1 | 48755 | 9 | 1.500 | 32503.3 |
905 | 2023-11-30 15:05:02 | hockey | 3 | 112716 | 678 | 4.873 | 23130.7 |
904 | 2023-11-24 00:52:18 | hockey | 2 | 82551 | 83 | 2.190 | 37694.5 |
903 | 2023-11-21 17:48:23 | hockey | 2 | 82551 | 83 | 2.440 | 33832.4 |
902 | 2023-11-17 22:00:22 | hockey | 1 | 48755 | 9 | 0.876 | 55656.4 |
901 | 2023-11-17 19:50:58 | hockey | 1 | 48755 | 9 | 0.810 | 60191.4 |
900 | 2023-11-15 22:43:48 | hockey | 1 | 48755 | 9 | 0.860 | 56691.9 |
899 | 2023-11-15 11:45:13 | hockey | 2 | 82551 | 83 | 5.173 | 15958.1 |
898 | 2023-11-13 12:25:19 | hockey | 3 | 112716 | 678 | 5.283 | 21335.6 |
897 | 2023-11-10 03:06:07 | hockey | 1 | 48755 | 9 | 0.810 | 60191.4 |
896 | 2023-11-07 00:57:51 | hockey | 2 | 82551 | 83 | 2.436 | 33887.9 |
895 | 2023-10-26 18:42:51 | hockey | 3 | 112716 | 678 | 5.220 | 21593.1 |
894 | 2023-10-21 21:26:18 | hockey | 1 | 48755 | 9 | 0.810 | 60191.4 |
893 | 2023-10-18 23:55:56 | hockey | 1 | 48755 | 9 | 0.843 | 57835.1 |
892 | 2023-10-17 09:20:48 | hockey | 3 | 112716 | 678 | 5.690 | 19809.5 |
891 | 2023-10-11 07:25:41 | hockey | 1 | 48755 | 9 | 0.826 | 59025.4 |
890 | 2023-10-05 05:42:17 | hockey | 1 | 48755 | 9 | 0.763 | 63899.1 |
889 | 2023-10-04 06:32:33 | hockey | 3 | 112716 | 678 | 5.376 | 20966.5 |
888 | 2023-10-01 08:35:32 | hockey | 1 | 48755 | 9 | 0.736 | 66243.2 |
887 | 2023-10-01 04:22:08 | hockey | 3 | 112716 | 678 | 5.656 | 19928.6 |
886 | 2023-09-29 13:34:13 | hockey | 1 | 48755 | 9 | 0.860 | 56691.9 |
885 | 2023-09-29 05:54:13 | hockey | 3 | 112716 | 678 | 4.873 | 23130.7 |
884 | 2023-09-14 02:41:29 | hockey | 1 | 48755 | 9 | 0.843 | 57835.1 |
883 | 2023-08-11 09:16:42 | hockey | 2 | 82551 | 83 | 2.373 | 34787.6 |
882 | 2023-07-31 19:44:22 | hockey | 1 | 48755 | 9 | 0.826 | 59025.4 |
881 | 2023-07-28 12:27:30 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
880 | 2023-07-10 18:25:28 | hockey | 3 | 112716 | 678 | 5.453 | 20670.5 |
879 | 2023-05-13 08:32:12 | hockey | 1 | 48755 | 9 | 0.766 | 63648.8 |
878 | 2023-04-27 05:14:29 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
877 | 2023-04-24 03:52:23 | hockey | 2 | 82551 | 83 | 2.440 | 33832.4 |
876 | 2023-04-23 10:39:41 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
875 | 2023-04-04 03:23:04 | hockey | 1 | 48755 | 9 | 0.843 | 57835.1 |
874 | 2023-03-23 10:49:06 | hockey | 3 | 112716 | 678 | 5.703 | 19764.3 |
873 | 2023-02-16 19:37:23 | hockey | 1 | 48755 | 9 | 0.810 | 60191.4 |
872 | 2023-01-27 04:45:51 | hockey | 2 | 82551 | 83 | 2.163 | 38165.0 |
871 | 2023-01-18 11:54:58 | hockey | 1 | 48755 | 9 | 0.736 | 66243.2 |
870 | 2022-12-22 12:45:50 | hockey | 3 | 112716 | 678 | 5.406 | 20850.2 |
869 | 2022-12-15 21:07:30 | hockey | 1 | 48755 | 9 | 0.796 | 61250.0 |
868 | 2022-11-08 11:59:30 | hockey | 2 | 82551 | 83 | 2.360 | 34979.2 |
867 | 2022-10-04 09:48:00 | hockey | 1 | 48755 | 9 | 0.733 | 66514.3 |
866 | 2022-09-19 15:08:50 | hockey | 1 | 48755 | 9 | 0.796 | 61250.0 |
865 | 2022-09-18 11:22:11 | hockey | 1 | 48755 | 9 | 0.733 | 66514.3 |
864 | 2022-09-12 00:52:29 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
863 | 2022-09-09 11:10:36 | hockey | 1 | 48755 | 9 | 0.733 | 66514.3 |
862 | 2022-09-03 16:51:32 | hockey | 1 | 48755 | 9 | 0.733 | 66514.3 |
861 | 2022-09-02 00:53:11 | hockey | 2 | 82551 | 83 | 2.110 | 39123.7 |
860 | 2022-08-31 01:03:15 | hockey | 1 | 48755 | 9 | 0.716 | 68093.6 |
859 | 2022-08-26 01:22:50 | hockey | 1 | 48755 | 9 | 0.766 | 63648.8 |
858 | 2022-08-25 16:47:53 | hockey | 2 | 82551 | 83 | 2.126 | 38829.3 |
857 | 2022-08-24 21:04:07 | hockey | 1 | 48755 | 9 | 0.780 | 62506.4 |
856 | 2022-08-17 00:47:26 | hockey | 3 | 112716 | 678 | 4.766 | 23650.0 |
855 | 2022-08-15 02:27:43 | hockey | 2 | 82551 | 83 | 2.373 | 34787.6 |
854 | 2022-08-07 22:07:41 | hockey | 2 | 82551 | 83 | 2.076 | 39764.5 |
853 | 2022-08-06 18:14:03 | hockey | 2 | 82551 | 83 | 2.106 | 39198.0 |
852 | 2022-08-06 18:02:29 | hockey | 1 | 48755 | 9 | 0.766 | 63648.8 |
851 | 2022-08-06 05:23:44 | hockey | 1 | 48755 | 9 | 0.813 | 59969.2 |
850 | 2022-07-29 23:05:07 | hockey | 1 | 48755 | 9 | 0.873 | 55847.7 |
849 | 2022-07-29 10:59:00 | hockey | 2 | 82551 | 83 | 2.580 | 31996.5 |
848 | 2022-07-10 03:01:20 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
847 | 2022-07-03 06:10:52 | hockey | 1 | 48755 | 9 | 0.843 | 57835.1 |
846 | 2022-07-02 14:58:15 | hockey | 1 | 48755 | 9 | 0.733 | 66514.3 |
845 | 2022-06-25 17:02:26 | hockey | 1 | 48755 | 9 | 0.986 | 49447.3 |
844 | 2022-06-21 06:49:06 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
843 | 2022-06-16 06:15:00 | hockey | 1 | 48755 | 9 | 0.876 | 55656.4 |
842 | 2022-06-10 10:50:12 | hockey | 2 | 82551 | 83 | 2.513 | 32849.6 |
841 | 2022-04-08 09:34:00 | hockey | 1 | 48755 | 9 | 0.860 | 56691.9 |
840 | 2022-03-13 00:34:01 | hockey | 3 | 112716 | 678 | 4.750 | 23729.7 |
839 | 2022-03-05 12:10:02 | hockey | 1 | 48755 | 9 | 0.843 | 57835.1 |
838 | 2022-01-07 20:53:53 | hockey | 1 | 48755 | 9 | 0.843 | 57835.1 |
837 | 2021-12-21 17:24:01 | hockey | 1 | 48755 | 9 | 1.123 | 43415.0 |
836 | 2021-11-25 04:39:44 | hockey | 1 | 48755 | 9 | 0.780 | 62506.4 |
835 | 2021-11-21 18:04:41 | hockey | 1 | 48755 | 9 | 1.170 | 41670.9 |
834 | 2021-11-19 01:22:35 | hockey | 1 | 48755 | 9 | 0.860 | 56691.9 |
833 | 2021-11-12 06:16:53 | hockey | 1 | 48755 | 9 | 0.783 | 62266.9 |
832 | 2021-09-29 21:32:49 | hockey | 1 | 48755 | 9 | 0.890 | 54780.9 |
831 | 2021-08-26 04:24:28 | hockey | 1 | 48755 | 9 | 0.843 | 57835.1 |
830 | 2021-08-24 00:32:54 | hockey | 1 | 48755 | 9 | 0.843 | 57835.1 |
829 | 2021-08-18 21:23:26 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
828 | 2021-05-23 01:43:31 | hockey | 1 | 48755 | 9 | 0.923 | 52822.3 |
827 | 2021-05-18 04:28:28 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
826 | 2021-04-27 05:57:40 | hockey | 1 | 48755 | 9 | 0.760 | 64151.3 |
825 | 2021-04-24 06:19:19 | hockey | 1 | 48755 | 9 | 0.860 | 56691.9 |
824 | 2021-04-06 10:40:53 | hockey | 1 | 48755 | 9 | 0.826 | 59025.4 |
823 | 2021-03-26 05:18:22 | hockey | 1 | 48755 | 9 | 0.750 | 65006.7 |
822 | 2021-02-20 06:09:12 | hockey | 1 | 48755 | 9 | 0.903 | 53992.2 |