History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clinic"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1074 | 2024-04-16 20:15:37 | clinic | 1 | 48755 | 5 | 2.186 | 22303.3 |
| 1073 | 2024-04-13 19:53:35 | clinic | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 1072 | 2024-04-01 07:56:31 | clinic | 1 | 48755 | 5 | 1.780 | 27390.4 |
| 1071 | 2024-03-11 12:21:09 | clinic | 3 | 112716 | 392 | 17.626 | 6394.9 |
| 1070 | 2024-03-08 22:35:36 | clinic | 2 | 82551 | 37 | 2.750 | 30018.5 |
| 1069 | 2024-03-08 22:34:48 | clinic | 3 | 112716 | 392 | 6.453 | 17467.2 |
| 1068 | 2024-03-07 03:45:09 | clinic | 3 | 112716 | 392 | 12.923 | 8722.1 |
| 1067 | 2024-03-06 08:30:33 | clinic | 3 | 112716 | 392 | 10.830 | 10407.8 |
| 1066 | 2024-03-05 22:58:15 | clinic | 2 | 82551 | 37 | 8.156 | 10121.5 |
| 1065 | 2024-03-05 21:23:12 | clinic | 1 | 48755 | 5 | 1.796 | 27146.4 |
| 1064 | 2024-03-05 15:59:07 | clinic | 2 | 82551 | 37 | 5.310 | 15546.3 |
| 1063 | 2024-03-05 15:57:55 | clinic | 3 | 112716 | 392 | 6.296 | 17902.8 |
| 1062 | 2024-03-05 15:13:45 | clinic | 3 | 112716 | 392 | 10.016 | 11253.6 |
| 1061 | 2024-03-02 13:16:19 | clinic | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 1060 | 2024-03-01 14:56:27 | clinic | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 1059 | 2024-02-28 08:44:04 | clinic | 1 | 48755 | 5 | 2.546 | 19149.6 |
| 1058 | 2024-02-03 04:42:30 | clinic | 3 | 112716 | 392 | 7.846 | 14366.0 |
| 1057 | 2024-02-03 04:42:26 | clinic | 2 | 82551 | 37 | 5.063 | 16304.8 |
| 1056 | 2024-02-02 18:48:17 | clinic | 2 | 82551 | 37 | 2.596 | 31799.3 |
| 1055 | 2024-02-01 13:28:28 | clinic | 2 | 82551 | 37 | 2.296 | 35954.3 |
| 1054 | 2024-02-01 13:26:04 | clinic | 3 | 112716 | 392 | 5.406 | 20850.2 |
| 1053 | 2024-02-01 11:29:56 | clinic | 2 | 82551 | 37 | 2.123 | 38884.1 |
| 1052 | 2024-02-01 10:56:35 | clinic | 3 | 112716 | 392 | 6.186 | 18221.1 |
| 1051 | 2024-02-01 10:56:32 | clinic | 3 | 112716 | 392 | 5.356 | 21044.8 |
| 1050 | 2024-01-24 19:27:49 | clinic | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 1049 | 2024-01-01 21:56:15 | clinic | 3 | 112716 | 392 | 5.140 | 21929.2 |
| 1048 | 2023-12-31 22:35:23 | clinic | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 1047 | 2023-12-31 21:56:25 | clinic | 3 | 112716 | 392 | 5.296 | 21283.2 |
| 1046 | 2023-12-28 00:41:20 | clinic | 3 | 112716 | 392 | 4.920 | 22909.8 |
| 1045 | 2023-12-26 23:41:11 | clinic | 3 | 112716 | 392 | 5.360 | 21029.1 |
| 1044 | 2023-12-25 03:06:54 | clinic | 3 | 112716 | 392 | 5.436 | 20735.1 |
| 1043 | 2023-12-24 00:20:12 | clinic | 3 | 112716 | 392 | 5.406 | 20850.2 |
| 1042 | 2023-12-23 05:56:37 | clinic | 2 | 82551 | 37 | 2.220 | 37185.1 |
| 1041 | 2023-12-21 19:52:56 | clinic | 3 | 112716 | 392 | 4.813 | 23419.1 |
| 1040 | 2023-12-20 12:33:14 | clinic | 3 | 112716 | 392 | 4.766 | 23650.0 |
| 1039 | 2023-12-19 22:03:11 | clinic | 3 | 112716 | 392 | 5.593 | 20153.0 |
| 1038 | 2023-12-19 07:11:41 | clinic | 3 | 112716 | 392 | 5.250 | 21469.7 |
| 1037 | 2023-12-18 21:57:43 | clinic | 3 | 112716 | 392 | 5.266 | 21404.5 |
| 1036 | 2023-12-18 03:26:45 | clinic | 3 | 112716 | 392 | 5.453 | 20670.5 |
| 1035 | 2023-12-17 04:24:31 | clinic | 3 | 112716 | 392 | 4.703 | 23966.8 |
| 1034 | 2023-12-16 02:27:02 | clinic | 3 | 112716 | 392 | 5.456 | 20659.1 |
| 1033 | 2023-12-15 20:46:52 | clinic | 2 | 82551 | 37 | 2.940 | 28078.6 |
| 1032 | 2023-12-14 05:24:03 | clinic | 3 | 112716 | 392 | 6.063 | 18590.8 |
| 1031 | 2023-12-13 07:49:15 | clinic | 3 | 112716 | 392 | 5.030 | 22408.7 |
| 1030 | 2023-12-11 09:21:25 | clinic | 3 | 112716 | 392 | 5.156 | 21861.1 |
| 1029 | 2023-12-10 08:23:25 | clinic | 3 | 112716 | 392 | 5.140 | 21929.2 |
| 1028 | 2023-11-26 21:25:36 | clinic | 3 | 112716 | 392 | 5.373 | 20978.2 |
| 1027 | 2023-11-25 21:21:33 | clinic | 3 | 112716 | 392 | 5.420 | 20796.3 |
| 1026 | 2023-11-25 08:12:10 | clinic | 2 | 82551 | 37 | 2.530 | 32628.9 |
| 1025 | 2023-11-22 20:55:49 | clinic | 3 | 112716 | 392 | 5.033 | 22395.4 |
| 1024 | 2023-11-21 20:53:04 | clinic | 3 | 112716 | 392 | 5.453 | 20670.5 |
| 1023 | 2023-11-20 20:52:18 | clinic | 3 | 112716 | 392 | 5.970 | 18880.4 |
| 1022 | 2023-11-19 20:50:25 | clinic | 3 | 112716 | 392 | 5.843 | 19290.8 |
| 1021 | 2023-11-18 20:50:34 | clinic | 3 | 112716 | 392 | 13.593 | 8292.2 |
| 1020 | 2023-11-17 20:29:39 | clinic | 3 | 112716 | 392 | 4.843 | 23274.0 |
| 1019 | 2023-11-17 01:09:28 | clinic | 3 | 112716 | 392 | 5.140 | 21929.2 |
| 1018 | 2023-11-16 20:40:13 | clinic | 3 | 112716 | 392 | 5.670 | 19879.4 |
| 1017 | 2023-11-15 21:17:49 | clinic | 3 | 112716 | 392 | 5.140 | 21929.2 |
| 1016 | 2023-11-14 19:33:45 | clinic | 3 | 112716 | 392 | 5.703 | 19764.3 |
| 1015 | 2023-11-13 19:36:13 | clinic | 3 | 112716 | 392 | 4.753 | 23714.7 |
| 1014 | 2023-11-13 16:39:42 | clinic | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 1013 | 2023-11-13 03:31:23 | clinic | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 1012 | 2023-11-12 04:45:05 | clinic | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 1011 | 2023-11-09 16:26:49 | clinic | 3 | 112716 | 392 | 5.360 | 21029.1 |
| 1010 | 2023-11-06 11:39:20 | clinic | 3 | 112716 | 392 | 5.203 | 21663.7 |
| 1009 | 2023-11-05 16:55:38 | clinic | 3 | 112716 | 392 | 4.736 | 23799.8 |
| 1008 | 2023-11-04 16:24:39 | clinic | 3 | 112716 | 392 | 4.923 | 22895.8 |
| 1007 | 2023-11-04 15:26:19 | clinic | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 1006 | 2023-11-04 14:02:04 | clinic | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 1005 | 2023-11-03 22:08:46 | clinic | 3 | 112716 | 392 | 4.656 | 24208.8 |
| 1004 | 2023-11-03 08:51:00 | clinic | 3 | 112716 | 392 | 5.936 | 18988.5 |
| 1003 | 2023-11-01 22:11:22 | clinic | 3 | 112716 | 392 | 6.656 | 16934.5 |
| 1002 | 2023-11-01 10:14:19 | clinic | 3 | 112716 | 392 | 5.000 | 22543.2 |
| 1001 | 2023-10-31 20:04:16 | clinic | 3 | 112716 | 392 | 6.123 | 18408.6 |
| 1000 | 2023-10-30 08:00:17 | clinic | 3 | 112716 | 392 | 5.283 | 21335.6 |
| 999 | 2023-10-29 20:31:18 | clinic | 3 | 112716 | 392 | 5.670 | 19879.4 |
| 998 | 2023-10-25 19:43:48 | clinic | 3 | 112716 | 392 | 6.610 | 17052.3 |
| 997 | 2023-10-20 05:15:50 | clinic | 3 | 112716 | 392 | 5.283 | 21335.6 |
| 996 | 2023-10-19 12:20:08 | clinic | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 995 | 2023-10-18 16:39:07 | clinic | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 994 | 2023-10-13 18:44:49 | clinic | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 993 | 2023-09-25 02:00:05 | clinic | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 992 | 2023-09-13 13:07:36 | clinic | 1 | 48755 | 5 | 0.966 | 50471.0 |
| 991 | 2023-08-19 17:54:07 | clinic | 3 | 112716 | 392 | 4.860 | 23192.6 |
| 990 | 2023-08-18 13:50:42 | clinic | 3 | 112716 | 392 | 4.670 | 24136.2 |
| 989 | 2023-08-17 08:37:54 | clinic | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 988 | 2023-08-16 21:31:45 | clinic | 3 | 112716 | 392 | 5.640 | 19985.1 |
| 987 | 2023-07-30 06:04:52 | clinic | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 986 | 2023-06-06 22:45:36 | clinic | 3 | 112716 | 392 | 5.830 | 19333.8 |
| 985 | 2023-06-05 12:12:13 | clinic | 3 | 112716 | 392 | 5.313 | 21215.1 |
| 984 | 2023-06-04 22:49:16 | clinic | 3 | 112716 | 392 | 4.766 | 23650.0 |
| 983 | 2023-06-01 12:00:35 | clinic | 3 | 112716 | 392 | 5.000 | 22543.2 |
| 982 | 2023-05-17 04:24:50 | clinic | 3 | 112716 | 392 | 4.906 | 22975.1 |
| 981 | 2023-05-14 00:36:05 | clinic | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 980 | 2023-05-06 16:16:54 | clinic | 3 | 112716 | 392 | 4.626 | 24365.8 |
| 979 | 2023-05-05 00:11:23 | clinic | 3 | 112716 | 392 | 4.906 | 22975.1 |
| 978 | 2023-04-21 21:33:55 | clinic | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 977 | 2023-04-13 19:27:48 | clinic | 3 | 112716 | 392 | 5.500 | 20493.8 |
| 976 | 2023-04-08 09:26:22 | clinic | 3 | 112716 | 392 | 5.170 | 21801.9 |
| 975 | 2023-03-18 18:01:52 | clinic | 3 | 112716 | 392 | 4.970 | 22679.3 |