History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lysine"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
424 | 2024-04-27 10:44:56 | lysine | 1 | 48755 | 5 | 1.720 | 28345.9 |
423 | 2024-04-13 15:56:20 | lysine | 1 | 48755 | 5 | 0.920 | 52994.6 |
422 | 2024-04-03 11:15:36 | lysine | 1 | 48755 | 5 | 1.533 | 31803.7 |
421 | 2024-03-31 02:11:53 | lysine | 3 | 112716 | 440 | 12.453 | 9051.3 |
420 | 2024-03-31 00:46:03 | lysine | 3 | 112716 | 440 | 8.923 | 12632.1 |
419 | 2024-03-30 15:43:29 | lysine | 1 | 48755 | 5 | 0.826 | 59025.4 |
418 | 2024-03-30 13:29:09 | lysine | 2 | 82551 | 24 | 4.656 | 17730.0 |
417 | 2024-03-30 13:28:49 | lysine | 3 | 112716 | 440 | 5.796 | 19447.2 |
416 | 2024-03-29 23:50:19 | lysine | 3 | 112716 | 440 | 6.000 | 18786.0 |
415 | 2024-03-29 23:50:21 | lysine | 2 | 82551 | 24 | 2.923 | 28241.9 |
414 | 2024-03-28 19:41:58 | lysine | 1 | 48755 | 5 | 2.140 | 22782.7 |
413 | 2024-03-04 09:09:30 | lysine | 1 | 48755 | 5 | 1.593 | 30605.8 |
412 | 2024-02-28 19:02:15 | lysine | 2 | 82551 | 24 | 2.140 | 38575.2 |
411 | 2024-02-28 18:45:43 | lysine | 3 | 112716 | 440 | 5.000 | 22543.2 |
410 | 2024-02-27 04:35:02 | lysine | 3 | 112716 | 440 | 11.423 | 9867.5 |
409 | 2024-02-26 13:20:00 | lysine | 3 | 112716 | 440 | 5.376 | 20966.5 |
408 | 2024-02-26 13:20:00 | lysine | 2 | 82551 | 24 | 2.420 | 34112.0 |
407 | 2024-02-26 13:19:57 | lysine | 1 | 48755 | 5 | 0.923 | 52822.3 |
406 | 2024-01-15 20:25:25 | lysine | 3 | 112716 | 440 | 4.783 | 23566.0 |
405 | 2024-01-15 20:25:21 | lysine | 2 | 82551 | 24 | 2.373 | 34787.6 |
404 | 2024-01-03 20:32:48 | lysine | 3 | 112716 | 440 | 5.266 | 21404.5 |
403 | 2024-01-03 20:32:49 | lysine | 2 | 82551 | 24 | 2.576 | 32046.2 |
402 | 2023-12-30 22:46:09 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
401 | 2023-12-28 12:40:14 | lysine | 1 | 48755 | 5 | 0.780 | 62506.4 |
400 | 2023-12-07 14:41:26 | lysine | 1 | 48755 | 5 | 0.860 | 56691.9 |
399 | 2023-12-07 14:41:25 | lysine | 1 | 48755 | 5 | 0.813 | 59969.2 |
398 | 2023-11-23 12:50:04 | lysine | 3 | 112716 | 440 | 4.466 | 25238.7 |
397 | 2023-11-23 12:50:02 | lysine | 2 | 82551 | 24 | 2.063 | 40015.0 |
396 | 2023-11-17 01:45:51 | lysine | 1 | 48755 | 5 | 1.576 | 30935.9 |
395 | 2023-11-14 01:27:08 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
394 | 2023-10-27 07:20:38 | lysine | 1 | 48755 | 5 | 0.830 | 58741.0 |
393 | 2023-10-24 00:23:02 | lysine | 1 | 48755 | 5 | 0.763 | 63899.1 |
392 | 2023-10-20 15:05:10 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
391 | 2023-10-18 16:24:11 | lysine | 1 | 48755 | 5 | 0.736 | 66243.2 |
390 | 2023-10-17 04:54:50 | lysine | 2 | 82551 | 24 | 2.593 | 31836.1 |
389 | 2023-10-16 11:03:03 | lysine | 2 | 82551 | 24 | 2.250 | 36689.3 |
388 | 2023-10-14 15:23:50 | lysine | 1 | 48755 | 5 | 0.800 | 60943.8 |
387 | 2023-10-10 20:39:51 | lysine | 3 | 112716 | 440 | 9.110 | 12372.8 |
386 | 2023-10-09 00:55:51 | lysine | 3 | 112716 | 440 | 12.266 | 9189.3 |
385 | 2023-10-08 10:24:48 | lysine | 1 | 48755 | 5 | 0.780 | 62506.4 |
384 | 2023-10-01 09:40:02 | lysine | 3 | 112716 | 440 | 5.516 | 20434.4 |
383 | 2023-09-28 00:57:24 | lysine | 1 | 48755 | 5 | 0.783 | 62266.9 |
382 | 2023-09-27 04:50:08 | lysine | 2 | 82551 | 24 | 2.390 | 34540.2 |
381 | 2023-09-27 04:50:01 | lysine | 3 | 112716 | 440 | 5.470 | 20606.2 |
380 | 2023-09-12 19:00:02 | lysine | 1 | 48755 | 5 | 0.796 | 61250.0 |
379 | 2023-08-26 06:38:45 | lysine | 1 | 48755 | 5 | 0.813 | 59969.2 |
378 | 2023-08-22 18:41:07 | lysine | 1 | 48755 | 5 | 0.796 | 61250.0 |
377 | 2023-08-16 11:56:38 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
376 | 2023-05-16 01:23:55 | lysine | 1 | 48755 | 5 | 0.716 | 68093.6 |
375 | 2023-05-01 16:04:21 | lysine | 1 | 48755 | 5 | 0.736 | 66243.2 |
374 | 2023-03-11 15:31:16 | lysine | 1 | 48755 | 5 | 0.703 | 69352.8 |
373 | 2023-01-08 05:10:53 | lysine | 1 | 48755 | 5 | 0.716 | 68093.6 |
372 | 2023-01-01 08:04:12 | lysine | 1 | 48755 | 5 | 0.720 | 67715.3 |
371 | 2022-09-18 08:53:44 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
370 | 2022-09-06 12:14:46 | lysine | 1 | 48755 | 5 | 0.736 | 66243.2 |
369 | 2022-09-04 04:44:30 | lysine | 1 | 48755 | 5 | 0.813 | 59969.2 |
368 | 2022-08-15 05:36:30 | lysine | 1 | 48755 | 5 | 0.716 | 68093.6 |
367 | 2022-08-06 21:09:00 | lysine | 1 | 48755 | 5 | 0.873 | 55847.7 |
366 | 2022-07-29 13:27:40 | lysine | 1 | 48755 | 5 | 0.720 | 67715.3 |
365 | 2022-04-27 13:37:22 | lysine | 1 | 48755 | 5 | 0.936 | 52088.7 |
364 | 2022-04-23 10:09:10 | lysine | 1 | 48755 | 5 | 0.796 | 61250.0 |
363 | 2022-01-20 23:48:28 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
362 | 2021-12-31 17:53:09 | lysine | 1 | 48755 | 5 | 0.750 | 65006.7 |
361 | 2021-11-16 14:44:25 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
360 | 2021-11-14 13:45:22 | lysine | 1 | 48755 | 5 | 0.843 | 57835.1 |
359 | 2021-09-18 05:37:38 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
358 | 2021-07-12 18:05:10 | lysine | 1 | 48755 | 5 | 0.876 | 55656.4 |
357 | 2021-06-15 00:15:20 | lysine | 1 | 48755 | 5 | 0.736 | 66243.2 |
356 | 2021-05-01 08:41:37 | lysine | 1 | 48755 | 5 | 0.783 | 62266.9 |
355 | 2021-04-12 05:58:55 | lysine | 1 | 48755 | 5 | 0.766 | 63648.8 |
354 | 2021-03-12 01:50:06 | lysine | 1 | 48755 | 5 | 0.813 | 59969.2 |
353 | 2021-02-19 04:20:03 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
352 | 2021-01-14 05:17:56 | lysine | 1 | 48755 | 5 | 0.720 | 67715.3 |
351 | 2020-12-08 22:26:10 | lysine | 1 | 48755 | 5 | 0.796 | 61250.0 |
350 | 2020-10-29 01:20:57 | lysine | 1 | 48755 | 5 | 0.846 | 57630.0 |
349 | 2020-10-26 15:07:56 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
348 | 2020-10-20 04:01:16 | lysine | 1 | 48755 | 5 | 0.796 | 61250.0 |
347 | 2020-10-12 16:48:41 | lysine | 1 | 48755 | 5 | 0.720 | 67715.3 |
346 | 2020-09-05 20:34:08 | lysine | 1 | 48755 | 5 | 0.720 | 67715.3 |
345 | 2020-08-13 10:56:16 | lysine | 1 | 48755 | 5 | 0.766 | 63648.8 |
344 | 2020-08-10 10:43:17 | lysine | 1 | 48755 | 5 | 0.720 | 67715.3 |
343 | 2020-08-07 05:47:11 | lysine | 1 | 48755 | 5 | 0.733 | 66514.3 |
342 | 2020-05-25 10:49:37 | lysine | 1 | 48755 | 5 | 0.716 | 68093.6 |
341 | 2020-04-30 11:40:24 | lysine | 1 | 48755 | 5 | 0.830 | 58741.0 |
340 | 2020-03-27 19:52:58 | lysine | 1 | 48755 | 5 | 0.860 | 56691.9 |
339 | 2020-03-25 16:31:59 | lysine | 1 | 48755 | 5 | 0.843 | 57835.1 |
338 | 2020-03-25 01:04:24 | lysine | 1 | 48755 | 5 | 0.736 | 66243.2 |
337 | 2020-03-23 23:19:58 | lysine | 1 | 48755 | 5 | 0.766 | 63648.8 |
336 | 2020-03-23 04:16:30 | lysine | 1 | 48755 | 5 | 0.813 | 59969.2 |
335 | 2020-03-19 20:54:34 | lysine | 1 | 48755 | 5 | 0.763 | 63899.1 |
334 | 2020-03-18 21:25:16 | lysine | 1 | 48755 | 5 | 0.813 | 59969.2 |
333 | 2020-03-04 00:34:16 | lysine | 1 | 48755 | 5 | 0.716 | 68093.6 |
332 | 2020-02-27 06:49:11 | lysine | 3 | 112716 | 440 | 8.250 | 13662.5 |
331 | 2020-02-23 20:45:52 | lysine | 1 | 48755 | 5 | 0.876 | 55656.4 |
330 | 2020-02-21 15:08:02 | lysine | 1 | 48755 | 5 | 0.873 | 55847.7 |
329 | 2020-02-19 06:08:43 | lysine | 1 | 48755 | 5 | 0.876 | 55656.4 |
328 | 2020-02-15 11:34:26 | lysine | 1 | 48755 | 5 | 1.876 | 25988.8 |
327 | 2020-02-13 08:02:29 | lysine | 3 | 112716 | 440 | 8.703 | 12951.4 |
326 | 2020-02-13 05:29:15 | lysine | 3 | 112716 | 440 | 9.733 | 11580.8 |
325 | 2020-02-13 01:45:13 | lysine | 3 | 112716 | 440 | 8.860 | 12721.9 |