History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"assets"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
760 | 2024-05-01 18:54:02 | assets | 1 | 48755 | 8 | 1.016 | 47987.2 |
759 | 2024-04-30 13:57:58 | assets | 1 | 48755 | 8 | 1.596 | 30548.2 |
758 | 2024-04-25 07:38:34 | assets | 1 | 48755 | 8 | 1.030 | 47335.0 |
757 | 2024-04-10 09:10:18 | assets | 1 | 48755 | 8 | 0.860 | 56691.9 |
756 | 2024-04-03 06:33:30 | assets | 1 | 48755 | 8 | 2.706 | 18017.4 |
755 | 2024-03-31 05:03:33 | assets | 1 | 48755 | 8 | 1.876 | 25988.8 |
754 | 2024-03-05 19:11:03 | assets | 3 | 112716 | 969 | 7.360 | 15314.7 |
753 | 2024-03-05 11:22:04 | assets | 3 | 112716 | 969 | 9.486 | 11882.4 |
752 | 2024-03-04 14:01:29 | assets | 2 | 82551 | 70 | 2.533 | 32590.2 |
751 | 2024-03-04 13:58:42 | assets | 3 | 112716 | 969 | 8.233 | 13690.8 |
750 | 2024-03-04 12:21:29 | assets | 2 | 82551 | 70 | 2.890 | 28564.4 |
749 | 2024-03-04 12:21:25 | assets | 1 | 48755 | 8 | 0.873 | 55847.7 |
748 | 2024-03-04 12:20:57 | assets | 3 | 112716 | 969 | 5.736 | 19650.6 |
747 | 2024-03-04 04:07:23 | assets | 3 | 112716 | 969 | 16.910 | 6665.6 |
746 | 2024-03-04 01:42:31 | assets | 3 | 112716 | 969 | 5.593 | 20153.0 |
745 | 2024-03-04 01:42:28 | assets | 2 | 82551 | 70 | 2.173 | 37989.4 |
744 | 2024-03-04 01:42:26 | assets | 1 | 48755 | 8 | 1.560 | 31253.2 |
743 | 2024-02-11 22:14:16 | assets | 1 | 48755 | 8 | 0.966 | 50471.0 |
742 | 2024-01-14 04:49:10 | assets | 1 | 48755 | 8 | 0.766 | 63648.8 |
741 | 2024-01-08 08:31:22 | assets | 1 | 48755 | 8 | 0.783 | 62266.9 |
740 | 2024-01-07 03:34:18 | assets | 3 | 112716 | 969 | 5.220 | 21593.1 |
739 | 2024-01-06 17:16:06 | assets | 2 | 82551 | 70 | 2.406 | 34310.5 |
738 | 2024-01-06 08:34:01 | assets | 3 | 112716 | 969 | 5.453 | 20670.5 |
737 | 2024-01-06 08:29:36 | assets | 2 | 82551 | 70 | 2.500 | 33020.4 |
736 | 2024-01-06 03:26:25 | assets | 2 | 82551 | 70 | 2.140 | 38575.2 |
735 | 2023-11-30 17:14:43 | assets | 1 | 48755 | 8 | 0.780 | 62506.4 |
734 | 2023-11-19 20:28:41 | assets | 1 | 48755 | 8 | 1.516 | 32160.3 |
733 | 2023-11-19 11:57:54 | assets | 1 | 48755 | 8 | 0.766 | 63648.8 |
732 | 2023-11-14 18:07:22 | assets | 1 | 48755 | 8 | 0.843 | 57835.1 |
731 | 2023-10-31 13:36:40 | assets | 1 | 48755 | 8 | 0.860 | 56691.9 |
730 | 2023-10-22 19:55:53 | assets | 1 | 48755 | 8 | 0.860 | 56691.9 |
729 | 2023-10-19 05:05:51 | assets | 1 | 48755 | 8 | 0.750 | 65006.7 |
728 | 2023-10-12 22:53:05 | assets | 1 | 48755 | 8 | 0.906 | 53813.5 |
727 | 2023-10-10 23:04:10 | assets | 2 | 82551 | 70 | 2.280 | 36206.6 |
726 | 2023-10-08 18:35:50 | assets | 1 | 48755 | 8 | 0.890 | 54780.9 |
725 | 2023-09-28 23:24:41 | assets | 1 | 48755 | 8 | 0.826 | 59025.4 |
724 | 2023-09-24 13:04:12 | assets | 1 | 48755 | 8 | 0.736 | 66243.2 |
723 | 2023-09-22 06:08:33 | assets | 1 | 48755 | 8 | 0.810 | 60191.4 |
722 | 2023-09-14 23:06:08 | assets | 1 | 48755 | 8 | 0.796 | 61250.0 |
721 | 2023-07-21 15:22:51 | assets | 2 | 82551 | 70 | 2.170 | 38041.9 |
720 | 2023-07-02 12:29:50 | assets | 1 | 48755 | 8 | 0.830 | 58741.0 |
719 | 2023-06-25 01:28:56 | assets | 1 | 48755 | 8 | 0.733 | 66514.3 |
718 | 2023-04-10 16:30:28 | assets | 1 | 48755 | 8 | 0.843 | 57835.1 |
717 | 2023-04-03 04:10:57 | assets | 2 | 82551 | 70 | 2.173 | 37989.4 |
716 | 2023-03-26 00:09:38 | assets | 1 | 48755 | 8 | 0.813 | 59969.2 |
715 | 2023-02-03 18:34:18 | assets | 1 | 48755 | 8 | 0.750 | 65006.7 |
714 | 2022-12-30 11:57:56 | assets | 2 | 82551 | 70 | 2.373 | 34787.6 |
713 | 2022-12-20 21:41:06 | assets | 1 | 48755 | 8 | 0.783 | 62266.9 |
712 | 2022-12-01 14:57:29 | assets | 1 | 48755 | 8 | 0.763 | 63899.1 |
711 | 2022-11-26 08:16:45 | assets | 1 | 48755 | 8 | 0.750 | 65006.7 |
710 | 2022-09-06 16:44:00 | assets | 1 | 48755 | 8 | 0.796 | 61250.0 |
709 | 2022-09-03 08:22:31 | assets | 1 | 48755 | 8 | 0.843 | 57835.1 |
708 | 2022-08-31 06:05:53 | assets | 2 | 82551 | 70 | 2.436 | 33887.9 |
707 | 2022-07-27 20:01:11 | assets | 1 | 48755 | 8 | 0.876 | 55656.4 |
706 | 2022-05-25 12:45:21 | assets | 1 | 48755 | 8 | 0.796 | 61250.0 |
705 | 2022-03-20 09:25:30 | assets | 1 | 48755 | 8 | 0.746 | 65355.2 |
704 | 2022-02-17 11:04:10 | assets | 1 | 48755 | 8 | 0.890 | 54780.9 |
703 | 2021-12-26 09:22:21 | assets | 1 | 48755 | 8 | 0.876 | 55656.4 |
702 | 2021-11-19 09:31:09 | assets | 1 | 48755 | 8 | 0.876 | 55656.4 |
701 | 2021-11-16 01:59:41 | assets | 1 | 48755 | 8 | 0.780 | 62506.4 |
700 | 2021-10-29 03:03:03 | assets | 1 | 48755 | 8 | 0.843 | 57835.1 |
699 | 2021-09-15 05:24:43 | assets | 1 | 48755 | 8 | 0.750 | 65006.7 |
698 | 2021-08-26 11:29:16 | assets | 1 | 48755 | 8 | 0.766 | 63648.8 |
697 | 2021-08-13 05:51:28 | assets | 1 | 48755 | 8 | 0.783 | 62266.9 |
696 | 2021-05-28 07:40:52 | assets | 1 | 48755 | 8 | 1.000 | 48755.0 |
695 | 2021-05-12 12:34:34 | assets | 1 | 48755 | 8 | 0.846 | 57630.0 |
694 | 2021-05-02 19:55:38 | assets | 1 | 48755 | 8 | 0.876 | 55656.4 |
693 | 2021-05-02 13:17:31 | assets | 1 | 48755 | 8 | 0.843 | 57835.1 |
692 | 2021-02-08 11:37:31 | assets | 1 | 48755 | 8 | 0.830 | 58741.0 |
691 | 2021-02-03 08:00:50 | assets | 1 | 48755 | 8 | 1.000 | 48755.0 |
690 | 2021-01-15 09:39:24 | assets | 1 | 48755 | 8 | 0.766 | 63648.8 |
689 | 2021-01-15 00:54:55 | assets | 1 | 48755 | 8 | 0.890 | 54780.9 |
688 | 2020-12-16 17:33:10 | assets | 1 | 48755 | 8 | 0.766 | 63648.8 |
687 | 2020-11-19 21:27:26 | assets | 1 | 48755 | 8 | 0.783 | 62266.9 |
686 | 2020-11-01 12:49:15 | assets | 1 | 48755 | 8 | 0.780 | 62506.4 |
685 | 2020-10-27 04:54:23 | assets | 1 | 48755 | 8 | 0.906 | 53813.5 |
684 | 2020-10-25 14:26:08 | assets | 1 | 48755 | 8 | 0.860 | 56691.9 |
683 | 2020-10-16 17:49:33 | assets | 1 | 48755 | 8 | 0.750 | 65006.7 |
682 | 2020-10-16 03:45:00 | assets | 1 | 48755 | 8 | 0.783 | 62266.9 |
681 | 2020-09-06 07:12:46 | assets | 1 | 48755 | 8 | 0.750 | 65006.7 |
680 | 2020-08-21 22:42:37 | assets | 1 | 48755 | 8 | 0.860 | 56691.9 |
679 | 2020-08-05 13:45:06 | assets | 1 | 48755 | 8 | 0.796 | 61250.0 |
678 | 2020-07-30 00:35:28 | assets | 1 | 48755 | 8 | 0.906 | 53813.5 |
677 | 2020-07-26 17:41:09 | assets | 1 | 48755 | 8 | 0.796 | 61250.0 |
676 | 2020-06-09 14:05:53 | assets | 1 | 48755 | 8 | 0.906 | 53813.5 |
675 | 2020-04-24 11:42:32 | assets | 1 | 48755 | 8 | 0.873 | 55847.7 |
674 | 2020-03-30 06:44:42 | assets | 1 | 48755 | 8 | 0.843 | 57835.1 |
673 | 2020-03-27 21:51:34 | assets | 1 | 48755 | 8 | 0.873 | 55847.7 |
672 | 2020-03-24 04:50:29 | assets | 1 | 48755 | 8 | 0.940 | 51867.0 |
671 | 2020-03-23 23:10:29 | assets | 1 | 48755 | 8 | 0.936 | 52088.7 |
670 | 2020-03-22 05:54:14 | assets | 1 | 48755 | 8 | 0.843 | 57835.1 |
669 | 2020-03-19 20:52:44 | assets | 1 | 48755 | 8 | 0.876 | 55656.4 |
668 | 2020-03-18 21:20:01 | assets | 1 | 48755 | 8 | 0.873 | 55847.7 |
667 | 2020-03-13 04:16:56 | assets | 1 | 48755 | 8 | 0.780 | 62506.4 |
666 | 2020-02-26 04:13:33 | assets | 1 | 48755 | 8 | 0.873 | 55847.7 |
665 | 2020-02-24 10:22:00 | assets | 1 | 48755 | 8 | 1.953 | 24964.2 |
664 | 2020-02-22 07:22:38 | assets | 1 | 48755 | 8 | 0.923 | 52822.3 |
663 | 2020-02-20 12:57:33 | assets | 1 | 48755 | 8 | 1.016 | 47987.2 |
662 | 2020-02-12 06:55:33 | assets | 1 | 48755 | 8 | 0.860 | 56691.9 |
661 | 2020-02-01 12:02:44 | assets | 1 | 48755 | 8 | 0.873 | 55847.7 |