History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tony"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
939 | 2024-04-19 22:51:56 | tony | 1 | 13983 | 19 | 0.826 | 16928.6 |
938 | 2024-04-04 05:43:12 | tony | 1 | 13983 | 19 | 0.296 | 47239.9 |
937 | 2024-04-02 18:16:50 | tony | 1 | 13983 | 19 | 0.826 | 16928.6 |
936 | 2024-04-01 17:10:43 | tony | 2 | 29872 | 298 | 3.750 | 7965.9 |
935 | 2024-04-01 16:42:41 | tony | 1 | 13983 | 19 | 0.263 | 53167.3 |
934 | 2024-03-31 00:52:20 | tony | 2 | 29872 | 298 | 2.030 | 14715.3 |
933 | 2024-03-31 00:45:38 | tony | 2 | 29872 | 298 | 1.953 | 15295.4 |
932 | 2024-03-30 23:46:34 | tony | 1 | 13983 | 19 | 0.546 | 25609.9 |
931 | 2024-03-29 03:17:57 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
930 | 2024-03-02 17:04:10 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
929 | 2024-03-02 13:54:20 | tony | 1 | 13983 | 19 | 0.266 | 52567.7 |
928 | 2024-02-29 22:44:37 | tony | 1 | 13983 | 19 | 0.516 | 27098.8 |
927 | 2024-02-25 21:02:02 | tony | 2 | 29872 | 298 | 1.966 | 15194.3 |
926 | 2024-02-25 16:52:36 | tony | 1 | 13983 | 19 | 2.436 | 5740.1 |
925 | 2024-02-05 07:04:32 | tony | 1 | 13983 | 19 | 0.280 | 49939.3 |
924 | 2024-02-02 13:29:28 | tony | 2 | 29872 | 298 | 0.860 | 34734.9 |
923 | 2024-01-26 01:25:17 | tony | 1 | 13983 | 19 | 0.420 | 33292.9 |
922 | 2023-12-21 03:17:11 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
921 | 2023-12-10 09:56:37 | tony | 2 | 29872 | 298 | 0.826 | 36164.6 |
920 | 2023-12-04 16:04:52 | tony | 2 | 29872 | 298 | 0.876 | 34100.5 |
919 | 2023-11-18 17:59:38 | tony | 2 | 29872 | 298 | 0.766 | 38997.4 |
918 | 2023-11-11 15:19:38 | tony | 2 | 29872 | 298 | 0.860 | 34734.9 |
917 | 2023-11-11 05:31:50 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
916 | 2023-11-09 00:40:40 | tony | 1 | 13983 | 19 | 0.236 | 59250.0 |
915 | 2023-11-07 05:48:10 | tony | 1 | 13983 | 19 | 0.346 | 40413.3 |
914 | 2023-11-07 05:48:08 | tony | 1 | 13983 | 19 | 0.343 | 40766.8 |
913 | 2023-11-06 15:53:35 | tony | 1 | 13983 | 19 | 0.216 | 64736.1 |
912 | 2023-10-30 02:53:13 | tony | 2 | 29872 | 298 | 1.250 | 23897.6 |
911 | 2023-10-28 01:08:36 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
910 | 2023-10-20 19:07:24 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
909 | 2023-10-17 23:27:13 | tony | 1 | 13983 | 19 | 0.216 | 64736.1 |
908 | 2023-10-14 09:30:58 | tony | 2 | 29872 | 298 | 0.750 | 39829.3 |
907 | 2023-10-10 13:09:11 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
906 | 2023-10-10 03:24:16 | tony | 1 | 13983 | 19 | 0.216 | 64736.1 |
905 | 2023-10-08 21:54:20 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
904 | 2023-10-06 19:52:47 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
903 | 2023-10-04 09:11:13 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
902 | 2023-09-23 06:56:23 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
901 | 2023-09-12 15:40:30 | tony | 1 | 13983 | 19 | 0.266 | 52567.7 |
900 | 2023-08-15 07:26:09 | tony | 2 | 29872 | 298 | 1.013 | 29488.6 |
899 | 2023-08-04 23:59:46 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
898 | 2023-07-23 16:10:38 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
897 | 2023-06-10 02:10:42 | tony | 1 | 13983 | 19 | 0.216 | 64736.1 |
896 | 2023-06-06 19:04:34 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
895 | 2023-05-18 04:39:46 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
894 | 2023-05-01 03:07:01 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
893 | 2023-04-27 16:15:29 | tony | 2 | 29872 | 298 | 0.796 | 37527.6 |
892 | 2023-02-24 02:11:32 | tony | 1 | 13983 | 19 | 0.216 | 64736.1 |
891 | 2023-02-15 04:25:01 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
890 | 2023-02-11 19:01:44 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
889 | 2023-01-31 11:42:41 | tony | 2 | 29872 | 298 | 0.736 | 40587.0 |
888 | 2022-12-21 09:02:42 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
887 | 2022-11-12 21:11:34 | tony | 2 | 29872 | 298 | 0.843 | 35435.3 |
886 | 2022-10-25 07:25:08 | tony | 1 | 13983 | 19 | 0.216 | 64736.1 |
885 | 2022-09-05 08:42:28 | tony | 1 | 13983 | 19 | 0.216 | 64736.1 |
884 | 2022-08-16 00:32:49 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
883 | 2022-07-18 07:45:54 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
882 | 2022-07-10 10:25:57 | tony | 1 | 13983 | 19 | 0.216 | 64736.1 |
881 | 2022-07-05 15:18:37 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
880 | 2022-06-26 07:56:24 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
879 | 2022-06-25 15:34:04 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
878 | 2022-06-06 10:30:11 | tony | 2 | 29872 | 298 | 0.763 | 39150.7 |
877 | 2022-06-01 19:25:08 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
876 | 2022-05-10 10:08:02 | tony | 1 | 13983 | 19 | 0.310 | 45106.5 |
875 | 2022-05-08 06:22:52 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
874 | 2022-04-28 21:36:07 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
873 | 2022-04-26 21:06:51 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
872 | 2022-04-25 23:25:12 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
871 | 2022-04-23 22:11:23 | tony | 1 | 13983 | 19 | 0.236 | 59250.0 |
870 | 2022-04-22 21:46:41 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
869 | 2022-04-21 21:35:25 | tony | 1 | 13983 | 19 | 0.343 | 40766.8 |
868 | 2022-04-20 17:55:12 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
867 | 2022-04-19 20:00:23 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
866 | 2022-03-31 22:37:08 | tony | 1 | 13983 | 19 | 0.343 | 40766.8 |
865 | 2022-03-24 21:30:14 | tony | 1 | 13983 | 19 | 0.360 | 38841.7 |
864 | 2022-03-08 02:00:49 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
863 | 2022-02-24 16:07:39 | tony | 1 | 13983 | 19 | 0.686 | 20383.4 |
862 | 2022-02-24 03:02:57 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
861 | 2022-02-23 14:43:55 | tony | 1 | 13983 | 19 | 0.326 | 42892.6 |
860 | 2022-02-22 20:04:18 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
859 | 2022-02-22 05:47:10 | tony | 1 | 13983 | 19 | 0.296 | 47239.9 |
858 | 2022-02-22 01:28:16 | tony | 1 | 13983 | 19 | 0.296 | 47239.9 |
857 | 2022-02-21 03:31:17 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
856 | 2022-02-20 16:56:22 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
855 | 2022-02-20 06:06:41 | tony | 1 | 13983 | 19 | 0.500 | 27966.0 |
854 | 2022-02-19 18:05:37 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
853 | 2022-02-19 06:20:43 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
852 | 2022-02-18 23:39:44 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
851 | 2022-02-18 14:07:41 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
850 | 2022-02-18 01:59:01 | tony | 1 | 13983 | 19 | 0.263 | 53167.3 |
849 | 2022-02-17 14:23:04 | tony | 1 | 13983 | 19 | 0.326 | 42892.6 |
848 | 2022-02-16 21:09:28 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
847 | 2022-02-16 05:23:57 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
846 | 2022-02-15 11:53:00 | tony | 1 | 13983 | 19 | 0.233 | 60012.9 |
845 | 2022-02-14 19:15:08 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
844 | 2022-02-13 22:58:07 | tony | 1 | 13983 | 19 | 0.283 | 49409.9 |
843 | 2022-02-13 13:34:43 | tony | 1 | 13983 | 19 | 0.250 | 55932.0 |
842 | 2022-02-10 19:32:57 | tony | 1 | 13983 | 19 | 0.220 | 63559.1 |
841 | 2022-02-10 02:15:21 | tony | 1 | 13983 | 19 | 0.266 | 52567.7 |
840 | 2022-02-09 18:58:48 | tony | 1 | 13983 | 19 | 0.263 | 53167.3 |