History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"speirs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
849 | 2024-04-26 08:16:07 | speirs | 3 | 112716 | 915 | 7.376 | 15281.5 |
848 | 2024-04-03 08:24:57 | speirs | 1 | 48755 | 7 | 0.766 | 63648.8 |
847 | 2024-04-03 04:35:29 | speirs | 1 | 48755 | 7 | 2.986 | 16327.9 |
846 | 2024-03-31 17:56:14 | speirs | 1 | 48755 | 7 | 2.796 | 17437.4 |
845 | 2024-03-06 10:44:35 | speirs | 3 | 112716 | 915 | 7.966 | 14149.6 |
844 | 2024-03-06 10:44:18 | speirs | 3 | 112716 | 915 | 15.830 | 7120.4 |
843 | 2024-03-04 04:23:38 | speirs | 3 | 112716 | 915 | 9.830 | 11466.5 |
842 | 2024-03-04 04:23:36 | speirs | 2 | 82551 | 85 | 3.393 | 24329.8 |
841 | 2024-03-04 04:23:34 | speirs | 1 | 48755 | 7 | 2.156 | 22613.6 |
840 | 2024-02-28 04:54:12 | speirs | 1 | 48755 | 7 | 2.000 | 24377.5 |
839 | 2024-02-04 12:03:26 | speirs | 1 | 48755 | 7 | 1.796 | 27146.4 |
838 | 2024-01-31 17:18:57 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
837 | 2024-01-29 20:04:34 | speirs | 3 | 112716 | 915 | 9.923 | 11359.1 |
836 | 2024-01-29 07:42:03 | speirs | 3 | 112716 | 915 | 6.593 | 17096.3 |
835 | 2024-01-28 13:51:07 | speirs | 3 | 112716 | 915 | 4.733 | 23814.9 |
834 | 2024-01-22 18:51:44 | speirs | 3 | 112716 | 915 | 18.596 | 6061.3 |
833 | 2024-01-22 11:40:40 | speirs | 2 | 82551 | 85 | 7.093 | 11638.4 |
832 | 2024-01-22 11:40:38 | speirs | 3 | 112716 | 915 | 6.593 | 17096.3 |
831 | 2024-01-22 11:40:28 | speirs | 1 | 48755 | 7 | 0.983 | 49598.2 |
830 | 2024-01-06 00:15:23 | speirs | 2 | 82551 | 85 | 2.483 | 33246.5 |
829 | 2024-01-04 08:25:27 | speirs | 2 | 82551 | 85 | 2.156 | 38289.0 |
828 | 2023-12-24 17:59:57 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
827 | 2023-12-20 21:12:13 | speirs | 2 | 82551 | 85 | 4.110 | 20085.4 |
826 | 2023-12-10 14:10:20 | speirs | 1 | 48755 | 7 | 0.810 | 60191.4 |
825 | 2023-12-08 00:03:47 | speirs | 3 | 112716 | 915 | 11.470 | 9827.0 |
824 | 2023-12-07 23:23:54 | speirs | 1 | 48755 | 7 | 0.890 | 54780.9 |
823 | 2023-12-07 23:23:53 | speirs | 1 | 48755 | 7 | 0.876 | 55656.4 |
822 | 2023-12-07 23:22:03 | speirs | 1 | 48755 | 7 | 0.766 | 63648.8 |
821 | 2023-11-27 03:11:19 | speirs | 3 | 112716 | 915 | 5.000 | 22543.2 |
820 | 2023-11-18 21:10:51 | speirs | 1 | 48755 | 7 | 0.890 | 54780.9 |
819 | 2023-11-14 20:11:15 | speirs | 2 | 82551 | 85 | 2.096 | 39385.0 |
818 | 2023-11-13 22:44:51 | speirs | 1 | 48755 | 7 | 0.890 | 54780.9 |
817 | 2023-11-11 16:57:46 | speirs | 1 | 48755 | 7 | 0.860 | 56691.9 |
816 | 2023-11-05 06:24:59 | speirs | 3 | 112716 | 915 | 5.296 | 21283.2 |
815 | 2023-11-05 06:25:02 | speirs | 2 | 82551 | 85 | 2.546 | 32423.8 |
814 | 2023-11-05 00:00:46 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
813 | 2023-10-21 05:13:28 | speirs | 1 | 48755 | 7 | 1.606 | 30358.0 |
812 | 2023-10-14 11:45:10 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
811 | 2023-10-14 00:33:39 | speirs | 1 | 48755 | 7 | 0.766 | 63648.8 |
810 | 2023-09-29 19:02:59 | speirs | 1 | 48755 | 7 | 0.826 | 59025.4 |
809 | 2023-09-26 08:45:42 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
808 | 2023-09-12 11:11:49 | speirs | 1 | 48755 | 7 | 0.763 | 63899.1 |
807 | 2023-08-27 08:27:39 | speirs | 3 | 112716 | 915 | 4.640 | 24292.2 |
806 | 2023-08-11 10:59:38 | speirs | 1 | 48755 | 7 | 0.766 | 63648.8 |
805 | 2023-07-15 00:45:27 | speirs | 1 | 48755 | 7 | 1.016 | 47987.2 |
804 | 2023-06-06 03:33:43 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
803 | 2023-06-02 20:07:50 | speirs | 1 | 48755 | 7 | 0.733 | 66514.3 |
802 | 2023-05-24 13:46:11 | speirs | 3 | 112716 | 915 | 4.673 | 24120.7 |
801 | 2023-05-22 15:39:06 | speirs | 2 | 82551 | 85 | 2.216 | 37252.3 |
800 | 2023-05-13 21:31:53 | speirs | 1 | 48755 | 7 | 0.796 | 61250.0 |
799 | 2023-05-12 03:24:16 | speirs | 3 | 112716 | 915 | 4.906 | 22975.1 |
798 | 2023-04-02 09:03:01 | speirs | 2 | 82551 | 85 | 2.436 | 33887.9 |
797 | 2023-03-25 02:05:59 | speirs | 3 | 112716 | 915 | 4.876 | 23116.5 |
796 | 2023-03-07 18:08:07 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
795 | 2023-02-16 17:05:02 | speirs | 3 | 112716 | 915 | 4.656 | 24208.8 |
794 | 2023-02-11 08:50:08 | speirs | 3 | 112716 | 915 | 4.656 | 24208.8 |
793 | 2023-02-10 16:51:07 | speirs | 2 | 82551 | 85 | 2.750 | 30018.5 |
792 | 2023-02-07 12:01:02 | speirs | 1 | 48755 | 7 | 0.826 | 59025.4 |
791 | 2023-02-07 05:59:09 | speirs | 2 | 82551 | 85 | 2.110 | 39123.7 |
790 | 2023-01-26 20:35:55 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
789 | 2023-01-22 06:06:27 | speirs | 3 | 112716 | 915 | 7.110 | 15853.2 |
788 | 2023-01-08 18:15:57 | speirs | 2 | 82551 | 85 | 4.763 | 17331.7 |
787 | 2022-12-29 09:39:12 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
786 | 2022-12-27 05:27:20 | speirs | 3 | 112716 | 915 | 5.093 | 22131.6 |
785 | 2022-12-23 03:26:25 | speirs | 2 | 82551 | 85 | 2.236 | 36919.1 |
784 | 2022-12-14 16:43:28 | speirs | 3 | 112716 | 915 | 4.670 | 24136.2 |
783 | 2022-12-12 13:37:51 | speirs | 1 | 48755 | 7 | 0.830 | 58741.0 |
782 | 2022-12-01 21:32:35 | speirs | 3 | 112716 | 915 | 5.156 | 21861.1 |
781 | 2022-11-29 15:15:51 | speirs | 2 | 82551 | 85 | 2.236 | 36919.1 |
780 | 2022-11-27 06:20:38 | speirs | 3 | 112716 | 915 | 4.593 | 24540.8 |
779 | 2022-11-22 14:43:41 | speirs | 3 | 112716 | 915 | 4.690 | 24033.3 |
778 | 2022-11-19 09:48:22 | speirs | 2 | 82551 | 85 | 2.393 | 34496.9 |
777 | 2022-11-16 19:16:11 | speirs | 1 | 48755 | 7 | 0.890 | 54780.9 |
776 | 2022-11-12 04:04:28 | speirs | 1 | 48755 | 7 | 0.860 | 56691.9 |
775 | 2022-11-06 10:21:01 | speirs | 1 | 48755 | 7 | 0.846 | 57630.0 |
774 | 2022-10-30 20:47:34 | speirs | 2 | 82551 | 85 | 2.406 | 34310.5 |
773 | 2022-10-23 19:00:08 | speirs | 3 | 112716 | 915 | 5.263 | 21416.7 |
772 | 2022-10-21 23:47:51 | speirs | 3 | 112716 | 915 | 4.593 | 24540.8 |
771 | 2022-10-19 16:36:28 | speirs | 3 | 112716 | 915 | 4.810 | 23433.7 |
770 | 2022-10-15 17:45:59 | speirs | 3 | 112716 | 915 | 4.640 | 24292.2 |
769 | 2022-10-15 02:50:45 | speirs | 2 | 82551 | 85 | 2.140 | 38575.2 |
768 | 2022-10-06 09:42:38 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
767 | 2022-09-21 02:23:02 | speirs | 2 | 82551 | 85 | 2.126 | 38829.3 |
766 | 2022-09-19 22:01:32 | speirs | 1 | 48755 | 7 | 0.843 | 57835.1 |
765 | 2022-09-05 21:00:00 | speirs | 3 | 112716 | 915 | 5.406 | 20850.2 |
764 | 2022-09-02 09:57:06 | speirs | 3 | 112716 | 915 | 5.200 | 21676.2 |
763 | 2022-09-02 03:19:26 | speirs | 3 | 112716 | 915 | 5.266 | 21404.5 |
762 | 2022-08-28 22:09:49 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
761 | 2022-08-20 15:46:33 | speirs | 2 | 82551 | 85 | 2.110 | 39123.7 |
760 | 2022-08-18 14:56:35 | speirs | 1 | 48755 | 7 | 0.826 | 59025.4 |
759 | 2022-08-06 19:27:08 | speirs | 2 | 82551 | 85 | 2.140 | 38575.2 |
758 | 2022-07-27 15:20:48 | speirs | 3 | 112716 | 915 | 5.376 | 20966.5 |
757 | 2022-07-26 08:44:07 | speirs | 1 | 48755 | 7 | 0.893 | 54596.9 |
756 | 2022-07-13 10:37:55 | speirs | 3 | 112716 | 915 | 4.796 | 23502.1 |
755 | 2022-07-05 06:36:10 | speirs | 3 | 112716 | 915 | 4.766 | 23650.0 |
754 | 2022-07-03 01:01:27 | speirs | 3 | 112716 | 915 | 4.750 | 23729.7 |
753 | 2022-07-01 16:12:29 | speirs | 3 | 112716 | 915 | 4.660 | 24188.0 |
752 | 2022-06-29 16:37:03 | speirs | 2 | 82551 | 85 | 2.093 | 39441.5 |
751 | 2022-06-08 14:02:22 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |
750 | 2022-06-04 23:11:34 | speirs | 1 | 48755 | 7 | 0.750 | 65006.7 |