History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nicks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
699 | 2024-04-03 06:34:28 | nicks | 2 | 53800 | 174 | 1.890 | 28465.6 |
698 | 2024-04-03 06:15:40 | nicks | 1 | 28756 | 15 | 1.810 | 15887.3 |
697 | 2024-03-31 02:57:22 | nicks | 1 | 28756 | 15 | 1.576 | 18246.2 |
696 | 2024-03-28 18:47:10 | nicks | 2 | 53800 | 174 | 3.873 | 13891.0 |
695 | 2024-03-28 18:18:41 | nicks | 1 | 28756 | 15 | 0.530 | 54256.6 |
694 | 2024-03-08 23:10:27 | nicks | 1 | 28756 | 15 | 1.093 | 26309.2 |
693 | 2024-03-04 03:28:05 | nicks | 2 | 53800 | 174 | 5.186 | 10374.1 |
692 | 2024-03-04 03:27:49 | nicks | 1 | 28756 | 15 | 1.686 | 17055.8 |
691 | 2024-02-27 04:48:31 | nicks | 2 | 53800 | 174 | 3.250 | 16553.8 |
690 | 2024-02-26 12:50:15 | nicks | 2 | 53800 | 174 | 1.530 | 35163.4 |
689 | 2024-02-26 12:49:45 | nicks | 1 | 28756 | 15 | 0.500 | 57512.0 |
688 | 2024-02-14 06:38:17 | nicks | 1 | 28756 | 15 | 0.560 | 51350.0 |
687 | 2024-02-04 00:08:39 | nicks | 1 | 28756 | 15 | 1.000 | 28756.0 |
686 | 2024-02-03 00:53:55 | nicks | 1 | 28756 | 15 | 1.016 | 28303.1 |
685 | 2024-01-28 20:08:08 | nicks | 1 | 28756 | 15 | 0.420 | 68466.7 |
684 | 2024-01-27 07:45:33 | nicks | 1 | 28756 | 15 | 0.486 | 59168.7 |
683 | 2024-01-27 07:44:49 | nicks | 1 | 28756 | 15 | 0.423 | 67981.1 |
682 | 2024-01-17 15:25:25 | nicks | 1 | 28756 | 15 | 0.420 | 68466.7 |
681 | 2023-12-27 23:47:59 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
680 | 2023-12-26 22:48:46 | nicks | 1 | 28756 | 15 | 0.500 | 57512.0 |
679 | 2023-12-24 18:10:52 | nicks | 1 | 28756 | 15 | 0.436 | 65954.1 |
678 | 2023-12-23 18:23:19 | nicks | 1 | 28756 | 15 | 0.436 | 65954.1 |
677 | 2023-12-21 08:31:03 | nicks | 2 | 53800 | 174 | 1.420 | 37887.3 |
676 | 2023-12-21 05:30:39 | nicks | 1 | 28756 | 15 | 0.453 | 63479.0 |
675 | 2023-12-20 08:47:13 | nicks | 1 | 28756 | 15 | 0.470 | 61183.0 |
674 | 2023-12-18 00:33:43 | nicks | 2 | 53800 | 174 | 1.703 | 31591.3 |
673 | 2023-12-16 09:32:22 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
672 | 2023-12-15 21:47:06 | nicks | 1 | 28756 | 15 | 0.563 | 51076.4 |
671 | 2023-12-15 08:15:59 | nicks | 1 | 28756 | 15 | 0.423 | 67981.1 |
670 | 2023-12-15 02:20:00 | nicks | 2 | 53800 | 174 | 1.626 | 33087.3 |
669 | 2023-12-14 09:02:33 | nicks | 1 | 28756 | 15 | 0.440 | 65354.5 |
668 | 2023-12-13 18:39:57 | nicks | 1 | 28756 | 15 | 0.423 | 67981.1 |
667 | 2023-12-12 17:23:45 | nicks | 1 | 28756 | 15 | 0.436 | 65954.1 |
666 | 2023-12-11 04:10:45 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
665 | 2023-12-10 02:00:54 | nicks | 1 | 28756 | 15 | 0.513 | 56054.6 |
664 | 2023-12-07 00:00:59 | nicks | 1 | 28756 | 15 | 0.470 | 61183.0 |
663 | 2023-12-07 00:00:58 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
662 | 2023-12-06 04:59:45 | nicks | 1 | 28756 | 15 | 0.486 | 59168.7 |
661 | 2023-12-05 09:26:08 | nicks | 1 | 28756 | 15 | 0.516 | 55728.7 |
660 | 2023-12-03 23:52:12 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
659 | 2023-12-03 23:46:11 | nicks | 1 | 28756 | 15 | 0.500 | 57512.0 |
658 | 2023-12-02 23:00:16 | nicks | 1 | 28756 | 15 | 0.436 | 65954.1 |
657 | 2023-12-02 19:41:13 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
656 | 2023-12-01 19:07:32 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
655 | 2023-12-01 03:34:55 | nicks | 1 | 28756 | 15 | 0.436 | 65954.1 |
654 | 2023-11-24 05:17:34 | nicks | 1 | 28756 | 15 | 0.453 | 63479.0 |
653 | 2023-11-23 11:37:27 | nicks | 1 | 28756 | 15 | 0.486 | 59168.7 |
652 | 2023-11-15 10:31:00 | nicks | 2 | 53800 | 174 | 1.360 | 39558.8 |
651 | 2023-11-12 02:25:33 | nicks | 1 | 28756 | 15 | 0.436 | 65954.1 |
650 | 2023-11-11 18:50:31 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
649 | 2023-10-29 08:32:42 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
648 | 2023-10-21 10:31:39 | nicks | 1 | 28756 | 15 | 0.500 | 57512.0 |
647 | 2023-10-19 16:43:30 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
646 | 2023-10-17 20:20:16 | nicks | 1 | 28756 | 15 | 0.453 | 63479.0 |
645 | 2023-10-12 02:44:41 | nicks | 1 | 28756 | 15 | 0.500 | 57512.0 |
644 | 2023-10-09 01:07:08 | nicks | 1 | 28756 | 15 | 0.470 | 61183.0 |
643 | 2023-10-08 16:26:09 | nicks | 1 | 28756 | 15 | 0.440 | 65354.5 |
642 | 2023-10-07 17:05:37 | nicks | 1 | 28756 | 15 | 0.500 | 57512.0 |
641 | 2023-10-06 16:26:59 | nicks | 1 | 28756 | 15 | 0.470 | 61183.0 |
640 | 2023-10-05 16:49:55 | nicks | 1 | 28756 | 15 | 0.546 | 52666.7 |
639 | 2023-10-04 23:30:02 | nicks | 1 | 28756 | 15 | 0.466 | 61708.2 |
638 | 2023-10-04 18:59:16 | nicks | 1 | 28756 | 15 | 0.500 | 57512.0 |
637 | 2023-10-03 17:41:20 | nicks | 1 | 28756 | 15 | 0.453 | 63479.0 |
636 | 2023-09-26 05:22:31 | nicks | 1 | 28756 | 15 | 0.500 | 57512.0 |
635 | 2023-09-18 22:18:18 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
634 | 2023-08-26 21:05:09 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
633 | 2023-08-09 17:49:28 | nicks | 2 | 53800 | 174 | 1.373 | 39184.3 |
632 | 2023-08-08 18:40:38 | nicks | 2 | 53800 | 174 | 1.530 | 35163.4 |
631 | 2023-08-04 20:49:24 | nicks | 2 | 53800 | 174 | 1.486 | 36204.6 |
630 | 2023-08-04 08:34:48 | nicks | 2 | 53800 | 174 | 1.546 | 34799.5 |
629 | 2023-07-30 22:36:18 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
628 | 2023-07-04 13:18:42 | nicks | 1 | 28756 | 15 | 0.423 | 67981.1 |
627 | 2023-06-18 19:31:44 | nicks | 1 | 28756 | 15 | 0.420 | 68466.7 |
626 | 2023-06-05 23:57:52 | nicks | 1 | 28756 | 15 | 0.856 | 33593.5 |
625 | 2023-05-02 18:25:19 | nicks | 2 | 53800 | 174 | 1.376 | 39098.8 |
624 | 2023-04-19 06:13:40 | nicks | 2 | 53800 | 174 | 1.533 | 35094.6 |
623 | 2023-04-10 20:02:39 | nicks | 1 | 28756 | 15 | 0.466 | 61708.2 |
622 | 2023-03-17 10:03:45 | nicks | 2 | 53800 | 174 | 1.563 | 34421.0 |
621 | 2023-03-03 06:20:15 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
620 | 2023-02-20 08:26:49 | nicks | 1 | 28756 | 15 | 0.470 | 61183.0 |
619 | 2023-02-19 10:15:51 | nicks | 1 | 28756 | 15 | 0.466 | 61708.2 |
618 | 2023-02-18 03:26:43 | nicks | 1 | 28756 | 15 | 0.436 | 65954.1 |
617 | 2023-02-16 11:19:11 | nicks | 1 | 28756 | 15 | 0.423 | 67981.1 |
616 | 2023-02-15 06:14:29 | nicks | 1 | 28756 | 15 | 0.500 | 57512.0 |
615 | 2023-02-14 08:12:06 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
614 | 2023-02-13 21:44:14 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
613 | 2023-02-12 04:23:32 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
612 | 2023-02-11 07:55:20 | nicks | 1 | 28756 | 15 | 0.470 | 61183.0 |
611 | 2023-01-31 17:12:32 | nicks | 1 | 28756 | 15 | 0.550 | 52283.6 |
610 | 2022-11-29 06:52:33 | nicks | 1 | 28756 | 15 | 0.436 | 65954.1 |
609 | 2022-11-07 09:41:41 | nicks | 1 | 28756 | 15 | 0.516 | 55728.7 |
608 | 2022-07-24 02:24:38 | nicks | 1 | 28756 | 15 | 0.516 | 55728.7 |
607 | 2022-07-21 16:08:06 | nicks | 1 | 28756 | 15 | 0.420 | 68466.7 |
606 | 2022-07-17 22:51:57 | nicks | 1 | 28756 | 15 | 0.486 | 59168.7 |
605 | 2022-03-30 20:43:58 | nicks | 1 | 28756 | 15 | 0.530 | 54256.6 |
604 | 2022-03-19 20:08:02 | nicks | 1 | 28756 | 15 | 0.436 | 65954.1 |
603 | 2022-03-19 02:20:04 | nicks | 1 | 28756 | 15 | 0.516 | 55728.7 |
602 | 2022-03-18 22:07:11 | nicks | 1 | 28756 | 15 | 0.546 | 52666.7 |
601 | 2022-03-18 03:00:12 | nicks | 1 | 28756 | 15 | 0.483 | 59536.2 |
600 | 2022-03-17 09:12:24 | nicks | 1 | 28756 | 15 | 0.640 | 44931.3 |