History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shoes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
949 | 2024-04-03 04:41:56 | shoes | 1 | 28756 | 18 | 1.190 | 24164.7 |
948 | 2024-03-31 06:26:17 | shoes | 1 | 28756 | 18 | 0.593 | 48492.4 |
947 | 2024-03-31 01:12:39 | shoes | 1 | 28756 | 18 | 1.736 | 16564.5 |
946 | 2024-03-27 22:04:59 | shoes | 1 | 28756 | 18 | 0.580 | 49579.3 |
945 | 2024-03-27 22:04:42 | shoes | 2 | 53800 | 291 | 1.673 | 32157.8 |
944 | 2024-03-27 03:45:59 | shoes | 2 | 53800 | 291 | 5.706 | 9428.7 |
943 | 2024-03-27 02:13:16 | shoes | 1 | 28756 | 18 | 1.110 | 25906.3 |
942 | 2024-03-22 22:28:19 | shoes | 1 | 28756 | 18 | 0.470 | 61183.0 |
941 | 2024-03-04 01:58:15 | shoes | 1 | 28756 | 18 | 0.486 | 59168.7 |
940 | 2024-02-25 22:19:03 | shoes | 2 | 53800 | 291 | 1.830 | 29398.9 |
939 | 2024-02-25 22:16:01 | shoes | 1 | 28756 | 18 | 2.126 | 13525.9 |
938 | 2024-02-03 03:53:19 | shoes | 1 | 28756 | 18 | 0.486 | 59168.7 |
937 | 2024-01-31 02:13:41 | shoes | 1 | 28756 | 18 | 0.513 | 56054.6 |
936 | 2024-01-26 20:27:01 | shoes | 1 | 28756 | 18 | 0.513 | 56054.6 |
935 | 2024-01-24 17:34:15 | shoes | 1 | 28756 | 18 | 0.516 | 55728.7 |
934 | 2024-01-16 22:07:05 | shoes | 1 | 28756 | 18 | 0.466 | 61708.2 |
933 | 2024-01-13 11:51:34 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
932 | 2024-01-02 07:42:23 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
931 | 2023-12-29 21:05:40 | shoes | 1 | 28756 | 18 | 1.000 | 28756.0 |
930 | 2023-12-08 10:57:37 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
929 | 2023-12-08 10:57:36 | shoes | 1 | 28756 | 18 | 0.513 | 56054.6 |
928 | 2023-12-02 09:57:48 | shoes | 2 | 53800 | 291 | 1.563 | 34421.0 |
927 | 2023-12-02 03:01:43 | shoes | 2 | 53800 | 291 | 1.466 | 36698.5 |
926 | 2023-11-26 13:52:18 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
925 | 2023-11-25 17:11:54 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
924 | 2023-11-22 07:25:50 | shoes | 2 | 53800 | 291 | 1.580 | 34050.6 |
923 | 2023-11-10 12:45:38 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
922 | 2023-11-09 04:21:03 | shoes | 1 | 28756 | 18 | 0.440 | 65354.5 |
921 | 2023-11-07 10:59:32 | shoes | 1 | 28756 | 18 | 1.093 | 26309.2 |
920 | 2023-11-07 10:59:30 | shoes | 1 | 28756 | 18 | 1.623 | 17717.8 |
919 | 2023-10-28 04:23:12 | shoes | 2 | 53800 | 291 | 1.653 | 32546.9 |
918 | 2023-10-27 21:14:24 | shoes | 1 | 28756 | 18 | 0.470 | 61183.0 |
917 | 2023-10-19 20:40:03 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
916 | 2023-10-19 03:17:12 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
915 | 2023-10-13 13:39:41 | shoes | 1 | 28756 | 18 | 0.470 | 61183.0 |
914 | 2023-10-11 01:30:34 | shoes | 2 | 53800 | 291 | 1.530 | 35163.4 |
913 | 2023-10-09 06:56:05 | shoes | 2 | 53800 | 291 | 1.576 | 34137.1 |
912 | 2023-10-03 15:28:54 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
911 | 2023-09-23 03:55:32 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
910 | 2023-09-21 19:18:27 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
909 | 2023-09-11 05:36:32 | shoes | 1 | 28756 | 18 | 0.436 | 65954.1 |
908 | 2023-09-10 07:56:33 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
907 | 2023-09-06 21:27:48 | shoes | 1 | 28756 | 18 | 0.513 | 56054.6 |
906 | 2023-06-17 12:14:31 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
905 | 2023-05-24 09:05:22 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
904 | 2023-04-02 19:18:38 | shoes | 1 | 28756 | 18 | 0.436 | 65954.1 |
903 | 2023-02-11 10:53:02 | shoes | 1 | 28756 | 18 | 0.516 | 55728.7 |
902 | 2023-01-15 11:26:44 | shoes | 1 | 28756 | 18 | 0.486 | 59168.7 |
901 | 2022-11-04 17:42:21 | shoes | 1 | 28756 | 18 | 0.450 | 63902.2 |
900 | 2022-10-28 13:57:12 | shoes | 1 | 28756 | 18 | 0.436 | 65954.1 |
899 | 2022-07-29 03:54:37 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
898 | 2022-07-18 19:14:21 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
897 | 2022-06-24 14:25:37 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
896 | 2022-06-22 10:52:20 | shoes | 1 | 28756 | 18 | 0.436 | 65954.1 |
895 | 2022-06-20 04:39:08 | shoes | 1 | 28756 | 18 | 0.436 | 65954.1 |
894 | 2022-03-24 19:25:24 | shoes | 1 | 28756 | 18 | 0.580 | 49579.3 |
893 | 2022-02-25 11:39:31 | shoes | 1 | 28756 | 18 | 0.623 | 46157.3 |
892 | 2022-02-25 02:41:56 | shoes | 1 | 28756 | 18 | 0.703 | 40904.7 |
891 | 2022-02-24 08:57:14 | shoes | 1 | 28756 | 18 | 0.626 | 45936.1 |
890 | 2022-02-23 20:40:04 | shoes | 1 | 28756 | 18 | 0.580 | 49579.3 |
889 | 2022-02-23 03:23:40 | shoes | 1 | 28756 | 18 | 0.550 | 52283.6 |
888 | 2022-02-22 16:56:45 | shoes | 1 | 28756 | 18 | 0.686 | 41918.4 |
887 | 2022-02-22 01:07:37 | shoes | 1 | 28756 | 18 | 0.483 | 59536.2 |
886 | 2022-02-21 05:18:42 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
885 | 2022-02-20 16:10:26 | shoes | 1 | 28756 | 18 | 0.470 | 61183.0 |
884 | 2022-02-20 04:08:57 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
883 | 2022-02-19 15:16:45 | shoes | 1 | 28756 | 18 | 0.466 | 61708.2 |
882 | 2022-02-19 03:34:26 | shoes | 1 | 28756 | 18 | 0.530 | 54256.6 |
881 | 2022-02-18 13:52:49 | shoes | 1 | 28756 | 18 | 0.923 | 31154.9 |
880 | 2022-02-18 02:21:02 | shoes | 1 | 28756 | 18 | 0.440 | 65354.5 |
879 | 2022-02-17 16:00:43 | shoes | 1 | 28756 | 18 | 0.470 | 61183.0 |
878 | 2022-02-17 05:21:52 | shoes | 1 | 28756 | 18 | 0.436 | 65954.1 |
877 | 2022-02-16 14:13:06 | shoes | 1 | 28756 | 18 | 0.516 | 55728.7 |
876 | 2022-02-15 20:30:26 | shoes | 1 | 28756 | 18 | 0.470 | 61183.0 |
875 | 2022-02-15 04:59:48 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
874 | 2022-02-14 13:41:49 | shoes | 1 | 28756 | 18 | 0.576 | 49923.6 |
873 | 2022-02-13 21:57:30 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
872 | 2022-02-10 23:14:31 | shoes | 1 | 28756 | 18 | 1.046 | 27491.4 |
871 | 2022-02-10 05:31:48 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
870 | 2022-02-09 21:48:09 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
869 | 2022-02-09 04:05:23 | shoes | 1 | 28756 | 18 | 0.516 | 55728.7 |
868 | 2022-02-08 21:51:49 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
867 | 2022-02-07 23:55:29 | shoes | 1 | 28756 | 18 | 0.456 | 63061.4 |
866 | 2021-12-23 03:40:44 | shoes | 1 | 28756 | 18 | 0.450 | 63902.2 |
865 | 2021-12-22 03:42:42 | shoes | 1 | 28756 | 18 | 0.546 | 52666.7 |
864 | 2021-12-21 09:21:28 | shoes | 1 | 28756 | 18 | 0.546 | 52666.7 |
863 | 2021-12-20 03:45:35 | shoes | 1 | 28756 | 18 | 0.530 | 54256.6 |
862 | 2021-12-16 14:50:26 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
861 | 2021-12-13 22:50:29 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
860 | 2021-12-08 01:47:12 | shoes | 1 | 28756 | 18 | 0.516 | 55728.7 |
859 | 2021-12-07 15:30:02 | shoes | 1 | 28756 | 18 | 0.546 | 52666.7 |
858 | 2021-12-07 06:37:49 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
857 | 2021-12-06 12:56:06 | shoes | 1 | 28756 | 18 | 0.533 | 53951.2 |
856 | 2021-12-05 23:15:05 | shoes | 1 | 28756 | 18 | 0.500 | 57512.0 |
855 | 2021-12-05 11:32:46 | shoes | 1 | 28756 | 18 | 0.513 | 56054.6 |
854 | 2021-11-19 00:17:44 | shoes | 1 | 28756 | 18 | 0.516 | 55728.7 |
853 | 2021-11-18 12:03:14 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
852 | 2021-11-17 23:08:55 | shoes | 1 | 28756 | 18 | 0.483 | 59536.2 |
851 | 2021-11-17 15:31:44 | shoes | 1 | 28756 | 18 | 0.453 | 63479.0 |
850 | 2021-11-10 17:37:44 | shoes | 1 | 28756 | 18 | 0.513 | 56054.6 |