History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"idiot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
975 | 2024-04-28 04:17:14 | idiot | 1 | 28756 | 3 | 0.516 | 55728.7 |
974 | 2024-04-26 19:05:01 | idiot | 1 | 28756 | 3 | 0.516 | 55728.7 |
973 | 2024-04-26 05:48:29 | idiot | 2 | 53800 | 27 | 1.716 | 31352.0 |
972 | 2024-04-06 05:56:42 | idiot | 1 | 28756 | 3 | 0.483 | 59536.2 |
971 | 2024-03-31 15:04:29 | idiot | 1 | 28756 | 3 | 0.563 | 51076.4 |
970 | 2024-03-29 11:10:15 | idiot | 2 | 53800 | 27 | 1.783 | 30173.9 |
969 | 2024-03-29 11:09:51 | idiot | 3 | 83667 | 588 | 4.720 | 17726.1 |
968 | 2024-03-29 09:00:59 | idiot | 3 | 83667 | 588 | 12.050 | 6943.3 |
967 | 2024-03-29 09:00:56 | idiot | 2 | 53800 | 27 | 1.830 | 29398.9 |
966 | 2024-03-29 08:58:46 | idiot | 1 | 28756 | 3 | 0.483 | 59536.2 |
965 | 2024-03-29 08:05:05 | idiot | 1 | 28756 | 3 | 1.296 | 22188.3 |
964 | 2024-03-07 05:40:34 | idiot | 3 | 83667 | 588 | 4.093 | 20441.5 |
963 | 2024-03-07 05:40:35 | idiot | 2 | 53800 | 27 | 1.733 | 31044.4 |
962 | 2024-03-07 04:52:13 | idiot | 1 | 28756 | 3 | 0.420 | 68466.7 |
961 | 2024-03-01 11:43:19 | idiot | 1 | 28756 | 3 | 0.470 | 61183.0 |
960 | 2024-02-28 02:28:17 | idiot | 1 | 28756 | 3 | 0.423 | 67981.1 |
959 | 2024-02-03 23:40:23 | idiot | 1 | 28756 | 3 | 0.453 | 63479.0 |
958 | 2024-01-29 09:58:35 | idiot | 1 | 28756 | 3 | 0.500 | 57512.0 |
957 | 2024-01-29 02:24:33 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
956 | 2024-01-19 07:46:23 | idiot | 1 | 28756 | 3 | 0.483 | 59536.2 |
955 | 2024-01-16 01:26:22 | idiot | 2 | 53800 | 27 | 1.360 | 39558.8 |
954 | 2024-01-16 01:26:18 | idiot | 3 | 83667 | 588 | 3.266 | 25617.6 |
953 | 2023-12-20 21:55:58 | idiot | 3 | 83667 | 588 | 5.593 | 14959.2 |
952 | 2023-12-20 21:55:55 | idiot | 2 | 53800 | 27 | 1.610 | 33416.1 |
951 | 2023-12-19 22:52:03 | idiot | 2 | 53800 | 27 | 2.796 | 19241.8 |
950 | 2023-11-28 01:19:52 | idiot | 3 | 83667 | 588 | 3.266 | 25617.6 |
949 | 2023-11-23 21:45:00 | idiot | 3 | 83667 | 588 | 4.063 | 20592.4 |
948 | 2023-11-23 21:45:01 | idiot | 2 | 53800 | 27 | 1.703 | 31591.3 |
947 | 2023-11-17 15:50:31 | idiot | 1 | 28756 | 3 | 0.483 | 59536.2 |
946 | 2023-11-15 04:21:54 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
945 | 2023-11-12 02:49:28 | idiot | 1 | 28756 | 3 | 0.453 | 63479.0 |
944 | 2023-11-05 18:02:39 | idiot | 3 | 83667 | 588 | 3.360 | 24900.9 |
943 | 2023-11-05 18:02:37 | idiot | 2 | 53800 | 27 | 1.343 | 40059.6 |
942 | 2023-11-05 17:18:31 | idiot | 1 | 28756 | 3 | 0.486 | 59168.7 |
941 | 2023-11-04 01:42:23 | idiot | 1 | 28756 | 3 | 0.486 | 59168.7 |
940 | 2023-10-21 21:54:08 | idiot | 1 | 28756 | 3 | 0.453 | 63479.0 |
939 | 2023-10-21 00:59:05 | idiot | 1 | 28756 | 3 | 0.483 | 59536.2 |
938 | 2023-10-18 17:22:00 | idiot | 1 | 28756 | 3 | 0.593 | 48492.4 |
937 | 2023-10-11 04:57:24 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
936 | 2023-10-05 14:23:49 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
935 | 2023-09-29 08:58:59 | idiot | 1 | 28756 | 3 | 0.483 | 59536.2 |
934 | 2023-09-22 20:16:47 | idiot | 2 | 53800 | 27 | 2.390 | 22510.5 |
933 | 2023-09-17 23:44:44 | idiot | 2 | 53800 | 27 | 1.656 | 32487.9 |
932 | 2023-09-14 16:00:11 | idiot | 1 | 28756 | 3 | 0.500 | 57512.0 |
931 | 2023-09-02 16:01:43 | idiot | 1 | 28756 | 3 | 0.860 | 33437.2 |
930 | 2023-07-04 03:45:11 | idiot | 1 | 28756 | 3 | 0.470 | 61183.0 |
929 | 2023-06-13 00:19:32 | idiot | 2 | 53800 | 27 | 1.610 | 33416.1 |
928 | 2023-06-06 14:01:42 | idiot | 1 | 28756 | 3 | 0.470 | 61183.0 |
927 | 2023-03-26 06:54:58 | idiot | 1 | 28756 | 3 | 0.420 | 68466.7 |
926 | 2023-03-14 05:51:50 | idiot | 1 | 28756 | 3 | 0.453 | 63479.0 |
925 | 2023-03-13 16:07:51 | idiot | 2 | 53800 | 27 | 1.326 | 40573.2 |
924 | 2023-03-10 22:03:02 | idiot | 1 | 28756 | 3 | 0.533 | 53951.2 |
923 | 2023-01-10 09:13:26 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
922 | 2022-12-17 17:36:39 | idiot | 2 | 53800 | 27 | 3.050 | 17639.3 |
921 | 2022-11-19 05:38:48 | idiot | 1 | 28756 | 3 | 0.420 | 68466.7 |
920 | 2022-10-20 18:03:26 | idiot | 1 | 28756 | 3 | 0.420 | 68466.7 |
919 | 2022-09-01 01:36:57 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
918 | 2022-08-09 22:23:56 | idiot | 2 | 53800 | 27 | 1.343 | 40059.6 |
917 | 2022-08-07 15:13:58 | idiot | 2 | 53800 | 27 | 1.360 | 39558.8 |
916 | 2022-07-26 11:14:50 | idiot | 1 | 28756 | 3 | 0.453 | 63479.0 |
915 | 2022-07-22 19:12:30 | idiot | 1 | 28756 | 3 | 0.420 | 68466.7 |
914 | 2022-06-11 09:51:08 | idiot | 1 | 28756 | 3 | 0.440 | 65354.5 |
913 | 2022-06-09 04:18:26 | idiot | 1 | 28756 | 3 | 0.470 | 61183.0 |
912 | 2022-03-25 02:26:23 | idiot | 1 | 28756 | 3 | 0.516 | 55728.7 |
911 | 2022-03-21 17:16:00 | idiot | 2 | 53800 | 27 | 1.593 | 33772.8 |
910 | 2022-03-01 18:40:13 | idiot | 1 | 28756 | 3 | 0.560 | 51350.0 |
909 | 2021-12-07 18:22:52 | idiot | 1 | 28756 | 3 | 0.440 | 65354.5 |
908 | 2021-08-28 02:32:54 | idiot | 1 | 28756 | 3 | 0.470 | 61183.0 |
907 | 2021-07-09 16:34:52 | idiot | 3 | 83667 | 588 | 3.296 | 25384.4 |
906 | 2021-05-27 08:20:31 | idiot | 1 | 28756 | 3 | 0.440 | 65354.5 |
905 | 2021-05-26 21:42:52 | idiot | 3 | 83667 | 588 | 3.703 | 22594.4 |
904 | 2021-05-20 03:57:00 | idiot | 1 | 28756 | 3 | 0.533 | 53951.2 |
903 | 2021-05-11 21:22:33 | idiot | 3 | 83667 | 588 | 3.220 | 25983.5 |
902 | 2021-04-20 08:12:20 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
901 | 2021-03-23 01:27:41 | idiot | 1 | 28756 | 3 | 0.440 | 65354.5 |
900 | 2021-02-24 08:58:05 | idiot | 1 | 28756 | 3 | 0.440 | 65354.5 |
899 | 2021-02-22 01:08:09 | idiot | 1 | 28756 | 3 | 0.500 | 57512.0 |
898 | 2021-01-15 20:23:10 | idiot | 3 | 83667 | 588 | 3.860 | 21675.4 |
897 | 2021-01-05 03:02:15 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
896 | 2020-12-07 22:21:59 | idiot | 1 | 28756 | 3 | 0.486 | 59168.7 |
895 | 2020-11-19 06:52:14 | idiot | 1 | 28756 | 3 | 0.483 | 59536.2 |
894 | 2020-11-18 22:42:37 | idiot | 1 | 28756 | 3 | 0.440 | 65354.5 |
893 | 2020-11-07 13:59:19 | idiot | 3 | 83667 | 588 | 3.876 | 21585.9 |
892 | 2020-10-26 15:27:21 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
891 | 2020-10-22 13:28:26 | idiot | 1 | 28756 | 3 | 0.466 | 61708.2 |
890 | 2020-10-22 04:17:40 | idiot | 1 | 28756 | 3 | 0.500 | 57512.0 |
889 | 2020-10-16 03:06:49 | idiot | 3 | 83667 | 588 | 3.296 | 25384.4 |
888 | 2020-09-12 18:58:29 | idiot | 1 | 28756 | 3 | 0.453 | 63479.0 |
887 | 2020-08-23 11:30:16 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
886 | 2020-08-06 20:25:44 | idiot | 1 | 28756 | 3 | 0.436 | 65954.1 |
885 | 2020-07-24 09:15:13 | idiot | 1 | 28756 | 3 | 0.466 | 61708.2 |
884 | 2020-07-19 14:02:39 | idiot | 1 | 28756 | 3 | 0.440 | 65354.5 |
883 | 2020-05-05 10:28:47 | idiot | 1 | 28756 | 3 | 0.453 | 63479.0 |
882 | 2020-03-26 12:54:00 | idiot | 1 | 28756 | 3 | 0.513 | 56054.6 |
881 | 2020-03-25 04:10:09 | idiot | 1 | 28756 | 3 | 0.453 | 63479.0 |
880 | 2020-03-24 19:16:56 | idiot | 1 | 28756 | 3 | 0.500 | 57512.0 |
879 | 2020-03-22 21:35:38 | idiot | 1 | 28756 | 3 | 0.453 | 63479.0 |
878 | 2020-03-22 05:23:38 | idiot | 1 | 28756 | 3 | 0.470 | 61183.0 |
877 | 2020-03-21 03:56:57 | idiot | 1 | 28756 | 3 | 0.500 | 57512.0 |
876 | 2020-03-18 01:45:23 | idiot | 1 | 28756 | 3 | 0.483 | 59536.2 |