History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sandy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
715 | 2024-05-04 00:36:09 | sandy | 1 | 28756 | 10 | 0.576 | 49923.6 |
714 | 2024-04-30 11:23:28 | sandy | 1 | 28756 | 10 | 1.890 | 15214.8 |
713 | 2024-04-29 12:35:20 | sandy | 1 | 28756 | 10 | 0.546 | 52666.7 |
712 | 2024-04-29 07:00:36 | sandy | 1 | 28756 | 10 | 0.546 | 52666.7 |
711 | 2024-04-28 03:51:20 | sandy | 1 | 28756 | 10 | 0.550 | 52283.6 |
710 | 2024-04-27 19:17:58 | sandy | 2 | 53800 | 135 | 1.466 | 36698.5 |
709 | 2024-04-27 00:44:59 | sandy | 1 | 28756 | 10 | 1.670 | 17219.2 |
708 | 2024-04-13 17:36:09 | sandy | 1 | 28756 | 10 | 0.656 | 43835.4 |
707 | 2024-04-03 02:58:38 | sandy | 2 | 53800 | 135 | 2.046 | 26295.2 |
706 | 2024-04-03 02:39:23 | sandy | 1 | 28756 | 10 | 0.610 | 47141.0 |
705 | 2024-03-31 07:39:03 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
704 | 2024-03-28 19:02:07 | sandy | 2 | 53800 | 135 | 4.970 | 10824.9 |
703 | 2024-03-28 18:08:02 | sandy | 1 | 28756 | 10 | 1.186 | 24246.2 |
702 | 2024-03-27 22:07:50 | sandy | 1 | 28756 | 10 | 0.483 | 59536.2 |
701 | 2024-03-03 20:51:40 | sandy | 1 | 28756 | 10 | 0.533 | 53951.2 |
700 | 2024-03-01 05:15:08 | sandy | 1 | 28756 | 10 | 0.546 | 52666.7 |
699 | 2024-02-28 16:51:03 | sandy | 1 | 28756 | 10 | 1.860 | 15460.2 |
698 | 2024-02-27 15:23:37 | sandy | 2 | 53800 | 135 | 1.813 | 29674.6 |
697 | 2024-02-26 19:46:37 | sandy | 2 | 53800 | 135 | 1.470 | 36598.6 |
696 | 2024-02-26 19:46:34 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
695 | 2024-01-29 13:54:34 | sandy | 1 | 28756 | 10 | 0.533 | 53951.2 |
694 | 2024-01-17 15:12:41 | sandy | 2 | 53800 | 135 | 2.940 | 18299.3 |
693 | 2024-01-17 13:50:27 | sandy | 2 | 53800 | 135 | 1.470 | 36598.6 |
692 | 2024-01-04 12:47:40 | sandy | 1 | 28756 | 10 | 0.543 | 52957.6 |
691 | 2023-12-31 09:11:56 | sandy | 2 | 53800 | 135 | 1.486 | 36204.6 |
690 | 2023-12-29 22:46:11 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
689 | 2023-11-23 10:00:49 | sandy | 1 | 28756 | 10 | 0.483 | 59536.2 |
688 | 2023-11-17 21:29:29 | sandy | 1 | 28756 | 10 | 0.513 | 56054.6 |
687 | 2023-11-17 20:19:01 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
686 | 2023-10-30 18:54:58 | sandy | 1 | 28756 | 10 | 0.546 | 52666.7 |
685 | 2023-10-20 16:07:04 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
684 | 2023-10-20 10:41:25 | sandy | 1 | 28756 | 10 | 0.513 | 56054.6 |
683 | 2023-10-19 18:57:06 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
682 | 2023-10-17 17:01:31 | sandy | 1 | 28756 | 10 | 1.156 | 24875.4 |
681 | 2023-10-05 03:25:30 | sandy | 1 | 28756 | 10 | 0.533 | 53951.2 |
680 | 2023-10-01 03:23:33 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
679 | 2023-09-27 19:44:54 | sandy | 1 | 28756 | 10 | 0.470 | 61183.0 |
678 | 2023-09-26 13:18:35 | sandy | 1 | 28756 | 10 | 0.533 | 53951.2 |
677 | 2023-09-26 09:06:53 | sandy | 1 | 28756 | 10 | 0.550 | 52283.6 |
676 | 2023-08-14 19:24:04 | sandy | 1 | 28756 | 10 | 0.470 | 61183.0 |
675 | 2023-06-10 20:45:42 | sandy | 1 | 28756 | 10 | 0.500 | 57512.0 |
674 | 2023-05-14 19:47:14 | sandy | 1 | 28756 | 10 | 0.436 | 65954.1 |
673 | 2023-03-06 01:37:34 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
672 | 2023-02-26 03:05:26 | sandy | 1 | 28756 | 10 | 0.466 | 61708.2 |
671 | 2023-01-20 23:37:27 | sandy | 2 | 53800 | 135 | 1.500 | 35866.7 |
670 | 2022-12-28 05:25:29 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
669 | 2022-12-20 10:01:43 | sandy | 2 | 53800 | 135 | 1.703 | 31591.3 |
668 | 2022-12-06 19:47:27 | sandy | 2 | 53800 | 135 | 1.423 | 37807.4 |
667 | 2022-11-25 10:05:23 | sandy | 1 | 28756 | 10 | 0.530 | 54256.6 |
666 | 2022-11-09 07:32:08 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
665 | 2022-11-08 19:17:37 | sandy | 2 | 53800 | 135 | 1.640 | 32804.9 |
664 | 2022-09-16 07:06:36 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
663 | 2022-08-24 04:43:41 | sandy | 1 | 28756 | 10 | 0.456 | 63061.4 |
662 | 2022-08-16 02:19:41 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
661 | 2022-08-07 20:39:52 | sandy | 1 | 28756 | 10 | 0.466 | 61708.2 |
660 | 2022-07-23 16:26:15 | sandy | 1 | 28756 | 10 | 0.466 | 61708.2 |
659 | 2022-07-16 09:47:30 | sandy | 2 | 53800 | 135 | 1.796 | 29955.5 |
658 | 2022-07-02 18:00:11 | sandy | 1 | 28756 | 10 | 0.483 | 59536.2 |
657 | 2022-06-30 14:15:01 | sandy | 1 | 28756 | 10 | 0.436 | 65954.1 |
656 | 2022-03-29 08:24:06 | sandy | 1 | 28756 | 10 | 0.596 | 48248.3 |
655 | 2022-03-05 11:48:34 | sandy | 1 | 28756 | 10 | 0.500 | 57512.0 |
654 | 2022-01-13 09:36:39 | sandy | 1 | 28756 | 10 | 1.080 | 26625.9 |
653 | 2022-01-12 09:49:21 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
652 | 2022-01-11 13:25:19 | sandy | 1 | 28756 | 10 | 0.533 | 53951.2 |
651 | 2022-01-10 15:04:07 | sandy | 1 | 28756 | 10 | 0.513 | 56054.6 |
650 | 2022-01-05 11:18:42 | sandy | 2 | 53800 | 135 | 1.670 | 32215.6 |
649 | 2021-12-18 04:37:22 | sandy | 1 | 28756 | 10 | 0.483 | 59536.2 |
648 | 2021-12-18 04:06:30 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
647 | 2021-12-16 00:10:51 | sandy | 1 | 28756 | 10 | 0.580 | 49579.3 |
646 | 2021-12-15 17:14:07 | sandy | 1 | 28756 | 10 | 0.500 | 57512.0 |
645 | 2021-12-11 18:19:21 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
644 | 2021-12-11 08:21:08 | sandy | 1 | 28756 | 10 | 0.500 | 57512.0 |
643 | 2021-12-11 00:04:29 | sandy | 1 | 28756 | 10 | 0.533 | 53951.2 |
642 | 2021-12-10 17:03:50 | sandy | 1 | 28756 | 10 | 0.500 | 57512.0 |
641 | 2021-12-10 06:20:05 | sandy | 1 | 28756 | 10 | 0.546 | 52666.7 |
640 | 2021-12-09 21:25:43 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
639 | 2021-12-09 07:44:01 | sandy | 1 | 28756 | 10 | 1.093 | 26309.2 |
638 | 2021-12-09 00:19:13 | sandy | 2 | 53800 | 135 | 1.483 | 36277.8 |
637 | 2021-12-08 22:27:53 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
636 | 2021-12-08 12:43:09 | sandy | 1 | 28756 | 10 | 0.546 | 52666.7 |
635 | 2021-11-27 03:29:22 | sandy | 1 | 28756 | 10 | 0.533 | 53951.2 |
634 | 2021-11-26 17:17:34 | sandy | 1 | 28756 | 10 | 0.500 | 57512.0 |
633 | 2021-11-25 11:09:17 | sandy | 1 | 28756 | 10 | 0.576 | 49923.6 |
632 | 2021-11-20 15:12:00 | sandy | 1 | 28756 | 10 | 0.513 | 56054.6 |
631 | 2021-11-10 17:33:15 | sandy | 1 | 28756 | 10 | 0.546 | 52666.7 |
630 | 2021-11-09 22:04:19 | sandy | 1 | 28756 | 10 | 0.640 | 44931.3 |
629 | 2021-11-08 17:22:39 | sandy | 1 | 28756 | 10 | 0.530 | 54256.6 |
628 | 2021-11-07 00:20:55 | sandy | 2 | 53800 | 135 | 1.703 | 31591.3 |
627 | 2021-10-23 04:37:44 | sandy | 1 | 28756 | 10 | 0.450 | 63902.2 |
626 | 2021-09-14 04:38:05 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
625 | 2021-09-13 06:11:53 | sandy | 1 | 28756 | 10 | 0.470 | 61183.0 |
624 | 2021-09-10 23:36:30 | sandy | 1 | 28756 | 10 | 0.466 | 61708.2 |
623 | 2021-08-26 16:15:53 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
622 | 2021-08-14 21:27:36 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
621 | 2021-07-30 06:56:01 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
620 | 2021-07-29 04:50:46 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
619 | 2021-07-28 03:31:06 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
618 | 2021-07-27 23:59:49 | sandy | 1 | 28756 | 10 | 0.453 | 63479.0 |
617 | 2021-07-27 06:46:19 | sandy | 1 | 28756 | 10 | 0.516 | 55728.7 |
616 | 2021-07-26 17:01:08 | sandy | 1 | 28756 | 10 | 0.470 | 61183.0 |