History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knotters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
340 | 2024-04-22 05:51:58 | knotters | 3 | 146162 | 269 | 10.453 | 13982.8 |
339 | 2024-04-21 04:21:39 | knotters | 3 | 146162 | 269 | 25.580 | 5713.9 |
338 | 2024-04-20 22:13:20 | knotters | 3 | 146162 | 269 | 22.720 | 6433.2 |
337 | 2024-04-18 23:34:12 | knotters | 3 | 146162 | 269 | 24.126 | 6058.3 |
336 | 2024-04-18 23:34:12 | knotters | 2 | 121059 | 29 | 12.280 | 9858.2 |
335 | 2024-04-18 22:54:29 | knotters | 1 | 82945 | 3 | 1.360 | 60989.0 |
334 | 2024-04-03 21:07:14 | knotters | 2 | 121059 | 29 | 11.330 | 10684.8 |
333 | 2024-04-03 21:07:06 | knotters | 1 | 82945 | 3 | 1.593 | 52068.4 |
332 | 2024-03-31 17:54:30 | knotters | 1 | 82945 | 3 | 2.810 | 29517.8 |
331 | 2024-03-29 05:48:56 | knotters | 1 | 82945 | 3 | 2.186 | 37943.7 |
330 | 2024-03-08 23:23:58 | knotters | 3 | 146162 | 269 | 12.406 | 11781.6 |
329 | 2024-03-07 06:54:52 | knotters | 3 | 146162 | 269 | 14.533 | 10057.2 |
328 | 2024-03-05 23:33:00 | knotters | 3 | 146162 | 269 | 15.763 | 9272.5 |
327 | 2024-03-05 01:43:43 | knotters | 3 | 146162 | 269 | 23.156 | 6312.1 |
326 | 2024-03-05 01:43:43 | knotters | 2 | 121059 | 29 | 8.263 | 14650.7 |
325 | 2024-03-05 00:09:56 | knotters | 1 | 82945 | 3 | 1.500 | 55296.7 |
324 | 2024-03-04 12:16:32 | knotters | 1 | 82945 | 3 | 4.860 | 17066.9 |
323 | 2024-02-28 05:18:37 | knotters | 1 | 82945 | 3 | 2.986 | 27778.0 |
322 | 2024-02-19 16:47:41 | knotters | 2 | 121059 | 29 | 3.860 | 31362.4 |
321 | 2024-02-19 16:47:14 | knotters | 3 | 146162 | 269 | 8.656 | 16885.6 |
320 | 2024-02-17 17:33:29 | knotters | 3 | 146162 | 269 | 11.373 | 12851.7 |
319 | 2024-02-15 20:06:42 | knotters | 3 | 146162 | 269 | 12.436 | 11753.1 |
318 | 2024-02-15 20:06:43 | knotters | 2 | 121059 | 29 | 3.873 | 31257.2 |
317 | 2024-02-02 01:58:00 | knotters | 2 | 121059 | 29 | 3.046 | 39743.6 |
316 | 2024-02-02 01:57:48 | knotters | 3 | 146162 | 269 | 7.923 | 18447.8 |
315 | 2024-02-02 01:57:44 | knotters | 1 | 82945 | 3 | 1.376 | 60279.8 |
314 | 2024-02-01 21:32:48 | knotters | 1 | 82945 | 3 | 1.280 | 64800.8 |
313 | 2024-01-31 01:43:58 | knotters | 1 | 82945 | 3 | 1.206 | 68776.9 |
312 | 2024-01-21 13:32:17 | knotters | 2 | 121059 | 29 | 2.966 | 40815.6 |
311 | 2024-01-02 08:18:29 | knotters | 1 | 82945 | 3 | 1.220 | 67987.7 |
310 | 2023-12-19 12:04:12 | knotters | 1 | 82945 | 3 | 1.656 | 50087.6 |
309 | 2023-11-25 11:15:19 | knotters | 1 | 82945 | 3 | 1.406 | 58993.6 |
308 | 2023-11-11 18:34:50 | knotters | 1 | 82945 | 3 | 1.233 | 67270.9 |
307 | 2023-11-02 06:06:23 | knotters | 2 | 121059 | 29 | 3.813 | 31749.0 |
306 | 2023-10-25 12:03:40 | knotters | 1 | 82945 | 3 | 1.296 | 64000.8 |
305 | 2023-10-21 11:29:14 | knotters | 1 | 82945 | 3 | 1.296 | 64000.8 |
304 | 2023-09-10 18:08:03 | knotters | 1 | 82945 | 3 | 1.250 | 66356.0 |
303 | 2023-08-07 23:18:06 | knotters | 2 | 121059 | 29 | 3.453 | 35059.1 |
302 | 2023-06-23 12:08:40 | knotters | 1 | 82945 | 3 | 1.186 | 69936.8 |
301 | 2023-06-20 09:38:09 | knotters | 1 | 82945 | 3 | 1.296 | 64000.8 |
300 | 2023-04-16 02:08:21 | knotters | 2 | 121059 | 29 | 2.966 | 40815.6 |
299 | 2023-04-03 16:34:24 | knotters | 1 | 82945 | 3 | 1.420 | 58412.0 |
298 | 2023-03-01 06:57:47 | knotters | 1 | 82945 | 3 | 1.300 | 63803.8 |
297 | 2023-01-21 08:00:25 | knotters | 2 | 121059 | 29 | 3.000 | 40353.0 |
296 | 2023-01-15 21:56:10 | knotters | 1 | 82945 | 3 | 1.236 | 67107.6 |
295 | 2022-12-25 11:28:29 | knotters | 1 | 82945 | 3 | 1.186 | 69936.8 |
294 | 2022-11-18 18:07:27 | knotters | 1 | 82945 | 3 | 1.373 | 60411.5 |
293 | 2022-11-06 07:56:12 | knotters | 1 | 82945 | 3 | 1.390 | 59672.7 |
292 | 2022-11-05 10:51:50 | knotters | 1 | 82945 | 3 | 1.326 | 62552.8 |
291 | 2022-11-01 22:30:27 | knotters | 1 | 82945 | 3 | 1.330 | 62364.7 |
290 | 2022-11-01 08:28:11 | knotters | 2 | 121059 | 29 | 2.986 | 40542.2 |
289 | 2022-07-02 05:26:26 | knotters | 1 | 82945 | 3 | 1.326 | 62552.8 |
288 | 2022-06-26 12:27:50 | knotters | 1 | 82945 | 3 | 1.376 | 60279.8 |
287 | 2022-05-23 08:03:48 | knotters | 2 | 121059 | 29 | 3.173 | 38152.9 |
286 | 2022-03-01 11:09:22 | knotters | 1 | 82945 | 3 | 1.466 | 56579.1 |
285 | 2022-02-26 04:25:28 | knotters | 1 | 82945 | 3 | 1.533 | 54106.3 |
284 | 2022-02-22 18:26:52 | knotters | 1 | 82945 | 3 | 1.266 | 65517.4 |
283 | 2021-12-16 06:41:06 | knotters | 1 | 82945 | 3 | 1.356 | 61168.9 |
282 | 2021-11-08 20:19:32 | knotters | 1 | 82945 | 3 | 1.296 | 64000.8 |
281 | 2021-11-06 18:24:54 | knotters | 1 | 82945 | 3 | 1.346 | 61623.3 |
280 | 2021-11-01 04:20:17 | knotters | 1 | 82945 | 3 | 1.296 | 64000.8 |
279 | 2021-10-28 18:59:26 | knotters | 1 | 82945 | 3 | 1.390 | 59672.7 |
278 | 2021-07-22 08:25:39 | knotters | 1 | 82945 | 3 | 1.266 | 65517.4 |
277 | 2021-04-19 14:42:57 | knotters | 1 | 82945 | 3 | 1.516 | 54713.1 |
276 | 2020-12-29 11:47:04 | knotters | 1 | 82945 | 3 | 1.423 | 58288.8 |
275 | 2020-11-14 06:09:32 | knotters | 1 | 82945 | 3 | 1.390 | 59672.7 |
274 | 2020-10-21 17:26:17 | knotters | 1 | 82945 | 3 | 1.220 | 67987.7 |
273 | 2020-10-21 01:30:34 | knotters | 1 | 82945 | 3 | 1.220 | 67987.7 |
272 | 2020-10-08 19:43:05 | knotters | 1 | 82945 | 3 | 1.313 | 63172.1 |
271 | 2020-09-26 03:33:40 | knotters | 1 | 82945 | 3 | 1.220 | 67987.7 |
270 | 2020-09-17 07:42:58 | knotters | 1 | 82945 | 3 | 1.360 | 60989.0 |
269 | 2020-08-28 18:29:57 | knotters | 1 | 82945 | 3 | 1.250 | 66356.0 |
268 | 2020-08-07 20:44:03 | knotters | 1 | 82945 | 3 | 1.453 | 57085.3 |
267 | 2020-08-04 13:53:33 | knotters | 1 | 82945 | 3 | 1.280 | 64800.8 |
266 | 2020-08-01 12:51:24 | knotters | 1 | 82945 | 3 | 1.423 | 58288.8 |
265 | 2020-08-01 02:40:59 | knotters | 1 | 82945 | 3 | 1.250 | 66356.0 |
264 | 2020-06-14 08:32:28 | knotters | 1 | 82945 | 3 | 1.283 | 64649.3 |
263 | 2020-05-07 03:33:52 | knotters | 1 | 82945 | 3 | 1.266 | 65517.4 |
262 | 2020-03-22 11:55:12 | knotters | 1 | 82945 | 3 | 1.376 | 60279.8 |
261 | 2020-03-09 18:21:05 | knotters | 1 | 82945 | 3 | 1.200 | 69120.8 |
260 | 2020-02-22 16:57:34 | knotters | 1 | 82945 | 3 | 1.346 | 61623.3 |
259 | 2020-02-22 15:36:04 | knotters | 1 | 82945 | 3 | 1.390 | 59672.7 |
258 | 2020-02-18 23:29:10 | knotters | 1 | 82945 | 3 | 1.420 | 58412.0 |
257 | 2020-02-17 07:00:22 | knotters | 1 | 82945 | 3 | 1.263 | 65673.0 |
256 | 2020-02-14 19:37:28 | knotters | 1 | 82945 | 3 | 1.500 | 55296.7 |
255 | 2020-02-14 05:29:22 | knotters | 1 | 82945 | 3 | 3.106 | 26704.8 |
254 | 2020-02-11 02:43:39 | knotters | 1 | 82945 | 3 | 1.423 | 58288.8 |
253 | 2020-02-10 05:59:38 | knotters | 1 | 82945 | 3 | 1.440 | 57600.7 |
252 | 2020-02-04 17:25:52 | knotters | 1 | 82945 | 3 | 2.690 | 30834.6 |
251 | 2020-02-03 02:41:52 | knotters | 1 | 82945 | 3 | 1.546 | 53651.4 |
250 | 2020-01-29 01:30:54 | knotters | 1 | 82945 | 3 | 1.406 | 58993.6 |
249 | 2020-01-22 18:03:15 | knotters | 1 | 82945 | 3 | 4.436 | 18698.2 |
248 | 2020-01-20 20:02:10 | knotters | 1 | 82945 | 3 | 2.843 | 29175.2 |
247 | 2020-01-16 03:14:17 | knotters | 1 | 82945 | 3 | 1.206 | 68776.9 |
246 | 2020-01-07 10:10:35 | knotters | 1 | 82945 | 3 | 2.186 | 37943.7 |
245 | 2020-01-03 05:33:20 | knotters | 1 | 82945 | 3 | 4.250 | 19516.5 |
244 | 2019-12-29 21:50:43 | knotters | 1 | 82945 | 3 | 1.266 | 65517.4 |
243 | 2019-12-29 20:12:40 | knotters | 1 | 82945 | 3 | 1.423 | 58288.8 |
242 | 2019-12-06 19:23:18 | knotters | 1 | 82945 | 3 | 1.220 | 67987.7 |
241 | 2019-10-29 09:44:07 | knotters | 1 | 82945 | 3 | 1.203 | 68948.5 |