History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"headnote"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
347 | 2024-05-18 09:59:38 | headnote | 1 | 82945 | 2 | 3.670 | 22600.8 |
346 | 2024-05-14 05:28:02 | headnote | 3 | 146162 | 27 | 7.580 | 19282.6 |
345 | 2024-05-14 05:28:02 | headnote | 2 | 121059 | 4 | 5.470 | 22131.4 |
344 | 2024-05-14 05:27:18 | headnote | 1 | 82945 | 2 | 1.483 | 55930.5 |
343 | 2024-05-11 12:31:58 | headnote | 1 | 82945 | 2 | 3.170 | 26165.6 |
342 | 2024-05-05 23:41:25 | headnote | 2 | 121059 | 4 | 6.373 | 18995.6 |
341 | 2024-05-05 01:43:00 | headnote | 2 | 121059 | 4 | 7.470 | 16206.0 |
340 | 2024-05-05 01:43:04 | headnote | 1 | 82945 | 2 | 1.546 | 53651.4 |
339 | 2024-05-05 01:42:56 | headnote | 3 | 146162 | 27 | 8.143 | 17949.4 |
338 | 2024-04-30 13:27:45 | headnote | 4 | 161609 | 409 | 15.296 | 10565.4 |
337 | 2024-04-27 06:25:18 | headnote | 4 | 161609 | 409 | 24.626 | 6562.5 |
336 | 2024-04-27 05:41:41 | headnote | 2 | 121059 | 4 | 3.970 | 30493.5 |
335 | 2024-04-27 05:41:37 | headnote | 3 | 146162 | 27 | 7.826 | 18676.5 |
334 | 2024-04-26 16:36:48 | headnote | 1 | 82945 | 2 | 1.390 | 59672.7 |
333 | 2024-04-26 16:36:43 | headnote | 1 | 82945 | 2 | 1.470 | 56425.2 |
332 | 2024-04-26 16:36:36 | headnote | 2 | 121059 | 4 | 3.736 | 32403.4 |
331 | 2024-04-26 11:47:07 | headnote | 3 | 146162 | 27 | 21.596 | 6768.0 |
330 | 2024-04-25 23:37:50 | headnote | 4 | 161609 | 409 | 41.813 | 3865.0 |
329 | 2024-04-25 23:38:03 | headnote | 3 | 146162 | 27 | 14.766 | 9898.6 |
328 | 2024-04-25 21:34:35 | headnote | 4 | 161609 | 409 | 22.596 | 7152.1 |
327 | 2024-04-25 18:08:44 | headnote | 4 | 161609 | 409 | 15.576 | 10375.5 |
326 | 2024-04-25 09:55:12 | headnote | 3 | 146162 | 27 | 15.610 | 9363.4 |
325 | 2024-04-25 00:13:26 | headnote | 4 | 161609 | 409 | 50.113 | 3224.9 |
324 | 2024-04-25 00:13:27 | headnote | 3 | 146162 | 27 | 39.033 | 3744.6 |
323 | 2024-04-25 00:13:26 | headnote | 2 | 121059 | 4 | 6.406 | 18897.8 |
322 | 2024-04-24 22:27:40 | headnote | 1 | 82945 | 2 | 1.326 | 62552.8 |
321 | 2024-04-17 10:05:03 | headnote | 1 | 82945 | 2 | 1.423 | 58288.8 |
320 | 2024-03-28 22:07:18 | headnote | 3 | 146162 | 27 | 20.046 | 7291.3 |
319 | 2024-03-27 07:40:17 | headnote | 3 | 146162 | 27 | 7.860 | 18595.7 |
318 | 2024-03-27 07:40:21 | headnote | 1 | 82945 | 2 | 1.546 | 53651.4 |
317 | 2024-03-27 07:40:13 | headnote | 2 | 121059 | 4 | 3.813 | 31749.0 |
316 | 2024-03-25 21:43:13 | headnote | 4 | 161609 | 409 | 26.893 | 6009.3 |
315 | 2024-03-25 05:17:33 | headnote | 4 | 161609 | 409 | 13.660 | 11830.8 |
314 | 2024-03-22 12:03:16 | headnote | 4 | 161609 | 409 | 31.376 | 5150.7 |
313 | 2024-03-21 22:04:25 | headnote | 4 | 161609 | 409 | 15.816 | 10218.1 |
312 | 2024-03-20 18:46:16 | headnote | 4 | 161609 | 409 | 22.033 | 7334.9 |
311 | 2024-03-20 18:46:23 | headnote | 3 | 146162 | 27 | 8.983 | 16271.0 |
310 | 2024-03-20 18:46:23 | headnote | 2 | 121059 | 4 | 4.093 | 29577.1 |
309 | 2024-03-20 18:45:54 | headnote | 1 | 82945 | 2 | 1.576 | 52630.1 |
308 | 2024-03-20 04:18:25 | headnote | 4 | 161609 | 409 | 33.516 | 4821.8 |
307 | 2024-03-11 17:57:29 | headnote | 3 | 146162 | 27 | 23.203 | 6299.3 |
306 | 2024-03-10 22:24:59 | headnote | 3 | 146162 | 27 | 8.356 | 17491.9 |
305 | 2024-03-10 22:25:00 | headnote | 2 | 121059 | 4 | 4.156 | 29128.7 |
304 | 2024-03-10 12:32:26 | headnote | 3 | 146162 | 27 | 11.126 | 13137.0 |
303 | 2024-03-10 12:32:26 | headnote | 2 | 121059 | 4 | 7.843 | 15435.3 |
302 | 2024-03-10 12:28:32 | headnote | 1 | 82945 | 2 | 1.546 | 53651.4 |
301 | 2024-03-08 12:59:44 | headnote | 4 | 161609 | 409 | 19.596 | 8247.0 |
300 | 2024-03-06 15:30:03 | headnote | 4 | 161609 | 409 | 41.143 | 3928.0 |
299 | 2024-03-01 09:01:12 | headnote | 1 | 82945 | 2 | 1.280 | 64800.8 |
298 | 2024-02-26 13:25:45 | headnote | 2 | 121059 | 4 | 3.390 | 35710.6 |
297 | 2024-02-26 13:25:30 | headnote | 3 | 146162 | 27 | 7.923 | 18447.8 |
296 | 2024-02-25 08:11:45 | headnote | 3 | 146162 | 27 | 7.983 | 18309.2 |
295 | 2024-02-25 08:11:43 | headnote | 2 | 121059 | 4 | 4.013 | 30166.7 |
294 | 2024-02-25 08:11:42 | headnote | 1 | 82945 | 2 | 1.436 | 57761.1 |
293 | 2024-02-24 19:02:21 | headnote | 4 | 161609 | 409 | 13.640 | 11848.2 |
292 | 2024-02-17 02:47:36 | headnote | 4 | 161609 | 409 | 25.266 | 6396.3 |
291 | 2024-02-16 01:34:45 | headnote | 4 | 161609 | 409 | 21.860 | 7392.9 |
290 | 2024-02-15 12:11:34 | headnote | 4 | 161609 | 409 | 13.220 | 12224.6 |
289 | 2024-02-15 12:11:35 | headnote | 3 | 146162 | 27 | 7.890 | 18525.0 |
288 | 2024-02-15 12:11:33 | headnote | 2 | 121059 | 4 | 3.813 | 31749.0 |
287 | 2024-02-15 12:11:25 | headnote | 1 | 82945 | 2 | 1.470 | 56425.2 |
286 | 2024-02-01 16:51:15 | headnote | 1 | 82945 | 2 | 1.360 | 60989.0 |
285 | 2024-01-20 08:47:52 | headnote | 1 | 82945 | 2 | 1.263 | 65673.0 |
284 | 2024-01-11 05:22:51 | headnote | 1 | 82945 | 2 | 1.376 | 60279.8 |
283 | 2023-12-28 15:52:49 | headnote | 1 | 82945 | 2 | 1.313 | 63172.1 |
282 | 2023-12-05 04:20:44 | headnote | 1 | 82945 | 2 | 3.076 | 26965.2 |
281 | 2023-11-15 20:13:21 | headnote | 1 | 82945 | 2 | 1.423 | 58288.8 |
280 | 2023-09-03 20:54:48 | headnote | 1 | 82945 | 2 | 1.406 | 58993.6 |
279 | 2023-07-28 20:39:05 | headnote | 1 | 82945 | 2 | 1.406 | 58993.6 |
278 | 2023-07-03 17:11:13 | headnote | 4 | 161609 | 409 | 10.953 | 14754.8 |
277 | 2023-06-07 08:24:23 | headnote | 1 | 82945 | 2 | 1.233 | 67270.9 |
276 | 2023-04-22 05:44:18 | headnote | 1 | 82945 | 2 | 1.343 | 61761.0 |
275 | 2023-04-02 03:22:39 | headnote | 1 | 82945 | 2 | 1.436 | 57761.1 |
274 | 2023-03-14 09:53:09 | headnote | 2 | 121059 | 4 | 3.203 | 37795.5 |
273 | 2023-03-04 22:33:15 | headnote | 1 | 82945 | 2 | 1.250 | 66356.0 |
272 | 2023-01-28 17:42:16 | headnote | 1 | 82945 | 2 | 1.250 | 66356.0 |
271 | 2023-01-21 23:10:30 | headnote | 2 | 121059 | 4 | 3.170 | 38189.0 |
270 | 2023-01-11 09:38:02 | headnote | 1 | 82945 | 2 | 1.453 | 57085.3 |
269 | 2022-12-13 22:24:50 | headnote | 1 | 82945 | 2 | 1.393 | 59544.1 |
268 | 2022-11-30 22:42:48 | headnote | 1 | 82945 | 2 | 1.470 | 56425.2 |
267 | 2022-11-27 15:44:10 | headnote | 1 | 82945 | 2 | 1.266 | 65517.4 |
266 | 2022-11-26 03:22:50 | headnote | 1 | 82945 | 2 | 1.406 | 58993.6 |
265 | 2022-11-05 02:48:15 | headnote | 1 | 82945 | 2 | 1.280 | 64800.8 |
264 | 2022-11-03 08:14:48 | headnote | 1 | 82945 | 2 | 1.360 | 60989.0 |
263 | 2022-10-18 23:07:34 | headnote | 1 | 82945 | 2 | 1.280 | 64800.8 |
262 | 2022-08-07 11:28:51 | headnote | 1 | 82945 | 2 | 1.406 | 58993.6 |
261 | 2022-07-20 20:55:00 | headnote | 1 | 82945 | 2 | 1.576 | 52630.1 |
260 | 2022-07-17 21:26:44 | headnote | 2 | 121059 | 4 | 3.266 | 37066.4 |
259 | 2022-07-17 03:40:18 | headnote | 1 | 82945 | 2 | 1.250 | 66356.0 |
258 | 2022-06-09 21:12:53 | headnote | 1 | 82945 | 2 | 1.313 | 63172.1 |
257 | 2022-03-02 19:37:01 | headnote | 1 | 82945 | 2 | 1.313 | 63172.1 |
256 | 2022-02-12 22:38:27 | headnote | 1 | 82945 | 2 | 1.250 | 66356.0 |
255 | 2021-11-02 10:41:06 | headnote | 1 | 82945 | 2 | 1.453 | 57085.3 |
254 | 2021-07-21 13:36:12 | headnote | 1 | 82945 | 2 | 1.263 | 65673.0 |
253 | 2021-07-19 21:57:00 | headnote | 1 | 82945 | 2 | 1.280 | 64800.8 |
252 | 2021-05-05 10:52:30 | headnote | 1 | 82945 | 2 | 1.346 | 61623.3 |
251 | 2021-04-26 20:43:55 | headnote | 1 | 82945 | 2 | 1.283 | 64649.3 |
250 | 2021-04-17 05:05:07 | headnote | 1 | 82945 | 2 | 1.500 | 55296.7 |
249 | 2021-03-27 00:47:12 | headnote | 1 | 82945 | 2 | 1.280 | 64800.8 |
248 | 2021-01-10 08:13:17 | headnote | 1 | 82945 | 2 | 1.250 | 66356.0 |