History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sandal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
711 | 2024-04-05 23:46:57 | sandal | 1 | 48755 | 5 | 3.423 | 14243.4 |
710 | 2024-03-24 00:35:54 | sandal | 1 | 48755 | 5 | 0.783 | 62266.9 |
709 | 2024-03-06 23:43:56 | sandal | 1 | 48755 | 5 | 2.030 | 24017.2 |
708 | 2024-02-28 05:19:36 | sandal | 3 | 112716 | 583 | 12.470 | 9039.0 |
707 | 2024-02-28 01:43:23 | sandal | 2 | 82551 | 55 | 2.843 | 29036.6 |
706 | 2024-02-28 00:20:21 | sandal | 3 | 112716 | 583 | 5.733 | 19660.9 |
705 | 2024-02-28 00:20:22 | sandal | 2 | 82551 | 55 | 2.626 | 31436.0 |
704 | 2024-02-28 00:20:18 | sandal | 1 | 48755 | 5 | 0.860 | 56691.9 |
703 | 2024-02-12 07:07:53 | sandal | 2 | 82551 | 55 | 2.970 | 27794.9 |
702 | 2024-01-22 11:27:10 | sandal | 3 | 112716 | 583 | 12.313 | 9154.2 |
701 | 2024-01-18 13:10:33 | sandal | 1 | 48755 | 5 | 0.890 | 54780.9 |
700 | 2024-01-16 18:16:54 | sandal | 3 | 112716 | 583 | 5.440 | 20719.9 |
699 | 2024-01-04 02:26:31 | sandal | 2 | 82551 | 55 | 2.486 | 33206.4 |
698 | 2024-01-02 04:13:22 | sandal | 2 | 82551 | 55 | 2.283 | 36159.0 |
697 | 2023-12-25 19:10:50 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
696 | 2023-12-07 10:28:04 | sandal | 1 | 48755 | 5 | 0.783 | 62266.9 |
695 | 2023-12-07 10:28:03 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
694 | 2023-12-07 09:45:45 | sandal | 1 | 48755 | 5 | 0.876 | 55656.4 |
693 | 2023-11-17 20:01:43 | sandal | 1 | 48755 | 5 | 0.910 | 53576.9 |
692 | 2023-11-15 22:30:12 | sandal | 1 | 48755 | 5 | 0.890 | 54780.9 |
691 | 2023-11-13 19:39:25 | sandal | 2 | 82551 | 55 | 2.236 | 36919.1 |
690 | 2023-11-08 11:31:35 | sandal | 1 | 48755 | 5 | 0.920 | 52994.6 |
689 | 2023-11-08 08:09:28 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
688 | 2023-11-05 07:58:20 | sandal | 1 | 48755 | 5 | 0.893 | 54596.9 |
687 | 2023-11-04 01:44:23 | sandal | 1 | 48755 | 5 | 0.953 | 51159.5 |
686 | 2023-11-03 19:21:35 | sandal | 1 | 48755 | 5 | 0.906 | 53813.5 |
685 | 2023-11-02 11:15:14 | sandal | 1 | 48755 | 5 | 0.966 | 50471.0 |
684 | 2023-10-15 13:17:02 | sandal | 1 | 48755 | 5 | 0.923 | 52822.3 |
683 | 2023-09-26 07:11:24 | sandal | 1 | 48755 | 5 | 1.126 | 43299.3 |
682 | 2023-09-15 16:57:17 | sandal | 1 | 48755 | 5 | 0.783 | 62266.9 |
681 | 2023-09-03 09:43:11 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
680 | 2023-08-16 00:26:20 | sandal | 2 | 82551 | 55 | 2.330 | 35429.6 |
679 | 2023-07-10 06:40:28 | sandal | 1 | 48755 | 5 | 0.873 | 55847.7 |
678 | 2023-04-30 05:02:44 | sandal | 2 | 82551 | 55 | 2.530 | 32628.9 |
677 | 2023-03-19 14:24:33 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
676 | 2023-03-15 01:04:22 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
675 | 2023-02-04 09:29:22 | sandal | 2 | 82551 | 55 | 2.720 | 30349.6 |
674 | 2023-01-02 08:58:34 | sandal | 1 | 48755 | 5 | 0.766 | 63648.8 |
673 | 2022-11-24 21:53:00 | sandal | 1 | 48755 | 5 | 0.890 | 54780.9 |
672 | 2022-11-15 20:35:30 | sandal | 2 | 82551 | 55 | 2.280 | 36206.6 |
671 | 2022-09-23 22:22:31 | sandal | 1 | 48755 | 5 | 1.093 | 44606.6 |
670 | 2022-09-17 00:19:01 | sandal | 1 | 48755 | 5 | 0.796 | 61250.0 |
669 | 2022-09-10 21:24:12 | sandal | 1 | 48755 | 5 | 0.766 | 63648.8 |
668 | 2022-09-01 09:49:18 | sandal | 1 | 48755 | 5 | 0.873 | 55847.7 |
667 | 2022-07-29 08:01:46 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
666 | 2022-07-28 16:26:30 | sandal | 1 | 48755 | 5 | 0.813 | 59969.2 |
665 | 2022-07-19 06:14:30 | sandal | 2 | 82551 | 55 | 2.233 | 36968.7 |
664 | 2022-06-20 00:42:03 | sandal | 1 | 48755 | 5 | 0.830 | 58741.0 |
663 | 2022-06-17 07:11:59 | sandal | 2 | 82551 | 55 | 2.206 | 37421.1 |
662 | 2022-05-06 13:49:06 | sandal | 1 | 48755 | 5 | 0.830 | 58741.0 |
661 | 2022-05-06 09:39:23 | sandal | 1 | 48755 | 5 | 0.986 | 49447.3 |
660 | 2022-04-06 14:38:34 | sandal | 1 | 48755 | 5 | 0.920 | 52994.6 |
659 | 2022-01-29 21:17:27 | sandal | 2 | 82551 | 55 | 4.186 | 19720.7 |
658 | 2022-01-27 17:47:35 | sandal | 1 | 48755 | 5 | 0.860 | 56691.9 |
657 | 2021-12-19 11:11:46 | sandal | 1 | 48755 | 5 | 0.890 | 54780.9 |
656 | 2021-11-21 00:19:14 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
655 | 2021-10-21 03:51:56 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
654 | 2021-09-22 10:54:49 | sandal | 1 | 48755 | 5 | 0.920 | 52994.6 |
653 | 2021-09-21 05:07:31 | sandal | 1 | 48755 | 5 | 1.016 | 47987.2 |
652 | 2021-09-15 03:42:36 | sandal | 1 | 48755 | 5 | 0.920 | 52994.6 |
651 | 2021-09-12 06:02:56 | sandal | 1 | 48755 | 5 | 0.936 | 52088.7 |
650 | 2021-06-11 23:41:22 | sandal | 1 | 48755 | 5 | 0.783 | 62266.9 |
649 | 2021-06-05 11:06:32 | sandal | 1 | 48755 | 5 | 0.890 | 54780.9 |
648 | 2021-05-11 10:59:20 | sandal | 1 | 48755 | 5 | 0.843 | 57835.1 |
647 | 2021-03-12 14:25:44 | sandal | 1 | 48755 | 5 | 0.796 | 61250.0 |
646 | 2021-02-27 23:28:58 | sandal | 2 | 82551 | 55 | 2.376 | 34743.7 |
645 | 2021-01-28 04:58:46 | sandal | 1 | 48755 | 5 | 0.800 | 60943.8 |
644 | 2021-01-24 15:45:28 | sandal | 1 | 48755 | 5 | 0.876 | 55656.4 |
643 | 2020-12-09 10:08:10 | sandal | 1 | 48755 | 5 | 0.890 | 54780.9 |
642 | 2020-12-09 09:51:59 | sandal | 1 | 48755 | 5 | 0.826 | 59025.4 |
641 | 2020-11-09 03:40:09 | sandal | 1 | 48755 | 5 | 0.783 | 62266.9 |
640 | 2020-10-28 08:46:17 | sandal | 1 | 48755 | 5 | 0.906 | 53813.5 |
639 | 2020-10-23 08:44:56 | sandal | 1 | 48755 | 5 | 0.920 | 52994.6 |
638 | 2020-10-16 04:32:57 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
637 | 2020-10-14 09:18:04 | sandal | 1 | 48755 | 5 | 0.783 | 62266.9 |
636 | 2020-10-10 01:14:57 | sandal | 1 | 48755 | 5 | 0.780 | 62506.4 |
635 | 2020-09-02 18:53:35 | sandal | 1 | 48755 | 5 | 0.810 | 60191.4 |
634 | 2020-07-25 10:47:24 | sandal | 1 | 48755 | 5 | 0.890 | 54780.9 |
633 | 2020-05-25 20:31:32 | sandal | 1 | 48755 | 5 | 0.783 | 62266.9 |
632 | 2020-04-25 04:28:28 | sandal | 1 | 48755 | 5 | 0.796 | 61250.0 |
631 | 2020-03-28 21:25:53 | sandal | 1 | 48755 | 5 | 0.953 | 51159.5 |
630 | 2020-03-26 13:24:57 | sandal | 1 | 48755 | 5 | 0.906 | 53813.5 |
629 | 2020-03-23 14:10:08 | sandal | 1 | 48755 | 5 | 1.076 | 45311.3 |
628 | 2020-03-23 04:08:02 | sandal | 1 | 48755 | 5 | 0.936 | 52088.7 |
627 | 2020-03-21 11:23:48 | sandal | 1 | 48755 | 5 | 0.843 | 57835.1 |
626 | 2020-03-18 03:06:10 | sandal | 1 | 48755 | 5 | 0.940 | 51867.0 |
625 | 2020-02-25 20:55:39 | sandal | 1 | 48755 | 5 | 1.013 | 48129.3 |
624 | 2020-02-25 18:05:53 | sandal | 1 | 48755 | 5 | 1.126 | 43299.3 |
623 | 2020-02-25 13:41:48 | sandal | 1 | 48755 | 5 | 0.873 | 55847.7 |
622 | 2020-02-23 05:00:22 | sandal | 1 | 48755 | 5 | 0.796 | 61250.0 |
621 | 2020-02-23 01:39:15 | sandal | 1 | 48755 | 5 | 0.936 | 52088.7 |
620 | 2020-02-19 02:00:55 | sandal | 1 | 48755 | 5 | 1.110 | 43923.4 |
619 | 2020-02-14 05:12:38 | sandal | 1 | 48755 | 5 | 1.030 | 47335.0 |
618 | 2020-02-10 07:07:17 | sandal | 1 | 48755 | 5 | 1.000 | 48755.0 |
617 | 2020-02-02 02:02:27 | sandal | 1 | 48755 | 5 | 2.123 | 22965.1 |
616 | 2020-01-30 04:17:45 | sandal | 1 | 48755 | 5 | 1.576 | 30935.9 |
615 | 2020-01-29 17:49:40 | sandal | 1 | 48755 | 5 | 3.033 | 16074.8 |
614 | 2020-01-24 19:29:56 | sandal | 1 | 48755 | 5 | 1.000 | 48755.0 |
613 | 2020-01-23 17:35:52 | sandal | 1 | 48755 | 5 | 2.140 | 22782.7 |
612 | 2020-01-22 00:44:31 | sandal | 1 | 48755 | 5 | 2.030 | 24017.2 |