History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
792 | 2024-04-06 09:36:10 | sparid | 1 | 48755 | 4 | 3.110 | 15676.8 |
791 | 2024-03-30 00:56:36 | sparid | 1 | 48755 | 4 | 0.923 | 52822.3 |
790 | 2024-03-29 16:28:45 | sparid | 1 | 48755 | 4 | 1.750 | 27860.0 |
789 | 2024-03-12 14:47:51 | sparid | 1 | 48755 | 4 | 0.800 | 60943.8 |
788 | 2024-02-29 19:46:18 | sparid | 3 | 112716 | 771 | 5.906 | 19085.0 |
787 | 2024-02-26 18:05:09 | sparid | 3 | 112716 | 771 | 9.923 | 11359.1 |
786 | 2024-02-25 09:57:09 | sparid | 2 | 82551 | 71 | 2.300 | 35891.7 |
785 | 2024-02-25 09:56:35 | sparid | 3 | 112716 | 771 | 6.016 | 18736.0 |
784 | 2024-02-18 09:29:27 | sparid | 3 | 112716 | 771 | 16.140 | 6983.6 |
783 | 2024-02-18 07:58:38 | sparid | 3 | 112716 | 771 | 17.203 | 6552.1 |
782 | 2024-02-18 00:30:12 | sparid | 2 | 82551 | 71 | 3.296 | 25045.8 |
781 | 2024-02-18 00:11:28 | sparid | 3 | 112716 | 771 | 6.763 | 16666.6 |
780 | 2024-02-17 18:25:41 | sparid | 3 | 112716 | 771 | 5.860 | 19234.8 |
779 | 2024-02-17 18:25:42 | sparid | 2 | 82551 | 71 | 2.733 | 30205.3 |
778 | 2024-02-17 16:56:23 | sparid | 1 | 48755 | 4 | 0.906 | 53813.5 |
777 | 2024-01-15 08:13:35 | sparid | 2 | 82551 | 71 | 2.220 | 37185.1 |
776 | 2024-01-10 09:27:01 | sparid | 1 | 48755 | 4 | 0.873 | 55847.7 |
775 | 2023-11-19 02:15:58 | sparid | 1 | 48755 | 4 | 0.846 | 57630.0 |
774 | 2023-11-18 06:25:16 | sparid | 1 | 48755 | 4 | 0.766 | 63648.8 |
773 | 2023-11-09 01:43:12 | sparid | 1 | 48755 | 4 | 0.783 | 62266.9 |
772 | 2023-11-06 10:35:51 | sparid | 1 | 48755 | 4 | 0.750 | 65006.7 |
771 | 2023-11-05 17:54:25 | sparid | 1 | 48755 | 4 | 0.813 | 59969.2 |
770 | 2023-11-02 05:21:52 | sparid | 1 | 48755 | 4 | 0.890 | 54780.9 |
769 | 2023-10-24 04:29:14 | sparid | 1 | 48755 | 4 | 0.860 | 56691.9 |
768 | 2023-10-24 01:58:16 | sparid | 2 | 82551 | 71 | 2.313 | 35690.0 |
767 | 2023-10-20 16:50:20 | sparid | 1 | 48755 | 4 | 0.826 | 59025.4 |
766 | 2023-10-15 12:28:58 | sparid | 1 | 48755 | 4 | 0.796 | 61250.0 |
765 | 2023-10-05 22:00:53 | sparid | 1 | 48755 | 4 | 0.830 | 58741.0 |
764 | 2023-09-26 12:31:32 | sparid | 1 | 48755 | 4 | 0.923 | 52822.3 |
763 | 2023-09-14 12:03:39 | sparid | 1 | 48755 | 4 | 1.546 | 31536.2 |
762 | 2023-08-27 08:39:51 | sparid | 1 | 48755 | 4 | 0.750 | 65006.7 |
761 | 2023-08-02 15:14:44 | sparid | 2 | 82551 | 71 | 2.173 | 37989.4 |
760 | 2023-07-14 04:58:37 | sparid | 1 | 48755 | 4 | 0.936 | 52088.7 |
759 | 2023-05-29 16:36:07 | sparid | 1 | 48755 | 4 | 0.843 | 57835.1 |
758 | 2023-04-11 04:46:20 | sparid | 2 | 82551 | 71 | 2.123 | 38884.1 |
757 | 2023-03-26 09:49:15 | sparid | 1 | 48755 | 4 | 0.830 | 58741.0 |
756 | 2023-03-26 07:36:09 | sparid | 1 | 48755 | 4 | 0.766 | 63648.8 |
755 | 2023-03-22 22:50:00 | sparid | 1 | 48755 | 4 | 0.750 | 65006.7 |
754 | 2023-01-12 22:53:08 | sparid | 2 | 82551 | 71 | 2.610 | 31628.7 |
753 | 2023-01-10 05:40:17 | sparid | 1 | 48755 | 4 | 0.826 | 59025.4 |
752 | 2022-11-25 00:27:04 | sparid | 1 | 48755 | 4 | 0.733 | 66514.3 |
751 | 2022-10-19 10:38:40 | sparid | 1 | 48755 | 4 | 0.843 | 57835.1 |
750 | 2022-10-13 06:41:35 | sparid | 2 | 82551 | 71 | 2.140 | 38575.2 |
749 | 2022-07-25 07:05:34 | sparid | 1 | 48755 | 4 | 0.813 | 59969.2 |
748 | 2022-06-10 10:59:38 | sparid | 1 | 48755 | 4 | 0.780 | 62506.4 |
747 | 2022-05-08 22:44:41 | sparid | 2 | 82551 | 71 | 2.173 | 37989.4 |
746 | 2022-03-27 07:51:19 | sparid | 1 | 48755 | 4 | 0.906 | 53813.5 |
745 | 2022-03-23 23:10:08 | sparid | 1 | 48755 | 4 | 1.030 | 47335.0 |
744 | 2022-02-18 01:18:38 | sparid | 1 | 48755 | 4 | 0.840 | 58041.7 |
743 | 2022-01-03 05:44:50 | sparid | 1 | 48755 | 4 | 0.813 | 59969.2 |
742 | 2021-12-24 03:15:25 | sparid | 1 | 48755 | 4 | 0.953 | 51159.5 |
741 | 2021-12-03 08:33:46 | sparid | 1 | 48755 | 4 | 1.033 | 47197.5 |
740 | 2021-11-19 05:10:26 | sparid | 1 | 48755 | 4 | 0.830 | 58741.0 |
739 | 2021-09-28 19:57:04 | sparid | 3 | 112716 | 771 | 5.063 | 22262.7 |
738 | 2021-09-27 21:32:53 | sparid | 3 | 112716 | 771 | 5.376 | 20966.5 |
737 | 2021-09-24 12:00:01 | sparid | 3 | 112716 | 771 | 4.780 | 23580.8 |
736 | 2021-09-24 03:40:58 | sparid | 3 | 112716 | 771 | 5.330 | 21147.5 |
735 | 2021-08-20 05:39:37 | sparid | 1 | 48755 | 4 | 0.766 | 63648.8 |
734 | 2021-05-16 06:06:19 | sparid | 1 | 48755 | 4 | 0.920 | 52994.6 |
733 | 2021-05-13 10:44:45 | sparid | 2 | 82551 | 71 | 2.733 | 30205.3 |
732 | 2021-05-12 21:32:23 | sparid | 1 | 48755 | 4 | 0.890 | 54780.9 |
731 | 2021-04-12 08:15:03 | sparid | 2 | 82551 | 71 | 2.703 | 30540.5 |
730 | 2021-02-17 21:31:36 | sparid | 1 | 48755 | 4 | 0.966 | 50471.0 |
729 | 2021-02-09 01:15:47 | sparid | 1 | 48755 | 4 | 0.763 | 63899.1 |
728 | 2021-02-02 09:09:57 | sparid | 1 | 48755 | 4 | 1.533 | 31803.7 |
727 | 2021-01-25 12:14:57 | sparid | 2 | 82551 | 71 | 2.423 | 34069.7 |
726 | 2020-11-19 16:43:50 | sparid | 3 | 112716 | 771 | 4.706 | 23951.6 |
725 | 2020-11-07 07:00:43 | sparid | 1 | 48755 | 4 | 1.000 | 48755.0 |
724 | 2020-10-26 23:05:04 | sparid | 2 | 82551 | 71 | 2.203 | 37472.1 |
723 | 2020-10-24 20:38:41 | sparid | 1 | 48755 | 4 | 0.843 | 57835.1 |
722 | 2020-10-20 02:34:36 | sparid | 1 | 48755 | 4 | 0.766 | 63648.8 |
721 | 2020-10-18 04:48:21 | sparid | 1 | 48755 | 4 | 0.826 | 59025.4 |
720 | 2020-10-15 17:34:15 | sparid | 1 | 48755 | 4 | 0.766 | 63648.8 |
719 | 2020-10-15 06:51:54 | sparid | 1 | 48755 | 4 | 0.890 | 54780.9 |
718 | 2020-10-13 17:45:47 | sparid | 2 | 82551 | 71 | 2.236 | 36919.1 |
717 | 2020-10-12 12:51:40 | sparid | 1 | 48755 | 4 | 0.783 | 62266.9 |
716 | 2020-09-09 23:03:34 | sparid | 2 | 82551 | 71 | 2.283 | 36159.0 |
715 | 2020-08-24 20:30:03 | sparid | 1 | 48755 | 4 | 0.796 | 61250.0 |
714 | 2020-08-10 11:37:39 | sparid | 2 | 82551 | 71 | 2.373 | 34787.6 |
713 | 2020-08-10 09:40:44 | sparid | 2 | 82551 | 71 | 2.186 | 37763.5 |
712 | 2020-08-05 20:22:01 | sparid | 1 | 48755 | 4 | 0.766 | 63648.8 |
711 | 2020-07-19 01:22:37 | sparid | 2 | 82551 | 71 | 2.280 | 36206.6 |
710 | 2020-06-07 15:10:14 | sparid | 2 | 82551 | 71 | 2.220 | 37185.1 |
709 | 2020-06-06 15:32:54 | sparid | 2 | 82551 | 71 | 2.436 | 33887.9 |
708 | 2020-06-05 15:15:32 | sparid | 2 | 82551 | 71 | 2.236 | 36919.1 |
707 | 2020-06-04 15:09:06 | sparid | 2 | 82551 | 71 | 2.220 | 37185.1 |
706 | 2020-06-03 15:10:23 | sparid | 2 | 82551 | 71 | 2.186 | 37763.5 |
705 | 2020-05-31 11:38:43 | sparid | 2 | 82551 | 71 | 2.250 | 36689.3 |
704 | 2020-05-30 11:02:34 | sparid | 2 | 82551 | 71 | 5.330 | 15488.0 |
703 | 2020-05-25 02:54:59 | sparid | 2 | 82551 | 71 | 2.203 | 37472.1 |
702 | 2020-05-22 04:47:13 | sparid | 2 | 82551 | 71 | 2.186 | 37763.5 |
701 | 2020-05-21 04:49:31 | sparid | 2 | 82551 | 71 | 2.546 | 32423.8 |
700 | 2020-05-20 10:51:45 | sparid | 1 | 48755 | 4 | 0.750 | 65006.7 |
699 | 2020-05-18 03:39:11 | sparid | 2 | 82551 | 71 | 2.203 | 37472.1 |
698 | 2020-05-17 02:55:16 | sparid | 2 | 82551 | 71 | 2.140 | 38575.2 |
697 | 2020-05-15 08:34:28 | sparid | 2 | 82551 | 71 | 2.483 | 33246.5 |
696 | 2020-04-28 01:34:19 | sparid | 2 | 82551 | 71 | 2.203 | 37472.1 |
695 | 2020-04-27 23:27:18 | sparid | 1 | 48755 | 4 | 0.766 | 63648.8 |
694 | 2020-04-27 01:54:30 | sparid | 2 | 82551 | 71 | 2.393 | 34496.9 |
693 | 2020-04-26 02:09:53 | sparid | 2 | 82551 | 71 | 2.280 | 36206.6 |