History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1188 | 2024-04-13 17:45:18 | gate | 2 | 29872 | 468 | 1.156 | 25840.8 |
1187 | 2024-04-13 03:20:58 | gate | 1 | 13983 | 29 | 0.500 | 27966.0 |
1186 | 2024-04-11 10:22:17 | gate | 2 | 29872 | 468 | 0.923 | 32364.0 |
1185 | 2024-04-01 15:53:38 | gate | 1 | 13983 | 29 | 0.283 | 49409.9 |
1184 | 2024-04-01 00:31:38 | gate | 1 | 13983 | 29 | 1.123 | 12451.5 |
1183 | 2024-03-31 00:49:51 | gate | 2 | 29872 | 468 | 2.733 | 10930.1 |
1182 | 2024-03-30 23:12:16 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1181 | 2024-03-28 16:42:24 | gate | 1 | 13983 | 29 | 0.266 | 52567.7 |
1180 | 2024-03-28 01:48:09 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1179 | 2024-03-02 17:45:20 | gate | 1 | 13983 | 29 | 0.216 | 64736.1 |
1178 | 2024-03-02 14:32:27 | gate | 2 | 29872 | 468 | 2.280 | 13101.8 |
1177 | 2024-03-02 13:45:31 | gate | 1 | 13983 | 29 | 0.500 | 27966.0 |
1176 | 2024-02-25 17:04:27 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1175 | 2024-02-19 05:51:11 | gate | 1 | 13983 | 29 | 0.780 | 17926.9 |
1174 | 2024-02-01 10:01:02 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1173 | 2024-01-26 18:24:12 | gate | 1 | 13983 | 29 | 0.266 | 52567.7 |
1172 | 2024-01-20 13:36:44 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1171 | 2024-01-13 05:17:35 | gate | 1 | 13983 | 29 | 0.266 | 52567.7 |
1170 | 2023-12-29 14:37:59 | gate | 1 | 13983 | 29 | 0.200 | 69915.0 |
1169 | 2023-12-23 11:47:36 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1168 | 2023-12-10 07:44:01 | gate | 2 | 29872 | 468 | 0.750 | 39829.3 |
1167 | 2023-12-01 22:01:48 | gate | 2 | 29872 | 468 | 0.890 | 33564.0 |
1166 | 2023-11-16 04:33:26 | gate | 2 | 29872 | 468 | 0.856 | 34897.2 |
1165 | 2023-11-11 16:59:28 | gate | 2 | 29872 | 468 | 0.843 | 35435.3 |
1164 | 2023-11-10 13:29:01 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1163 | 2023-11-08 02:11:55 | gate | 1 | 13983 | 29 | 0.236 | 59250.0 |
1162 | 2023-11-08 01:24:48 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1161 | 2023-11-07 12:34:53 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1160 | 2023-11-02 08:42:32 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1159 | 2023-11-02 02:10:24 | gate | 2 | 29872 | 468 | 0.843 | 35435.3 |
1158 | 2023-11-01 14:01:12 | gate | 2 | 29872 | 468 | 0.766 | 38997.4 |
1157 | 2023-10-26 01:24:23 | gate | 1 | 13983 | 29 | 0.236 | 59250.0 |
1156 | 2023-10-21 11:07:39 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1155 | 2023-10-17 15:17:36 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1154 | 2023-10-14 00:00:09 | gate | 1 | 13983 | 29 | 0.296 | 47239.9 |
1153 | 2023-10-03 16:23:07 | gate | 1 | 13983 | 29 | 0.203 | 68881.8 |
1152 | 2023-09-23 22:07:53 | gate | 1 | 13983 | 29 | 0.266 | 52567.7 |
1151 | 2023-09-22 01:41:08 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1150 | 2023-09-13 16:45:46 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1149 | 2023-09-07 06:53:32 | gate | 2 | 29872 | 468 | 0.750 | 39829.3 |
1148 | 2023-08-27 20:43:53 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1147 | 2023-08-20 06:17:27 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1146 | 2023-06-09 17:58:06 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1145 | 2023-06-06 11:13:39 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1144 | 2023-06-01 16:12:51 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1143 | 2023-05-18 18:14:46 | gate | 2 | 29872 | 468 | 0.736 | 40587.0 |
1142 | 2023-03-26 22:04:49 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1141 | 2023-03-26 04:14:17 | gate | 1 | 13983 | 29 | 0.200 | 69915.0 |
1140 | 2023-02-28 12:50:38 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1139 | 2023-02-22 05:18:12 | gate | 2 | 29872 | 468 | 0.843 | 35435.3 |
1138 | 2023-01-10 03:17:28 | gate | 1 | 13983 | 29 | 0.216 | 64736.1 |
1137 | 2022-12-31 03:17:37 | gate | 2 | 29872 | 468 | 0.906 | 32971.3 |
1136 | 2022-12-18 12:44:17 | gate | 2 | 29872 | 468 | 0.873 | 34217.6 |
1135 | 2022-12-02 12:57:17 | gate | 2 | 29872 | 468 | 0.766 | 38997.4 |
1134 | 2022-11-22 09:42:34 | gate | 1 | 13983 | 29 | 0.280 | 49939.3 |
1133 | 2022-11-17 19:32:49 | gate | 2 | 29872 | 468 | 0.920 | 32469.6 |
1132 | 2022-10-30 14:33:59 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1131 | 2022-10-29 12:55:27 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1130 | 2022-10-28 13:31:25 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1129 | 2022-10-27 12:33:32 | gate | 1 | 13983 | 29 | 0.216 | 64736.1 |
1128 | 2022-10-26 23:49:31 | gate | 1 | 13983 | 29 | 0.203 | 68881.8 |
1127 | 2022-10-25 11:01:11 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1126 | 2022-10-24 15:36:26 | gate | 1 | 13983 | 29 | 0.266 | 52567.7 |
1125 | 2022-10-23 14:51:23 | gate | 1 | 13983 | 29 | 0.203 | 68881.8 |
1124 | 2022-10-22 12:37:14 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1123 | 2022-10-21 18:49:30 | gate | 1 | 13983 | 29 | 0.216 | 64736.1 |
1122 | 2022-10-20 17:40:56 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1121 | 2022-10-19 15:14:06 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1120 | 2022-10-18 23:09:06 | gate | 1 | 13983 | 29 | 0.216 | 64736.1 |
1119 | 2022-10-16 19:58:25 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1118 | 2022-10-14 21:35:31 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1117 | 2022-10-14 18:29:45 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1116 | 2022-10-13 14:09:07 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1115 | 2022-10-12 18:36:26 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1114 | 2022-10-11 15:26:33 | gate | 1 | 13983 | 29 | 0.206 | 67878.6 |
1113 | 2022-10-10 23:51:11 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1112 | 2022-10-09 18:33:37 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1111 | 2022-10-08 15:47:15 | gate | 1 | 13983 | 29 | 0.216 | 64736.1 |
1110 | 2022-10-07 17:22:18 | gate | 1 | 13983 | 29 | 0.203 | 68881.8 |
1109 | 2022-09-19 23:44:15 | gate | 1 | 13983 | 29 | 0.310 | 45106.5 |
1108 | 2022-09-18 16:35:25 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1107 | 2022-08-23 20:48:53 | gate | 1 | 13983 | 29 | 0.216 | 64736.1 |
1106 | 2022-08-22 00:23:22 | gate | 1 | 13983 | 29 | 0.263 | 53167.3 |
1105 | 2022-08-07 00:37:27 | gate | 1 | 13983 | 29 | 0.203 | 68881.8 |
1104 | 2022-07-30 01:59:40 | gate | 1 | 13983 | 29 | 0.203 | 68881.8 |
1103 | 2022-07-17 19:53:01 | gate | 1 | 13983 | 29 | 0.203 | 68881.8 |
1102 | 2022-07-12 16:45:08 | gate | 2 | 29872 | 468 | 0.796 | 37527.6 |
1101 | 2022-07-11 09:18:07 | gate | 2 | 29872 | 468 | 1.563 | 19112.0 |
1100 | 2022-07-10 10:13:55 | gate | 2 | 29872 | 468 | 0.750 | 39829.3 |
1099 | 2022-07-10 05:22:21 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1098 | 2022-07-09 21:53:28 | gate | 1 | 13983 | 29 | 0.250 | 55932.0 |
1097 | 2022-07-02 22:17:30 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1096 | 2022-07-02 16:38:19 | gate | 1 | 13983 | 29 | 0.216 | 64736.1 |
1095 | 2022-06-25 06:21:15 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1094 | 2022-06-24 19:52:32 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1093 | 2022-06-15 21:00:38 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1092 | 2022-06-01 06:47:33 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1091 | 2022-05-31 04:20:09 | gate | 1 | 13983 | 29 | 0.220 | 63559.1 |
1090 | 2022-05-12 21:27:38 | gate | 1 | 13983 | 29 | 0.233 | 60012.9 |
1089 | 2022-05-11 12:05:21 | gate | 1 | 13983 | 29 | 0.313 | 44674.1 |