History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hicks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
695 | 2024-05-07 23:54:25 | hicks | 1 | 28756 | 19 | 0.983 | 29253.3 |
694 | 2024-05-07 07:15:13 | hicks | 1 | 28756 | 19 | 1.093 | 26309.2 |
693 | 2024-05-02 12:16:57 | hicks | 1 | 28756 | 19 | 1.046 | 27491.4 |
692 | 2024-05-01 08:30:30 | hicks | 2 | 53800 | 195 | 6.373 | 8441.9 |
691 | 2024-05-01 08:08:31 | hicks | 1 | 28756 | 19 | 0.576 | 49923.6 |
690 | 2024-05-01 08:08:21 | hicks | 2 | 53800 | 195 | 3.720 | 14462.4 |
689 | 2024-04-30 15:54:02 | hicks | 2 | 53800 | 195 | 2.516 | 21383.1 |
688 | 2024-04-12 19:31:33 | hicks | 1 | 28756 | 19 | 0.576 | 49923.6 |
687 | 2024-04-03 08:11:31 | hicks | 2 | 53800 | 195 | 3.736 | 14400.4 |
686 | 2024-04-03 08:02:10 | hicks | 1 | 28756 | 19 | 1.093 | 26309.2 |
685 | 2024-03-29 09:52:18 | hicks | 2 | 53800 | 195 | 3.326 | 16175.6 |
684 | 2024-03-28 18:47:06 | hicks | 2 | 53800 | 195 | 3.736 | 14400.4 |
683 | 2024-03-28 18:18:47 | hicks | 1 | 28756 | 19 | 1.143 | 25158.4 |
682 | 2024-03-12 19:33:33 | hicks | 1 | 28756 | 19 | 1.063 | 27051.7 |
681 | 2024-03-12 19:33:23 | hicks | 2 | 53800 | 195 | 3.686 | 14595.8 |
680 | 2024-03-12 19:33:10 | hicks | 1 | 28756 | 19 | 0.533 | 53951.2 |
679 | 2024-03-11 21:45:21 | hicks | 1 | 28756 | 19 | 0.516 | 55728.7 |
678 | 2024-03-04 03:28:04 | hicks | 2 | 53800 | 195 | 5.453 | 9866.1 |
677 | 2024-03-04 03:27:56 | hicks | 1 | 28756 | 19 | 1.703 | 16885.5 |
676 | 2024-02-27 10:24:32 | hicks | 2 | 53800 | 195 | 3.360 | 16011.9 |
675 | 2024-02-26 12:50:06 | hicks | 2 | 53800 | 195 | 1.673 | 32157.8 |
674 | 2024-02-26 12:49:55 | hicks | 1 | 28756 | 19 | 0.500 | 57512.0 |
673 | 2024-02-11 18:16:47 | hicks | 1 | 28756 | 19 | 1.283 | 22413.1 |
672 | 2024-02-03 00:54:03 | hicks | 1 | 28756 | 19 | 0.483 | 59536.2 |
671 | 2024-01-27 07:45:25 | hicks | 1 | 28756 | 19 | 0.986 | 29164.3 |
670 | 2024-01-11 18:19:02 | hicks | 1 | 28756 | 19 | 0.483 | 59536.2 |
669 | 2023-12-19 11:48:34 | hicks | 2 | 53800 | 195 | 1.403 | 38346.4 |
668 | 2023-12-18 00:24:41 | hicks | 2 | 53800 | 195 | 1.376 | 39098.8 |
667 | 2023-12-16 12:46:03 | hicks | 1 | 28756 | 19 | 0.483 | 59536.2 |
666 | 2023-12-12 19:10:12 | hicks | 2 | 53800 | 195 | 1.360 | 39558.8 |
665 | 2023-12-04 17:19:26 | hicks | 1 | 28756 | 19 | 0.483 | 59536.2 |
664 | 2023-12-04 17:19:25 | hicks | 1 | 28756 | 19 | 0.500 | 57512.0 |
663 | 2023-11-28 22:09:04 | hicks | 2 | 53800 | 195 | 3.296 | 16322.8 |
662 | 2023-11-16 04:29:08 | hicks | 1 | 28756 | 19 | 0.466 | 61708.2 |
661 | 2023-11-15 07:43:42 | hicks | 2 | 53800 | 195 | 1.673 | 32157.8 |
660 | 2023-11-11 11:38:05 | hicks | 1 | 28756 | 19 | 0.423 | 67981.1 |
659 | 2023-11-10 02:51:26 | hicks | 1 | 28756 | 19 | 1.030 | 27918.4 |
658 | 2023-10-29 08:32:14 | hicks | 1 | 28756 | 19 | 0.500 | 57512.0 |
657 | 2023-10-21 10:30:10 | hicks | 1 | 28756 | 19 | 0.483 | 59536.2 |
656 | 2023-10-17 11:40:09 | hicks | 1 | 28756 | 19 | 0.436 | 65954.1 |
655 | 2023-10-12 02:38:35 | hicks | 1 | 28756 | 19 | 0.516 | 55728.7 |
654 | 2023-10-04 23:28:26 | hicks | 1 | 28756 | 19 | 0.500 | 57512.0 |
653 | 2023-10-02 19:18:26 | hicks | 1 | 28756 | 19 | 0.470 | 61183.0 |
652 | 2023-09-29 07:12:54 | hicks | 1 | 28756 | 19 | 1.140 | 25224.6 |
651 | 2023-09-20 01:04:58 | hicks | 2 | 53800 | 195 | 1.326 | 40573.2 |
650 | 2023-08-10 17:07:49 | hicks | 2 | 53800 | 195 | 1.313 | 40974.9 |
649 | 2023-08-03 02:33:54 | hicks | 2 | 53800 | 195 | 1.436 | 37465.2 |
648 | 2023-08-02 17:32:30 | hicks | 1 | 28756 | 19 | 0.470 | 61183.0 |
647 | 2023-07-30 07:26:05 | hicks | 1 | 28756 | 19 | 0.436 | 65954.1 |
646 | 2023-07-03 22:49:24 | hicks | 2 | 53800 | 195 | 3.236 | 16625.5 |
645 | 2023-06-25 15:17:57 | hicks | 2 | 53800 | 195 | 1.360 | 39558.8 |
644 | 2023-05-14 13:55:41 | hicks | 2 | 53800 | 195 | 1.500 | 35866.7 |
643 | 2023-04-28 23:29:04 | hicks | 1 | 28756 | 19 | 0.483 | 59536.2 |
642 | 2023-04-26 21:48:45 | hicks | 1 | 28756 | 19 | 0.436 | 65954.1 |
641 | 2023-04-08 23:27:30 | hicks | 2 | 53800 | 195 | 1.343 | 40059.6 |
640 | 2023-03-18 20:48:15 | hicks | 2 | 53800 | 195 | 1.360 | 39558.8 |
639 | 2023-02-16 15:54:30 | hicks | 1 | 28756 | 19 | 0.423 | 67981.1 |
638 | 2023-01-24 03:27:40 | hicks | 1 | 28756 | 19 | 0.440 | 65354.5 |
637 | 2022-12-19 17:58:50 | hicks | 2 | 53800 | 195 | 1.330 | 40451.1 |
636 | 2022-12-15 20:07:53 | hicks | 1 | 28756 | 19 | 0.440 | 65354.5 |
635 | 2022-12-14 08:11:07 | hicks | 2 | 53800 | 195 | 1.560 | 34487.2 |
634 | 2022-11-02 21:32:02 | hicks | 2 | 53800 | 195 | 1.453 | 37026.8 |
633 | 2022-10-09 19:04:53 | hicks | 1 | 28756 | 19 | 0.436 | 65954.1 |
632 | 2022-08-25 20:59:15 | hicks | 1 | 28756 | 19 | 0.513 | 56054.6 |
631 | 2022-08-15 06:07:19 | hicks | 2 | 53800 | 195 | 1.356 | 39675.5 |
630 | 2022-07-04 16:37:16 | hicks | 1 | 28756 | 19 | 0.436 | 65954.1 |
629 | 2022-04-15 04:14:06 | hicks | 1 | 28756 | 19 | 0.610 | 47141.0 |
628 | 2022-03-24 07:03:16 | hicks | 1 | 28756 | 19 | 0.533 | 53951.2 |
627 | 2022-03-21 23:52:30 | hicks | 1 | 28756 | 19 | 0.436 | 65954.1 |
626 | 2022-03-15 18:48:17 | hicks | 2 | 53800 | 195 | 1.546 | 34799.5 |
625 | 2022-03-11 07:24:37 | hicks | 1 | 28756 | 19 | 0.470 | 61183.0 |
624 | 2022-03-10 17:12:48 | hicks | 1 | 28756 | 19 | 0.483 | 59536.2 |
623 | 2022-03-09 15:51:39 | hicks | 1 | 28756 | 19 | 0.733 | 39230.6 |
622 | 2022-03-08 11:51:21 | hicks | 1 | 28756 | 19 | 0.703 | 40904.7 |
621 | 2022-03-07 15:41:33 | hicks | 1 | 28756 | 19 | 0.750 | 38341.3 |
620 | 2022-03-06 14:25:59 | hicks | 1 | 28756 | 19 | 0.486 | 59168.7 |
619 | 2022-03-05 14:05:51 | hicks | 1 | 28756 | 19 | 0.516 | 55728.7 |
618 | 2022-03-04 14:00:25 | hicks | 1 | 28756 | 19 | 0.486 | 59168.7 |
617 | 2022-03-03 07:40:02 | hicks | 1 | 28756 | 19 | 0.453 | 63479.0 |
616 | 2022-03-02 17:52:52 | hicks | 1 | 28756 | 19 | 0.440 | 65354.5 |
615 | 2022-02-10 21:41:22 | hicks | 1 | 28756 | 19 | 0.486 | 59168.7 |
614 | 2022-02-10 03:56:09 | hicks | 1 | 28756 | 19 | 0.483 | 59536.2 |
613 | 2022-02-09 15:52:50 | hicks | 1 | 28756 | 19 | 0.440 | 65354.5 |
612 | 2022-02-08 15:28:25 | hicks | 1 | 28756 | 19 | 0.970 | 29645.4 |
611 | 2022-02-07 17:34:50 | hicks | 1 | 28756 | 19 | 0.450 | 63902.2 |
610 | 2022-01-23 16:15:24 | hicks | 1 | 28756 | 19 | 0.500 | 57512.0 |
609 | 2022-01-22 20:33:33 | hicks | 1 | 28756 | 19 | 0.513 | 56054.6 |
608 | 2022-01-10 21:59:05 | hicks | 1 | 28756 | 19 | 0.500 | 57512.0 |
607 | 2022-01-08 19:03:01 | hicks | 1 | 28756 | 19 | 0.436 | 65954.1 |
606 | 2021-12-17 16:48:56 | hicks | 1 | 28756 | 19 | 0.563 | 51076.4 |
605 | 2021-12-16 19:57:34 | hicks | 1 | 28756 | 19 | 0.486 | 59168.7 |
604 | 2021-12-15 22:36:44 | hicks | 1 | 28756 | 19 | 0.440 | 65354.5 |
603 | 2021-12-10 21:20:24 | hicks | 1 | 28756 | 19 | 0.533 | 53951.2 |
602 | 2021-12-10 05:34:25 | hicks | 1 | 28756 | 19 | 0.513 | 56054.6 |
601 | 2021-12-09 21:58:25 | hicks | 1 | 28756 | 19 | 0.486 | 59168.7 |
600 | 2021-12-08 22:28:07 | hicks | 1 | 28756 | 19 | 0.516 | 55728.7 |
599 | 2021-12-07 18:04:42 | hicks | 1 | 28756 | 19 | 0.500 | 57512.0 |
598 | 2021-12-06 23:07:34 | hicks | 1 | 28756 | 19 | 0.436 | 65954.1 |
597 | 2021-12-06 22:51:01 | hicks | 1 | 28756 | 19 | 0.513 | 56054.6 |
596 | 2021-11-18 18:14:34 | hicks | 1 | 28756 | 19 | 0.546 | 52666.7 |