History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aromatase"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
320 | 2024-05-23 08:58:29 | aromatase | 1 | 81242 | 2 | 4.703 | 17274.5 |
319 | 2024-05-16 18:31:22 | aromatase | 1 | 81242 | 2 | 1.250 | 64993.6 |
318 | 2024-05-16 03:54:29 | aromatase | 4 | 165329 | 197 | 16.813 | 9833.4 |
317 | 2024-05-13 23:06:56 | aromatase | 4 | 165329 | 197 | 44.300 | 3732.0 |
316 | 2024-05-11 18:57:39 | aromatase | 3 | 148641 | 16 | 22.953 | 6475.9 |
315 | 2024-05-10 02:09:33 | aromatase | 3 | 148641 | 16 | 9.016 | 16486.4 |
314 | 2024-05-09 10:50:43 | aromatase | 4 | 165329 | 197 | 49.300 | 3353.5 |
313 | 2024-05-09 10:50:45 | aromatase | 3 | 148641 | 16 | 17.516 | 8486.0 |
312 | 2024-05-09 10:29:47 | aromatase | 1 | 81242 | 2 | 3.110 | 26122.8 |
311 | 2024-05-07 14:38:31 | aromatase | 3 | 148641 | 16 | 24.313 | 6113.6 |
310 | 2024-05-07 14:38:26 | aromatase | 2 | 121436 | 3 | 11.703 | 10376.5 |
309 | 2024-05-07 11:55:11 | aromatase | 1 | 81242 | 2 | 1.640 | 49537.8 |
308 | 2024-05-02 06:40:26 | aromatase | 3 | 148641 | 16 | 22.563 | 6587.8 |
307 | 2024-05-02 06:40:21 | aromatase | 2 | 121436 | 3 | 11.843 | 10253.8 |
306 | 2024-05-01 23:49:41 | aromatase | 1 | 81242 | 2 | 1.483 | 54782.2 |
305 | 2024-05-01 18:38:51 | aromatase | 1 | 81242 | 2 | 1.360 | 59736.8 |
304 | 2024-04-20 11:21:43 | aromatase | 1 | 81242 | 2 | 7.250 | 11205.8 |
303 | 2024-04-12 00:15:44 | aromatase | 4 | 165329 | 197 | 40.906 | 4041.7 |
302 | 2024-04-11 15:59:59 | aromatase | 4 | 165329 | 197 | 11.313 | 14614.1 |
301 | 2024-04-08 23:09:06 | aromatase | 4 | 165329 | 197 | 53.596 | 3084.7 |
300 | 2024-04-08 23:08:09 | aromatase | 3 | 148641 | 16 | 16.940 | 8774.6 |
299 | 2024-04-08 18:44:31 | aromatase | 4 | 165329 | 197 | 32.346 | 5111.3 |
298 | 2024-04-08 09:00:05 | aromatase | 4 | 165329 | 197 | 43.350 | 3813.8 |
297 | 2024-04-08 09:00:04 | aromatase | 3 | 148641 | 16 | 24.656 | 6028.6 |
296 | 2024-04-08 09:00:05 | aromatase | 2 | 121436 | 3 | 13.296 | 9133.3 |
295 | 2024-04-08 07:17:33 | aromatase | 1 | 81242 | 2 | 1.516 | 53589.7 |
294 | 2024-04-05 18:16:32 | aromatase | 1 | 81242 | 2 | 3.250 | 24997.5 |
293 | 2024-03-18 12:20:42 | aromatase | 2 | 121436 | 3 | 4.313 | 28155.8 |
292 | 2024-03-18 11:10:46 | aromatase | 1 | 81242 | 2 | 1.653 | 49148.2 |
291 | 2024-03-10 16:29:36 | aromatase | 4 | 165329 | 197 | 42.486 | 3891.4 |
290 | 2024-03-10 11:16:03 | aromatase | 4 | 165329 | 197 | 35.563 | 4648.9 |
289 | 2024-03-10 09:41:00 | aromatase | 3 | 148641 | 16 | 17.843 | 8330.5 |
288 | 2024-03-09 17:46:03 | aromatase | 4 | 165329 | 197 | 29.706 | 5565.5 |
287 | 2024-03-09 00:38:05 | aromatase | 4 | 165329 | 197 | 41.096 | 4023.0 |
286 | 2024-03-09 00:38:04 | aromatase | 3 | 148641 | 16 | 23.033 | 6453.4 |
285 | 2024-03-09 00:38:06 | aromatase | 2 | 121436 | 3 | 8.016 | 15149.2 |
284 | 2024-03-08 23:14:49 | aromatase | 1 | 81242 | 2 | 1.420 | 57212.7 |
283 | 2024-03-02 00:45:38 | aromatase | 1 | 81242 | 2 | 3.296 | 24648.7 |
282 | 2024-02-28 11:54:50 | aromatase | 1 | 81242 | 2 | 1.533 | 52995.4 |
281 | 2024-02-26 03:50:32 | aromatase | 1 | 81242 | 2 | 4.876 | 16661.6 |
280 | 2024-02-20 23:17:22 | aromatase | 2 | 121436 | 3 | 3.906 | 31089.6 |
279 | 2024-02-07 19:10:47 | aromatase | 3 | 148641 | 16 | 21.113 | 7040.3 |
278 | 2024-02-07 19:10:41 | aromatase | 2 | 121436 | 3 | 8.016 | 15149.2 |
277 | 2024-02-04 11:16:36 | aromatase | 4 | 165329 | 197 | 44.410 | 3722.8 |
276 | 2024-02-03 14:02:54 | aromatase | 4 | 165329 | 197 | 12.016 | 13759.1 |
275 | 2024-02-03 14:03:02 | aromatase | 2 | 121436 | 3 | 3.720 | 32644.1 |
274 | 2024-02-03 14:02:58 | aromatase | 3 | 148641 | 16 | 7.326 | 20289.5 |
273 | 2024-02-03 13:59:50 | aromatase | 1 | 81242 | 2 | 1.250 | 64993.6 |
272 | 2024-01-23 03:16:00 | aromatase | 1 | 81242 | 2 | 1.310 | 62016.8 |
271 | 2023-12-31 16:38:58 | aromatase | 1 | 81242 | 2 | 1.296 | 62686.7 |
270 | 2023-12-25 22:56:52 | aromatase | 1 | 81242 | 2 | 1.310 | 62016.8 |
269 | 2023-12-08 22:56:28 | aromatase | 4 | 165329 | 197 | 10.686 | 15471.6 |
268 | 2023-11-20 19:29:18 | aromatase | 1 | 81242 | 2 | 1.500 | 54161.3 |
267 | 2023-11-19 18:49:23 | aromatase | 2 | 121436 | 3 | 3.593 | 33797.9 |
266 | 2023-09-07 14:26:49 | aromatase | 1 | 81242 | 2 | 1.236 | 65729.8 |
265 | 2023-09-06 21:06:08 | aromatase | 4 | 165329 | 197 | 10.706 | 15442.6 |
264 | 2023-08-19 21:31:44 | aromatase | 2 | 121436 | 3 | 3.466 | 35036.4 |
263 | 2023-08-12 15:17:11 | aromatase | 1 | 81242 | 2 | 1.250 | 64993.6 |
262 | 2023-06-13 04:37:02 | aromatase | 1 | 81242 | 2 | 1.376 | 59042.2 |
261 | 2023-05-25 08:47:14 | aromatase | 4 | 165329 | 197 | 11.970 | 13811.9 |
260 | 2023-05-06 01:29:12 | aromatase | 4 | 165329 | 197 | 10.766 | 15356.6 |
259 | 2023-05-05 06:15:16 | aromatase | 2 | 121436 | 3 | 3.500 | 34696.0 |
258 | 2023-04-05 18:13:43 | aromatase | 1 | 81242 | 2 | 1.330 | 61084.2 |
257 | 2023-03-31 06:56:45 | aromatase | 4 | 165329 | 197 | 16.016 | 10322.7 |
256 | 2023-03-30 02:19:11 | aromatase | 1 | 81242 | 2 | 1.216 | 66810.9 |
255 | 2023-03-04 17:02:05 | aromatase | 4 | 165329 | 197 | 10.753 | 15375.2 |
254 | 2023-02-17 13:56:35 | aromatase | 4 | 165329 | 197 | 16.936 | 9762.0 |
253 | 2023-02-11 19:28:27 | aromatase | 2 | 121436 | 3 | 3.500 | 34696.0 |
252 | 2023-01-14 09:00:40 | aromatase | 1 | 81242 | 2 | 1.296 | 62686.7 |
251 | 2023-01-03 15:45:26 | aromatase | 4 | 165329 | 197 | 11.800 | 14010.9 |
250 | 2022-12-11 20:55:07 | aromatase | 4 | 165329 | 197 | 10.656 | 15515.1 |
249 | 2022-12-07 09:33:38 | aromatase | 1 | 81242 | 2 | 2.453 | 33119.4 |
248 | 2022-11-23 19:00:21 | aromatase | 2 | 121436 | 3 | 3.533 | 34371.9 |
247 | 2022-11-03 23:23:32 | aromatase | 1 | 81242 | 2 | 1.250 | 64993.6 |
246 | 2022-09-07 07:06:38 | aromatase | 4 | 165329 | 197 | 10.923 | 15135.9 |
245 | 2022-07-27 14:13:48 | aromatase | 4 | 165329 | 197 | 10.893 | 15177.5 |
244 | 2022-07-24 09:58:45 | aromatase | 1 | 81242 | 2 | 1.326 | 61268.5 |
243 | 2022-07-19 10:09:40 | aromatase | 3 | 148641 | 16 | 6.470 | 22973.9 |
242 | 2022-06-23 21:32:56 | aromatase | 1 | 81242 | 2 | 1.373 | 59171.2 |
241 | 2022-06-21 16:38:53 | aromatase | 1 | 81242 | 2 | 1.266 | 64172.2 |
240 | 2022-04-29 18:59:51 | aromatase | 2 | 121436 | 3 | 3.123 | 38884.4 |
239 | 2022-03-02 16:09:34 | aromatase | 1 | 81242 | 2 | 1.390 | 58447.5 |
238 | 2022-02-26 22:43:04 | aromatase | 1 | 81242 | 2 | 1.266 | 64172.2 |
237 | 2021-12-15 21:43:00 | aromatase | 1 | 81242 | 2 | 1.343 | 60492.9 |
236 | 2021-10-29 20:24:28 | aromatase | 1 | 81242 | 2 | 1.343 | 60492.9 |
235 | 2021-10-27 02:48:22 | aromatase | 1 | 81242 | 2 | 1.250 | 64993.6 |
234 | 2021-09-17 11:14:01 | aromatase | 1 | 81242 | 2 | 1.500 | 54161.3 |
233 | 2021-09-15 07:15:46 | aromatase | 1 | 81242 | 2 | 1.250 | 64993.6 |
232 | 2021-08-24 09:17:51 | aromatase | 1 | 81242 | 2 | 1.346 | 60358.1 |
231 | 2021-07-16 01:40:42 | aromatase | 1 | 81242 | 2 | 1.393 | 58321.6 |
230 | 2021-04-17 00:01:33 | aromatase | 1 | 81242 | 2 | 2.860 | 28406.3 |
229 | 2021-04-13 06:05:07 | aromatase | 1 | 81242 | 2 | 1.500 | 54161.3 |
228 | 2021-01-27 22:19:21 | aromatase | 3 | 148641 | 16 | 6.310 | 23556.4 |
227 | 2021-01-03 11:54:46 | aromatase | 1 | 81242 | 2 | 1.360 | 59736.8 |
226 | 2021-01-01 06:08:27 | aromatase | 1 | 81242 | 2 | 1.236 | 65729.8 |
225 | 2020-10-14 16:06:16 | aromatase | 1 | 81242 | 2 | 1.250 | 64993.6 |
224 | 2020-10-01 16:27:58 | aromatase | 1 | 81242 | 2 | 1.233 | 65889.7 |
223 | 2020-09-09 14:56:43 | aromatase | 1 | 81242 | 2 | 1.440 | 56418.1 |
222 | 2020-08-28 08:29:39 | aromatase | 1 | 81242 | 2 | 1.373 | 59171.2 |
221 | 2020-06-21 14:30:16 | aromatase | 1 | 81242 | 2 | 2.220 | 36595.5 |