History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"channels"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
354 | 2024-05-01 12:34:38 | channels | 3 | 146162 | 233 | 16.766 | 8717.8 |
353 | 2024-04-30 13:51:29 | channels | 2 | 121059 | 28 | 4.216 | 28714.2 |
352 | 2024-04-30 13:51:17 | channels | 3 | 146162 | 233 | 7.986 | 18302.3 |
351 | 2024-04-29 05:22:07 | channels | 2 | 121059 | 28 | 3.890 | 31120.6 |
350 | 2024-04-29 05:22:00 | channels | 2 | 121059 | 28 | 7.830 | 15460.9 |
349 | 2024-04-29 05:21:59 | channels | 1 | 82945 | 6 | 2.033 | 40799.3 |
348 | 2024-04-29 05:21:45 | channels | 3 | 146162 | 233 | 9.393 | 15560.7 |
347 | 2024-04-29 02:50:00 | channels | 3 | 146162 | 233 | 18.016 | 8112.9 |
346 | 2024-04-28 06:34:34 | channels | 3 | 146162 | 233 | 8.860 | 16496.8 |
345 | 2024-04-16 04:34:08 | channels | 1 | 82945 | 6 | 1.470 | 56425.2 |
344 | 2024-04-03 11:30:43 | channels | 3 | 146162 | 233 | 13.686 | 10679.7 |
343 | 2024-04-02 01:21:09 | channels | 2 | 121059 | 28 | 3.546 | 34139.6 |
342 | 2024-04-01 05:47:02 | channels | 2 | 121059 | 28 | 6.033 | 20066.1 |
341 | 2024-04-01 02:26:34 | channels | 3 | 146162 | 233 | 20.310 | 7196.6 |
340 | 2024-03-30 04:02:01 | channels | 3 | 146162 | 233 | 11.156 | 13101.6 |
339 | 2024-03-30 04:01:25 | channels | 2 | 121059 | 28 | 10.406 | 11633.6 |
338 | 2024-03-30 02:29:25 | channels | 1 | 82945 | 6 | 2.360 | 35146.2 |
337 | 2024-03-29 16:14:38 | channels | 3 | 146162 | 233 | 9.156 | 15963.5 |
336 | 2024-03-29 16:14:37 | channels | 2 | 121059 | 28 | 4.576 | 26455.2 |
335 | 2024-03-29 05:49:45 | channels | 1 | 82945 | 6 | 2.030 | 40859.6 |
334 | 2024-03-29 05:49:24 | channels | 2 | 121059 | 28 | 12.330 | 9818.2 |
333 | 2024-03-29 00:19:48 | channels | 3 | 146162 | 233 | 20.373 | 7174.3 |
332 | 2024-03-28 06:53:54 | channels | 1 | 82945 | 6 | 1.330 | 62364.7 |
331 | 2024-03-28 06:53:17 | channels | 3 | 146162 | 233 | 7.876 | 18557.9 |
330 | 2024-03-28 06:53:18 | channels | 2 | 121059 | 28 | 4.000 | 30264.8 |
329 | 2024-03-28 06:53:13 | channels | 1 | 82945 | 6 | 1.376 | 60279.8 |
328 | 2024-03-16 20:58:38 | channels | 1 | 82945 | 6 | 4.703 | 17636.6 |
327 | 2024-02-28 20:41:47 | channels | 1 | 82945 | 6 | 3.266 | 25396.5 |
326 | 2024-02-25 23:06:46 | channels | 1 | 82945 | 6 | 4.906 | 16906.8 |
325 | 2024-02-07 17:45:14 | channels | 2 | 121059 | 28 | 4.390 | 27576.1 |
324 | 2024-02-06 21:55:26 | channels | 3 | 146162 | 233 | 8.236 | 17746.7 |
323 | 2024-02-06 10:18:09 | channels | 2 | 121059 | 28 | 3.330 | 36354.1 |
322 | 2024-02-06 10:17:49 | channels | 3 | 146162 | 233 | 6.766 | 21602.4 |
321 | 2024-01-26 12:23:29 | channels | 1 | 82945 | 6 | 1.500 | 55296.7 |
320 | 2024-01-25 11:21:43 | channels | 1 | 82945 | 6 | 1.283 | 64649.3 |
319 | 2024-01-23 04:40:25 | channels | 3 | 146162 | 233 | 8.610 | 16975.8 |
318 | 2024-01-19 08:25:49 | channels | 3 | 146162 | 233 | 6.830 | 21400.0 |
317 | 2024-01-19 08:25:44 | channels | 2 | 121059 | 28 | 3.626 | 33386.4 |
316 | 2024-01-10 10:35:51 | channels | 1 | 82945 | 6 | 1.393 | 59544.1 |
315 | 2024-01-03 20:58:08 | channels | 3 | 146162 | 233 | 8.266 | 17682.3 |
314 | 2023-12-06 03:42:47 | channels | 2 | 121059 | 28 | 4.126 | 29340.5 |
313 | 2023-11-29 04:54:34 | channels | 1 | 82945 | 6 | 1.406 | 58993.6 |
312 | 2023-11-24 23:51:55 | channels | 3 | 146162 | 233 | 7.796 | 18748.3 |
311 | 2023-11-24 23:51:53 | channels | 2 | 121059 | 28 | 3.750 | 32282.4 |
310 | 2023-11-21 08:26:26 | channels | 1 | 82945 | 6 | 1.313 | 63172.1 |
309 | 2023-11-17 11:36:49 | channels | 1 | 82945 | 6 | 2.950 | 28116.9 |
308 | 2023-10-31 14:52:20 | channels | 1 | 82945 | 6 | 1.266 | 65517.4 |
307 | 2023-10-29 20:04:13 | channels | 1 | 82945 | 6 | 1.656 | 50087.6 |
306 | 2023-10-27 08:42:32 | channels | 1 | 82945 | 6 | 1.360 | 60989.0 |
305 | 2023-10-16 19:12:07 | channels | 1 | 82945 | 6 | 1.530 | 54212.4 |
304 | 2023-10-10 12:39:06 | channels | 1 | 82945 | 6 | 1.373 | 60411.5 |
303 | 2023-10-08 04:43:02 | channels | 3 | 146162 | 233 | 7.440 | 19645.4 |
302 | 2023-09-29 16:00:07 | channels | 1 | 82945 | 6 | 1.330 | 62364.7 |
301 | 2023-09-18 22:11:22 | channels | 1 | 82945 | 6 | 1.436 | 57761.1 |
300 | 2023-09-07 12:46:47 | channels | 1 | 82945 | 6 | 1.390 | 59672.7 |
299 | 2023-09-04 13:25:48 | channels | 2 | 121059 | 28 | 3.296 | 36729.1 |
298 | 2023-07-18 20:22:45 | channels | 3 | 146162 | 233 | 7.703 | 18974.7 |
297 | 2023-06-20 04:21:16 | channels | 1 | 82945 | 6 | 1.266 | 65517.4 |
296 | 2023-06-11 22:48:50 | channels | 1 | 82945 | 6 | 1.233 | 67270.9 |
295 | 2023-05-22 05:10:18 | channels | 2 | 121059 | 28 | 3.563 | 33976.7 |
294 | 2023-04-01 09:24:41 | channels | 3 | 146162 | 233 | 6.190 | 23612.6 |
293 | 2023-03-31 10:09:28 | channels | 1 | 82945 | 6 | 1.296 | 64000.8 |
292 | 2023-03-02 10:37:38 | channels | 2 | 121059 | 28 | 3.140 | 38553.8 |
291 | 2023-03-01 06:07:11 | channels | 1 | 82945 | 6 | 2.843 | 29175.2 |
290 | 2023-01-13 14:42:24 | channels | 1 | 82945 | 6 | 1.250 | 66356.0 |
289 | 2022-12-28 16:41:16 | channels | 3 | 146162 | 233 | 12.093 | 12086.5 |
288 | 2022-12-25 10:00:24 | channels | 3 | 146162 | 233 | 7.046 | 20744.0 |
287 | 2022-12-08 20:24:45 | channels | 2 | 121059 | 28 | 3.110 | 38925.7 |
286 | 2022-11-08 20:30:37 | channels | 1 | 82945 | 6 | 1.280 | 64800.8 |
285 | 2022-11-05 00:20:15 | channels | 3 | 146162 | 233 | 6.233 | 23449.7 |
284 | 2022-11-03 11:09:44 | channels | 1 | 82945 | 6 | 1.266 | 65517.4 |
283 | 2022-09-29 16:32:35 | channels | 3 | 146162 | 233 | 6.360 | 22981.4 |
282 | 2022-08-23 06:30:28 | channels | 3 | 146162 | 233 | 7.126 | 20511.1 |
281 | 2022-08-20 20:41:09 | channels | 3 | 146162 | 233 | 6.453 | 22650.2 |
280 | 2022-07-23 22:19:40 | channels | 2 | 121059 | 28 | 3.873 | 31257.2 |
279 | 2022-07-19 13:02:17 | channels | 1 | 82945 | 6 | 1.266 | 65517.4 |
278 | 2022-06-22 22:44:40 | channels | 1 | 82945 | 6 | 1.280 | 64800.8 |
277 | 2022-03-22 01:10:04 | channels | 1 | 82945 | 6 | 1.733 | 47862.1 |
276 | 2022-03-18 14:39:51 | channels | 1 | 82945 | 6 | 1.266 | 65517.4 |
275 | 2022-02-28 04:04:03 | channels | 1 | 82945 | 6 | 1.313 | 63172.1 |
274 | 2022-02-26 02:26:48 | channels | 1 | 82945 | 6 | 1.330 | 62364.7 |
273 | 2021-12-12 22:38:36 | channels | 1 | 82945 | 6 | 1.436 | 57761.1 |
272 | 2021-12-08 03:24:15 | channels | 1 | 82945 | 6 | 1.406 | 58993.6 |
271 | 2021-10-20 03:37:06 | channels | 1 | 82945 | 6 | 1.266 | 65517.4 |
270 | 2021-09-16 13:49:30 | channels | 1 | 82945 | 6 | 1.390 | 59672.7 |
269 | 2021-09-14 11:15:58 | channels | 1 | 82945 | 6 | 1.406 | 58993.6 |
268 | 2021-08-31 18:00:23 | channels | 1 | 82945 | 6 | 1.296 | 64000.8 |
267 | 2021-08-27 20:02:25 | channels | 1 | 82945 | 6 | 1.263 | 65673.0 |
266 | 2021-05-30 22:23:51 | channels | 1 | 82945 | 6 | 1.516 | 54713.1 |
265 | 2021-05-27 17:10:35 | channels | 1 | 82945 | 6 | 1.470 | 56425.2 |
264 | 2021-02-24 12:20:40 | channels | 1 | 82945 | 6 | 1.466 | 56579.1 |
263 | 2021-02-22 10:56:05 | channels | 1 | 82945 | 6 | 2.783 | 29804.2 |
262 | 2020-11-19 10:46:35 | channels | 1 | 82945 | 6 | 1.390 | 59672.7 |
261 | 2020-11-06 19:38:00 | channels | 1 | 82945 | 6 | 1.440 | 57600.7 |
260 | 2020-11-05 17:27:19 | channels | 1 | 82945 | 6 | 1.360 | 60989.0 |
259 | 2020-11-03 19:14:50 | channels | 1 | 82945 | 6 | 1.640 | 50576.2 |
258 | 2020-10-28 13:35:18 | channels | 1 | 82945 | 6 | 1.280 | 64800.8 |
257 | 2020-10-16 20:41:59 | channels | 1 | 82945 | 6 | 1.283 | 64649.3 |
256 | 2020-08-16 04:36:11 | channels | 1 | 82945 | 6 | 1.326 | 62552.8 |
255 | 2020-07-27 02:39:44 | channels | 1 | 82945 | 6 | 1.343 | 61761.0 |