History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knothole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-04-17 13:17:07 | knothole | 4 | 161609 | 289 | 18.453 | 8757.9 |
280 | 2024-04-16 13:45:57 | knothole | 3 | 146162 | 32 | 10.936 | 13365.2 |
279 | 2024-04-15 22:17:18 | knothole | 3 | 146162 | 32 | 7.653 | 19098.7 |
278 | 2024-04-15 22:17:17 | knothole | 2 | 121059 | 6 | 4.173 | 29010.1 |
277 | 2024-04-15 19:42:08 | knothole | 4 | 161609 | 289 | 47.986 | 3367.8 |
276 | 2024-04-13 17:31:19 | knothole | 4 | 161609 | 289 | 31.786 | 5084.3 |
275 | 2024-04-13 16:30:01 | knothole | 4 | 161609 | 289 | 16.906 | 9559.3 |
274 | 2024-04-13 15:06:05 | knothole | 4 | 161609 | 289 | 11.360 | 14226.1 |
273 | 2024-04-13 15:06:01 | knothole | 1 | 82945 | 2 | 1.326 | 62552.8 |
272 | 2024-04-13 15:05:48 | knothole | 3 | 146162 | 32 | 7.360 | 19859.0 |
271 | 2024-04-13 15:05:52 | knothole | 1 | 82945 | 2 | 1.453 | 57085.3 |
270 | 2024-04-13 15:05:40 | knothole | 4 | 161609 | 289 | 12.656 | 12769.4 |
269 | 2024-04-13 15:05:44 | knothole | 2 | 121059 | 6 | 4.546 | 26629.8 |
268 | 2024-04-01 13:30:56 | knothole | 3 | 146162 | 32 | 10.500 | 13920.2 |
267 | 2024-04-01 13:30:39 | knothole | 2 | 121059 | 6 | 6.986 | 17328.8 |
266 | 2024-04-01 13:30:15 | knothole | 3 | 146162 | 32 | 23.203 | 6299.3 |
265 | 2024-04-01 13:30:14 | knothole | 2 | 121059 | 6 | 9.000 | 13451.0 |
264 | 2024-04-01 13:30:00 | knothole | 1 | 82945 | 2 | 3.936 | 21073.4 |
263 | 2024-03-30 21:34:12 | knothole | 1 | 82945 | 2 | 1.516 | 54713.1 |
262 | 2024-03-29 21:29:12 | knothole | 1 | 82945 | 2 | 1.563 | 53067.8 |
261 | 2024-03-28 16:14:47 | knothole | 1 | 82945 | 2 | 1.343 | 61761.0 |
260 | 2024-03-28 04:48:11 | knothole | 1 | 82945 | 2 | 1.203 | 68948.5 |
259 | 2024-03-27 05:27:46 | knothole | 1 | 82945 | 2 | 1.330 | 62364.7 |
258 | 2024-03-19 03:40:54 | knothole | 1 | 82945 | 2 | 3.063 | 27079.7 |
257 | 2024-03-17 14:14:55 | knothole | 1 | 82945 | 2 | 1.220 | 67987.7 |
256 | 2024-03-08 04:56:08 | knothole | 2 | 121059 | 6 | 4.640 | 26090.3 |
255 | 2024-03-07 23:35:21 | knothole | 2 | 121059 | 6 | 3.780 | 32026.2 |
254 | 2024-03-07 19:27:18 | knothole | 4 | 161609 | 289 | 14.093 | 11467.3 |
253 | 2024-03-07 10:35:04 | knothole | 1 | 82945 | 2 | 3.186 | 26034.2 |
252 | 2024-03-06 22:09:41 | knothole | 4 | 161609 | 289 | 43.486 | 3716.3 |
251 | 2024-03-06 21:14:43 | knothole | 4 | 161609 | 289 | 13.046 | 12387.6 |
250 | 2024-03-06 01:33:48 | knothole | 3 | 146162 | 32 | 25.983 | 5625.3 |
249 | 2024-03-05 20:05:20 | knothole | 4 | 161609 | 289 | 33.300 | 4853.1 |
248 | 2024-03-05 20:05:22 | knothole | 3 | 146162 | 32 | 26.113 | 5597.3 |
247 | 2024-03-05 20:05:29 | knothole | 2 | 121059 | 6 | 4.216 | 28714.2 |
246 | 2024-03-05 20:00:04 | knothole | 1 | 82945 | 2 | 1.610 | 51518.6 |
245 | 2024-03-03 21:34:40 | knothole | 1 | 82945 | 2 | 2.453 | 33813.7 |
244 | 2024-03-02 10:11:06 | knothole | 2 | 121059 | 6 | 11.953 | 10127.9 |
243 | 2024-03-02 10:11:09 | knothole | 2 | 121059 | 6 | 5.013 | 24149.0 |
242 | 2024-03-02 05:19:52 | knothole | 1 | 82945 | 2 | 1.766 | 46967.7 |
241 | 2024-03-01 00:02:11 | knothole | 3 | 146162 | 32 | 8.186 | 17855.1 |
240 | 2024-03-01 00:02:16 | knothole | 1 | 82945 | 2 | 2.766 | 29987.3 |
239 | 2024-02-29 23:57:28 | knothole | 4 | 161609 | 289 | 13.580 | 11900.5 |
238 | 2024-02-29 23:57:24 | knothole | 2 | 121059 | 6 | 3.593 | 33693.0 |
237 | 2024-02-29 14:18:38 | knothole | 1 | 82945 | 2 | 2.373 | 34953.6 |
236 | 2024-02-28 19:00:39 | knothole | 1 | 82945 | 2 | 1.343 | 61761.0 |
235 | 2024-02-27 22:57:52 | knothole | 1 | 82945 | 2 | 1.530 | 54212.4 |
234 | 2024-02-26 23:23:08 | knothole | 1 | 82945 | 2 | 2.076 | 39954.2 |
233 | 2024-02-26 02:56:33 | knothole | 1 | 82945 | 2 | 3.063 | 27079.7 |
232 | 2024-02-25 07:15:28 | knothole | 1 | 82945 | 2 | 1.920 | 43200.5 |
231 | 2024-02-24 10:58:24 | knothole | 1 | 82945 | 2 | 1.220 | 67987.7 |
230 | 2024-02-23 16:39:40 | knothole | 1 | 82945 | 2 | 3.156 | 26281.7 |
229 | 2024-02-22 13:25:53 | knothole | 1 | 82945 | 2 | 1.500 | 55296.7 |
228 | 2024-02-21 19:01:34 | knothole | 1 | 82945 | 2 | 3.063 | 27079.7 |
227 | 2024-02-20 10:52:27 | knothole | 1 | 82945 | 2 | 1.513 | 54821.5 |
226 | 2024-02-19 13:18:15 | knothole | 1 | 82945 | 2 | 1.956 | 42405.4 |
225 | 2024-02-18 18:52:52 | knothole | 1 | 82945 | 2 | 2.343 | 35401.2 |
224 | 2024-02-14 19:17:42 | knothole | 1 | 82945 | 2 | 1.453 | 57085.3 |
223 | 2024-02-07 12:23:55 | knothole | 1 | 82945 | 2 | 1.263 | 65673.0 |
222 | 2024-02-06 15:21:36 | knothole | 1 | 82945 | 2 | 1.393 | 59544.1 |
221 | 2024-02-06 00:03:26 | knothole | 3 | 146162 | 32 | 10.063 | 14524.7 |
220 | 2024-02-05 13:23:00 | knothole | 1 | 82945 | 2 | 1.360 | 60989.0 |
219 | 2024-02-04 19:57:35 | knothole | 3 | 146162 | 32 | 17.766 | 8227.1 |
218 | 2024-02-04 15:28:54 | knothole | 1 | 82945 | 2 | 3.080 | 26930.2 |
217 | 2024-02-04 12:55:04 | knothole | 4 | 161609 | 289 | 23.580 | 6853.6 |
216 | 2024-02-04 02:54:42 | knothole | 4 | 161609 | 289 | 12.846 | 12580.5 |
215 | 2024-02-03 23:33:19 | knothole | 3 | 146162 | 32 | 6.890 | 21213.6 |
214 | 2024-02-03 03:52:46 | knothole | 4 | 161609 | 289 | 13.533 | 11941.8 |
213 | 2024-02-03 03:52:42 | knothole | 3 | 146162 | 32 | 10.423 | 14023.0 |
212 | 2024-02-03 03:36:14 | knothole | 2 | 121059 | 6 | 3.830 | 31608.1 |
211 | 2024-02-03 03:20:57 | knothole | 1 | 82945 | 2 | 1.313 | 63172.1 |
210 | 2024-01-30 19:00:48 | knothole | 1 | 82945 | 2 | 2.690 | 30834.6 |
209 | 2024-01-29 21:57:20 | knothole | 1 | 82945 | 2 | 1.906 | 43517.8 |
208 | 2024-01-28 17:45:48 | knothole | 1 | 82945 | 2 | 1.360 | 60989.0 |
207 | 2024-01-27 11:00:14 | knothole | 1 | 82945 | 2 | 1.390 | 59672.7 |
206 | 2024-01-26 17:41:51 | knothole | 1 | 82945 | 2 | 1.453 | 57085.3 |
205 | 2024-01-09 06:23:24 | knothole | 1 | 82945 | 2 | 1.483 | 55930.5 |
204 | 2023-12-30 18:47:43 | knothole | 1 | 82945 | 2 | 1.203 | 68948.5 |
203 | 2023-12-13 23:48:21 | knothole | 1 | 82945 | 2 | 2.703 | 30686.3 |
202 | 2023-12-03 14:08:50 | knothole | 1 | 82945 | 2 | 1.486 | 55817.6 |
201 | 2023-11-29 23:00:36 | knothole | 1 | 82945 | 2 | 1.233 | 67270.9 |
200 | 2023-11-27 22:12:24 | knothole | 1 | 82945 | 2 | 2.406 | 34474.2 |
199 | 2023-10-08 07:40:18 | knothole | 1 | 82945 | 2 | 1.250 | 66356.0 |
198 | 2023-09-18 00:57:09 | knothole | 1 | 82945 | 2 | 1.200 | 69120.8 |
197 | 2023-08-20 10:25:41 | knothole | 1 | 82945 | 2 | 1.313 | 63172.1 |
196 | 2023-08-18 04:25:28 | knothole | 1 | 82945 | 2 | 1.186 | 69936.8 |
195 | 2023-08-10 07:49:09 | knothole | 1 | 82945 | 2 | 1.190 | 69701.7 |
194 | 2023-08-08 10:08:48 | knothole | 1 | 82945 | 2 | 1.216 | 68211.3 |
193 | 2023-07-30 19:01:33 | knothole | 1 | 82945 | 2 | 1.346 | 61623.3 |
192 | 2023-07-11 16:41:58 | knothole | 1 | 82945 | 2 | 1.360 | 60989.0 |
191 | 2023-07-10 08:09:30 | knothole | 1 | 82945 | 2 | 1.266 | 65517.4 |
190 | 2023-05-29 11:07:07 | knothole | 1 | 82945 | 2 | 1.190 | 69701.7 |
189 | 2023-01-26 15:24:20 | knothole | 1 | 82945 | 2 | 1.186 | 69936.8 |
188 | 2022-12-18 09:17:11 | knothole | 3 | 146162 | 32 | 6.000 | 24360.3 |
187 | 2022-12-01 02:09:51 | knothole | 1 | 82945 | 2 | 1.186 | 69936.8 |
186 | 2022-11-19 15:28:28 | knothole | 1 | 82945 | 2 | 1.313 | 63172.1 |
185 | 2022-11-16 19:45:17 | knothole | 1 | 82945 | 2 | 1.326 | 62552.8 |
184 | 2022-09-30 18:51:21 | knothole | 1 | 82945 | 2 | 1.453 | 57085.3 |
183 | 2022-09-20 16:27:40 | knothole | 1 | 82945 | 2 | 1.236 | 67107.6 |
182 | 2022-07-26 04:46:30 | knothole | 1 | 82945 | 2 | 1.406 | 58993.6 |