History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"advect"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
649 | 2024-04-30 21:38:48 | advect | 2 | 82551 | 16 | 6.390 | 12918.8 |
648 | 2024-04-30 21:38:44 | advect | 3 | 112716 | 188 | 9.970 | 11305.5 |
647 | 2024-04-30 21:38:39 | advect | 1 | 48755 | 4 | 0.843 | 57835.1 |
646 | 2024-04-30 21:38:33 | advect | 2 | 82551 | 16 | 2.393 | 34496.9 |
645 | 2024-04-06 13:47:53 | advect | 3 | 112716 | 188 | 13.593 | 8292.2 |
644 | 2024-04-06 12:08:18 | advect | 3 | 112716 | 188 | 5.780 | 19501.0 |
643 | 2024-04-06 12:08:19 | advect | 2 | 82551 | 16 | 3.826 | 21576.3 |
642 | 2024-04-06 12:08:14 | advect | 1 | 48755 | 4 | 2.143 | 22750.8 |
641 | 2024-04-01 10:59:11 | advect | 1 | 48755 | 4 | 0.983 | 49598.2 |
640 | 2024-03-31 12:39:12 | advect | 2 | 82551 | 16 | 2.186 | 37763.5 |
639 | 2024-03-31 12:39:10 | advect | 1 | 48755 | 4 | 0.766 | 63648.8 |
638 | 2024-03-31 12:38:54 | advect | 3 | 112716 | 188 | 5.376 | 20966.5 |
637 | 2024-03-31 07:15:12 | advect | 2 | 82551 | 16 | 5.033 | 16401.9 |
636 | 2024-03-31 03:00:38 | advect | 2 | 82551 | 16 | 9.063 | 9108.6 |
635 | 2024-03-31 03:00:36 | advect | 3 | 112716 | 188 | 9.796 | 11506.3 |
634 | 2024-03-31 03:00:30 | advect | 1 | 48755 | 4 | 2.843 | 17149.1 |
633 | 2024-03-22 16:04:59 | advect | 1 | 48755 | 4 | 0.950 | 51321.1 |
632 | 2024-02-04 12:51:46 | advect | 2 | 82551 | 16 | 7.143 | 11556.9 |
631 | 2024-02-04 00:27:35 | advect | 1 | 48755 | 4 | 0.813 | 59969.2 |
630 | 2024-02-04 00:27:31 | advect | 2 | 82551 | 16 | 2.546 | 32423.8 |
629 | 2024-02-01 17:34:21 | advect | 1 | 48755 | 4 | 0.860 | 56691.9 |
628 | 2024-02-01 02:32:44 | advect | 2 | 82551 | 16 | 5.253 | 15715.0 |
627 | 2024-01-29 18:18:26 | advect | 2 | 82551 | 16 | 2.516 | 32810.4 |
626 | 2024-01-29 18:02:30 | advect | 3 | 112716 | 188 | 5.703 | 19764.3 |
625 | 2024-01-26 07:52:23 | advect | 2 | 82551 | 16 | 2.670 | 30918.0 |
624 | 2024-01-26 07:52:11 | advect | 3 | 112716 | 188 | 5.890 | 19136.8 |
623 | 2024-01-26 01:43:55 | advect | 3 | 112716 | 188 | 9.470 | 11902.4 |
622 | 2024-01-22 12:38:44 | advect | 3 | 112716 | 188 | 6.346 | 17761.7 |
621 | 2024-01-15 00:58:23 | advect | 3 | 112716 | 188 | 5.593 | 20153.0 |
620 | 2023-12-21 19:44:58 | advect | 1 | 48755 | 4 | 0.810 | 60191.4 |
619 | 2023-11-29 05:30:51 | advect | 1 | 48755 | 4 | 0.843 | 57835.1 |
618 | 2023-11-22 15:57:47 | advect | 1 | 48755 | 4 | 0.843 | 57835.1 |
617 | 2023-11-06 18:38:08 | advect | 1 | 48755 | 4 | 0.893 | 54596.9 |
616 | 2023-11-01 21:20:07 | advect | 3 | 112716 | 188 | 5.656 | 19928.6 |
615 | 2023-10-19 05:03:46 | advect | 1 | 48755 | 4 | 0.766 | 63648.8 |
614 | 2023-10-15 11:31:01 | advect | 1 | 48755 | 4 | 0.750 | 65006.7 |
613 | 2023-10-10 16:54:34 | advect | 1 | 48755 | 4 | 0.763 | 63899.1 |
612 | 2023-10-10 09:40:15 | advect | 1 | 48755 | 4 | 0.750 | 65006.7 |
611 | 2023-10-06 09:27:58 | advect | 1 | 48755 | 4 | 0.856 | 56956.8 |
610 | 2023-09-27 00:59:08 | advect | 1 | 48755 | 4 | 0.733 | 66514.3 |
609 | 2023-09-15 11:18:23 | advect | 1 | 48755 | 4 | 0.923 | 52822.3 |
608 | 2023-08-09 15:03:27 | advect | 3 | 112716 | 188 | 4.720 | 23880.5 |
607 | 2023-08-07 06:10:21 | advect | 1 | 48755 | 4 | 0.766 | 63648.8 |
606 | 2023-07-04 22:54:18 | advect | 1 | 48755 | 4 | 0.733 | 66514.3 |
605 | 2023-06-20 02:25:36 | advect | 1 | 48755 | 4 | 0.750 | 65006.7 |
604 | 2023-05-08 21:59:22 | advect | 1 | 48755 | 4 | 0.843 | 57835.1 |
603 | 2023-04-24 07:39:15 | advect | 3 | 112716 | 188 | 5.266 | 21404.5 |
602 | 2023-03-03 21:28:25 | advect | 1 | 48755 | 4 | 0.766 | 63648.8 |
601 | 2023-03-01 03:59:30 | advect | 1 | 48755 | 4 | 0.750 | 65006.7 |
600 | 2023-01-27 04:37:18 | advect | 3 | 112716 | 188 | 4.513 | 24975.8 |
599 | 2023-01-23 06:10:35 | advect | 3 | 112716 | 188 | 5.186 | 21734.7 |
598 | 2022-12-26 14:30:09 | advect | 1 | 48755 | 4 | 0.843 | 57835.1 |
597 | 2022-12-21 03:54:54 | advect | 3 | 112716 | 188 | 4.996 | 22561.2 |
596 | 2022-11-09 15:00:05 | advect | 3 | 112716 | 188 | 5.140 | 21929.2 |
595 | 2022-11-08 18:19:52 | advect | 1 | 48755 | 4 | 0.766 | 63648.8 |
594 | 2022-09-16 13:00:18 | advect | 1 | 48755 | 4 | 0.733 | 66514.3 |
593 | 2022-07-19 10:27:50 | advect | 1 | 48755 | 4 | 0.766 | 63648.8 |
592 | 2022-06-12 05:34:44 | advect | 3 | 112716 | 188 | 4.780 | 23580.8 |
591 | 2022-05-31 02:00:22 | advect | 1 | 48755 | 4 | 0.733 | 66514.3 |
590 | 2022-04-23 04:15:32 | advect | 1 | 48755 | 4 | 0.766 | 63648.8 |
589 | 2022-04-21 00:51:03 | advect | 1 | 48755 | 4 | 0.826 | 59025.4 |
588 | 2022-03-15 02:06:05 | advect | 1 | 48755 | 4 | 0.830 | 58741.0 |
587 | 2022-03-07 01:51:13 | advect | 1 | 48755 | 4 | 0.766 | 63648.8 |
586 | 2022-02-13 15:47:23 | advect | 1 | 48755 | 4 | 0.843 | 57835.1 |
585 | 2022-01-12 10:44:35 | advect | 1 | 48755 | 4 | 0.830 | 58741.0 |
584 | 2021-12-29 07:14:38 | advect | 1 | 48755 | 4 | 0.796 | 61250.0 |
583 | 2021-12-18 04:09:14 | advect | 1 | 48755 | 4 | 0.860 | 56691.9 |
582 | 2021-12-04 18:39:57 | advect | 1 | 48755 | 4 | 0.830 | 58741.0 |
581 | 2021-11-22 21:21:28 | advect | 1 | 48755 | 4 | 0.856 | 56956.8 |
580 | 2021-11-21 18:56:30 | advect | 1 | 48755 | 4 | 0.860 | 56691.9 |
579 | 2021-11-21 06:27:52 | advect | 1 | 48755 | 4 | 0.830 | 58741.0 |
578 | 2021-10-08 20:24:14 | advect | 3 | 112716 | 188 | 4.546 | 24794.5 |
577 | 2021-09-30 00:00:57 | advect | 3 | 112716 | 188 | 4.750 | 23729.7 |
576 | 2021-09-24 02:23:12 | advect | 3 | 112716 | 188 | 4.626 | 24365.8 |
575 | 2021-09-09 02:25:21 | advect | 3 | 112716 | 188 | 5.360 | 21029.1 |
574 | 2021-09-08 20:19:10 | advect | 3 | 112716 | 188 | 4.953 | 22757.1 |
573 | 2021-09-08 05:32:26 | advect | 3 | 112716 | 188 | 4.903 | 22989.2 |
572 | 2021-09-07 14:56:20 | advect | 3 | 112716 | 188 | 5.063 | 22262.7 |
571 | 2021-09-07 00:14:06 | advect | 3 | 112716 | 188 | 4.733 | 23814.9 |
570 | 2021-09-06 09:24:18 | advect | 3 | 112716 | 188 | 4.923 | 22895.8 |
569 | 2021-09-05 18:47:33 | advect | 3 | 112716 | 188 | 4.560 | 24718.4 |
568 | 2021-09-01 13:37:59 | advect | 3 | 112716 | 188 | 4.610 | 24450.3 |
567 | 2021-08-28 08:46:33 | advect | 1 | 48755 | 4 | 0.766 | 63648.8 |
566 | 2021-06-23 14:55:20 | advect | 1 | 48755 | 4 | 0.873 | 55847.7 |
565 | 2021-05-27 14:55:24 | advect | 1 | 48755 | 4 | 0.903 | 53992.2 |
564 | 2021-05-17 18:45:33 | advect | 1 | 48755 | 4 | 0.750 | 65006.7 |
563 | 2021-05-06 08:52:13 | advect | 1 | 48755 | 4 | 1.733 | 28133.3 |
562 | 2021-04-04 13:04:38 | advect | 1 | 48755 | 4 | 0.763 | 63899.1 |
561 | 2021-02-22 19:02:04 | advect | 1 | 48755 | 4 | 0.936 | 52088.7 |
560 | 2021-02-22 07:51:14 | advect | 1 | 48755 | 4 | 0.890 | 54780.9 |
559 | 2021-02-12 18:53:03 | advect | 1 | 48755 | 4 | 0.783 | 62266.9 |
558 | 2021-02-12 16:45:35 | advect | 3 | 112716 | 188 | 4.873 | 23130.7 |
557 | 2021-01-30 13:02:06 | advect | 3 | 112716 | 188 | 4.656 | 24208.8 |
556 | 2021-01-28 15:20:33 | advect | 3 | 112716 | 188 | 4.813 | 23419.1 |
555 | 2021-01-02 14:10:29 | advect | 3 | 112716 | 188 | 4.673 | 24120.7 |
554 | 2020-11-19 07:20:34 | advect | 1 | 48755 | 4 | 0.953 | 51159.5 |
553 | 2020-11-13 06:46:39 | advect | 3 | 112716 | 188 | 5.143 | 21916.4 |
552 | 2020-10-30 23:34:45 | advect | 1 | 48755 | 4 | 0.763 | 63899.1 |
551 | 2020-10-05 04:01:58 | advect | 3 | 112716 | 188 | 4.703 | 23966.8 |
550 | 2020-09-02 21:09:48 | advect | 1 | 48755 | 4 | 1.893 | 25755.4 |