History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"focal"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1010 | 2024-04-19 18:19:47 | focal | 3 | 83667 | 981 | 11.330 | 7384.6 |
| 1009 | 2024-04-02 22:00:55 | focal | 2 | 53800 | 84 | 1.860 | 28924.7 |
| 1008 | 2024-04-02 21:22:43 | focal | 3 | 83667 | 981 | 4.316 | 19385.3 |
| 1007 | 2024-04-02 21:22:41 | focal | 2 | 53800 | 84 | 1.610 | 33416.1 |
| 1006 | 2024-04-02 21:22:27 | focal | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1005 | 2024-03-31 08:22:39 | focal | 3 | 83667 | 981 | 4.156 | 20131.6 |
| 1004 | 2024-03-31 08:22:40 | focal | 2 | 53800 | 84 | 1.966 | 27365.2 |
| 1003 | 2024-03-31 08:22:36 | focal | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1002 | 2024-03-31 08:22:22 | focal | 3 | 83667 | 981 | 4.283 | 19534.7 |
| 1001 | 2024-03-31 08:22:20 | focal | 2 | 53800 | 84 | 3.560 | 15112.4 |
| 1000 | 2024-03-31 08:22:03 | focal | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 999 | 2024-03-29 02:35:55 | focal | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 998 | 2024-03-09 11:04:40 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 997 | 2024-03-05 10:27:16 | focal | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 996 | 2024-03-01 05:58:41 | focal | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 995 | 2024-02-28 05:14:50 | focal | 3 | 83667 | 981 | 14.110 | 5929.6 |
| 994 | 2024-02-28 01:17:35 | focal | 2 | 53800 | 84 | 1.670 | 32215.6 |
| 993 | 2024-02-28 01:17:05 | focal | 3 | 83667 | 981 | 4.266 | 19612.5 |
| 992 | 2024-02-28 01:12:33 | focal | 3 | 83667 | 981 | 4.216 | 19845.1 |
| 991 | 2024-02-28 01:12:31 | focal | 2 | 53800 | 84 | 2.233 | 24093.1 |
| 990 | 2024-02-28 01:12:27 | focal | 1 | 28756 | 5 | 1.000 | 28756.0 |
| 989 | 2024-01-29 06:02:16 | focal | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 988 | 2024-01-28 20:01:49 | focal | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 987 | 2024-01-17 04:55:44 | focal | 3 | 83667 | 981 | 3.906 | 21420.1 |
| 986 | 2023-12-21 23:51:48 | focal | 3 | 83667 | 981 | 3.813 | 21942.6 |
| 985 | 2023-12-21 23:51:50 | focal | 2 | 53800 | 84 | 1.623 | 33148.5 |
| 984 | 2023-12-16 05:38:36 | focal | 3 | 83667 | 981 | 3.953 | 21165.4 |
| 983 | 2023-12-09 21:25:50 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 982 | 2023-11-26 22:09:09 | focal | 3 | 83667 | 981 | 3.186 | 26260.8 |
| 981 | 2023-11-26 22:09:04 | focal | 2 | 53800 | 84 | 1.516 | 35488.1 |
| 980 | 2023-11-25 00:36:15 | focal | 3 | 83667 | 981 | 3.233 | 25879.1 |
| 979 | 2023-11-25 00:36:12 | focal | 2 | 53800 | 84 | 1.373 | 39184.3 |
| 978 | 2023-11-16 10:14:00 | focal | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 977 | 2023-11-12 04:09:30 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 976 | 2023-11-10 02:53:27 | focal | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 975 | 2023-11-03 15:10:17 | focal | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 974 | 2023-10-21 22:37:27 | focal | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 973 | 2023-10-19 01:24:16 | focal | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 972 | 2023-10-13 17:59:48 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 971 | 2023-10-04 16:25:30 | focal | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 970 | 2023-09-28 22:49:56 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 969 | 2023-09-26 09:40:18 | focal | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 968 | 2023-09-24 08:26:54 | focal | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 967 | 2023-09-16 06:51:33 | focal | 3 | 83667 | 981 | 3.263 | 25641.1 |
| 966 | 2023-08-06 19:13:10 | focal | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 965 | 2023-07-22 05:07:58 | focal | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 964 | 2023-07-08 17:23:03 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 963 | 2023-06-22 20:32:14 | focal | 3 | 83667 | 981 | 3.873 | 21602.6 |
| 962 | 2023-06-19 18:07:12 | focal | 3 | 83667 | 981 | 3.216 | 26015.9 |
| 961 | 2023-04-29 05:56:48 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 960 | 2023-04-22 04:20:23 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 959 | 2023-03-15 12:47:07 | focal | 3 | 83667 | 981 | 3.936 | 21256.9 |
| 958 | 2023-02-10 18:26:28 | focal | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 957 | 2023-01-16 22:14:52 | focal | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 956 | 2023-01-13 05:03:14 | focal | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 955 | 2022-12-18 20:21:03 | focal | 3 | 83667 | 981 | 6.830 | 12249.9 |
| 954 | 2022-12-08 08:20:20 | focal | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 953 | 2022-09-29 06:35:10 | focal | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 952 | 2022-08-18 12:54:07 | focal | 3 | 83667 | 981 | 3.750 | 22311.2 |
| 951 | 2022-08-13 01:10:42 | focal | 3 | 83667 | 981 | 3.203 | 26121.4 |
| 950 | 2022-08-11 12:50:25 | focal | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 949 | 2022-08-09 03:02:27 | focal | 1 | 28756 | 5 | 0.450 | 63902.2 |
| 948 | 2022-06-12 06:24:53 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 947 | 2022-05-08 22:10:52 | focal | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 946 | 2022-04-01 04:05:04 | focal | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 945 | 2022-03-31 16:45:35 | focal | 1 | 28756 | 5 | 0.593 | 48492.4 |
| 944 | 2022-02-25 04:41:56 | focal | 1 | 28756 | 5 | 0.550 | 52283.6 |
| 943 | 2022-01-04 10:31:45 | focal | 1 | 28756 | 5 | 0.580 | 49579.3 |
| 942 | 2021-11-22 20:19:27 | focal | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 941 | 2021-11-17 01:31:38 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 940 | 2021-11-04 19:46:26 | focal | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 939 | 2021-10-07 01:53:13 | focal | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 938 | 2021-08-17 11:29:27 | focal | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 937 | 2021-06-29 16:53:45 | focal | 3 | 83667 | 981 | 5.903 | 14173.6 |
| 936 | 2021-06-26 04:43:27 | focal | 3 | 83667 | 981 | 3.766 | 22216.4 |
| 935 | 2021-06-12 01:24:09 | focal | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 934 | 2021-05-16 20:28:32 | focal | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 933 | 2021-05-13 23:25:53 | focal | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 932 | 2021-04-02 06:42:34 | focal | 3 | 83667 | 981 | 3.640 | 22985.4 |
| 931 | 2021-03-21 11:27:14 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 930 | 2021-03-17 04:49:03 | focal | 3 | 83667 | 981 | 3.406 | 24564.6 |
| 929 | 2021-02-10 20:02:31 | focal | 3 | 83667 | 981 | 3.593 | 23286.1 |
| 928 | 2021-02-09 19:48:47 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 927 | 2021-01-31 03:23:36 | focal | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 926 | 2021-01-03 05:32:50 | focal | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 925 | 2020-11-19 15:17:36 | focal | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 924 | 2020-11-08 16:23:39 | focal | 3 | 83667 | 981 | 5.453 | 15343.3 |
| 923 | 2020-11-08 04:12:24 | focal | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 922 | 2020-11-06 08:30:56 | focal | 2 | 53800 | 84 | 1.376 | 39098.8 |
| 921 | 2020-11-02 12:02:48 | focal | 3 | 83667 | 981 | 4.170 | 20064.0 |
| 920 | 2020-10-27 06:11:13 | focal | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 919 | 2020-10-18 08:18:27 | focal | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 918 | 2020-09-03 11:22:22 | focal | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 917 | 2020-08-11 06:17:07 | focal | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 916 | 2020-07-24 09:42:27 | focal | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 915 | 2020-05-12 08:46:07 | focal | 3 | 83667 | 981 | 4.000 | 20916.8 |
| 914 | 2020-04-25 17:07:58 | focal | 3 | 83667 | 981 | 3.656 | 22884.8 |
| 913 | 2020-04-22 06:01:45 | focal | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 912 | 2020-04-08 12:19:05 | focal | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 911 | 2020-03-29 17:54:15 | focal | 3 | 83667 | 981 | 4.063 | 20592.4 |