History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lipases"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
598 | 2024-06-05 13:43:59 | lipases | 1 | 69583 | 3 | 2.046 | 34009.3 |
597 | 2024-06-04 10:46:54 | lipases | 2 | 107671 | 24 | 13.846 | 7776.3 |
596 | 2024-06-04 10:46:58 | lipases | 1 | 69583 | 3 | 2.203 | 31585.6 |
595 | 2024-06-02 15:16:34 | lipases | 3 | 134027 | 400 | 22.376 | 5989.8 |
594 | 2024-06-01 18:21:46 | lipases | 2 | 107671 | 24 | 5.703 | 18879.7 |
593 | 2024-06-01 17:32:27 | lipases | 3 | 134027 | 400 | 6.846 | 19577.4 |
592 | 2024-06-01 14:14:01 | lipases | 3 | 134027 | 400 | 15.643 | 8567.9 |
591 | 2024-05-30 03:13:20 | lipases | 1 | 69583 | 3 | 5.280 | 13178.6 |
590 | 2024-05-27 11:42:32 | lipases | 2 | 107671 | 24 | 11.513 | 9352.1 |
589 | 2024-05-27 11:42:26 | lipases | 3 | 134027 | 400 | 16.170 | 8288.6 |
588 | 2024-05-27 11:41:47 | lipases | 1 | 69583 | 3 | 4.093 | 17000.5 |
587 | 2024-05-09 07:31:45 | lipases | 2 | 107671 | 24 | 9.406 | 11447.1 |
586 | 2024-05-08 00:27:10 | lipases | 3 | 134027 | 400 | 14.863 | 9017.5 |
585 | 2024-05-06 12:48:52 | lipases | 3 | 134027 | 400 | 7.403 | 18104.4 |
584 | 2024-05-02 06:53:50 | lipases | 1 | 69583 | 3 | 4.046 | 17198.0 |
583 | 2024-04-30 02:30:04 | lipases | 3 | 134027 | 400 | 20.970 | 6391.4 |
582 | 2024-04-29 06:51:12 | lipases | 1 | 69583 | 3 | 1.250 | 55666.4 |
581 | 2024-04-28 19:06:13 | lipases | 2 | 107671 | 24 | 3.140 | 34290.1 |
580 | 2024-04-28 18:26:33 | lipases | 3 | 134027 | 400 | 8.706 | 15394.8 |
579 | 2024-04-28 04:39:18 | lipases | 1 | 69583 | 3 | 2.406 | 28920.6 |
578 | 2024-04-27 10:59:41 | lipases | 2 | 107671 | 24 | 4.080 | 26390.0 |
577 | 2024-04-25 22:58:18 | lipases | 3 | 134027 | 400 | 9.453 | 14178.3 |
576 | 2024-04-25 09:07:32 | lipases | 3 | 134027 | 400 | 16.923 | 7919.8 |
575 | 2024-04-24 22:35:16 | lipases | 2 | 107671 | 24 | 3.830 | 28112.5 |
574 | 2024-04-21 12:23:54 | lipases | 3 | 134027 | 400 | 16.080 | 8335.0 |
573 | 2024-04-21 12:23:56 | lipases | 2 | 107671 | 24 | 11.233 | 9585.2 |
572 | 2024-04-21 12:23:41 | lipases | 1 | 69583 | 3 | 1.593 | 43680.5 |
571 | 2024-04-18 09:05:39 | lipases | 1 | 69583 | 3 | 2.403 | 28956.7 |
570 | 2024-03-30 13:47:29 | lipases | 3 | 134027 | 400 | 7.610 | 17612.0 |
569 | 2024-03-29 19:05:51 | lipases | 2 | 107671 | 24 | 3.326 | 32372.5 |
568 | 2024-03-28 21:46:43 | lipases | 3 | 134027 | 400 | 13.060 | 10262.4 |
567 | 2024-03-26 20:41:17 | lipases | 2 | 107671 | 24 | 7.156 | 15046.3 |
566 | 2024-03-26 20:39:46 | lipases | 3 | 134027 | 400 | 8.110 | 16526.1 |
565 | 2024-03-26 08:54:34 | lipases | 2 | 107671 | 24 | 11.313 | 9517.5 |
564 | 2024-03-23 03:46:46 | lipases | 2 | 107671 | 24 | 3.580 | 30075.7 |
563 | 2024-03-22 04:25:59 | lipases | 2 | 107671 | 24 | 7.563 | 14236.5 |
562 | 2024-03-22 04:25:57 | lipases | 3 | 134027 | 400 | 8.140 | 16465.2 |
561 | 2024-03-22 04:25:52 | lipases | 1 | 69583 | 3 | 3.140 | 22160.2 |
560 | 2024-03-07 13:45:50 | lipases | 1 | 69583 | 3 | 1.186 | 58670.3 |
559 | 2024-02-29 06:28:12 | lipases | 2 | 107671 | 24 | 3.250 | 33129.5 |
558 | 2024-02-29 06:27:20 | lipases | 3 | 134027 | 400 | 6.780 | 19768.0 |
557 | 2024-02-27 22:55:59 | lipases | 1 | 69583 | 3 | 3.716 | 18725.2 |
556 | 2024-02-26 23:56:00 | lipases | 1 | 69583 | 3 | 2.643 | 26327.3 |
555 | 2024-02-26 10:27:09 | lipases | 3 | 134027 | 400 | 8.703 | 15400.1 |
554 | 2024-02-26 10:27:00 | lipases | 2 | 107671 | 24 | 3.250 | 33129.5 |
553 | 2024-02-23 18:56:39 | lipases | 2 | 107671 | 24 | 3.236 | 33272.9 |
552 | 2024-02-21 16:25:26 | lipases | 3 | 134027 | 400 | 23.706 | 5653.7 |
551 | 2024-02-20 16:00:04 | lipases | 3 | 134027 | 400 | 27.140 | 4938.4 |
550 | 2024-02-20 16:00:03 | lipases | 2 | 107671 | 24 | 11.516 | 9349.7 |
549 | 2024-02-20 07:00:28 | lipases | 1 | 69583 | 3 | 3.283 | 21194.9 |
548 | 2024-01-20 18:20:13 | lipases | 1 | 69583 | 3 | 1.203 | 57841.2 |
547 | 2024-01-15 09:19:14 | lipases | 3 | 134027 | 400 | 6.686 | 20045.9 |
546 | 2024-01-12 04:19:54 | lipases | 3 | 134027 | 400 | 6.313 | 21230.3 |
545 | 2024-01-09 05:10:24 | lipases | 1 | 69583 | 3 | 1.076 | 64668.2 |
544 | 2024-01-06 20:15:07 | lipases | 2 | 107671 | 24 | 2.890 | 37256.4 |
543 | 2024-01-06 20:14:59 | lipases | 3 | 134027 | 400 | 6.593 | 20328.7 |
542 | 2023-12-04 20:33:04 | lipases | 1 | 69583 | 3 | 1.046 | 66522.9 |
541 | 2023-11-28 15:14:43 | lipases | 3 | 134027 | 400 | 6.813 | 19672.2 |
540 | 2023-11-28 02:52:31 | lipases | 1 | 69583 | 3 | 1.046 | 66522.9 |
539 | 2023-11-20 16:36:55 | lipases | 1 | 69583 | 3 | 1.080 | 64428.7 |
538 | 2023-11-17 13:36:21 | lipases | 1 | 69583 | 3 | 1.190 | 58473.1 |
537 | 2023-11-02 22:23:27 | lipases | 1 | 69583 | 3 | 1.063 | 65459.1 |
536 | 2023-10-31 14:45:09 | lipases | 1 | 69583 | 3 | 1.203 | 57841.2 |
535 | 2023-10-25 06:48:22 | lipases | 1 | 69583 | 3 | 1.216 | 57222.9 |
534 | 2023-10-15 19:45:21 | lipases | 1 | 69583 | 3 | 1.110 | 62687.4 |
533 | 2023-09-11 03:13:35 | lipases | 1 | 69583 | 3 | 1.123 | 61961.7 |
532 | 2023-08-27 15:34:04 | lipases | 1 | 69583 | 3 | 1.170 | 59472.6 |
531 | 2023-08-15 18:09:30 | lipases | 1 | 69583 | 3 | 1.203 | 57841.2 |
530 | 2023-06-02 01:28:51 | lipases | 1 | 69583 | 3 | 1.140 | 61037.7 |
529 | 2023-05-05 00:13:35 | lipases | 1 | 69583 | 3 | 1.043 | 66714.3 |
528 | 2023-03-26 13:09:26 | lipases | 1 | 69583 | 3 | 1.140 | 61037.7 |
527 | 2023-03-03 02:19:39 | lipases | 3 | 134027 | 400 | 6.563 | 20421.6 |
526 | 2023-02-28 23:20:54 | lipases | 1 | 69583 | 3 | 1.093 | 63662.4 |
525 | 2023-01-29 22:50:59 | lipases | 1 | 69583 | 3 | 1.033 | 67360.1 |
524 | 2023-01-10 01:30:20 | lipases | 1 | 69583 | 3 | 1.173 | 59320.5 |
523 | 2022-12-27 19:06:45 | lipases | 3 | 134027 | 400 | 5.686 | 23571.4 |
522 | 2022-12-21 06:13:45 | lipases | 3 | 134027 | 400 | 6.500 | 20619.5 |
521 | 2022-11-08 03:31:04 | lipases | 3 | 134027 | 400 | 6.173 | 21711.8 |
520 | 2022-10-19 11:34:13 | lipases | 1 | 69583 | 3 | 1.190 | 58473.1 |
519 | 2022-10-19 00:41:57 | lipases | 1 | 69583 | 3 | 1.046 | 66522.9 |
518 | 2022-07-03 04:43:57 | lipases | 1 | 69583 | 3 | 1.076 | 64668.2 |
517 | 2022-06-26 00:18:07 | lipases | 1 | 69583 | 3 | 1.156 | 60192.9 |
516 | 2022-06-08 17:12:20 | lipases | 1 | 69583 | 3 | 1.063 | 65459.1 |
515 | 2022-05-16 02:23:07 | lipases | 1 | 69583 | 3 | 1.046 | 66522.9 |
514 | 2022-03-19 11:57:22 | lipases | 1 | 69583 | 3 | 1.060 | 65644.3 |
513 | 2022-03-16 01:09:34 | lipases | 1 | 69583 | 3 | 1.220 | 57035.2 |
512 | 2022-02-20 16:23:36 | lipases | 1 | 69583 | 3 | 1.063 | 65459.1 |
511 | 2022-02-18 12:19:12 | lipases | 1 | 69583 | 3 | 1.046 | 66522.9 |
510 | 2022-01-23 04:56:58 | lipases | 3 | 134027 | 400 | 6.283 | 21331.7 |
509 | 2022-01-22 13:38:49 | lipases | 3 | 134027 | 400 | 5.656 | 23696.4 |
508 | 2022-01-21 19:28:45 | lipases | 3 | 134027 | 400 | 6.186 | 21666.2 |
507 | 2022-01-17 19:32:16 | lipases | 3 | 134027 | 400 | 6.280 | 21341.9 |
506 | 2022-01-17 03:50:56 | lipases | 3 | 134027 | 400 | 7.406 | 18097.1 |
505 | 2022-01-16 10:32:55 | lipases | 3 | 134027 | 400 | 6.936 | 19323.4 |
504 | 2022-01-15 23:31:18 | lipases | 3 | 134027 | 400 | 5.796 | 23124.1 |
503 | 2022-01-15 12:11:03 | lipases | 3 | 134027 | 400 | 7.796 | 17191.8 |
502 | 2022-01-14 19:27:48 | lipases | 3 | 134027 | 400 | 6.876 | 19492.0 |
501 | 2022-01-13 23:57:45 | lipases | 3 | 134027 | 400 | 6.720 | 19944.5 |
500 | 2022-01-08 02:48:31 | lipases | 3 | 134027 | 400 | 5.876 | 22809.2 |
499 | 2022-01-01 02:00:53 | lipases | 3 | 134027 | 400 | 5.953 | 22514.2 |