History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aphid"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1011 | 2024-04-13 08:34:05 | aphid | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1010 | 2024-04-04 19:55:50 | aphid | 3 | 83667 | 625 | 7.796 | 10732.0 |
| 1009 | 2024-04-04 08:07:04 | aphid | 3 | 83667 | 625 | 6.266 | 13352.5 |
| 1008 | 2024-04-03 06:33:41 | aphid | 3 | 83667 | 625 | 4.796 | 17445.2 |
| 1007 | 2024-04-03 06:33:39 | aphid | 2 | 53800 | 39 | 5.970 | 9011.7 |
| 1006 | 2024-04-03 06:19:06 | aphid | 1 | 28756 | 3 | 1.173 | 24514.9 |
| 1005 | 2024-03-31 08:27:59 | aphid | 3 | 83667 | 625 | 4.423 | 18916.3 |
| 1004 | 2024-03-31 08:28:00 | aphid | 2 | 53800 | 39 | 3.470 | 15504.3 |
| 1003 | 2024-03-31 08:27:57 | aphid | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 1002 | 2024-03-28 20:14:30 | aphid | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1001 | 2024-03-06 08:10:12 | aphid | 2 | 53800 | 39 | 5.656 | 9512.0 |
| 1000 | 2024-03-06 08:09:45 | aphid | 3 | 83667 | 625 | 3.296 | 25384.4 |
| 999 | 2024-03-05 18:36:34 | aphid | 3 | 83667 | 625 | 16.033 | 5218.4 |
| 998 | 2024-03-05 18:11:37 | aphid | 2 | 53800 | 39 | 5.763 | 9335.4 |
| 997 | 2024-03-04 12:24:55 | aphid | 2 | 53800 | 39 | 1.640 | 32804.9 |
| 996 | 2024-03-04 12:24:53 | aphid | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 995 | 2024-03-04 12:23:45 | aphid | 3 | 83667 | 625 | 4.533 | 18457.3 |
| 994 | 2024-03-04 03:58:31 | aphid | 3 | 83667 | 625 | 9.313 | 8983.9 |
| 993 | 2024-03-04 03:58:28 | aphid | 2 | 53800 | 39 | 3.533 | 15227.9 |
| 992 | 2024-03-04 00:41:19 | aphid | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 991 | 2024-03-01 02:29:21 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 990 | 2024-02-25 19:14:22 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 989 | 2024-02-02 23:53:51 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 988 | 2024-02-02 04:59:25 | aphid | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 987 | 2024-01-29 01:45:35 | aphid | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 986 | 2024-01-27 11:25:32 | aphid | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 985 | 2024-01-26 04:01:05 | aphid | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 984 | 2024-01-06 04:42:45 | aphid | 3 | 83667 | 625 | 3.830 | 21845.2 |
| 983 | 2024-01-04 15:36:59 | aphid | 3 | 83667 | 625 | 3.733 | 22412.8 |
| 982 | 2023-12-21 21:32:36 | aphid | 2 | 53800 | 39 | 1.783 | 30173.9 |
| 981 | 2023-12-03 21:44:54 | aphid | 3 | 83667 | 625 | 3.783 | 22116.6 |
| 980 | 2023-12-03 21:44:50 | aphid | 3 | 83667 | 625 | 3.420 | 24464.0 |
| 979 | 2023-12-03 21:39:53 | aphid | 3 | 83667 | 625 | 8.373 | 9992.5 |
| 978 | 2023-12-02 04:40:25 | aphid | 3 | 83667 | 625 | 3.923 | 21327.3 |
| 977 | 2023-11-26 16:09:05 | aphid | 3 | 83667 | 625 | 3.703 | 22594.4 |
| 976 | 2023-11-26 13:55:58 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 975 | 2023-11-25 16:16:12 | aphid | 3 | 83667 | 625 | 3.796 | 22040.8 |
| 974 | 2023-11-24 17:58:00 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 973 | 2023-11-21 11:47:42 | aphid | 3 | 83667 | 625 | 3.860 | 21675.4 |
| 972 | 2023-11-21 11:47:36 | aphid | 2 | 53800 | 39 | 1.530 | 35163.4 |
| 971 | 2023-11-12 13:16:47 | aphid | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 970 | 2023-11-09 22:45:58 | aphid | 2 | 53800 | 39 | 1.643 | 32745.0 |
| 969 | 2023-11-09 22:45:53 | aphid | 3 | 83667 | 625 | 3.656 | 22884.8 |
| 968 | 2023-11-09 05:06:51 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 967 | 2023-10-26 15:03:50 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 966 | 2023-10-26 11:39:07 | aphid | 1 | 28756 | 3 | 0.750 | 38341.3 |
| 965 | 2023-10-20 11:44:57 | aphid | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 964 | 2023-10-17 15:52:57 | aphid | 3 | 83667 | 625 | 14.546 | 5751.9 |
| 963 | 2023-10-17 07:22:41 | aphid | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 962 | 2023-10-14 07:22:05 | aphid | 3 | 83667 | 625 | 3.673 | 22778.9 |
| 961 | 2023-10-11 20:58:27 | aphid | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 960 | 2023-10-09 00:16:02 | aphid | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 959 | 2023-10-05 02:35:27 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 958 | 2023-10-03 23:58:08 | aphid | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 957 | 2023-09-23 04:16:42 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 956 | 2023-09-13 02:30:51 | aphid | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 955 | 2023-09-11 09:21:56 | aphid | 1 | 28756 | 3 | 0.550 | 52283.6 |
| 954 | 2023-09-11 05:15:49 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 953 | 2023-08-15 16:52:44 | aphid | 1 | 28756 | 3 | 0.456 | 63061.4 |
| 952 | 2023-07-25 12:39:42 | aphid | 3 | 83667 | 625 | 4.203 | 19906.5 |
| 951 | 2023-06-29 03:37:01 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 950 | 2023-06-25 10:24:32 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 949 | 2023-06-17 03:59:09 | aphid | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 948 | 2023-04-07 03:52:13 | aphid | 3 | 83667 | 625 | 3.253 | 25720.0 |
| 947 | 2023-04-06 10:02:15 | aphid | 3 | 83667 | 625 | 3.576 | 23396.8 |
| 946 | 2023-04-02 01:38:05 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 945 | 2023-03-29 21:43:12 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 944 | 2023-03-26 10:58:54 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 943 | 2023-01-15 05:42:20 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 942 | 2023-01-13 09:17:30 | aphid | 3 | 83667 | 625 | 3.266 | 25617.6 |
| 941 | 2022-12-14 15:31:39 | aphid | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 940 | 2022-12-11 11:29:48 | aphid | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 939 | 2022-11-04 12:07:17 | aphid | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 938 | 2022-10-19 14:25:04 | aphid | 3 | 83667 | 625 | 3.593 | 23286.1 |
| 937 | 2022-09-14 06:31:32 | aphid | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 936 | 2022-09-04 18:48:39 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 935 | 2022-09-01 14:49:35 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 934 | 2022-08-28 04:17:42 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 933 | 2022-08-21 03:54:28 | aphid | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 932 | 2022-08-14 19:44:18 | aphid | 1 | 28756 | 3 | 0.450 | 63902.2 |
| 931 | 2022-08-06 12:39:01 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 930 | 2022-06-24 03:08:47 | aphid | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 929 | 2022-06-09 06:10:23 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 928 | 2022-05-30 02:07:37 | aphid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 927 | 2022-05-25 16:51:08 | aphid | 3 | 83667 | 625 | 4.033 | 20745.6 |
| 926 | 2022-05-21 11:39:23 | aphid | 3 | 83667 | 625 | 3.436 | 24350.1 |
| 925 | 2022-05-08 18:29:16 | aphid | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 924 | 2022-05-01 08:32:26 | aphid | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 923 | 2022-04-04 02:07:51 | aphid | 2 | 53800 | 39 | 1.376 | 39098.8 |
| 922 | 2022-03-01 09:50:41 | aphid | 1 | 28756 | 3 | 0.626 | 45936.1 |
| 921 | 2022-02-03 19:25:45 | aphid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 920 | 2022-01-16 11:48:58 | aphid | 3 | 83667 | 625 | 3.796 | 22040.8 |
| 919 | 2021-12-15 11:11:46 | aphid | 2 | 53800 | 39 | 1.703 | 31591.3 |
| 918 | 2021-12-14 00:48:06 | aphid | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 917 | 2021-12-13 08:43:59 | aphid | 2 | 53800 | 39 | 1.466 | 36698.5 |
| 916 | 2021-12-11 23:54:28 | aphid | 1 | 28756 | 3 | 0.796 | 36125.6 |
| 915 | 2021-11-03 02:35:36 | aphid | 1 | 28756 | 3 | 0.560 | 51350.0 |
| 914 | 2021-10-19 04:59:07 | aphid | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 913 | 2021-10-14 10:52:14 | aphid | 2 | 53800 | 39 | 1.903 | 28271.2 |
| 912 | 2021-09-22 08:17:04 | aphid | 1 | 28756 | 3 | 0.546 | 52666.7 |