History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subset"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
914 | 2024-04-27 04:23:46 | subset | 2 | 82551 | 38 | 4.063 | 20317.7 |
913 | 2024-04-26 05:00:10 | subset | 3 | 112716 | 519 | 9.080 | 12413.7 |
912 | 2024-04-25 22:11:44 | subset | 3 | 112716 | 519 | 11.706 | 9628.9 |
911 | 2024-04-22 16:29:11 | subset | 2 | 82551 | 38 | 3.016 | 27371.0 |
910 | 2024-04-22 16:29:08 | subset | 1 | 48755 | 7 | 1.046 | 46610.9 |
909 | 2024-04-22 16:28:44 | subset | 3 | 112716 | 519 | 5.970 | 18880.4 |
908 | 2024-04-21 01:10:54 | subset | 1 | 48755 | 7 | 2.093 | 23294.3 |
907 | 2024-04-20 22:17:37 | subset | 3 | 112716 | 519 | 16.890 | 6673.5 |
906 | 2024-04-19 22:38:40 | subset | 3 | 112716 | 519 | 10.660 | 10573.7 |
905 | 2024-04-18 18:29:30 | subset | 3 | 112716 | 519 | 7.626 | 14780.5 |
904 | 2024-04-12 11:49:17 | subset | 3 | 112716 | 519 | 16.250 | 6936.4 |
903 | 2024-04-11 20:33:20 | subset | 3 | 112716 | 519 | 18.140 | 6213.7 |
902 | 2024-04-10 13:55:01 | subset | 3 | 112716 | 519 | 11.250 | 10019.2 |
901 | 2024-04-09 23:02:23 | subset | 2 | 82551 | 38 | 5.360 | 15401.3 |
900 | 2024-04-09 23:02:02 | subset | 3 | 112716 | 519 | 5.690 | 19809.5 |
899 | 2024-04-09 17:32:39 | subset | 3 | 112716 | 519 | 13.300 | 8474.9 |
898 | 2024-04-08 16:52:55 | subset | 3 | 112716 | 519 | 17.643 | 6388.7 |
897 | 2024-04-01 00:44:40 | subset | 3 | 112716 | 519 | 25.253 | 4463.5 |
896 | 2024-03-31 17:57:12 | subset | 1 | 48755 | 7 | 1.296 | 37619.6 |
895 | 2024-03-30 09:45:33 | subset | 1 | 48755 | 7 | 2.016 | 24184.0 |
894 | 2024-03-29 22:25:35 | subset | 3 | 112716 | 519 | 11.576 | 9737.0 |
893 | 2024-03-28 18:00:12 | subset | 1 | 48755 | 7 | 0.923 | 52822.3 |
892 | 2024-03-26 18:53:46 | subset | 2 | 82551 | 38 | 2.640 | 31269.3 |
891 | 2024-03-26 18:53:01 | subset | 3 | 112716 | 519 | 5.000 | 22543.2 |
890 | 2024-03-23 07:06:39 | subset | 1 | 48755 | 7 | 1.013 | 48129.3 |
889 | 2024-03-23 07:06:13 | subset | 3 | 112716 | 519 | 6.250 | 18034.6 |
888 | 2024-03-23 07:06:12 | subset | 2 | 82551 | 38 | 2.780 | 29694.6 |
887 | 2024-03-08 22:48:28 | subset | 3 | 112716 | 519 | 9.750 | 11560.6 |
886 | 2024-03-08 09:09:43 | subset | 3 | 112716 | 519 | 14.423 | 7815.0 |
885 | 2024-03-07 00:51:09 | subset | 3 | 112716 | 519 | 4.783 | 23566.0 |
884 | 2024-03-04 07:25:33 | subset | 1 | 48755 | 7 | 2.733 | 17839.4 |
883 | 2024-02-21 21:35:54 | subset | 3 | 112716 | 519 | 4.953 | 22757.1 |
882 | 2024-02-21 21:35:53 | subset | 2 | 82551 | 38 | 2.360 | 34979.2 |
881 | 2024-02-18 08:17:20 | subset | 3 | 112716 | 519 | 31.020 | 3633.7 |
880 | 2024-02-18 06:03:06 | subset | 3 | 112716 | 519 | 14.186 | 7945.6 |
879 | 2024-02-17 03:42:18 | subset | 3 | 112716 | 519 | 12.906 | 8733.6 |
878 | 2024-02-16 18:16:28 | subset | 3 | 112716 | 519 | 5.766 | 19548.4 |
877 | 2024-02-03 06:08:47 | subset | 1 | 48755 | 7 | 1.156 | 42175.6 |
876 | 2024-01-24 18:44:42 | subset | 1 | 48755 | 7 | 0.750 | 65006.7 |
875 | 2024-01-10 06:59:19 | subset | 3 | 112716 | 519 | 4.720 | 23880.5 |
874 | 2024-01-08 19:43:44 | subset | 2 | 82551 | 38 | 2.593 | 31836.1 |
873 | 2023-12-15 22:48:52 | subset | 3 | 112716 | 519 | 5.393 | 20900.4 |
872 | 2023-11-22 09:02:12 | subset | 2 | 82551 | 38 | 2.203 | 37472.1 |
871 | 2023-11-20 11:15:30 | subset | 1 | 48755 | 7 | 0.826 | 59025.4 |
870 | 2023-11-19 04:42:47 | subset | 1 | 48755 | 7 | 0.750 | 65006.7 |
869 | 2023-11-15 09:43:09 | subset | 1 | 48755 | 7 | 0.906 | 53813.5 |
868 | 2023-11-12 23:54:30 | subset | 3 | 112716 | 519 | 5.596 | 20142.2 |
867 | 2023-11-11 03:14:11 | subset | 1 | 48755 | 7 | 0.766 | 63648.8 |
866 | 2023-11-09 11:07:05 | subset | 3 | 112716 | 519 | 4.576 | 24632.0 |
865 | 2023-11-07 10:23:41 | subset | 3 | 112716 | 519 | 5.940 | 18975.8 |
864 | 2023-11-06 09:55:14 | subset | 3 | 112716 | 519 | 9.860 | 11431.6 |
863 | 2023-11-05 20:34:27 | subset | 3 | 112716 | 519 | 4.750 | 23729.7 |
862 | 2023-11-05 20:15:33 | subset | 2 | 82551 | 38 | 2.546 | 32423.8 |
861 | 2023-11-05 20:15:32 | subset | 1 | 48755 | 7 | 0.873 | 55847.7 |
860 | 2023-11-05 10:00:35 | subset | 3 | 112716 | 519 | 5.326 | 21163.3 |
859 | 2023-11-04 20:29:35 | subset | 3 | 112716 | 519 | 5.393 | 20900.4 |
858 | 2023-11-04 09:45:29 | subset | 3 | 112716 | 519 | 4.750 | 23729.7 |
857 | 2023-11-03 20:23:09 | subset | 3 | 112716 | 519 | 5.796 | 19447.2 |
856 | 2023-11-03 10:15:28 | subset | 3 | 112716 | 519 | 6.250 | 18034.6 |
855 | 2023-11-02 21:27:56 | subset | 3 | 112716 | 519 | 5.263 | 21416.7 |
854 | 2023-11-02 09:57:45 | subset | 3 | 112716 | 519 | 5.953 | 18934.3 |
853 | 2023-11-01 21:45:56 | subset | 3 | 112716 | 519 | 5.093 | 22131.6 |
852 | 2023-11-01 13:40:57 | subset | 3 | 112716 | 519 | 7.456 | 15117.5 |
851 | 2023-11-01 13:14:40 | subset | 3 | 112716 | 519 | 4.653 | 24224.4 |
850 | 2023-10-31 18:55:41 | subset | 3 | 112716 | 519 | 5.826 | 19347.1 |
849 | 2023-10-30 23:47:45 | subset | 3 | 112716 | 519 | 6.436 | 17513.4 |
848 | 2023-10-30 19:02:10 | subset | 3 | 112716 | 519 | 5.533 | 20371.6 |
847 | 2023-10-30 12:51:53 | subset | 3 | 112716 | 519 | 5.466 | 20621.3 |
846 | 2023-10-29 12:44:35 | subset | 3 | 112716 | 519 | 5.610 | 20092.0 |
845 | 2023-10-28 13:25:46 | subset | 3 | 112716 | 519 | 5.903 | 19094.7 |
844 | 2023-10-27 13:51:53 | subset | 3 | 112716 | 519 | 4.796 | 23502.1 |
843 | 2023-10-26 18:46:58 | subset | 3 | 112716 | 519 | 5.000 | 22543.2 |
842 | 2023-10-26 12:53:34 | subset | 3 | 112716 | 519 | 12.516 | 9005.8 |
841 | 2023-10-26 11:28:21 | subset | 3 | 112716 | 519 | 4.983 | 22620.1 |
840 | 2023-10-25 18:46:18 | subset | 3 | 112716 | 519 | 5.893 | 19127.1 |
839 | 2023-10-25 12:54:47 | subset | 3 | 112716 | 519 | 5.220 | 21593.1 |
838 | 2023-10-24 20:41:37 | subset | 3 | 112716 | 519 | 5.766 | 19548.4 |
837 | 2023-10-24 18:43:43 | subset | 3 | 112716 | 519 | 5.593 | 20153.0 |
836 | 2023-10-24 13:05:44 | subset | 3 | 112716 | 519 | 4.700 | 23982.1 |
835 | 2023-10-24 11:55:41 | subset | 3 | 112716 | 519 | 5.890 | 19136.8 |
834 | 2023-10-23 18:40:41 | subset | 3 | 112716 | 519 | 5.813 | 19390.3 |
833 | 2023-10-23 12:34:07 | subset | 3 | 112716 | 519 | 5.546 | 20323.8 |
832 | 2023-10-22 20:08:46 | subset | 2 | 82551 | 38 | 2.780 | 29694.6 |
831 | 2023-10-22 19:55:35 | subset | 1 | 48755 | 7 | 0.906 | 53813.5 |
830 | 2023-10-22 18:49:09 | subset | 3 | 112716 | 519 | 6.360 | 17722.6 |
829 | 2023-10-22 12:26:52 | subset | 3 | 112716 | 519 | 5.860 | 19234.8 |
828 | 2023-10-21 21:26:50 | subset | 3 | 112716 | 519 | 5.750 | 19602.8 |
827 | 2023-10-21 20:29:36 | subset | 3 | 112716 | 519 | 4.970 | 22679.3 |
826 | 2023-10-21 12:33:43 | subset | 3 | 112716 | 519 | 6.093 | 18499.3 |
825 | 2023-10-20 20:38:03 | subset | 3 | 112716 | 519 | 4.610 | 24450.3 |
824 | 2023-10-20 12:26:14 | subset | 3 | 112716 | 519 | 5.610 | 20092.0 |
823 | 2023-10-19 16:57:40 | subset | 3 | 112716 | 519 | 6.516 | 17298.3 |
822 | 2023-10-19 14:37:26 | subset | 3 | 112716 | 519 | 8.250 | 13662.5 |
821 | 2023-10-19 11:03:34 | subset | 2 | 82551 | 38 | 2.576 | 32046.2 |
820 | 2023-10-19 01:50:24 | subset | 3 | 112716 | 519 | 5.873 | 19192.2 |
819 | 2023-10-18 14:14:28 | subset | 3 | 112716 | 519 | 5.280 | 21347.7 |
818 | 2023-10-18 00:30:20 | subset | 1 | 48755 | 7 | 0.796 | 61250.0 |
817 | 2023-10-18 00:01:22 | subset | 3 | 112716 | 519 | 4.766 | 23650.0 |
816 | 2023-10-17 15:10:18 | subset | 3 | 112716 | 519 | 5.013 | 22484.7 |
815 | 2023-10-17 14:01:07 | subset | 3 | 112716 | 519 | 5.000 | 22543.2 |