History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
941 | 2024-05-06 03:32:59 | scot | 2 | 29872 | 217 | 0.920 | 32469.6 |
940 | 2024-05-05 08:53:32 | scot | 2 | 29872 | 217 | 0.986 | 30296.1 |
939 | 2024-05-05 08:53:28 | scot | 1 | 13983 | 19 | 0.266 | 52567.7 |
938 | 2024-05-05 08:53:22 | scot | 2 | 29872 | 217 | 0.983 | 30388.6 |
937 | 2024-05-05 08:51:03 | scot | 2 | 29872 | 217 | 1.030 | 29001.9 |
936 | 2024-05-02 07:26:36 | scot | 1 | 13983 | 19 | 0.580 | 24108.6 |
935 | 2024-05-01 07:34:35 | scot | 1 | 13983 | 19 | 0.500 | 27966.0 |
934 | 2024-04-28 08:18:58 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
933 | 2024-04-24 20:44:32 | scot | 1 | 13983 | 19 | 0.466 | 30006.4 |
932 | 2024-04-20 12:30:47 | scot | 1 | 13983 | 19 | 0.263 | 53167.3 |
931 | 2024-04-03 00:24:44 | scot | 1 | 13983 | 19 | 0.860 | 16259.3 |
930 | 2024-04-01 16:14:22 | scot | 1 | 13983 | 19 | 0.766 | 18254.6 |
929 | 2024-04-01 07:22:38 | scot | 2 | 29872 | 217 | 1.000 | 29872.0 |
928 | 2024-04-01 07:02:39 | scot | 1 | 13983 | 19 | 0.343 | 40766.8 |
927 | 2024-03-26 23:36:19 | scot | 1 | 13983 | 19 | 0.483 | 28950.3 |
926 | 2024-03-03 19:47:35 | scot | 1 | 13983 | 19 | 0.216 | 64736.1 |
925 | 2024-03-02 18:34:39 | scot | 2 | 29872 | 217 | 2.093 | 14272.3 |
924 | 2024-03-02 13:36:17 | scot | 1 | 13983 | 19 | 0.280 | 49939.3 |
923 | 2024-03-02 01:18:12 | scot | 2 | 29872 | 217 | 0.970 | 30795.9 |
922 | 2024-03-02 01:18:11 | scot | 1 | 13983 | 19 | 0.513 | 27257.3 |
921 | 2024-02-27 16:30:00 | scot | 2 | 29872 | 217 | 0.893 | 33451.3 |
920 | 2024-02-25 21:10:39 | scot | 2 | 29872 | 217 | 2.046 | 14600.2 |
919 | 2024-02-25 21:04:35 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
918 | 2024-02-22 07:40:34 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
917 | 2024-02-06 04:37:51 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
916 | 2024-02-01 10:43:43 | scot | 1 | 13983 | 19 | 0.216 | 64736.1 |
915 | 2024-02-01 01:05:04 | scot | 2 | 29872 | 217 | 1.436 | 20802.2 |
914 | 2024-02-01 01:04:55 | scot | 1 | 13983 | 19 | 0.516 | 27098.8 |
913 | 2024-01-26 17:57:25 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
912 | 2024-01-01 22:46:09 | scot | 1 | 13983 | 19 | 0.236 | 59250.0 |
911 | 2023-12-19 16:14:24 | scot | 1 | 13983 | 19 | 0.203 | 68881.8 |
910 | 2023-12-07 06:03:45 | scot | 2 | 29872 | 217 | 0.826 | 36164.6 |
909 | 2023-12-03 07:35:21 | scot | 2 | 29872 | 217 | 0.720 | 41488.9 |
908 | 2023-11-28 09:07:35 | scot | 1 | 13983 | 19 | 0.236 | 59250.0 |
907 | 2023-11-25 21:11:47 | scot | 2 | 29872 | 217 | 0.876 | 34100.5 |
906 | 2023-11-24 14:03:46 | scot | 1 | 13983 | 19 | 0.220 | 63559.1 |
905 | 2023-11-20 00:43:00 | scot | 1 | 13983 | 19 | 0.236 | 59250.0 |
904 | 2023-11-18 04:50:43 | scot | 2 | 29872 | 217 | 0.736 | 40587.0 |
903 | 2023-11-12 17:06:12 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
902 | 2023-11-10 16:42:18 | scot | 1 | 13983 | 19 | 0.483 | 28950.3 |
901 | 2023-11-09 22:23:51 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
900 | 2023-10-27 22:47:01 | scot | 1 | 13983 | 19 | 0.453 | 30867.5 |
899 | 2023-10-26 14:26:50 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
898 | 2023-10-21 12:39:52 | scot | 2 | 29872 | 217 | 0.796 | 37527.6 |
897 | 2023-10-20 09:55:32 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
896 | 2023-10-20 03:18:11 | scot | 1 | 13983 | 19 | 0.236 | 59250.0 |
895 | 2023-10-16 23:52:41 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
894 | 2023-10-13 18:50:13 | scot | 1 | 13983 | 19 | 0.216 | 64736.1 |
893 | 2023-10-10 05:23:55 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
892 | 2023-10-06 21:48:18 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
891 | 2023-10-03 16:56:22 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
890 | 2023-09-25 16:23:11 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
889 | 2023-09-23 11:31:34 | scot | 1 | 13983 | 19 | 0.216 | 64736.1 |
888 | 2023-09-13 03:13:30 | scot | 1 | 13983 | 19 | 0.266 | 52567.7 |
887 | 2023-09-12 05:54:24 | scot | 1 | 13983 | 19 | 0.203 | 68881.8 |
886 | 2023-09-03 05:22:42 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
885 | 2023-06-28 08:40:47 | scot | 1 | 13983 | 19 | 0.216 | 64736.1 |
884 | 2023-06-19 22:27:53 | scot | 1 | 13983 | 19 | 0.216 | 64736.1 |
883 | 2023-04-09 13:33:27 | scot | 1 | 13983 | 19 | 0.220 | 63559.1 |
882 | 2023-03-04 10:11:37 | scot | 1 | 13983 | 19 | 0.220 | 63559.1 |
881 | 2023-01-28 20:49:35 | scot | 1 | 13983 | 19 | 0.200 | 69915.0 |
880 | 2022-11-26 01:25:43 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
879 | 2022-11-25 17:22:33 | scot | 1 | 13983 | 19 | 0.200 | 69915.0 |
878 | 2022-11-24 05:29:15 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
877 | 2022-11-22 10:11:46 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
876 | 2022-11-19 07:59:02 | scot | 1 | 13983 | 19 | 0.216 | 64736.1 |
875 | 2022-09-01 07:41:38 | scot | 1 | 13983 | 19 | 0.440 | 31779.5 |
874 | 2022-07-26 14:19:10 | scot | 1 | 13983 | 19 | 0.220 | 63559.1 |
873 | 2022-07-20 22:27:29 | scot | 1 | 13983 | 19 | 0.203 | 68881.8 |
872 | 2022-04-08 07:03:44 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
871 | 2022-04-07 08:47:53 | scot | 1 | 13983 | 19 | 0.326 | 42892.6 |
870 | 2022-04-06 05:52:05 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
869 | 2022-04-05 10:58:19 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
868 | 2022-04-04 08:26:23 | scot | 1 | 13983 | 19 | 0.236 | 59250.0 |
867 | 2022-04-03 14:32:22 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
866 | 2022-04-02 14:10:30 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
865 | 2022-04-01 07:07:30 | scot | 1 | 13983 | 19 | 0.533 | 26234.5 |
864 | 2022-03-28 15:13:01 | scot | 1 | 13983 | 19 | 0.266 | 52567.7 |
863 | 2022-03-25 18:36:38 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
862 | 2022-03-25 12:26:02 | scot | 1 | 13983 | 19 | 0.500 | 27966.0 |
861 | 2022-03-23 15:03:07 | scot | 1 | 13983 | 19 | 0.310 | 45106.5 |
860 | 2022-03-23 06:19:43 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
859 | 2022-03-22 19:11:52 | scot | 1 | 13983 | 19 | 0.263 | 53167.3 |
858 | 2022-03-14 00:58:12 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
857 | 2022-01-11 21:01:07 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
856 | 2021-12-20 01:26:32 | scot | 1 | 13983 | 19 | 0.220 | 63559.1 |
855 | 2021-12-17 12:52:27 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
854 | 2021-12-05 23:13:26 | scot | 1 | 13983 | 19 | 0.343 | 40766.8 |
853 | 2021-12-03 21:54:43 | scot | 1 | 13983 | 19 | 0.220 | 63559.1 |
852 | 2021-11-25 00:00:41 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
851 | 2021-11-24 15:38:15 | scot | 1 | 13983 | 19 | 0.236 | 59250.0 |
850 | 2021-11-24 05:05:55 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
849 | 2021-11-23 13:09:53 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |
848 | 2021-11-23 02:06:56 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
847 | 2021-11-22 17:15:36 | scot | 1 | 13983 | 19 | 0.250 | 55932.0 |
846 | 2021-11-22 00:25:30 | scot | 1 | 13983 | 19 | 0.236 | 59250.0 |
845 | 2021-11-21 00:38:31 | scot | 1 | 13983 | 19 | 0.236 | 59250.0 |
844 | 2021-11-20 01:04:53 | scot | 1 | 13983 | 19 | 0.220 | 63559.1 |
843 | 2021-11-20 00:42:11 | scot | 1 | 13983 | 19 | 0.216 | 64736.1 |
842 | 2021-11-18 15:18:22 | scot | 1 | 13983 | 19 | 0.233 | 60012.9 |