History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"collectors"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
253 | 2024-04-27 14:21:54 | collectors | 2 | 108824 | 8 | 6.716 | 16203.7 |
252 | 2024-04-27 12:30:26 | collectors | 1 | 67641 | 2 | 1.610 | 42013.0 |
251 | 2024-04-26 17:55:52 | collectors | 1 | 67641 | 2 | 2.750 | 24596.7 |
250 | 2024-04-16 03:42:38 | collectors | 3 | 140603 | 47 | 14.563 | 9654.8 |
249 | 2024-04-14 19:58:12 | collectors | 3 | 140603 | 47 | 17.220 | 8165.1 |
248 | 2024-04-14 07:44:38 | collectors | 3 | 140603 | 47 | 8.296 | 16948.3 |
247 | 2024-04-14 02:31:04 | collectors | 1 | 67641 | 2 | 1.343 | 50365.6 |
246 | 2024-04-08 06:30:47 | collectors | 4 | 161450 | 225 | 40.863 | 3951.0 |
245 | 2024-04-04 10:36:47 | collectors | 2 | 108824 | 8 | 11.406 | 9540.9 |
244 | 2024-04-04 10:35:33 | collectors | 1 | 67641 | 2 | 2.670 | 25333.7 |
243 | 2024-04-04 03:04:59 | collectors | 4 | 161450 | 225 | 38.673 | 4174.7 |
242 | 2024-04-04 02:48:50 | collectors | 3 | 140603 | 47 | 16.250 | 8652.5 |
241 | 2024-04-01 07:38:00 | collectors | 4 | 161450 | 225 | 38.470 | 4196.8 |
240 | 2024-04-01 07:38:06 | collectors | 2 | 108824 | 8 | 11.233 | 9687.9 |
239 | 2024-04-01 07:37:55 | collectors | 3 | 140603 | 47 | 13.110 | 10724.9 |
238 | 2024-04-01 06:52:30 | collectors | 1 | 67641 | 2 | 1.343 | 50365.6 |
237 | 2024-03-27 12:29:06 | collectors | 2 | 108824 | 8 | 7.453 | 14601.4 |
236 | 2024-03-27 11:43:24 | collectors | 1 | 67641 | 2 | 1.233 | 54858.9 |
235 | 2024-03-27 08:54:09 | collectors | 1 | 67641 | 2 | 1.266 | 53428.9 |
234 | 2024-03-15 16:39:54 | collectors | 4 | 161450 | 225 | 24.080 | 6704.7 |
233 | 2024-03-15 16:39:55 | collectors | 2 | 108824 | 8 | 9.266 | 11744.4 |
232 | 2024-03-15 15:51:43 | collectors | 1 | 67641 | 2 | 1.173 | 57665.0 |
231 | 2024-03-11 21:53:03 | collectors | 1 | 67641 | 2 | 2.546 | 26567.6 |
230 | 2024-03-10 11:31:08 | collectors | 3 | 140603 | 47 | 8.360 | 16818.5 |
229 | 2024-03-08 08:15:20 | collectors | 2 | 108824 | 8 | 9.893 | 11000.1 |
228 | 2024-03-08 08:08:21 | collectors | 1 | 67641 | 2 | 1.280 | 52844.5 |
227 | 2024-03-04 20:12:50 | collectors | 4 | 161450 | 225 | 34.283 | 4709.3 |
226 | 2024-03-03 17:19:13 | collectors | 4 | 161450 | 225 | 29.970 | 5387.1 |
225 | 2024-03-03 17:19:11 | collectors | 3 | 140603 | 47 | 24.186 | 5813.4 |
224 | 2024-03-03 17:19:11 | collectors | 2 | 108824 | 8 | 11.033 | 9863.5 |
223 | 2024-03-03 17:07:39 | collectors | 1 | 67641 | 2 | 1.203 | 56226.9 |
222 | 2024-02-27 12:41:09 | collectors | 1 | 67641 | 2 | 1.216 | 55625.8 |
221 | 2024-02-07 08:15:10 | collectors | 1 | 67641 | 2 | 1.186 | 57032.9 |
220 | 2024-02-06 00:44:25 | collectors | 1 | 67641 | 2 | 1.110 | 60937.8 |
219 | 2024-01-26 20:56:43 | collectors | 1 | 67641 | 2 | 1.190 | 56841.2 |
218 | 2024-01-15 16:29:38 | collectors | 4 | 161450 | 225 | 11.720 | 13775.6 |
217 | 2024-01-15 08:54:39 | collectors | 2 | 108824 | 8 | 2.703 | 40260.5 |
216 | 2024-01-04 13:35:28 | collectors | 1 | 67641 | 2 | 1.220 | 55443.4 |
215 | 2023-12-16 12:41:54 | collectors | 1 | 67641 | 2 | 1.156 | 58513.0 |
214 | 2023-11-23 18:16:12 | collectors | 4 | 161450 | 225 | 13.250 | 12184.9 |
213 | 2023-11-08 00:07:56 | collectors | 1 | 67641 | 2 | 1.173 | 57665.0 |
212 | 2023-10-25 15:41:51 | collectors | 2 | 108824 | 8 | 2.656 | 40972.9 |
211 | 2023-10-24 18:38:04 | collectors | 4 | 161450 | 225 | 10.986 | 14696.0 |
210 | 2023-10-02 20:31:11 | collectors | 1 | 67641 | 2 | 1.123 | 60232.4 |
209 | 2023-09-28 16:29:36 | collectors | 1 | 67641 | 2 | 1.220 | 55443.4 |
208 | 2023-09-02 04:17:26 | collectors | 1 | 67641 | 2 | 1.156 | 58513.0 |
207 | 2023-08-03 23:33:59 | collectors | 2 | 108824 | 8 | 2.813 | 38686.1 |
206 | 2023-08-03 00:15:33 | collectors | 4 | 161450 | 225 | 12.766 | 12646.9 |
205 | 2023-07-30 07:17:13 | collectors | 1 | 67641 | 2 | 1.060 | 63812.3 |
204 | 2023-07-15 13:49:59 | collectors | 1 | 67641 | 2 | 1.126 | 60071.9 |
203 | 2023-05-05 14:25:03 | collectors | 1 | 67641 | 2 | 1.093 | 61885.6 |
202 | 2023-04-26 21:28:00 | collectors | 1 | 67641 | 2 | 1.173 | 57665.0 |
201 | 2023-04-13 09:28:20 | collectors | 4 | 161450 | 225 | 9.280 | 17397.6 |
200 | 2023-04-10 22:40:10 | collectors | 2 | 108824 | 8 | 3.030 | 35915.5 |
199 | 2023-02-16 16:02:54 | collectors | 1 | 67641 | 2 | 1.016 | 66575.8 |
198 | 2023-01-21 09:13:37 | collectors | 4 | 161450 | 225 | 10.686 | 15108.6 |
197 | 2023-01-15 21:53:04 | collectors | 2 | 108824 | 8 | 2.656 | 40972.9 |
196 | 2023-01-12 02:30:15 | collectors | 1 | 67641 | 2 | 1.126 | 60071.9 |
195 | 2022-12-15 19:55:45 | collectors | 1 | 67641 | 2 | 1.063 | 63632.2 |
194 | 2022-11-01 12:28:09 | collectors | 4 | 161450 | 225 | 9.360 | 17248.9 |
193 | 2022-10-15 13:53:53 | collectors | 2 | 108824 | 8 | 2.860 | 38050.3 |
192 | 2022-09-10 04:48:15 | collectors | 1 | 67641 | 2 | 1.030 | 65670.9 |
191 | 2022-08-26 23:22:22 | collectors | 1 | 67641 | 2 | 1.013 | 66773.0 |
190 | 2022-06-02 20:29:17 | collectors | 4 | 161450 | 225 | 9.733 | 16587.9 |
189 | 2022-05-17 01:26:56 | collectors | 2 | 108824 | 8 | 3.343 | 32552.8 |
188 | 2022-04-27 05:39:57 | collectors | 1 | 67641 | 2 | 1.060 | 63812.3 |
187 | 2022-04-14 00:33:21 | collectors | 1 | 67641 | 2 | 1.280 | 52844.5 |
186 | 2022-01-23 09:24:15 | collectors | 1 | 67641 | 2 | 1.093 | 61885.6 |
185 | 2022-01-11 21:33:09 | collectors | 1 | 67641 | 2 | 1.216 | 55625.8 |
184 | 2021-12-31 21:29:08 | collectors | 1 | 67641 | 2 | 1.143 | 59178.5 |
183 | 2021-12-08 22:18:07 | collectors | 1 | 67641 | 2 | 1.190 | 56841.2 |
182 | 2021-11-14 02:41:58 | collectors | 1 | 67641 | 2 | 1.046 | 64666.3 |
181 | 2021-11-12 00:15:43 | collectors | 1 | 67641 | 2 | 1.063 | 63632.2 |
180 | 2021-10-01 18:59:07 | collectors | 1 | 67641 | 2 | 1.216 | 55625.8 |
179 | 2021-09-29 15:40:24 | collectors | 1 | 67641 | 2 | 1.046 | 64666.3 |
178 | 2021-09-11 22:53:22 | collectors | 1 | 67641 | 2 | 2.406 | 28113.5 |
177 | 2021-06-11 14:12:38 | collectors | 1 | 67641 | 2 | 1.156 | 58513.0 |
176 | 2021-05-09 06:02:19 | collectors | 1 | 67641 | 2 | 2.283 | 29628.1 |
175 | 2021-03-12 05:07:44 | collectors | 1 | 67641 | 2 | 1.093 | 61885.6 |
174 | 2021-02-23 02:00:11 | collectors | 4 | 161450 | 225 | 10.546 | 15309.1 |
173 | 2021-01-22 20:35:41 | collectors | 1 | 67641 | 2 | 1.203 | 56226.9 |
172 | 2020-12-24 04:27:37 | collectors | 1 | 67641 | 2 | 1.156 | 58513.0 |
171 | 2020-12-09 01:32:27 | collectors | 1 | 67641 | 2 | 1.063 | 63632.2 |
170 | 2020-10-29 11:35:09 | collectors | 1 | 67641 | 2 | 1.156 | 58513.0 |
169 | 2020-09-05 23:46:26 | collectors | 1 | 67641 | 2 | 1.063 | 63632.2 |
168 | 2020-08-06 11:47:50 | collectors | 1 | 67641 | 2 | 1.080 | 62630.6 |
167 | 2020-05-25 13:29:04 | collectors | 1 | 67641 | 2 | 1.033 | 65480.2 |
166 | 2020-03-25 09:01:04 | collectors | 1 | 67641 | 2 | 1.093 | 61885.6 |
165 | 2020-02-28 00:32:33 | collectors | 1 | 67641 | 2 | 1.673 | 40431.0 |
164 | 2020-02-25 06:39:13 | collectors | 1 | 67641 | 2 | 2.423 | 27916.2 |
163 | 2020-02-23 11:51:27 | collectors | 1 | 67641 | 2 | 1.796 | 37662.0 |
162 | 2020-02-11 01:56:56 | collectors | 1 | 67641 | 2 | 1.796 | 37662.0 |
161 | 2020-02-10 17:47:00 | collectors | 1 | 67641 | 2 | 2.720 | 24868.0 |
160 | 2020-02-10 14:12:26 | collectors | 1 | 67641 | 2 | 1.203 | 56226.9 |
159 | 2020-02-04 10:33:48 | collectors | 2 | 108824 | 8 | 4.626 | 23524.4 |
158 | 2020-02-04 09:49:34 | collectors | 1 | 67641 | 2 | 1.330 | 50857.9 |
157 | 2020-01-30 00:53:10 | collectors | 1 | 67641 | 2 | 1.123 | 60232.4 |
156 | 2020-01-27 08:31:51 | collectors | 1 | 67641 | 2 | 1.280 | 52844.5 |
155 | 2020-01-27 03:46:15 | collectors | 1 | 67641 | 2 | 1.360 | 49736.0 |
154 | 2020-01-20 12:11:35 | collectors | 1 | 67641 | 2 | 1.233 | 54858.9 |