History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rota"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
961 | 2025-04-15 21:13:57 | rota | 2 | 29872 | 261 | 3.826 | 7807.6 |
960 | 2025-04-14 23:45:53 | rota | 1 | 13983 | 13 | 0.220 | 63559.1 |
959 | 2025-04-11 09:27:52 | rota | 1 | 13983 | 13 | 0.703 | 19890.5 |
958 | 2025-04-06 09:20:37 | rota | 1 | 13983 | 13 | 0.296 | 47239.9 |
957 | 2025-03-27 10:05:07 | rota | 1 | 13983 | 13 | 1.186 | 11790.1 |
956 | 2025-03-19 23:00:15 | rota | 1 | 13983 | 13 | 0.733 | 19076.4 |
955 | 2025-03-17 11:31:33 | rota | 1 | 13983 | 13 | 0.686 | 20383.4 |
954 | 2025-03-15 09:03:17 | rota | 2 | 29872 | 261 | 4.466 | 6688.8 |
953 | 2025-03-15 08:38:25 | rota | 1 | 13983 | 13 | 0.670 | 20870.1 |
952 | 2025-03-10 23:38:54 | rota | 1 | 13983 | 13 | 1.140 | 12265.8 |
951 | 2025-03-06 19:31:54 | rota | 2 | 29872 | 261 | 6.516 | 4584.4 |
950 | 2025-03-06 08:23:06 | rota | 2 | 29872 | 261 | 2.920 | 10230.1 |
949 | 2025-03-06 08:22:48 | rota | 1 | 13983 | 13 | 0.610 | 22923.0 |
948 | 2025-02-27 12:03:58 | rota | 1 | 13983 | 13 | 0.626 | 22337.1 |
947 | 2025-02-25 16:05:07 | rota | 1 | 13983 | 13 | 0.236 | 59250.0 |
946 | 2025-02-25 12:39:38 | rota | 2 | 29872 | 261 | 4.406 | 6779.8 |
945 | 2025-02-25 11:31:51 | rota | 1 | 13983 | 13 | 0.236 | 59250.0 |
944 | 2025-02-25 09:10:24 | rota | 2 | 29872 | 261 | 2.516 | 11872.8 |
943 | 2025-02-25 08:52:28 | rota | 1 | 13983 | 13 | 0.220 | 63559.1 |
942 | 2025-02-22 20:50:30 | rota | 1 | 13983 | 13 | 0.906 | 15433.8 |
941 | 2025-02-14 19:45:07 | rota | 2 | 29872 | 261 | 4.520 | 6608.8 |
940 | 2025-02-04 08:06:07 | rota | 1 | 13983 | 13 | 2.483 | 5631.5 |
939 | 2025-01-26 06:56:19 | rota | 2 | 29872 | 261 | 3.890 | 7679.2 |
938 | 2025-01-26 06:27:32 | rota | 1 | 13983 | 13 | 1.236 | 11313.1 |
937 | 2025-01-26 06:20:07 | rota | 1 | 13983 | 13 | 0.830 | 16847.0 |
936 | 2025-01-23 18:38:02 | rota | 1 | 13983 | 13 | 1.156 | 12096.0 |
935 | 2025-01-05 06:21:36 | rota | 2 | 29872 | 261 | 4.046 | 7383.1 |
934 | 2025-01-05 06:00:40 | rota | 2 | 29872 | 261 | 4.486 | 6658.9 |
933 | 2025-01-05 05:52:09 | rota | 1 | 13983 | 13 | 0.266 | 52567.7 |
932 | 2024-12-27 06:10:39 | rota | 1 | 13983 | 13 | 0.216 | 64736.1 |
931 | 2024-12-27 05:23:23 | rota | 1 | 13983 | 13 | 0.233 | 60012.9 |
930 | 2024-12-24 18:11:18 | rota | 1 | 13983 | 13 | 1.110 | 12597.3 |
929 | 2024-12-06 06:22:54 | rota | 2 | 29872 | 261 | 4.860 | 6146.5 |
928 | 2024-12-06 03:54:39 | rota | 2 | 29872 | 261 | 4.610 | 6479.8 |
927 | 2024-12-06 02:54:59 | rota | 2 | 29872 | 261 | 2.216 | 13480.1 |
926 | 2024-12-06 02:37:24 | rota | 1 | 13983 | 13 | 0.250 | 55932.0 |
925 | 2024-11-27 05:40:42 | rota | 1 | 13983 | 13 | 0.263 | 53167.3 |
924 | 2024-11-27 03:12:29 | rota | 1 | 13983 | 13 | 0.233 | 60012.9 |
923 | 2024-11-24 18:03:34 | rota | 1 | 13983 | 13 | 1.393 | 10038.0 |
922 | 2024-11-06 02:44:05 | rota | 2 | 29872 | 261 | 4.406 | 6779.8 |
921 | 2024-11-06 02:29:46 | rota | 1 | 13983 | 13 | 1.406 | 9945.2 |
920 | 2024-10-28 08:32:19 | rota | 2 | 29872 | 261 | 3.390 | 8811.8 |
919 | 2024-10-28 03:31:41 | rota | 2 | 29872 | 261 | 4.750 | 6288.8 |
918 | 2024-10-28 02:06:32 | rota | 1 | 13983 | 13 | 0.266 | 52567.7 |
917 | 2024-10-27 23:53:16 | rota | 1 | 13983 | 13 | 0.280 | 49939.3 |
916 | 2024-10-25 16:46:32 | rota | 1 | 13983 | 13 | 0.656 | 21315.5 |
915 | 2024-10-10 00:44:00 | rota | 1 | 13983 | 13 | 1.356 | 10311.9 |
914 | 2024-10-07 03:24:20 | rota | 2 | 29872 | 261 | 6.076 | 4916.4 |
913 | 2024-10-07 03:20:42 | rota | 1 | 13983 | 13 | 0.953 | 14672.6 |
912 | 2024-09-28 02:23:28 | rota | 2 | 29872 | 261 | 9.500 | 3144.4 |
911 | 2024-09-27 23:46:55 | rota | 1 | 13983 | 13 | 0.263 | 53167.3 |
910 | 2024-09-27 11:18:45 | rota | 1 | 13983 | 13 | 1.686 | 8293.6 |
909 | 2024-09-25 13:03:06 | rota | 2 | 29872 | 261 | 9.296 | 3213.4 |
908 | 2024-09-25 13:02:57 | rota | 1 | 13983 | 13 | 1.233 | 11340.6 |
907 | 2024-09-06 20:57:24 | rota | 1 | 13983 | 13 | 2.233 | 6262.0 |
906 | 2024-08-29 22:58:55 | rota | 1 | 13983 | 13 | 1.656 | 8443.8 |
905 | 2024-08-28 20:39:32 | rota | 2 | 29872 | 261 | 7.986 | 3740.5 |
904 | 2024-08-28 19:22:56 | rota | 2 | 29872 | 261 | 6.220 | 4802.6 |
903 | 2024-08-28 17:28:44 | rota | 1 | 13983 | 13 | 0.266 | 52567.7 |
902 | 2024-08-28 10:02:57 | rota | 1 | 13983 | 13 | 2.423 | 5770.9 |
901 | 2024-08-26 04:08:18 | rota | 1 | 13983 | 13 | 3.876 | 3607.6 |
900 | 2024-08-08 19:01:06 | rota | 1 | 13983 | 13 | 0.673 | 20777.1 |
899 | 2024-08-07 20:18:38 | rota | 1 | 13983 | 13 | 1.686 | 8293.6 |
898 | 2024-08-02 11:04:12 | rota | 2 | 29872 | 261 | 1.860 | 16060.2 |
897 | 2024-08-02 09:32:56 | rota | 1 | 13983 | 13 | 0.250 | 55932.0 |
896 | 2024-07-29 17:06:57 | rota | 2 | 29872 | 261 | 1.983 | 15064.0 |
895 | 2024-07-29 17:06:53 | rota | 1 | 13983 | 13 | 1.250 | 11186.4 |
894 | 2024-07-29 15:00:56 | rota | 1 | 13983 | 13 | 0.216 | 64736.1 |
893 | 2024-07-29 11:21:27 | rota | 1 | 13983 | 13 | 0.986 | 14181.5 |
892 | 2024-07-29 08:15:21 | rota | 2 | 29872 | 261 | 1.560 | 19148.7 |
891 | 2024-07-29 06:53:39 | rota | 2 | 29872 | 261 | 4.330 | 6898.8 |
890 | 2024-07-29 05:34:12 | rota | 2 | 29872 | 261 | 1.860 | 16060.2 |
889 | 2024-07-29 04:54:33 | rota | 1 | 13983 | 13 | 0.376 | 37188.8 |
888 | 2024-07-26 23:47:41 | rota | 1 | 13983 | 13 | 0.533 | 26234.5 |
887 | 2024-07-07 19:15:11 | rota | 1 | 13983 | 13 | 0.686 | 20383.4 |
886 | 2024-07-03 03:04:52 | rota | 1 | 13983 | 13 | 0.283 | 49409.9 |
885 | 2024-06-30 23:56:59 | rota | 1 | 13983 | 13 | 0.923 | 15149.5 |
884 | 2024-06-30 20:54:52 | rota | 1 | 13983 | 13 | 0.656 | 21315.5 |
883 | 2024-06-29 14:47:22 | rota | 1 | 13983 | 13 | 0.690 | 20265.2 |
882 | 2024-06-29 03:50:00 | rota | 1 | 13983 | 13 | 1.233 | 11340.6 |
881 | 2024-06-26 19:48:47 | rota | 1 | 13983 | 13 | 1.000 | 13983.0 |
880 | 2024-06-25 22:02:58 | rota | 1 | 13983 | 13 | 1.406 | 9945.2 |
879 | 2024-06-10 04:43:04 | rota | 1 | 13983 | 13 | 1.373 | 10184.3 |
878 | 2024-06-07 12:17:44 | rota | 1 | 13983 | 13 | 1.906 | 7336.3 |
877 | 2024-06-07 09:47:09 | rota | 1 | 13983 | 13 | 0.296 | 47239.9 |
876 | 2024-05-30 07:46:13 | rota | 2 | 29872 | 261 | 1.856 | 16094.8 |
875 | 2024-05-30 06:19:38 | rota | 2 | 29872 | 261 | 2.406 | 12415.6 |
874 | 2024-05-30 06:18:44 | rota | 1 | 13983 | 13 | 0.906 | 15433.8 |
873 | 2024-05-29 05:46:46 | rota | 1 | 13983 | 13 | 0.673 | 20777.1 |
872 | 2024-05-27 12:56:14 | rota | 1 | 13983 | 13 | 0.830 | 16847.0 |
871 | 2024-05-15 12:51:57 | rota | 1 | 13983 | 13 | 0.373 | 37487.9 |
870 | 2024-05-03 18:13:43 | rota | 1 | 13983 | 13 | 0.263 | 53167.3 |
869 | 2024-05-02 00:43:48 | rota | 2 | 29872 | 261 | 0.983 | 30388.6 |
868 | 2024-05-01 21:12:08 | rota | 1 | 13983 | 13 | 0.500 | 27966.0 |
867 | 2024-05-01 13:04:34 | rota | 1 | 13983 | 13 | 0.516 | 27098.8 |
866 | 2024-04-29 22:01:50 | rota | 1 | 13983 | 13 | 0.266 | 52567.7 |
865 | 2024-04-29 03:05:14 | rota | 1 | 13983 | 13 | 0.826 | 16928.6 |
864 | 2024-04-12 11:28:27 | rota | 1 | 13983 | 13 | 0.906 | 15433.8 |
863 | 2024-04-02 20:45:24 | rota | 1 | 13983 | 13 | 0.220 | 63559.1 |
862 | 2024-04-01 16:12:30 | rota | 1 | 13983 | 13 | 0.423 | 33056.7 |