History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chatter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1025 | 2024-04-26 04:48:44 | chatter | 1 | 69583 | 15 | 1.156 | 60192.9 |
1024 | 2024-03-26 03:15:53 | chatter | 1 | 69583 | 15 | 1.173 | 59320.5 |
1023 | 2024-03-04 17:47:03 | chatter | 1 | 69583 | 15 | 2.983 | 23326.5 |
1022 | 2024-03-03 23:17:56 | chatter | 2 | 107671 | 91 | 11.440 | 9411.8 |
1021 | 2024-03-03 12:24:21 | chatter | 2 | 107671 | 91 | 7.140 | 15080.0 |
1020 | 2024-03-03 12:24:19 | chatter | 1 | 69583 | 15 | 1.330 | 52318.0 |
1019 | 2024-02-12 11:36:28 | chatter | 3 | 134027 | 720 | 13.050 | 10270.3 |
1018 | 2024-02-11 16:10:53 | chatter | 3 | 134027 | 720 | 24.783 | 5408.0 |
1017 | 2024-02-09 17:45:22 | chatter | 1 | 69583 | 15 | 1.360 | 51164.0 |
1016 | 2024-02-08 10:09:18 | chatter | 3 | 134027 | 720 | 20.093 | 6670.3 |
1015 | 2024-02-06 03:00:25 | chatter | 3 | 134027 | 720 | 12.423 | 10788.6 |
1014 | 2024-02-05 23:21:34 | chatter | 3 | 134027 | 720 | 9.686 | 13837.2 |
1013 | 2024-01-21 00:48:33 | chatter | 2 | 107671 | 91 | 2.923 | 36835.8 |
1012 | 2024-01-20 18:39:37 | chatter | 1 | 69583 | 15 | 1.186 | 58670.3 |
1011 | 2024-01-13 10:20:51 | chatter | 2 | 107671 | 91 | 3.216 | 33479.8 |
1010 | 2024-01-09 23:21:17 | chatter | 1 | 69583 | 15 | 1.250 | 55666.4 |
1009 | 2024-01-08 12:50:07 | chatter | 3 | 134027 | 720 | 7.436 | 18024.1 |
1008 | 2023-11-30 06:25:45 | chatter | 1 | 69583 | 15 | 1.233 | 56433.9 |
1007 | 2023-11-22 23:32:36 | chatter | 1 | 69583 | 15 | 1.046 | 66522.9 |
1006 | 2023-11-20 09:22:28 | chatter | 1 | 69583 | 15 | 1.266 | 54962.9 |
1005 | 2023-11-19 16:08:28 | chatter | 1 | 69583 | 15 | 1.063 | 65459.1 |
1004 | 2023-11-15 12:36:04 | chatter | 1 | 69583 | 15 | 1.233 | 56433.9 |
1003 | 2023-11-13 22:02:08 | chatter | 1 | 69583 | 15 | 1.126 | 61796.6 |
1002 | 2023-11-01 12:15:06 | chatter | 2 | 107671 | 91 | 2.873 | 37476.9 |
1001 | 2023-10-17 09:50:41 | chatter | 3 | 134027 | 720 | 20.296 | 6603.6 |
1000 | 2023-10-17 01:49:03 | chatter | 1 | 69583 | 15 | 1.063 | 65459.1 |
999 | 2023-10-15 09:04:06 | chatter | 3 | 134027 | 720 | 5.953 | 22514.2 |
998 | 2023-09-29 19:28:01 | chatter | 1 | 69583 | 15 | 1.093 | 63662.4 |
997 | 2023-09-21 15:10:06 | chatter | 1 | 69583 | 15 | 1.283 | 54234.6 |
996 | 2023-09-14 18:07:03 | chatter | 1 | 69583 | 15 | 1.203 | 57841.2 |
995 | 2023-08-15 03:43:32 | chatter | 2 | 107671 | 91 | 3.080 | 34958.1 |
994 | 2023-08-10 07:51:38 | chatter | 2 | 107671 | 91 | 3.016 | 35699.9 |
993 | 2023-07-31 04:23:45 | chatter | 1 | 69583 | 15 | 1.060 | 65644.3 |
992 | 2023-07-25 17:59:04 | chatter | 3 | 134027 | 720 | 6.236 | 21492.5 |
991 | 2023-07-21 17:42:53 | chatter | 3 | 134027 | 720 | 6.733 | 19906.0 |
990 | 2023-07-03 13:31:08 | chatter | 1 | 69583 | 15 | 1.186 | 58670.3 |
989 | 2023-06-28 21:00:14 | chatter | 1 | 69583 | 15 | 1.236 | 56296.9 |
988 | 2023-05-26 01:37:22 | chatter | 3 | 134027 | 720 | 6.016 | 22278.4 |
987 | 2023-05-01 19:39:28 | chatter | 3 | 134027 | 720 | 6.580 | 20368.8 |
986 | 2023-04-27 16:07:29 | chatter | 3 | 134027 | 720 | 7.173 | 18684.9 |
985 | 2023-04-22 19:08:23 | chatter | 1 | 69583 | 15 | 1.200 | 57985.8 |
984 | 2023-04-22 01:25:53 | chatter | 2 | 107671 | 91 | 3.250 | 33129.5 |
983 | 2023-04-07 22:12:27 | chatter | 1 | 69583 | 15 | 2.343 | 29698.3 |
982 | 2023-04-04 23:58:00 | chatter | 3 | 134027 | 720 | 6.123 | 21889.1 |
981 | 2023-01-29 02:06:31 | chatter | 2 | 107671 | 91 | 3.033 | 35499.8 |
980 | 2023-01-24 03:03:12 | chatter | 1 | 69583 | 15 | 1.186 | 58670.3 |
979 | 2023-01-10 09:23:51 | chatter | 1 | 69583 | 15 | 1.063 | 65459.1 |
978 | 2023-01-06 16:54:32 | chatter | 1 | 69583 | 15 | 1.190 | 58473.1 |
977 | 2023-01-02 01:55:09 | chatter | 3 | 134027 | 720 | 5.593 | 23963.3 |
976 | 2022-11-18 00:09:34 | chatter | 1 | 69583 | 15 | 1.063 | 65459.1 |
975 | 2022-11-07 18:33:44 | chatter | 2 | 107671 | 91 | 3.280 | 32826.5 |
974 | 2022-09-19 08:38:45 | chatter | 1 | 69583 | 15 | 1.050 | 66269.5 |
973 | 2022-09-04 22:46:23 | chatter | 3 | 134027 | 720 | 5.860 | 22871.5 |
972 | 2022-09-02 20:14:18 | chatter | 3 | 134027 | 720 | 6.796 | 19721.5 |
971 | 2022-09-02 01:16:36 | chatter | 1 | 69583 | 15 | 1.203 | 57841.2 |
970 | 2022-08-15 05:12:16 | chatter | 1 | 69583 | 15 | 1.233 | 56433.9 |
969 | 2022-07-29 12:31:56 | chatter | 1 | 69583 | 15 | 1.063 | 65459.1 |
968 | 2022-07-29 01:02:22 | chatter | 1 | 69583 | 15 | 1.080 | 64428.7 |
967 | 2022-07-12 11:24:19 | chatter | 1 | 69583 | 15 | 1.110 | 62687.4 |
966 | 2022-07-10 08:14:43 | chatter | 1 | 69583 | 15 | 1.063 | 65459.1 |
965 | 2022-06-18 08:39:40 | chatter | 3 | 134027 | 720 | 6.096 | 21986.1 |
964 | 2022-05-30 10:21:41 | chatter | 1 | 69583 | 15 | 1.063 | 65459.1 |
963 | 2022-05-27 05:41:29 | chatter | 1 | 69583 | 15 | 1.050 | 66269.5 |
962 | 2022-05-17 08:12:17 | chatter | 2 | 107671 | 91 | 3.563 | 30219.2 |
961 | 2022-05-01 07:30:51 | chatter | 3 | 134027 | 720 | 5.876 | 22809.2 |
960 | 2022-04-27 22:54:41 | chatter | 1 | 69583 | 15 | 1.266 | 54962.9 |
959 | 2022-04-26 19:45:25 | chatter | 1 | 69583 | 15 | 1.220 | 57035.2 |
958 | 2022-04-25 21:44:36 | chatter | 1 | 69583 | 15 | 1.250 | 55666.4 |
957 | 2022-04-23 21:48:00 | chatter | 1 | 69583 | 15 | 1.080 | 64428.7 |
956 | 2022-04-22 23:00:09 | chatter | 1 | 69583 | 15 | 1.376 | 50569.0 |
955 | 2022-04-21 22:41:36 | chatter | 1 | 69583 | 15 | 1.203 | 57841.2 |
954 | 2022-04-20 22:16:07 | chatter | 1 | 69583 | 15 | 1.173 | 59320.5 |
953 | 2022-04-19 22:26:02 | chatter | 1 | 69583 | 15 | 1.280 | 54361.7 |
952 | 2022-04-16 23:54:36 | chatter | 1 | 69583 | 15 | 1.203 | 57841.2 |
951 | 2022-04-08 16:50:51 | chatter | 1 | 69583 | 15 | 1.626 | 42794.0 |
950 | 2022-04-07 19:28:48 | chatter | 1 | 69583 | 15 | 1.780 | 39091.6 |
949 | 2022-04-06 16:38:39 | chatter | 1 | 69583 | 15 | 1.360 | 51164.0 |
948 | 2022-04-05 22:07:29 | chatter | 1 | 69583 | 15 | 1.106 | 62914.1 |
947 | 2022-04-01 17:11:54 | chatter | 1 | 69583 | 15 | 1.170 | 59472.6 |
946 | 2022-03-26 04:51:17 | chatter | 3 | 134027 | 720 | 6.110 | 21935.7 |
945 | 2022-03-15 07:01:30 | chatter | 1 | 69583 | 15 | 1.283 | 54234.6 |
944 | 2022-03-14 08:33:08 | chatter | 1 | 69583 | 15 | 1.280 | 54361.7 |
943 | 2022-03-13 16:18:26 | chatter | 1 | 69583 | 15 | 1.250 | 55666.4 |
942 | 2022-03-12 11:41:02 | chatter | 1 | 69583 | 15 | 1.280 | 54361.7 |
941 | 2022-03-11 17:08:33 | chatter | 2 | 107671 | 91 | 2.953 | 36461.6 |
940 | 2022-03-11 04:52:33 | chatter | 2 | 107671 | 91 | 3.530 | 30501.7 |
939 | 2022-03-10 19:58:27 | chatter | 2 | 107671 | 91 | 4.080 | 26390.0 |
938 | 2022-03-10 00:16:48 | chatter | 2 | 107671 | 91 | 3.516 | 30623.2 |
937 | 2022-03-09 08:58:10 | chatter | 2 | 107671 | 91 | 3.453 | 31181.9 |
936 | 2022-03-08 15:00:27 | chatter | 2 | 107671 | 91 | 4.033 | 26697.5 |
935 | 2022-03-08 11:53:59 | chatter | 1 | 69583 | 15 | 1.640 | 42428.7 |
934 | 2022-03-07 15:04:10 | chatter | 2 | 107671 | 91 | 3.550 | 30329.9 |
933 | 2022-03-07 01:35:12 | chatter | 2 | 107671 | 91 | 3.126 | 34443.7 |
932 | 2022-03-06 10:32:39 | chatter | 2 | 107671 | 91 | 6.373 | 16894.9 |
931 | 2022-03-05 20:01:24 | chatter | 2 | 107671 | 91 | 3.406 | 31612.2 |
930 | 2022-03-05 06:54:26 | chatter | 2 | 107671 | 91 | 2.826 | 38100.1 |
929 | 2022-03-05 03:00:28 | chatter | 2 | 107671 | 91 | 3.236 | 33272.9 |
928 | 2022-03-04 12:18:34 | chatter | 2 | 107671 | 91 | 4.076 | 26415.8 |
927 | 2022-03-03 19:34:27 | chatter | 2 | 107671 | 91 | 3.126 | 34443.7 |
926 | 2022-03-03 05:25:57 | chatter | 2 | 107671 | 91 | 3.186 | 33795.0 |