History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"contents"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
521 | 2024-04-16 20:17:39 | contents | 1 | 82945 | 8 | 4.470 | 18555.9 |
520 | 2024-04-03 15:02:02 | contents | 2 | 121059 | 36 | 4.640 | 26090.3 |
519 | 2024-04-03 10:07:52 | contents | 1 | 82945 | 8 | 3.563 | 23279.5 |
518 | 2024-03-31 22:01:37 | contents | 2 | 121059 | 36 | 4.533 | 26706.2 |
517 | 2024-03-31 08:21:26 | contents | 1 | 82945 | 8 | 2.390 | 34705.0 |
516 | 2024-03-31 08:21:19 | contents | 2 | 121059 | 36 | 4.530 | 26723.8 |
515 | 2024-03-31 05:01:42 | contents | 3 | 146162 | 289 | 26.893 | 5434.9 |
514 | 2024-03-31 05:01:39 | contents | 2 | 121059 | 36 | 4.560 | 26548.0 |
513 | 2024-03-31 03:51:53 | contents | 1 | 82945 | 8 | 1.563 | 53067.8 |
512 | 2024-03-05 23:17:08 | contents | 3 | 146162 | 289 | 26.483 | 5519.1 |
511 | 2024-03-04 19:19:47 | contents | 3 | 146162 | 289 | 16.063 | 9099.3 |
510 | 2024-03-04 14:40:54 | contents | 3 | 146162 | 289 | 18.483 | 7907.9 |
509 | 2024-03-04 07:20:38 | contents | 3 | 146162 | 289 | 21.753 | 6719.2 |
508 | 2024-03-04 07:20:37 | contents | 2 | 121059 | 36 | 4.593 | 26357.3 |
507 | 2024-03-04 07:20:30 | contents | 1 | 82945 | 8 | 2.910 | 28503.4 |
506 | 2024-03-01 00:48:32 | contents | 1 | 82945 | 8 | 1.640 | 50576.2 |
505 | 2024-01-29 01:26:50 | contents | 1 | 82945 | 8 | 1.296 | 64000.8 |
504 | 2023-12-31 05:15:43 | contents | 1 | 82945 | 8 | 1.346 | 61623.3 |
503 | 2023-12-01 07:32:04 | contents | 1 | 82945 | 8 | 1.296 | 64000.8 |
502 | 2023-11-23 14:54:02 | contents | 1 | 82945 | 8 | 1.283 | 64649.3 |
501 | 2023-11-22 21:47:27 | contents | 1 | 82945 | 8 | 1.280 | 64800.8 |
500 | 2023-11-20 05:39:22 | contents | 1 | 82945 | 8 | 1.283 | 64649.3 |
499 | 2023-11-15 13:12:11 | contents | 1 | 82945 | 8 | 1.470 | 56425.2 |
498 | 2023-11-12 20:08:02 | contents | 1 | 82945 | 8 | 2.983 | 27805.9 |
497 | 2023-11-10 02:22:41 | contents | 1 | 82945 | 8 | 1.466 | 56579.1 |
496 | 2023-09-09 01:58:42 | contents | 1 | 82945 | 8 | 1.420 | 58412.0 |
495 | 2023-07-30 14:55:22 | contents | 1 | 82945 | 8 | 1.296 | 64000.8 |
494 | 2023-06-18 11:22:04 | contents | 1 | 82945 | 8 | 1.376 | 60279.8 |
493 | 2023-04-22 06:25:30 | contents | 1 | 82945 | 8 | 1.280 | 64800.8 |
492 | 2023-04-01 20:20:25 | contents | 1 | 82945 | 8 | 1.310 | 63316.8 |
491 | 2023-01-14 10:58:12 | contents | 1 | 82945 | 8 | 1.280 | 64800.8 |
490 | 2023-01-06 03:52:42 | contents | 1 | 82945 | 8 | 1.436 | 57761.1 |
489 | 2022-12-29 23:32:05 | contents | 1 | 82945 | 8 | 1.280 | 64800.8 |
488 | 2022-11-19 18:23:32 | contents | 1 | 82945 | 8 | 1.423 | 58288.8 |
487 | 2022-11-19 09:23:39 | contents | 1 | 82945 | 8 | 1.406 | 58993.6 |
486 | 2022-11-06 06:09:30 | contents | 1 | 82945 | 8 | 1.373 | 60411.5 |
485 | 2022-09-22 11:09:40 | contents | 1 | 82945 | 8 | 1.300 | 63803.8 |
484 | 2022-08-23 13:50:56 | contents | 1 | 82945 | 8 | 1.470 | 56425.2 |
483 | 2022-06-26 14:10:25 | contents | 1 | 82945 | 8 | 1.326 | 62552.8 |
482 | 2022-06-12 16:14:09 | contents | 1 | 82945 | 8 | 1.313 | 63172.1 |
481 | 2022-03-03 18:16:19 | contents | 1 | 82945 | 8 | 1.393 | 59544.1 |
480 | 2022-03-01 15:23:42 | contents | 1 | 82945 | 8 | 1.563 | 53067.8 |
479 | 2022-02-22 04:03:02 | contents | 1 | 82945 | 8 | 1.513 | 54821.5 |
478 | 2021-12-16 10:56:23 | contents | 1 | 82945 | 8 | 1.423 | 58288.8 |
477 | 2021-11-14 03:13:16 | contents | 1 | 82945 | 8 | 1.313 | 63172.1 |
476 | 2021-10-21 12:45:24 | contents | 1 | 82945 | 8 | 1.673 | 49578.6 |
475 | 2021-09-13 17:22:34 | contents | 1 | 82945 | 8 | 1.313 | 63172.1 |
474 | 2021-08-24 22:14:08 | contents | 1 | 82945 | 8 | 1.296 | 64000.8 |
473 | 2021-08-11 04:16:38 | contents | 1 | 82945 | 8 | 1.296 | 64000.8 |
472 | 2021-07-25 15:39:01 | contents | 1 | 82945 | 8 | 1.296 | 64000.8 |
471 | 2021-05-16 00:17:38 | contents | 1 | 82945 | 8 | 1.313 | 63172.1 |
470 | 2021-05-10 07:43:15 | contents | 1 | 82945 | 8 | 1.453 | 57085.3 |
469 | 2021-05-06 21:43:45 | contents | 1 | 82945 | 8 | 1.483 | 55930.5 |
468 | 2021-03-18 19:57:52 | contents | 1 | 82945 | 8 | 1.563 | 53067.8 |
467 | 2021-01-31 18:00:04 | contents | 1 | 82945 | 8 | 1.326 | 62552.8 |
466 | 2021-01-28 15:24:37 | contents | 1 | 82945 | 8 | 1.546 | 53651.4 |
465 | 2020-10-30 16:46:04 | contents | 1 | 82945 | 8 | 1.356 | 61168.9 |
464 | 2020-10-29 11:23:55 | contents | 1 | 82945 | 8 | 1.360 | 60989.0 |
463 | 2020-10-22 02:24:42 | contents | 1 | 82945 | 8 | 1.296 | 64000.8 |
462 | 2020-09-11 01:43:09 | contents | 1 | 82945 | 8 | 1.280 | 64800.8 |
461 | 2020-09-09 16:53:25 | contents | 1 | 82945 | 8 | 1.296 | 64000.8 |
460 | 2020-09-01 07:42:03 | contents | 1 | 82945 | 8 | 1.393 | 59544.1 |
459 | 2020-08-25 11:53:45 | contents | 1 | 82945 | 8 | 1.513 | 54821.5 |
458 | 2020-07-24 18:35:35 | contents | 1 | 82945 | 8 | 1.376 | 60279.8 |
457 | 2020-06-17 21:45:16 | contents | 1 | 82945 | 8 | 1.486 | 55817.6 |
456 | 2020-04-22 13:33:08 | contents | 1 | 82945 | 8 | 1.453 | 57085.3 |
455 | 2020-03-28 18:51:32 | contents | 1 | 82945 | 8 | 3.360 | 24686.0 |
454 | 2020-03-26 04:36:32 | contents | 1 | 82945 | 8 | 1.500 | 55296.7 |
453 | 2020-03-24 22:01:11 | contents | 1 | 82945 | 8 | 1.546 | 53651.4 |
452 | 2020-03-20 12:06:49 | contents | 1 | 82945 | 8 | 1.656 | 50087.6 |
451 | 2020-03-15 15:16:30 | contents | 1 | 82945 | 8 | 1.280 | 64800.8 |
450 | 2020-02-26 04:58:56 | contents | 1 | 82945 | 8 | 1.623 | 51106.0 |
449 | 2020-02-25 15:22:33 | contents | 1 | 82945 | 8 | 1.516 | 54713.1 |
448 | 2020-02-25 13:29:17 | contents | 1 | 82945 | 8 | 3.126 | 26533.9 |
447 | 2020-02-24 23:22:00 | contents | 1 | 82945 | 8 | 1.500 | 55296.7 |
446 | 2020-02-09 09:44:03 | contents | 1 | 82945 | 8 | 1.563 | 53067.8 |
445 | 2020-02-07 08:36:48 | contents | 1 | 82945 | 8 | 1.546 | 53651.4 |
444 | 2020-02-03 22:07:48 | contents | 1 | 82945 | 8 | 1.580 | 52496.8 |
443 | 2020-02-01 02:53:05 | contents | 1 | 82945 | 8 | 1.640 | 50576.2 |
442 | 2020-01-31 09:13:57 | contents | 1 | 82945 | 8 | 1.470 | 56425.2 |
441 | 2020-01-30 19:23:20 | contents | 1 | 82945 | 8 | 1.656 | 50087.6 |
440 | 2020-01-22 02:07:28 | contents | 1 | 82945 | 8 | 2.673 | 31030.7 |
439 | 2020-01-17 13:21:12 | contents | 2 | 121059 | 36 | 13.156 | 9201.8 |
438 | 2020-01-17 11:27:45 | contents | 1 | 82945 | 8 | 1.343 | 61761.0 |
437 | 2020-01-17 08:05:54 | contents | 1 | 82945 | 8 | 2.640 | 31418.6 |
436 | 2020-01-13 05:12:46 | contents | 1 | 82945 | 8 | 1.546 | 53651.4 |
435 | 2020-01-07 23:33:30 | contents | 1 | 82945 | 8 | 5.160 | 16074.6 |
434 | 2020-01-02 02:10:04 | contents | 1 | 82945 | 8 | 1.686 | 49196.3 |
433 | 2019-12-29 04:27:31 | contents | 1 | 82945 | 8 | 1.653 | 50178.5 |
432 | 2019-12-28 18:46:19 | contents | 1 | 82945 | 8 | 1.470 | 56425.2 |
431 | 2019-12-28 13:26:07 | contents | 1 | 82945 | 8 | 1.530 | 54212.4 |
430 | 2019-12-16 20:47:20 | contents | 1 | 82945 | 8 | 1.356 | 61168.9 |
429 | 2019-12-09 11:17:17 | contents | 1 | 82945 | 8 | 1.326 | 62552.8 |
428 | 2019-11-27 07:21:30 | contents | 1 | 82945 | 8 | 1.546 | 53651.4 |
427 | 2019-11-18 12:10:43 | contents | 3 | 146162 | 289 | 7.593 | 19249.6 |
426 | 2019-11-09 20:56:24 | contents | 1 | 82945 | 8 | 1.296 | 64000.8 |
425 | 2019-10-29 05:01:35 | contents | 1 | 82945 | 8 | 1.530 | 54212.4 |
424 | 2019-10-23 11:35:53 | contents | 1 | 82945 | 8 | 1.300 | 63803.8 |
423 | 2019-10-06 14:33:15 | contents | 1 | 82945 | 8 | 1.210 | 68549.6 |
422 | 2019-09-20 15:14:37 | contents | 1 | 82945 | 8 | 1.226 | 67655.0 |