History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
943 | 2024-04-25 09:08:51 | coots | 1 | 28756 | 25 | 0.593 | 48492.4 |
942 | 2024-04-24 16:38:15 | coots | 1 | 28756 | 25 | 1.156 | 24875.4 |
941 | 2024-04-15 13:36:34 | coots | 1 | 28756 | 25 | 1.060 | 27128.3 |
940 | 2024-04-02 20:47:09 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
939 | 2024-04-01 18:53:38 | coots | 1 | 28756 | 25 | 1.516 | 18968.3 |
938 | 2024-03-31 03:24:12 | coots | 1 | 28756 | 25 | 1.203 | 23903.6 |
937 | 2024-03-26 22:36:33 | coots | 1 | 28756 | 25 | 0.640 | 44931.3 |
936 | 2024-03-16 15:39:42 | coots | 1 | 28756 | 25 | 1.216 | 23648.0 |
935 | 2024-03-06 02:39:45 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
934 | 2024-02-25 18:38:33 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
933 | 2024-01-30 00:11:58 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
932 | 2024-01-26 12:18:21 | coots | 1 | 28756 | 25 | 0.436 | 65954.1 |
931 | 2024-01-05 23:28:20 | coots | 1 | 28756 | 25 | 0.546 | 52666.7 |
930 | 2023-12-31 19:34:31 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
929 | 2023-12-31 02:11:52 | coots | 1 | 28756 | 25 | 0.456 | 63061.4 |
928 | 2023-12-10 11:03:31 | coots | 2 | 53800 | 347 | 1.390 | 38705.0 |
927 | 2023-12-03 05:43:35 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
926 | 2023-11-29 20:15:54 | coots | 1 | 28756 | 25 | 0.516 | 55728.7 |
925 | 2023-11-24 03:55:46 | coots | 2 | 53800 | 347 | 1.360 | 39558.8 |
924 | 2023-11-21 05:48:07 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
923 | 2023-11-19 01:25:58 | coots | 2 | 53800 | 347 | 1.486 | 36204.6 |
922 | 2023-11-11 07:09:19 | coots | 1 | 28756 | 25 | 0.436 | 65954.1 |
921 | 2023-11-08 17:12:01 | coots | 1 | 28756 | 25 | 0.483 | 59536.2 |
920 | 2023-11-02 07:09:07 | coots | 1 | 28756 | 25 | 2.030 | 14165.5 |
919 | 2023-11-02 07:08:53 | coots | 1 | 28756 | 25 | 1.763 | 16310.8 |
918 | 2023-10-29 20:37:20 | coots | 1 | 28756 | 25 | 0.486 | 59168.7 |
917 | 2023-10-28 03:07:16 | coots | 2 | 53800 | 347 | 1.610 | 33416.1 |
916 | 2023-10-27 08:02:10 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
915 | 2023-10-19 20:38:36 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
914 | 2023-10-18 02:25:21 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
913 | 2023-10-11 14:10:12 | coots | 1 | 28756 | 25 | 0.483 | 59536.2 |
912 | 2023-10-08 19:31:08 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
911 | 2023-10-04 14:09:35 | coots | 1 | 28756 | 25 | 0.483 | 59536.2 |
910 | 2023-09-25 06:18:35 | coots | 1 | 28756 | 25 | 0.890 | 32310.1 |
909 | 2023-09-22 06:12:06 | coots | 1 | 28756 | 25 | 0.436 | 65954.1 |
908 | 2023-09-12 03:04:22 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
907 | 2023-08-24 04:21:02 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
906 | 2023-08-23 22:20:11 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
905 | 2023-05-24 18:40:44 | coots | 1 | 28756 | 25 | 0.466 | 61708.2 |
904 | 2023-05-24 07:59:29 | coots | 1 | 28756 | 25 | 0.466 | 61708.2 |
903 | 2023-03-19 11:07:53 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
902 | 2023-02-18 07:00:12 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
901 | 2023-01-06 14:23:25 | coots | 1 | 28756 | 25 | 0.436 | 65954.1 |
900 | 2022-11-15 08:14:10 | coots | 1 | 28756 | 25 | 0.436 | 65954.1 |
899 | 2022-10-03 03:14:10 | coots | 1 | 28756 | 25 | 0.440 | 65354.5 |
898 | 2022-08-15 05:18:16 | coots | 1 | 28756 | 25 | 0.513 | 56054.6 |
897 | 2022-05-19 03:40:47 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
896 | 2022-05-12 20:40:22 | coots | 1 | 28756 | 25 | 1.376 | 20898.3 |
895 | 2022-02-08 04:00:08 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
894 | 2022-01-31 14:07:48 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
893 | 2022-01-08 21:42:20 | coots | 1 | 28756 | 25 | 0.533 | 53951.2 |
892 | 2022-01-08 06:15:10 | coots | 1 | 28756 | 25 | 0.486 | 59168.7 |
891 | 2022-01-07 14:15:28 | coots | 1 | 28756 | 25 | 0.546 | 52666.7 |
890 | 2022-01-06 23:07:39 | coots | 1 | 28756 | 25 | 0.533 | 53951.2 |
889 | 2021-12-11 05:35:20 | coots | 1 | 28756 | 25 | 0.530 | 54256.6 |
888 | 2021-12-10 07:07:36 | coots | 1 | 28756 | 25 | 0.486 | 59168.7 |
887 | 2021-12-09 04:21:20 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
886 | 2021-12-08 08:27:48 | coots | 1 | 28756 | 25 | 1.046 | 27491.4 |
885 | 2021-11-24 15:47:40 | coots | 1 | 28756 | 25 | 0.796 | 36125.6 |
884 | 2021-11-23 10:47:02 | coots | 1 | 28756 | 25 | 0.516 | 55728.7 |
883 | 2021-11-07 05:40:57 | coots | 1 | 28756 | 25 | 0.486 | 59168.7 |
882 | 2021-10-27 08:06:49 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
881 | 2021-10-08 07:13:36 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
880 | 2021-09-27 05:02:04 | coots | 1 | 28756 | 25 | 0.563 | 51076.4 |
879 | 2021-09-04 01:04:33 | coots | 1 | 28756 | 25 | 0.470 | 61183.0 |
878 | 2021-09-01 17:57:24 | coots | 1 | 28756 | 25 | 0.466 | 61708.2 |
877 | 2021-08-17 11:17:59 | coots | 1 | 28756 | 25 | 0.450 | 63902.2 |
876 | 2021-08-04 03:46:59 | coots | 1 | 28756 | 25 | 0.516 | 55728.7 |
875 | 2021-07-23 21:46:16 | coots | 1 | 28756 | 25 | 0.436 | 65954.1 |
874 | 2021-06-03 23:49:08 | coots | 1 | 28756 | 25 | 1.000 | 28756.0 |
873 | 2021-06-02 20:31:41 | coots | 1 | 28756 | 25 | 0.486 | 59168.7 |
872 | 2021-05-13 15:49:43 | coots | 1 | 28756 | 25 | 0.483 | 59536.2 |
871 | 2021-05-05 22:13:17 | coots | 1 | 28756 | 25 | 0.470 | 61183.0 |
870 | 2021-05-03 10:48:09 | coots | 1 | 28756 | 25 | 0.513 | 56054.6 |
869 | 2021-04-29 18:58:35 | coots | 1 | 28756 | 25 | 0.516 | 55728.7 |
868 | 2021-04-24 20:26:25 | coots | 1 | 28756 | 25 | 0.530 | 54256.6 |
867 | 2021-04-22 22:05:16 | coots | 1 | 28756 | 25 | 0.516 | 55728.7 |
866 | 2021-04-12 15:48:02 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
865 | 2021-03-16 10:54:36 | coots | 1 | 28756 | 25 | 0.560 | 51350.0 |
864 | 2021-02-27 02:22:06 | coots | 1 | 28756 | 25 | 0.546 | 52666.7 |
863 | 2021-02-12 09:08:33 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
862 | 2021-01-25 08:23:00 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
861 | 2020-12-28 15:05:45 | coots | 1 | 28756 | 25 | 0.516 | 55728.7 |
860 | 2020-12-16 03:05:29 | coots | 2 | 53800 | 347 | 1.406 | 38264.6 |
859 | 2020-11-09 00:24:14 | coots | 2 | 53800 | 347 | 1.640 | 32804.9 |
858 | 2020-10-28 04:29:27 | coots | 1 | 28756 | 25 | 0.530 | 54256.6 |
857 | 2020-10-27 07:09:31 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
856 | 2020-10-26 18:44:40 | coots | 1 | 28756 | 25 | 0.500 | 57512.0 |
855 | 2020-10-24 03:42:33 | coots | 1 | 28756 | 25 | 0.436 | 65954.1 |
854 | 2020-10-20 22:59:21 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
853 | 2020-10-20 17:49:44 | coots | 1 | 28756 | 25 | 0.516 | 55728.7 |
852 | 2020-10-18 12:24:51 | coots | 1 | 28756 | 25 | 0.440 | 65354.5 |
851 | 2020-10-14 12:50:48 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
850 | 2020-09-10 16:45:38 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
849 | 2020-09-04 01:19:04 | coots | 1 | 28756 | 25 | 0.453 | 63479.0 |
848 | 2020-08-27 01:30:46 | coots | 1 | 28756 | 25 | 0.466 | 61708.2 |
847 | 2020-08-05 07:05:15 | coots | 1 | 28756 | 25 | 0.436 | 65954.1 |
846 | 2020-07-29 04:47:14 | coots | 1 | 28756 | 25 | 0.466 | 61708.2 |
845 | 2020-07-29 04:26:22 | coots | 1 | 28756 | 25 | 0.546 | 52666.7 |
844 | 2020-07-24 15:16:26 | coots | 1 | 28756 | 25 | 0.513 | 56054.6 |