History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"kings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
651 | 2024-04-05 03:06:15 | kings | 1 | 28756 | 17 | 1.013 | 28387.0 |
650 | 2024-04-04 04:05:35 | kings | 1 | 28756 | 17 | 1.703 | 16885.5 |
649 | 2024-04-03 21:12:36 | kings | 1 | 28756 | 17 | 1.110 | 25906.3 |
648 | 2024-04-03 01:35:38 | kings | 1 | 28756 | 17 | 0.563 | 51076.4 |
647 | 2024-03-31 02:12:59 | kings | 1 | 28756 | 17 | 0.546 | 52666.7 |
646 | 2024-03-27 03:25:17 | kings | 1 | 28756 | 17 | 2.436 | 11804.6 |
645 | 2024-03-04 20:26:08 | kings | 1 | 28756 | 17 | 1.000 | 28756.0 |
644 | 2024-03-04 20:26:01 | kings | 2 | 53800 | 235 | 1.720 | 31279.1 |
643 | 2024-03-04 20:25:52 | kings | 1 | 28756 | 17 | 0.486 | 59168.7 |
642 | 2024-03-03 22:37:28 | kings | 1 | 28756 | 17 | 0.906 | 31739.5 |
641 | 2024-03-01 13:33:48 | kings | 2 | 53800 | 235 | 1.550 | 34709.7 |
640 | 2024-02-25 17:55:23 | kings | 1 | 28756 | 17 | 1.673 | 17188.3 |
639 | 2024-02-03 17:13:22 | kings | 1 | 28756 | 17 | 0.486 | 59168.7 |
638 | 2024-01-31 22:40:44 | kings | 2 | 53800 | 235 | 1.563 | 34421.0 |
637 | 2024-01-31 06:35:59 | kings | 2 | 53800 | 235 | 1.596 | 33709.3 |
636 | 2024-01-26 08:45:49 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
635 | 2024-01-21 10:28:16 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
634 | 2024-01-13 05:46:12 | kings | 2 | 53800 | 235 | 1.766 | 30464.3 |
633 | 2024-01-04 15:03:19 | kings | 1 | 28756 | 17 | 0.500 | 57512.0 |
632 | 2023-12-23 04:31:35 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
631 | 2023-11-30 14:28:26 | kings | 2 | 53800 | 235 | 3.110 | 17299.0 |
630 | 2023-11-25 18:17:11 | kings | 1 | 28756 | 17 | 0.500 | 57512.0 |
629 | 2023-11-20 05:09:02 | kings | 2 | 53800 | 235 | 1.486 | 36204.6 |
628 | 2023-11-17 22:40:20 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
627 | 2023-11-15 13:12:32 | kings | 2 | 53800 | 235 | 1.310 | 41068.7 |
626 | 2023-11-15 10:21:08 | kings | 1 | 28756 | 17 | 0.466 | 61708.2 |
625 | 2023-11-09 00:05:03 | kings | 1 | 28756 | 17 | 0.486 | 59168.7 |
624 | 2023-11-08 16:35:43 | kings | 1 | 28756 | 17 | 0.470 | 61183.0 |
623 | 2023-11-03 10:13:03 | kings | 1 | 28756 | 17 | 0.500 | 57512.0 |
622 | 2023-10-31 03:36:01 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
621 | 2023-10-26 13:05:43 | kings | 2 | 53800 | 235 | 1.716 | 31352.0 |
620 | 2023-10-26 02:38:53 | kings | 1 | 28756 | 17 | 0.656 | 43835.4 |
619 | 2023-10-25 16:50:41 | kings | 2 | 53800 | 235 | 1.563 | 34421.0 |
618 | 2023-10-23 07:23:35 | kings | 2 | 53800 | 235 | 1.330 | 40451.1 |
617 | 2023-10-22 03:29:22 | kings | 2 | 53800 | 235 | 1.376 | 39098.8 |
616 | 2023-10-19 22:01:59 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
615 | 2023-10-19 12:51:15 | kings | 1 | 28756 | 17 | 0.546 | 52666.7 |
614 | 2023-10-17 00:24:32 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
613 | 2023-10-11 14:26:17 | kings | 1 | 28756 | 17 | 0.423 | 67981.1 |
612 | 2023-10-04 08:52:17 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
611 | 2023-09-26 13:05:20 | kings | 1 | 28756 | 17 | 0.420 | 68466.7 |
610 | 2023-09-22 07:23:38 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
609 | 2023-09-09 16:23:14 | kings | 1 | 28756 | 17 | 0.423 | 67981.1 |
608 | 2023-09-03 07:11:18 | kings | 1 | 28756 | 17 | 0.470 | 61183.0 |
607 | 2023-08-20 17:07:30 | kings | 2 | 53800 | 235 | 1.340 | 40149.3 |
606 | 2023-08-18 22:53:53 | kings | 2 | 53800 | 235 | 1.330 | 40451.1 |
605 | 2023-08-02 15:56:23 | kings | 2 | 53800 | 235 | 1.330 | 40451.1 |
604 | 2023-08-02 13:09:27 | kings | 1 | 28756 | 17 | 0.423 | 67981.1 |
603 | 2023-07-19 02:30:40 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
602 | 2023-06-05 14:16:51 | kings | 2 | 53800 | 235 | 1.486 | 36204.6 |
601 | 2023-06-01 14:05:01 | kings | 2 | 53800 | 235 | 2.826 | 19037.5 |
600 | 2023-04-13 17:29:43 | kings | 2 | 53800 | 235 | 1.483 | 36277.8 |
599 | 2023-04-07 14:42:17 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
598 | 2023-02-04 14:44:17 | kings | 2 | 53800 | 235 | 1.580 | 34050.6 |
597 | 2023-01-20 02:44:10 | kings | 2 | 53800 | 235 | 1.486 | 36204.6 |
596 | 2023-01-11 01:45:20 | kings | 1 | 28756 | 17 | 0.423 | 67981.1 |
595 | 2022-12-29 15:46:32 | kings | 1 | 28756 | 17 | 0.453 | 63479.0 |
594 | 2022-12-29 03:02:38 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
593 | 2022-12-28 13:44:47 | kings | 2 | 53800 | 235 | 1.313 | 40974.9 |
592 | 2022-12-27 00:29:14 | kings | 1 | 28756 | 17 | 0.470 | 61183.0 |
591 | 2022-12-25 00:32:51 | kings | 1 | 28756 | 17 | 0.453 | 63479.0 |
590 | 2022-12-23 00:33:54 | kings | 1 | 28756 | 17 | 0.500 | 57512.0 |
589 | 2022-11-24 05:48:49 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
588 | 2022-11-16 08:16:05 | kings | 1 | 28756 | 17 | 0.500 | 57512.0 |
587 | 2022-11-14 01:33:43 | kings | 1 | 28756 | 17 | 0.466 | 61708.2 |
586 | 2022-11-09 19:28:01 | kings | 1 | 28756 | 17 | 0.486 | 59168.7 |
585 | 2022-11-08 08:16:56 | kings | 1 | 28756 | 17 | 0.500 | 57512.0 |
584 | 2022-10-31 12:51:22 | kings | 2 | 53800 | 235 | 1.736 | 30990.8 |
583 | 2022-10-18 15:57:48 | kings | 1 | 28756 | 17 | 0.470 | 61183.0 |
582 | 2022-09-19 18:13:08 | kings | 1 | 28756 | 17 | 0.420 | 68466.7 |
581 | 2022-09-18 13:32:32 | kings | 1 | 28756 | 17 | 0.420 | 68466.7 |
580 | 2022-09-15 05:07:30 | kings | 1 | 28756 | 17 | 0.420 | 68466.7 |
579 | 2022-08-31 03:22:14 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
578 | 2022-08-23 19:04:54 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
577 | 2022-08-15 11:27:48 | kings | 1 | 28756 | 17 | 0.456 | 63061.4 |
576 | 2022-08-15 00:19:23 | kings | 1 | 28756 | 17 | 0.440 | 65354.5 |
575 | 2022-07-10 04:18:23 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
574 | 2022-06-09 12:45:07 | kings | 1 | 28756 | 17 | 0.470 | 61183.0 |
573 | 2022-06-05 09:28:55 | kings | 1 | 28756 | 17 | 0.420 | 68466.7 |
572 | 2022-06-02 02:52:22 | kings | 1 | 28756 | 17 | 0.453 | 63479.0 |
571 | 2022-05-16 21:00:20 | kings | 2 | 53800 | 235 | 1.763 | 30516.2 |
570 | 2022-05-06 19:23:03 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
569 | 2022-05-05 15:09:40 | kings | 1 | 28756 | 17 | 0.563 | 51076.4 |
568 | 2022-05-05 02:11:03 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
567 | 2022-05-04 12:15:20 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
566 | 2022-05-03 21:05:54 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
565 | 2022-05-03 03:00:07 | kings | 1 | 28756 | 17 | 1.000 | 28756.0 |
564 | 2022-03-31 08:12:39 | kings | 1 | 28756 | 17 | 0.516 | 55728.7 |
563 | 2022-03-30 12:39:36 | kings | 1 | 28756 | 17 | 0.686 | 41918.4 |
562 | 2022-03-29 15:32:06 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
561 | 2022-03-28 22:12:38 | kings | 1 | 28756 | 17 | 0.626 | 45936.1 |
560 | 2022-03-27 14:42:59 | kings | 1 | 28756 | 17 | 0.516 | 55728.7 |
559 | 2022-03-26 22:34:37 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
558 | 2022-03-21 20:59:56 | kings | 1 | 28756 | 17 | 0.500 | 57512.0 |
557 | 2022-03-20 22:13:56 | kings | 1 | 28756 | 17 | 0.483 | 59536.2 |
556 | 2022-02-18 17:31:32 | kings | 1 | 28756 | 17 | 0.466 | 61708.2 |
555 | 2022-02-17 03:30:47 | kings | 1 | 28756 | 17 | 0.436 | 65954.1 |
554 | 2022-01-09 20:50:35 | kings | 2 | 53800 | 235 | 1.670 | 32215.6 |
553 | 2021-12-17 12:18:49 | kings | 1 | 28756 | 17 | 0.500 | 57512.0 |
552 | 2021-12-16 15:29:23 | kings | 1 | 28756 | 17 | 0.470 | 61183.0 |