History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rosters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1006 | 2024-03-28 05:55:16 | rosters | 1 | 69583 | 16 | 1.170 | 59472.6 |
1005 | 2024-03-18 07:20:53 | rosters | 1 | 69583 | 16 | 1.233 | 56433.9 |
1004 | 2024-02-16 20:09:17 | rosters | 1 | 69583 | 16 | 1.250 | 55666.4 |
1003 | 2024-01-29 01:56:29 | rosters | 1 | 69583 | 16 | 1.453 | 47889.2 |
1002 | 2024-01-27 01:17:31 | rosters | 1 | 69583 | 16 | 1.203 | 57841.2 |
1001 | 2024-01-26 23:42:54 | rosters | 1 | 69583 | 16 | 1.283 | 54234.6 |
1000 | 2024-01-14 18:01:42 | rosters | 2 | 107671 | 185 | 2.940 | 36622.8 |
999 | 2024-01-02 13:05:53 | rosters | 1 | 69583 | 16 | 1.186 | 58670.3 |
998 | 2023-12-28 19:32:17 | rosters | 1 | 69583 | 16 | 1.173 | 59320.5 |
997 | 2023-12-07 16:54:02 | rosters | 1 | 69583 | 16 | 1.296 | 53690.6 |
996 | 2023-12-07 16:54:00 | rosters | 1 | 69583 | 16 | 1.313 | 52995.4 |
995 | 2023-12-01 06:49:57 | rosters | 1 | 69583 | 16 | 2.140 | 32515.4 |
994 | 2023-11-22 15:38:32 | rosters | 1 | 69583 | 16 | 1.123 | 61961.7 |
993 | 2023-11-21 08:02:53 | rosters | 1 | 69583 | 16 | 1.203 | 57841.2 |
992 | 2023-11-17 23:22:06 | rosters | 1 | 69583 | 16 | 1.236 | 56296.9 |
991 | 2023-11-17 00:49:40 | rosters | 1 | 69583 | 16 | 1.250 | 55666.4 |
990 | 2023-11-16 16:31:57 | rosters | 1 | 69583 | 16 | 1.263 | 55093.4 |
989 | 2023-11-14 14:43:07 | rosters | 1 | 69583 | 16 | 1.296 | 53690.6 |
988 | 2023-11-11 05:48:06 | rosters | 1 | 69583 | 16 | 1.096 | 63488.1 |
987 | 2023-10-29 21:15:15 | rosters | 1 | 69583 | 16 | 1.300 | 53525.4 |
986 | 2023-10-24 23:06:52 | rosters | 1 | 69583 | 16 | 2.596 | 26803.9 |
985 | 2023-10-16 02:02:56 | rosters | 1 | 69583 | 16 | 1.093 | 63662.4 |
984 | 2023-09-25 17:10:59 | rosters | 1 | 69583 | 16 | 1.220 | 57035.2 |
983 | 2023-09-24 22:24:11 | rosters | 1 | 69583 | 16 | 1.250 | 55666.4 |
982 | 2023-09-21 02:48:50 | rosters | 1 | 69583 | 16 | 1.250 | 55666.4 |
981 | 2023-09-09 07:28:29 | rosters | 1 | 69583 | 16 | 1.470 | 47335.4 |
980 | 2023-09-05 17:23:58 | rosters | 1 | 69583 | 16 | 1.093 | 63662.4 |
979 | 2023-08-10 07:33:02 | rosters | 1 | 69583 | 16 | 1.140 | 61037.7 |
978 | 2023-08-08 09:39:32 | rosters | 1 | 69583 | 16 | 1.076 | 64668.2 |
977 | 2023-08-05 02:38:01 | rosters | 1 | 69583 | 16 | 1.076 | 64668.2 |
976 | 2023-07-31 16:02:34 | rosters | 1 | 69583 | 16 | 1.063 | 65459.1 |
975 | 2023-07-30 12:53:59 | rosters | 1 | 69583 | 16 | 1.343 | 51811.6 |
974 | 2023-07-20 17:10:12 | rosters | 2 | 107671 | 185 | 2.936 | 36672.7 |
973 | 2023-07-19 22:21:09 | rosters | 2 | 107671 | 185 | 3.063 | 35152.1 |
972 | 2023-07-15 16:52:32 | rosters | 1 | 69583 | 16 | 1.093 | 63662.4 |
971 | 2023-07-14 19:38:54 | rosters | 1 | 69583 | 16 | 2.390 | 29114.2 |
970 | 2023-07-12 07:47:34 | rosters | 1 | 69583 | 16 | 1.250 | 55666.4 |
969 | 2023-06-17 08:46:34 | rosters | 1 | 69583 | 16 | 1.156 | 60192.9 |
968 | 2023-06-07 18:48:35 | rosters | 2 | 107671 | 185 | 2.830 | 38046.3 |
967 | 2023-05-19 21:52:12 | rosters | 1 | 69583 | 16 | 1.063 | 65459.1 |
966 | 2023-05-14 15:56:59 | rosters | 1 | 69583 | 16 | 1.216 | 57222.9 |
965 | 2023-05-13 16:59:53 | rosters | 1 | 69583 | 16 | 1.156 | 60192.9 |
964 | 2023-05-12 17:41:25 | rosters | 1 | 69583 | 16 | 1.080 | 64428.7 |
963 | 2023-05-11 23:01:53 | rosters | 1 | 69583 | 16 | 1.123 | 61961.7 |
962 | 2023-05-11 02:45:15 | rosters | 1 | 69583 | 16 | 1.063 | 65459.1 |
961 | 2023-05-10 08:39:43 | rosters | 1 | 69583 | 16 | 1.140 | 61037.7 |
960 | 2023-05-03 13:34:45 | rosters | 1 | 69583 | 16 | 1.080 | 64428.7 |
959 | 2023-04-01 01:51:57 | rosters | 1 | 69583 | 16 | 1.173 | 59320.5 |
958 | 2023-03-20 02:59:56 | rosters | 1 | 69583 | 16 | 1.250 | 55666.4 |
957 | 2023-02-03 01:53:46 | rosters | 1 | 69583 | 16 | 1.063 | 65459.1 |
956 | 2023-01-30 16:34:17 | rosters | 1 | 69583 | 16 | 1.080 | 64428.7 |
955 | 2023-01-14 04:29:02 | rosters | 1 | 69583 | 16 | 1.076 | 64668.2 |
954 | 2022-11-03 21:14:26 | rosters | 1 | 69583 | 16 | 1.063 | 65459.1 |
953 | 2022-10-12 19:52:07 | rosters | 1 | 69583 | 16 | 1.063 | 65459.1 |
952 | 2022-08-07 18:37:02 | rosters | 1 | 69583 | 16 | 1.233 | 56433.9 |
951 | 2022-06-23 16:30:40 | rosters | 1 | 69583 | 16 | 1.080 | 64428.7 |
950 | 2022-06-18 18:31:49 | rosters | 1 | 69583 | 16 | 1.076 | 64668.2 |
949 | 2022-06-13 05:28:42 | rosters | 1 | 69583 | 16 | 1.093 | 63662.4 |
948 | 2022-05-27 16:06:49 | rosters | 1 | 69583 | 16 | 1.093 | 63662.4 |
947 | 2022-04-22 22:16:11 | rosters | 1 | 69583 | 16 | 1.076 | 64668.2 |
946 | 2022-04-12 13:06:51 | rosters | 1 | 69583 | 16 | 1.390 | 50059.7 |
945 | 2022-04-11 11:13:22 | rosters | 1 | 69583 | 16 | 1.186 | 58670.3 |
944 | 2022-04-10 11:24:46 | rosters | 1 | 69583 | 16 | 1.156 | 60192.9 |
943 | 2022-04-09 16:33:49 | rosters | 1 | 69583 | 16 | 1.236 | 56296.9 |
942 | 2022-03-31 06:38:32 | rosters | 1 | 69583 | 16 | 1.093 | 63662.4 |
941 | 2022-03-30 17:40:22 | rosters | 1 | 69583 | 16 | 1.253 | 55533.1 |
940 | 2022-03-30 05:42:50 | rosters | 1 | 69583 | 16 | 1.216 | 57222.9 |
939 | 2022-03-29 20:09:32 | rosters | 1 | 69583 | 16 | 1.283 | 54234.6 |
938 | 2022-03-29 08:32:11 | rosters | 1 | 69583 | 16 | 1.843 | 37755.3 |
937 | 2022-03-28 09:59:25 | rosters | 1 | 69583 | 16 | 1.170 | 59472.6 |
936 | 2022-03-27 17:44:39 | rosters | 1 | 69583 | 16 | 1.093 | 63662.4 |
935 | 2022-03-26 09:33:56 | rosters | 1 | 69583 | 16 | 1.300 | 53525.4 |
934 | 2022-03-21 21:24:27 | rosters | 1 | 69583 | 16 | 1.123 | 61961.7 |
933 | 2022-03-20 21:42:13 | rosters | 1 | 69583 | 16 | 1.123 | 61961.7 |
932 | 2022-03-15 13:49:11 | rosters | 1 | 69583 | 16 | 1.250 | 55666.4 |
931 | 2022-03-14 18:18:19 | rosters | 1 | 69583 | 16 | 1.203 | 57841.2 |
930 | 2022-03-13 18:30:05 | rosters | 1 | 69583 | 16 | 1.250 | 55666.4 |
929 | 2022-03-12 13:00:35 | rosters | 1 | 69583 | 16 | 1.266 | 54962.9 |
928 | 2022-03-06 15:02:27 | rosters | 1 | 69583 | 16 | 1.093 | 63662.4 |
927 | 2022-02-28 18:07:31 | rosters | 1 | 69583 | 16 | 1.140 | 61037.7 |
926 | 2022-02-20 16:25:50 | rosters | 1 | 69583 | 16 | 1.170 | 59472.6 |
925 | 2022-02-14 16:57:26 | rosters | 1 | 69583 | 16 | 1.156 | 60192.9 |
924 | 2022-02-11 03:23:02 | rosters | 1 | 69583 | 16 | 1.080 | 64428.7 |
923 | 2022-02-10 10:30:50 | rosters | 1 | 69583 | 16 | 1.483 | 46920.4 |
922 | 2022-02-09 22:33:09 | rosters | 1 | 69583 | 16 | 1.093 | 63662.4 |
921 | 2022-02-09 14:09:21 | rosters | 1 | 69583 | 16 | 1.310 | 53116.8 |
920 | 2022-02-08 12:47:59 | rosters | 1 | 69583 | 16 | 1.123 | 61961.7 |
919 | 2022-02-07 18:29:24 | rosters | 1 | 69583 | 16 | 1.360 | 51164.0 |
918 | 2022-01-09 21:05:18 | rosters | 1 | 69583 | 16 | 1.466 | 47464.5 |
917 | 2022-01-07 22:03:19 | rosters | 1 | 69583 | 16 | 1.156 | 60192.9 |
916 | 2022-01-06 22:39:02 | rosters | 1 | 69583 | 16 | 1.216 | 57222.9 |
915 | 2022-01-03 15:53:31 | rosters | 1 | 69583 | 16 | 1.236 | 56296.9 |
914 | 2021-12-31 23:12:30 | rosters | 1 | 69583 | 16 | 1.266 | 54962.9 |
913 | 2021-12-31 11:54:53 | rosters | 1 | 69583 | 16 | 2.546 | 27330.3 |
912 | 2021-12-30 17:42:36 | rosters | 1 | 69583 | 16 | 1.296 | 53690.6 |
911 | 2021-12-30 00:29:16 | rosters | 1 | 69583 | 16 | 2.330 | 29863.9 |
910 | 2021-12-29 16:25:37 | rosters | 1 | 69583 | 16 | 2.593 | 26834.9 |
909 | 2021-12-29 05:14:53 | rosters | 1 | 69583 | 16 | 1.533 | 45390.1 |
908 | 2021-12-28 15:48:00 | rosters | 1 | 69583 | 16 | 1.423 | 48898.8 |
907 | 2021-12-27 21:43:53 | rosters | 1 | 69583 | 16 | 1.296 | 53690.6 |