History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"charlock"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
295 | 2024-04-26 14:36:42 | charlock | 1 | 82945 | 2 | 1.406 | 58993.6 |
294 | 2024-04-18 21:22:49 | charlock | 1 | 82945 | 2 | 1.563 | 53067.8 |
293 | 2024-04-12 20:47:04 | charlock | 1 | 82945 | 2 | 2.110 | 39310.4 |
292 | 2024-04-09 12:14:03 | charlock | 4 | 161609 | 509 | 50.270 | 3214.8 |
291 | 2024-04-08 17:06:19 | charlock | 1 | 82945 | 2 | 3.783 | 21925.7 |
290 | 2024-04-07 14:31:26 | charlock | 4 | 161609 | 509 | 27.736 | 5826.7 |
289 | 2024-04-07 08:15:16 | charlock | 1 | 82945 | 2 | 4.206 | 19720.6 |
288 | 2024-04-07 08:13:52 | charlock | 3 | 146162 | 67 | 12.486 | 11706.1 |
287 | 2024-04-07 08:13:53 | charlock | 2 | 121059 | 7 | 9.063 | 13357.5 |
286 | 2024-04-07 08:12:50 | charlock | 1 | 82945 | 2 | 3.016 | 27501.7 |
285 | 2024-04-06 17:01:04 | charlock | 4 | 161609 | 509 | 43.050 | 3754.0 |
284 | 2024-04-05 04:59:37 | charlock | 4 | 161609 | 509 | 48.453 | 3335.4 |
283 | 2024-04-01 16:22:54 | charlock | 4 | 161609 | 509 | 16.436 | 9832.6 |
282 | 2024-04-01 13:57:13 | charlock | 1 | 82945 | 2 | 3.640 | 22787.1 |
281 | 2024-04-01 13:56:36 | charlock | 4 | 161609 | 509 | 29.160 | 5542.1 |
280 | 2024-04-01 13:56:36 | charlock | 3 | 146162 | 67 | 9.563 | 15284.1 |
279 | 2024-04-01 13:56:36 | charlock | 2 | 121059 | 7 | 5.563 | 21761.5 |
278 | 2024-03-26 12:38:57 | charlock | 1 | 82945 | 2 | 1.500 | 55296.7 |
277 | 2024-03-26 12:33:26 | charlock | 3 | 146162 | 67 | 7.843 | 18636.0 |
276 | 2024-03-26 12:33:21 | charlock | 2 | 121059 | 7 | 3.656 | 33112.4 |
275 | 2024-03-11 04:18:20 | charlock | 4 | 161609 | 509 | 17.920 | 9018.4 |
274 | 2024-03-09 07:18:14 | charlock | 3 | 146162 | 67 | 16.516 | 8849.7 |
273 | 2024-03-08 00:49:56 | charlock | 3 | 146162 | 67 | 11.343 | 12885.7 |
272 | 2024-03-07 19:06:33 | charlock | 3 | 146162 | 67 | 8.826 | 16560.4 |
271 | 2024-03-07 06:55:17 | charlock | 4 | 161609 | 509 | 29.423 | 5492.6 |
270 | 2024-03-05 11:20:18 | charlock | 3 | 146162 | 67 | 12.470 | 11721.1 |
269 | 2024-03-05 11:20:17 | charlock | 2 | 121059 | 7 | 3.953 | 30624.6 |
268 | 2024-03-05 11:20:20 | charlock | 1 | 82945 | 2 | 1.513 | 54821.5 |
267 | 2024-03-05 11:20:03 | charlock | 4 | 161609 | 509 | 13.050 | 12383.8 |
266 | 2024-03-02 06:50:46 | charlock | 4 | 161609 | 509 | 18.000 | 8978.3 |
265 | 2024-03-02 04:59:22 | charlock | 4 | 161609 | 509 | 19.470 | 8300.4 |
264 | 2024-03-02 04:59:22 | charlock | 3 | 146162 | 67 | 16.843 | 8677.9 |
263 | 2024-03-02 04:59:21 | charlock | 2 | 121059 | 7 | 6.390 | 18945.1 |
262 | 2024-03-02 04:15:16 | charlock | 1 | 82945 | 2 | 1.546 | 53651.4 |
261 | 2024-02-29 01:51:18 | charlock | 1 | 82945 | 2 | 1.640 | 50576.2 |
260 | 2024-02-25 08:04:22 | charlock | 1 | 82945 | 2 | 1.593 | 52068.4 |
259 | 2024-02-06 00:08:26 | charlock | 3 | 146162 | 67 | 7.953 | 18378.2 |
258 | 2024-02-04 05:48:15 | charlock | 4 | 161609 | 509 | 16.280 | 9926.8 |
257 | 2024-02-04 05:48:23 | charlock | 3 | 146162 | 67 | 8.296 | 17618.4 |
256 | 2024-02-04 05:48:19 | charlock | 2 | 121059 | 7 | 3.750 | 32282.4 |
255 | 2024-02-04 05:48:11 | charlock | 1 | 82945 | 2 | 1.453 | 57085.3 |
254 | 2024-02-03 06:36:23 | charlock | 2 | 121059 | 7 | 8.423 | 14372.4 |
253 | 2024-01-29 08:53:44 | charlock | 2 | 121059 | 7 | 3.626 | 33386.4 |
252 | 2024-01-29 08:53:23 | charlock | 4 | 161609 | 509 | 13.220 | 12224.6 |
251 | 2024-01-29 08:53:27 | charlock | 3 | 146162 | 67 | 7.580 | 19282.6 |
250 | 2024-01-29 08:52:57 | charlock | 4 | 161609 | 509 | 12.686 | 12739.2 |
249 | 2024-01-29 08:52:53 | charlock | 2 | 121059 | 7 | 3.423 | 35366.3 |
248 | 2024-01-29 08:52:49 | charlock | 3 | 146162 | 67 | 6.563 | 22270.6 |
247 | 2024-01-29 08:52:46 | charlock | 1 | 82945 | 2 | 1.453 | 57085.3 |
246 | 2024-01-15 17:16:45 | charlock | 3 | 146162 | 67 | 6.546 | 22328.4 |
245 | 2024-01-15 09:28:46 | charlock | 3 | 146162 | 67 | 7.050 | 20732.2 |
244 | 2024-01-12 03:36:20 | charlock | 3 | 146162 | 67 | 16.063 | 9099.3 |
243 | 2024-01-05 02:03:16 | charlock | 1 | 82945 | 2 | 1.296 | 64000.8 |
242 | 2023-11-21 15:32:20 | charlock | 1 | 82945 | 2 | 1.420 | 58412.0 |
241 | 2023-11-15 09:40:38 | charlock | 3 | 146162 | 67 | 6.563 | 22270.6 |
240 | 2023-11-15 07:11:53 | charlock | 1 | 82945 | 2 | 1.263 | 65673.0 |
239 | 2023-10-29 12:15:19 | charlock | 1 | 82945 | 2 | 1.436 | 57761.1 |
238 | 2023-10-27 03:06:33 | charlock | 1 | 82945 | 2 | 1.326 | 62552.8 |
237 | 2023-10-25 16:20:26 | charlock | 3 | 146162 | 67 | 7.813 | 18707.5 |
236 | 2023-08-22 01:46:08 | charlock | 1 | 82945 | 2 | 1.483 | 55930.5 |
235 | 2023-08-04 07:40:23 | charlock | 3 | 146162 | 67 | 6.406 | 22816.4 |
234 | 2023-06-24 15:13:29 | charlock | 1 | 82945 | 2 | 1.266 | 65517.4 |
233 | 2023-05-24 10:32:36 | charlock | 1 | 82945 | 2 | 1.236 | 67107.6 |
232 | 2023-04-17 02:29:08 | charlock | 3 | 146162 | 67 | 7.123 | 20519.7 |
231 | 2023-03-19 13:03:49 | charlock | 1 | 82945 | 2 | 1.390 | 59672.7 |
230 | 2023-03-02 10:23:02 | charlock | 1 | 82945 | 2 | 1.296 | 64000.8 |
229 | 2023-02-26 20:04:00 | charlock | 1 | 82945 | 2 | 1.296 | 64000.8 |
228 | 2023-01-25 08:42:53 | charlock | 3 | 146162 | 67 | 6.220 | 23498.7 |
227 | 2023-01-05 06:48:27 | charlock | 1 | 82945 | 2 | 1.283 | 64649.3 |
226 | 2022-11-06 17:02:03 | charlock | 3 | 146162 | 67 | 6.233 | 23449.7 |
225 | 2022-10-30 13:02:23 | charlock | 1 | 82945 | 2 | 1.266 | 65517.4 |
224 | 2022-09-28 20:57:49 | charlock | 1 | 82945 | 2 | 1.406 | 58993.6 |
223 | 2022-06-21 23:37:18 | charlock | 1 | 82945 | 2 | 1.436 | 57761.1 |
222 | 2022-05-14 10:43:11 | charlock | 1 | 82945 | 2 | 1.280 | 64800.8 |
221 | 2022-05-07 13:49:12 | charlock | 3 | 146162 | 67 | 6.283 | 23263.1 |
220 | 2022-02-09 23:38:27 | charlock | 1 | 82945 | 2 | 1.280 | 64800.8 |
219 | 2022-01-31 05:33:07 | charlock | 1 | 82945 | 2 | 1.296 | 64000.8 |
218 | 2021-11-18 02:26:26 | charlock | 1 | 82945 | 2 | 1.470 | 56425.2 |
217 | 2021-11-16 00:11:44 | charlock | 1 | 82945 | 2 | 1.343 | 61761.0 |
216 | 2021-10-13 15:39:20 | charlock | 1 | 82945 | 2 | 1.453 | 57085.3 |
215 | 2021-10-01 15:16:46 | charlock | 1 | 82945 | 2 | 1.266 | 65517.4 |
214 | 2021-09-14 14:18:02 | charlock | 1 | 82945 | 2 | 1.810 | 45826.0 |
213 | 2021-07-12 13:45:47 | charlock | 1 | 82945 | 2 | 1.296 | 64000.8 |
212 | 2021-04-08 20:49:56 | charlock | 1 | 82945 | 2 | 1.440 | 57600.7 |
211 | 2021-04-04 16:31:41 | charlock | 1 | 82945 | 2 | 1.393 | 59544.1 |
210 | 2020-12-27 00:52:34 | charlock | 1 | 82945 | 2 | 1.313 | 63172.1 |
209 | 2020-10-28 08:20:17 | charlock | 1 | 82945 | 2 | 1.440 | 57600.7 |
208 | 2020-09-23 09:19:16 | charlock | 1 | 82945 | 2 | 1.296 | 64000.8 |
207 | 2020-06-12 07:44:32 | charlock | 1 | 82945 | 2 | 1.470 | 56425.2 |
206 | 2020-06-09 07:49:37 | charlock | 1 | 82945 | 2 | 1.453 | 57085.3 |
205 | 2020-03-28 19:51:48 | charlock | 1 | 82945 | 2 | 1.530 | 54212.4 |
204 | 2020-03-22 10:45:43 | charlock | 1 | 82945 | 2 | 1.546 | 53651.4 |
203 | 2020-03-06 02:51:20 | charlock | 1 | 82945 | 2 | 1.516 | 54713.1 |
202 | 2020-02-29 02:40:49 | charlock | 1 | 82945 | 2 | 3.143 | 26390.4 |
201 | 2020-02-29 01:43:44 | charlock | 1 | 82945 | 2 | 3.046 | 27230.8 |
200 | 2020-02-26 12:08:12 | charlock | 1 | 82945 | 2 | 1.346 | 61623.3 |
199 | 2020-02-25 00:10:48 | charlock | 1 | 82945 | 2 | 1.640 | 50576.2 |
198 | 2020-02-23 14:07:34 | charlock | 4 | 161609 | 509 | 13.280 | 12169.4 |
197 | 2020-02-21 13:23:44 | charlock | 4 | 161609 | 509 | 21.376 | 7560.3 |
196 | 2020-02-20 03:38:27 | charlock | 1 | 82945 | 2 | 3.280 | 25288.1 |