History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"candle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
815 | 2025-04-20 07:04:54 | candle | 1 | 48755 | 9 | 2.156 | 22613.6 |
814 | 2025-04-08 15:24:42 | candle | 1 | 48755 | 9 | 4.190 | 11636.0 |
813 | 2025-04-06 03:21:50 | candle | 1 | 48755 | 9 | 4.500 | 10834.4 |
812 | 2025-03-31 06:26:44 | candle | 1 | 48755 | 9 | 3.953 | 12333.7 |
811 | 2025-03-26 13:11:25 | candle | 2 | 82551 | 89 | 13.876 | 5949.2 |
810 | 2025-03-24 20:29:14 | candle | 3 | 112716 | 859 | 5.826 | 19347.1 |
809 | 2025-03-12 01:17:40 | candle | 2 | 82551 | 89 | 19.580 | 4216.1 |
808 | 2025-03-10 11:20:34 | candle | 2 | 82551 | 89 | 24.390 | 3384.6 |
807 | 2025-03-10 10:43:28 | candle | 3 | 112716 | 859 | 24.770 | 4550.5 |
806 | 2025-03-09 20:13:22 | candle | 3 | 112716 | 859 | 28.986 | 3888.6 |
805 | 2025-03-09 20:13:19 | candle | 2 | 82551 | 89 | 17.156 | 4811.8 |
804 | 2025-03-09 17:41:25 | candle | 3 | 112716 | 859 | 45.626 | 2470.4 |
803 | 2025-03-09 14:57:44 | candle | 3 | 112716 | 859 | 15.236 | 7398.0 |
802 | 2025-03-09 13:57:48 | candle | 1 | 48755 | 9 | 2.203 | 22131.2 |
801 | 2025-03-09 13:52:20 | candle | 3 | 112716 | 859 | 23.283 | 4841.1 |
800 | 2025-03-09 13:52:18 | candle | 2 | 82551 | 89 | 6.640 | 12432.4 |
799 | 2025-03-07 21:59:27 | candle | 1 | 48755 | 9 | 5.546 | 8791.0 |
798 | 2025-03-06 21:20:29 | candle | 1 | 48755 | 9 | 4.410 | 11055.6 |
797 | 2025-03-01 04:36:08 | candle | 1 | 48755 | 9 | 2.280 | 21383.8 |
796 | 2025-02-14 22:43:04 | candle | 1 | 48755 | 9 | 1.986 | 24549.3 |
795 | 2025-02-07 12:10:12 | candle | 1 | 48755 | 9 | 2.843 | 17149.1 |
794 | 2025-02-05 01:14:42 | candle | 1 | 48755 | 9 | 2.063 | 23633.1 |
793 | 2025-01-27 10:59:07 | candle | 1 | 48755 | 9 | 2.203 | 22131.2 |
792 | 2025-01-08 04:50:33 | candle | 1 | 48755 | 9 | 2.030 | 24017.2 |
791 | 2025-01-05 15:32:50 | candle | 1 | 48755 | 9 | 4.373 | 11149.1 |
790 | 2025-01-05 09:49:23 | candle | 1 | 48755 | 9 | 3.736 | 13050.1 |
789 | 2024-12-28 01:37:34 | candle | 1 | 48755 | 9 | 4.250 | 11471.8 |
788 | 2024-12-15 13:58:00 | candle | 3 | 112716 | 859 | 23.076 | 4884.6 |
787 | 2024-12-15 11:18:07 | candle | 3 | 112716 | 859 | 25.376 | 4441.8 |
786 | 2024-12-15 09:24:27 | candle | 3 | 112716 | 859 | 21.046 | 5355.7 |
785 | 2024-12-15 03:36:13 | candle | 3 | 112716 | 859 | 44.660 | 2523.9 |
784 | 2024-12-09 02:11:15 | candle | 1 | 48755 | 9 | 2.156 | 22613.6 |
783 | 2024-12-06 06:11:13 | candle | 1 | 48755 | 9 | 5.296 | 9206.0 |
782 | 2024-12-05 22:35:26 | candle | 2 | 82551 | 89 | 12.843 | 6427.7 |
781 | 2024-11-11 15:27:54 | candle | 2 | 82551 | 89 | 11.406 | 7237.5 |
780 | 2024-11-10 20:04:00 | candle | 3 | 112716 | 859 | 29.550 | 3814.4 |
779 | 2024-11-10 11:26:36 | candle | 2 | 82551 | 89 | 14.313 | 5767.6 |
778 | 2024-11-10 11:02:37 | candle | 3 | 112716 | 859 | 14.360 | 7849.3 |
777 | 2024-11-09 10:15:15 | candle | 2 | 82551 | 89 | 7.673 | 10758.6 |
776 | 2024-11-09 07:11:41 | candle | 3 | 112716 | 859 | 30.313 | 3718.4 |
775 | 2024-11-09 03:45:33 | candle | 3 | 112716 | 859 | 20.530 | 5490.3 |
774 | 2024-11-09 03:45:34 | candle | 2 | 82551 | 89 | 15.156 | 5446.8 |
773 | 2024-11-09 02:07:47 | candle | 1 | 48755 | 9 | 0.766 | 63648.8 |
772 | 2024-11-06 09:11:38 | candle | 1 | 48755 | 9 | 4.016 | 12140.2 |
771 | 2024-11-06 06:07:44 | candle | 1 | 48755 | 9 | 5.080 | 9597.4 |
770 | 2024-10-07 05:36:33 | candle | 1 | 48755 | 9 | 3.420 | 14255.8 |
769 | 2024-10-07 05:23:49 | candle | 1 | 48755 | 9 | 3.220 | 15141.3 |
768 | 2024-10-01 08:21:57 | candle | 1 | 48755 | 9 | 7.003 | 6962.0 |
767 | 2024-09-09 03:58:07 | candle | 1 | 48755 | 9 | 4.656 | 10471.4 |
766 | 2024-09-04 15:16:11 | candle | 1 | 48755 | 9 | 9.330 | 5225.6 |
765 | 2024-09-04 02:39:10 | candle | 3 | 112716 | 859 | 47.786 | 2358.8 |
764 | 2024-09-04 02:35:04 | candle | 1 | 48755 | 9 | 9.250 | 5270.8 |
763 | 2024-09-04 02:22:55 | candle | 3 | 112716 | 859 | 41.766 | 2698.8 |
762 | 2024-09-03 21:42:58 | candle | 3 | 112716 | 859 | 35.343 | 3189.2 |
761 | 2024-09-03 21:42:56 | candle | 2 | 82551 | 89 | 23.626 | 3494.1 |
760 | 2024-09-03 17:28:14 | candle | 3 | 112716 | 859 | 44.416 | 2537.7 |
759 | 2024-09-03 17:28:12 | candle | 2 | 82551 | 89 | 20.726 | 3983.0 |
758 | 2024-09-03 14:45:03 | candle | 3 | 112716 | 859 | 36.876 | 3056.6 |
757 | 2024-09-03 14:45:06 | candle | 2 | 82551 | 89 | 20.596 | 4008.1 |
756 | 2024-09-03 14:37:32 | candle | 1 | 48755 | 9 | 3.376 | 14441.6 |
755 | 2024-08-28 12:54:41 | candle | 1 | 48755 | 9 | 0.873 | 55847.7 |
754 | 2024-08-28 02:00:47 | candle | 1 | 48755 | 9 | 7.140 | 6828.4 |
753 | 2024-08-09 18:08:01 | candle | 1 | 48755 | 9 | 1.580 | 30857.6 |
752 | 2024-08-08 13:04:18 | candle | 1 | 48755 | 9 | 3.280 | 14864.3 |
751 | 2024-08-07 21:33:52 | candle | 1 | 48755 | 9 | 2.466 | 19770.9 |
750 | 2024-08-04 18:07:12 | candle | 1 | 48755 | 9 | 3.280 | 14864.3 |
749 | 2024-07-30 18:30:01 | candle | 1 | 48755 | 9 | 1.920 | 25393.2 |
748 | 2024-07-20 23:18:02 | candle | 1 | 48755 | 9 | 3.860 | 12630.8 |
747 | 2024-07-07 09:41:12 | candle | 1 | 48755 | 9 | 5.220 | 9340.0 |
746 | 2024-06-30 16:03:53 | candle | 1 | 48755 | 9 | 3.580 | 13618.7 |
745 | 2024-06-29 03:17:09 | candle | 1 | 48755 | 9 | 1.766 | 27607.6 |
744 | 2024-06-27 09:10:09 | candle | 1 | 48755 | 9 | 3.376 | 14441.6 |
743 | 2024-06-25 20:50:47 | candle | 1 | 48755 | 9 | 4.593 | 10615.1 |
742 | 2024-05-31 07:50:42 | candle | 1 | 48755 | 9 | 3.250 | 15001.5 |
741 | 2024-05-30 01:08:36 | candle | 1 | 48755 | 9 | 5.093 | 9572.9 |
740 | 2024-05-28 00:50:48 | candle | 1 | 48755 | 9 | 2.550 | 19119.6 |
739 | 2024-05-11 19:09:55 | candle | 1 | 48755 | 9 | 0.953 | 51159.5 |
738 | 2024-05-08 01:12:13 | candle | 3 | 112716 | 859 | 11.843 | 9517.5 |
737 | 2024-05-08 01:06:25 | candle | 3 | 112716 | 859 | 7.610 | 14811.6 |
736 | 2024-05-07 16:32:02 | candle | 2 | 82551 | 89 | 5.423 | 15222.4 |
735 | 2024-05-07 16:31:16 | candle | 3 | 112716 | 859 | 8.530 | 13214.1 |
734 | 2024-05-07 11:35:15 | candle | 3 | 112716 | 859 | 7.160 | 15742.5 |
733 | 2024-05-06 04:21:05 | candle | 1 | 48755 | 9 | 2.986 | 16327.9 |
732 | 2024-05-03 23:22:27 | candle | 2 | 82551 | 89 | 2.966 | 27832.4 |
731 | 2024-05-03 18:35:08 | candle | 1 | 48755 | 9 | 0.860 | 56691.9 |
730 | 2024-05-03 18:34:16 | candle | 3 | 112716 | 859 | 7.626 | 14780.5 |
729 | 2024-05-03 18:34:00 | candle | 2 | 82551 | 89 | 8.796 | 9385.1 |
728 | 2024-05-02 05:21:26 | candle | 1 | 48755 | 9 | 0.983 | 49598.2 |
727 | 2024-04-09 02:59:25 | candle | 1 | 48755 | 9 | 1.516 | 32160.3 |
726 | 2024-04-05 23:47:05 | candle | 1 | 48755 | 9 | 2.050 | 23782.9 |
725 | 2024-04-05 15:11:41 | candle | 3 | 112716 | 859 | 11.656 | 9670.2 |
724 | 2024-04-03 11:34:54 | candle | 2 | 82551 | 89 | 7.063 | 11687.8 |
723 | 2024-04-03 10:42:36 | candle | 3 | 112716 | 859 | 20.126 | 5600.5 |
722 | 2024-04-03 10:35:35 | candle | 3 | 112716 | 859 | 11.533 | 9773.3 |
721 | 2024-04-03 10:35:25 | candle | 2 | 82551 | 89 | 9.093 | 9078.5 |
720 | 2024-03-14 13:10:41 | candle | 3 | 112716 | 859 | 5.343 | 21096.0 |
719 | 2024-03-14 13:10:04 | candle | 2 | 82551 | 89 | 2.796 | 29524.7 |
718 | 2024-03-13 15:45:02 | candle | 2 | 82551 | 89 | 2.736 | 30172.1 |
717 | 2024-03-06 23:55:43 | candle | 1 | 48755 | 9 | 3.046 | 16006.2 |
716 | 2024-03-05 23:30:44 | candle | 2 | 82551 | 89 | 6.643 | 12426.8 |