History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"state"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
757 | 2024-03-01 08:56:05 | state | 1 | 28756 | 21 | 0.533 | 53951.2 |
756 | 2024-02-28 04:47:53 | state | 2 | 53800 | 276 | 5.610 | 9590.0 |
755 | 2024-02-27 22:59:19 | state | 2 | 53800 | 276 | 2.076 | 25915.2 |
754 | 2024-02-27 20:39:54 | state | 1 | 28756 | 21 | 1.033 | 27837.4 |
753 | 2024-02-19 05:03:10 | state | 1 | 28756 | 21 | 0.560 | 51350.0 |
752 | 2024-01-28 22:58:29 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
751 | 2024-01-01 10:36:45 | state | 2 | 53800 | 276 | 1.393 | 38621.7 |
750 | 2023-12-30 05:21:40 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
749 | 2023-12-18 06:49:09 | state | 1 | 28756 | 21 | 0.483 | 59536.2 |
748 | 2023-12-17 21:27:29 | state | 2 | 53800 | 276 | 1.703 | 31591.3 |
747 | 2023-12-14 18:11:55 | state | 1 | 28756 | 21 | 0.516 | 55728.7 |
746 | 2023-12-07 23:59:11 | state | 2 | 53800 | 276 | 1.420 | 37887.3 |
745 | 2023-12-07 23:59:09 | state | 2 | 53800 | 276 | 1.453 | 37026.8 |
744 | 2023-12-07 13:44:08 | state | 2 | 53800 | 276 | 1.686 | 31909.8 |
743 | 2023-12-02 12:33:09 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
742 | 2023-11-18 12:12:01 | state | 1 | 28756 | 21 | 0.546 | 52666.7 |
741 | 2023-11-11 17:51:10 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
740 | 2023-11-11 07:15:33 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
739 | 2023-11-11 04:04:32 | state | 1 | 28756 | 21 | 0.513 | 56054.6 |
738 | 2023-10-30 22:06:04 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
737 | 2023-10-26 10:05:55 | state | 1 | 28756 | 21 | 0.516 | 55728.7 |
736 | 2023-10-22 11:21:38 | state | 1 | 28756 | 21 | 1.190 | 24164.7 |
735 | 2023-10-18 20:48:32 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
734 | 2023-10-14 22:19:02 | state | 1 | 28756 | 21 | 0.483 | 59536.2 |
733 | 2023-10-08 02:33:26 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
732 | 2023-09-28 09:49:55 | state | 2 | 53800 | 276 | 1.546 | 34799.5 |
731 | 2023-09-26 12:39:41 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
730 | 2023-09-22 11:11:34 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
729 | 2023-09-17 06:28:16 | state | 1 | 28756 | 21 | 0.486 | 59168.7 |
728 | 2023-09-16 03:51:42 | state | 1 | 28756 | 21 | 0.440 | 65354.5 |
727 | 2023-08-02 05:43:04 | state | 1 | 28756 | 21 | 0.530 | 54256.6 |
726 | 2023-07-06 00:42:53 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
725 | 2023-06-25 16:35:38 | state | 1 | 28756 | 21 | 0.483 | 59536.2 |
724 | 2023-04-04 11:40:24 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
723 | 2023-03-19 03:22:44 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
722 | 2023-01-18 06:06:32 | state | 1 | 28756 | 21 | 0.483 | 59536.2 |
721 | 2022-11-24 12:00:56 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
720 | 2022-11-14 14:42:00 | state | 1 | 28756 | 21 | 0.470 | 61183.0 |
719 | 2022-09-01 10:08:49 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
718 | 2022-08-15 17:56:05 | state | 2 | 53800 | 276 | 1.393 | 38621.7 |
717 | 2022-08-07 19:29:33 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
716 | 2022-07-29 02:56:53 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
715 | 2022-07-28 06:39:09 | state | 1 | 28756 | 21 | 0.486 | 59168.7 |
714 | 2022-07-19 09:48:35 | state | 2 | 53800 | 276 | 1.373 | 39184.3 |
713 | 2022-07-17 23:18:04 | state | 1 | 28756 | 21 | 0.440 | 65354.5 |
712 | 2022-07-04 11:01:07 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
711 | 2022-07-03 03:13:21 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
710 | 2022-06-08 23:11:18 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
709 | 2022-03-30 05:33:19 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
708 | 2022-03-26 18:08:08 | state | 1 | 28756 | 21 | 0.516 | 55728.7 |
707 | 2022-03-22 03:57:13 | state | 1 | 28756 | 21 | 0.516 | 55728.7 |
706 | 2022-03-21 17:15:52 | state | 1 | 28756 | 21 | 0.656 | 43835.4 |
705 | 2022-03-21 15:39:19 | state | 1 | 28756 | 21 | 0.516 | 55728.7 |
704 | 2022-03-20 19:53:09 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
703 | 2022-03-20 15:38:22 | state | 1 | 28756 | 21 | 0.450 | 63902.2 |
702 | 2022-03-07 02:55:02 | state | 1 | 28756 | 21 | 0.470 | 61183.0 |
701 | 2022-02-24 14:47:33 | state | 1 | 28756 | 21 | 0.576 | 49923.6 |
700 | 2022-02-21 16:18:03 | state | 1 | 28756 | 21 | 0.533 | 53951.2 |
699 | 2022-02-20 20:33:24 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
698 | 2022-02-19 22:21:39 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
697 | 2022-02-19 17:00:02 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
696 | 2022-02-18 21:47:58 | state | 1 | 28756 | 21 | 0.470 | 61183.0 |
695 | 2022-02-18 15:48:07 | state | 1 | 28756 | 21 | 0.656 | 43835.4 |
694 | 2022-02-17 19:43:55 | state | 1 | 28756 | 21 | 0.530 | 54256.6 |
693 | 2022-02-15 21:27:24 | state | 1 | 28756 | 21 | 0.533 | 53951.2 |
692 | 2022-02-14 23:52:25 | state | 1 | 28756 | 21 | 1.030 | 27918.4 |
691 | 2021-12-21 19:10:10 | state | 1 | 28756 | 21 | 0.530 | 54256.6 |
690 | 2021-12-12 14:05:31 | state | 1 | 28756 | 21 | 0.563 | 51076.4 |
689 | 2021-10-30 20:32:32 | state | 1 | 28756 | 21 | 0.486 | 59168.7 |
688 | 2021-10-29 19:12:54 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
687 | 2021-10-28 19:02:00 | state | 1 | 28756 | 21 | 0.670 | 42919.4 |
686 | 2021-09-21 07:55:58 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
685 | 2021-09-06 05:20:07 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
684 | 2021-09-05 07:52:14 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
683 | 2021-09-02 00:21:33 | state | 1 | 28756 | 21 | 0.516 | 55728.7 |
682 | 2021-08-08 17:13:28 | state | 1 | 28756 | 21 | 0.440 | 65354.5 |
681 | 2021-07-02 16:47:57 | state | 1 | 28756 | 21 | 0.516 | 55728.7 |
680 | 2021-06-01 07:19:45 | state | 1 | 28756 | 21 | 0.500 | 57512.0 |
679 | 2021-05-16 20:12:04 | state | 1 | 28756 | 21 | 0.516 | 55728.7 |
678 | 2021-04-15 12:42:44 | state | 1 | 28756 | 21 | 0.516 | 55728.7 |
677 | 2021-04-01 10:08:47 | state | 2 | 53800 | 276 | 1.610 | 33416.1 |
676 | 2021-02-27 17:12:51 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
675 | 2021-02-26 03:52:47 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
674 | 2021-02-21 14:40:03 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
673 | 2021-01-16 11:18:23 | state | 2 | 53800 | 276 | 1.390 | 38705.0 |
672 | 2020-12-30 22:17:27 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
671 | 2020-11-13 02:20:47 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |
670 | 2020-11-11 16:10:07 | state | 1 | 28756 | 21 | 0.486 | 59168.7 |
669 | 2020-11-03 11:40:45 | state | 1 | 28756 | 21 | 0.563 | 51076.4 |
668 | 2020-10-30 08:43:25 | state | 1 | 28756 | 21 | 0.466 | 61708.2 |
667 | 2020-10-29 23:48:46 | state | 1 | 28756 | 21 | 0.610 | 47141.0 |
666 | 2020-10-26 04:14:27 | state | 2 | 53800 | 276 | 1.406 | 38264.6 |
665 | 2020-10-25 00:03:29 | state | 2 | 53800 | 276 | 2.986 | 18017.4 |
664 | 2020-10-22 00:20:19 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
663 | 2020-10-18 10:34:40 | state | 2 | 53800 | 276 | 1.483 | 36277.8 |
662 | 2020-10-16 11:11:29 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
661 | 2020-10-14 06:54:58 | state | 2 | 53800 | 276 | 1.483 | 36277.8 |
660 | 2020-10-13 12:44:53 | state | 2 | 53800 | 276 | 1.406 | 38264.6 |
659 | 2020-09-06 23:28:52 | state | 1 | 28756 | 21 | 0.436 | 65954.1 |
658 | 2020-08-24 09:44:52 | state | 1 | 28756 | 21 | 0.453 | 63479.0 |