History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mainlines"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
272 | 2024-03-18 18:04:04 | mainlines | 2 | 121436 | 15 | 7.923 | 15327.0 |
271 | 2024-03-18 18:01:59 | mainlines | 3 | 148641 | 117 | 8.513 | 17460.5 |
270 | 2024-03-15 23:38:24 | mainlines | 3 | 148641 | 117 | 29.376 | 5059.9 |
269 | 2024-03-14 14:49:42 | mainlines | 2 | 121436 | 15 | 12.156 | 9989.8 |
268 | 2024-03-14 14:49:30 | mainlines | 3 | 148641 | 117 | 11.423 | 13012.4 |
267 | 2024-03-14 13:56:52 | mainlines | 1 | 81242 | 5 | 2.936 | 27671.0 |
266 | 2024-03-12 09:21:41 | mainlines | 3 | 148641 | 117 | 17.843 | 8330.5 |
265 | 2024-03-12 09:21:43 | mainlines | 2 | 121436 | 15 | 12.296 | 9876.1 |
264 | 2024-03-12 06:53:51 | mainlines | 1 | 81242 | 5 | 1.436 | 56575.2 |
263 | 2024-02-28 21:09:18 | mainlines | 1 | 81242 | 5 | 1.436 | 56575.2 |
262 | 2024-02-26 12:03:12 | mainlines | 1 | 81242 | 5 | 3.110 | 26122.8 |
261 | 2024-02-10 06:46:39 | mainlines | 1 | 81242 | 5 | 1.513 | 53696.0 |
260 | 2024-02-05 09:26:49 | mainlines | 1 | 81242 | 5 | 1.826 | 44491.8 |
259 | 2024-02-04 08:43:23 | mainlines | 1 | 81242 | 5 | 1.563 | 51978.2 |
258 | 2024-02-01 14:50:39 | mainlines | 1 | 81242 | 5 | 1.393 | 58321.6 |
257 | 2024-01-29 15:57:03 | mainlines | 1 | 81242 | 5 | 2.876 | 28248.3 |
256 | 2024-01-27 11:41:41 | mainlines | 1 | 81242 | 5 | 1.453 | 55913.3 |
255 | 2023-12-28 21:20:11 | mainlines | 2 | 121436 | 15 | 9.656 | 12576.2 |
254 | 2023-12-28 21:20:11 | mainlines | 3 | 148641 | 117 | 7.876 | 18872.7 |
253 | 2023-12-28 20:28:28 | mainlines | 2 | 121436 | 15 | 3.563 | 34082.5 |
252 | 2023-12-13 17:34:00 | mainlines | 3 | 148641 | 117 | 6.266 | 23721.8 |
251 | 2023-11-28 06:49:44 | mainlines | 1 | 81242 | 5 | 1.266 | 64172.2 |
250 | 2023-11-20 01:52:09 | mainlines | 1 | 81242 | 5 | 1.250 | 64993.6 |
249 | 2023-11-13 03:47:50 | mainlines | 1 | 81242 | 5 | 3.000 | 27080.7 |
248 | 2023-11-06 19:46:47 | mainlines | 1 | 81242 | 5 | 1.236 | 65729.8 |
247 | 2023-10-25 23:01:27 | mainlines | 3 | 148641 | 117 | 6.436 | 23095.2 |
246 | 2023-10-25 23:00:55 | mainlines | 2 | 121436 | 15 | 6.096 | 19920.6 |
245 | 2023-10-25 19:16:02 | mainlines | 1 | 81242 | 5 | 1.550 | 52414.2 |
244 | 2023-10-25 19:05:36 | mainlines | 1 | 81242 | 5 | 1.406 | 57782.4 |
243 | 2023-10-14 23:10:30 | mainlines | 1 | 81242 | 5 | 1.250 | 64993.6 |
242 | 2023-10-01 20:49:20 | mainlines | 2 | 121436 | 15 | 3.216 | 37760.0 |
241 | 2023-09-14 13:32:11 | mainlines | 1 | 81242 | 5 | 2.483 | 32719.3 |
240 | 2023-09-14 13:29:59 | mainlines | 3 | 148641 | 117 | 6.423 | 23142.0 |
239 | 2023-07-12 12:40:43 | mainlines | 2 | 121436 | 15 | 6.890 | 17625.0 |
238 | 2023-06-29 19:38:50 | mainlines | 1 | 81242 | 5 | 1.343 | 60492.9 |
237 | 2023-06-24 08:43:28 | mainlines | 1 | 81242 | 5 | 1.356 | 59913.0 |
236 | 2023-06-04 12:05:07 | mainlines | 3 | 148641 | 117 | 6.703 | 22175.3 |
235 | 2023-04-08 17:02:11 | mainlines | 1 | 81242 | 5 | 1.343 | 60492.9 |
234 | 2023-03-27 14:35:32 | mainlines | 2 | 121436 | 15 | 3.140 | 38673.9 |
233 | 2023-03-15 09:48:25 | mainlines | 1 | 81242 | 5 | 1.360 | 59736.8 |
232 | 2023-03-10 02:52:21 | mainlines | 3 | 148641 | 117 | 6.143 | 24196.8 |
231 | 2023-02-04 07:01:09 | mainlines | 1 | 81242 | 5 | 1.423 | 57092.1 |
230 | 2023-01-30 03:19:53 | mainlines | 1 | 81242 | 5 | 1.406 | 57782.4 |
229 | 2022-12-25 07:46:28 | mainlines | 2 | 121436 | 15 | 3.063 | 39646.1 |
228 | 2022-12-19 05:14:49 | mainlines | 1 | 81242 | 5 | 1.266 | 64172.2 |
227 | 2022-12-14 02:15:21 | mainlines | 3 | 148641 | 117 | 6.313 | 23545.2 |
226 | 2022-12-04 09:51:41 | mainlines | 1 | 81242 | 5 | 1.266 | 64172.2 |
225 | 2022-11-28 04:34:37 | mainlines | 1 | 81242 | 5 | 1.203 | 67532.8 |
224 | 2022-11-25 00:22:46 | mainlines | 1 | 81242 | 5 | 1.423 | 57092.1 |
223 | 2022-11-24 17:14:14 | mainlines | 1 | 81242 | 5 | 1.420 | 57212.7 |
222 | 2022-11-24 01:05:56 | mainlines | 1 | 81242 | 5 | 1.233 | 65889.7 |
221 | 2022-11-09 09:06:53 | mainlines | 1 | 81242 | 5 | 1.470 | 55266.7 |
220 | 2022-08-25 10:29:07 | mainlines | 2 | 121436 | 15 | 3.530 | 34401.1 |
219 | 2022-08-02 08:05:16 | mainlines | 3 | 148641 | 117 | 6.330 | 23482.0 |
218 | 2022-07-27 19:30:09 | mainlines | 1 | 81242 | 5 | 1.373 | 59171.2 |
217 | 2022-07-24 07:46:00 | mainlines | 1 | 81242 | 5 | 1.233 | 65889.7 |
216 | 2022-04-02 05:17:47 | mainlines | 1 | 81242 | 5 | 1.453 | 55913.3 |
215 | 2022-03-29 18:13:55 | mainlines | 1 | 81242 | 5 | 1.250 | 64993.6 |
214 | 2022-03-19 06:11:23 | mainlines | 1 | 81242 | 5 | 1.250 | 64993.6 |
213 | 2021-12-31 14:08:49 | mainlines | 1 | 81242 | 5 | 1.486 | 54671.6 |
212 | 2021-12-29 11:02:53 | mainlines | 1 | 81242 | 5 | 1.280 | 63470.3 |
211 | 2021-12-27 02:37:08 | mainlines | 1 | 81242 | 5 | 1.313 | 61875.1 |
210 | 2021-12-18 13:22:49 | mainlines | 1 | 81242 | 5 | 1.266 | 64172.2 |
209 | 2021-11-15 02:35:22 | mainlines | 1 | 81242 | 5 | 1.233 | 65889.7 |
208 | 2021-09-20 18:35:12 | mainlines | 1 | 81242 | 5 | 1.576 | 51549.5 |
207 | 2021-09-14 14:04:50 | mainlines | 1 | 81242 | 5 | 1.606 | 50586.6 |
206 | 2021-09-14 06:29:43 | mainlines | 1 | 81242 | 5 | 1.266 | 64172.2 |
205 | 2021-09-09 20:02:08 | mainlines | 3 | 148641 | 117 | 7.140 | 20818.1 |
204 | 2021-08-15 00:36:08 | mainlines | 2 | 121436 | 15 | 3.343 | 36325.5 |
203 | 2021-08-06 18:13:50 | mainlines | 3 | 148641 | 117 | 6.373 | 23323.6 |
202 | 2021-08-06 03:16:43 | mainlines | 1 | 81242 | 5 | 1.233 | 65889.7 |
201 | 2021-07-12 11:23:45 | mainlines | 2 | 121436 | 15 | 3.296 | 36843.4 |
200 | 2021-06-20 08:09:19 | mainlines | 1 | 81242 | 5 | 1.266 | 64172.2 |
199 | 2021-06-14 10:34:23 | mainlines | 1 | 81242 | 5 | 1.406 | 57782.4 |
198 | 2021-05-29 05:06:38 | mainlines | 1 | 81242 | 5 | 1.423 | 57092.1 |
197 | 2021-05-11 11:32:28 | mainlines | 1 | 81242 | 5 | 1.546 | 52549.8 |
196 | 2021-05-03 14:22:46 | mainlines | 1 | 81242 | 5 | 1.280 | 63470.3 |
195 | 2021-04-01 19:32:14 | mainlines | 1 | 81242 | 5 | 1.450 | 56029.0 |
194 | 2021-03-11 14:52:00 | mainlines | 1 | 81242 | 5 | 1.280 | 63470.3 |
193 | 2021-02-17 15:45:26 | mainlines | 1 | 81242 | 5 | 1.393 | 58321.6 |
192 | 2021-01-16 21:51:09 | mainlines | 1 | 81242 | 5 | 1.440 | 56418.1 |
191 | 2020-12-08 10:50:43 | mainlines | 1 | 81242 | 5 | 1.250 | 64993.6 |
190 | 2020-10-27 10:44:46 | mainlines | 1 | 81242 | 5 | 1.376 | 59042.2 |
189 | 2020-10-25 07:52:10 | mainlines | 1 | 81242 | 5 | 1.313 | 61875.1 |
188 | 2020-10-12 19:50:23 | mainlines | 1 | 81242 | 5 | 1.220 | 66591.8 |
187 | 2020-10-11 04:10:16 | mainlines | 1 | 81242 | 5 | 1.420 | 57212.7 |
186 | 2020-10-02 23:32:22 | mainlines | 1 | 81242 | 5 | 1.233 | 65889.7 |
185 | 2020-09-05 09:39:45 | mainlines | 1 | 81242 | 5 | 1.233 | 65889.7 |
184 | 2020-08-28 18:00:59 | mainlines | 1 | 81242 | 5 | 1.516 | 53589.7 |
183 | 2020-08-23 05:04:49 | mainlines | 1 | 81242 | 5 | 1.250 | 64993.6 |
182 | 2020-06-06 04:09:19 | mainlines | 1 | 81242 | 5 | 1.266 | 64172.2 |
181 | 2020-06-03 07:19:00 | mainlines | 1 | 81242 | 5 | 1.546 | 52549.8 |
180 | 2020-03-21 15:10:21 | mainlines | 1 | 81242 | 5 | 1.483 | 54782.2 |
179 | 2020-03-14 01:07:37 | mainlines | 1 | 81242 | 5 | 1.376 | 59042.2 |
178 | 2020-02-28 02:17:28 | mainlines | 1 | 81242 | 5 | 2.890 | 28111.4 |
177 | 2020-02-24 18:22:20 | mainlines | 1 | 81242 | 5 | 1.483 | 54782.2 |
176 | 2020-02-24 11:37:43 | mainlines | 1 | 81242 | 5 | 1.313 | 61875.1 |
175 | 2020-02-22 09:02:38 | mainlines | 1 | 81242 | 5 | 1.533 | 52995.4 |
174 | 2020-02-17 10:53:19 | mainlines | 1 | 81242 | 5 | 1.626 | 49964.3 |
173 | 2020-02-08 20:23:57 | mainlines | 1 | 81242 | 5 | 2.923 | 27794.0 |