History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knack"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
421 | 2024-04-23 19:10:37 | knack | 1 | 28756 | 5 | 0.670 | 42919.4 |
420 | 2024-04-03 03:15:20 | knack | 1 | 28756 | 5 | 1.060 | 27128.3 |
419 | 2024-03-31 03:47:56 | knack | 1 | 28756 | 5 | 0.813 | 35370.2 |
418 | 2024-03-29 02:20:50 | knack | 1 | 28756 | 5 | 0.533 | 53951.2 |
417 | 2024-03-14 12:32:52 | knack | 1 | 28756 | 5 | 0.466 | 61708.2 |
416 | 2024-03-05 17:59:03 | knack | 3 | 83667 | 605 | 12.703 | 6586.4 |
415 | 2024-03-05 02:31:15 | knack | 3 | 83667 | 605 | 9.703 | 8622.8 |
414 | 2024-03-04 20:48:31 | knack | 2 | 53800 | 59 | 3.046 | 17662.5 |
413 | 2024-03-04 20:48:29 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
412 | 2024-03-04 20:48:12 | knack | 3 | 83667 | 605 | 4.390 | 19058.5 |
411 | 2024-03-04 04:20:49 | knack | 2 | 53800 | 59 | 2.096 | 25667.9 |
410 | 2024-03-04 04:20:09 | knack | 3 | 83667 | 605 | 9.000 | 9296.3 |
409 | 2024-03-04 03:20:56 | knack | 3 | 83667 | 605 | 4.373 | 19132.6 |
408 | 2024-03-04 03:20:54 | knack | 2 | 53800 | 59 | 1.920 | 28020.8 |
407 | 2024-03-04 00:59:43 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
406 | 2024-02-27 20:15:06 | knack | 1 | 28756 | 5 | 1.063 | 27051.7 |
405 | 2024-02-07 17:06:41 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
404 | 2024-02-02 21:28:43 | knack | 1 | 28756 | 5 | 1.013 | 28387.0 |
403 | 2024-01-28 23:50:07 | knack | 1 | 28756 | 5 | 0.406 | 70827.6 |
402 | 2024-01-28 19:15:37 | knack | 1 | 28756 | 5 | 0.450 | 63902.2 |
401 | 2024-01-15 03:36:39 | knack | 3 | 83667 | 605 | 3.513 | 23816.4 |
400 | 2023-12-08 11:04:28 | knack | 1 | 28756 | 5 | 0.500 | 57512.0 |
399 | 2023-12-08 11:04:27 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
398 | 2023-12-04 04:37:31 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
397 | 2023-12-01 07:14:48 | knack | 2 | 53800 | 59 | 2.626 | 20487.4 |
396 | 2023-12-01 07:14:43 | knack | 3 | 83667 | 605 | 3.236 | 25855.1 |
395 | 2023-11-30 08:27:30 | knack | 1 | 28756 | 5 | 0.423 | 67981.1 |
394 | 2023-11-15 14:30:13 | knack | 3 | 83667 | 605 | 3.920 | 21343.6 |
393 | 2023-11-15 14:30:12 | knack | 2 | 53800 | 59 | 1.640 | 32804.9 |
392 | 2023-11-10 02:52:55 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
391 | 2023-11-08 16:41:17 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
390 | 2023-11-04 09:59:29 | knack | 1 | 28756 | 5 | 0.453 | 63479.0 |
389 | 2023-11-01 04:37:24 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
388 | 2023-10-18 09:32:29 | knack | 1 | 28756 | 5 | 0.453 | 63479.0 |
387 | 2023-10-12 01:05:51 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
386 | 2023-10-06 07:58:28 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
385 | 2023-09-28 23:41:29 | knack | 1 | 28756 | 5 | 0.406 | 70827.6 |
384 | 2023-09-24 00:21:03 | knack | 1 | 28756 | 5 | 0.453 | 63479.0 |
383 | 2023-09-15 19:20:30 | knack | 1 | 28756 | 5 | 0.423 | 67981.1 |
382 | 2023-07-31 12:00:19 | knack | 1 | 28756 | 5 | 0.813 | 35370.2 |
381 | 2023-06-23 00:44:01 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
380 | 2023-04-17 04:54:03 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
379 | 2023-04-12 01:48:31 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
378 | 2023-04-04 04:51:01 | knack | 1 | 28756 | 5 | 0.466 | 61708.2 |
377 | 2023-03-19 16:32:10 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
376 | 2023-01-19 19:10:24 | knack | 1 | 28756 | 5 | 0.406 | 70827.6 |
375 | 2022-12-26 19:07:27 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
374 | 2022-11-15 19:54:42 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
373 | 2022-09-19 21:18:33 | knack | 1 | 28756 | 5 | 0.453 | 63479.0 |
372 | 2022-09-10 20:46:35 | knack | 1 | 28756 | 5 | 0.423 | 67981.1 |
371 | 2022-08-31 21:51:55 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
370 | 2022-08-29 21:23:10 | knack | 1 | 28756 | 5 | 0.423 | 67981.1 |
369 | 2022-08-14 19:42:44 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
368 | 2022-07-29 03:54:21 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
367 | 2022-07-05 16:24:32 | knack | 1 | 28756 | 5 | 0.453 | 63479.0 |
366 | 2022-07-03 09:57:47 | knack | 1 | 28756 | 5 | 0.423 | 67981.1 |
365 | 2022-04-22 06:19:28 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
364 | 2022-02-27 16:53:32 | knack | 1 | 28756 | 5 | 0.500 | 57512.0 |
363 | 2022-02-27 16:12:13 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
362 | 2022-02-27 13:08:32 | knack | 1 | 28756 | 5 | 0.423 | 67981.1 |
361 | 2021-12-30 15:16:53 | knack | 1 | 28756 | 5 | 0.500 | 57512.0 |
360 | 2021-12-18 17:32:05 | knack | 1 | 28756 | 5 | 0.436 | 65954.1 |
359 | 2021-12-09 08:59:14 | knack | 1 | 28756 | 5 | 0.466 | 61708.2 |
358 | 2021-10-25 20:21:19 | knack | 1 | 28756 | 5 | 0.550 | 52283.6 |
357 | 2021-09-20 09:26:54 | knack | 1 | 28756 | 5 | 0.423 | 67981.1 |
356 | 2021-09-16 04:12:06 | knack | 1 | 28756 | 5 | 0.436 | 65954.1 |
355 | 2021-08-29 12:19:36 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
354 | 2021-06-17 05:46:40 | knack | 1 | 28756 | 5 | 0.486 | 59168.7 |
353 | 2021-06-13 18:45:06 | knack | 1 | 28756 | 5 | 0.466 | 61708.2 |
352 | 2021-05-21 23:50:01 | knack | 1 | 28756 | 5 | 0.436 | 65954.1 |
351 | 2021-04-22 18:09:05 | knack | 1 | 28756 | 5 | 0.686 | 41918.4 |
350 | 2021-03-25 00:22:53 | knack | 1 | 28756 | 5 | 0.423 | 67981.1 |
349 | 2021-03-10 21:57:49 | knack | 1 | 28756 | 5 | 0.406 | 70827.6 |
348 | 2021-01-07 18:42:38 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
347 | 2020-12-07 15:12:15 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
346 | 2020-10-22 22:30:35 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
345 | 2020-10-18 11:54:35 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
344 | 2020-09-26 23:09:10 | knack | 1 | 28756 | 5 | 0.420 | 68466.7 |
343 | 2020-09-01 05:46:49 | knack | 1 | 28756 | 5 | 0.436 | 65954.1 |
342 | 2020-05-30 12:30:27 | knack | 1 | 28756 | 5 | 0.546 | 52666.7 |
341 | 2020-03-26 08:04:30 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
340 | 2020-03-25 22:28:58 | knack | 1 | 28756 | 5 | 0.453 | 63479.0 |
339 | 2020-03-24 00:38:42 | knack | 1 | 28756 | 5 | 1.563 | 18398.0 |
338 | 2020-03-22 23:42:44 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
337 | 2020-03-21 16:16:43 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
336 | 2020-03-20 19:50:44 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
335 | 2020-03-18 05:18:15 | knack | 1 | 28756 | 5 | 0.483 | 59536.2 |
334 | 2020-02-27 16:54:55 | knack | 1 | 28756 | 5 | 1.670 | 17219.2 |
333 | 2020-02-27 05:18:04 | knack | 1 | 28756 | 5 | 0.533 | 53951.2 |
332 | 2020-02-23 07:52:28 | knack | 1 | 28756 | 5 | 0.736 | 39070.7 |
331 | 2020-02-13 09:33:57 | knack | 1 | 28756 | 5 | 0.403 | 71354.8 |
330 | 2020-02-13 01:15:02 | knack | 1 | 28756 | 5 | 0.530 | 54256.6 |
329 | 2020-02-04 19:09:58 | knack | 1 | 28756 | 5 | 1.110 | 25906.3 |
328 | 2020-02-02 20:02:23 | knack | 1 | 28756 | 5 | 1.016 | 28303.1 |
327 | 2020-01-30 20:35:29 | knack | 1 | 28756 | 5 | 0.500 | 57512.0 |
326 | 2020-01-30 17:36:07 | knack | 1 | 28756 | 5 | 0.470 | 61183.0 |
325 | 2020-01-26 22:27:10 | knack | 1 | 28756 | 5 | 0.533 | 53951.2 |
324 | 2020-01-21 17:05:53 | knack | 1 | 28756 | 5 | 0.516 | 55728.7 |
323 | 2020-01-13 14:01:50 | knack | 1 | 28756 | 5 | 1.093 | 26309.2 |
322 | 2020-01-11 18:53:29 | knack | 1 | 28756 | 5 | 0.513 | 56054.6 |