History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"asper"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
726 | 2024-05-04 03:44:39 | asper | 1 | 28756 | 9 | 0.546 | 52666.7 |
725 | 2024-04-30 09:36:02 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
724 | 2024-04-30 07:24:54 | asper | 1 | 28756 | 9 | 0.563 | 51076.4 |
723 | 2024-04-30 06:49:12 | asper | 1 | 28756 | 9 | 0.610 | 47141.0 |
722 | 2024-04-29 08:25:54 | asper | 1 | 28756 | 9 | 0.516 | 55728.7 |
721 | 2024-04-27 10:50:24 | asper | 1 | 28756 | 9 | 1.140 | 25224.6 |
720 | 2024-04-27 03:23:52 | asper | 1 | 28756 | 9 | 0.593 | 48492.4 |
719 | 2024-04-08 13:53:09 | asper | 1 | 28756 | 9 | 0.580 | 49579.3 |
718 | 2024-04-03 07:16:30 | asper | 2 | 53800 | 182 | 1.656 | 32487.9 |
717 | 2024-04-03 07:16:26 | asper | 1 | 28756 | 9 | 0.533 | 53951.2 |
716 | 2024-04-03 07:16:18 | asper | 2 | 53800 | 182 | 1.940 | 27732.0 |
715 | 2024-04-03 07:16:14 | asper | 1 | 28756 | 9 | 0.533 | 53951.2 |
714 | 2024-03-31 04:56:51 | asper | 2 | 53800 | 182 | 5.763 | 9335.4 |
713 | 2024-03-31 04:15:08 | asper | 1 | 28756 | 9 | 1.203 | 23903.6 |
712 | 2024-03-29 02:47:11 | asper | 1 | 28756 | 9 | 0.656 | 43835.4 |
711 | 2024-03-04 00:19:49 | asper | 2 | 53800 | 182 | 4.690 | 11471.2 |
710 | 2024-03-04 00:11:12 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
709 | 2024-03-01 02:26:20 | asper | 1 | 28756 | 9 | 0.533 | 53951.2 |
708 | 2024-02-27 19:43:48 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
707 | 2024-02-08 21:18:03 | asper | 2 | 53800 | 182 | 1.890 | 28465.6 |
706 | 2024-02-02 22:53:19 | asper | 1 | 28756 | 9 | 0.533 | 53951.2 |
705 | 2024-01-28 19:12:27 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
704 | 2024-01-28 17:55:37 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
703 | 2024-01-13 06:38:16 | asper | 1 | 28756 | 9 | 0.516 | 55728.7 |
702 | 2024-01-12 08:41:02 | asper | 2 | 53800 | 182 | 1.580 | 34050.6 |
701 | 2023-12-28 19:39:48 | asper | 1 | 28756 | 9 | 0.516 | 55728.7 |
700 | 2023-12-17 08:06:17 | asper | 2 | 53800 | 182 | 1.826 | 29463.3 |
699 | 2023-12-16 13:36:24 | asper | 2 | 53800 | 182 | 1.500 | 35866.7 |
698 | 2023-11-28 01:44:55 | asper | 2 | 53800 | 182 | 1.610 | 33416.1 |
697 | 2023-11-19 11:33:14 | asper | 1 | 28756 | 9 | 0.530 | 54256.6 |
696 | 2023-11-11 23:02:16 | asper | 2 | 53800 | 182 | 1.453 | 37026.8 |
695 | 2023-11-11 21:22:30 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
694 | 2023-11-01 09:35:57 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
693 | 2023-10-21 23:54:23 | asper | 1 | 28756 | 9 | 0.486 | 59168.7 |
692 | 2023-10-17 15:59:06 | asper | 1 | 28756 | 9 | 0.486 | 59168.7 |
691 | 2023-10-17 15:38:06 | asper | 1 | 28756 | 9 | 0.513 | 56054.6 |
690 | 2023-10-14 01:19:36 | asper | 1 | 28756 | 9 | 0.516 | 55728.7 |
689 | 2023-10-06 05:09:43 | asper | 1 | 28756 | 9 | 0.486 | 59168.7 |
688 | 2023-10-03 03:41:27 | asper | 1 | 28756 | 9 | 0.450 | 63902.2 |
687 | 2023-09-27 04:24:51 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
686 | 2023-09-23 06:13:46 | asper | 1 | 28756 | 9 | 0.623 | 46157.3 |
685 | 2023-09-02 18:09:26 | asper | 1 | 28756 | 9 | 0.483 | 59536.2 |
684 | 2023-08-14 09:58:09 | asper | 2 | 53800 | 182 | 1.640 | 32804.9 |
683 | 2023-08-13 02:26:38 | asper | 1 | 28756 | 9 | 0.470 | 61183.0 |
682 | 2023-07-12 23:17:42 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
681 | 2023-06-29 21:38:48 | asper | 1 | 28756 | 9 | 0.483 | 59536.2 |
680 | 2023-05-14 00:22:14 | asper | 1 | 28756 | 9 | 0.436 | 65954.1 |
679 | 2023-04-27 13:15:54 | asper | 2 | 53800 | 182 | 1.406 | 38264.6 |
678 | 2023-04-23 23:09:16 | asper | 1 | 28756 | 9 | 0.533 | 53951.2 |
677 | 2023-03-27 14:56:39 | asper | 1 | 28756 | 9 | 0.516 | 55728.7 |
676 | 2023-03-23 16:29:28 | asper | 1 | 28756 | 9 | 0.440 | 65354.5 |
675 | 2023-03-13 06:20:36 | asper | 1 | 28756 | 9 | 1.063 | 27051.7 |
674 | 2023-03-06 20:46:35 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
673 | 2023-03-02 02:28:01 | asper | 1 | 28756 | 9 | 0.530 | 54256.6 |
672 | 2023-02-26 21:42:00 | asper | 2 | 53800 | 182 | 1.393 | 38621.7 |
671 | 2023-01-31 14:58:40 | asper | 2 | 53800 | 182 | 1.390 | 38705.0 |
670 | 2023-01-19 10:43:42 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
669 | 2023-01-10 05:07:44 | asper | 1 | 28756 | 9 | 0.483 | 59536.2 |
668 | 2023-01-07 00:38:11 | asper | 2 | 53800 | 182 | 1.563 | 34421.0 |
667 | 2022-12-29 11:03:25 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
666 | 2022-12-19 21:02:58 | asper | 2 | 53800 | 182 | 1.406 | 38264.6 |
665 | 2022-12-12 02:50:06 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
664 | 2022-12-10 02:24:12 | asper | 2 | 53800 | 182 | 1.576 | 34137.1 |
663 | 2022-12-05 10:46:45 | asper | 1 | 28756 | 9 | 0.436 | 65954.1 |
662 | 2022-11-25 17:48:02 | asper | 1 | 28756 | 9 | 0.516 | 55728.7 |
661 | 2022-11-14 10:10:26 | asper | 2 | 53800 | 182 | 1.466 | 36698.5 |
660 | 2022-10-19 12:19:22 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
659 | 2022-10-09 09:14:12 | asper | 1 | 28756 | 9 | 0.486 | 59168.7 |
658 | 2022-09-19 02:43:36 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
657 | 2022-09-16 06:33:11 | asper | 1 | 28756 | 9 | 0.450 | 63902.2 |
656 | 2022-09-05 20:12:35 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
655 | 2022-09-03 21:19:26 | asper | 1 | 28756 | 9 | 0.483 | 59536.2 |
654 | 2022-09-01 03:51:31 | asper | 1 | 28756 | 9 | 0.906 | 31739.5 |
653 | 2022-08-27 03:22:40 | asper | 1 | 28756 | 9 | 0.516 | 55728.7 |
652 | 2022-08-15 16:42:29 | asper | 1 | 28756 | 9 | 0.456 | 63061.4 |
651 | 2022-08-14 15:47:45 | asper | 1 | 28756 | 9 | 0.483 | 59536.2 |
650 | 2022-08-14 12:44:42 | asper | 1 | 28756 | 9 | 0.500 | 57512.0 |
649 | 2022-08-06 05:47:15 | asper | 1 | 28756 | 9 | 0.436 | 65954.1 |
648 | 2022-07-28 19:50:56 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
647 | 2022-07-17 19:54:03 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
646 | 2022-07-17 18:27:48 | asper | 1 | 28756 | 9 | 0.440 | 65354.5 |
645 | 2022-07-15 20:07:39 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
644 | 2022-07-06 23:31:42 | asper | 1 | 28756 | 9 | 0.483 | 59536.2 |
643 | 2022-06-18 02:22:28 | asper | 2 | 53800 | 182 | 1.423 | 37807.4 |
642 | 2022-05-28 17:58:42 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
641 | 2022-05-23 04:34:06 | asper | 1 | 28756 | 9 | 0.483 | 59536.2 |
640 | 2022-05-19 18:25:06 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
639 | 2022-05-19 11:38:19 | asper | 1 | 28756 | 9 | 0.533 | 53951.2 |
638 | 2022-04-26 01:52:19 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
637 | 2022-04-23 19:52:58 | asper | 1 | 28756 | 9 | 0.453 | 63479.0 |
636 | 2022-04-21 16:21:55 | asper | 1 | 28756 | 9 | 0.626 | 45936.1 |
635 | 2022-04-10 06:12:52 | asper | 1 | 28756 | 9 | 0.516 | 55728.7 |
634 | 2022-03-31 23:46:37 | asper | 1 | 28756 | 9 | 0.690 | 41675.4 |
633 | 2022-02-15 02:26:16 | asper | 1 | 28756 | 9 | 0.440 | 65354.5 |
632 | 2022-02-11 13:33:03 | asper | 1 | 28756 | 9 | 0.466 | 61708.2 |
631 | 2022-01-13 01:28:27 | asper | 1 | 28756 | 9 | 0.436 | 65954.1 |
630 | 2022-01-03 18:53:37 | asper | 1 | 28756 | 9 | 0.560 | 51350.0 |
629 | 2021-12-01 10:20:36 | asper | 1 | 28756 | 9 | 0.513 | 56054.6 |
628 | 2021-11-17 16:50:08 | asper | 1 | 28756 | 9 | 0.533 | 53951.2 |
627 | 2021-11-13 04:23:28 | asper | 1 | 28756 | 9 | 0.470 | 61183.0 |