History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lairds"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
934 | 2024-03-14 15:59:59 | lairds | 2 | 82551 | 76 | 2.876 | 28703.4 |
933 | 2024-03-12 06:03:25 | lairds | 2 | 82551 | 76 | 3.390 | 24351.3 |
932 | 2024-03-09 10:27:32 | lairds | 1 | 48755 | 7 | 0.810 | 60191.4 |
931 | 2024-03-04 03:41:10 | lairds | 3 | 112716 | 852 | 5.360 | 21029.1 |
930 | 2024-03-04 03:41:08 | lairds | 2 | 82551 | 76 | 2.203 | 37472.1 |
929 | 2024-03-04 03:41:00 | lairds | 1 | 48755 | 7 | 0.893 | 54596.9 |
928 | 2024-03-02 03:44:05 | lairds | 3 | 112716 | 852 | 8.080 | 13950.0 |
927 | 2024-02-28 05:50:54 | lairds | 2 | 82551 | 76 | 3.046 | 27101.4 |
926 | 2024-02-28 02:01:10 | lairds | 3 | 112716 | 852 | 9.703 | 11616.6 |
925 | 2024-02-28 01:19:22 | lairds | 3 | 112716 | 852 | 9.063 | 12436.9 |
924 | 2024-02-28 01:19:21 | lairds | 2 | 82551 | 76 | 4.923 | 16768.4 |
923 | 2024-02-28 01:19:21 | lairds | 1 | 48755 | 7 | 1.466 | 33257.2 |
922 | 2024-02-03 02:49:42 | lairds | 3 | 112716 | 852 | 11.546 | 9762.3 |
921 | 2024-01-29 04:57:34 | lairds | 2 | 82551 | 76 | 2.643 | 31233.8 |
920 | 2024-01-26 21:44:51 | lairds | 3 | 112716 | 852 | 8.390 | 13434.6 |
919 | 2024-01-17 04:53:49 | lairds | 3 | 112716 | 852 | 5.050 | 22320.0 |
918 | 2024-01-17 04:53:41 | lairds | 2 | 82551 | 76 | 2.220 | 37185.1 |
917 | 2023-11-29 01:20:00 | lairds | 2 | 82551 | 76 | 2.610 | 31628.7 |
916 | 2023-11-27 09:29:47 | lairds | 1 | 48755 | 7 | 0.846 | 57630.0 |
915 | 2023-11-24 03:07:20 | lairds | 1 | 48755 | 7 | 0.750 | 65006.7 |
914 | 2023-11-22 14:58:05 | lairds | 1 | 48755 | 7 | 0.890 | 54780.9 |
913 | 2023-11-17 08:32:39 | lairds | 1 | 48755 | 7 | 0.873 | 55847.7 |
912 | 2023-11-07 01:00:49 | lairds | 1 | 48755 | 7 | 0.826 | 59025.4 |
911 | 2023-11-01 01:45:50 | lairds | 1 | 48755 | 7 | 0.830 | 58741.0 |
910 | 2023-10-20 03:14:52 | lairds | 1 | 48755 | 7 | 0.813 | 59969.2 |
909 | 2023-10-14 02:31:09 | lairds | 1 | 48755 | 7 | 0.890 | 54780.9 |
908 | 2023-09-24 11:14:19 | lairds | 1 | 48755 | 7 | 0.856 | 56956.8 |
907 | 2023-09-14 09:24:59 | lairds | 1 | 48755 | 7 | 0.796 | 61250.0 |
906 | 2023-08-27 21:41:39 | lairds | 2 | 82551 | 76 | 2.423 | 34069.7 |
905 | 2023-07-31 11:01:24 | lairds | 1 | 48755 | 7 | 0.750 | 65006.7 |
904 | 2023-05-14 05:04:35 | lairds | 2 | 82551 | 76 | 2.170 | 38041.9 |
903 | 2023-04-12 01:22:38 | lairds | 1 | 48755 | 7 | 0.750 | 65006.7 |
902 | 2023-02-18 20:44:09 | lairds | 2 | 82551 | 76 | 2.156 | 38289.0 |
901 | 2022-12-26 17:55:46 | lairds | 1 | 48755 | 7 | 0.750 | 65006.7 |
900 | 2022-12-02 14:12:36 | lairds | 2 | 82551 | 76 | 2.173 | 37989.4 |
899 | 2022-12-02 05:31:57 | lairds | 2 | 82551 | 76 | 2.436 | 33887.9 |
898 | 2022-10-24 23:23:12 | lairds | 2 | 82551 | 76 | 2.250 | 36689.3 |
897 | 2022-09-18 08:12:53 | lairds | 1 | 48755 | 7 | 0.766 | 63648.8 |
896 | 2022-09-12 18:07:10 | lairds | 1 | 48755 | 7 | 0.766 | 63648.8 |
895 | 2022-08-29 20:31:06 | lairds | 1 | 48755 | 7 | 0.843 | 57835.1 |
894 | 2022-08-23 11:32:42 | lairds | 1 | 48755 | 7 | 0.733 | 66514.3 |
893 | 2022-07-15 19:15:23 | lairds | 1 | 48755 | 7 | 0.750 | 65006.7 |
892 | 2022-06-25 18:46:22 | lairds | 1 | 48755 | 7 | 0.733 | 66514.3 |
891 | 2022-06-07 15:59:24 | lairds | 2 | 82551 | 76 | 2.516 | 32810.4 |
890 | 2022-06-06 06:47:41 | lairds | 2 | 82551 | 76 | 2.670 | 30918.0 |
889 | 2022-06-05 09:52:36 | lairds | 2 | 82551 | 76 | 2.780 | 29694.6 |
888 | 2022-06-04 06:18:11 | lairds | 2 | 82551 | 76 | 5.266 | 15676.2 |
887 | 2022-06-03 04:49:09 | lairds | 2 | 82551 | 76 | 2.656 | 31080.9 |
886 | 2022-06-02 13:40:05 | lairds | 2 | 82551 | 76 | 2.330 | 35429.6 |
885 | 2022-05-06 22:43:56 | lairds | 2 | 82551 | 76 | 2.190 | 37694.5 |
884 | 2022-05-06 12:02:05 | lairds | 2 | 82551 | 76 | 2.716 | 30394.3 |
883 | 2022-05-05 19:21:50 | lairds | 2 | 82551 | 76 | 2.376 | 34743.7 |
882 | 2022-05-05 13:10:10 | lairds | 2 | 82551 | 76 | 2.326 | 35490.5 |
881 | 2022-05-05 04:05:29 | lairds | 2 | 82551 | 76 | 2.486 | 33206.4 |
880 | 2022-05-04 19:48:52 | lairds | 2 | 82551 | 76 | 2.686 | 30733.8 |
879 | 2022-05-04 09:43:55 | lairds | 2 | 82551 | 76 | 2.800 | 29482.5 |
878 | 2022-05-03 21:58:17 | lairds | 2 | 82551 | 76 | 3.280 | 25168.0 |
877 | 2022-05-03 08:12:38 | lairds | 2 | 82551 | 76 | 2.233 | 36968.7 |
876 | 2022-04-29 12:05:34 | lairds | 1 | 48755 | 7 | 0.953 | 51159.5 |
875 | 2022-04-27 21:01:34 | lairds | 2 | 82551 | 76 | 2.376 | 34743.7 |
874 | 2022-04-27 04:28:53 | lairds | 2 | 82551 | 76 | 2.170 | 38041.9 |
873 | 2022-04-26 17:03:52 | lairds | 2 | 82551 | 76 | 2.500 | 33020.4 |
872 | 2022-04-26 05:04:13 | lairds | 2 | 82551 | 76 | 2.186 | 37763.5 |
871 | 2022-04-25 18:55:46 | lairds | 1 | 48755 | 7 | 0.780 | 62506.4 |
870 | 2022-04-25 13:51:13 | lairds | 2 | 82551 | 76 | 2.830 | 29170.0 |
869 | 2022-04-24 17:23:11 | lairds | 2 | 82551 | 76 | 2.453 | 33653.1 |
868 | 2022-04-23 18:39:53 | lairds | 2 | 82551 | 76 | 2.453 | 33653.1 |
867 | 2022-04-22 23:44:31 | lairds | 2 | 82551 | 76 | 2.623 | 31472.0 |
866 | 2022-04-22 05:51:48 | lairds | 2 | 82551 | 76 | 2.186 | 37763.5 |
865 | 2022-04-21 23:59:37 | lairds | 2 | 82551 | 76 | 2.720 | 30349.6 |
864 | 2022-04-21 14:43:35 | lairds | 2 | 82551 | 76 | 2.283 | 36159.0 |
863 | 2022-04-20 09:43:54 | lairds | 2 | 82551 | 76 | 2.513 | 32849.6 |
862 | 2022-04-19 21:22:03 | lairds | 2 | 82551 | 76 | 2.486 | 33206.4 |
861 | 2022-04-19 20:37:27 | lairds | 2 | 82551 | 76 | 2.936 | 28116.8 |
860 | 2022-04-19 06:19:29 | lairds | 2 | 82551 | 76 | 2.190 | 37694.5 |
859 | 2022-04-18 04:20:40 | lairds | 2 | 82551 | 76 | 2.190 | 37694.5 |
858 | 2022-04-17 18:07:40 | lairds | 2 | 82551 | 76 | 2.530 | 32628.9 |
857 | 2022-04-16 15:56:51 | lairds | 2 | 82551 | 76 | 2.546 | 32423.8 |
856 | 2022-03-31 06:49:59 | lairds | 2 | 82551 | 76 | 2.436 | 33887.9 |
855 | 2022-03-30 11:16:15 | lairds | 2 | 82551 | 76 | 2.750 | 30018.5 |
854 | 2022-03-29 14:08:24 | lairds | 2 | 82551 | 76 | 2.923 | 28241.9 |
853 | 2022-03-28 20:49:16 | lairds | 2 | 82551 | 76 | 2.563 | 32208.7 |
852 | 2022-03-27 13:19:26 | lairds | 2 | 82551 | 76 | 2.606 | 31677.3 |
851 | 2022-03-26 21:10:14 | lairds | 2 | 82551 | 76 | 2.593 | 31836.1 |
850 | 2022-03-15 15:18:58 | lairds | 1 | 48755 | 7 | 1.110 | 43923.4 |
849 | 2022-03-01 19:41:35 | lairds | 2 | 82551 | 76 | 2.780 | 29694.6 |
848 | 2022-02-28 20:09:17 | lairds | 2 | 82551 | 76 | 2.360 | 34979.2 |
847 | 2022-02-27 20:43:53 | lairds | 2 | 82551 | 76 | 2.186 | 37763.5 |
846 | 2022-02-26 22:24:48 | lairds | 2 | 82551 | 76 | 2.250 | 36689.3 |
845 | 2022-02-25 14:41:16 | lairds | 2 | 82551 | 76 | 2.796 | 29524.7 |
844 | 2022-02-06 18:12:17 | lairds | 2 | 82551 | 76 | 2.233 | 36968.7 |
843 | 2022-02-05 14:06:57 | lairds | 2 | 82551 | 76 | 5.390 | 15315.6 |
842 | 2022-02-04 15:11:19 | lairds | 2 | 82551 | 76 | 2.720 | 30349.6 |
841 | 2022-02-03 11:21:41 | lairds | 2 | 82551 | 76 | 2.626 | 31436.0 |
840 | 2022-02-02 08:35:08 | lairds | 2 | 82551 | 76 | 4.610 | 17906.9 |
839 | 2022-02-01 10:06:23 | lairds | 2 | 82551 | 76 | 2.296 | 35954.3 |
838 | 2022-01-31 10:16:22 | lairds | 2 | 82551 | 76 | 4.013 | 20570.9 |
837 | 2022-01-30 16:22:12 | lairds | 2 | 82551 | 76 | 2.640 | 31269.3 |
836 | 2022-01-29 16:34:13 | lairds | 2 | 82551 | 76 | 2.500 | 33020.4 |
835 | 2022-01-28 13:37:46 | lairds | 2 | 82551 | 76 | 2.250 | 36689.3 |