History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
731 | 2025-08-17 14:56:06 | opal | 1 | 13983 | 8 | 0.263 | 53167.3 |
730 | 2025-08-10 03:37:39 | opal | 2 | 29872 | 155 | 3.766 | 7932.0 |
729 | 2025-08-09 05:41:35 | opal | 2 | 29872 | 155 | 4.563 | 6546.6 |
728 | 2025-08-08 22:40:01 | opal | 1 | 13983 | 8 | 0.470 | 29751.1 |
727 | 2025-08-06 11:19:21 | opal | 1 | 13983 | 8 | 0.263 | 53167.3 |
726 | 2025-08-03 23:34:14 | opal | 1 | 13983 | 8 | 0.703 | 19890.5 |
725 | 2025-08-03 20:12:07 | opal | 1 | 13983 | 8 | 1.653 | 8459.2 |
724 | 2025-07-31 20:40:57 | opal | 1 | 13983 | 8 | 0.266 | 52567.7 |
723 | 2025-07-31 14:24:37 | opal | 1 | 13983 | 8 | 1.046 | 13368.1 |
722 | 2025-07-31 08:40:50 | opal | 1 | 13983 | 8 | 0.766 | 18254.6 |
721 | 2025-07-28 08:14:26 | opal | 2 | 29872 | 155 | 1.813 | 16476.6 |
720 | 2025-07-28 08:14:23 | opal | 2 | 29872 | 155 | 1.860 | 16060.2 |
719 | 2025-07-27 18:09:01 | opal | 2 | 29872 | 155 | 6.140 | 4865.1 |
718 | 2025-07-25 23:59:27 | opal | 2 | 29872 | 155 | 2.563 | 11655.1 |
717 | 2025-07-22 01:07:05 | opal | 1 | 13983 | 8 | 0.513 | 27257.3 |
716 | 2025-07-18 15:58:14 | opal | 1 | 13983 | 8 | 0.673 | 20777.1 |
715 | 2025-07-17 12:28:42 | opal | 1 | 13983 | 8 | 0.283 | 49409.9 |
714 | 2025-07-10 16:31:33 | opal | 2 | 29872 | 155 | 4.126 | 7239.9 |
713 | 2025-07-08 21:55:34 | opal | 1 | 13983 | 8 | 0.343 | 40766.8 |
712 | 2025-07-04 02:59:02 | opal | 2 | 29872 | 155 | 5.596 | 5338.1 |
711 | 2025-07-04 01:11:44 | opal | 2 | 29872 | 155 | 4.453 | 6708.3 |
710 | 2025-07-03 11:23:03 | opal | 2 | 29872 | 155 | 0.966 | 30923.4 |
709 | 2025-07-02 23:28:35 | opal | 1 | 13983 | 8 | 1.326 | 10545.2 |
708 | 2025-07-01 19:46:32 | opal | 1 | 13983 | 8 | 0.300 | 46610.0 |
707 | 2025-06-30 14:23:50 | opal | 1 | 13983 | 8 | 1.143 | 12233.6 |
706 | 2025-06-18 11:09:54 | opal | 1 | 13983 | 8 | 2.030 | 6888.2 |
705 | 2025-06-10 17:15:04 | opal | 1 | 13983 | 8 | 1.373 | 10184.3 |
704 | 2025-06-09 17:36:20 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
703 | 2025-06-01 23:17:31 | opal | 1 | 13983 | 8 | 1.220 | 11461.5 |
702 | 2025-05-31 23:09:55 | opal | 1 | 13983 | 8 | 1.186 | 11790.1 |
701 | 2025-05-31 22:46:04 | opal | 1 | 13983 | 8 | 0.283 | 49409.9 |
700 | 2025-05-30 20:04:06 | opal | 1 | 13983 | 8 | 0.593 | 23580.1 |
699 | 2025-05-28 21:22:17 | opal | 1 | 13983 | 8 | 1.906 | 7336.3 |
698 | 2025-05-20 00:54:46 | opal | 2 | 29872 | 155 | 6.046 | 4940.8 |
697 | 2025-05-18 09:37:08 | opal | 2 | 29872 | 155 | 4.250 | 7028.7 |
696 | 2025-05-17 07:19:17 | opal | 1 | 13983 | 8 | 1.220 | 11461.5 |
695 | 2025-05-13 10:10:31 | opal | 1 | 13983 | 8 | 0.516 | 27098.8 |
694 | 2025-05-11 11:50:34 | opal | 1 | 13983 | 8 | 0.453 | 30867.5 |
693 | 2025-05-10 15:12:28 | opal | 1 | 13983 | 8 | 1.156 | 12096.0 |
692 | 2025-05-09 10:25:58 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
691 | 2025-05-07 21:40:36 | opal | 1 | 13983 | 8 | 1.296 | 10789.4 |
690 | 2025-05-07 19:47:23 | opal | 1 | 13983 | 8 | 0.953 | 14672.6 |
689 | 2025-05-02 02:23:40 | opal | 2 | 29872 | 155 | 6.313 | 4731.8 |
688 | 2025-04-30 22:47:30 | opal | 1 | 13983 | 8 | 0.670 | 20870.1 |
687 | 2025-04-29 19:30:49 | opal | 1 | 13983 | 8 | 1.656 | 8443.8 |
686 | 2025-04-27 17:57:21 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
685 | 2025-04-25 12:52:21 | opal | 1 | 13983 | 8 | 1.250 | 11186.4 |
684 | 2025-04-11 00:11:39 | opal | 2 | 29872 | 155 | 4.750 | 6288.8 |
683 | 2025-04-10 14:05:39 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
682 | 2025-04-10 10:14:29 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
681 | 2025-04-07 21:01:43 | opal | 1 | 13983 | 8 | 1.156 | 12096.0 |
680 | 2025-03-31 00:04:23 | opal | 1 | 13983 | 8 | 1.063 | 13154.3 |
679 | 2025-03-28 20:49:07 | opal | 1 | 13983 | 8 | 1.220 | 11461.5 |
678 | 2025-03-25 15:48:22 | opal | 1 | 13983 | 8 | 1.563 | 8946.3 |
677 | 2025-03-17 06:07:18 | opal | 1 | 13983 | 8 | 0.936 | 14939.1 |
676 | 2025-03-16 05:12:40 | opal | 1 | 13983 | 8 | 1.830 | 7641.0 |
675 | 2025-03-10 23:39:22 | opal | 1 | 13983 | 8 | 0.656 | 21315.5 |
674 | 2025-03-07 16:12:10 | opal | 2 | 29872 | 155 | 2.640 | 11315.2 |
673 | 2025-03-07 15:52:48 | opal | 1 | 13983 | 8 | 1.800 | 7768.3 |
672 | 2025-02-27 03:55:57 | opal | 2 | 29872 | 155 | 4.233 | 7056.9 |
671 | 2025-02-27 03:54:28 | opal | 1 | 13983 | 8 | 0.686 | 20383.4 |
670 | 2025-02-25 00:19:31 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
669 | 2025-02-23 03:10:47 | opal | 1 | 13983 | 8 | 1.623 | 8615.5 |
668 | 2025-02-16 15:17:28 | opal | 1 | 13983 | 8 | 1.970 | 7098.0 |
667 | 2025-02-05 13:28:13 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
666 | 2025-01-27 15:26:49 | opal | 2 | 29872 | 155 | 1.000 | 29872.0 |
665 | 2025-01-27 15:26:37 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
664 | 2025-01-26 06:55:34 | opal | 2 | 29872 | 155 | 7.376 | 4049.9 |
663 | 2025-01-25 17:45:28 | opal | 1 | 13983 | 8 | 0.236 | 59250.0 |
662 | 2025-01-24 01:57:25 | opal | 1 | 13983 | 8 | 0.266 | 52567.7 |
661 | 2025-01-06 00:46:12 | opal | 1 | 13983 | 8 | 1.843 | 7587.1 |
660 | 2024-12-28 14:14:31 | opal | 1 | 13983 | 8 | 0.266 | 52567.7 |
659 | 2024-12-27 06:36:09 | opal | 2 | 29872 | 155 | 4.486 | 6658.9 |
658 | 2024-12-26 15:18:53 | opal | 1 | 13983 | 8 | 0.670 | 20870.1 |
657 | 2024-12-25 00:59:20 | opal | 1 | 13983 | 8 | 0.560 | 24969.6 |
656 | 2024-12-06 23:59:22 | opal | 2 | 29872 | 155 | 4.330 | 6898.8 |
655 | 2024-12-06 23:59:20 | opal | 1 | 13983 | 8 | 2.156 | 6485.6 |
654 | 2024-11-28 07:01:23 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
653 | 2024-11-28 05:51:10 | opal | 2 | 29872 | 155 | 3.796 | 7869.3 |
652 | 2024-11-27 06:34:07 | opal | 2 | 29872 | 155 | 2.550 | 11714.5 |
651 | 2024-11-26 10:32:24 | opal | 1 | 13983 | 8 | 0.906 | 15433.8 |
650 | 2024-11-24 18:00:53 | opal | 2 | 29872 | 155 | 2.046 | 14600.2 |
649 | 2024-11-24 18:00:49 | opal | 1 | 13983 | 8 | 0.263 | 53167.3 |
648 | 2024-11-16 12:34:34 | opal | 1 | 13983 | 8 | 1.606 | 8706.7 |
647 | 2024-11-06 20:17:53 | opal | 1 | 13983 | 8 | 1.326 | 10545.2 |
646 | 2024-10-29 05:21:45 | opal | 2 | 29872 | 155 | 5.860 | 5097.6 |
645 | 2024-10-29 05:09:03 | opal | 1 | 13983 | 8 | 0.860 | 16259.3 |
644 | 2024-10-28 08:25:58 | opal | 2 | 29872 | 155 | 5.593 | 5341.0 |
643 | 2024-10-27 09:25:31 | opal | 1 | 13983 | 8 | 0.936 | 14939.1 |
642 | 2024-10-25 16:41:10 | opal | 1 | 13983 | 8 | 1.376 | 10162.1 |
641 | 2024-10-07 17:17:21 | opal | 1 | 13983 | 8 | 3.720 | 3758.9 |
640 | 2024-10-04 11:45:56 | opal | 1 | 13983 | 8 | 1.343 | 10411.8 |
639 | 2024-09-28 14:19:37 | opal | 2 | 29872 | 155 | 7.093 | 4211.5 |
638 | 2024-09-28 14:08:33 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
637 | 2024-09-27 07:49:49 | opal | 1 | 13983 | 8 | 2.640 | 5296.6 |
636 | 2024-09-25 13:51:00 | opal | 1 | 13983 | 8 | 1.546 | 9044.6 |
635 | 2024-09-18 21:08:09 | opal | 1 | 13983 | 8 | 2.450 | 5707.3 |
634 | 2024-09-07 13:10:56 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
633 | 2024-08-31 05:42:25 | opal | 2 | 29872 | 155 | 9.623 | 3104.2 |
632 | 2024-08-30 04:24:47 | opal | 1 | 13983 | 8 | 1.763 | 7931.4 |