History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wear"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
907 | 2025-05-07 12:41:10 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
906 | 2025-05-06 20:22:03 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
905 | 2025-05-06 05:16:32 | wear | 2 | 29872 | 268 | 2.360 | 12657.6 |
904 | 2025-05-05 02:23:19 | wear | 2 | 29872 | 268 | 0.750 | 39829.3 |
903 | 2025-05-03 04:34:18 | wear | 1 | 13983 | 23 | 1.000 | 13983.0 |
902 | 2025-04-30 09:24:27 | wear | 1 | 13983 | 23 | 1.110 | 12597.3 |
901 | 2025-04-29 06:00:29 | wear | 1 | 13983 | 23 | 0.720 | 19420.8 |
900 | 2025-04-28 10:26:19 | wear | 1 | 13983 | 23 | 1.343 | 10411.8 |
899 | 2025-04-27 21:38:02 | wear | 1 | 13983 | 23 | 0.533 | 26234.5 |
898 | 2025-04-27 09:25:48 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
897 | 2025-04-20 11:28:47 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
896 | 2025-04-20 10:46:25 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
895 | 2025-04-19 22:49:09 | wear | 2 | 29872 | 268 | 5.890 | 5071.6 |
894 | 2025-04-19 01:10:25 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
893 | 2025-04-14 12:50:26 | wear | 1 | 13983 | 23 | 0.716 | 19529.3 |
892 | 2025-04-06 12:39:03 | wear | 1 | 13983 | 23 | 1.393 | 10038.0 |
891 | 2025-03-27 12:32:09 | wear | 1 | 13983 | 23 | 0.670 | 20870.1 |
890 | 2025-03-27 10:17:51 | wear | 1 | 13983 | 23 | 0.983 | 14224.8 |
889 | 2025-03-26 22:57:48 | wear | 1 | 13983 | 23 | 0.873 | 16017.2 |
888 | 2025-03-20 13:19:46 | wear | 1 | 13983 | 23 | 1.550 | 9021.3 |
887 | 2025-03-20 00:05:33 | wear | 2 | 29872 | 268 | 4.063 | 7352.2 |
886 | 2025-03-16 08:30:26 | wear | 2 | 29872 | 268 | 1.986 | 15041.3 |
885 | 2025-03-14 21:19:43 | wear | 1 | 13983 | 23 | 0.876 | 15962.3 |
884 | 2025-03-14 14:00:40 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
883 | 2025-03-06 14:18:48 | wear | 2 | 29872 | 268 | 4.233 | 7056.9 |
882 | 2025-03-06 14:16:46 | wear | 1 | 13983 | 23 | 0.936 | 14939.1 |
881 | 2025-03-02 16:47:47 | wear | 1 | 13983 | 23 | 0.280 | 49939.3 |
880 | 2025-02-25 08:34:38 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
879 | 2025-02-24 22:04:26 | wear | 2 | 29872 | 268 | 6.370 | 4689.5 |
878 | 2025-02-24 18:35:39 | wear | 2 | 29872 | 268 | 6.203 | 4815.7 |
877 | 2025-02-24 15:38:49 | wear | 2 | 29872 | 268 | 2.156 | 13855.3 |
876 | 2025-02-24 15:37:10 | wear | 1 | 13983 | 23 | 0.263 | 53167.3 |
875 | 2025-02-23 00:30:55 | wear | 1 | 13983 | 23 | 1.500 | 9322.0 |
874 | 2025-02-15 06:33:14 | wear | 1 | 13983 | 23 | 1.626 | 8599.6 |
873 | 2025-02-15 05:30:20 | wear | 1 | 13983 | 23 | 1.656 | 8443.8 |
872 | 2025-02-09 13:42:39 | wear | 1 | 13983 | 23 | 1.593 | 8777.8 |
871 | 2025-02-04 10:10:32 | wear | 1 | 13983 | 23 | 1.470 | 9512.2 |
870 | 2025-01-27 03:38:43 | wear | 1 | 13983 | 23 | 1.593 | 8777.8 |
869 | 2025-01-26 06:14:46 | wear | 1 | 13983 | 23 | 0.266 | 52567.7 |
868 | 2025-01-25 11:35:34 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
867 | 2025-01-24 15:13:42 | wear | 2 | 29872 | 268 | 2.486 | 12016.1 |
866 | 2025-01-23 19:49:07 | wear | 2 | 29872 | 268 | 5.406 | 5525.7 |
865 | 2025-01-23 19:48:54 | wear | 1 | 13983 | 23 | 0.656 | 21315.5 |
864 | 2025-01-05 10:45:17 | wear | 2 | 29872 | 268 | 5.280 | 5657.6 |
863 | 2025-01-05 10:27:31 | wear | 2 | 29872 | 268 | 0.830 | 35990.4 |
862 | 2025-01-05 08:33:15 | wear | 2 | 29872 | 268 | 2.000 | 14936.0 |
861 | 2025-01-05 08:16:56 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
860 | 2024-12-28 01:05:11 | wear | 1 | 13983 | 23 | 1.220 | 11461.5 |
859 | 2024-12-27 05:38:28 | wear | 1 | 13983 | 23 | 0.656 | 21315.5 |
858 | 2024-12-26 06:40:14 | wear | 1 | 13983 | 23 | 1.203 | 11623.4 |
857 | 2024-12-24 18:18:10 | wear | 1 | 13983 | 23 | 1.140 | 12265.8 |
856 | 2024-12-24 11:09:15 | wear | 1 | 13983 | 23 | 1.623 | 8615.5 |
855 | 2024-12-06 06:11:45 | wear | 2 | 29872 | 268 | 1.893 | 15780.2 |
854 | 2024-12-06 02:57:00 | wear | 2 | 29872 | 268 | 4.000 | 7468.0 |
853 | 2024-12-06 02:35:47 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
852 | 2024-11-27 03:08:19 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
851 | 2024-11-26 09:44:38 | wear | 2 | 29872 | 268 | 6.610 | 4519.2 |
850 | 2024-11-26 05:15:04 | wear | 2 | 29872 | 268 | 5.890 | 5071.6 |
849 | 2024-11-26 01:39:29 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
848 | 2024-11-24 17:15:35 | wear | 1 | 13983 | 23 | 1.126 | 12418.3 |
847 | 2024-11-21 05:16:23 | wear | 1 | 13983 | 23 | 0.793 | 17633.0 |
846 | 2024-11-06 05:50:20 | wear | 2 | 29872 | 268 | 4.250 | 7028.7 |
845 | 2024-11-05 22:48:45 | wear | 2 | 29872 | 268 | 2.376 | 12572.4 |
844 | 2024-11-05 22:23:03 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
843 | 2024-10-28 01:59:33 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
842 | 2024-10-27 01:43:31 | wear | 1 | 13983 | 23 | 1.813 | 7712.6 |
841 | 2024-10-25 13:33:13 | wear | 1 | 13983 | 23 | 1.076 | 12995.4 |
840 | 2024-10-07 06:33:09 | wear | 2 | 29872 | 268 | 6.406 | 4663.1 |
839 | 2024-10-06 20:32:10 | wear | 2 | 29872 | 268 | 6.406 | 4663.1 |
838 | 2024-10-06 20:28:17 | wear | 1 | 13983 | 23 | 2.170 | 6443.8 |
837 | 2024-10-03 18:04:57 | wear | 1 | 13983 | 23 | 1.906 | 7336.3 |
836 | 2024-09-27 21:53:21 | wear | 1 | 13983 | 23 | 1.720 | 8129.7 |
835 | 2024-09-26 23:18:31 | wear | 1 | 13983 | 23 | 1.953 | 7159.8 |
834 | 2024-09-25 11:22:49 | wear | 1 | 13983 | 23 | 1.953 | 7159.8 |
833 | 2024-09-16 18:01:12 | wear | 1 | 13983 | 23 | 1.686 | 8293.6 |
832 | 2024-09-06 20:52:05 | wear | 1 | 13983 | 23 | 2.826 | 4948.0 |
831 | 2024-08-30 07:24:31 | wear | 1 | 13983 | 23 | 2.580 | 5419.8 |
830 | 2024-08-28 20:39:24 | wear | 2 | 29872 | 268 | 2.936 | 10174.4 |
829 | 2024-08-28 19:13:21 | wear | 2 | 29872 | 268 | 8.733 | 3420.6 |
828 | 2024-08-28 17:11:06 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
827 | 2024-08-27 18:47:56 | wear | 1 | 13983 | 23 | 2.546 | 5492.1 |
826 | 2024-08-26 10:49:07 | wear | 1 | 13983 | 23 | 0.766 | 18254.6 |
825 | 2024-08-19 16:01:50 | wear | 2 | 29872 | 268 | 4.220 | 7078.7 |
824 | 2024-08-09 13:45:23 | wear | 1 | 13983 | 23 | 1.093 | 12793.2 |
823 | 2024-08-09 07:35:16 | wear | 1 | 13983 | 23 | 0.266 | 52567.7 |
822 | 2024-08-07 20:05:44 | wear | 1 | 13983 | 23 | 1.810 | 7725.4 |
821 | 2024-08-02 06:02:51 | wear | 2 | 29872 | 268 | 1.220 | 24485.2 |
820 | 2024-08-02 05:33:36 | wear | 1 | 13983 | 23 | 0.266 | 52567.7 |
819 | 2024-07-31 14:27:04 | wear | 2 | 29872 | 268 | 2.220 | 13455.9 |
818 | 2024-07-29 09:45:29 | wear | 1 | 13983 | 23 | 0.486 | 28771.6 |
817 | 2024-07-29 09:28:57 | wear | 1 | 13983 | 23 | 0.483 | 28950.3 |
816 | 2024-07-29 05:45:12 | wear | 1 | 13983 | 23 | 0.500 | 27966.0 |
815 | 2024-07-28 09:46:51 | wear | 1 | 13983 | 23 | 1.203 | 11623.4 |
814 | 2024-07-28 04:46:49 | wear | 2 | 29872 | 268 | 4.530 | 6594.3 |
813 | 2024-07-27 11:51:16 | wear | 2 | 29872 | 268 | 4.826 | 6189.8 |
812 | 2024-07-27 08:48:32 | wear | 2 | 29872 | 268 | 1.453 | 20558.8 |
811 | 2024-07-27 08:48:25 | wear | 1 | 13983 | 23 | 0.360 | 38841.7 |
810 | 2024-07-11 05:02:59 | wear | 1 | 13983 | 23 | 0.546 | 25609.9 |
809 | 2024-07-06 01:38:48 | wear | 1 | 13983 | 23 | 1.203 | 11623.4 |
808 | 2024-07-05 20:13:11 | wear | 1 | 13983 | 23 | 0.626 | 22337.1 |