History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loreal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
653 | 2024-04-22 03:04:19 | loreal | 1 | 48755 | 3 | 1.576 | 30935.9 |
652 | 2024-03-31 06:13:01 | loreal | 1 | 48755 | 3 | 1.093 | 44606.6 |
651 | 2024-03-30 19:52:41 | loreal | 2 | 82551 | 42 | 4.703 | 17552.8 |
650 | 2024-03-30 18:40:32 | loreal | 2 | 82551 | 42 | 7.423 | 11121.0 |
649 | 2024-03-29 06:44:10 | loreal | 1 | 48755 | 3 | 2.203 | 22131.2 |
648 | 2024-03-06 19:45:42 | loreal | 3 | 112716 | 570 | 8.000 | 14089.5 |
647 | 2024-03-06 07:11:00 | loreal | 3 | 112716 | 570 | 20.520 | 5493.0 |
646 | 2024-03-06 03:39:04 | loreal | 3 | 112716 | 570 | 19.846 | 5679.5 |
645 | 2024-03-06 03:39:03 | loreal | 2 | 82551 | 42 | 5.593 | 14759.7 |
644 | 2024-03-06 03:38:55 | loreal | 1 | 48755 | 3 | 2.470 | 19738.9 |
643 | 2024-02-28 04:52:50 | loreal | 3 | 112716 | 570 | 15.923 | 7078.8 |
642 | 2024-02-27 22:02:32 | loreal | 2 | 82551 | 42 | 2.796 | 29524.7 |
641 | 2024-02-27 22:02:07 | loreal | 3 | 112716 | 570 | 6.576 | 17140.5 |
640 | 2024-02-27 21:58:03 | loreal | 3 | 112716 | 570 | 12.610 | 8938.6 |
639 | 2024-02-27 21:58:02 | loreal | 2 | 82551 | 42 | 4.733 | 17441.6 |
638 | 2024-02-27 21:57:55 | loreal | 1 | 48755 | 3 | 1.860 | 26212.4 |
637 | 2024-02-07 06:23:40 | loreal | 1 | 48755 | 3 | 0.923 | 52822.3 |
636 | 2024-02-04 03:39:35 | loreal | 1 | 48755 | 3 | 0.860 | 56691.9 |
635 | 2024-02-03 11:09:52 | loreal | 1 | 48755 | 3 | 0.813 | 59969.2 |
634 | 2024-01-19 06:27:26 | loreal | 1 | 48755 | 3 | 0.733 | 66514.3 |
633 | 2024-01-07 01:39:41 | loreal | 3 | 112716 | 570 | 4.810 | 23433.7 |
632 | 2023-12-27 08:23:15 | loreal | 3 | 112716 | 570 | 5.766 | 19548.4 |
631 | 2023-12-27 08:23:18 | loreal | 2 | 82551 | 42 | 2.750 | 30018.5 |
630 | 2023-12-05 04:37:45 | loreal | 2 | 82551 | 42 | 2.546 | 32423.8 |
629 | 2023-11-18 11:23:05 | loreal | 1 | 48755 | 3 | 0.736 | 66243.2 |
628 | 2023-11-14 10:00:00 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
627 | 2023-11-12 22:22:07 | loreal | 1 | 48755 | 3 | 0.843 | 57835.1 |
626 | 2023-11-10 17:53:38 | loreal | 1 | 48755 | 3 | 0.923 | 52822.3 |
625 | 2023-11-03 15:15:38 | loreal | 1 | 48755 | 3 | 0.810 | 60191.4 |
624 | 2023-10-24 03:52:11 | loreal | 2 | 82551 | 42 | 2.220 | 37185.1 |
623 | 2023-10-20 19:49:03 | loreal | 1 | 48755 | 3 | 0.813 | 59969.2 |
622 | 2023-10-17 09:13:41 | loreal | 3 | 112716 | 570 | 6.800 | 16575.9 |
621 | 2023-10-15 01:01:23 | loreal | 3 | 112716 | 570 | 5.330 | 21147.5 |
620 | 2023-10-12 01:14:35 | loreal | 1 | 48755 | 3 | 0.783 | 62266.9 |
619 | 2023-10-11 17:24:46 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
618 | 2023-10-05 06:00:50 | loreal | 1 | 48755 | 3 | 0.733 | 66514.3 |
617 | 2023-09-27 04:53:05 | loreal | 1 | 48755 | 3 | 0.860 | 56691.9 |
616 | 2023-09-13 16:33:54 | loreal | 1 | 48755 | 3 | 0.860 | 56691.9 |
615 | 2023-09-03 11:04:11 | loreal | 2 | 82551 | 42 | 2.280 | 36206.6 |
614 | 2023-09-01 23:06:14 | loreal | 1 | 48755 | 3 | 0.860 | 56691.9 |
613 | 2023-07-25 20:23:07 | loreal | 3 | 112716 | 570 | 5.266 | 21404.5 |
612 | 2023-06-24 23:26:17 | loreal | 1 | 48755 | 3 | 0.873 | 55847.7 |
611 | 2023-06-04 19:26:49 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
610 | 2023-04-05 04:45:46 | loreal | 3 | 112716 | 570 | 5.500 | 20493.8 |
609 | 2023-03-28 01:47:07 | loreal | 1 | 48755 | 3 | 0.736 | 66243.2 |
608 | 2023-03-09 09:37:59 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
607 | 2023-01-11 16:28:49 | loreal | 1 | 48755 | 3 | 0.736 | 66243.2 |
606 | 2023-01-02 09:11:27 | loreal | 3 | 112716 | 570 | 4.940 | 22817.0 |
605 | 2022-12-16 05:23:28 | loreal | 2 | 82551 | 42 | 2.420 | 34112.0 |
604 | 2022-12-06 02:13:25 | loreal | 3 | 112716 | 570 | 4.690 | 24033.3 |
603 | 2022-11-30 05:24:14 | loreal | 2 | 82551 | 42 | 2.186 | 37763.5 |
602 | 2022-11-17 14:14:37 | loreal | 1 | 48755 | 3 | 0.733 | 66514.3 |
601 | 2022-11-13 23:31:35 | loreal | 1 | 48755 | 3 | 0.830 | 58741.0 |
600 | 2022-11-05 07:33:35 | loreal | 3 | 112716 | 570 | 4.826 | 23356.0 |
599 | 2022-10-31 02:07:05 | loreal | 2 | 82551 | 42 | 2.406 | 34310.5 |
598 | 2022-10-20 19:21:39 | loreal | 1 | 48755 | 3 | 0.766 | 63648.8 |
597 | 2022-09-19 21:23:32 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
596 | 2022-09-18 15:52:03 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
595 | 2022-09-12 04:03:34 | loreal | 1 | 48755 | 3 | 0.733 | 66514.3 |
594 | 2022-09-09 06:40:45 | loreal | 3 | 112716 | 570 | 11.610 | 9708.5 |
593 | 2022-09-01 08:47:48 | loreal | 1 | 48755 | 3 | 0.733 | 66514.3 |
592 | 2022-08-15 09:34:06 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
591 | 2022-08-15 00:37:01 | loreal | 1 | 48755 | 3 | 1.733 | 28133.3 |
590 | 2022-08-14 11:47:54 | loreal | 1 | 48755 | 3 | 0.733 | 66514.3 |
589 | 2022-08-14 02:17:36 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
588 | 2022-08-07 11:37:24 | loreal | 2 | 82551 | 42 | 2.126 | 38829.3 |
587 | 2022-07-24 19:01:47 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
586 | 2022-06-12 06:49:30 | loreal | 1 | 48755 | 3 | 0.733 | 66514.3 |
585 | 2022-03-30 08:13:59 | loreal | 1 | 48755 | 3 | 0.873 | 55847.7 |
584 | 2022-03-26 20:43:04 | loreal | 1 | 48755 | 3 | 0.843 | 57835.1 |
583 | 2022-02-21 23:57:24 | loreal | 1 | 48755 | 3 | 0.920 | 52994.6 |
582 | 2022-02-19 19:32:19 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
581 | 2021-12-09 11:21:10 | loreal | 1 | 48755 | 3 | 0.846 | 57630.0 |
580 | 2021-12-09 00:40:00 | loreal | 1 | 48755 | 3 | 1.126 | 43299.3 |
579 | 2021-10-20 12:25:07 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
578 | 2021-09-12 13:25:51 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
577 | 2021-09-02 02:42:14 | loreal | 1 | 48755 | 3 | 0.830 | 58741.0 |
576 | 2021-08-29 19:35:14 | loreal | 1 | 48755 | 3 | 0.843 | 57835.1 |
575 | 2021-08-28 03:08:27 | loreal | 1 | 48755 | 3 | 1.406 | 34676.4 |
574 | 2021-06-06 21:51:28 | loreal | 1 | 48755 | 3 | 0.876 | 55656.4 |
573 | 2021-05-29 03:37:53 | loreal | 1 | 48755 | 3 | 0.876 | 55656.4 |
572 | 2021-05-13 06:34:40 | loreal | 1 | 48755 | 3 | 0.830 | 58741.0 |
571 | 2021-04-26 18:06:38 | loreal | 3 | 112716 | 570 | 5.876 | 19182.4 |
570 | 2021-04-25 16:13:58 | loreal | 2 | 82551 | 42 | 2.156 | 38289.0 |
569 | 2021-04-12 03:45:14 | loreal | 1 | 48755 | 3 | 0.813 | 59969.2 |
568 | 2021-04-01 19:39:00 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
567 | 2021-02-26 06:16:47 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
566 | 2021-02-22 05:06:09 | loreal | 1 | 48755 | 3 | 0.766 | 63648.8 |
565 | 2021-02-19 01:48:42 | loreal | 1 | 48755 | 3 | 0.766 | 63648.8 |
564 | 2020-11-30 20:44:16 | loreal | 1 | 48755 | 3 | 0.796 | 61250.0 |
563 | 2020-11-26 08:11:52 | loreal | 1 | 48755 | 3 | 0.796 | 61250.0 |
562 | 2020-10-08 00:36:47 | loreal | 1 | 48755 | 3 | 0.766 | 63648.8 |
561 | 2020-09-21 08:58:12 | loreal | 1 | 48755 | 3 | 0.780 | 62506.4 |
560 | 2020-09-10 20:44:16 | loreal | 1 | 48755 | 3 | 0.766 | 63648.8 |
559 | 2020-08-23 23:23:38 | loreal | 1 | 48755 | 3 | 0.843 | 57835.1 |
558 | 2020-08-23 20:21:23 | loreal | 1 | 48755 | 3 | 1.720 | 28345.9 |
557 | 2020-08-22 19:37:45 | loreal | 1 | 48755 | 3 | 0.860 | 56691.9 |
556 | 2020-08-06 11:12:44 | loreal | 1 | 48755 | 3 | 0.750 | 65006.7 |
555 | 2020-07-26 15:34:57 | loreal | 1 | 48755 | 3 | 0.780 | 62506.4 |
554 | 2020-07-20 18:46:24 | loreal | 1 | 48755 | 3 | 0.813 | 59969.2 |