History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crannied"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
236 | 2024-05-04 15:20:09 | crannied | 1 | 82945 | 2 | 1.626 | 51011.7 |
235 | 2024-05-01 08:42:03 | crannied | 3 | 146162 | 199 | 22.720 | 6433.2 |
234 | 2024-04-30 13:50:53 | crannied | 2 | 121059 | 17 | 12.623 | 9590.4 |
233 | 2024-04-30 09:00:10 | crannied | 3 | 146162 | 199 | 24.796 | 5894.6 |
232 | 2024-04-30 09:00:04 | crannied | 2 | 121059 | 17 | 7.626 | 15874.5 |
231 | 2024-04-30 08:17:09 | crannied | 1 | 82945 | 2 | 1.576 | 52630.1 |
230 | 2024-04-08 13:55:50 | crannied | 3 | 146162 | 199 | 12.360 | 11825.4 |
229 | 2024-04-06 02:12:41 | crannied | 1 | 82945 | 2 | 2.830 | 29309.2 |
228 | 2024-04-06 00:41:35 | crannied | 3 | 146162 | 199 | 11.766 | 12422.4 |
227 | 2024-04-05 07:10:34 | crannied | 3 | 146162 | 199 | 24.173 | 6046.5 |
226 | 2024-04-05 07:10:37 | crannied | 2 | 121059 | 17 | 17.033 | 7107.3 |
225 | 2024-04-05 07:10:32 | crannied | 1 | 82945 | 2 | 4.860 | 17066.9 |
224 | 2024-03-31 23:48:41 | crannied | 2 | 121059 | 17 | 10.080 | 12009.8 |
223 | 2024-03-31 23:48:37 | crannied | 1 | 82945 | 2 | 1.563 | 53067.8 |
222 | 2024-03-31 23:48:21 | crannied | 3 | 146162 | 199 | 8.703 | 16794.4 |
221 | 2024-03-31 06:12:53 | crannied | 3 | 146162 | 199 | 19.186 | 7618.2 |
220 | 2024-03-31 06:12:54 | crannied | 2 | 121059 | 17 | 12.456 | 9718.9 |
219 | 2024-03-31 06:10:41 | crannied | 1 | 82945 | 2 | 3.250 | 25521.5 |
218 | 2024-03-15 05:56:51 | crannied | 1 | 82945 | 2 | 3.280 | 25288.1 |
217 | 2024-03-04 08:43:42 | crannied | 1 | 82945 | 2 | 5.030 | 16490.1 |
216 | 2024-03-01 03:14:42 | crannied | 1 | 82945 | 2 | 1.593 | 52068.4 |
215 | 2024-01-30 22:44:52 | crannied | 1 | 82945 | 2 | 1.516 | 54713.1 |
214 | 2024-01-18 09:28:29 | crannied | 1 | 82945 | 2 | 1.313 | 63172.1 |
213 | 2024-01-13 02:38:17 | crannied | 2 | 121059 | 17 | 3.593 | 33693.0 |
212 | 2023-12-22 18:00:05 | crannied | 1 | 82945 | 2 | 1.436 | 57761.1 |
211 | 2023-12-22 07:49:58 | crannied | 2 | 121059 | 17 | 3.326 | 36397.8 |
210 | 2023-12-09 14:14:35 | crannied | 1 | 82945 | 2 | 1.423 | 58288.8 |
209 | 2023-12-08 04:05:02 | crannied | 1 | 82945 | 2 | 1.420 | 58412.0 |
208 | 2023-11-16 02:19:24 | crannied | 1 | 82945 | 2 | 1.296 | 64000.8 |
207 | 2023-11-11 22:36:24 | crannied | 1 | 82945 | 2 | 2.313 | 35860.4 |
206 | 2023-11-03 05:20:57 | crannied | 1 | 82945 | 2 | 1.313 | 63172.1 |
205 | 2023-10-30 08:38:09 | crannied | 1 | 82945 | 2 | 1.390 | 59672.7 |
204 | 2023-10-29 11:04:15 | crannied | 2 | 121059 | 17 | 4.123 | 29361.9 |
203 | 2023-10-20 04:04:27 | crannied | 2 | 121059 | 17 | 3.783 | 32000.8 |
202 | 2023-10-17 17:11:35 | crannied | 1 | 82945 | 2 | 1.466 | 56579.1 |
201 | 2023-09-24 17:47:20 | crannied | 3 | 146162 | 199 | 7.390 | 19778.3 |
200 | 2023-09-24 17:47:19 | crannied | 2 | 121059 | 17 | 3.563 | 33976.7 |
199 | 2023-09-19 11:50:36 | crannied | 1 | 82945 | 2 | 1.313 | 63172.1 |
198 | 2023-09-15 07:52:54 | crannied | 1 | 82945 | 2 | 1.546 | 53651.4 |
197 | 2023-09-03 23:42:55 | crannied | 1 | 82945 | 2 | 1.470 | 56425.2 |
196 | 2023-08-08 18:05:45 | crannied | 1 | 82945 | 2 | 1.313 | 63172.1 |
195 | 2023-07-30 16:56:30 | crannied | 2 | 121059 | 17 | 3.343 | 36212.7 |
194 | 2023-04-20 02:24:01 | crannied | 1 | 82945 | 2 | 1.313 | 63172.1 |
193 | 2023-04-09 11:11:36 | crannied | 2 | 121059 | 17 | 3.656 | 33112.4 |
192 | 2023-02-20 18:00:33 | crannied | 1 | 82945 | 2 | 1.280 | 64800.8 |
191 | 2023-01-06 23:33:39 | crannied | 2 | 121059 | 17 | 3.233 | 37444.8 |
190 | 2023-01-03 23:19:38 | crannied | 1 | 82945 | 2 | 1.280 | 64800.8 |
189 | 2022-12-18 15:54:29 | crannied | 1 | 82945 | 2 | 1.280 | 64800.8 |
188 | 2022-09-11 16:21:16 | crannied | 2 | 121059 | 17 | 3.233 | 37444.8 |
187 | 2022-09-06 00:02:38 | crannied | 1 | 82945 | 2 | 1.266 | 65517.4 |
186 | 2022-09-02 16:55:40 | crannied | 1 | 82945 | 2 | 1.330 | 62364.7 |
185 | 2022-08-30 12:06:05 | crannied | 1 | 82945 | 2 | 1.500 | 55296.7 |
184 | 2022-08-28 02:58:44 | crannied | 1 | 82945 | 2 | 1.296 | 64000.8 |
183 | 2022-04-26 13:34:51 | crannied | 1 | 82945 | 2 | 1.423 | 58288.8 |
182 | 2022-04-22 22:21:26 | crannied | 1 | 82945 | 2 | 1.406 | 58993.6 |
181 | 2022-04-12 20:33:00 | crannied | 1 | 82945 | 2 | 1.563 | 53067.8 |
180 | 2022-01-12 21:11:50 | crannied | 1 | 82945 | 2 | 1.533 | 54106.3 |
179 | 2022-01-09 23:43:58 | crannied | 1 | 82945 | 2 | 1.470 | 56425.2 |
178 | 2021-11-10 22:41:54 | crannied | 1 | 82945 | 2 | 1.440 | 57600.7 |
177 | 2021-10-30 20:18:43 | crannied | 1 | 82945 | 2 | 1.500 | 55296.7 |
176 | 2021-10-29 18:58:12 | crannied | 1 | 82945 | 2 | 1.470 | 56425.2 |
175 | 2021-10-15 05:53:08 | crannied | 1 | 82945 | 2 | 1.343 | 61761.0 |
174 | 2021-09-30 13:25:17 | crannied | 1 | 82945 | 2 | 1.533 | 54106.3 |
173 | 2021-09-21 19:26:39 | crannied | 1 | 82945 | 2 | 1.813 | 45750.1 |
172 | 2021-09-21 02:14:39 | crannied | 1 | 82945 | 2 | 1.500 | 55296.7 |
171 | 2021-09-20 12:38:30 | crannied | 1 | 82945 | 2 | 1.420 | 58412.0 |
170 | 2021-09-14 05:17:10 | crannied | 1 | 82945 | 2 | 1.453 | 57085.3 |
169 | 2021-07-01 04:02:28 | crannied | 1 | 82945 | 2 | 1.330 | 62364.7 |
168 | 2021-05-03 07:39:40 | crannied | 1 | 82945 | 2 | 3.093 | 26817.0 |
167 | 2021-04-29 20:53:56 | crannied | 1 | 82945 | 2 | 1.500 | 55296.7 |
166 | 2021-04-26 19:50:42 | crannied | 1 | 82945 | 2 | 1.390 | 59672.7 |
165 | 2021-04-20 02:42:28 | crannied | 1 | 82945 | 2 | 1.403 | 59119.7 |
164 | 2021-04-15 02:10:09 | crannied | 1 | 82945 | 2 | 1.280 | 64800.8 |
163 | 2021-04-09 16:48:09 | crannied | 1 | 82945 | 2 | 1.453 | 57085.3 |
162 | 2021-04-05 11:13:14 | crannied | 1 | 82945 | 2 | 1.736 | 47779.4 |
161 | 2021-03-31 04:15:23 | crannied | 1 | 82945 | 2 | 1.516 | 54713.1 |
160 | 2021-01-10 07:19:07 | crannied | 1 | 82945 | 2 | 1.453 | 57085.3 |
159 | 2020-12-19 14:02:53 | crannied | 1 | 82945 | 2 | 1.440 | 57600.7 |
158 | 2020-11-06 06:55:53 | crannied | 1 | 82945 | 2 | 1.313 | 63172.1 |
157 | 2020-10-27 20:32:59 | crannied | 1 | 82945 | 2 | 1.453 | 57085.3 |
156 | 2020-10-22 16:07:42 | crannied | 1 | 82945 | 2 | 1.343 | 61761.0 |
155 | 2020-10-21 02:57:33 | crannied | 1 | 82945 | 2 | 1.296 | 64000.8 |
154 | 2020-09-19 04:08:15 | crannied | 1 | 82945 | 2 | 1.296 | 64000.8 |
153 | 2020-08-25 15:35:48 | crannied | 1 | 82945 | 2 | 1.516 | 54713.1 |
152 | 2020-06-12 01:18:50 | crannied | 1 | 82945 | 2 | 1.406 | 58993.6 |
151 | 2020-06-09 01:48:05 | crannied | 1 | 82945 | 2 | 1.313 | 63172.1 |
150 | 2020-03-22 09:09:51 | crannied | 1 | 82945 | 2 | 3.216 | 25791.4 |
149 | 2020-03-01 18:04:21 | crannied | 1 | 82945 | 2 | 1.296 | 64000.8 |
148 | 2020-02-28 00:31:42 | crannied | 1 | 82945 | 2 | 1.780 | 46598.3 |
147 | 2020-02-19 10:19:20 | crannied | 1 | 82945 | 2 | 1.546 | 53651.4 |
146 | 2020-02-19 06:05:40 | crannied | 1 | 82945 | 2 | 1.623 | 51106.0 |
145 | 2020-02-17 08:48:59 | crannied | 1 | 82945 | 2 | 1.530 | 54212.4 |
144 | 2020-02-17 05:43:48 | crannied | 1 | 82945 | 2 | 1.780 | 46598.3 |
143 | 2020-02-05 12:55:12 | crannied | 1 | 82945 | 2 | 1.563 | 53067.8 |
142 | 2020-02-02 01:29:40 | crannied | 1 | 82945 | 2 | 1.626 | 51011.7 |
141 | 2020-02-01 08:39:01 | crannied | 1 | 82945 | 2 | 1.546 | 53651.4 |
140 | 2020-01-22 01:38:08 | crannied | 1 | 82945 | 2 | 1.610 | 51518.6 |
139 | 2020-01-21 23:32:10 | crannied | 1 | 82945 | 2 | 3.516 | 23590.7 |
138 | 2020-01-18 18:28:08 | crannied | 1 | 82945 | 2 | 1.593 | 52068.4 |
137 | 2020-01-10 12:06:41 | crannied | 1 | 82945 | 2 | 1.563 | 53067.8 |