History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"horse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
952 | 2024-04-24 16:09:00 | horse | 1 | 28756 | 18 | 0.563 | 51076.4 |
951 | 2024-04-03 04:12:17 | horse | 1 | 28756 | 18 | 1.093 | 26309.2 |
950 | 2024-04-01 17:02:42 | horse | 1 | 28756 | 18 | 1.076 | 26724.9 |
949 | 2024-03-31 09:03:49 | horse | 2 | 53800 | 217 | 1.830 | 29398.9 |
948 | 2024-03-31 09:03:45 | horse | 1 | 28756 | 18 | 0.576 | 49923.6 |
947 | 2024-03-31 09:03:32 | horse | 2 | 53800 | 217 | 5.376 | 10007.4 |
946 | 2024-03-31 09:03:20 | horse | 1 | 28756 | 18 | 0.596 | 48248.3 |
945 | 2024-03-28 20:02:37 | horse | 1 | 28756 | 18 | 0.483 | 59536.2 |
944 | 2024-03-23 09:30:34 | horse | 1 | 28756 | 18 | 0.516 | 55728.7 |
943 | 2024-03-04 04:07:55 | horse | 2 | 53800 | 217 | 3.173 | 16955.6 |
942 | 2024-03-04 02:07:36 | horse | 1 | 28756 | 18 | 0.516 | 55728.7 |
941 | 2024-03-03 05:56:21 | horse | 2 | 53800 | 217 | 1.420 | 37887.3 |
940 | 2024-03-02 14:36:52 | horse | 1 | 28756 | 18 | 0.580 | 49579.3 |
939 | 2024-03-01 06:25:19 | horse | 1 | 28756 | 18 | 0.546 | 52666.7 |
938 | 2024-02-28 16:52:42 | horse | 1 | 28756 | 18 | 0.860 | 33437.2 |
937 | 2024-02-25 17:58:36 | horse | 1 | 28756 | 18 | 0.653 | 44036.8 |
936 | 2024-02-03 02:42:41 | horse | 1 | 28756 | 18 | 1.060 | 27128.3 |
935 | 2024-01-29 15:51:25 | horse | 1 | 28756 | 18 | 0.796 | 36125.6 |
934 | 2024-01-29 01:41:07 | horse | 1 | 28756 | 18 | 0.500 | 57512.0 |
933 | 2024-01-26 09:11:09 | horse | 1 | 28756 | 18 | 0.516 | 55728.7 |
932 | 2024-01-19 11:13:31 | horse | 1 | 28756 | 18 | 0.516 | 55728.7 |
931 | 2023-12-20 16:18:32 | horse | 1 | 28756 | 18 | 0.533 | 53951.2 |
930 | 2023-11-22 12:24:05 | horse | 2 | 53800 | 217 | 1.563 | 34421.0 |
929 | 2023-11-21 00:50:32 | horse | 2 | 53800 | 217 | 1.670 | 32215.6 |
928 | 2023-11-19 20:08:15 | horse | 2 | 53800 | 217 | 1.703 | 31591.3 |
927 | 2023-11-16 09:30:34 | horse | 2 | 53800 | 217 | 1.406 | 38264.6 |
926 | 2023-11-09 07:55:25 | horse | 1 | 28756 | 18 | 0.470 | 61183.0 |
925 | 2023-11-08 04:19:53 | horse | 1 | 28756 | 18 | 0.500 | 57512.0 |
924 | 2023-10-28 03:45:18 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
923 | 2023-10-27 06:10:19 | horse | 1 | 28756 | 18 | 0.593 | 48492.4 |
922 | 2023-10-20 13:04:22 | horse | 2 | 53800 | 217 | 1.796 | 29955.5 |
921 | 2023-10-19 17:03:45 | horse | 1 | 28756 | 18 | 0.486 | 59168.7 |
920 | 2023-10-19 14:35:18 | horse | 2 | 53800 | 217 | 1.596 | 33709.3 |
919 | 2023-10-18 06:12:20 | horse | 1 | 28756 | 18 | 0.530 | 54256.6 |
918 | 2023-10-16 20:42:59 | horse | 1 | 28756 | 18 | 0.450 | 63902.2 |
917 | 2023-10-13 07:43:36 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
916 | 2023-10-08 12:55:09 | horse | 1 | 28756 | 18 | 0.483 | 59536.2 |
915 | 2023-10-04 06:06:28 | horse | 1 | 28756 | 18 | 0.483 | 59536.2 |
914 | 2023-09-23 14:33:53 | horse | 1 | 28756 | 18 | 0.516 | 55728.7 |
913 | 2023-09-12 07:20:20 | horse | 1 | 28756 | 18 | 0.440 | 65354.5 |
912 | 2023-09-09 10:20:26 | horse | 1 | 28756 | 18 | 0.483 | 59536.2 |
911 | 2023-08-19 09:05:59 | horse | 2 | 53800 | 217 | 1.406 | 38264.6 |
910 | 2023-08-05 04:29:22 | horse | 1 | 28756 | 18 | 0.470 | 61183.0 |
909 | 2023-07-12 15:41:05 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
908 | 2023-05-05 23:12:20 | horse | 2 | 53800 | 217 | 1.576 | 34137.1 |
907 | 2023-05-02 17:45:21 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
906 | 2023-04-08 20:14:32 | horse | 1 | 28756 | 18 | 0.440 | 65354.5 |
905 | 2023-02-23 02:04:09 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
904 | 2023-02-13 19:49:47 | horse | 2 | 53800 | 217 | 1.516 | 35488.1 |
903 | 2023-01-03 15:16:18 | horse | 1 | 28756 | 18 | 0.466 | 61708.2 |
902 | 2022-12-20 09:31:45 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
901 | 2022-11-25 03:38:15 | horse | 2 | 53800 | 217 | 1.390 | 38705.0 |
900 | 2022-09-20 00:06:25 | horse | 1 | 28756 | 18 | 0.576 | 49923.6 |
899 | 2022-09-19 22:25:56 | horse | 1 | 28756 | 18 | 0.500 | 57512.0 |
898 | 2022-09-18 16:32:31 | horse | 1 | 28756 | 18 | 0.456 | 63061.4 |
897 | 2022-09-03 15:24:51 | horse | 1 | 28756 | 18 | 0.440 | 65354.5 |
896 | 2022-09-03 11:48:14 | horse | 1 | 28756 | 18 | 0.483 | 59536.2 |
895 | 2022-09-01 11:50:19 | horse | 1 | 28756 | 18 | 0.470 | 61183.0 |
894 | 2022-08-26 08:52:07 | horse | 1 | 28756 | 18 | 0.483 | 59536.2 |
893 | 2022-08-07 00:42:25 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
892 | 2022-07-30 02:03:49 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
891 | 2022-07-10 05:21:28 | horse | 1 | 28756 | 18 | 0.453 | 63479.0 |
890 | 2022-07-03 10:02:22 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
889 | 2022-07-02 16:37:20 | horse | 1 | 28756 | 18 | 0.440 | 65354.5 |
888 | 2022-06-25 21:48:47 | horse | 1 | 28756 | 18 | 0.420 | 68466.7 |
887 | 2022-06-16 10:00:30 | horse | 1 | 28756 | 18 | 0.453 | 63479.0 |
886 | 2022-06-03 03:59:16 | horse | 1 | 28756 | 18 | 0.453 | 63479.0 |
885 | 2022-05-26 02:25:46 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
884 | 2022-04-25 11:55:12 | horse | 2 | 53800 | 217 | 1.563 | 34421.0 |
883 | 2022-04-19 00:10:52 | horse | 1 | 28756 | 18 | 0.513 | 56054.6 |
882 | 2022-02-23 05:41:51 | horse | 1 | 28756 | 18 | 0.483 | 59536.2 |
881 | 2022-02-19 18:55:01 | horse | 1 | 28756 | 18 | 0.453 | 63479.0 |
880 | 2022-02-10 18:08:00 | horse | 1 | 28756 | 18 | 0.500 | 57512.0 |
879 | 2022-02-05 21:14:51 | horse | 1 | 28756 | 18 | 0.513 | 56054.6 |
878 | 2022-02-04 22:15:35 | horse | 1 | 28756 | 18 | 0.456 | 63061.4 |
877 | 2022-02-03 18:25:50 | horse | 1 | 28756 | 18 | 0.516 | 55728.7 |
876 | 2022-02-03 05:28:06 | horse | 1 | 28756 | 18 | 0.470 | 61183.0 |
875 | 2022-02-02 18:30:46 | horse | 1 | 28756 | 18 | 0.470 | 61183.0 |
874 | 2022-02-01 17:06:59 | horse | 1 | 28756 | 18 | 0.483 | 59536.2 |
873 | 2022-01-31 17:20:10 | horse | 1 | 28756 | 18 | 0.483 | 59536.2 |
872 | 2022-01-30 23:27:16 | horse | 1 | 28756 | 18 | 0.466 | 61708.2 |
871 | 2022-01-29 23:35:18 | horse | 1 | 28756 | 18 | 0.530 | 54256.6 |
870 | 2022-01-23 15:51:27 | horse | 1 | 28756 | 18 | 0.516 | 55728.7 |
869 | 2022-01-23 11:52:19 | horse | 1 | 28756 | 18 | 0.516 | 55728.7 |
868 | 2022-01-23 06:17:46 | horse | 1 | 28756 | 18 | 0.500 | 57512.0 |
867 | 2022-01-22 20:13:10 | horse | 1 | 28756 | 18 | 0.500 | 57512.0 |
866 | 2022-01-22 20:11:15 | horse | 1 | 28756 | 18 | 0.486 | 59168.7 |
865 | 2022-01-22 17:27:10 | horse | 1 | 28756 | 18 | 0.516 | 55728.7 |
864 | 2022-01-22 05:38:44 | horse | 1 | 28756 | 18 | 0.500 | 57512.0 |
863 | 2022-01-22 00:03:09 | horse | 1 | 28756 | 18 | 0.513 | 56054.6 |
862 | 2022-01-17 08:49:26 | horse | 1 | 28756 | 18 | 0.580 | 49579.3 |
861 | 2022-01-16 12:31:56 | horse | 1 | 28756 | 18 | 0.533 | 53951.2 |
860 | 2022-01-16 02:33:57 | horse | 1 | 28756 | 18 | 0.576 | 49923.6 |
859 | 2022-01-15 17:30:24 | horse | 1 | 28756 | 18 | 0.453 | 63479.0 |
858 | 2022-01-15 09:46:30 | horse | 1 | 28756 | 18 | 0.453 | 63479.0 |
857 | 2022-01-14 20:14:01 | horse | 1 | 28756 | 18 | 0.546 | 52666.7 |
856 | 2022-01-14 11:57:36 | horse | 1 | 28756 | 18 | 0.466 | 61708.2 |
855 | 2022-01-13 19:53:03 | horse | 1 | 28756 | 18 | 0.436 | 65954.1 |
854 | 2022-01-09 13:02:46 | horse | 1 | 28756 | 18 | 0.750 | 38341.3 |
853 | 2022-01-08 19:34:33 | horse | 1 | 28756 | 18 | 0.466 | 61708.2 |