History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fauna"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
947 | 2024-04-27 11:30:12 | fauna | 1 | 28756 | 8 | 1.656 | 17364.7 |
946 | 2024-04-27 05:53:18 | fauna | 2 | 53800 | 77 | 1.720 | 31279.1 |
945 | 2024-04-27 05:53:12 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
944 | 2024-04-27 05:51:19 | fauna | 3 | 83667 | 1061 | 3.673 | 22778.9 |
943 | 2024-04-26 16:38:18 | fauna | 3 | 83667 | 1061 | 3.593 | 23286.1 |
942 | 2024-04-05 09:53:45 | fauna | 1 | 28756 | 8 | 0.716 | 40162.0 |
941 | 2024-04-03 06:01:12 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
940 | 2024-03-31 07:00:32 | fauna | 1 | 28756 | 8 | 0.986 | 29164.3 |
939 | 2024-03-29 02:32:58 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
938 | 2024-03-04 00:33:35 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
937 | 2024-03-01 05:10:12 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
936 | 2024-02-27 20:23:55 | fauna | 1 | 28756 | 8 | 0.530 | 54256.6 |
935 | 2024-02-02 22:48:19 | fauna | 1 | 28756 | 8 | 0.530 | 54256.6 |
934 | 2024-01-28 23:29:59 | fauna | 1 | 28756 | 8 | 0.513 | 56054.6 |
933 | 2024-01-28 20:12:45 | fauna | 1 | 28756 | 8 | 0.903 | 31845.0 |
932 | 2024-01-13 00:36:51 | fauna | 2 | 53800 | 77 | 1.610 | 33416.1 |
931 | 2024-01-13 00:36:43 | fauna | 3 | 83667 | 1061 | 3.326 | 25155.4 |
930 | 2023-12-25 01:59:57 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
929 | 2023-12-21 05:11:43 | fauna | 3 | 83667 | 1061 | 3.533 | 23681.6 |
928 | 2023-12-21 01:13:28 | fauna | 2 | 53800 | 77 | 1.766 | 30464.3 |
927 | 2023-12-15 02:52:53 | fauna | 2 | 53800 | 77 | 1.720 | 31279.1 |
926 | 2023-12-09 08:23:13 | fauna | 3 | 83667 | 1061 | 3.593 | 23286.1 |
925 | 2023-12-07 01:19:59 | fauna | 1 | 28756 | 8 | 0.483 | 59536.2 |
924 | 2023-12-07 01:19:58 | fauna | 1 | 28756 | 8 | 0.516 | 55728.7 |
923 | 2023-11-21 04:10:16 | fauna | 3 | 83667 | 1061 | 3.733 | 22412.8 |
922 | 2023-11-17 20:10:47 | fauna | 3 | 83667 | 1061 | 3.970 | 21074.8 |
921 | 2023-11-17 13:58:26 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
920 | 2023-11-11 07:20:11 | fauna | 3 | 83667 | 1061 | 3.513 | 23816.4 |
919 | 2023-11-11 07:20:12 | fauna | 2 | 53800 | 77 | 1.623 | 33148.5 |
918 | 2023-11-07 11:06:06 | fauna | 1 | 28756 | 8 | 1.580 | 18200.0 |
917 | 2023-11-06 14:40:48 | fauna | 1 | 28756 | 8 | 0.486 | 59168.7 |
916 | 2023-11-03 09:52:25 | fauna | 1 | 28756 | 8 | 0.466 | 61708.2 |
915 | 2023-11-01 12:28:56 | fauna | 1 | 28756 | 8 | 0.470 | 61183.0 |
914 | 2023-10-23 03:08:54 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
913 | 2023-10-18 04:22:45 | fauna | 1 | 28756 | 8 | 0.470 | 61183.0 |
912 | 2023-10-14 01:33:15 | fauna | 1 | 28756 | 8 | 0.483 | 59536.2 |
911 | 2023-10-13 14:38:21 | fauna | 1 | 28756 | 8 | 0.533 | 53951.2 |
910 | 2023-10-05 19:25:08 | fauna | 1 | 28756 | 8 | 0.483 | 59536.2 |
909 | 2023-09-29 06:54:55 | fauna | 1 | 28756 | 8 | 0.453 | 63479.0 |
908 | 2023-09-10 22:01:53 | fauna | 1 | 28756 | 8 | 0.486 | 59168.7 |
907 | 2023-08-09 07:40:29 | fauna | 1 | 28756 | 8 | 0.483 | 59536.2 |
906 | 2023-07-22 22:08:57 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
905 | 2023-05-10 01:24:38 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
904 | 2023-04-11 04:45:30 | fauna | 1 | 28756 | 8 | 0.486 | 59168.7 |
903 | 2023-03-04 14:15:09 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
902 | 2022-12-29 14:57:04 | fauna | 1 | 28756 | 8 | 0.486 | 59168.7 |
901 | 2022-12-28 09:21:15 | fauna | 1 | 28756 | 8 | 0.453 | 63479.0 |
900 | 2022-09-18 19:03:22 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
899 | 2022-09-17 10:38:53 | fauna | 1 | 28756 | 8 | 0.453 | 63479.0 |
898 | 2022-08-15 18:17:43 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
897 | 2022-08-15 01:14:44 | fauna | 1 | 28756 | 8 | 0.466 | 61708.2 |
896 | 2022-07-30 07:54:09 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
895 | 2022-07-29 09:19:51 | fauna | 1 | 28756 | 8 | 0.483 | 59536.2 |
894 | 2022-06-05 08:40:26 | fauna | 1 | 28756 | 8 | 0.483 | 59536.2 |
893 | 2022-06-02 02:11:00 | fauna | 1 | 28756 | 8 | 0.440 | 65354.5 |
892 | 2022-04-27 10:20:45 | fauna | 1 | 28756 | 8 | 0.483 | 59536.2 |
891 | 2022-03-21 21:12:17 | fauna | 1 | 28756 | 8 | 0.453 | 63479.0 |
890 | 2022-03-20 22:25:57 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
889 | 2022-02-18 16:42:42 | fauna | 1 | 28756 | 8 | 0.966 | 29768.1 |
888 | 2022-02-10 17:34:55 | fauna | 1 | 28756 | 8 | 0.420 | 68466.7 |
887 | 2022-01-18 16:13:09 | fauna | 1 | 28756 | 8 | 0.483 | 59536.2 |
886 | 2022-01-05 23:56:25 | fauna | 1 | 28756 | 8 | 0.546 | 52666.7 |
885 | 2022-01-05 14:41:10 | fauna | 1 | 28756 | 8 | 0.516 | 55728.7 |
884 | 2022-01-04 23:49:42 | fauna | 1 | 28756 | 8 | 0.516 | 55728.7 |
883 | 2021-12-07 20:11:09 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
882 | 2021-12-07 08:50:29 | fauna | 1 | 28756 | 8 | 0.440 | 65354.5 |
881 | 2021-12-06 23:23:36 | fauna | 1 | 28756 | 8 | 0.453 | 63479.0 |
880 | 2021-12-06 13:43:19 | fauna | 1 | 28756 | 8 | 0.516 | 55728.7 |
879 | 2021-12-05 22:55:46 | fauna | 1 | 28756 | 8 | 0.486 | 59168.7 |
878 | 2021-12-05 12:38:03 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
877 | 2021-11-25 00:41:49 | fauna | 1 | 28756 | 8 | 0.436 | 65954.1 |
876 | 2021-11-19 07:54:40 | fauna | 1 | 28756 | 8 | 0.456 | 63061.4 |
875 | 2021-11-12 07:58:13 | fauna | 1 | 28756 | 8 | 0.986 | 29164.3 |
874 | 2021-11-10 17:17:04 | fauna | 1 | 28756 | 8 | 0.733 | 39230.6 |
873 | 2021-11-07 20:38:42 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
872 | 2021-11-05 23:10:06 | fauna | 1 | 28756 | 8 | 0.546 | 52666.7 |
871 | 2021-10-04 05:56:34 | fauna | 1 | 28756 | 8 | 0.453 | 63479.0 |
870 | 2021-09-27 04:53:46 | fauna | 1 | 28756 | 8 | 1.046 | 27491.4 |
869 | 2021-09-27 01:49:52 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
868 | 2021-09-22 09:29:19 | fauna | 1 | 28756 | 8 | 0.486 | 59168.7 |
867 | 2021-09-17 05:02:52 | fauna | 1 | 28756 | 8 | 0.486 | 59168.7 |
866 | 2021-08-24 03:16:46 | fauna | 1 | 28756 | 8 | 0.516 | 55728.7 |
865 | 2021-08-07 17:10:07 | fauna | 1 | 28756 | 8 | 0.453 | 63479.0 |
864 | 2021-06-26 19:55:54 | fauna | 3 | 83667 | 1061 | 3.873 | 21602.6 |
863 | 2021-05-22 23:10:59 | fauna | 3 | 83667 | 1061 | 4.546 | 18404.5 |
862 | 2021-05-21 18:24:59 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
861 | 2021-05-03 12:41:13 | fauna | 1 | 28756 | 8 | 0.513 | 56054.6 |
860 | 2021-04-29 21:05:41 | fauna | 1 | 28756 | 8 | 0.516 | 55728.7 |
859 | 2021-04-23 17:18:33 | fauna | 3 | 83667 | 1061 | 4.170 | 20064.0 |
858 | 2021-04-08 06:29:15 | fauna | 3 | 83667 | 1061 | 3.830 | 21845.2 |
857 | 2021-02-15 21:57:44 | fauna | 3 | 83667 | 1061 | 3.500 | 23904.9 |
856 | 2021-02-10 18:08:02 | fauna | 1 | 28756 | 8 | 0.440 | 65354.5 |
855 | 2021-01-25 10:14:32 | fauna | 1 | 28756 | 8 | 0.500 | 57512.0 |
854 | 2021-01-15 10:48:30 | fauna | 3 | 83667 | 1061 | 3.330 | 25125.2 |
853 | 2020-11-06 02:28:52 | fauna | 3 | 83667 | 1061 | 7.160 | 11685.3 |
852 | 2020-11-02 00:22:37 | fauna | 1 | 28756 | 8 | 0.516 | 55728.7 |
851 | 2020-10-26 18:27:21 | fauna | 2 | 53800 | 77 | 1.733 | 31044.4 |
850 | 2020-10-24 06:08:12 | fauna | 1 | 28756 | 8 | 0.450 | 63902.2 |
849 | 2020-10-23 06:32:54 | fauna | 1 | 28756 | 8 | 0.440 | 65354.5 |
848 | 2020-10-15 15:56:13 | fauna | 3 | 83667 | 1061 | 3.406 | 24564.6 |