History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gravel"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
710 | 2024-04-04 08:09:02 | gravel | 1 | 48755 | 12 | 1.843 | 26454.2 |
709 | 2024-04-03 19:40:35 | gravel | 3 | 112716 | 749 | 9.033 | 12478.2 |
708 | 2024-04-03 11:51:45 | gravel | 3 | 112716 | 749 | 13.343 | 8447.6 |
707 | 2024-04-03 11:51:43 | gravel | 2 | 82551 | 85 | 9.390 | 8791.4 |
706 | 2024-04-03 11:51:39 | gravel | 1 | 48755 | 12 | 3.860 | 12630.8 |
705 | 2024-03-28 20:20:32 | gravel | 1 | 48755 | 12 | 0.856 | 56956.8 |
704 | 2024-03-14 10:46:00 | gravel | 3 | 112716 | 749 | 10.093 | 11167.7 |
703 | 2024-03-12 13:56:32 | gravel | 3 | 112716 | 749 | 4.703 | 23966.8 |
702 | 2024-03-04 20:34:20 | gravel | 2 | 82551 | 85 | 2.640 | 31269.3 |
701 | 2024-03-04 20:33:42 | gravel | 3 | 112716 | 749 | 5.720 | 19705.6 |
700 | 2024-03-04 14:19:30 | gravel | 3 | 112716 | 749 | 10.046 | 11220.0 |
699 | 2024-03-04 14:19:32 | gravel | 2 | 82551 | 85 | 4.343 | 19007.8 |
698 | 2024-03-04 14:12:36 | gravel | 2 | 82551 | 85 | 5.486 | 15047.6 |
697 | 2024-03-04 14:12:32 | gravel | 1 | 48755 | 12 | 0.873 | 55847.7 |
696 | 2024-03-04 14:09:24 | gravel | 3 | 112716 | 749 | 6.406 | 17595.4 |
695 | 2024-03-04 08:21:08 | gravel | 3 | 112716 | 749 | 9.013 | 12505.9 |
694 | 2024-03-04 08:21:10 | gravel | 2 | 82551 | 85 | 2.966 | 27832.4 |
693 | 2024-03-04 08:21:06 | gravel | 1 | 48755 | 12 | 1.203 | 40527.8 |
692 | 2024-01-09 09:22:17 | gravel | 2 | 82551 | 85 | 2.373 | 34787.6 |
691 | 2024-01-07 18:39:51 | gravel | 3 | 112716 | 749 | 5.440 | 20719.9 |
690 | 2023-12-24 01:39:00 | gravel | 1 | 48755 | 12 | 0.736 | 66243.2 |
689 | 2023-12-21 06:53:02 | gravel | 2 | 82551 | 85 | 2.186 | 37763.5 |
688 | 2023-12-17 04:41:23 | gravel | 3 | 112716 | 749 | 8.206 | 13735.8 |
687 | 2023-11-25 02:41:35 | gravel | 2 | 82551 | 85 | 2.423 | 34069.7 |
686 | 2023-11-25 02:38:06 | gravel | 3 | 112716 | 749 | 5.486 | 20546.1 |
685 | 2023-11-24 01:52:32 | gravel | 3 | 112716 | 749 | 5.016 | 22471.3 |
684 | 2023-11-14 20:24:12 | gravel | 1 | 48755 | 12 | 0.750 | 65006.7 |
683 | 2023-11-12 05:16:35 | gravel | 1 | 48755 | 12 | 0.846 | 57630.0 |
682 | 2023-10-30 19:19:34 | gravel | 1 | 48755 | 12 | 0.873 | 55847.7 |
681 | 2023-10-27 17:42:06 | gravel | 1 | 48755 | 12 | 1.516 | 32160.3 |
680 | 2023-10-27 08:49:07 | gravel | 1 | 48755 | 12 | 0.876 | 55656.4 |
679 | 2023-10-19 07:12:38 | gravel | 1 | 48755 | 12 | 0.860 | 56691.9 |
678 | 2023-10-12 08:47:55 | gravel | 1 | 48755 | 12 | 0.766 | 63648.8 |
677 | 2023-10-11 17:12:29 | gravel | 1 | 48755 | 12 | 0.826 | 59025.4 |
676 | 2023-10-08 19:58:38 | gravel | 1 | 48755 | 12 | 0.780 | 62506.4 |
675 | 2023-09-26 18:46:32 | gravel | 1 | 48755 | 12 | 0.860 | 56691.9 |
674 | 2023-09-23 10:49:48 | gravel | 1 | 48755 | 12 | 0.796 | 61250.0 |
673 | 2023-08-24 14:09:18 | gravel | 3 | 112716 | 749 | 4.766 | 23650.0 |
672 | 2023-08-08 16:04:02 | gravel | 1 | 48755 | 12 | 0.736 | 66243.2 |
671 | 2023-07-03 19:12:06 | gravel | 1 | 48755 | 12 | 1.063 | 45865.5 |
670 | 2023-05-28 13:31:29 | gravel | 3 | 112716 | 749 | 4.640 | 24292.2 |
669 | 2023-05-11 03:03:30 | gravel | 3 | 112716 | 749 | 4.623 | 24381.6 |
668 | 2023-05-07 22:52:25 | gravel | 1 | 48755 | 12 | 0.733 | 66514.3 |
667 | 2023-04-07 15:23:32 | gravel | 3 | 112716 | 749 | 5.156 | 21861.1 |
666 | 2023-03-21 11:50:49 | gravel | 3 | 112716 | 749 | 4.580 | 24610.5 |
665 | 2023-03-15 07:12:41 | gravel | 3 | 112716 | 749 | 4.750 | 23729.7 |
664 | 2023-03-10 14:29:59 | gravel | 1 | 48755 | 12 | 0.783 | 62266.9 |
663 | 2023-03-01 02:13:02 | gravel | 1 | 48755 | 12 | 0.843 | 57835.1 |
662 | 2023-02-18 06:36:30 | gravel | 3 | 112716 | 749 | 5.266 | 21404.5 |
661 | 2022-12-27 00:26:02 | gravel | 1 | 48755 | 12 | 0.720 | 67715.3 |
660 | 2022-12-01 02:24:33 | gravel | 3 | 112716 | 749 | 4.623 | 24381.6 |
659 | 2022-11-15 07:55:02 | gravel | 1 | 48755 | 12 | 0.736 | 66243.2 |
658 | 2022-09-17 20:06:58 | gravel | 1 | 48755 | 12 | 0.750 | 65006.7 |
657 | 2022-09-15 08:01:34 | gravel | 1 | 48755 | 12 | 0.813 | 59969.2 |
656 | 2022-09-10 15:18:19 | gravel | 1 | 48755 | 12 | 0.750 | 65006.7 |
655 | 2022-09-02 17:21:23 | gravel | 1 | 48755 | 12 | 0.796 | 61250.0 |
654 | 2022-08-31 02:53:24 | gravel | 1 | 48755 | 12 | 0.736 | 66243.2 |
653 | 2022-07-22 11:07:11 | gravel | 1 | 48755 | 12 | 0.796 | 61250.0 |
652 | 2022-04-25 13:19:00 | gravel | 1 | 48755 | 12 | 0.783 | 62266.9 |
651 | 2022-04-19 19:50:26 | gravel | 3 | 112716 | 749 | 5.530 | 20382.6 |
650 | 2022-04-04 02:16:56 | gravel | 1 | 48755 | 12 | 0.720 | 67715.3 |
649 | 2022-01-18 23:46:58 | gravel | 1 | 48755 | 12 | 0.796 | 61250.0 |
648 | 2021-12-25 06:47:23 | gravel | 3 | 112716 | 749 | 5.606 | 20106.3 |
647 | 2021-12-20 08:05:32 | gravel | 1 | 48755 | 12 | 0.843 | 57835.1 |
646 | 2021-11-16 17:55:07 | gravel | 1 | 48755 | 12 | 0.766 | 63648.8 |
645 | 2021-11-14 17:37:31 | gravel | 1 | 48755 | 12 | 0.856 | 56956.8 |
644 | 2021-09-26 01:38:21 | gravel | 1 | 48755 | 12 | 0.750 | 65006.7 |
643 | 2021-09-23 21:54:28 | gravel | 1 | 48755 | 12 | 0.733 | 66514.3 |
642 | 2021-09-21 13:48:02 | gravel | 1 | 48755 | 12 | 0.813 | 59969.2 |
641 | 2021-09-20 14:30:24 | gravel | 1 | 48755 | 12 | 0.890 | 54780.9 |
640 | 2021-09-09 21:09:47 | gravel | 1 | 48755 | 12 | 0.780 | 62506.4 |
639 | 2021-09-06 16:05:52 | gravel | 1 | 48755 | 12 | 0.733 | 66514.3 |
638 | 2021-09-04 11:41:16 | gravel | 1 | 48755 | 12 | 0.796 | 61250.0 |
637 | 2021-06-08 23:01:21 | gravel | 1 | 48755 | 12 | 0.766 | 63648.8 |
636 | 2021-06-06 01:34:56 | gravel | 3 | 112716 | 749 | 5.453 | 20670.5 |
635 | 2021-05-20 15:52:08 | gravel | 1 | 48755 | 12 | 0.830 | 58741.0 |
634 | 2021-04-20 19:25:17 | gravel | 1 | 48755 | 12 | 0.783 | 62266.9 |
633 | 2021-04-10 19:59:30 | gravel | 3 | 112716 | 749 | 5.453 | 20670.5 |
632 | 2021-03-23 11:02:36 | gravel | 1 | 48755 | 12 | 0.843 | 57835.1 |
631 | 2021-03-18 22:06:58 | gravel | 3 | 112716 | 749 | 4.670 | 24136.2 |
630 | 2021-03-09 23:02:49 | gravel | 1 | 48755 | 12 | 0.826 | 59025.4 |
629 | 2021-02-20 15:40:29 | gravel | 1 | 48755 | 12 | 0.843 | 57835.1 |
628 | 2021-02-18 02:38:13 | gravel | 3 | 112716 | 749 | 4.890 | 23050.3 |
627 | 2021-02-14 04:16:06 | gravel | 3 | 112716 | 749 | 5.483 | 20557.4 |
626 | 2021-02-11 09:07:35 | gravel | 1 | 48755 | 12 | 0.750 | 65006.7 |
625 | 2021-01-05 12:06:27 | gravel | 1 | 48755 | 12 | 0.733 | 66514.3 |
624 | 2020-12-06 13:09:06 | gravel | 1 | 48755 | 12 | 0.796 | 61250.0 |
623 | 2020-11-07 04:24:14 | gravel | 3 | 112716 | 749 | 4.873 | 23130.7 |
622 | 2020-10-05 17:40:14 | gravel | 1 | 48755 | 12 | 0.736 | 66243.2 |
621 | 2020-10-03 21:00:25 | gravel | 1 | 48755 | 12 | 0.733 | 66514.3 |
620 | 2020-08-31 09:10:39 | gravel | 1 | 48755 | 12 | 0.830 | 58741.0 |
619 | 2020-08-01 17:04:56 | gravel | 1 | 48755 | 12 | 0.750 | 65006.7 |
618 | 2020-07-31 11:17:20 | gravel | 1 | 48755 | 12 | 0.763 | 63899.1 |
617 | 2020-07-13 18:59:09 | gravel | 1 | 48755 | 12 | 0.813 | 59969.2 |
616 | 2020-06-16 07:52:56 | gravel | 1 | 48755 | 12 | 0.733 | 66514.3 |
615 | 2020-05-26 14:45:51 | gravel | 1 | 48755 | 12 | 0.826 | 59025.4 |
614 | 2020-03-28 16:48:58 | gravel | 1 | 48755 | 12 | 1.716 | 28412.0 |
613 | 2020-03-23 17:44:50 | gravel | 1 | 48755 | 12 | 0.800 | 60943.8 |
612 | 2020-03-23 10:03:28 | gravel | 1 | 48755 | 12 | 1.313 | 37132.5 |
611 | 2020-03-22 03:16:25 | gravel | 1 | 48755 | 12 | 0.906 | 53813.5 |