History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"articles"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
403 | 2024-04-23 01:59:59 | articles | 1 | 82945 | 4 | 1.343 | 61761.0 |
402 | 2024-04-07 16:54:01 | articles | 1 | 82945 | 4 | 1.703 | 48705.2 |
401 | 2024-04-07 01:05:23 | articles | 3 | 146162 | 192 | 19.280 | 7581.0 |
400 | 2024-04-06 11:02:00 | articles | 3 | 146162 | 192 | 21.986 | 6648.0 |
399 | 2024-04-06 06:11:17 | articles | 3 | 146162 | 192 | 10.296 | 14196.0 |
398 | 2024-04-05 09:33:23 | articles | 2 | 121059 | 12 | 4.110 | 29454.7 |
397 | 2024-04-05 09:33:17 | articles | 3 | 146162 | 192 | 9.750 | 14991.0 |
396 | 2024-04-05 09:33:14 | articles | 1 | 82945 | 4 | 1.610 | 51518.6 |
395 | 2024-04-05 09:33:03 | articles | 3 | 146162 | 192 | 7.893 | 18517.9 |
394 | 2024-04-05 09:33:04 | articles | 2 | 121059 | 12 | 4.080 | 29671.3 |
393 | 2024-04-05 09:33:01 | articles | 1 | 82945 | 4 | 1.516 | 54713.1 |
392 | 2024-03-31 17:30:57 | articles | 1 | 82945 | 4 | 2.716 | 30539.4 |
391 | 2024-03-30 05:30:49 | articles | 1 | 82945 | 4 | 2.860 | 29001.7 |
390 | 2024-03-23 08:18:34 | articles | 1 | 82945 | 4 | 4.080 | 20329.7 |
389 | 2024-03-05 10:56:43 | articles | 2 | 121059 | 12 | 3.970 | 30493.5 |
388 | 2024-03-05 10:56:28 | articles | 3 | 146162 | 192 | 8.686 | 16827.3 |
387 | 2024-03-03 23:13:00 | articles | 3 | 146162 | 192 | 13.283 | 11003.7 |
386 | 2024-03-03 09:51:11 | articles | 2 | 121059 | 12 | 4.016 | 30144.2 |
385 | 2024-03-03 09:50:50 | articles | 3 | 146162 | 192 | 8.610 | 16975.8 |
384 | 2024-03-02 18:48:37 | articles | 3 | 146162 | 192 | 27.266 | 5360.6 |
383 | 2024-02-22 08:46:57 | articles | 3 | 146162 | 192 | 7.016 | 20832.7 |
382 | 2024-02-22 08:46:58 | articles | 2 | 121059 | 12 | 3.686 | 32842.9 |
381 | 2024-02-21 21:39:00 | articles | 1 | 82945 | 4 | 1.436 | 57761.1 |
380 | 2024-01-10 23:51:48 | articles | 1 | 82945 | 4 | 1.530 | 54212.4 |
379 | 2024-01-07 23:55:55 | articles | 1 | 82945 | 4 | 1.326 | 62552.8 |
378 | 2024-01-04 10:19:25 | articles | 3 | 146162 | 192 | 7.296 | 20033.2 |
377 | 2023-12-21 23:56:40 | articles | 3 | 146162 | 192 | 7.593 | 19249.6 |
376 | 2023-12-21 23:56:39 | articles | 2 | 121059 | 12 | 4.003 | 30242.1 |
375 | 2023-11-18 08:53:17 | articles | 1 | 82945 | 4 | 1.280 | 64800.8 |
374 | 2023-11-04 15:44:37 | articles | 1 | 82945 | 4 | 1.310 | 63316.8 |
373 | 2023-11-03 09:34:59 | articles | 1 | 82945 | 4 | 1.483 | 55930.5 |
372 | 2023-10-30 21:12:59 | articles | 1 | 82945 | 4 | 2.953 | 28088.4 |
371 | 2023-10-29 17:22:31 | articles | 1 | 82945 | 4 | 1.360 | 60989.0 |
370 | 2023-10-24 11:15:43 | articles | 1 | 82945 | 4 | 1.390 | 59672.7 |
369 | 2023-10-11 08:40:17 | articles | 1 | 82945 | 4 | 1.423 | 58288.8 |
368 | 2023-09-16 19:19:19 | articles | 1 | 82945 | 4 | 1.313 | 63172.1 |
367 | 2023-08-26 04:31:50 | articles | 1 | 82945 | 4 | 1.403 | 59119.7 |
366 | 2023-07-11 07:14:20 | articles | 1 | 82945 | 4 | 1.313 | 63172.1 |
365 | 2023-05-26 23:37:20 | articles | 1 | 82945 | 4 | 1.263 | 65673.0 |
364 | 2023-03-31 00:06:59 | articles | 1 | 82945 | 4 | 1.436 | 57761.1 |
363 | 2023-03-21 08:52:56 | articles | 1 | 82945 | 4 | 1.266 | 65517.4 |
362 | 2023-01-08 00:04:49 | articles | 1 | 82945 | 4 | 2.423 | 34232.4 |
361 | 2022-12-22 03:36:09 | articles | 1 | 82945 | 4 | 1.330 | 62364.7 |
360 | 2022-10-01 22:21:25 | articles | 1 | 82945 | 4 | 1.283 | 64649.3 |
359 | 2022-09-11 21:49:47 | articles | 1 | 82945 | 4 | 1.376 | 60279.8 |
358 | 2022-09-07 22:45:01 | articles | 1 | 82945 | 4 | 1.313 | 63172.1 |
357 | 2022-05-17 03:32:18 | articles | 1 | 82945 | 4 | 1.593 | 52068.4 |
356 | 2022-05-14 22:02:57 | articles | 1 | 82945 | 4 | 1.310 | 63316.8 |
355 | 2022-02-22 00:47:13 | articles | 1 | 82945 | 4 | 1.656 | 50087.6 |
354 | 2022-02-02 22:02:34 | articles | 1 | 82945 | 4 | 1.423 | 58288.8 |
353 | 2022-01-31 16:49:44 | articles | 1 | 82945 | 4 | 1.283 | 64649.3 |
352 | 2021-11-24 18:37:55 | articles | 1 | 82945 | 4 | 1.533 | 54106.3 |
351 | 2021-11-13 23:42:38 | articles | 1 | 82945 | 4 | 1.720 | 48223.8 |
350 | 2021-10-26 21:19:50 | articles | 1 | 82945 | 4 | 1.280 | 64800.8 |
349 | 2021-08-11 01:17:03 | articles | 1 | 82945 | 4 | 1.296 | 64000.8 |
348 | 2021-06-11 19:59:29 | articles | 1 | 82945 | 4 | 2.560 | 32400.4 |
347 | 2021-05-22 07:39:43 | articles | 3 | 146162 | 192 | 7.516 | 19446.8 |
346 | 2021-05-18 22:39:03 | articles | 3 | 146162 | 192 | 7.203 | 20291.8 |
345 | 2021-05-10 03:45:13 | articles | 1 | 82945 | 4 | 1.593 | 52068.4 |
344 | 2021-05-06 18:35:09 | articles | 1 | 82945 | 4 | 1.626 | 51011.7 |
343 | 2021-05-03 06:10:47 | articles | 1 | 82945 | 4 | 1.516 | 54713.1 |
342 | 2021-04-20 02:42:17 | articles | 1 | 82945 | 4 | 1.296 | 64000.8 |
341 | 2021-04-15 02:09:58 | articles | 1 | 82945 | 4 | 2.893 | 28670.9 |
340 | 2021-04-09 16:48:04 | articles | 1 | 82945 | 4 | 1.466 | 56579.1 |
339 | 2021-04-05 15:19:18 | articles | 1 | 82945 | 4 | 1.453 | 57085.3 |
338 | 2021-04-01 21:13:08 | articles | 1 | 82945 | 4 | 1.500 | 55296.7 |
337 | 2021-03-28 08:11:53 | articles | 1 | 82945 | 4 | 1.440 | 57600.7 |
336 | 2021-03-21 04:51:57 | articles | 1 | 82945 | 4 | 1.313 | 63172.1 |
335 | 2021-02-20 03:41:35 | articles | 1 | 82945 | 4 | 1.470 | 56425.2 |
334 | 2021-01-31 14:05:46 | articles | 1 | 82945 | 4 | 1.296 | 64000.8 |
333 | 2021-01-02 19:06:27 | articles | 1 | 82945 | 4 | 1.313 | 63172.1 |
332 | 2020-12-04 22:49:28 | articles | 3 | 146162 | 192 | 6.610 | 22112.3 |
331 | 2020-11-20 03:07:49 | articles | 1 | 82945 | 4 | 1.296 | 64000.8 |
330 | 2020-10-29 07:00:00 | articles | 1 | 82945 | 4 | 1.550 | 53512.9 |
329 | 2020-10-18 15:50:22 | articles | 1 | 82945 | 4 | 1.423 | 58288.8 |
328 | 2020-08-27 15:32:39 | articles | 1 | 82945 | 4 | 1.313 | 63172.1 |
327 | 2020-08-22 13:26:41 | articles | 1 | 82945 | 4 | 1.576 | 52630.1 |
326 | 2020-07-24 15:35:14 | articles | 1 | 82945 | 4 | 1.376 | 60279.8 |
325 | 2020-07-13 15:42:08 | articles | 1 | 82945 | 4 | 1.343 | 61761.0 |
324 | 2020-05-10 02:09:53 | articles | 3 | 146162 | 192 | 7.500 | 19488.3 |
323 | 2020-04-22 11:02:40 | articles | 1 | 82945 | 4 | 1.483 | 55930.5 |
322 | 2020-04-06 19:14:14 | articles | 1 | 82945 | 4 | 1.343 | 61761.0 |
321 | 2020-03-26 05:19:54 | articles | 1 | 82945 | 4 | 1.560 | 53169.9 |
320 | 2020-03-24 01:07:11 | articles | 3 | 146162 | 192 | 15.873 | 9208.2 |
319 | 2020-03-23 20:45:19 | articles | 3 | 146162 | 192 | 18.890 | 7737.5 |
318 | 2020-03-22 15:44:13 | articles | 3 | 146162 | 192 | 8.343 | 17519.1 |
317 | 2020-03-21 01:10:28 | articles | 1 | 82945 | 4 | 1.420 | 58412.0 |
316 | 2020-03-06 00:24:39 | articles | 3 | 146162 | 192 | 8.250 | 17716.6 |
315 | 2020-03-05 17:17:53 | articles | 3 | 146162 | 192 | 11.893 | 12289.8 |
314 | 2020-02-29 03:10:03 | articles | 1 | 82945 | 4 | 1.516 | 54713.1 |
313 | 2020-02-23 03:52:08 | articles | 1 | 82945 | 4 | 2.420 | 34274.8 |
312 | 2020-02-23 02:41:51 | articles | 1 | 82945 | 4 | 3.250 | 25521.5 |
311 | 2020-02-20 12:19:36 | articles | 1 | 82945 | 4 | 1.533 | 54106.3 |
310 | 2020-02-19 22:13:31 | articles | 3 | 146162 | 192 | 8.753 | 16698.5 |
309 | 2020-02-18 04:07:39 | articles | 3 | 146162 | 192 | 8.846 | 16522.9 |
308 | 2020-02-17 22:05:07 | articles | 3 | 146162 | 192 | 7.110 | 20557.2 |
307 | 2020-02-17 14:54:21 | articles | 1 | 82945 | 4 | 3.250 | 25521.5 |
306 | 2020-02-07 04:01:39 | articles | 1 | 82945 | 4 | 3.186 | 26034.2 |
305 | 2020-02-05 12:47:58 | articles | 1 | 82945 | 4 | 3.530 | 23497.2 |
304 | 2020-02-03 15:16:31 | articles | 1 | 82945 | 4 | 1.483 | 55930.5 |