History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"apricot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
690 | 2024-04-17 21:45:54 | apricot | 4 | 151207 | 1055 | 26.783 | 5645.6 |
689 | 2024-04-17 13:35:13 | apricot | 2 | 107671 | 5 | 3.640 | 29579.9 |
688 | 2024-04-17 13:33:56 | apricot | 3 | 134027 | 83 | 8.970 | 14941.7 |
687 | 2024-04-17 13:18:51 | apricot | 4 | 151207 | 1055 | 14.816 | 10205.7 |
686 | 2024-04-16 08:04:10 | apricot | 4 | 151207 | 1055 | 22.190 | 6814.2 |
685 | 2024-04-16 04:59:55 | apricot | 4 | 151207 | 1055 | 44.376 | 3407.4 |
684 | 2024-04-16 04:59:55 | apricot | 2 | 107671 | 5 | 9.033 | 11919.7 |
683 | 2024-04-16 04:59:32 | apricot | 3 | 134027 | 83 | 8.843 | 15156.3 |
682 | 2024-04-15 10:52:39 | apricot | 3 | 134027 | 83 | 24.563 | 5456.5 |
681 | 2024-04-15 09:08:19 | apricot | 3 | 134027 | 83 | 5.920 | 22639.7 |
680 | 2024-04-05 17:39:19 | apricot | 1 | 69583 | 2 | 2.500 | 27833.2 |
679 | 2024-03-05 19:09:41 | apricot | 4 | 151207 | 1055 | 45.206 | 3344.8 |
678 | 2024-03-05 13:27:45 | apricot | 2 | 107671 | 5 | 3.690 | 29179.1 |
677 | 2024-03-05 13:27:32 | apricot | 3 | 134027 | 83 | 7.406 | 18097.1 |
676 | 2024-03-05 09:12:54 | apricot | 4 | 151207 | 1055 | 19.266 | 7848.4 |
675 | 2024-03-04 12:52:44 | apricot | 4 | 151207 | 1055 | 32.533 | 4647.8 |
674 | 2024-03-04 12:44:05 | apricot | 4 | 151207 | 1055 | 25.376 | 5958.7 |
673 | 2024-03-04 10:43:23 | apricot | 4 | 151207 | 1055 | 40.596 | 3724.7 |
672 | 2024-03-04 09:52:37 | apricot | 3 | 134027 | 83 | 24.830 | 5397.8 |
671 | 2024-03-04 09:52:37 | apricot | 4 | 151207 | 1055 | 14.453 | 10462.0 |
670 | 2024-03-04 09:52:36 | apricot | 2 | 107671 | 5 | 10.970 | 9815.0 |
669 | 2024-03-04 09:52:34 | apricot | 1 | 69583 | 2 | 3.563 | 19529.3 |
668 | 2024-02-03 04:06:36 | apricot | 4 | 151207 | 1055 | 20.093 | 7525.4 |
667 | 2024-01-29 23:05:16 | apricot | 4 | 151207 | 1055 | 14.470 | 10449.7 |
666 | 2024-01-14 23:30:01 | apricot | 4 | 151207 | 1055 | 13.516 | 11187.3 |
665 | 2024-01-14 23:29:57 | apricot | 3 | 134027 | 83 | 14.156 | 9467.9 |
664 | 2024-01-14 23:29:58 | apricot | 2 | 107671 | 5 | 3.343 | 32207.9 |
663 | 2024-01-12 03:20:47 | apricot | 1 | 69583 | 2 | 1.110 | 62687.4 |
662 | 2023-12-27 00:41:29 | apricot | 1 | 69583 | 2 | 1.203 | 57841.2 |
661 | 2023-12-23 20:28:45 | apricot | 1 | 69583 | 2 | 1.093 | 63662.4 |
660 | 2023-12-18 07:31:25 | apricot | 4 | 151207 | 1055 | 9.873 | 15315.2 |
659 | 2023-12-11 19:08:32 | apricot | 3 | 134027 | 83 | 5.843 | 22938.0 |
658 | 2023-12-04 22:22:11 | apricot | 4 | 151207 | 1055 | 14.046 | 10765.1 |
657 | 2023-12-01 00:33:10 | apricot | 1 | 69583 | 2 | 1.280 | 54361.7 |
656 | 2023-11-25 18:18:14 | apricot | 4 | 151207 | 1055 | 10.563 | 14314.8 |
655 | 2023-11-19 13:46:22 | apricot | 1 | 69583 | 2 | 1.250 | 55666.4 |
654 | 2023-11-19 05:36:57 | apricot | 1 | 69583 | 2 | 1.110 | 62687.4 |
653 | 2023-11-16 06:24:19 | apricot | 1 | 69583 | 2 | 1.093 | 63662.4 |
652 | 2023-11-10 00:39:16 | apricot | 1 | 69583 | 2 | 1.280 | 54361.7 |
651 | 2023-11-07 14:00:18 | apricot | 1 | 69583 | 2 | 1.266 | 54962.9 |
650 | 2023-11-05 15:58:03 | apricot | 3 | 134027 | 83 | 5.736 | 23365.9 |
649 | 2023-10-19 05:58:19 | apricot | 3 | 134027 | 83 | 6.466 | 20728.0 |
648 | 2023-10-17 16:45:18 | apricot | 4 | 151207 | 1055 | 10.953 | 13805.1 |
647 | 2023-10-16 16:43:35 | apricot | 3 | 134027 | 83 | 6.643 | 20175.7 |
646 | 2023-10-16 16:43:37 | apricot | 2 | 107671 | 5 | 3.326 | 32372.5 |
645 | 2023-10-11 00:33:19 | apricot | 1 | 69583 | 2 | 2.156 | 32274.1 |
644 | 2023-09-28 03:38:53 | apricot | 4 | 151207 | 1055 | 10.813 | 13983.8 |
643 | 2023-09-27 22:18:57 | apricot | 4 | 151207 | 1055 | 20.346 | 7431.8 |
642 | 2023-09-26 08:44:10 | apricot | 1 | 69583 | 2 | 1.093 | 63662.4 |
641 | 2023-09-24 17:06:23 | apricot | 4 | 151207 | 1055 | 10.093 | 14981.4 |
640 | 2023-09-21 08:17:59 | apricot | 4 | 151207 | 1055 | 10.593 | 14274.2 |
639 | 2023-09-18 17:56:28 | apricot | 4 | 151207 | 1055 | 10.156 | 14888.4 |
638 | 2023-09-15 15:07:47 | apricot | 1 | 69583 | 2 | 1.096 | 63488.1 |
637 | 2023-09-11 01:33:23 | apricot | 3 | 134027 | 83 | 5.750 | 23309.0 |
636 | 2023-08-28 15:57:58 | apricot | 1 | 69583 | 2 | 1.110 | 62687.4 |
635 | 2023-08-28 04:18:31 | apricot | 1 | 69583 | 2 | 1.096 | 63488.1 |
634 | 2023-06-23 23:55:02 | apricot | 4 | 151207 | 1055 | 10.440 | 14483.4 |
633 | 2023-06-04 15:48:27 | apricot | 3 | 134027 | 83 | 5.766 | 23244.4 |
632 | 2023-06-02 01:28:23 | apricot | 1 | 69583 | 2 | 1.060 | 65644.3 |
631 | 2023-05-10 21:48:06 | apricot | 1 | 69583 | 2 | 1.080 | 64428.7 |
630 | 2023-03-24 06:41:22 | apricot | 1 | 69583 | 2 | 1.063 | 65459.1 |
629 | 2023-03-21 16:18:34 | apricot | 4 | 151207 | 1055 | 10.466 | 14447.4 |
628 | 2023-03-17 02:07:57 | apricot | 4 | 151207 | 1055 | 11.296 | 13385.9 |
627 | 2023-03-12 16:34:52 | apricot | 3 | 134027 | 83 | 5.703 | 23501.1 |
626 | 2023-01-28 17:51:35 | apricot | 1 | 69583 | 2 | 1.080 | 64428.7 |
625 | 2023-01-08 18:20:14 | apricot | 1 | 69583 | 2 | 1.140 | 61037.7 |
624 | 2022-12-18 01:58:06 | apricot | 4 | 151207 | 1055 | 10.453 | 14465.4 |
623 | 2022-12-16 18:58:53 | apricot | 3 | 134027 | 83 | 6.360 | 21073.4 |
622 | 2022-12-11 01:23:07 | apricot | 4 | 151207 | 1055 | 10.706 | 14123.6 |
621 | 2022-11-17 09:37:56 | apricot | 1 | 69583 | 2 | 2.483 | 28023.8 |
620 | 2022-10-29 10:38:05 | apricot | 4 | 151207 | 1055 | 11.796 | 12818.5 |
619 | 2022-10-15 17:37:06 | apricot | 1 | 69583 | 2 | 1.093 | 63662.4 |
618 | 2022-10-10 18:32:46 | apricot | 1 | 69583 | 2 | 1.063 | 65459.1 |
617 | 2022-10-01 23:56:13 | apricot | 4 | 151207 | 1055 | 9.970 | 15166.2 |
616 | 2022-09-12 21:02:58 | apricot | 4 | 151207 | 1055 | 9.813 | 15408.8 |
615 | 2022-09-10 18:43:29 | apricot | 1 | 69583 | 2 | 1.106 | 62914.1 |
614 | 2022-09-06 19:56:29 | apricot | 4 | 151207 | 1055 | 10.406 | 14530.8 |
613 | 2022-08-26 07:55:42 | apricot | 1 | 69583 | 2 | 1.080 | 64428.7 |
612 | 2022-08-09 10:39:49 | apricot | 1 | 69583 | 2 | 1.186 | 58670.3 |
611 | 2022-08-07 09:46:28 | apricot | 4 | 151207 | 1055 | 10.013 | 15101.1 |
610 | 2022-08-05 05:23:46 | apricot | 3 | 134027 | 83 | 6.533 | 20515.4 |
609 | 2022-08-01 02:35:56 | apricot | 1 | 69583 | 2 | 1.123 | 61961.7 |
608 | 2022-07-21 17:21:39 | apricot | 1 | 69583 | 2 | 1.060 | 65644.3 |
607 | 2022-06-16 16:11:04 | apricot | 1 | 69583 | 2 | 1.126 | 61796.6 |
606 | 2022-06-05 16:44:44 | apricot | 1 | 69583 | 2 | 1.096 | 63488.1 |
605 | 2022-06-03 14:30:54 | apricot | 4 | 151207 | 1055 | 11.156 | 13553.9 |
604 | 2022-05-05 15:55:38 | apricot | 4 | 151207 | 1055 | 10.643 | 14207.2 |
603 | 2022-05-05 14:52:20 | apricot | 4 | 151207 | 1055 | 11.486 | 13164.5 |
602 | 2022-03-29 10:58:32 | apricot | 4 | 151207 | 1055 | 12.016 | 12583.8 |
601 | 2022-03-12 21:16:05 | apricot | 4 | 151207 | 1055 | 11.826 | 12786.0 |
600 | 2022-02-22 10:13:10 | apricot | 1 | 69583 | 2 | 1.783 | 39025.8 |
599 | 2022-02-13 08:21:48 | apricot | 1 | 69583 | 2 | 1.296 | 53690.6 |
598 | 2021-12-21 15:16:44 | apricot | 1 | 69583 | 2 | 1.280 | 54361.7 |
597 | 2021-11-17 15:45:02 | apricot | 1 | 69583 | 2 | 1.563 | 44518.9 |
596 | 2021-10-06 17:02:11 | apricot | 4 | 151207 | 1055 | 11.690 | 12934.7 |
595 | 2021-09-01 00:36:26 | apricot | 1 | 69583 | 2 | 1.060 | 65644.3 |
594 | 2021-08-18 02:35:05 | apricot | 1 | 69583 | 2 | 1.080 | 64428.7 |
593 | 2021-08-14 19:19:59 | apricot | 1 | 69583 | 2 | 1.126 | 61796.6 |
592 | 2021-07-05 20:25:22 | apricot | 4 | 151207 | 1055 | 13.423 | 11264.8 |
591 | 2021-05-15 14:14:23 | apricot | 2 | 107671 | 5 | 2.826 | 38100.1 |