History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prospectus"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
147 | 2024-05-26 17:57:46 | prospectus | 1 | 67641 | 2 | 1.360 | 49736.0 |
146 | 2024-05-20 15:19:36 | prospectus | 2 | 108824 | 9 | 3.846 | 28295.4 |
145 | 2024-05-20 14:00:52 | prospectus | 2 | 108824 | 9 | 10.873 | 10008.6 |
144 | 2024-05-17 14:19:56 | prospectus | 3 | 140603 | 22 | 19.563 | 7187.2 |
143 | 2024-05-17 14:19:55 | prospectus | 2 | 108824 | 9 | 3.800 | 28637.9 |
142 | 2024-05-17 14:19:00 | prospectus | 1 | 67641 | 2 | 1.390 | 48662.6 |
141 | 2024-05-12 13:18:18 | prospectus | 3 | 140603 | 22 | 21.173 | 6640.7 |
140 | 2024-05-12 13:18:13 | prospectus | 2 | 108824 | 9 | 11.203 | 9713.8 |
139 | 2024-05-12 13:13:02 | prospectus | 1 | 67641 | 2 | 4.080 | 16578.7 |
138 | 2024-05-01 04:43:23 | prospectus | 3 | 140603 | 22 | 8.936 | 15734.4 |
137 | 2024-05-01 04:43:17 | prospectus | 2 | 108824 | 9 | 6.233 | 17459.3 |
136 | 2024-05-01 04:42:05 | prospectus | 1 | 67641 | 2 | 1.153 | 58665.2 |
135 | 2024-05-01 04:41:40 | prospectus | 1 | 67641 | 2 | 2.563 | 26391.3 |
134 | 2024-05-01 02:18:29 | prospectus | 4 | 161450 | 107 | 14.986 | 10773.4 |
133 | 2024-04-28 09:07:43 | prospectus | 4 | 161450 | 107 | 44.986 | 3588.9 |
132 | 2024-04-20 14:32:46 | prospectus | 1 | 67641 | 2 | 1.220 | 55443.4 |
131 | 2024-04-18 03:29:18 | prospectus | 1 | 67641 | 2 | 1.236 | 54725.7 |
130 | 2024-04-11 07:08:55 | prospectus | 1 | 67641 | 2 | 1.263 | 53555.8 |
129 | 2024-04-08 07:14:58 | prospectus | 1 | 67641 | 2 | 2.593 | 26086.0 |
128 | 2024-04-03 05:04:19 | prospectus | 4 | 161450 | 107 | 24.410 | 6614.1 |
127 | 2024-03-30 18:03:45 | prospectus | 3 | 140603 | 22 | 24.250 | 5798.1 |
126 | 2024-03-30 15:07:37 | prospectus | 1 | 67641 | 2 | 1.890 | 35788.9 |
125 | 2024-03-29 19:59:58 | prospectus | 4 | 161450 | 107 | 20.296 | 7954.8 |
124 | 2024-03-29 19:59:40 | prospectus | 3 | 140603 | 22 | 21.780 | 6455.6 |
123 | 2024-03-29 19:59:39 | prospectus | 2 | 108824 | 9 | 8.546 | 12733.9 |
122 | 2024-03-27 12:44:41 | prospectus | 4 | 161450 | 107 | 29.766 | 5424.0 |
121 | 2024-03-27 12:44:37 | prospectus | 3 | 140603 | 22 | 15.906 | 8839.6 |
120 | 2024-03-27 12:44:33 | prospectus | 2 | 108824 | 9 | 7.530 | 14452.1 |
119 | 2024-03-27 11:22:55 | prospectus | 1 | 67641 | 2 | 1.220 | 55443.4 |
118 | 2024-03-18 20:25:40 | prospectus | 1 | 67641 | 2 | 1.300 | 52031.5 |
117 | 2024-02-28 14:12:39 | prospectus | 1 | 67641 | 2 | 1.280 | 52844.5 |
116 | 2024-02-15 10:28:49 | prospectus | 4 | 161450 | 107 | 25.143 | 6421.3 |
115 | 2024-02-15 10:28:49 | prospectus | 3 | 140603 | 22 | 19.063 | 7375.7 |
114 | 2024-02-15 10:28:48 | prospectus | 2 | 108824 | 9 | 7.456 | 14595.5 |
113 | 2024-02-15 10:05:38 | prospectus | 1 | 67641 | 2 | 1.060 | 63812.3 |
112 | 2024-02-09 19:06:57 | prospectus | 1 | 67641 | 2 | 2.563 | 26391.3 |
111 | 2024-01-31 16:31:20 | prospectus | 1 | 67641 | 2 | 1.236 | 54725.7 |
110 | 2024-01-31 05:15:03 | prospectus | 1 | 67641 | 2 | 1.060 | 63812.3 |
109 | 2024-01-29 07:02:07 | prospectus | 1 | 67641 | 2 | 1.110 | 60937.8 |
108 | 2023-12-31 07:00:07 | prospectus | 1 | 67641 | 2 | 1.140 | 59334.2 |
107 | 2023-12-14 21:01:57 | prospectus | 1 | 67641 | 2 | 1.186 | 57032.9 |
106 | 2023-10-20 14:55:20 | prospectus | 1 | 67641 | 2 | 1.080 | 62630.6 |
105 | 2023-09-27 21:57:11 | prospectus | 1 | 67641 | 2 | 1.046 | 64666.3 |
104 | 2023-08-16 16:26:10 | prospectus | 1 | 67641 | 2 | 1.030 | 65670.9 |
103 | 2023-05-18 18:11:49 | prospectus | 1 | 67641 | 2 | 1.170 | 57812.8 |
102 | 2023-03-14 10:20:38 | prospectus | 1 | 67641 | 2 | 1.033 | 65480.2 |
101 | 2022-07-01 08:15:48 | prospectus | 1 | 67641 | 2 | 1.016 | 66575.8 |
100 | 2021-04-28 01:13:15 | prospectus | 1 | 67641 | 2 | 1.173 | 57665.0 |
99 | 2021-03-27 23:40:17 | prospectus | 1 | 67641 | 2 | 2.313 | 29243.8 |
98 | 2021-01-11 07:27:18 | prospectus | 1 | 67641 | 2 | 1.063 | 63632.2 |
97 | 2020-10-28 03:06:35 | prospectus | 1 | 67641 | 2 | 1.046 | 64666.3 |
96 | 2020-10-27 05:46:45 | prospectus | 1 | 67641 | 2 | 1.030 | 65670.9 |
95 | 2020-10-25 17:45:06 | prospectus | 1 | 67641 | 2 | 1.060 | 63812.3 |
94 | 2020-10-23 13:31:14 | prospectus | 1 | 67641 | 2 | 1.030 | 65670.9 |
93 | 2020-06-12 10:58:19 | prospectus | 1 | 67641 | 2 | 1.280 | 52844.5 |
92 | 2020-03-29 18:20:03 | prospectus | 1 | 67641 | 2 | 1.046 | 64666.3 |
91 | 2020-03-24 12:03:59 | prospectus | 1 | 67641 | 2 | 1.983 | 34110.4 |
90 | 2020-03-17 05:02:50 | prospectus | 1 | 67641 | 2 | 1.033 | 65480.2 |
89 | 2020-02-18 16:35:39 | prospectus | 1 | 67641 | 2 | 1.343 | 50365.6 |
88 | 2020-02-18 13:40:58 | prospectus | 1 | 67641 | 2 | 1.236 | 54725.7 |
87 | 2020-02-13 08:18:24 | prospectus | 1 | 67641 | 2 | 1.173 | 57665.0 |
86 | 2020-02-06 11:36:42 | prospectus | 3 | 140603 | 22 | 12.970 | 10840.6 |
85 | 2020-02-06 11:36:37 | prospectus | 2 | 108824 | 9 | 4.343 | 25057.3 |
84 | 2020-02-05 05:09:28 | prospectus | 1 | 67641 | 2 | 1.720 | 39326.2 |
83 | 2020-02-05 04:19:41 | prospectus | 3 | 140603 | 22 | 21.470 | 6548.8 |
82 | 2020-02-05 04:04:18 | prospectus | 2 | 108824 | 9 | 3.393 | 32073.1 |
81 | 2020-02-05 02:38:14 | prospectus | 4 | 161450 | 107 | 13.660 | 11819.2 |
80 | 2020-02-04 20:24:49 | prospectus | 4 | 161450 | 107 | 17.363 | 9298.5 |
79 | 2020-02-04 00:09:50 | prospectus | 1 | 67641 | 2 | 1.360 | 49736.0 |
78 | 2020-01-30 11:00:18 | prospectus | 1 | 67641 | 2 | 1.513 | 44706.5 |
77 | 2020-01-29 02:49:02 | prospectus | 4 | 161450 | 107 | 43.253 | 3732.7 |
76 | 2020-01-28 05:57:58 | prospectus | 4 | 161450 | 107 | 28.423 | 5680.3 |
75 | 2020-01-18 03:01:51 | prospectus | 1 | 67641 | 2 | 2.466 | 27429.4 |
74 | 2020-01-18 02:00:33 | prospectus | 1 | 67641 | 2 | 1.283 | 52721.0 |
73 | 2020-01-11 00:23:57 | prospectus | 1 | 67641 | 2 | 2.516 | 26884.3 |
72 | 2020-01-06 21:41:15 | prospectus | 2 | 108824 | 9 | 5.673 | 19182.8 |
71 | 2020-01-06 21:38:53 | prospectus | 3 | 140603 | 22 | 9.236 | 15223.4 |
70 | 2020-01-06 21:36:12 | prospectus | 4 | 161450 | 107 | 14.436 | 11183.8 |
69 | 2020-01-06 16:11:44 | prospectus | 1 | 67641 | 2 | 2.376 | 28468.4 |
68 | 2019-12-07 02:30:10 | prospectus | 1 | 67641 | 2 | 1.033 | 65480.2 |
67 | 2019-09-05 01:06:40 | prospectus | 1 | 67641 | 2 | 1.133 | 59700.8 |
66 | 2019-05-20 20:15:22 | prospectus | 1 | 67641 | 2 | 1.043 | 64852.3 |
65 | 2019-02-15 22:23:09 | prospectus | 1 | 67641 | 2 | 2.256 | 29982.7 |
64 | 2019-01-21 03:25:11 | prospectus | 1 | 67641 | 2 | 1.100 | 61491.8 |
63 | 2019-01-13 18:29:51 | prospectus | 1 | 67641 | 2 | 1.003 | 67438.7 |
62 | 2019-01-03 02:46:31 | prospectus | 1 | 67641 | 2 | 0.993 | 68117.8 |
61 | 2019-01-02 21:44:13 | prospectus | 1 | 67641 | 2 | 1.113 | 60773.6 |
60 | 2019-01-02 13:29:14 | prospectus | 1 | 67641 | 2 | 1.016 | 66575.8 |
59 | 2018-12-15 18:16:50 | prospectus | 1 | 67641 | 2 | 0.996 | 67912.7 |
58 | 2018-08-24 13:41:22 | prospectus | 1 | 67641 | 2 | 1.090 | 62056.0 |
57 | 2018-01-07 08:25:28 | prospectus | 1 | 67641 | 2 | 1.836 | 36841.5 |
56 | 2017-11-09 17:45:57 | prospectus | 1 | 67641 | 2 | 1.520 | 44500.7 |
55 | 2017-04-02 13:58:43 | prospectus | 1 | 67641 | 2 | 1.406 | 48108.8 |
54 | 2017-02-01 21:13:58 | prospectus | 1 | 67641 | 2 | 1.270 | 53260.6 |
53 | 2016-12-04 15:59:22 | prospectus | 4 | 161450 | 107 | 15.723 | 10268.4 |
52 | 2016-08-31 18:32:04 | prospectus | 1 | 67641 | 2 | 1.366 | 49517.6 |
51 | 2016-08-03 19:03:46 | prospectus | 1 | 67641 | 2 | 1.680 | 40262.5 |
50 | 2016-07-24 13:46:02 | prospectus | 2 | 108824 | 9 | 6.420 | 16950.8 |
49 | 2016-07-02 00:08:34 | prospectus | 1 | 67641 | 2 | 1.943 | 34812.7 |
48 | 2016-06-23 16:12:44 | prospectus | 1 | 67641 | 2 | 1.796 | 37662.0 |