History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crap"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1107 | 2024-04-27 19:45:00 | crap | 1 | 13983 | 18 | 0.266 | 52567.7 |
1106 | 2024-04-16 23:35:33 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1105 | 2024-04-15 18:51:49 | crap | 1 | 13983 | 18 | 0.203 | 68881.8 |
1104 | 2024-04-04 19:33:18 | crap | 1 | 13983 | 18 | 0.296 | 47239.9 |
1103 | 2024-04-02 18:37:57 | crap | 1 | 13983 | 18 | 0.546 | 25609.9 |
1102 | 2024-03-31 00:08:58 | crap | 1 | 13983 | 18 | 0.440 | 31779.5 |
1101 | 2024-03-28 11:48:12 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1100 | 2024-03-27 00:57:47 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1099 | 2024-03-05 17:30:37 | crap | 1 | 13983 | 18 | 0.546 | 25609.9 |
1098 | 2024-03-02 18:30:52 | crap | 2 | 29872 | 246 | 2.033 | 14693.6 |
1097 | 2024-03-02 17:06:47 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1096 | 2024-02-25 20:51:51 | crap | 1 | 13983 | 18 | 0.263 | 53167.3 |
1095 | 2024-02-03 00:35:34 | crap | 1 | 13983 | 18 | 0.266 | 52567.7 |
1094 | 2024-01-30 02:53:11 | crap | 1 | 13983 | 18 | 0.420 | 33292.9 |
1093 | 2024-01-26 18:00:21 | crap | 1 | 13983 | 18 | 0.266 | 52567.7 |
1092 | 2023-12-21 19:32:54 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1091 | 2023-12-15 11:05:20 | crap | 1 | 13983 | 18 | 0.203 | 68881.8 |
1090 | 2023-12-09 21:57:14 | crap | 2 | 29872 | 246 | 0.923 | 32364.0 |
1089 | 2023-12-03 18:51:56 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1088 | 2023-12-03 18:51:55 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1087 | 2023-12-03 18:46:45 | crap | 1 | 13983 | 18 | 0.263 | 53167.3 |
1086 | 2023-11-27 10:18:34 | crap | 2 | 29872 | 246 | 0.750 | 39829.3 |
1085 | 2023-11-19 09:35:29 | crap | 2 | 29872 | 246 | 0.750 | 39829.3 |
1084 | 2023-11-10 22:21:56 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1083 | 2023-11-09 01:31:27 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1082 | 2023-11-04 20:47:08 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1081 | 2023-11-03 18:10:34 | crap | 2 | 29872 | 246 | 0.830 | 35990.4 |
1080 | 2023-10-27 12:40:33 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1079 | 2023-10-21 08:00:18 | crap | 2 | 29872 | 246 | 0.986 | 30296.1 |
1078 | 2023-10-19 15:26:58 | crap | 1 | 13983 | 18 | 0.203 | 68881.8 |
1077 | 2023-10-18 02:44:18 | crap | 1 | 13983 | 18 | 0.236 | 59250.0 |
1076 | 2023-10-15 00:31:41 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1075 | 2023-10-14 02:58:51 | crap | 2 | 29872 | 246 | 0.763 | 39150.7 |
1074 | 2023-10-10 17:21:01 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1073 | 2023-10-09 09:07:57 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1072 | 2023-10-04 07:53:22 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1071 | 2023-09-27 23:35:45 | crap | 2 | 29872 | 246 | 0.750 | 39829.3 |
1070 | 2023-09-23 22:02:04 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1069 | 2023-09-19 18:55:37 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1068 | 2023-08-05 04:51:54 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1067 | 2023-07-05 14:01:49 | crap | 1 | 13983 | 18 | 0.216 | 64736.1 |
1066 | 2023-05-03 17:05:54 | crap | 1 | 13983 | 18 | 0.423 | 33056.7 |
1065 | 2023-04-01 18:58:54 | crap | 1 | 13983 | 18 | 0.203 | 68881.8 |
1064 | 2023-03-26 22:49:52 | crap | 1 | 13983 | 18 | 0.236 | 59250.0 |
1063 | 2023-01-17 08:21:44 | crap | 1 | 13983 | 18 | 0.266 | 52567.7 |
1062 | 2022-12-27 15:00:57 | crap | 1 | 13983 | 18 | 0.203 | 68881.8 |
1061 | 2022-09-13 05:46:17 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1060 | 2022-08-15 05:09:26 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1059 | 2022-07-29 12:29:09 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1058 | 2022-07-07 14:26:22 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1057 | 2022-06-07 09:41:34 | crap | 1 | 13983 | 18 | 0.216 | 64736.1 |
1056 | 2022-05-24 21:34:11 | crap | 1 | 13983 | 18 | 0.203 | 68881.8 |
1055 | 2022-03-29 14:12:37 | crap | 1 | 13983 | 18 | 0.313 | 44674.1 |
1054 | 2022-03-12 07:11:11 | crap | 1 | 13983 | 18 | 0.216 | 64736.1 |
1053 | 2022-02-09 18:57:52 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1052 | 2022-01-05 14:01:48 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1051 | 2022-01-04 20:36:17 | crap | 1 | 13983 | 18 | 0.236 | 59250.0 |
1050 | 2021-12-24 19:25:50 | crap | 1 | 13983 | 18 | 0.236 | 59250.0 |
1049 | 2021-12-23 22:16:29 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1048 | 2021-12-23 14:19:43 | crap | 1 | 13983 | 18 | 0.516 | 27098.8 |
1047 | 2021-12-23 03:05:25 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1046 | 2021-12-22 18:40:56 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1045 | 2021-12-22 16:38:36 | crap | 1 | 13983 | 18 | 0.500 | 27966.0 |
1044 | 2021-12-22 08:54:41 | crap | 1 | 13983 | 18 | 0.216 | 64736.1 |
1043 | 2021-12-21 23:06:34 | crap | 1 | 13983 | 18 | 0.236 | 59250.0 |
1042 | 2021-12-21 13:54:31 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1041 | 2021-12-20 23:47:50 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1040 | 2021-12-20 16:26:01 | crap | 1 | 13983 | 18 | 0.266 | 52567.7 |
1039 | 2021-12-20 10:19:03 | crap | 1 | 13983 | 18 | 0.500 | 27966.0 |
1038 | 2021-12-19 21:10:18 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1037 | 2021-11-22 13:07:08 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1036 | 2021-11-22 04:51:41 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1035 | 2021-11-21 17:20:04 | crap | 1 | 13983 | 18 | 0.236 | 59250.0 |
1034 | 2021-11-21 01:09:48 | crap | 1 | 13983 | 18 | 0.263 | 53167.3 |
1033 | 2021-11-10 22:48:52 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1032 | 2021-11-08 21:10:56 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1031 | 2021-10-29 22:47:39 | crap | 1 | 13983 | 18 | 0.203 | 68881.8 |
1030 | 2021-10-22 11:09:28 | crap | 1 | 13983 | 18 | 0.216 | 64736.1 |
1029 | 2021-10-21 23:14:43 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1028 | 2021-10-21 03:53:41 | crap | 1 | 13983 | 18 | 0.466 | 30006.4 |
1027 | 2021-10-20 10:28:26 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1026 | 2021-10-19 09:40:07 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1025 | 2021-10-14 22:33:40 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1024 | 2021-10-14 15:22:37 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1023 | 2021-10-14 01:17:15 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1022 | 2021-10-13 13:53:33 | crap | 1 | 13983 | 18 | 0.263 | 53167.3 |
1021 | 2021-10-13 03:07:17 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1020 | 2021-10-12 10:23:34 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1019 | 2021-10-11 20:12:00 | crap | 1 | 13983 | 18 | 0.346 | 40413.3 |
1018 | 2021-10-11 13:11:18 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1017 | 2021-10-10 20:52:31 | crap | 1 | 13983 | 18 | 0.216 | 64736.1 |
1016 | 2021-10-10 11:37:14 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1015 | 2021-10-10 01:16:16 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1014 | 2021-09-22 15:04:54 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1013 | 2021-09-21 22:49:03 | crap | 1 | 13983 | 18 | 0.200 | 69915.0 |
1012 | 2021-09-21 21:28:39 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |
1011 | 2021-09-21 04:18:09 | crap | 1 | 13983 | 18 | 0.250 | 55932.0 |
1010 | 2021-09-15 01:51:08 | crap | 1 | 13983 | 18 | 0.203 | 68881.8 |
1009 | 2021-09-13 15:04:10 | crap | 1 | 13983 | 18 | 0.220 | 63559.1 |
1008 | 2021-09-11 11:14:16 | crap | 1 | 13983 | 18 | 0.233 | 60012.9 |