History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"posts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
725 | 2024-04-27 10:13:47 | posts | 1 | 28756 | 13 | 0.516 | 55728.7 |
724 | 2024-04-20 19:23:05 | posts | 1 | 28756 | 13 | 0.580 | 49579.3 |
723 | 2024-04-04 19:53:45 | posts | 2 | 53800 | 283 | 8.530 | 6307.2 |
722 | 2024-04-03 10:56:01 | posts | 2 | 53800 | 283 | 5.670 | 9488.5 |
721 | 2024-04-03 08:10:46 | posts | 2 | 53800 | 283 | 5.156 | 10434.4 |
720 | 2024-04-03 08:03:00 | posts | 1 | 28756 | 13 | 1.733 | 16593.2 |
719 | 2024-03-29 06:53:43 | posts | 2 | 53800 | 283 | 5.486 | 9806.8 |
718 | 2024-03-29 04:24:46 | posts | 1 | 28756 | 13 | 0.530 | 54256.6 |
717 | 2024-03-29 03:44:15 | posts | 1 | 28756 | 13 | 0.546 | 52666.7 |
716 | 2024-03-20 18:19:03 | posts | 1 | 28756 | 13 | 0.546 | 52666.7 |
715 | 2024-03-20 18:18:34 | posts | 2 | 53800 | 283 | 3.403 | 15809.6 |
714 | 2024-03-20 18:18:10 | posts | 1 | 28756 | 13 | 0.533 | 53951.2 |
713 | 2024-03-09 04:37:18 | posts | 2 | 53800 | 283 | 1.406 | 38264.6 |
712 | 2024-03-04 06:59:56 | posts | 2 | 53800 | 283 | 1.546 | 34799.5 |
711 | 2024-03-04 06:59:55 | posts | 1 | 28756 | 13 | 0.500 | 57512.0 |
710 | 2024-02-28 01:07:15 | posts | 1 | 28756 | 13 | 0.576 | 49923.6 |
709 | 2024-02-27 22:05:11 | posts | 2 | 53800 | 283 | 1.890 | 28465.6 |
708 | 2024-02-27 18:19:12 | posts | 2 | 53800 | 283 | 1.563 | 34421.0 |
707 | 2024-02-19 15:42:10 | posts | 1 | 28756 | 13 | 0.640 | 44931.3 |
706 | 2024-02-03 02:43:51 | posts | 1 | 28756 | 13 | 1.030 | 27918.4 |
705 | 2024-01-28 21:29:21 | posts | 1 | 28756 | 13 | 0.516 | 55728.7 |
704 | 2024-01-26 19:52:52 | posts | 2 | 53800 | 283 | 1.403 | 38346.4 |
703 | 2024-01-24 05:04:46 | posts | 1 | 28756 | 13 | 0.436 | 65954.1 |
702 | 2024-01-21 11:47:23 | posts | 1 | 28756 | 13 | 0.513 | 56054.6 |
701 | 2024-01-19 08:04:47 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
700 | 2024-01-10 11:31:38 | posts | 2 | 53800 | 283 | 1.563 | 34421.0 |
699 | 2023-12-27 14:54:42 | posts | 2 | 53800 | 283 | 1.656 | 32487.9 |
698 | 2023-11-24 10:37:15 | posts | 2 | 53800 | 283 | 1.436 | 37465.2 |
697 | 2023-11-21 05:40:13 | posts | 1 | 28756 | 13 | 0.486 | 59168.7 |
696 | 2023-11-21 05:34:13 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
695 | 2023-11-12 23:17:07 | posts | 1 | 28756 | 13 | 0.436 | 65954.1 |
694 | 2023-11-07 08:00:49 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
693 | 2023-11-01 03:35:22 | posts | 1 | 28756 | 13 | 0.500 | 57512.0 |
692 | 2023-10-20 02:16:44 | posts | 1 | 28756 | 13 | 0.593 | 48492.4 |
691 | 2023-10-18 10:58:36 | posts | 1 | 28756 | 13 | 0.450 | 63902.2 |
690 | 2023-10-16 13:18:24 | posts | 1 | 28756 | 13 | 0.486 | 59168.7 |
689 | 2023-10-03 22:58:45 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
688 | 2023-09-30 15:18:41 | posts | 1 | 28756 | 13 | 0.486 | 59168.7 |
687 | 2023-09-28 17:38:00 | posts | 2 | 53800 | 283 | 1.686 | 31909.8 |
686 | 2023-09-26 08:57:51 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
685 | 2023-09-24 06:58:42 | posts | 2 | 53800 | 283 | 1.500 | 35866.7 |
684 | 2023-09-19 10:42:40 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
683 | 2023-09-08 14:23:37 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
682 | 2023-08-25 12:23:16 | posts | 2 | 53800 | 283 | 1.580 | 34050.6 |
681 | 2023-06-16 21:26:34 | posts | 1 | 28756 | 13 | 0.436 | 65954.1 |
680 | 2023-06-14 02:10:57 | posts | 1 | 28756 | 13 | 0.436 | 65954.1 |
679 | 2023-05-06 02:54:45 | posts | 2 | 53800 | 283 | 1.640 | 32804.9 |
678 | 2023-04-02 13:33:50 | posts | 1 | 28756 | 13 | 0.436 | 65954.1 |
677 | 2023-03-25 20:03:00 | posts | 1 | 28756 | 13 | 0.500 | 57512.0 |
676 | 2023-03-01 03:47:15 | posts | 1 | 28756 | 13 | 0.436 | 65954.1 |
675 | 2023-02-12 05:24:11 | posts | 2 | 53800 | 283 | 1.406 | 38264.6 |
674 | 2023-01-18 13:25:18 | posts | 1 | 28756 | 13 | 0.436 | 65954.1 |
673 | 2022-11-22 18:25:07 | posts | 2 | 53800 | 283 | 1.373 | 39184.3 |
672 | 2022-11-16 21:35:43 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
671 | 2022-11-12 07:08:59 | posts | 1 | 28756 | 13 | 0.440 | 65354.5 |
670 | 2022-07-29 03:50:42 | posts | 1 | 28756 | 13 | 0.500 | 57512.0 |
669 | 2022-07-23 02:26:51 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
668 | 2022-07-08 11:06:20 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
667 | 2022-06-29 02:55:14 | posts | 2 | 53800 | 283 | 1.376 | 39098.8 |
666 | 2022-06-26 20:38:20 | posts | 2 | 53800 | 283 | 1.610 | 33416.1 |
665 | 2022-05-18 10:58:46 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
664 | 2022-03-21 22:53:02 | posts | 1 | 28756 | 13 | 0.530 | 54256.6 |
663 | 2022-03-18 12:20:46 | posts | 1 | 28756 | 13 | 0.466 | 61708.2 |
662 | 2022-03-06 17:30:05 | posts | 1 | 28756 | 13 | 0.486 | 59168.7 |
661 | 2022-03-04 13:42:02 | posts | 1 | 28756 | 13 | 0.486 | 59168.7 |
660 | 2022-02-06 01:55:23 | posts | 2 | 53800 | 283 | 1.390 | 38705.0 |
659 | 2022-01-15 13:47:08 | posts | 1 | 28756 | 13 | 0.483 | 59536.2 |
658 | 2021-12-13 01:06:14 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
657 | 2021-12-11 07:01:23 | posts | 1 | 28756 | 13 | 0.936 | 30722.2 |
656 | 2021-11-28 03:06:06 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
655 | 2021-11-24 04:48:19 | posts | 1 | 28756 | 13 | 0.516 | 55728.7 |
654 | 2021-11-09 04:54:22 | posts | 2 | 53800 | 283 | 1.393 | 38621.7 |
653 | 2021-11-06 02:55:59 | posts | 1 | 28756 | 13 | 0.470 | 61183.0 |
652 | 2021-10-20 06:57:14 | posts | 1 | 28756 | 13 | 0.470 | 61183.0 |
651 | 2021-09-14 11:45:18 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
650 | 2021-09-07 05:07:08 | posts | 1 | 28756 | 13 | 0.500 | 57512.0 |
649 | 2021-08-30 02:35:20 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
648 | 2021-06-06 06:24:36 | posts | 1 | 28756 | 13 | 0.516 | 55728.7 |
647 | 2021-06-03 01:43:55 | posts | 1 | 28756 | 13 | 0.500 | 57512.0 |
646 | 2021-05-26 02:26:09 | posts | 1 | 28756 | 13 | 0.513 | 56054.6 |
645 | 2021-02-28 14:14:14 | posts | 1 | 28756 | 13 | 0.500 | 57512.0 |
644 | 2021-02-25 22:25:03 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
643 | 2021-01-13 04:48:27 | posts | 1 | 28756 | 13 | 0.516 | 55728.7 |
642 | 2020-11-28 18:28:59 | posts | 1 | 28756 | 13 | 0.470 | 61183.0 |
641 | 2020-10-22 04:22:38 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
640 | 2020-10-19 18:43:26 | posts | 1 | 28756 | 13 | 0.436 | 65954.1 |
639 | 2020-09-30 13:21:22 | posts | 1 | 28756 | 13 | 0.440 | 65354.5 |
638 | 2020-09-06 22:49:44 | posts | 1 | 28756 | 13 | 0.436 | 65954.1 |
637 | 2020-08-25 13:43:53 | posts | 1 | 28756 | 13 | 0.470 | 61183.0 |
636 | 2020-08-06 09:23:50 | posts | 1 | 28756 | 13 | 0.546 | 52666.7 |
635 | 2020-08-05 07:45:24 | posts | 1 | 28756 | 13 | 0.530 | 54256.6 |
634 | 2020-08-05 02:55:53 | posts | 1 | 28756 | 13 | 0.610 | 47141.0 |
633 | 2020-07-29 04:18:17 | posts | 1 | 28756 | 13 | 0.500 | 57512.0 |
632 | 2020-07-28 11:37:49 | posts | 1 | 28756 | 13 | 0.516 | 55728.7 |
631 | 2020-07-27 06:56:55 | posts | 1 | 28756 | 13 | 0.500 | 57512.0 |
630 | 2020-07-26 11:16:20 | posts | 1 | 28756 | 13 | 0.470 | 61183.0 |
629 | 2020-07-25 13:25:45 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |
628 | 2020-06-02 09:27:08 | posts | 1 | 28756 | 13 | 0.483 | 59536.2 |
627 | 2020-05-29 13:47:30 | posts | 1 | 28756 | 13 | 0.440 | 65354.5 |
626 | 2020-05-28 13:59:51 | posts | 1 | 28756 | 13 | 0.453 | 63479.0 |