History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"entry"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1011 | 2024-04-30 22:12:43 | entry | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1010 | 2024-04-29 23:13:57 | entry | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1009 | 2024-04-29 20:05:01 | entry | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1008 | 2024-04-28 22:25:11 | entry | 2 | 53800 | 55 | 2.716 | 19808.5 |
| 1007 | 2024-04-28 22:24:29 | entry | 3 | 83667 | 723 | 4.373 | 19132.6 |
| 1006 | 2024-04-28 19:52:39 | entry | 2 | 53800 | 55 | 1.623 | 33148.5 |
| 1005 | 2024-04-28 19:45:46 | entry | 3 | 83667 | 723 | 3.670 | 22797.5 |
| 1004 | 2024-04-28 17:03:05 | entry | 1 | 28756 | 3 | 0.576 | 49923.6 |
| 1003 | 2024-04-26 23:43:06 | entry | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1002 | 2024-04-26 10:57:47 | entry | 2 | 53800 | 55 | 2.890 | 18615.9 |
| 1001 | 2024-04-26 10:57:42 | entry | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1000 | 2024-04-26 10:57:41 | entry | 2 | 53800 | 55 | 1.580 | 34050.6 |
| 999 | 2024-04-26 10:57:19 | entry | 3 | 83667 | 723 | 4.033 | 20745.6 |
| 998 | 2024-04-26 10:57:13 | entry | 3 | 83667 | 723 | 3.766 | 22216.4 |
| 997 | 2024-04-26 04:58:44 | entry | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 996 | 2024-04-20 04:58:48 | entry | 3 | 83667 | 723 | 3.436 | 24350.1 |
| 995 | 2024-04-17 15:26:21 | entry | 1 | 28756 | 3 | 2.716 | 10587.6 |
| 994 | 2024-04-12 13:30:08 | entry | 2 | 53800 | 55 | 5.283 | 10183.6 |
| 993 | 2024-04-05 23:21:31 | entry | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 992 | 2024-03-31 15:57:44 | entry | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 991 | 2024-03-29 09:20:13 | entry | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 990 | 2024-03-07 20:00:09 | entry | 3 | 83667 | 723 | 4.266 | 19612.5 |
| 989 | 2024-03-06 23:41:33 | entry | 3 | 83667 | 723 | 9.580 | 8733.5 |
| 988 | 2024-03-06 23:41:33 | entry | 2 | 53800 | 55 | 1.843 | 29191.5 |
| 987 | 2024-03-06 19:29:22 | entry | 1 | 28756 | 3 | 1.140 | 25224.6 |
| 986 | 2024-03-02 20:34:51 | entry | 3 | 83667 | 723 | 3.656 | 22884.8 |
| 985 | 2024-03-01 12:54:19 | entry | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 984 | 2024-02-28 05:00:38 | entry | 3 | 83667 | 723 | 10.486 | 7978.9 |
| 983 | 2024-02-28 03:43:24 | entry | 2 | 53800 | 55 | 2.263 | 23773.8 |
| 982 | 2024-02-28 03:43:01 | entry | 3 | 83667 | 723 | 4.546 | 18404.5 |
| 981 | 2024-02-28 02:59:58 | entry | 2 | 53800 | 55 | 3.750 | 14346.7 |
| 980 | 2024-02-28 02:59:56 | entry | 3 | 83667 | 723 | 4.593 | 18216.2 |
| 979 | 2024-02-28 02:59:51 | entry | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 978 | 2024-02-03 19:05:47 | entry | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 977 | 2024-01-30 16:40:34 | entry | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 976 | 2024-01-29 09:16:08 | entry | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 975 | 2024-01-29 02:04:13 | entry | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 974 | 2024-01-17 09:53:37 | entry | 2 | 53800 | 55 | 1.623 | 33148.5 |
| 973 | 2024-01-17 09:44:24 | entry | 3 | 83667 | 723 | 3.673 | 22778.9 |
| 972 | 2023-12-21 15:38:26 | entry | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 971 | 2023-12-17 04:48:53 | entry | 3 | 83667 | 723 | 3.890 | 21508.2 |
| 970 | 2023-12-16 23:28:43 | entry | 3 | 83667 | 723 | 3.546 | 23594.8 |
| 969 | 2023-12-16 23:28:40 | entry | 2 | 53800 | 55 | 1.576 | 34137.1 |
| 968 | 2023-12-16 14:38:31 | entry | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 967 | 2023-12-13 11:09:59 | entry | 2 | 53800 | 55 | 1.516 | 35488.1 |
| 966 | 2023-12-08 12:37:16 | entry | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 965 | 2023-12-08 12:37:15 | entry | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 964 | 2023-11-25 22:12:51 | entry | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 963 | 2023-11-20 08:33:16 | entry | 3 | 83667 | 723 | 3.483 | 24021.5 |
| 962 | 2023-11-20 08:33:10 | entry | 2 | 53800 | 55 | 1.830 | 29398.9 |
| 961 | 2023-11-12 08:36:17 | entry | 3 | 83667 | 723 | 4.360 | 19189.7 |
| 960 | 2023-11-12 08:36:19 | entry | 2 | 53800 | 55 | 1.763 | 30516.2 |
| 959 | 2023-11-11 21:18:10 | entry | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 958 | 2023-11-08 05:02:58 | entry | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 957 | 2023-11-04 12:15:43 | entry | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 956 | 2023-11-02 07:25:53 | entry | 3 | 83667 | 723 | 12.063 | 6935.8 |
| 955 | 2023-11-02 07:25:48 | entry | 3 | 83667 | 723 | 8.173 | 10237.0 |
| 954 | 2023-11-02 07:25:51 | entry | 2 | 53800 | 55 | 4.750 | 11326.3 |
| 953 | 2023-11-02 07:25:47 | entry | 2 | 53800 | 55 | 2.983 | 18035.5 |
| 952 | 2023-11-02 06:19:03 | entry | 1 | 28756 | 3 | 1.093 | 26309.2 |
| 951 | 2023-10-28 18:12:53 | entry | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 950 | 2023-10-21 15:40:25 | entry | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 949 | 2023-10-20 16:27:41 | entry | 1 | 28756 | 3 | 0.423 | 67981.1 |
| 948 | 2023-10-13 11:05:45 | entry | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 947 | 2023-10-05 03:51:19 | entry | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 946 | 2023-09-23 12:28:30 | entry | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 945 | 2023-09-22 18:14:11 | entry | 3 | 83667 | 723 | 3.716 | 22515.3 |
| 944 | 2023-09-22 05:02:51 | entry | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 943 | 2023-09-18 02:10:29 | entry | 3 | 83667 | 723 | 3.763 | 22234.1 |
| 942 | 2023-09-12 08:09:15 | entry | 2 | 53800 | 55 | 1.546 | 34799.5 |
| 941 | 2023-09-11 10:05:01 | entry | 1 | 28756 | 3 | 0.593 | 48492.4 |
| 940 | 2023-08-07 07:40:38 | entry | 3 | 83667 | 723 | 3.470 | 24111.5 |
| 939 | 2023-07-16 07:54:25 | entry | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 938 | 2023-07-14 23:43:01 | entry | 3 | 83667 | 723 | 3.876 | 21585.9 |
| 937 | 2023-06-25 23:15:26 | entry | 3 | 83667 | 723 | 3.813 | 21942.6 |
| 936 | 2023-06-22 16:50:39 | entry | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 935 | 2023-06-01 15:57:42 | entry | 2 | 53800 | 55 | 1.640 | 32804.9 |
| 934 | 2023-05-29 20:33:32 | entry | 1 | 28756 | 3 | 0.423 | 67981.1 |
| 933 | 2023-05-04 18:51:53 | entry | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 932 | 2023-04-13 07:57:56 | entry | 3 | 83667 | 723 | 3.810 | 21959.8 |
| 931 | 2023-04-12 07:46:26 | entry | 3 | 83667 | 723 | 8.123 | 10300.0 |
| 930 | 2023-04-11 07:50:53 | entry | 3 | 83667 | 723 | 3.876 | 21585.9 |
| 929 | 2023-04-10 07:50:10 | entry | 3 | 83667 | 723 | 3.280 | 25508.2 |
| 928 | 2023-04-09 07:49:51 | entry | 3 | 83667 | 723 | 3.936 | 21256.9 |
| 927 | 2023-04-08 15:57:45 | entry | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 926 | 2023-04-08 07:55:30 | entry | 3 | 83667 | 723 | 3.453 | 24230.2 |
| 925 | 2023-04-07 07:44:48 | entry | 3 | 83667 | 723 | 3.626 | 23074.2 |
| 924 | 2023-04-06 12:48:53 | entry | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 923 | 2023-04-04 08:20:43 | entry | 3 | 83667 | 723 | 3.906 | 21420.1 |
| 922 | 2023-04-03 20:16:23 | entry | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 921 | 2023-04-03 07:40:34 | entry | 3 | 83667 | 723 | 3.843 | 21771.3 |
| 920 | 2023-04-02 07:39:57 | entry | 3 | 83667 | 723 | 3.530 | 23701.7 |
| 919 | 2023-04-01 07:39:52 | entry | 3 | 83667 | 723 | 3.720 | 22491.1 |
| 918 | 2023-03-31 07:38:15 | entry | 3 | 83667 | 723 | 8.266 | 10121.8 |
| 917 | 2023-03-30 07:29:12 | entry | 3 | 83667 | 723 | 4.390 | 19058.5 |
| 916 | 2023-03-29 07:33:48 | entry | 3 | 83667 | 723 | 4.126 | 20278.0 |
| 915 | 2023-03-28 07:30:33 | entry | 3 | 83667 | 723 | 4.106 | 20376.8 |
| 914 | 2023-03-27 20:20:45 | entry | 3 | 83667 | 723 | 3.283 | 25484.9 |
| 913 | 2023-03-27 08:31:34 | entry | 3 | 83667 | 723 | 6.906 | 12115.1 |
| 912 | 2023-03-26 08:28:21 | entry | 3 | 83667 | 723 | 4.236 | 19751.4 |