History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bacilli"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
935 | 2024-05-31 23:45:33 | bacilli | 1 | 69583 | 1 | 4.753 | 14639.8 |
934 | 2024-05-30 16:41:21 | bacilli | 4 | 151207 | 1061 | 26.063 | 5801.6 |
933 | 2024-05-29 08:37:49 | bacilli | 4 | 151207 | 1061 | 48.616 | 3110.2 |
932 | 2024-05-29 04:23:16 | bacilli | 4 | 151207 | 1061 | 38.626 | 3914.6 |
931 | 2024-05-29 00:32:47 | bacilli | 4 | 151207 | 1061 | 60.463 | 2500.8 |
930 | 2024-05-29 00:25:28 | bacilli | 4 | 151207 | 1061 | 34.156 | 4427.0 |
929 | 2024-05-23 01:36:56 | bacilli | 4 | 151207 | 1061 | 20.783 | 7275.5 |
928 | 2024-05-11 10:35:28 | bacilli | 1 | 69583 | 1 | 4.343 | 16021.9 |
927 | 2024-05-02 01:40:52 | bacilli | 4 | 151207 | 1061 | 35.020 | 4317.7 |
926 | 2024-04-29 12:58:06 | bacilli | 4 | 151207 | 1061 | 22.046 | 6858.7 |
925 | 2024-04-28 22:36:00 | bacilli | 4 | 151207 | 1061 | 12.873 | 11746.1 |
924 | 2024-04-27 23:19:47 | bacilli | 4 | 151207 | 1061 | 35.000 | 4320.2 |
923 | 2024-04-27 21:58:07 | bacilli | 4 | 151207 | 1061 | 18.123 | 8343.4 |
922 | 2024-04-27 15:43:17 | bacilli | 1 | 69583 | 1 | 1.873 | 37150.6 |
921 | 2024-04-27 06:23:17 | bacilli | 4 | 151207 | 1061 | 39.250 | 3852.4 |
920 | 2024-04-09 10:57:44 | bacilli | 3 | 134027 | 89 | 28.063 | 4775.9 |
919 | 2024-04-07 12:52:33 | bacilli | 3 | 134027 | 89 | 24.936 | 5374.8 |
918 | 2024-04-05 02:27:09 | bacilli | 2 | 107671 | 5 | 3.876 | 27778.9 |
917 | 2024-04-05 02:27:04 | bacilli | 1 | 69583 | 1 | 1.296 | 53690.6 |
916 | 2024-04-05 02:26:49 | bacilli | 3 | 134027 | 89 | 9.343 | 14345.2 |
915 | 2024-04-04 16:18:40 | bacilli | 3 | 134027 | 89 | 14.343 | 9344.4 |
914 | 2024-04-03 05:29:40 | bacilli | 3 | 134027 | 89 | 15.876 | 8442.1 |
913 | 2024-04-02 22:18:43 | bacilli | 3 | 134027 | 89 | 20.236 | 6623.2 |
912 | 2024-04-02 04:29:30 | bacilli | 3 | 134027 | 89 | 5.830 | 22989.2 |
911 | 2024-03-29 12:04:59 | bacilli | 1 | 69583 | 1 | 2.720 | 25582.0 |
910 | 2024-03-28 14:14:12 | bacilli | 4 | 151207 | 1061 | 12.393 | 12201.0 |
909 | 2024-03-24 06:59:35 | bacilli | 4 | 151207 | 1061 | 28.470 | 5311.1 |
908 | 2024-03-09 19:11:26 | bacilli | 4 | 151207 | 1061 | 28.986 | 5216.6 |
907 | 2024-03-08 19:02:25 | bacilli | 4 | 151207 | 1061 | 46.220 | 3271.5 |
906 | 2024-03-07 03:19:25 | bacilli | 4 | 151207 | 1061 | 27.220 | 5555.0 |
905 | 2024-03-06 21:57:44 | bacilli | 4 | 151207 | 1061 | 30.706 | 4924.3 |
904 | 2024-03-06 08:49:14 | bacilli | 4 | 151207 | 1061 | 41.833 | 3614.5 |
903 | 2024-03-06 05:13:25 | bacilli | 4 | 151207 | 1061 | 25.580 | 5911.1 |
902 | 2024-03-06 05:03:12 | bacilli | 4 | 151207 | 1061 | 20.970 | 7210.6 |
901 | 2024-02-14 22:37:09 | bacilli | 1 | 69583 | 1 | 1.763 | 39468.5 |
900 | 2024-02-08 07:43:42 | bacilli | 4 | 151207 | 1061 | 37.033 | 4083.0 |
899 | 2024-02-07 13:43:04 | bacilli | 4 | 151207 | 1061 | 12.733 | 11875.2 |
898 | 2024-02-04 17:49:23 | bacilli | 1 | 69583 | 1 | 2.186 | 31831.2 |
897 | 2024-01-23 10:58:47 | bacilli | 4 | 151207 | 1061 | 38.410 | 3936.7 |
896 | 2024-01-23 07:51:39 | bacilli | 4 | 151207 | 1061 | 24.453 | 6183.6 |
895 | 2024-01-21 02:01:51 | bacilli | 1 | 69583 | 1 | 1.093 | 63662.4 |
894 | 2024-01-13 02:39:32 | bacilli | 4 | 151207 | 1061 | 13.046 | 11590.3 |
893 | 2024-01-12 02:09:40 | bacilli | 1 | 69583 | 1 | 1.220 | 57035.2 |
892 | 2024-01-10 11:42:58 | bacilli | 4 | 151207 | 1061 | 11.656 | 12972.5 |
891 | 2024-01-05 18:33:00 | bacilli | 4 | 151207 | 1061 | 10.826 | 13967.0 |
890 | 2024-01-04 14:32:54 | bacilli | 4 | 151207 | 1061 | 10.030 | 15075.5 |
889 | 2023-12-26 13:50:15 | bacilli | 4 | 151207 | 1061 | 9.860 | 15335.4 |
888 | 2023-12-25 23:27:01 | bacilli | 4 | 151207 | 1061 | 12.203 | 12391.0 |
887 | 2023-12-25 21:43:02 | bacilli | 4 | 151207 | 1061 | 12.110 | 12486.1 |
886 | 2023-12-13 10:57:11 | bacilli | 4 | 151207 | 1061 | 10.953 | 13805.1 |
885 | 2023-12-07 03:30:13 | bacilli | 3 | 134027 | 89 | 6.063 | 22105.7 |
884 | 2023-12-04 00:00:15 | bacilli | 1 | 69583 | 1 | 1.236 | 56296.9 |
883 | 2023-11-30 10:54:09 | bacilli | 1 | 69583 | 1 | 1.140 | 61037.7 |
882 | 2023-11-28 01:40:52 | bacilli | 1 | 69583 | 1 | 1.080 | 64428.7 |
881 | 2023-11-20 16:51:52 | bacilli | 4 | 151207 | 1061 | 27.093 | 5581.0 |
880 | 2023-11-15 11:42:12 | bacilli | 4 | 151207 | 1061 | 13.186 | 11467.2 |
879 | 2023-11-12 09:52:10 | bacilli | 4 | 151207 | 1061 | 10.766 | 14044.9 |
878 | 2023-11-07 21:13:11 | bacilli | 1 | 69583 | 1 | 1.080 | 64428.7 |
877 | 2023-11-02 20:10:36 | bacilli | 4 | 151207 | 1061 | 13.126 | 11519.7 |
876 | 2023-10-23 17:11:18 | bacilli | 4 | 151207 | 1061 | 12.673 | 11931.4 |
875 | 2023-09-22 09:30:47 | bacilli | 1 | 69583 | 1 | 1.123 | 61961.7 |
874 | 2023-09-13 03:43:54 | bacilli | 1 | 69583 | 1 | 1.250 | 55666.4 |
873 | 2023-09-06 12:01:51 | bacilli | 3 | 134027 | 89 | 5.813 | 23056.4 |
872 | 2023-08-14 12:55:59 | bacilli | 4 | 151207 | 1061 | 11.890 | 12717.2 |
871 | 2023-08-05 14:14:44 | bacilli | 4 | 151207 | 1061 | 11.173 | 13533.2 |
870 | 2023-07-30 22:27:50 | bacilli | 4 | 151207 | 1061 | 12.623 | 11978.7 |
869 | 2023-07-12 19:05:28 | bacilli | 1 | 69583 | 1 | 1.186 | 58670.3 |
868 | 2023-07-09 16:29:57 | bacilli | 4 | 151207 | 1061 | 10.080 | 15000.7 |
867 | 2023-07-08 09:26:33 | bacilli | 4 | 151207 | 1061 | 13.456 | 11237.1 |
866 | 2023-07-07 13:29:56 | bacilli | 4 | 151207 | 1061 | 10.800 | 14000.6 |
865 | 2023-07-06 15:32:09 | bacilli | 4 | 151207 | 1061 | 9.953 | 15192.1 |
864 | 2023-07-04 22:15:30 | bacilli | 4 | 151207 | 1061 | 11.266 | 13421.5 |
863 | 2023-07-02 21:51:44 | bacilli | 4 | 151207 | 1061 | 12.046 | 12552.5 |
862 | 2023-07-01 20:36:13 | bacilli | 4 | 151207 | 1061 | 11.093 | 13630.8 |
861 | 2023-06-30 22:06:59 | bacilli | 4 | 151207 | 1061 | 11.580 | 13057.6 |
860 | 2023-06-29 22:20:52 | bacilli | 4 | 151207 | 1061 | 10.610 | 14251.4 |
859 | 2023-06-27 22:15:12 | bacilli | 4 | 151207 | 1061 | 11.143 | 13569.7 |
858 | 2023-06-26 19:58:03 | bacilli | 1 | 69583 | 1 | 1.186 | 58670.3 |
857 | 2023-06-24 21:40:00 | bacilli | 4 | 151207 | 1061 | 15.936 | 9488.4 |
856 | 2023-06-22 21:30:38 | bacilli | 4 | 151207 | 1061 | 12.063 | 12534.8 |
855 | 2023-06-21 21:32:21 | bacilli | 4 | 151207 | 1061 | 12.516 | 12081.1 |
854 | 2023-06-20 22:31:14 | bacilli | 4 | 151207 | 1061 | 10.563 | 14314.8 |
853 | 2023-06-19 22:23:40 | bacilli | 4 | 151207 | 1061 | 10.686 | 14150.0 |
852 | 2023-06-18 21:38:09 | bacilli | 4 | 151207 | 1061 | 11.126 | 13590.4 |
851 | 2023-06-16 22:20:06 | bacilli | 4 | 151207 | 1061 | 10.940 | 13821.5 |
850 | 2023-06-15 13:50:12 | bacilli | 4 | 151207 | 1061 | 10.766 | 14044.9 |
849 | 2023-05-29 18:36:17 | bacilli | 3 | 134027 | 89 | 5.860 | 22871.5 |
848 | 2023-04-28 16:30:23 | bacilli | 4 | 151207 | 1061 | 11.843 | 12767.6 |
847 | 2023-04-10 07:38:23 | bacilli | 1 | 69583 | 1 | 1.063 | 65459.1 |
846 | 2023-03-25 02:37:41 | bacilli | 1 | 69583 | 1 | 1.186 | 58670.3 |
845 | 2023-03-05 14:57:52 | bacilli | 3 | 134027 | 89 | 5.703 | 23501.1 |
844 | 2023-02-02 23:04:23 | bacilli | 4 | 151207 | 1061 | 11.063 | 13667.8 |
843 | 2023-01-30 20:47:43 | bacilli | 1 | 69583 | 1 | 1.080 | 64428.7 |
842 | 2023-01-17 03:00:22 | bacilli | 4 | 151207 | 1061 | 10.923 | 13843.0 |
841 | 2023-01-15 21:23:33 | bacilli | 2 | 107671 | 5 | 2.800 | 38453.9 |
840 | 2023-01-07 23:54:11 | bacilli | 4 | 151207 | 1061 | 12.546 | 12052.2 |
839 | 2022-12-11 02:42:54 | bacilli | 4 | 151207 | 1061 | 11.283 | 13401.3 |
838 | 2022-12-10 03:23:52 | bacilli | 3 | 134027 | 89 | 5.830 | 22989.2 |
837 | 2022-12-07 06:18:31 | bacilli | 4 | 151207 | 1061 | 9.753 | 15503.6 |
836 | 2022-12-01 23:03:32 | bacilli | 2 | 107671 | 5 | 3.516 | 30623.2 |