History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"faults"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
928 | 2024-04-28 01:46:29 | faults | 1 | 48755 | 7 | 0.923 | 52822.3 |
927 | 2024-04-27 15:38:39 | faults | 1 | 48755 | 7 | 1.033 | 47197.5 |
926 | 2024-04-27 09:09:49 | faults | 3 | 112716 | 846 | 6.406 | 17595.4 |
925 | 2024-04-25 09:06:18 | faults | 1 | 48755 | 7 | 1.953 | 24964.2 |
924 | 2024-04-18 15:00:56 | faults | 2 | 82551 | 69 | 9.190 | 8982.7 |
923 | 2024-04-18 15:00:54 | faults | 3 | 112716 | 846 | 7.283 | 15476.6 |
922 | 2024-04-18 15:00:40 | faults | 1 | 48755 | 7 | 3.000 | 16251.7 |
921 | 2024-04-05 07:25:17 | faults | 3 | 112716 | 846 | 7.156 | 15751.3 |
920 | 2024-04-04 05:08:47 | faults | 1 | 48755 | 7 | 0.780 | 62506.4 |
919 | 2024-04-03 01:09:44 | faults | 3 | 112716 | 846 | 15.093 | 7468.1 |
918 | 2024-04-03 01:09:46 | faults | 2 | 82551 | 69 | 8.313 | 9930.4 |
917 | 2024-04-03 01:09:42 | faults | 1 | 48755 | 7 | 2.046 | 23829.4 |
916 | 2024-03-31 21:27:32 | faults | 2 | 82551 | 69 | 5.860 | 14087.2 |
915 | 2024-03-30 20:06:45 | faults | 3 | 112716 | 846 | 17.800 | 6332.4 |
914 | 2024-03-30 07:25:00 | faults | 2 | 82551 | 69 | 5.236 | 15766.0 |
913 | 2024-03-30 07:24:31 | faults | 3 | 112716 | 846 | 5.766 | 19548.4 |
912 | 2024-03-28 22:35:02 | faults | 3 | 112716 | 846 | 13.016 | 8659.8 |
911 | 2024-03-28 22:11:29 | faults | 1 | 48755 | 7 | 1.796 | 27146.4 |
910 | 2024-03-28 22:11:14 | faults | 2 | 82551 | 69 | 5.703 | 14475.0 |
909 | 2024-03-27 11:52:27 | faults | 2 | 82551 | 69 | 8.970 | 9203.0 |
908 | 2024-03-15 22:41:34 | faults | 1 | 48755 | 7 | 1.873 | 26030.4 |
907 | 2024-03-03 23:35:25 | faults | 1 | 48755 | 7 | 2.953 | 16510.3 |
906 | 2024-02-29 16:16:35 | faults | 1 | 48755 | 7 | 1.686 | 28917.6 |
905 | 2024-02-09 14:51:14 | faults | 3 | 112716 | 846 | 15.076 | 7476.5 |
904 | 2024-02-08 18:06:08 | faults | 3 | 112716 | 846 | 5.830 | 19333.8 |
903 | 2024-02-08 18:06:07 | faults | 2 | 82551 | 69 | 2.780 | 29694.6 |
902 | 2024-02-08 18:02:34 | faults | 1 | 48755 | 7 | 0.890 | 54780.9 |
901 | 2024-01-09 15:51:55 | faults | 1 | 48755 | 7 | 0.766 | 63648.8 |
900 | 2023-12-25 05:53:34 | faults | 3 | 112716 | 846 | 5.143 | 21916.4 |
899 | 2023-12-25 00:47:12 | faults | 1 | 48755 | 7 | 0.736 | 66243.2 |
898 | 2023-12-13 18:06:20 | faults | 2 | 82551 | 69 | 2.156 | 38289.0 |
897 | 2023-12-13 18:06:15 | faults | 3 | 112716 | 846 | 4.670 | 24136.2 |
896 | 2023-12-03 01:56:07 | faults | 2 | 82551 | 69 | 2.640 | 31269.3 |
895 | 2023-11-27 20:59:59 | faults | 1 | 48755 | 7 | 0.876 | 55656.4 |
894 | 2023-11-25 13:20:06 | faults | 3 | 112716 | 846 | 5.783 | 19490.9 |
893 | 2023-11-20 14:20:05 | faults | 1 | 48755 | 7 | 0.783 | 62266.9 |
892 | 2023-11-11 07:38:45 | faults | 1 | 48755 | 7 | 0.876 | 55656.4 |
891 | 2023-11-03 17:53:20 | faults | 1 | 48755 | 7 | 0.796 | 61250.0 |
890 | 2023-11-02 07:15:00 | faults | 1 | 48755 | 7 | 0.860 | 56691.9 |
889 | 2023-10-23 10:37:26 | faults | 1 | 48755 | 7 | 0.936 | 52088.7 |
888 | 2023-10-20 17:49:08 | faults | 1 | 48755 | 7 | 1.906 | 25579.7 |
887 | 2023-10-13 18:18:13 | faults | 1 | 48755 | 7 | 0.843 | 57835.1 |
886 | 2023-10-13 09:17:25 | faults | 1 | 48755 | 7 | 0.750 | 65006.7 |
885 | 2023-10-05 00:50:06 | faults | 3 | 112716 | 846 | 5.876 | 19182.4 |
884 | 2023-10-01 05:28:24 | faults | 3 | 112716 | 846 | 4.796 | 23502.1 |
883 | 2023-09-26 23:18:22 | faults | 3 | 112716 | 846 | 5.720 | 19705.6 |
882 | 2023-09-26 13:29:07 | faults | 1 | 48755 | 7 | 0.733 | 66514.3 |
881 | 2023-09-13 16:07:31 | faults | 1 | 48755 | 7 | 0.826 | 59025.4 |
880 | 2023-09-01 04:23:59 | faults | 2 | 82551 | 69 | 2.140 | 38575.2 |
879 | 2023-08-25 10:06:44 | faults | 3 | 112716 | 846 | 5.313 | 21215.1 |
878 | 2023-08-16 02:14:16 | faults | 3 | 112716 | 846 | 5.123 | 22002.0 |
877 | 2023-08-12 04:15:11 | faults | 1 | 48755 | 7 | 0.826 | 59025.4 |
876 | 2023-08-09 00:57:22 | faults | 1 | 48755 | 7 | 0.766 | 63648.8 |
875 | 2023-08-06 19:38:32 | faults | 2 | 82551 | 69 | 2.126 | 38829.3 |
874 | 2023-08-02 22:10:37 | faults | 2 | 82551 | 69 | 2.403 | 34353.3 |
873 | 2023-07-10 14:00:29 | faults | 3 | 112716 | 846 | 4.860 | 23192.6 |
872 | 2023-07-07 07:02:22 | faults | 3 | 112716 | 846 | 4.750 | 23729.7 |
871 | 2023-07-04 11:06:26 | faults | 3 | 112716 | 846 | 5.783 | 19490.9 |
870 | 2023-07-03 14:12:56 | faults | 3 | 112716 | 846 | 5.406 | 20850.2 |
869 | 2023-07-02 10:29:15 | faults | 3 | 112716 | 846 | 5.423 | 20784.8 |
868 | 2023-07-01 09:26:48 | faults | 3 | 112716 | 846 | 4.733 | 23814.9 |
867 | 2023-06-30 10:34:11 | faults | 3 | 112716 | 846 | 5.610 | 20092.0 |
866 | 2023-06-29 15:05:14 | faults | 3 | 112716 | 846 | 4.656 | 24208.8 |
865 | 2023-06-28 16:02:23 | faults | 3 | 112716 | 846 | 5.093 | 22131.6 |
864 | 2023-06-27 11:07:15 | faults | 3 | 112716 | 846 | 4.720 | 23880.5 |
863 | 2023-06-26 16:21:39 | faults | 3 | 112716 | 846 | 5.063 | 22262.7 |
862 | 2023-06-25 16:54:12 | faults | 3 | 112716 | 846 | 4.670 | 24136.2 |
861 | 2023-06-25 10:15:14 | faults | 3 | 112716 | 846 | 5.390 | 20912.1 |
860 | 2023-06-24 10:31:24 | faults | 3 | 112716 | 846 | 4.903 | 22989.2 |
859 | 2023-06-23 15:51:48 | faults | 3 | 112716 | 846 | 4.640 | 24292.2 |
858 | 2023-06-22 10:02:56 | faults | 3 | 112716 | 846 | 5.080 | 22188.2 |
857 | 2023-06-21 10:23:07 | faults | 3 | 112716 | 846 | 4.876 | 23116.5 |
856 | 2023-06-20 10:41:01 | faults | 3 | 112716 | 846 | 5.376 | 20966.5 |
855 | 2023-06-19 11:12:11 | faults | 3 | 112716 | 846 | 4.673 | 24120.7 |
854 | 2023-06-18 10:34:26 | faults | 3 | 112716 | 846 | 4.623 | 24381.6 |
853 | 2023-06-17 16:36:38 | faults | 3 | 112716 | 846 | 4.736 | 23799.8 |
852 | 2023-06-15 17:45:37 | faults | 3 | 112716 | 846 | 5.016 | 22471.3 |
851 | 2023-06-14 20:51:12 | faults | 3 | 112716 | 846 | 5.016 | 22471.3 |
850 | 2023-06-13 16:39:44 | faults | 3 | 112716 | 846 | 5.690 | 19809.5 |
849 | 2023-06-11 20:58:07 | faults | 3 | 112716 | 846 | 5.220 | 21593.1 |
848 | 2023-06-05 21:42:45 | faults | 3 | 112716 | 846 | 5.390 | 20912.1 |
847 | 2023-05-19 16:36:24 | faults | 2 | 82551 | 69 | 2.296 | 35954.3 |
846 | 2023-05-11 18:18:22 | faults | 1 | 48755 | 7 | 0.750 | 65006.7 |
845 | 2023-04-30 22:01:21 | faults | 1 | 48755 | 7 | 0.736 | 66243.2 |
844 | 2023-04-27 19:56:05 | faults | 1 | 48755 | 7 | 0.750 | 65006.7 |
843 | 2023-04-20 18:59:04 | faults | 2 | 82551 | 69 | 2.406 | 34310.5 |
842 | 2023-04-20 12:58:40 | faults | 3 | 112716 | 846 | 5.080 | 22188.2 |
841 | 2023-04-17 10:19:59 | faults | 3 | 112716 | 846 | 4.596 | 24524.8 |
840 | 2023-04-12 09:05:00 | faults | 3 | 112716 | 846 | 5.953 | 18934.3 |
839 | 2023-04-11 08:55:34 | faults | 3 | 112716 | 846 | 5.593 | 20153.0 |
838 | 2023-04-10 08:57:39 | faults | 3 | 112716 | 846 | 11.736 | 9604.3 |
837 | 2023-04-09 09:04:54 | faults | 3 | 112716 | 846 | 5.843 | 19290.8 |
836 | 2023-04-08 09:05:10 | faults | 3 | 112716 | 846 | 5.673 | 19868.9 |
835 | 2023-04-07 08:54:10 | faults | 3 | 112716 | 846 | 5.453 | 20670.5 |
834 | 2023-04-06 10:25:53 | faults | 3 | 112716 | 846 | 5.626 | 20034.8 |
833 | 2023-04-05 13:01:43 | faults | 3 | 112716 | 846 | 4.783 | 23566.0 |
832 | 2023-04-05 10:18:26 | faults | 3 | 112716 | 846 | 5.466 | 20621.3 |
831 | 2023-04-04 09:33:56 | faults | 3 | 112716 | 846 | 5.593 | 20153.0 |
830 | 2023-04-03 09:03:38 | faults | 3 | 112716 | 846 | 5.626 | 20034.8 |
829 | 2023-04-02 08:49:46 | faults | 3 | 112716 | 846 | 6.516 | 17298.3 |