History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knits"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
488 | 2024-04-03 04:40:42 | knits | 1 | 28756 | 7 | 1.673 | 17188.3 |
487 | 2024-04-01 17:35:53 | knits | 1 | 28756 | 7 | 1.626 | 17685.1 |
486 | 2024-03-31 14:59:16 | knits | 1 | 28756 | 7 | 0.500 | 57512.0 |
485 | 2024-03-28 20:14:04 | knits | 2 | 53800 | 135 | 1.576 | 34137.1 |
484 | 2024-03-28 20:13:57 | knits | 1 | 28756 | 7 | 0.953 | 30174.2 |
483 | 2024-03-28 20:13:46 | knits | 2 | 53800 | 135 | 1.436 | 37465.2 |
482 | 2024-03-28 20:13:42 | knits | 1 | 28756 | 7 | 0.516 | 55728.7 |
481 | 2024-03-18 23:54:34 | knits | 1 | 28756 | 7 | 1.483 | 19390.4 |
480 | 2024-03-04 03:53:08 | knits | 2 | 53800 | 135 | 1.593 | 33772.8 |
479 | 2024-03-04 00:44:10 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
478 | 2024-03-02 14:19:58 | knits | 1 | 28756 | 7 | 1.610 | 17860.9 |
477 | 2024-03-01 11:36:50 | knits | 1 | 28756 | 7 | 0.423 | 67981.1 |
476 | 2024-02-26 13:25:31 | knits | 2 | 53800 | 135 | 1.546 | 34799.5 |
475 | 2024-02-26 13:25:29 | knits | 1 | 28756 | 7 | 0.486 | 59168.7 |
474 | 2024-02-03 00:37:47 | knits | 1 | 28756 | 7 | 0.500 | 57512.0 |
473 | 2024-02-02 06:13:24 | knits | 2 | 53800 | 135 | 1.313 | 40974.9 |
472 | 2024-01-29 05:56:16 | knits | 1 | 28756 | 7 | 0.486 | 59168.7 |
471 | 2024-01-27 12:34:18 | knits | 1 | 28756 | 7 | 1.000 | 28756.0 |
470 | 2024-01-15 16:53:50 | knits | 1 | 28756 | 7 | 0.483 | 59536.2 |
469 | 2024-01-01 05:12:12 | knits | 1 | 28756 | 7 | 0.483 | 59536.2 |
468 | 2023-12-07 12:08:35 | knits | 2 | 53800 | 135 | 1.466 | 36698.5 |
467 | 2023-11-28 18:11:04 | knits | 2 | 53800 | 135 | 1.296 | 41512.3 |
466 | 2023-11-15 04:40:23 | knits | 2 | 53800 | 135 | 1.576 | 34137.1 |
465 | 2023-11-10 21:26:04 | knits | 1 | 28756 | 7 | 0.516 | 55728.7 |
464 | 2023-11-10 07:13:55 | knits | 2 | 53800 | 135 | 1.546 | 34799.5 |
463 | 2023-11-08 15:33:26 | knits | 1 | 28756 | 7 | 0.453 | 63479.0 |
462 | 2023-10-27 15:19:56 | knits | 1 | 28756 | 7 | 0.436 | 65954.1 |
461 | 2023-10-23 23:15:26 | knits | 1 | 28756 | 7 | 0.466 | 61708.2 |
460 | 2023-10-21 08:36:58 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
459 | 2023-10-17 20:05:45 | knits | 1 | 28756 | 7 | 0.470 | 61183.0 |
458 | 2023-10-13 07:28:20 | knits | 1 | 28756 | 7 | 0.516 | 55728.7 |
457 | 2023-10-04 11:07:58 | knits | 1 | 28756 | 7 | 0.453 | 63479.0 |
456 | 2023-10-04 00:52:17 | knits | 1 | 28756 | 7 | 0.420 | 68466.7 |
455 | 2023-09-30 20:38:38 | knits | 1 | 28756 | 7 | 0.483 | 59536.2 |
454 | 2023-09-26 03:14:08 | knits | 2 | 53800 | 135 | 1.483 | 36277.8 |
453 | 2023-09-19 14:59:37 | knits | 1 | 28756 | 7 | 0.500 | 57512.0 |
452 | 2023-09-12 10:18:57 | knits | 1 | 28756 | 7 | 0.470 | 61183.0 |
451 | 2023-08-19 19:52:53 | knits | 1 | 28756 | 7 | 0.440 | 65354.5 |
450 | 2023-06-17 02:54:21 | knits | 1 | 28756 | 7 | 0.420 | 68466.7 |
449 | 2023-05-22 02:58:54 | knits | 1 | 28756 | 7 | 0.453 | 63479.0 |
448 | 2023-03-17 12:34:55 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
447 | 2023-03-01 09:44:12 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
446 | 2023-01-05 10:02:54 | knits | 1 | 28756 | 7 | 0.423 | 67981.1 |
445 | 2022-11-12 13:05:50 | knits | 1 | 28756 | 7 | 0.453 | 63479.0 |
444 | 2022-09-29 12:44:25 | knits | 1 | 28756 | 7 | 0.420 | 68466.7 |
443 | 2022-09-19 08:58:47 | knits | 1 | 28756 | 7 | 0.420 | 68466.7 |
442 | 2022-09-12 07:34:00 | knits | 1 | 28756 | 7 | 0.423 | 67981.1 |
441 | 2022-08-26 02:15:06 | knits | 1 | 28756 | 7 | 0.420 | 68466.7 |
440 | 2022-08-23 06:11:51 | knits | 1 | 28756 | 7 | 0.453 | 63479.0 |
439 | 2022-08-17 14:26:03 | knits | 1 | 28756 | 7 | 0.450 | 63902.2 |
438 | 2022-08-14 14:47:32 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
437 | 2022-08-09 07:26:57 | knits | 1 | 28756 | 7 | 0.423 | 67981.1 |
436 | 2022-08-06 23:11:39 | knits | 1 | 28756 | 7 | 0.453 | 63479.0 |
435 | 2022-08-01 01:17:45 | knits | 1 | 28756 | 7 | 0.453 | 63479.0 |
434 | 2022-07-28 21:47:11 | knits | 1 | 28756 | 7 | 0.420 | 68466.7 |
433 | 2022-07-23 08:14:51 | knits | 1 | 28756 | 7 | 0.530 | 54256.6 |
432 | 2022-07-03 09:18:38 | knits | 1 | 28756 | 7 | 0.546 | 52666.7 |
431 | 2022-07-02 21:52:08 | knits | 1 | 28756 | 7 | 0.546 | 52666.7 |
430 | 2022-06-16 09:16:39 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
429 | 2022-06-12 00:26:00 | knits | 1 | 28756 | 7 | 0.936 | 30722.2 |
428 | 2022-05-26 01:57:40 | knits | 1 | 28756 | 7 | 0.440 | 65354.5 |
427 | 2022-05-11 07:33:57 | knits | 1 | 28756 | 7 | 0.970 | 29645.4 |
426 | 2022-05-03 16:34:23 | knits | 1 | 28756 | 7 | 0.670 | 42919.4 |
425 | 2022-03-25 14:20:15 | knits | 1 | 28756 | 7 | 0.623 | 46157.3 |
424 | 2022-03-21 21:57:44 | knits | 1 | 28756 | 7 | 0.470 | 61183.0 |
423 | 2022-03-20 22:55:02 | knits | 1 | 28756 | 7 | 0.466 | 61708.2 |
422 | 2022-01-28 03:22:51 | knits | 1 | 28756 | 7 | 0.453 | 63479.0 |
421 | 2021-12-19 13:23:03 | knits | 1 | 28756 | 7 | 1.000 | 28756.0 |
420 | 2021-12-19 04:33:23 | knits | 1 | 28756 | 7 | 0.423 | 67981.1 |
419 | 2021-12-18 19:41:11 | knits | 1 | 28756 | 7 | 0.470 | 61183.0 |
418 | 2021-12-11 12:23:03 | knits | 1 | 28756 | 7 | 0.423 | 67981.1 |
417 | 2021-11-23 10:34:00 | knits | 1 | 28756 | 7 | 0.436 | 65954.1 |
416 | 2021-11-03 00:32:39 | knits | 1 | 28756 | 7 | 0.423 | 67981.1 |
415 | 2021-11-02 02:00:32 | knits | 1 | 28756 | 7 | 0.483 | 59536.2 |
414 | 2021-11-02 01:06:25 | knits | 1 | 28756 | 7 | 0.436 | 65954.1 |
413 | 2021-11-01 16:11:56 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
412 | 2021-10-30 12:56:00 | knits | 1 | 28756 | 7 | 0.423 | 67981.1 |
411 | 2021-10-30 06:01:46 | knits | 1 | 28756 | 7 | 0.500 | 57512.0 |
410 | 2021-10-29 19:21:56 | knits | 1 | 28756 | 7 | 0.486 | 59168.7 |
409 | 2021-10-29 01:05:28 | knits | 1 | 28756 | 7 | 0.533 | 53951.2 |
408 | 2021-10-28 18:30:07 | knits | 1 | 28756 | 7 | 0.530 | 54256.6 |
407 | 2021-10-27 21:20:33 | knits | 1 | 28756 | 7 | 0.530 | 54256.6 |
406 | 2021-10-27 01:11:09 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
405 | 2021-10-11 05:35:33 | knits | 1 | 28756 | 7 | 0.470 | 61183.0 |
404 | 2021-09-23 23:45:27 | knits | 1 | 28756 | 7 | 0.530 | 54256.6 |
403 | 2021-09-23 03:44:10 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
402 | 2021-09-20 02:41:08 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
401 | 2021-09-16 21:14:00 | knits | 1 | 28756 | 7 | 0.406 | 70827.6 |
400 | 2021-09-07 10:34:25 | knits | 1 | 28756 | 7 | 0.420 | 68466.7 |
399 | 2021-06-06 12:29:29 | knits | 1 | 28756 | 7 | 0.486 | 59168.7 |
398 | 2021-06-03 07:48:33 | knits | 1 | 28756 | 7 | 0.483 | 59536.2 |
397 | 2021-05-28 02:34:20 | knits | 1 | 28756 | 7 | 0.483 | 59536.2 |
396 | 2021-05-26 18:24:58 | knits | 2 | 53800 | 135 | 1.610 | 33416.1 |
395 | 2021-05-12 05:38:12 | knits | 1 | 28756 | 7 | 0.483 | 59536.2 |
394 | 2021-05-02 08:29:45 | knits | 1 | 28756 | 7 | 0.423 | 67981.1 |
393 | 2021-03-30 07:22:30 | knits | 2 | 53800 | 135 | 1.360 | 39558.8 |
392 | 2021-02-24 16:01:00 | knits | 1 | 28756 | 7 | 0.453 | 63479.0 |
391 | 2021-02-22 14:31:03 | knits | 1 | 28756 | 7 | 0.826 | 34813.6 |
390 | 2021-01-25 07:15:51 | knits | 1 | 28756 | 7 | 0.483 | 59536.2 |
389 | 2020-12-15 03:14:14 | knits | 2 | 53800 | 135 | 1.393 | 38621.7 |