History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crayon"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
857 | 2024-04-24 20:38:52 | crayon | 1 | 48755 | 4 | 1.970 | 24748.7 |
856 | 2024-04-23 22:56:39 | crayon | 1 | 48755 | 4 | 1.310 | 37217.6 |
855 | 2024-04-06 13:08:29 | crayon | 1 | 48755 | 4 | 1.906 | 25579.7 |
854 | 2024-03-31 09:26:11 | crayon | 2 | 82551 | 26 | 8.453 | 9765.9 |
853 | 2024-03-31 09:26:07 | crayon | 1 | 48755 | 4 | 2.576 | 18926.6 |
852 | 2024-03-30 02:20:06 | crayon | 2 | 82551 | 26 | 5.796 | 14242.8 |
851 | 2024-03-30 02:19:41 | crayon | 3 | 112716 | 399 | 9.423 | 11961.8 |
850 | 2024-03-29 05:31:10 | crayon | 3 | 112716 | 399 | 12.610 | 8938.6 |
849 | 2024-03-29 05:31:11 | crayon | 2 | 82551 | 26 | 4.546 | 18159.0 |
848 | 2024-03-29 05:30:55 | crayon | 3 | 112716 | 399 | 17.140 | 6576.2 |
847 | 2024-03-29 05:31:04 | crayon | 1 | 48755 | 4 | 3.596 | 13558.1 |
846 | 2024-03-29 05:30:53 | crayon | 2 | 82551 | 26 | 4.720 | 17489.6 |
845 | 2024-03-29 05:30:52 | crayon | 1 | 48755 | 4 | 3.050 | 15985.2 |
844 | 2024-02-28 02:40:43 | crayon | 1 | 48755 | 4 | 1.860 | 26212.4 |
843 | 2024-02-09 07:51:22 | crayon | 1 | 48755 | 4 | 0.736 | 66243.2 |
842 | 2024-01-22 03:54:06 | crayon | 3 | 112716 | 399 | 5.486 | 20546.1 |
841 | 2024-01-12 15:10:29 | crayon | 3 | 112716 | 399 | 10.330 | 10911.5 |
840 | 2024-01-10 07:55:18 | crayon | 1 | 48755 | 4 | 0.796 | 61250.0 |
839 | 2024-01-10 06:13:18 | crayon | 2 | 82551 | 26 | 2.200 | 37523.2 |
838 | 2023-12-21 14:57:40 | crayon | 3 | 112716 | 399 | 5.950 | 18943.9 |
837 | 2023-12-21 14:57:39 | crayon | 2 | 82551 | 26 | 5.283 | 15625.8 |
836 | 2023-12-17 12:22:33 | crayon | 3 | 112716 | 399 | 5.796 | 19447.2 |
835 | 2023-11-25 04:45:29 | crayon | 1 | 48755 | 4 | 0.873 | 55847.7 |
834 | 2023-11-12 01:57:45 | crayon | 1 | 48755 | 4 | 0.860 | 56691.9 |
833 | 2023-11-10 19:02:24 | crayon | 1 | 48755 | 4 | 0.830 | 58741.0 |
832 | 2023-11-06 15:43:23 | crayon | 3 | 112716 | 399 | 11.656 | 9670.2 |
831 | 2023-11-03 02:58:18 | crayon | 1 | 48755 | 4 | 0.956 | 50999.0 |
830 | 2023-11-01 08:39:22 | crayon | 3 | 112716 | 399 | 5.640 | 19985.1 |
829 | 2023-10-30 15:04:29 | crayon | 1 | 48755 | 4 | 0.893 | 54596.9 |
828 | 2023-10-17 16:36:21 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
827 | 2023-10-16 09:50:14 | crayon | 2 | 82551 | 26 | 2.186 | 37763.5 |
826 | 2023-10-13 22:59:46 | crayon | 1 | 48755 | 4 | 0.893 | 54596.9 |
825 | 2023-10-11 10:20:38 | crayon | 1 | 48755 | 4 | 0.810 | 60191.4 |
824 | 2023-09-30 13:50:19 | crayon | 3 | 112716 | 399 | 5.266 | 21404.5 |
823 | 2023-09-30 13:50:20 | crayon | 2 | 82551 | 26 | 2.483 | 33246.5 |
822 | 2023-09-24 22:09:15 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
821 | 2023-09-14 10:58:57 | crayon | 1 | 48755 | 4 | 0.843 | 57835.1 |
820 | 2023-08-26 13:54:52 | crayon | 1 | 48755 | 4 | 0.843 | 57835.1 |
819 | 2023-08-08 14:55:30 | crayon | 3 | 112716 | 399 | 4.860 | 23192.6 |
818 | 2023-07-26 16:32:33 | crayon | 2 | 82551 | 26 | 2.623 | 31472.0 |
817 | 2023-06-26 23:24:42 | crayon | 1 | 48755 | 4 | 0.826 | 59025.4 |
816 | 2023-05-30 10:56:14 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
815 | 2023-04-22 08:01:14 | crayon | 3 | 112716 | 399 | 5.470 | 20606.2 |
814 | 2023-04-04 12:06:40 | crayon | 2 | 82551 | 26 | 2.140 | 38575.2 |
813 | 2023-03-24 08:02:45 | crayon | 1 | 48755 | 4 | 0.856 | 56956.8 |
812 | 2023-03-13 18:57:47 | crayon | 3 | 112716 | 399 | 5.750 | 19602.8 |
811 | 2023-03-07 21:57:42 | crayon | 1 | 48755 | 4 | 0.736 | 66243.2 |
810 | 2023-02-01 13:55:22 | crayon | 3 | 112716 | 399 | 5.296 | 21283.2 |
809 | 2023-01-27 19:01:34 | crayon | 3 | 112716 | 399 | 4.656 | 24208.8 |
808 | 2023-01-19 21:08:26 | crayon | 3 | 112716 | 399 | 4.796 | 23502.1 |
807 | 2023-01-08 16:15:49 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
806 | 2023-01-06 03:10:47 | crayon | 3 | 112716 | 399 | 4.656 | 24208.8 |
805 | 2023-01-01 13:29:12 | crayon | 2 | 82551 | 26 | 2.140 | 38575.2 |
804 | 2022-12-16 19:27:22 | crayon | 3 | 112716 | 399 | 5.300 | 21267.2 |
803 | 2022-12-13 08:10:11 | crayon | 3 | 112716 | 399 | 4.703 | 23966.8 |
802 | 2022-11-15 23:24:09 | crayon | 1 | 48755 | 4 | 0.796 | 61250.0 |
801 | 2022-11-10 04:45:06 | crayon | 3 | 112716 | 399 | 4.750 | 23729.7 |
800 | 2022-10-07 23:16:33 | crayon | 1 | 48755 | 4 | 0.796 | 61250.0 |
799 | 2022-09-02 11:06:22 | crayon | 2 | 82551 | 26 | 2.330 | 35429.6 |
798 | 2022-09-02 00:59:27 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
797 | 2022-08-31 05:29:11 | crayon | 2 | 82551 | 26 | 2.170 | 38041.9 |
796 | 2022-07-29 01:53:08 | crayon | 1 | 48755 | 4 | 0.860 | 56691.9 |
795 | 2022-07-23 02:11:17 | crayon | 1 | 48755 | 4 | 0.766 | 63648.8 |
794 | 2022-06-22 04:56:35 | crayon | 3 | 112716 | 399 | 4.906 | 22975.1 |
793 | 2022-05-30 22:34:54 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
792 | 2022-05-27 14:20:36 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
791 | 2022-05-05 20:08:06 | crayon | 3 | 112716 | 399 | 7.373 | 15287.7 |
790 | 2022-05-04 15:26:20 | crayon | 3 | 112716 | 399 | 5.560 | 20272.7 |
789 | 2022-05-02 11:34:57 | crayon | 3 | 112716 | 399 | 5.390 | 20912.1 |
788 | 2022-04-30 08:07:45 | crayon | 3 | 112716 | 399 | 5.203 | 21663.7 |
787 | 2022-04-04 04:52:23 | crayon | 3 | 112716 | 399 | 5.530 | 20382.6 |
786 | 2022-03-28 04:07:11 | crayon | 3 | 112716 | 399 | 4.656 | 24208.8 |
785 | 2022-03-15 02:07:00 | crayon | 1 | 48755 | 4 | 1.580 | 30857.6 |
784 | 2022-02-08 20:17:08 | crayon | 1 | 48755 | 4 | 0.766 | 63648.8 |
783 | 2021-12-28 22:48:09 | crayon | 3 | 112716 | 399 | 5.423 | 20784.8 |
782 | 2021-12-04 18:21:10 | crayon | 1 | 48755 | 4 | 0.766 | 63648.8 |
781 | 2021-11-30 12:55:26 | crayon | 1 | 48755 | 4 | 0.940 | 51867.0 |
780 | 2021-11-28 11:32:00 | crayon | 1 | 48755 | 4 | 0.873 | 55847.7 |
779 | 2021-10-14 03:31:02 | crayon | 1 | 48755 | 4 | 0.843 | 57835.1 |
778 | 2021-10-12 03:36:54 | crayon | 1 | 48755 | 4 | 0.766 | 63648.8 |
777 | 2021-09-08 01:34:00 | crayon | 1 | 48755 | 4 | 0.876 | 55656.4 |
776 | 2021-08-25 01:38:15 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
775 | 2021-08-19 06:38:37 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
774 | 2021-05-24 04:56:17 | crayon | 1 | 48755 | 4 | 0.796 | 61250.0 |
773 | 2021-05-23 18:50:56 | crayon | 3 | 112716 | 399 | 5.406 | 20850.2 |
772 | 2021-05-11 10:55:22 | crayon | 1 | 48755 | 4 | 0.890 | 54780.9 |
771 | 2021-02-23 22:15:11 | crayon | 1 | 48755 | 4 | 0.826 | 59025.4 |
770 | 2021-02-19 09:36:04 | crayon | 3 | 112716 | 399 | 5.063 | 22262.7 |
769 | 2021-02-18 22:46:22 | crayon | 1 | 48755 | 4 | 0.780 | 62506.4 |
768 | 2021-02-18 13:22:15 | crayon | 1 | 48755 | 4 | 0.763 | 63899.1 |
767 | 2021-01-24 16:37:45 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
766 | 2021-01-05 08:16:46 | crayon | 3 | 112716 | 399 | 4.796 | 23502.1 |
765 | 2020-11-14 12:19:42 | crayon | 1 | 48755 | 4 | 0.766 | 63648.8 |
764 | 2020-10-12 20:07:34 | crayon | 1 | 48755 | 4 | 0.860 | 56691.9 |
763 | 2020-09-24 00:29:42 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
762 | 2020-08-12 14:39:35 | crayon | 1 | 48755 | 4 | 0.750 | 65006.7 |
761 | 2020-08-10 01:47:40 | crayon | 1 | 48755 | 4 | 0.763 | 63899.1 |
760 | 2020-07-20 11:03:48 | crayon | 1 | 48755 | 4 | 0.813 | 59969.2 |
759 | 2020-07-16 18:10:46 | crayon | 2 | 82551 | 26 | 2.800 | 29482.5 |
758 | 2020-05-10 23:25:37 | crayon | 1 | 48755 | 4 | 0.763 | 63899.1 |