History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"soap"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
672 | 2024-04-27 11:12:11 | soap | 2 | 29872 | 306 | 2.030 | 14715.3 |
671 | 2024-04-27 10:29:42 | soap | 2 | 29872 | 306 | 1.063 | 28101.6 |
670 | 2024-04-27 09:49:44 | soap | 1 | 13983 | 11 | 0.280 | 49939.3 |
669 | 2024-04-27 09:44:11 | soap | 1 | 13983 | 11 | 0.296 | 47239.9 |
668 | 2024-04-04 19:30:42 | soap | 1 | 13983 | 11 | 0.563 | 24836.6 |
667 | 2024-04-02 18:44:07 | soap | 2 | 29872 | 306 | 2.076 | 14389.2 |
666 | 2024-04-02 18:39:46 | soap | 1 | 13983 | 11 | 0.560 | 24969.6 |
665 | 2024-03-30 19:28:02 | soap | 2 | 29872 | 306 | 3.203 | 9326.3 |
664 | 2024-03-30 19:15:00 | soap | 1 | 13983 | 11 | 0.300 | 46610.0 |
663 | 2024-03-28 19:05:07 | soap | 2 | 29872 | 306 | 2.563 | 11655.1 |
662 | 2024-03-28 17:56:29 | soap | 1 | 13983 | 11 | 0.283 | 49409.9 |
661 | 2024-03-05 17:32:28 | soap | 1 | 13983 | 11 | 0.280 | 49939.3 |
660 | 2024-02-26 03:26:48 | soap | 1 | 13983 | 11 | 0.266 | 52567.7 |
659 | 2024-02-22 09:38:01 | soap | 2 | 29872 | 306 | 0.813 | 36742.9 |
658 | 2024-02-20 15:49:49 | soap | 2 | 29872 | 306 | 1.000 | 29872.0 |
657 | 2024-02-03 16:08:28 | soap | 1 | 13983 | 11 | 0.233 | 60012.9 |
656 | 2024-02-03 03:12:14 | soap | 1 | 13983 | 11 | 0.500 | 27966.0 |
655 | 2024-01-28 16:11:56 | soap | 1 | 13983 | 11 | 0.263 | 53167.3 |
654 | 2024-01-26 22:25:13 | soap | 1 | 13983 | 11 | 0.266 | 52567.7 |
653 | 2024-01-16 15:23:42 | soap | 2 | 29872 | 306 | 0.830 | 35990.4 |
652 | 2023-12-22 15:16:53 | soap | 1 | 13983 | 11 | 0.233 | 60012.9 |
651 | 2023-12-21 17:05:37 | soap | 2 | 29872 | 306 | 0.780 | 38297.4 |
650 | 2023-12-08 14:26:05 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
649 | 2023-12-08 14:26:05 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
648 | 2023-11-27 15:49:37 | soap | 1 | 13983 | 11 | 0.236 | 59250.0 |
647 | 2023-11-24 03:00:12 | soap | 1 | 13983 | 11 | 0.266 | 52567.7 |
646 | 2023-11-21 22:41:42 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
645 | 2023-11-20 19:53:43 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
644 | 2023-11-18 10:11:37 | soap | 1 | 13983 | 11 | 0.280 | 49939.3 |
643 | 2023-11-18 05:38:49 | soap | 2 | 29872 | 306 | 0.876 | 34100.5 |
642 | 2023-11-18 00:51:21 | soap | 2 | 29872 | 306 | 0.860 | 34734.9 |
641 | 2023-11-12 06:49:54 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
640 | 2023-10-29 03:13:28 | soap | 2 | 29872 | 306 | 0.906 | 32971.3 |
639 | 2023-10-27 00:05:55 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
638 | 2023-10-19 21:13:14 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
637 | 2023-10-18 16:05:15 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
636 | 2023-10-13 20:24:24 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
635 | 2023-10-05 03:48:54 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
634 | 2023-09-27 05:27:19 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
633 | 2023-09-12 17:08:31 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
632 | 2023-09-11 19:17:38 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
631 | 2023-08-19 16:57:21 | soap | 2 | 29872 | 306 | 0.796 | 37527.6 |
630 | 2023-07-31 10:46:04 | soap | 1 | 13983 | 11 | 0.233 | 60012.9 |
629 | 2023-06-25 23:24:06 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
628 | 2023-05-04 00:29:08 | soap | 2 | 29872 | 306 | 2.346 | 12733.2 |
627 | 2023-04-12 01:03:22 | soap | 1 | 13983 | 11 | 0.266 | 52567.7 |
626 | 2023-04-09 18:02:04 | soap | 1 | 13983 | 11 | 0.216 | 64736.1 |
625 | 2023-02-10 20:01:07 | soap | 2 | 29872 | 306 | 0.766 | 38997.4 |
624 | 2023-02-01 12:52:46 | soap | 1 | 13983 | 11 | 0.216 | 64736.1 |
623 | 2022-12-26 17:50:20 | soap | 1 | 13983 | 11 | 0.236 | 59250.0 |
622 | 2022-11-30 02:15:00 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
621 | 2022-11-26 15:24:09 | soap | 2 | 29872 | 306 | 0.856 | 34897.2 |
620 | 2022-11-23 02:16:01 | soap | 2 | 29872 | 306 | 0.780 | 38297.4 |
619 | 2022-08-29 20:31:50 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
618 | 2022-08-06 10:16:46 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
617 | 2022-07-26 00:32:55 | soap | 1 | 13983 | 11 | 0.236 | 59250.0 |
616 | 2022-07-18 19:07:40 | soap | 1 | 13983 | 11 | 0.236 | 59250.0 |
615 | 2022-07-17 21:55:15 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
614 | 2022-07-03 02:16:04 | soap | 1 | 13983 | 11 | 0.280 | 49939.3 |
613 | 2022-06-17 02:55:42 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
612 | 2022-06-15 17:59:23 | soap | 1 | 13983 | 11 | 0.233 | 60012.9 |
611 | 2022-05-14 02:32:57 | soap | 1 | 13983 | 11 | 0.280 | 49939.3 |
610 | 2022-05-04 21:55:40 | soap | 2 | 29872 | 306 | 0.873 | 34217.6 |
609 | 2022-04-29 12:07:24 | soap | 1 | 13983 | 11 | 0.216 | 64736.1 |
608 | 2022-04-25 18:49:58 | soap | 1 | 13983 | 11 | 0.233 | 60012.9 |
607 | 2022-03-22 22:15:56 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
606 | 2022-03-20 18:35:00 | soap | 1 | 13983 | 11 | 0.236 | 59250.0 |
605 | 2022-01-09 07:16:22 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
604 | 2022-01-06 18:24:23 | soap | 2 | 29872 | 306 | 0.856 | 34897.2 |
603 | 2021-12-28 21:08:20 | soap | 1 | 13983 | 11 | 0.233 | 60012.9 |
602 | 2021-11-04 15:44:24 | soap | 1 | 13983 | 11 | 0.236 | 59250.0 |
601 | 2021-10-19 14:18:00 | soap | 2 | 29872 | 306 | 0.763 | 39150.7 |
600 | 2021-09-29 22:14:27 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
599 | 2021-09-28 11:22:36 | soap | 1 | 13983 | 11 | 0.280 | 49939.3 |
598 | 2021-08-31 06:03:22 | soap | 1 | 13983 | 11 | 0.233 | 60012.9 |
597 | 2021-08-29 01:25:02 | soap | 1 | 13983 | 11 | 0.266 | 52567.7 |
596 | 2021-08-24 11:16:45 | soap | 2 | 29872 | 306 | 0.783 | 38150.7 |
595 | 2021-08-24 10:54:16 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
594 | 2021-08-24 09:27:03 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
593 | 2021-08-18 14:46:25 | soap | 2 | 29872 | 306 | 0.763 | 39150.7 |
592 | 2021-08-13 20:02:55 | soap | 1 | 13983 | 11 | 0.216 | 64736.1 |
591 | 2021-06-30 12:24:56 | soap | 1 | 13983 | 11 | 0.263 | 53167.3 |
590 | 2021-05-07 14:51:41 | soap | 1 | 13983 | 11 | 0.283 | 49409.9 |
589 | 2021-03-30 08:34:14 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
588 | 2021-03-26 00:16:26 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
587 | 2021-03-21 14:47:13 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
586 | 2021-02-23 18:23:09 | soap | 1 | 13983 | 11 | 0.216 | 64736.1 |
585 | 2021-02-14 06:36:23 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
584 | 2021-01-20 18:30:48 | soap | 2 | 29872 | 306 | 0.826 | 36164.6 |
583 | 2020-12-29 11:01:00 | soap | 1 | 13983 | 11 | 0.263 | 53167.3 |
582 | 2020-12-11 09:26:44 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
581 | 2020-10-31 19:36:24 | soap | 2 | 29872 | 306 | 0.873 | 34217.6 |
580 | 2020-10-27 22:19:18 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
579 | 2020-10-18 01:59:19 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
578 | 2020-10-06 19:32:44 | soap | 1 | 13983 | 11 | 0.250 | 55932.0 |
577 | 2020-09-30 17:15:52 | soap | 1 | 13983 | 11 | 0.220 | 63559.1 |
576 | 2020-09-14 20:02:38 | soap | 1 | 13983 | 11 | 0.330 | 42372.7 |
575 | 2020-09-04 15:41:04 | soap | 1 | 13983 | 11 | 0.233 | 60012.9 |
574 | 2020-08-29 02:19:43 | soap | 1 | 13983 | 11 | 0.263 | 53167.3 |
573 | 2020-08-07 20:11:12 | soap | 1 | 13983 | 11 | 0.236 | 59250.0 |