History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"water"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
962 | 2024-04-29 08:34:00 | water | 1 | 28756 | 26 | 1.126 | 25538.2 |
961 | 2024-04-27 16:42:06 | water | 1 | 28756 | 26 | 0.593 | 48492.4 |
960 | 2024-04-21 08:24:48 | water | 1 | 28756 | 26 | 2.500 | 11502.4 |
959 | 2024-04-03 05:22:35 | water | 1 | 28756 | 26 | 1.686 | 17055.8 |
958 | 2024-04-03 05:22:18 | water | 2 | 53800 | 377 | 3.593 | 14973.6 |
957 | 2024-04-02 21:59:35 | water | 2 | 53800 | 377 | 1.873 | 28724.0 |
956 | 2024-04-02 21:58:43 | water | 1 | 28756 | 26 | 1.076 | 26724.9 |
955 | 2024-03-31 05:12:32 | water | 2 | 53800 | 377 | 3.860 | 13937.8 |
954 | 2024-03-31 04:07:42 | water | 1 | 28756 | 26 | 1.063 | 27051.7 |
953 | 2024-03-29 02:42:18 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
952 | 2024-03-03 20:47:04 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
951 | 2024-03-01 00:19:16 | water | 1 | 28756 | 26 | 0.983 | 29253.3 |
950 | 2024-02-29 11:44:22 | water | 1 | 28756 | 26 | 0.576 | 49923.6 |
949 | 2024-02-27 19:35:18 | water | 1 | 28756 | 26 | 1.076 | 26724.9 |
948 | 2024-01-28 05:07:26 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
947 | 2024-01-02 20:10:50 | water | 2 | 53800 | 377 | 1.513 | 35558.5 |
946 | 2023-12-30 20:37:05 | water | 1 | 28756 | 26 | 0.423 | 67981.1 |
945 | 2023-12-10 23:49:29 | water | 2 | 53800 | 377 | 1.360 | 39558.8 |
944 | 2023-12-09 01:13:57 | water | 2 | 53800 | 377 | 1.376 | 39098.8 |
943 | 2023-12-07 22:00:50 | water | 1 | 28756 | 26 | 0.513 | 56054.6 |
942 | 2023-12-07 22:00:49 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
941 | 2023-11-23 09:57:12 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
940 | 2023-11-20 17:19:21 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
939 | 2023-11-11 05:30:54 | water | 1 | 28756 | 26 | 0.456 | 63061.4 |
938 | 2023-11-11 00:37:54 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
937 | 2023-11-03 23:18:37 | water | 1 | 28756 | 26 | 0.606 | 47452.1 |
936 | 2023-10-23 09:06:24 | water | 1 | 28756 | 26 | 0.513 | 56054.6 |
935 | 2023-10-18 10:08:58 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
934 | 2023-10-15 13:09:33 | water | 1 | 28756 | 26 | 0.440 | 65354.5 |
933 | 2023-10-14 12:11:52 | water | 1 | 28756 | 26 | 0.440 | 65354.5 |
932 | 2023-10-13 04:32:16 | water | 2 | 53800 | 377 | 1.640 | 32804.9 |
931 | 2023-10-08 20:13:04 | water | 2 | 53800 | 377 | 1.373 | 39184.3 |
930 | 2023-10-04 13:32:53 | water | 1 | 28756 | 26 | 0.516 | 55728.7 |
929 | 2023-09-27 02:16:34 | water | 1 | 28756 | 26 | 0.453 | 63479.0 |
928 | 2023-09-23 22:46:16 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
927 | 2023-09-09 09:37:26 | water | 1 | 28756 | 26 | 0.466 | 61708.2 |
926 | 2023-08-15 08:40:25 | water | 1 | 28756 | 26 | 1.013 | 28387.0 |
925 | 2023-07-19 15:47:34 | water | 2 | 53800 | 377 | 1.360 | 39558.8 |
924 | 2023-06-20 13:17:53 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
923 | 2023-06-18 17:51:16 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
922 | 2023-05-28 17:26:40 | water | 1 | 28756 | 26 | 0.450 | 63902.2 |
921 | 2023-04-04 15:51:02 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
920 | 2023-04-03 12:19:48 | water | 2 | 53800 | 377 | 1.373 | 39184.3 |
919 | 2023-03-05 02:52:17 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
918 | 2023-03-01 16:08:23 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
917 | 2023-02-12 15:27:55 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
916 | 2023-01-18 09:12:08 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
915 | 2023-01-01 01:46:20 | water | 2 | 53800 | 377 | 1.356 | 39675.5 |
914 | 2022-12-24 17:51:51 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
913 | 2022-12-06 08:50:14 | water | 2 | 53800 | 377 | 1.716 | 31352.0 |
912 | 2022-11-21 03:59:19 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
911 | 2022-11-20 13:29:31 | water | 1 | 28756 | 26 | 0.440 | 65354.5 |
910 | 2022-11-18 19:05:19 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
909 | 2022-11-17 12:19:33 | water | 1 | 28756 | 26 | 0.596 | 48248.3 |
908 | 2022-11-16 08:22:59 | water | 1 | 28756 | 26 | 0.563 | 51076.4 |
907 | 2022-11-15 08:49:30 | water | 1 | 28756 | 26 | 0.486 | 59168.7 |
906 | 2022-11-14 18:49:53 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
905 | 2022-11-09 06:39:55 | water | 1 | 28756 | 26 | 0.423 | 67981.1 |
904 | 2022-11-05 21:01:04 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
903 | 2022-10-22 08:36:31 | water | 2 | 53800 | 377 | 1.360 | 39558.8 |
902 | 2022-09-19 20:58:17 | water | 1 | 28756 | 26 | 0.453 | 63479.0 |
901 | 2022-09-18 15:32:14 | water | 1 | 28756 | 26 | 0.486 | 59168.7 |
900 | 2022-09-17 18:00:16 | water | 1 | 28756 | 26 | 0.453 | 63479.0 |
899 | 2022-09-05 09:54:09 | water | 2 | 53800 | 377 | 1.373 | 39184.3 |
898 | 2022-08-31 02:33:12 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
897 | 2022-08-23 20:25:41 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
896 | 2022-08-23 00:23:33 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
895 | 2022-08-07 03:22:06 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
894 | 2022-07-30 04:08:48 | water | 1 | 28756 | 26 | 0.453 | 63479.0 |
893 | 2022-07-18 03:11:35 | water | 2 | 53800 | 377 | 1.406 | 38264.6 |
892 | 2022-07-17 19:27:39 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
891 | 2022-07-16 06:37:06 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
890 | 2022-07-11 14:49:15 | water | 2 | 53800 | 377 | 1.403 | 38346.4 |
889 | 2022-07-10 06:05:33 | water | 2 | 53800 | 377 | 1.373 | 39184.3 |
888 | 2022-07-06 03:54:55 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
887 | 2022-07-03 21:53:39 | water | 1 | 28756 | 26 | 0.516 | 55728.7 |
886 | 2022-07-03 11:18:56 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
885 | 2022-07-02 07:13:26 | water | 1 | 28756 | 26 | 0.453 | 63479.0 |
884 | 2022-06-26 06:35:12 | water | 2 | 53800 | 377 | 1.343 | 40059.6 |
883 | 2022-06-25 11:08:42 | water | 2 | 53800 | 377 | 1.390 | 38705.0 |
882 | 2022-06-16 11:18:27 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
881 | 2022-06-15 18:24:49 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
880 | 2022-06-08 13:10:35 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
879 | 2022-06-01 16:34:17 | water | 2 | 53800 | 377 | 1.530 | 35163.4 |
878 | 2022-06-01 09:36:05 | water | 1 | 28756 | 26 | 0.516 | 55728.7 |
877 | 2022-05-26 03:19:30 | water | 1 | 28756 | 26 | 0.466 | 61708.2 |
876 | 2022-05-25 14:25:27 | water | 1 | 28756 | 26 | 0.486 | 59168.7 |
875 | 2022-04-16 11:16:19 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
874 | 2022-04-15 18:12:31 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
873 | 2022-04-14 06:53:47 | water | 1 | 28756 | 26 | 0.716 | 40162.0 |
872 | 2022-04-13 05:10:54 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
871 | 2022-04-12 10:40:14 | water | 1 | 28756 | 26 | 0.703 | 40904.7 |
870 | 2022-04-11 15:38:46 | water | 1 | 28756 | 26 | 0.470 | 61183.0 |
869 | 2022-04-11 04:15:29 | water | 1 | 28756 | 26 | 0.436 | 65954.1 |
868 | 2022-04-10 15:09:53 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
867 | 2022-04-10 01:47:37 | water | 1 | 28756 | 26 | 0.500 | 57512.0 |
866 | 2022-04-09 14:02:00 | water | 1 | 28756 | 26 | 0.486 | 59168.7 |
865 | 2022-04-08 22:57:43 | water | 1 | 28756 | 26 | 0.513 | 56054.6 |
864 | 2022-03-31 10:47:24 | water | 1 | 28756 | 26 | 0.640 | 44931.3 |
863 | 2022-03-30 16:41:40 | water | 1 | 28756 | 26 | 0.626 | 45936.1 |