History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clayey"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
686 | 2024-05-04 19:00:07 | clayey | 1 | 48755 | 2 | 0.826 | 59025.4 |
685 | 2024-05-01 10:21:33 | clayey | 2 | 82551 | 33 | 2.516 | 32810.4 |
684 | 2024-05-01 10:21:07 | clayey | 2 | 82551 | 33 | 3.876 | 21298.0 |
683 | 2024-05-01 10:21:02 | clayey | 3 | 112716 | 627 | 6.313 | 17854.6 |
682 | 2024-05-01 10:20:58 | clayey | 1 | 48755 | 2 | 0.876 | 55656.4 |
681 | 2024-05-01 10:20:29 | clayey | 3 | 112716 | 627 | 6.546 | 17219.1 |
680 | 2024-05-01 08:08:41 | clayey | 1 | 48755 | 2 | 1.013 | 48129.3 |
679 | 2024-05-01 00:40:09 | clayey | 3 | 112716 | 627 | 18.846 | 5980.9 |
678 | 2024-05-01 00:40:19 | clayey | 2 | 82551 | 33 | 8.986 | 9186.6 |
677 | 2024-05-01 00:40:20 | clayey | 1 | 48755 | 2 | 1.626 | 29984.6 |
676 | 2024-04-27 10:56:51 | clayey | 1 | 48755 | 2 | 0.923 | 52822.3 |
675 | 2024-04-08 02:51:49 | clayey | 1 | 48755 | 2 | 0.873 | 55847.7 |
674 | 2024-04-05 00:49:49 | clayey | 1 | 48755 | 2 | 3.903 | 12491.7 |
673 | 2024-03-28 19:50:48 | clayey | 1 | 48755 | 2 | 0.970 | 50262.9 |
672 | 2024-01-31 15:59:11 | clayey | 2 | 82551 | 33 | 2.546 | 32423.8 |
671 | 2024-01-29 05:38:41 | clayey | 3 | 112716 | 627 | 5.156 | 21861.1 |
670 | 2024-01-29 05:38:37 | clayey | 2 | 82551 | 33 | 2.390 | 34540.2 |
669 | 2024-01-21 14:54:27 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
668 | 2024-01-15 04:08:25 | clayey | 3 | 112716 | 627 | 5.940 | 18975.8 |
667 | 2024-01-15 04:08:24 | clayey | 2 | 82551 | 33 | 2.533 | 32590.2 |
666 | 2023-12-21 18:33:04 | clayey | 1 | 48755 | 2 | 0.766 | 63648.8 |
665 | 2023-11-26 03:45:31 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
664 | 2023-11-17 16:11:00 | clayey | 1 | 48755 | 2 | 0.796 | 61250.0 |
663 | 2023-11-12 00:24:56 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
662 | 2023-10-25 06:48:59 | clayey | 1 | 48755 | 2 | 0.813 | 59969.2 |
661 | 2023-10-21 10:36:54 | clayey | 1 | 48755 | 2 | 1.466 | 33257.2 |
660 | 2023-10-19 08:43:29 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
659 | 2023-10-11 07:15:34 | clayey | 1 | 48755 | 2 | 0.860 | 56691.9 |
658 | 2023-10-07 00:53:39 | clayey | 1 | 48755 | 2 | 0.843 | 57835.1 |
657 | 2023-10-05 03:00:30 | clayey | 1 | 48755 | 2 | 0.763 | 63899.1 |
656 | 2023-09-25 22:20:20 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
655 | 2023-09-14 11:49:52 | clayey | 1 | 48755 | 2 | 0.733 | 66514.3 |
654 | 2023-08-02 05:55:10 | clayey | 2 | 82551 | 33 | 2.156 | 38289.0 |
653 | 2023-06-30 19:31:57 | clayey | 1 | 48755 | 2 | 0.860 | 56691.9 |
652 | 2023-04-09 02:47:36 | clayey | 2 | 82551 | 33 | 2.093 | 39441.5 |
651 | 2023-03-11 06:42:36 | clayey | 1 | 48755 | 2 | 0.830 | 58741.0 |
650 | 2023-01-06 17:04:24 | clayey | 2 | 82551 | 33 | 4.236 | 19488.0 |
649 | 2022-11-19 14:47:00 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
648 | 2022-11-16 02:09:28 | clayey | 1 | 48755 | 2 | 0.860 | 56691.9 |
647 | 2022-09-11 19:25:31 | clayey | 2 | 82551 | 33 | 2.143 | 38521.2 |
646 | 2022-09-05 20:29:58 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
645 | 2022-09-01 06:49:14 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
644 | 2022-07-26 21:15:22 | clayey | 1 | 48755 | 2 | 0.846 | 57630.0 |
643 | 2022-07-11 12:33:06 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
642 | 2022-03-28 22:35:26 | clayey | 2 | 82551 | 33 | 2.453 | 33653.1 |
641 | 2022-03-28 21:33:50 | clayey | 1 | 48755 | 2 | 0.860 | 56691.9 |
640 | 2022-03-11 22:08:10 | clayey | 1 | 48755 | 2 | 1.033 | 47197.5 |
639 | 2021-12-20 02:10:24 | clayey | 1 | 48755 | 2 | 0.796 | 61250.0 |
638 | 2021-12-18 00:15:55 | clayey | 1 | 48755 | 2 | 0.893 | 54596.9 |
637 | 2021-12-15 21:59:13 | clayey | 1 | 48755 | 2 | 0.890 | 54780.9 |
636 | 2021-12-14 14:03:26 | clayey | 1 | 48755 | 2 | 0.736 | 66243.2 |
635 | 2021-12-13 16:27:36 | clayey | 2 | 82551 | 33 | 2.140 | 38575.2 |
634 | 2021-11-04 08:54:20 | clayey | 1 | 48755 | 2 | 0.766 | 63648.8 |
633 | 2021-10-14 17:56:14 | clayey | 2 | 82551 | 33 | 2.513 | 32849.6 |
632 | 2021-09-07 07:24:09 | clayey | 1 | 48755 | 2 | 0.826 | 59025.4 |
631 | 2021-09-02 04:02:45 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
630 | 2021-07-27 20:06:02 | clayey | 1 | 48755 | 2 | 0.733 | 66514.3 |
629 | 2021-06-06 09:10:21 | clayey | 1 | 48755 | 2 | 0.906 | 53813.5 |
628 | 2021-06-03 04:25:58 | clayey | 1 | 48755 | 2 | 0.876 | 55656.4 |
627 | 2021-05-18 21:36:32 | clayey | 1 | 48755 | 2 | 0.846 | 57630.0 |
626 | 2021-04-18 20:36:10 | clayey | 1 | 48755 | 2 | 0.830 | 58741.0 |
625 | 2021-03-21 16:27:11 | clayey | 1 | 48755 | 2 | 1.733 | 28133.3 |
624 | 2021-02-28 16:59:42 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
623 | 2021-01-03 10:23:53 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
622 | 2020-12-06 12:09:01 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
621 | 2020-11-24 05:52:11 | clayey | 1 | 48755 | 2 | 0.750 | 65006.7 |
620 | 2020-11-04 21:46:10 | clayey | 1 | 48755 | 2 | 0.876 | 55656.4 |
619 | 2020-10-27 21:33:16 | clayey | 1 | 48755 | 2 | 1.013 | 48129.3 |
618 | 2020-10-23 14:00:54 | clayey | 1 | 48755 | 2 | 0.766 | 63648.8 |
617 | 2020-08-16 04:48:14 | clayey | 1 | 48755 | 2 | 0.873 | 55847.7 |
616 | 2020-08-10 15:50:14 | clayey | 1 | 48755 | 2 | 0.780 | 62506.4 |
615 | 2020-08-09 15:08:47 | clayey | 1 | 48755 | 2 | 0.843 | 57835.1 |
614 | 2020-08-09 11:02:12 | clayey | 1 | 48755 | 2 | 0.783 | 62266.9 |
613 | 2020-05-14 21:41:08 | clayey | 1 | 48755 | 2 | 0.780 | 62506.4 |
612 | 2020-03-28 15:58:08 | clayey | 1 | 48755 | 2 | 0.953 | 51159.5 |
611 | 2020-03-28 13:51:43 | clayey | 1 | 48755 | 2 | 0.906 | 53813.5 |
610 | 2020-03-28 10:08:00 | clayey | 1 | 48755 | 2 | 1.263 | 38602.5 |
609 | 2020-03-24 11:14:11 | clayey | 1 | 48755 | 2 | 0.860 | 56691.9 |
608 | 2020-03-23 17:14:34 | clayey | 1 | 48755 | 2 | 0.826 | 59025.4 |
607 | 2020-03-20 18:50:38 | clayey | 1 | 48755 | 2 | 0.860 | 56691.9 |
606 | 2020-02-23 20:28:55 | clayey | 1 | 48755 | 2 | 1.810 | 26936.5 |
605 | 2020-02-23 15:12:11 | clayey | 3 | 112716 | 627 | 12.080 | 9330.8 |
604 | 2020-02-22 12:44:32 | clayey | 1 | 48755 | 2 | 1.843 | 26454.2 |
603 | 2020-02-19 04:42:36 | clayey | 3 | 112716 | 627 | 14.796 | 7618.0 |
602 | 2020-02-14 20:26:29 | clayey | 1 | 48755 | 2 | 0.953 | 51159.5 |
601 | 2020-02-12 06:43:01 | clayey | 1 | 48755 | 2 | 0.923 | 52822.3 |
600 | 2020-02-11 12:29:23 | clayey | 1 | 48755 | 2 | 0.936 | 52088.7 |
599 | 2020-02-09 08:47:23 | clayey | 1 | 48755 | 2 | 1.890 | 25796.3 |
598 | 2020-01-29 17:27:50 | clayey | 1 | 48755 | 2 | 0.830 | 58741.0 |
597 | 2020-01-27 11:41:40 | clayey | 1 | 48755 | 2 | 0.860 | 56691.9 |
596 | 2020-01-26 18:43:31 | clayey | 3 | 112716 | 627 | 7.640 | 14753.4 |
595 | 2020-01-25 18:36:10 | clayey | 3 | 112716 | 627 | 7.063 | 15958.7 |
594 | 2020-01-25 04:57:38 | clayey | 3 | 112716 | 627 | 6.530 | 17261.3 |
593 | 2020-01-25 04:18:41 | clayey | 3 | 112716 | 627 | 15.860 | 7106.9 |
592 | 2020-01-25 03:19:57 | clayey | 3 | 112716 | 627 | 14.876 | 7577.0 |
591 | 2020-01-24 22:48:26 | clayey | 3 | 112716 | 627 | 15.670 | 7193.1 |
590 | 2020-01-20 21:40:33 | clayey | 1 | 48755 | 2 | 2.046 | 23829.4 |
589 | 2020-01-19 19:30:07 | clayey | 1 | 48755 | 2 | 0.923 | 52822.3 |
588 | 2020-01-19 01:34:35 | clayey | 1 | 48755 | 2 | 0.920 | 52994.6 |
587 | 2020-01-18 06:57:50 | clayey | 1 | 48755 | 2 | 0.873 | 55847.7 |