History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bill"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
970 | 2025-01-05 08:26:52 | bill | 2 | 29872 | 274 | 2.186 | 13665.1 |
969 | 2025-01-05 08:24:26 | bill | 1 | 13983 | 28 | 0.203 | 68881.8 |
968 | 2024-12-27 23:44:58 | bill | 2 | 29872 | 274 | 4.500 | 6638.2 |
967 | 2024-12-27 22:18:28 | bill | 2 | 29872 | 274 | 6.456 | 4627.0 |
966 | 2024-12-26 12:21:25 | bill | 1 | 13983 | 28 | 0.280 | 49939.3 |
965 | 2024-12-26 11:00:03 | bill | 2 | 29872 | 274 | 4.533 | 6589.9 |
964 | 2024-12-26 10:59:40 | bill | 1 | 13983 | 28 | 1.156 | 12096.0 |
963 | 2024-12-09 13:05:58 | bill | 1 | 13983 | 28 | 0.906 | 15433.8 |
962 | 2024-12-09 09:30:12 | bill | 2 | 29872 | 274 | 3.750 | 7965.9 |
961 | 2024-12-06 04:08:04 | bill | 2 | 29872 | 274 | 3.906 | 7647.7 |
960 | 2024-12-06 04:05:15 | bill | 1 | 13983 | 28 | 0.236 | 59250.0 |
959 | 2024-11-27 22:08:42 | bill | 2 | 29872 | 274 | 6.593 | 4530.9 |
958 | 2024-11-27 17:14:05 | bill | 2 | 29872 | 274 | 2.406 | 12415.6 |
957 | 2024-11-26 07:58:15 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
956 | 2024-11-26 05:26:37 | bill | 1 | 13983 | 28 | 1.796 | 7785.6 |
955 | 2024-11-09 06:42:22 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
954 | 2024-11-08 03:04:11 | bill | 2 | 29872 | 274 | 2.170 | 13765.9 |
953 | 2024-11-06 02:41:10 | bill | 2 | 29872 | 274 | 4.266 | 7002.3 |
952 | 2024-11-06 02:33:30 | bill | 1 | 13983 | 28 | 0.390 | 35853.8 |
951 | 2024-10-28 16:03:56 | bill | 2 | 29872 | 274 | 1.890 | 15805.3 |
950 | 2024-10-28 12:29:40 | bill | 2 | 29872 | 274 | 4.250 | 7028.7 |
949 | 2024-10-27 05:25:14 | bill | 1 | 13983 | 28 | 1.250 | 11186.4 |
948 | 2024-10-26 18:34:27 | bill | 1 | 13983 | 28 | 0.686 | 20383.4 |
947 | 2024-10-23 09:22:01 | bill | 1 | 13983 | 28 | 0.673 | 20777.1 |
946 | 2024-10-19 15:44:32 | bill | 1 | 13983 | 28 | 1.126 | 12418.3 |
945 | 2024-10-09 12:08:38 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
944 | 2024-10-07 02:38:21 | bill | 1 | 13983 | 28 | 1.236 | 11313.1 |
943 | 2024-09-28 06:49:51 | bill | 2 | 29872 | 274 | 4.123 | 7245.2 |
942 | 2024-09-27 05:16:15 | bill | 1 | 13983 | 28 | 2.470 | 5661.1 |
941 | 2024-09-26 14:59:18 | bill | 1 | 13983 | 28 | 1.313 | 10649.7 |
940 | 2024-09-09 21:42:38 | bill | 1 | 13983 | 28 | 1.970 | 7098.0 |
939 | 2024-09-09 08:25:55 | bill | 1 | 13983 | 28 | 2.170 | 6443.8 |
938 | 2024-09-06 20:53:15 | bill | 1 | 13983 | 28 | 1.406 | 9945.2 |
937 | 2024-08-30 02:21:00 | bill | 1 | 13983 | 28 | 3.033 | 4610.3 |
936 | 2024-08-27 23:06:20 | bill | 2 | 29872 | 274 | 6.093 | 4902.7 |
935 | 2024-08-27 18:58:46 | bill | 2 | 29872 | 274 | 6.203 | 4815.7 |
934 | 2024-08-27 18:45:27 | bill | 1 | 13983 | 28 | 0.656 | 21315.5 |
933 | 2024-08-27 06:10:05 | bill | 1 | 13983 | 28 | 0.923 | 15149.5 |
932 | 2024-08-10 00:21:50 | bill | 1 | 13983 | 28 | 0.280 | 49939.3 |
931 | 2024-08-07 19:52:50 | bill | 1 | 13983 | 28 | 1.733 | 8068.7 |
930 | 2024-08-02 05:06:31 | bill | 1 | 13983 | 28 | 0.936 | 14939.1 |
929 | 2024-07-29 17:04:15 | bill | 1 | 13983 | 28 | 1.220 | 11461.5 |
928 | 2024-07-29 00:02:04 | bill | 2 | 29872 | 274 | 4.123 | 7245.2 |
927 | 2024-07-28 21:02:24 | bill | 2 | 29872 | 274 | 2.843 | 10507.2 |
926 | 2024-07-28 17:27:11 | bill | 2 | 29872 | 274 | 1.360 | 21964.7 |
925 | 2024-07-28 14:39:05 | bill | 2 | 29872 | 274 | 3.156 | 9465.1 |
924 | 2024-07-28 14:36:50 | bill | 1 | 13983 | 28 | 1.373 | 10184.3 |
923 | 2024-07-28 11:41:30 | bill | 1 | 13983 | 28 | 0.780 | 17926.9 |
922 | 2024-07-28 00:28:14 | bill | 1 | 13983 | 28 | 1.016 | 13762.8 |
921 | 2024-07-10 21:07:21 | bill | 1 | 13983 | 28 | 0.673 | 20777.1 |
920 | 2024-07-05 05:29:05 | bill | 1 | 13983 | 28 | 1.626 | 8599.6 |
919 | 2024-07-05 05:25:18 | bill | 1 | 13983 | 28 | 0.513 | 27257.3 |
918 | 2024-07-03 05:51:25 | bill | 1 | 13983 | 28 | 1.436 | 9737.5 |
917 | 2024-06-30 21:23:32 | bill | 1 | 13983 | 28 | 0.860 | 16259.3 |
916 | 2024-06-30 20:33:20 | bill | 1 | 13983 | 28 | 1.046 | 13368.1 |
915 | 2024-06-30 14:21:53 | bill | 1 | 13983 | 28 | 0.563 | 24836.6 |
914 | 2024-06-28 09:21:22 | bill | 1 | 13983 | 28 | 1.203 | 11623.4 |
913 | 2024-06-27 17:50:02 | bill | 1 | 13983 | 28 | 0.903 | 15485.0 |
912 | 2024-06-13 03:41:36 | bill | 2 | 29872 | 274 | 3.250 | 9191.4 |
911 | 2024-06-13 03:38:31 | bill | 1 | 13983 | 28 | 0.670 | 20870.1 |
910 | 2024-06-10 02:37:36 | bill | 1 | 13983 | 28 | 1.220 | 11461.5 |
909 | 2024-06-05 23:03:13 | bill | 2 | 29872 | 274 | 0.923 | 32364.0 |
908 | 2024-06-04 07:09:28 | bill | 2 | 29872 | 274 | 2.000 | 14936.0 |
907 | 2024-06-04 07:09:24 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
906 | 2024-06-03 03:06:23 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
905 | 2024-06-01 00:28:29 | bill | 2 | 29872 | 274 | 5.046 | 5919.9 |
904 | 2024-05-31 21:37:29 | bill | 1 | 13983 | 28 | 0.236 | 59250.0 |
903 | 2024-05-29 11:04:08 | bill | 1 | 13983 | 28 | 0.810 | 17263.0 |
902 | 2024-05-29 11:03:58 | bill | 1 | 13983 | 28 | 0.783 | 17858.2 |
901 | 2024-05-29 08:30:37 | bill | 1 | 13983 | 28 | 0.283 | 49409.9 |
900 | 2024-05-20 13:40:50 | bill | 1 | 13983 | 28 | 0.300 | 46610.0 |
899 | 2024-05-05 06:29:23 | bill | 1 | 13983 | 28 | 0.530 | 26383.0 |
898 | 2024-05-04 00:26:26 | bill | 1 | 13983 | 28 | 0.563 | 24836.6 |
897 | 2024-05-02 00:39:23 | bill | 1 | 13983 | 28 | 0.263 | 53167.3 |
896 | 2024-04-28 01:46:05 | bill | 2 | 29872 | 274 | 0.923 | 32364.0 |
895 | 2024-04-05 05:45:16 | bill | 1 | 13983 | 28 | 0.280 | 49939.3 |
894 | 2024-04-01 16:10:49 | bill | 1 | 13983 | 28 | 0.280 | 49939.3 |
893 | 2024-03-30 19:51:30 | bill | 2 | 29872 | 274 | 2.046 | 14600.2 |
892 | 2024-03-28 19:05:34 | bill | 2 | 29872 | 274 | 2.406 | 12415.6 |
891 | 2024-03-28 17:55:46 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
890 | 2024-03-17 16:53:38 | bill | 1 | 13983 | 28 | 0.236 | 59250.0 |
889 | 2024-03-05 16:54:37 | bill | 1 | 13983 | 28 | 0.266 | 52567.7 |
888 | 2024-03-03 16:17:48 | bill | 2 | 29872 | 274 | 1.890 | 15805.3 |
887 | 2024-03-02 18:06:35 | bill | 2 | 29872 | 274 | 2.533 | 11793.1 |
886 | 2024-03-02 17:43:21 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
885 | 2024-03-02 13:25:57 | bill | 1 | 13983 | 28 | 0.546 | 25609.9 |
884 | 2024-02-29 12:59:42 | bill | 1 | 13983 | 28 | 0.266 | 52567.7 |
883 | 2024-02-26 08:43:05 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
882 | 2024-02-06 20:37:32 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
881 | 2024-02-04 16:45:06 | bill | 2 | 29872 | 274 | 1.016 | 29401.6 |
880 | 2024-02-04 12:43:21 | bill | 2 | 29872 | 274 | 2.000 | 14936.0 |
879 | 2024-02-04 12:13:42 | bill | 1 | 13983 | 28 | 0.266 | 52567.7 |
878 | 2024-01-27 06:48:41 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
877 | 2024-01-22 02:51:42 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
876 | 2024-01-05 01:10:28 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
875 | 2023-12-17 20:42:07 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
874 | 2023-12-17 10:59:40 | bill | 2 | 29872 | 274 | 0.733 | 40753.1 |
873 | 2023-12-16 07:51:55 | bill | 2 | 29872 | 274 | 0.766 | 38997.4 |
872 | 2023-12-10 13:47:03 | bill | 2 | 29872 | 274 | 0.733 | 40753.1 |
871 | 2023-12-10 12:36:11 | bill | 1 | 13983 | 28 | 0.203 | 68881.8 |