History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"valine"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
631 | 2024-04-23 17:59:11 | valine | 1 | 48755 | 7 | 0.813 | 59969.2 |
630 | 2024-04-13 18:20:24 | valine | 2 | 82551 | 93 | 3.030 | 27244.6 |
629 | 2024-04-13 18:11:27 | valine | 3 | 112716 | 1155 | 7.016 | 16065.6 |
628 | 2024-04-13 10:08:23 | valine | 3 | 112716 | 1155 | 5.486 | 20546.1 |
627 | 2024-04-06 09:40:18 | valine | 1 | 48755 | 7 | 2.220 | 21961.7 |
626 | 2024-03-31 22:17:13 | valine | 3 | 112716 | 1155 | 8.173 | 13791.3 |
625 | 2024-03-29 23:39:01 | valine | 2 | 82551 | 93 | 2.690 | 30688.1 |
624 | 2024-03-29 23:38:37 | valine | 3 | 112716 | 1155 | 5.843 | 19290.8 |
623 | 2024-03-28 21:36:01 | valine | 3 | 112716 | 1155 | 12.733 | 8852.3 |
622 | 2024-03-28 21:35:55 | valine | 2 | 82551 | 93 | 2.906 | 28407.1 |
621 | 2024-03-28 21:35:40 | valine | 3 | 112716 | 1155 | 13.533 | 8329.0 |
620 | 2024-03-28 21:35:51 | valine | 1 | 48755 | 7 | 2.766 | 17626.5 |
619 | 2024-03-28 21:35:42 | valine | 2 | 82551 | 93 | 4.140 | 19939.9 |
618 | 2024-03-28 21:35:39 | valine | 1 | 48755 | 7 | 1.890 | 25796.3 |
617 | 2024-03-24 04:31:46 | valine | 1 | 48755 | 7 | 1.920 | 25393.2 |
616 | 2024-03-05 15:30:57 | valine | 1 | 48755 | 7 | 1.843 | 26454.2 |
615 | 2024-02-28 06:21:22 | valine | 2 | 82551 | 93 | 3.376 | 24452.3 |
614 | 2024-02-28 06:20:45 | valine | 3 | 112716 | 1155 | 7.233 | 15583.6 |
613 | 2024-02-27 04:35:15 | valine | 3 | 112716 | 1155 | 11.843 | 9517.5 |
612 | 2024-02-27 04:35:14 | valine | 2 | 82551 | 93 | 8.783 | 9399.0 |
611 | 2024-02-27 04:34:52 | valine | 1 | 48755 | 7 | 1.080 | 45143.5 |
610 | 2024-02-26 20:08:58 | valine | 3 | 112716 | 1155 | 9.563 | 11786.7 |
609 | 2024-02-26 20:08:58 | valine | 2 | 82551 | 93 | 2.796 | 29524.7 |
608 | 2024-02-26 20:08:56 | valine | 1 | 48755 | 7 | 0.890 | 54780.9 |
607 | 2024-01-27 11:42:17 | valine | 1 | 48755 | 7 | 0.856 | 56956.8 |
606 | 2024-01-05 09:32:29 | valine | 2 | 82551 | 93 | 2.156 | 38289.0 |
605 | 2024-01-04 00:09:51 | valine | 1 | 48755 | 7 | 0.890 | 54780.9 |
604 | 2024-01-02 08:35:58 | valine | 3 | 112716 | 1155 | 5.076 | 22205.7 |
603 | 2024-01-02 08:35:53 | valine | 2 | 82551 | 93 | 2.123 | 38884.1 |
602 | 2023-12-29 22:37:02 | valine | 3 | 112716 | 1155 | 5.300 | 21267.2 |
601 | 2023-12-29 22:37:04 | valine | 2 | 82551 | 93 | 2.483 | 33246.5 |
600 | 2023-12-25 14:57:10 | valine | 1 | 48755 | 7 | 0.750 | 65006.7 |
599 | 2023-12-19 19:09:54 | valine | 3 | 112716 | 1155 | 5.783 | 19490.9 |
598 | 2023-12-19 19:09:57 | valine | 2 | 82551 | 93 | 2.656 | 31080.9 |
597 | 2023-12-12 21:38:46 | valine | 3 | 112716 | 1155 | 5.610 | 20092.0 |
596 | 2023-12-07 00:29:23 | valine | 1 | 48755 | 7 | 0.736 | 66243.2 |
595 | 2023-12-07 00:29:22 | valine | 1 | 48755 | 7 | 0.780 | 62506.4 |
594 | 2023-11-22 12:10:26 | valine | 2 | 82551 | 93 | 2.373 | 34787.6 |
593 | 2023-11-22 12:10:21 | valine | 3 | 112716 | 1155 | 5.326 | 21163.3 |
592 | 2023-11-16 23:31:21 | valine | 1 | 48755 | 7 | 0.813 | 59969.2 |
591 | 2023-11-14 13:58:46 | valine | 1 | 48755 | 7 | 0.813 | 59969.2 |
590 | 2023-11-13 16:40:40 | valine | 1 | 48755 | 7 | 0.733 | 66514.3 |
589 | 2023-10-29 12:26:02 | valine | 1 | 48755 | 7 | 0.813 | 59969.2 |
588 | 2023-10-26 04:55:33 | valine | 1 | 48755 | 7 | 0.826 | 59025.4 |
587 | 2023-10-21 18:11:31 | valine | 1 | 48755 | 7 | 0.826 | 59025.4 |
586 | 2023-10-20 05:12:54 | valine | 1 | 48755 | 7 | 0.733 | 66514.3 |
585 | 2023-10-18 15:43:57 | valine | 1 | 48755 | 7 | 0.736 | 66243.2 |
584 | 2023-10-18 07:14:40 | valine | 2 | 82551 | 93 | 2.623 | 31472.0 |
583 | 2023-10-16 19:00:14 | valine | 2 | 82551 | 93 | 2.266 | 36430.3 |
582 | 2023-10-12 23:55:01 | valine | 1 | 48755 | 7 | 0.843 | 57835.1 |
581 | 2023-10-11 17:37:45 | valine | 2 | 82551 | 93 | 2.233 | 36968.7 |
580 | 2023-10-11 00:41:08 | valine | 3 | 112716 | 1155 | 6.970 | 16171.6 |
579 | 2023-10-09 00:38:10 | valine | 3 | 112716 | 1155 | 6.410 | 17584.4 |
578 | 2023-10-08 01:36:31 | valine | 3 | 112716 | 1155 | 5.703 | 19764.3 |
577 | 2023-10-01 08:09:16 | valine | 3 | 112716 | 1155 | 10.343 | 10897.8 |
576 | 2023-09-27 17:05:58 | valine | 3 | 112716 | 1155 | 5.140 | 21929.2 |
575 | 2023-09-26 12:28:11 | valine | 1 | 48755 | 7 | 0.736 | 66243.2 |
574 | 2023-09-13 18:22:33 | valine | 3 | 112716 | 1155 | 5.750 | 19602.8 |
573 | 2023-08-20 15:50:31 | valine | 1 | 48755 | 7 | 0.826 | 59025.4 |
572 | 2023-07-23 08:22:41 | valine | 2 | 82551 | 93 | 2.250 | 36689.3 |
571 | 2023-06-25 19:09:02 | valine | 1 | 48755 | 7 | 0.856 | 56956.8 |
570 | 2023-06-18 14:17:24 | valine | 3 | 112716 | 1155 | 5.110 | 22057.9 |
569 | 2023-05-20 06:18:18 | valine | 1 | 48755 | 7 | 0.796 | 61250.0 |
568 | 2023-04-04 16:00:04 | valine | 2 | 82551 | 93 | 2.123 | 38884.1 |
567 | 2023-03-18 17:58:44 | valine | 3 | 112716 | 1155 | 5.300 | 21267.2 |
566 | 2023-03-16 03:26:08 | valine | 1 | 48755 | 7 | 0.826 | 59025.4 |
565 | 2023-03-14 13:35:44 | valine | 3 | 112716 | 1155 | 5.283 | 21335.6 |
564 | 2023-03-13 11:40:08 | valine | 1 | 48755 | 7 | 0.843 | 57835.1 |
563 | 2023-01-06 06:49:03 | valine | 1 | 48755 | 7 | 0.716 | 68093.6 |
562 | 2023-01-03 07:21:20 | valine | 2 | 82551 | 93 | 2.080 | 39688.0 |
561 | 2022-12-17 07:21:26 | valine | 3 | 112716 | 1155 | 4.700 | 23982.1 |
560 | 2022-11-14 20:43:43 | valine | 1 | 48755 | 7 | 0.733 | 66514.3 |
559 | 2022-09-27 02:08:30 | valine | 1 | 48755 | 7 | 0.733 | 66514.3 |
558 | 2022-09-12 20:56:29 | valine | 1 | 48755 | 7 | 0.750 | 65006.7 |
557 | 2022-09-05 15:32:34 | valine | 1 | 48755 | 7 | 0.733 | 66514.3 |
556 | 2022-09-05 14:19:34 | valine | 2 | 82551 | 93 | 2.110 | 39123.7 |
555 | 2022-09-04 18:33:19 | valine | 1 | 48755 | 7 | 0.750 | 65006.7 |
554 | 2022-09-01 19:57:14 | valine | 1 | 48755 | 7 | 0.750 | 65006.7 |
553 | 2022-08-20 02:14:12 | valine | 3 | 112716 | 1155 | 4.906 | 22975.1 |
552 | 2022-08-14 04:31:07 | valine | 3 | 112716 | 1155 | 11.486 | 9813.3 |
551 | 2022-07-21 23:50:02 | valine | 1 | 48755 | 7 | 0.733 | 66514.3 |
550 | 2022-05-13 19:38:43 | valine | 1 | 48755 | 7 | 1.046 | 46610.9 |
549 | 2022-05-11 14:35:49 | valine | 1 | 48755 | 7 | 0.983 | 49598.2 |
548 | 2022-03-27 17:03:07 | valine | 1 | 48755 | 7 | 0.766 | 63648.8 |
547 | 2022-03-24 17:28:48 | valine | 2 | 82551 | 93 | 2.310 | 35736.4 |
546 | 2022-02-03 22:52:56 | valine | 1 | 48755 | 7 | 0.920 | 52994.6 |
545 | 2022-02-01 18:11:51 | valine | 1 | 48755 | 7 | 0.830 | 58741.0 |
544 | 2021-12-07 10:24:42 | valine | 2 | 82551 | 93 | 2.220 | 37185.1 |
543 | 2021-12-03 17:31:17 | valine | 1 | 48755 | 7 | 0.736 | 66243.2 |
542 | 2021-11-29 23:06:07 | valine | 1 | 48755 | 7 | 1.186 | 41108.8 |
541 | 2021-10-21 16:34:41 | valine | 3 | 112716 | 1155 | 4.766 | 23650.0 |
540 | 2021-10-07 09:08:05 | valine | 1 | 48755 | 7 | 0.826 | 59025.4 |
539 | 2021-10-05 05:48:22 | valine | 1 | 48755 | 7 | 0.796 | 61250.0 |
538 | 2021-09-30 15:09:34 | valine | 3 | 112716 | 1155 | 5.420 | 20796.3 |
537 | 2021-09-26 17:10:47 | valine | 3 | 112716 | 1155 | 5.656 | 19928.6 |
536 | 2021-09-24 18:01:51 | valine | 1 | 48755 | 7 | 0.876 | 55656.4 |
535 | 2021-09-24 02:41:33 | valine | 1 | 48755 | 7 | 0.843 | 57835.1 |
534 | 2021-09-18 07:53:45 | valine | 1 | 48755 | 7 | 0.750 | 65006.7 |
533 | 2021-08-31 18:58:50 | valine | 3 | 112716 | 1155 | 5.126 | 21989.1 |
532 | 2021-08-27 07:37:50 | valine | 1 | 48755 | 7 | 0.750 | 65006.7 |