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 |
861 | 2025-08-28 16:14:20 | candle | 1 | 48755 | 9 | 1.500 | 32503.3 |
860 | 2025-08-25 03:11:03 | candle | 1 | 48755 | 9 | 2.376 | 20519.8 |
859 | 2025-08-17 14:53:36 | candle | 1 | 48755 | 9 | 2.063 | 23633.1 |
858 | 2025-08-10 02:11:38 | candle | 1 | 48755 | 9 | 3.280 | 14864.3 |
857 | 2025-08-07 09:04:21 | candle | 3 | 112716 | 859 | 14.860 | 7585.2 |
856 | 2025-08-06 15:25:42 | candle | 2 | 82551 | 89 | 12.596 | 6553.7 |
855 | 2025-08-04 04:53:05 | candle | 1 | 48755 | 9 | 2.626 | 18566.3 |
854 | 2025-08-04 01:46:31 | candle | 2 | 82551 | 89 | 12.763 | 6468.0 |
853 | 2025-08-04 01:44:11 | candle | 3 | 112716 | 859 | 15.643 | 7205.5 |
852 | 2025-07-31 14:51:58 | candle | 1 | 48755 | 9 | 2.563 | 19022.6 |
851 | 2025-07-31 03:48:12 | candle | 1 | 48755 | 9 | 4.296 | 11348.9 |
850 | 2025-07-25 03:38:54 | candle | 1 | 48755 | 9 | 2.233 | 21833.9 |
849 | 2025-07-24 08:36:10 | candle | 1 | 48755 | 9 | 5.580 | 8737.5 |
848 | 2025-07-23 11:58:43 | candle | 1 | 48755 | 9 | 1.736 | 28084.7 |
847 | 2025-07-22 10:50:07 | candle | 1 | 48755 | 9 | 4.390 | 11105.9 |
846 | 2025-07-22 07:16:28 | candle | 1 | 48755 | 9 | 4.186 | 11647.2 |
845 | 2025-07-17 13:29:37 | candle | 1 | 48755 | 9 | 3.483 | 13998.0 |
844 | 2025-07-13 10:27:38 | candle | 1 | 48755 | 9 | 0.920 | 52994.6 |
843 | 2025-07-12 10:28:31 | candle | 1 | 48755 | 9 | 0.890 | 54780.9 |
842 | 2025-07-10 22:03:38 | candle | 1 | 48755 | 9 | 4.093 | 11911.8 |
841 | 2025-07-10 14:42:32 | candle | 1 | 48755 | 9 | 2.686 | 18151.5 |
840 | 2025-07-08 12:22:57 | candle | 1 | 48755 | 9 | 4.250 | 11471.8 |
839 | 2025-07-04 08:17:39 | candle | 1 | 48755 | 9 | 2.440 | 19981.6 |
838 | 2025-07-04 04:57:01 | candle | 1 | 48755 | 9 | 4.906 | 9937.8 |
837 | 2025-07-01 17:51:04 | candle | 1 | 48755 | 9 | 0.796 | 61250.0 |
836 | 2025-06-29 09:20:09 | candle | 1 | 48755 | 9 | 0.906 | 53813.5 |
835 | 2025-06-26 14:01:59 | candle | 1 | 48755 | 9 | 2.296 | 21234.8 |
834 | 2025-06-24 02:00:30 | candle | 1 | 48755 | 9 | 4.080 | 11949.8 |
833 | 2025-06-21 01:35:56 | candle | 1 | 48755 | 9 | 0.890 | 54780.9 |
832 | 2025-06-20 12:16:28 | candle | 1 | 48755 | 9 | 4.050 | 12038.3 |
831 | 2025-06-13 20:22:05 | candle | 1 | 48755 | 9 | 5.173 | 9424.9 |
830 | 2025-06-10 16:00:13 | candle | 1 | 48755 | 9 | 4.123 | 11825.1 |
829 | 2025-06-10 15:51:09 | candle | 1 | 48755 | 9 | 4.250 | 11471.8 |
828 | 2025-06-10 00:03:23 | candle | 1 | 48755 | 9 | 4.033 | 12089.0 |
827 | 2025-06-06 04:34:18 | candle | 1 | 48755 | 9 | 4.640 | 10507.5 |
826 | 2025-06-02 04:30:21 | candle | 1 | 48755 | 9 | 5.126 | 9511.3 |
825 | 2025-05-30 06:44:46 | candle | 1 | 48755 | 9 | 1.796 | 27146.4 |
824 | 2025-05-28 20:03:01 | candle | 1 | 48755 | 9 | 1.656 | 29441.4 |
823 | 2025-05-23 05:46:55 | candle | 1 | 48755 | 9 | 2.173 | 22436.7 |
822 | 2025-05-22 19:47:24 | candle | 1 | 48755 | 9 | 0.780 | 62506.4 |
821 | 2025-05-21 18:31:10 | candle | 1 | 48755 | 9 | 0.873 | 55847.7 |
820 | 2025-05-13 18:42:35 | candle | 1 | 48755 | 9 | 0.890 | 54780.9 |
819 | 2025-05-10 19:29:35 | candle | 1 | 48755 | 9 | 4.390 | 11105.9 |
818 | 2025-05-10 17:56:02 | candle | 1 | 48755 | 9 | 2.236 | 21804.6 |
817 | 2025-04-25 17:27:11 | candle | 1 | 48755 | 9 | 0.936 | 52088.7 |
816 | 2025-04-22 01:03:20 | candle | 1 | 48755 | 9 | 0.920 | 52994.6 |
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 |