History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"alan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1164 | 2024-05-05 12:44:29 | alan | 1 | 13983 | 16 | 0.283 | 49409.9 |
1163 | 2024-05-05 09:53:30 | alan | 1 | 13983 | 16 | 0.780 | 17926.9 |
1162 | 2024-05-05 01:40:05 | alan | 1 | 13983 | 16 | 0.266 | 52567.7 |
1161 | 2024-05-01 17:31:14 | alan | 1 | 13983 | 16 | 0.563 | 24836.6 |
1160 | 2024-04-30 06:00:06 | alan | 1 | 13983 | 16 | 0.546 | 25609.9 |
1159 | 2024-04-26 23:39:27 | alan | 1 | 13983 | 16 | 0.266 | 52567.7 |
1158 | 2024-04-26 23:14:45 | alan | 1 | 13983 | 16 | 0.670 | 20870.1 |
1157 | 2024-04-25 07:53:16 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1156 | 2024-04-06 10:32:27 | alan | 1 | 13983 | 16 | 0.326 | 42892.6 |
1155 | 2024-04-05 00:34:57 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1154 | 2024-03-31 02:37:32 | alan | 1 | 13983 | 16 | 0.546 | 25609.9 |
1153 | 2024-03-27 04:35:48 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1152 | 2024-03-23 13:37:36 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1151 | 2024-03-05 19:55:49 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1150 | 2024-03-02 18:16:22 | alan | 2 | 29872 | 291 | 1.140 | 26203.5 |
1149 | 2024-03-02 17:30:33 | alan | 1 | 13983 | 16 | 0.263 | 53167.3 |
1148 | 2024-02-25 17:06:55 | alan | 1 | 13983 | 16 | 0.233 | 60012.9 |
1147 | 2024-02-05 19:32:09 | alan | 1 | 13983 | 16 | 0.233 | 60012.9 |
1146 | 2024-02-03 02:34:22 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1145 | 2023-12-24 18:30:25 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1144 | 2023-12-24 13:32:56 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1143 | 2023-12-21 06:03:01 | alan | 2 | 29872 | 291 | 0.780 | 38297.4 |
1142 | 2023-12-20 14:07:10 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1141 | 2023-12-01 21:05:40 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1140 | 2023-11-29 21:54:11 | alan | 1 | 13983 | 16 | 0.236 | 59250.0 |
1139 | 2023-11-23 04:49:39 | alan | 2 | 29872 | 291 | 0.923 | 32364.0 |
1138 | 2023-11-21 07:57:42 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1137 | 2023-11-17 18:36:51 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1136 | 2023-11-12 13:43:48 | alan | 1 | 13983 | 16 | 0.233 | 60012.9 |
1135 | 2023-11-09 06:10:39 | alan | 1 | 13983 | 16 | 0.263 | 53167.3 |
1134 | 2023-10-31 04:05:07 | alan | 2 | 29872 | 291 | 0.876 | 34100.5 |
1133 | 2023-10-26 10:55:25 | alan | 2 | 29872 | 291 | 0.890 | 33564.0 |
1132 | 2023-10-25 23:50:23 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1131 | 2023-10-24 10:48:55 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1130 | 2023-10-20 04:27:50 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1129 | 2023-10-17 03:09:34 | alan | 1 | 13983 | 16 | 0.236 | 59250.0 |
1128 | 2023-10-13 22:57:05 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1127 | 2023-10-11 17:28:18 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1126 | 2023-10-03 17:45:12 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1125 | 2023-09-22 22:04:58 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1124 | 2023-09-12 18:30:19 | alan | 2 | 29872 | 291 | 0.936 | 31914.5 |
1123 | 2023-09-10 13:14:07 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1122 | 2023-09-10 10:00:32 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1121 | 2023-08-26 09:19:22 | alan | 1 | 13983 | 16 | 0.266 | 52567.7 |
1120 | 2023-08-11 14:40:20 | alan | 1 | 13983 | 16 | 0.233 | 60012.9 |
1119 | 2023-08-07 19:05:11 | alan | 1 | 13983 | 16 | 0.233 | 60012.9 |
1118 | 2023-06-30 13:51:12 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1117 | 2023-06-24 14:09:10 | alan | 1 | 13983 | 16 | 0.233 | 60012.9 |
1116 | 2023-05-23 01:47:14 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1115 | 2023-05-13 01:07:03 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1114 | 2023-03-14 07:57:51 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1113 | 2023-02-20 09:53:54 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1112 | 2022-11-26 09:44:29 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1111 | 2022-11-17 13:11:05 | alan | 1 | 13983 | 16 | 0.280 | 49939.3 |
1110 | 2022-11-13 22:29:32 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1109 | 2022-09-19 13:52:44 | alan | 1 | 13983 | 16 | 0.236 | 59250.0 |
1108 | 2022-09-18 10:35:35 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1107 | 2022-09-11 19:50:57 | alan | 1 | 13983 | 16 | 0.266 | 52567.7 |
1106 | 2022-09-10 09:18:02 | alan | 1 | 13983 | 16 | 0.233 | 60012.9 |
1105 | 2022-09-09 10:34:14 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1104 | 2022-09-03 12:36:07 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1103 | 2022-09-03 10:33:00 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1102 | 2022-09-01 10:35:10 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1101 | 2022-08-27 22:03:34 | alan | 2 | 29872 | 291 | 0.906 | 32971.3 |
1100 | 2022-08-25 22:19:35 | alan | 1 | 13983 | 16 | 0.236 | 59250.0 |
1099 | 2022-08-23 15:39:29 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1098 | 2022-08-23 09:25:24 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1097 | 2022-08-18 07:41:41 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1096 | 2022-08-14 22:49:32 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1095 | 2022-08-10 18:08:57 | alan | 1 | 13983 | 16 | 0.236 | 59250.0 |
1094 | 2022-08-10 12:50:42 | alan | 1 | 13983 | 16 | 0.360 | 38841.7 |
1093 | 2022-08-06 15:49:30 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1092 | 2022-08-06 11:21:20 | alan | 1 | 13983 | 16 | 0.233 | 60012.9 |
1091 | 2022-08-06 04:53:41 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1090 | 2022-07-29 20:57:26 | alan | 1 | 13983 | 16 | 0.500 | 27966.0 |
1089 | 2022-07-28 18:36:03 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1088 | 2022-07-28 13:46:04 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1087 | 2022-07-21 19:06:42 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1086 | 2022-07-17 17:02:43 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1085 | 2022-07-09 21:04:55 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1084 | 2022-07-03 04:17:16 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1083 | 2022-07-02 06:11:48 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1082 | 2022-06-16 04:26:27 | alan | 1 | 13983 | 16 | 0.233 | 60012.9 |
1081 | 2022-06-15 17:45:26 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1080 | 2022-06-15 15:02:01 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1079 | 2022-06-08 12:32:25 | alan | 1 | 13983 | 16 | 0.236 | 59250.0 |
1078 | 2022-06-01 08:56:16 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1077 | 2022-05-26 01:14:38 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1076 | 2022-05-25 13:44:24 | alan | 1 | 13983 | 16 | 0.313 | 44674.1 |
1075 | 2022-05-08 04:17:14 | alan | 1 | 13983 | 16 | 0.216 | 64736.1 |
1074 | 2022-04-24 18:27:13 | alan | 1 | 13983 | 16 | 0.250 | 55932.0 |
1073 | 2022-03-19 02:07:31 | alan | 1 | 13983 | 16 | 0.266 | 52567.7 |
1072 | 2022-02-23 09:31:47 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1071 | 2022-02-14 21:44:45 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1070 | 2022-02-03 07:27:19 | alan | 1 | 13983 | 16 | 0.343 | 40766.8 |
1069 | 2022-02-01 00:57:10 | alan | 2 | 29872 | 291 | 0.890 | 33564.0 |
1068 | 2021-12-27 03:46:45 | alan | 1 | 13983 | 16 | 0.403 | 34697.3 |
1067 | 2021-11-15 08:37:24 | alan | 1 | 13983 | 16 | 0.263 | 53167.3 |
1066 | 2021-11-13 06:31:03 | alan | 1 | 13983 | 16 | 0.220 | 63559.1 |
1065 | 2021-11-02 07:48:25 | alan | 2 | 29872 | 291 | 0.783 | 38150.7 |