History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grams"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
713 | 2024-04-25 23:53:16 | grams | 1 | 28756 | 18 | 1.546 | 18600.3 |
712 | 2024-04-23 06:11:45 | grams | 1 | 28756 | 18 | 0.593 | 48492.4 |
711 | 2024-04-03 20:10:07 | grams | 1 | 28756 | 18 | 1.170 | 24577.8 |
710 | 2024-04-03 02:23:36 | grams | 1 | 28756 | 18 | 1.173 | 24514.9 |
709 | 2024-03-31 02:31:33 | grams | 1 | 28756 | 18 | 1.080 | 26625.9 |
708 | 2024-03-27 02:54:14 | grams | 1 | 28756 | 18 | 0.563 | 51076.4 |
707 | 2024-03-25 05:34:01 | grams | 1 | 28756 | 18 | 0.513 | 56054.6 |
706 | 2024-03-05 15:23:52 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
705 | 2024-02-29 23:23:56 | grams | 1 | 28756 | 18 | 0.530 | 54256.6 |
704 | 2024-02-25 19:09:58 | grams | 1 | 28756 | 18 | 0.470 | 61183.0 |
703 | 2024-01-29 00:27:13 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
702 | 2024-01-29 00:25:56 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
701 | 2024-01-26 18:54:41 | grams | 1 | 28756 | 18 | 0.513 | 56054.6 |
700 | 2024-01-17 18:25:40 | grams | 2 | 53800 | 260 | 1.593 | 33772.8 |
699 | 2024-01-14 14:14:48 | grams | 2 | 53800 | 260 | 1.436 | 37465.2 |
698 | 2023-12-22 17:36:47 | grams | 1 | 28756 | 18 | 0.486 | 59168.7 |
697 | 2023-12-18 14:12:50 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
696 | 2023-12-15 23:38:41 | grams | 1 | 28756 | 18 | 0.513 | 56054.6 |
695 | 2023-12-13 10:27:40 | grams | 2 | 53800 | 260 | 1.610 | 33416.1 |
694 | 2023-12-07 02:47:23 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
693 | 2023-11-22 08:31:38 | grams | 2 | 53800 | 260 | 1.626 | 33087.3 |
692 | 2023-11-17 14:07:12 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
691 | 2023-11-11 17:05:38 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
690 | 2023-11-09 02:38:28 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
689 | 2023-11-02 21:58:03 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
688 | 2023-10-28 20:43:57 | grams | 2 | 53800 | 260 | 1.640 | 32804.9 |
687 | 2023-10-28 18:15:45 | grams | 1 | 28756 | 18 | 0.626 | 45936.1 |
686 | 2023-10-24 03:08:41 | grams | 1 | 28756 | 18 | 0.483 | 59536.2 |
685 | 2023-10-20 17:50:56 | grams | 1 | 28756 | 18 | 0.563 | 51076.4 |
684 | 2023-10-12 01:22:36 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
683 | 2023-10-05 21:11:46 | grams | 1 | 28756 | 18 | 0.423 | 67981.1 |
682 | 2023-10-03 16:08:41 | grams | 1 | 28756 | 18 | 0.470 | 61183.0 |
681 | 2023-10-01 05:24:39 | grams | 2 | 53800 | 260 | 3.470 | 15504.3 |
680 | 2023-09-28 04:12:51 | grams | 2 | 53800 | 260 | 2.860 | 18811.2 |
679 | 2023-09-27 18:50:22 | grams | 1 | 28756 | 18 | 0.516 | 55728.7 |
678 | 2023-09-22 04:25:53 | grams | 1 | 28756 | 18 | 0.420 | 68466.7 |
677 | 2023-08-05 07:14:32 | grams | 2 | 53800 | 260 | 1.656 | 32487.9 |
676 | 2023-08-02 07:40:37 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
675 | 2023-07-26 04:01:58 | grams | 1 | 28756 | 18 | 0.440 | 65354.5 |
674 | 2023-05-24 10:07:49 | grams | 1 | 28756 | 18 | 0.470 | 61183.0 |
673 | 2023-04-29 15:43:13 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
672 | 2023-04-27 18:38:12 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
671 | 2023-04-21 15:34:47 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
670 | 2023-04-12 22:21:13 | grams | 2 | 53800 | 260 | 1.330 | 40451.1 |
669 | 2023-03-20 09:52:52 | grams | 1 | 28756 | 18 | 0.466 | 61708.2 |
668 | 2023-02-17 03:59:57 | grams | 1 | 28756 | 18 | 0.440 | 65354.5 |
667 | 2023-01-19 15:09:35 | grams | 2 | 53800 | 260 | 1.360 | 39558.8 |
666 | 2023-01-09 06:19:15 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
665 | 2022-12-14 08:24:46 | grams | 1 | 28756 | 18 | 0.516 | 55728.7 |
664 | 2022-11-01 02:56:33 | grams | 2 | 53800 | 260 | 1.330 | 40451.1 |
663 | 2022-09-29 01:30:16 | grams | 1 | 28756 | 18 | 0.450 | 63902.2 |
662 | 2022-08-26 08:04:16 | grams | 1 | 28756 | 18 | 0.450 | 63902.2 |
661 | 2022-08-19 09:25:07 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
660 | 2022-08-17 13:31:49 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
659 | 2022-08-14 01:49:10 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
658 | 2022-08-09 06:39:35 | grams | 1 | 28756 | 18 | 0.483 | 59536.2 |
657 | 2022-08-06 18:54:21 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
656 | 2022-08-01 01:03:17 | grams | 1 | 28756 | 18 | 0.423 | 67981.1 |
655 | 2022-07-29 23:55:10 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |
654 | 2022-07-21 17:08:48 | grams | 1 | 28756 | 18 | 0.470 | 61183.0 |
653 | 2022-07-17 21:16:01 | grams | 1 | 28756 | 18 | 0.420 | 68466.7 |
652 | 2022-07-05 17:54:29 | grams | 1 | 28756 | 18 | 0.453 | 63479.0 |
651 | 2022-06-28 10:32:09 | grams | 1 | 28756 | 18 | 0.420 | 68466.7 |
650 | 2022-06-23 04:53:32 | grams | 1 | 28756 | 18 | 0.486 | 59168.7 |
649 | 2022-05-21 18:58:47 | grams | 2 | 53800 | 260 | 1.360 | 39558.8 |
648 | 2022-04-08 14:00:28 | grams | 1 | 28756 | 18 | 0.593 | 48492.4 |
647 | 2022-04-07 18:08:33 | grams | 1 | 28756 | 18 | 0.546 | 52666.7 |
646 | 2022-04-07 16:39:14 | grams | 1 | 28756 | 18 | 0.626 | 45936.1 |
645 | 2022-04-06 13:49:11 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
644 | 2022-04-05 19:18:46 | grams | 1 | 28756 | 18 | 0.470 | 61183.0 |
643 | 2022-04-04 23:46:22 | grams | 1 | 28756 | 18 | 0.470 | 61183.0 |
642 | 2022-04-02 23:23:47 | grams | 1 | 28756 | 18 | 0.483 | 59536.2 |
641 | 2022-04-01 14:25:10 | grams | 1 | 28756 | 18 | 0.486 | 59168.7 |
640 | 2022-03-26 05:28:45 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
639 | 2022-03-19 22:41:11 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
638 | 2022-03-17 20:02:25 | grams | 1 | 28756 | 18 | 0.626 | 45936.1 |
637 | 2022-03-16 23:48:24 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
636 | 2022-03-10 14:50:56 | grams | 1 | 28756 | 18 | 0.546 | 52666.7 |
635 | 2022-01-09 07:31:25 | grams | 1 | 28756 | 18 | 0.530 | 54256.6 |
634 | 2022-01-04 06:45:49 | grams | 1 | 28756 | 18 | 0.466 | 61708.2 |
633 | 2022-01-03 17:11:00 | grams | 1 | 28756 | 18 | 0.516 | 55728.7 |
632 | 2022-01-02 10:53:03 | grams | 1 | 28756 | 18 | 0.470 | 61183.0 |
631 | 2022-01-01 18:55:18 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
630 | 2021-12-31 21:49:11 | grams | 1 | 28756 | 18 | 0.516 | 55728.7 |
629 | 2021-12-31 10:56:26 | grams | 1 | 28756 | 18 | 0.516 | 55728.7 |
628 | 2021-12-31 03:01:24 | grams | 1 | 28756 | 18 | 0.546 | 52666.7 |
627 | 2021-12-30 21:47:06 | grams | 1 | 28756 | 18 | 0.530 | 54256.6 |
626 | 2021-12-30 03:44:54 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
625 | 2021-12-29 20:41:18 | grams | 1 | 28756 | 18 | 0.563 | 51076.4 |
624 | 2021-12-29 09:25:20 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
623 | 2021-12-28 20:09:30 | grams | 1 | 28756 | 18 | 0.466 | 61708.2 |
622 | 2021-12-28 01:49:33 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
621 | 2021-12-27 16:27:20 | grams | 1 | 28756 | 18 | 0.513 | 56054.6 |
620 | 2021-12-26 18:10:26 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
619 | 2021-12-26 07:01:51 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
618 | 2021-12-25 14:37:17 | grams | 1 | 28756 | 18 | 0.516 | 55728.7 |
617 | 2021-12-25 05:03:20 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
616 | 2021-12-24 16:38:12 | grams | 1 | 28756 | 18 | 0.513 | 56054.6 |
615 | 2021-12-24 05:06:20 | grams | 1 | 28756 | 18 | 0.500 | 57512.0 |
614 | 2021-11-30 07:02:50 | grams | 1 | 28756 | 18 | 0.436 | 65954.1 |