History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sandals"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
715 | 2024-04-27 18:30:35 | sandals | 1 | 69583 | 5 | 1.220 | 57035.2 |
714 | 2024-04-27 08:31:01 | sandals | 1 | 69583 | 5 | 1.326 | 52475.9 |
713 | 2024-03-28 15:06:23 | sandals | 1 | 69583 | 5 | 1.236 | 56296.9 |
712 | 2024-03-08 23:50:48 | sandals | 3 | 134027 | 449 | 19.253 | 6961.4 |
711 | 2024-03-07 01:03:19 | sandals | 1 | 69583 | 5 | 1.173 | 59320.5 |
710 | 2024-03-06 20:09:13 | sandals | 3 | 134027 | 449 | 13.186 | 10164.3 |
709 | 2024-03-06 08:49:14 | sandals | 3 | 134027 | 449 | 8.623 | 15543.0 |
708 | 2024-03-06 06:03:59 | sandals | 2 | 107671 | 40 | 13.063 | 8242.4 |
707 | 2024-03-06 06:03:57 | sandals | 3 | 134027 | 449 | 13.893 | 9647.1 |
706 | 2024-03-06 06:03:49 | sandals | 1 | 69583 | 5 | 2.890 | 24077.2 |
705 | 2024-02-04 00:44:11 | sandals | 2 | 107671 | 40 | 3.686 | 29210.8 |
704 | 2024-02-03 03:51:30 | sandals | 3 | 134027 | 449 | 15.530 | 8630.2 |
703 | 2024-02-02 22:36:56 | sandals | 3 | 134027 | 449 | 15.110 | 8870.1 |
702 | 2024-02-02 20:36:13 | sandals | 2 | 107671 | 40 | 3.216 | 33479.8 |
701 | 2024-02-02 20:35:33 | sandals | 3 | 134027 | 449 | 6.530 | 20524.8 |
700 | 2024-02-02 20:23:43 | sandals | 3 | 134027 | 449 | 8.563 | 15651.9 |
699 | 2024-02-01 03:00:12 | sandals | 2 | 107671 | 40 | 3.623 | 29718.7 |
698 | 2024-01-31 12:28:34 | sandals | 2 | 107671 | 40 | 3.500 | 30763.1 |
697 | 2024-01-17 10:00:19 | sandals | 1 | 69583 | 5 | 1.373 | 50679.5 |
696 | 2024-01-08 02:13:02 | sandals | 3 | 134027 | 449 | 6.080 | 22043.9 |
695 | 2023-12-16 04:33:16 | sandals | 1 | 69583 | 5 | 1.266 | 54962.9 |
694 | 2023-12-14 02:48:26 | sandals | 2 | 107671 | 40 | 3.406 | 31612.2 |
693 | 2023-12-08 12:04:54 | sandals | 3 | 134027 | 449 | 7.736 | 17325.1 |
692 | 2023-12-08 11:59:57 | sandals | 3 | 134027 | 449 | 7.250 | 18486.5 |
691 | 2023-12-08 11:55:25 | sandals | 3 | 134027 | 449 | 22.986 | 5830.8 |
690 | 2023-12-07 14:26:39 | sandals | 2 | 107671 | 40 | 3.610 | 29825.8 |
689 | 2023-12-02 04:00:35 | sandals | 1 | 69583 | 5 | 1.170 | 59472.6 |
688 | 2023-11-26 22:21:24 | sandals | 1 | 69583 | 5 | 1.140 | 61037.7 |
687 | 2023-11-25 20:27:33 | sandals | 1 | 69583 | 5 | 1.173 | 59320.5 |
686 | 2023-11-20 06:06:21 | sandals | 3 | 134027 | 449 | 6.000 | 22337.8 |
685 | 2023-11-19 19:14:52 | sandals | 1 | 69583 | 5 | 1.266 | 54962.9 |
684 | 2023-11-13 17:20:33 | sandals | 1 | 69583 | 5 | 1.250 | 55666.4 |
683 | 2023-11-12 20:16:12 | sandals | 1 | 69583 | 5 | 1.233 | 56433.9 |
682 | 2023-11-11 07:48:16 | sandals | 3 | 134027 | 449 | 8.266 | 16214.3 |
681 | 2023-11-10 21:47:07 | sandals | 2 | 107671 | 40 | 3.313 | 32499.5 |
680 | 2023-11-06 15:58:36 | sandals | 3 | 134027 | 449 | 7.170 | 18692.7 |
679 | 2023-11-01 03:59:09 | sandals | 1 | 69583 | 5 | 1.140 | 61037.7 |
678 | 2023-10-23 10:54:09 | sandals | 1 | 69583 | 5 | 2.283 | 30478.8 |
677 | 2023-10-21 05:34:40 | sandals | 3 | 134027 | 449 | 8.706 | 15394.8 |
676 | 2023-10-16 22:57:31 | sandals | 1 | 69583 | 5 | 1.530 | 45479.1 |
675 | 2023-10-16 00:51:40 | sandals | 3 | 134027 | 449 | 7.143 | 18763.4 |
674 | 2023-10-09 16:21:32 | sandals | 1 | 69583 | 5 | 1.250 | 55666.4 |
673 | 2023-09-29 17:33:55 | sandals | 1 | 69583 | 5 | 1.266 | 54962.9 |
672 | 2023-09-23 21:36:51 | sandals | 1 | 69583 | 5 | 1.233 | 56433.9 |
671 | 2023-09-01 22:52:16 | sandals | 1 | 69583 | 5 | 1.233 | 56433.9 |
670 | 2023-08-14 08:24:46 | sandals | 2 | 107671 | 40 | 3.390 | 31761.4 |
669 | 2023-07-26 17:48:16 | sandals | 3 | 134027 | 449 | 5.873 | 22820.9 |
668 | 2023-07-20 01:12:33 | sandals | 1 | 69583 | 5 | 1.250 | 55666.4 |
667 | 2023-06-05 06:49:45 | sandals | 1 | 69583 | 5 | 1.220 | 57035.2 |
666 | 2023-04-30 00:44:36 | sandals | 2 | 107671 | 40 | 2.920 | 36873.6 |
665 | 2023-04-04 18:02:10 | sandals | 1 | 69583 | 5 | 1.236 | 56296.9 |
664 | 2023-04-04 17:54:42 | sandals | 3 | 134027 | 449 | 5.796 | 23124.1 |
663 | 2023-03-27 09:45:55 | sandals | 1 | 69583 | 5 | 1.233 | 56433.9 |
662 | 2023-02-02 01:26:56 | sandals | 2 | 107671 | 40 | 2.920 | 36873.6 |
661 | 2023-01-12 13:34:38 | sandals | 1 | 69583 | 5 | 1.220 | 57035.2 |
660 | 2023-01-01 14:18:20 | sandals | 3 | 134027 | 449 | 7.186 | 18651.1 |
659 | 2022-12-16 06:06:10 | sandals | 1 | 69583 | 5 | 1.126 | 61796.6 |
658 | 2022-11-14 03:51:28 | sandals | 2 | 107671 | 40 | 3.486 | 30886.7 |
657 | 2022-10-26 16:48:03 | sandals | 1 | 69583 | 5 | 1.186 | 58670.3 |
656 | 2022-09-03 07:19:27 | sandals | 3 | 134027 | 449 | 6.186 | 21666.2 |
655 | 2022-08-19 09:46:39 | sandals | 1 | 69583 | 5 | 1.110 | 62687.4 |
654 | 2022-07-29 09:34:12 | sandals | 1 | 69583 | 5 | 1.123 | 61961.7 |
653 | 2022-06-16 20:13:44 | sandals | 1 | 69583 | 5 | 1.156 | 60192.9 |
652 | 2022-06-16 12:57:59 | sandals | 2 | 107671 | 40 | 2.953 | 36461.6 |
651 | 2022-04-15 11:05:32 | sandals | 1 | 69583 | 5 | 1.343 | 51811.6 |
650 | 2022-02-19 23:54:26 | sandals | 1 | 69583 | 5 | 1.143 | 60877.5 |
649 | 2021-12-27 12:18:02 | sandals | 1 | 69583 | 5 | 1.376 | 50569.0 |
648 | 2021-12-15 11:57:12 | sandals | 1 | 69583 | 5 | 1.250 | 55666.4 |
647 | 2021-10-26 17:35:45 | sandals | 1 | 69583 | 5 | 1.296 | 53690.6 |
646 | 2021-10-04 02:26:11 | sandals | 1 | 69583 | 5 | 1.123 | 61961.7 |
645 | 2021-09-20 09:59:11 | sandals | 1 | 69583 | 5 | 1.140 | 61037.7 |
644 | 2021-06-19 23:08:49 | sandals | 1 | 69583 | 5 | 2.720 | 25582.0 |
643 | 2021-06-17 06:34:42 | sandals | 1 | 69583 | 5 | 1.170 | 59472.6 |
642 | 2021-06-13 19:18:33 | sandals | 1 | 69583 | 5 | 1.140 | 61037.7 |
641 | 2021-03-31 04:05:43 | sandals | 1 | 69583 | 5 | 1.280 | 54361.7 |
640 | 2021-03-10 22:26:48 | sandals | 1 | 69583 | 5 | 1.140 | 61037.7 |
639 | 2021-02-08 22:53:14 | sandals | 1 | 69583 | 5 | 1.123 | 61961.7 |
638 | 2021-01-14 18:50:46 | sandals | 1 | 69583 | 5 | 1.250 | 55666.4 |
637 | 2020-12-26 15:47:54 | sandals | 3 | 134027 | 449 | 6.296 | 21287.6 |
636 | 2020-12-07 16:14:16 | sandals | 1 | 69583 | 5 | 1.236 | 56296.9 |
635 | 2020-11-14 04:47:24 | sandals | 1 | 69583 | 5 | 1.110 | 62687.4 |
634 | 2020-11-08 12:27:00 | sandals | 3 | 134027 | 449 | 6.670 | 20094.0 |
633 | 2020-10-28 23:00:35 | sandals | 1 | 69583 | 5 | 2.093 | 33245.6 |
632 | 2020-10-27 19:23:35 | sandals | 1 | 69583 | 5 | 1.156 | 60192.9 |
631 | 2020-10-27 15:05:49 | sandals | 2 | 107671 | 40 | 3.200 | 33647.2 |
630 | 2020-10-26 01:46:24 | sandals | 1 | 69583 | 5 | 1.283 | 54234.6 |
629 | 2020-09-13 17:37:29 | sandals | 1 | 69583 | 5 | 1.250 | 55666.4 |
628 | 2020-09-10 10:54:36 | sandals | 1 | 69583 | 5 | 1.123 | 61961.7 |
627 | 2020-09-01 06:14:15 | sandals | 1 | 69583 | 5 | 1.140 | 61037.7 |
626 | 2020-07-27 22:31:34 | sandals | 1 | 69583 | 5 | 1.186 | 58670.3 |
625 | 2020-07-21 11:39:18 | sandals | 1 | 69583 | 5 | 1.673 | 41591.8 |
624 | 2020-05-30 13:06:41 | sandals | 1 | 69583 | 5 | 1.173 | 59320.5 |
623 | 2020-05-04 10:11:44 | sandals | 1 | 69583 | 5 | 1.266 | 54962.9 |
622 | 2020-03-28 09:34:57 | sandals | 1 | 69583 | 5 | 2.623 | 26528.0 |
621 | 2020-03-24 16:39:48 | sandals | 1 | 69583 | 5 | 1.266 | 54962.9 |
620 | 2020-03-21 18:40:24 | sandals | 1 | 69583 | 5 | 1.266 | 54962.9 |
619 | 2020-03-19 20:24:12 | sandals | 1 | 69583 | 5 | 1.126 | 61796.6 |
618 | 2020-02-29 06:04:10 | sandals | 1 | 69583 | 5 | 1.250 | 55666.4 |
617 | 2020-02-27 05:58:32 | sandals | 1 | 69583 | 5 | 1.466 | 47464.5 |
616 | 2020-02-24 12:37:07 | sandals | 1 | 69583 | 5 | 1.123 | 61961.7 |