History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"plate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
808 | 2024-04-03 02:30:23 | plate | 2 | 53800 | 240 | 3.766 | 14285.7 |
807 | 2024-04-03 02:22:07 | plate | 1 | 28756 | 19 | 1.110 | 25906.3 |
806 | 2024-03-31 02:38:05 | plate | 1 | 28756 | 19 | 0.530 | 54256.6 |
805 | 2024-03-28 20:15:03 | plate | 2 | 53800 | 240 | 1.593 | 33772.8 |
804 | 2024-03-28 20:14:56 | plate | 1 | 28756 | 19 | 0.513 | 56054.6 |
803 | 2024-03-28 20:14:45 | plate | 2 | 53800 | 240 | 1.656 | 32487.9 |
802 | 2024-03-28 20:14:41 | plate | 1 | 28756 | 19 | 0.450 | 63902.2 |
801 | 2024-02-28 10:31:16 | plate | 1 | 28756 | 19 | 2.063 | 13938.9 |
800 | 2024-02-27 08:56:17 | plate | 2 | 53800 | 240 | 1.703 | 31591.3 |
799 | 2024-02-26 08:41:03 | plate | 2 | 53800 | 240 | 2.436 | 22085.4 |
798 | 2024-02-26 08:41:00 | plate | 1 | 28756 | 19 | 0.530 | 54256.6 |
797 | 2024-02-19 17:27:27 | plate | 1 | 28756 | 19 | 0.563 | 51076.4 |
796 | 2024-01-27 04:20:45 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
795 | 2024-01-17 22:16:39 | plate | 2 | 53800 | 240 | 1.563 | 34421.0 |
794 | 2023-12-29 21:36:48 | plate | 1 | 28756 | 19 | 0.483 | 59536.2 |
793 | 2023-12-18 17:25:27 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
792 | 2023-12-06 16:25:53 | plate | 2 | 53800 | 240 | 1.593 | 33772.8 |
791 | 2023-12-03 00:57:44 | plate | 1 | 28756 | 19 | 0.530 | 54256.6 |
790 | 2023-11-26 06:29:44 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
789 | 2023-11-25 10:43:18 | plate | 2 | 53800 | 240 | 1.360 | 39558.8 |
788 | 2023-11-25 02:50:53 | plate | 1 | 28756 | 19 | 0.483 | 59536.2 |
787 | 2023-11-12 11:43:36 | plate | 2 | 53800 | 240 | 1.533 | 35094.6 |
786 | 2023-11-11 18:12:17 | plate | 2 | 53800 | 240 | 1.626 | 33087.3 |
785 | 2023-11-11 05:23:23 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
784 | 2023-11-07 12:39:35 | plate | 1 | 28756 | 19 | 0.470 | 61183.0 |
783 | 2023-10-28 07:38:28 | plate | 1 | 28756 | 19 | 0.530 | 54256.6 |
782 | 2023-10-26 17:09:55 | plate | 2 | 53800 | 240 | 1.703 | 31591.3 |
781 | 2023-10-21 23:50:18 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
780 | 2023-10-18 16:10:45 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
779 | 2023-10-11 03:16:29 | plate | 1 | 28756 | 19 | 0.486 | 59168.7 |
778 | 2023-10-05 02:58:45 | plate | 1 | 28756 | 19 | 0.453 | 63479.0 |
777 | 2023-09-24 02:10:50 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
776 | 2023-09-22 17:16:58 | plate | 1 | 28756 | 19 | 0.470 | 61183.0 |
775 | 2023-09-16 23:53:27 | plate | 1 | 28756 | 19 | 0.890 | 32310.1 |
774 | 2023-08-10 08:55:31 | plate | 1 | 28756 | 19 | 0.486 | 59168.7 |
773 | 2023-08-03 01:15:07 | plate | 2 | 53800 | 240 | 1.436 | 37465.2 |
772 | 2023-07-02 15:14:48 | plate | 1 | 28756 | 19 | 0.453 | 63479.0 |
771 | 2023-05-06 14:33:48 | plate | 1 | 28756 | 19 | 0.533 | 53951.2 |
770 | 2023-04-13 13:36:56 | plate | 1 | 28756 | 19 | 0.420 | 68466.7 |
769 | 2023-04-09 15:08:49 | plate | 2 | 53800 | 240 | 1.343 | 40059.6 |
768 | 2023-02-06 03:29:02 | plate | 1 | 28756 | 19 | 0.470 | 61183.0 |
767 | 2023-01-24 07:14:42 | plate | 1 | 28756 | 19 | 0.483 | 59536.2 |
766 | 2023-01-17 06:45:17 | plate | 2 | 53800 | 240 | 1.670 | 32215.6 |
765 | 2022-12-04 17:30:52 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
764 | 2022-10-28 02:17:21 | plate | 2 | 53800 | 240 | 1.530 | 35163.4 |
763 | 2022-10-09 22:51:15 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
762 | 2022-09-01 09:12:37 | plate | 1 | 28756 | 19 | 0.470 | 61183.0 |
761 | 2022-07-31 22:45:59 | plate | 1 | 28756 | 19 | 0.440 | 65354.5 |
760 | 2022-07-29 15:02:46 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
759 | 2022-07-29 00:13:03 | plate | 1 | 28756 | 19 | 0.486 | 59168.7 |
758 | 2022-07-18 18:20:20 | plate | 1 | 28756 | 19 | 0.453 | 63479.0 |
757 | 2022-06-30 23:31:52 | plate | 1 | 28756 | 19 | 0.440 | 65354.5 |
756 | 2022-06-17 02:25:30 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
755 | 2022-06-08 17:22:30 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
754 | 2022-06-01 20:30:44 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
753 | 2022-06-01 13:40:12 | plate | 1 | 28756 | 19 | 0.440 | 65354.5 |
752 | 2022-05-25 17:15:55 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
751 | 2022-05-24 16:14:02 | plate | 2 | 53800 | 240 | 1.660 | 32409.6 |
750 | 2022-05-22 11:17:40 | plate | 2 | 53800 | 240 | 1.406 | 38264.6 |
749 | 2022-03-25 17:12:04 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
748 | 2022-03-23 13:41:46 | plate | 1 | 28756 | 19 | 0.533 | 53951.2 |
747 | 2022-03-22 01:18:21 | plate | 1 | 28756 | 19 | 0.453 | 63479.0 |
746 | 2022-03-20 23:37:11 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
745 | 2022-03-17 13:01:41 | plate | 1 | 28756 | 19 | 0.640 | 44931.3 |
744 | 2022-03-11 12:38:58 | plate | 1 | 28756 | 19 | 0.440 | 65354.5 |
743 | 2022-03-10 22:15:43 | plate | 1 | 28756 | 19 | 0.796 | 36125.6 |
742 | 2022-03-09 20:48:53 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
741 | 2022-03-08 16:50:03 | plate | 1 | 28756 | 19 | 0.733 | 39230.6 |
740 | 2022-03-07 20:35:27 | plate | 1 | 28756 | 19 | 0.563 | 51076.4 |
739 | 2022-03-06 19:21:15 | plate | 1 | 28756 | 19 | 0.453 | 63479.0 |
738 | 2022-03-05 19:08:35 | plate | 1 | 28756 | 19 | 0.470 | 61183.0 |
737 | 2022-03-04 19:00:28 | plate | 1 | 28756 | 19 | 0.470 | 61183.0 |
736 | 2022-03-03 12:39:34 | plate | 1 | 28756 | 19 | 0.606 | 47452.1 |
735 | 2022-03-02 22:52:06 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
734 | 2022-01-17 19:56:17 | plate | 1 | 28756 | 19 | 0.516 | 55728.7 |
733 | 2022-01-16 16:35:29 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
732 | 2022-01-15 22:34:21 | plate | 1 | 28756 | 19 | 0.440 | 65354.5 |
731 | 2022-01-11 01:34:08 | plate | 2 | 53800 | 240 | 1.453 | 37026.8 |
730 | 2022-01-03 09:06:43 | plate | 1 | 28756 | 19 | 0.516 | 55728.7 |
729 | 2022-01-02 20:28:17 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
728 | 2022-01-01 17:42:18 | plate | 1 | 28756 | 19 | 0.546 | 52666.7 |
727 | 2022-01-01 05:23:56 | plate | 1 | 28756 | 19 | 0.516 | 55728.7 |
726 | 2021-12-17 12:55:21 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
725 | 2021-12-17 01:37:14 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
724 | 2021-12-16 18:47:16 | plate | 1 | 28756 | 19 | 0.470 | 61183.0 |
723 | 2021-12-16 06:21:38 | plate | 1 | 28756 | 19 | 0.436 | 65954.1 |
722 | 2021-12-15 20:46:49 | plate | 1 | 28756 | 19 | 0.486 | 59168.7 |
721 | 2021-12-15 03:56:03 | plate | 1 | 28756 | 19 | 0.530 | 54256.6 |
720 | 2021-12-14 17:30:21 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
719 | 2021-12-07 02:15:54 | plate | 1 | 28756 | 19 | 0.576 | 49923.6 |
718 | 2021-12-03 19:36:48 | plate | 1 | 28756 | 19 | 0.503 | 57169.0 |
717 | 2021-11-15 03:50:06 | plate | 1 | 28756 | 19 | 0.533 | 53951.2 |
716 | 2021-11-15 03:49:21 | plate | 1 | 28756 | 19 | 0.546 | 52666.7 |
715 | 2021-11-14 04:29:53 | plate | 1 | 28756 | 19 | 0.530 | 54256.6 |
714 | 2021-11-13 03:58:10 | plate | 1 | 28756 | 19 | 0.643 | 44721.6 |
713 | 2021-11-12 08:03:02 | plate | 1 | 28756 | 19 | 0.530 | 54256.6 |
712 | 2021-11-11 06:16:48 | plate | 1 | 28756 | 19 | 0.546 | 52666.7 |
711 | 2021-11-03 18:26:42 | plate | 1 | 28756 | 19 | 0.500 | 57512.0 |
710 | 2021-09-23 07:04:13 | plate | 1 | 28756 | 19 | 0.486 | 59168.7 |
709 | 2021-09-21 03:48:28 | plate | 1 | 28756 | 19 | 0.483 | 59536.2 |