History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"invest"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
635 | 2024-04-05 23:51:14 | invest | 3 | 112716 | 529 | 11.860 | 9503.9 |
634 | 2024-04-05 19:23:07 | invest | 1 | 48755 | 7 | 1.766 | 27607.6 |
633 | 2024-04-05 13:40:54 | invest | 3 | 112716 | 529 | 20.766 | 5427.9 |
632 | 2024-04-05 13:40:57 | invest | 2 | 82551 | 58 | 5.200 | 15875.2 |
631 | 2024-04-05 13:40:31 | invest | 1 | 48755 | 7 | 3.390 | 14382.0 |
630 | 2024-03-29 20:49:41 | invest | 1 | 48755 | 7 | 0.846 | 57630.0 |
629 | 2024-03-29 20:41:58 | invest | 3 | 112716 | 529 | 11.126 | 10130.9 |
628 | 2024-03-29 20:41:58 | invest | 2 | 82551 | 58 | 2.736 | 30172.1 |
627 | 2024-03-29 10:07:38 | invest | 2 | 82551 | 58 | 4.403 | 18748.8 |
626 | 2024-03-28 23:53:36 | invest | 3 | 112716 | 529 | 9.796 | 11506.3 |
625 | 2024-03-28 17:16:45 | invest | 3 | 112716 | 529 | 19.343 | 5827.2 |
624 | 2024-03-28 17:16:45 | invest | 2 | 82551 | 58 | 8.000 | 10318.9 |
623 | 2024-03-28 17:16:34 | invest | 1 | 48755 | 7 | 0.970 | 50262.9 |
622 | 2024-03-06 22:07:35 | invest | 3 | 112716 | 529 | 19.873 | 5671.8 |
621 | 2024-03-06 22:07:33 | invest | 2 | 82551 | 58 | 8.970 | 9203.0 |
620 | 2024-03-06 04:17:08 | invest | 1 | 48755 | 7 | 0.983 | 49598.2 |
619 | 2024-03-06 04:16:51 | invest | 3 | 112716 | 529 | 14.953 | 7538.0 |
618 | 2024-03-06 04:16:51 | invest | 2 | 82551 | 58 | 8.436 | 9785.6 |
617 | 2024-03-06 04:16:48 | invest | 1 | 48755 | 7 | 1.893 | 25755.4 |
616 | 2024-03-04 07:13:47 | invest | 1 | 48755 | 7 | 2.000 | 24377.5 |
615 | 2024-02-28 06:21:27 | invest | 2 | 82551 | 58 | 5.343 | 15450.3 |
614 | 2024-02-28 06:20:37 | invest | 3 | 112716 | 529 | 5.610 | 20092.0 |
613 | 2024-02-28 03:08:01 | invest | 2 | 82551 | 58 | 5.656 | 14595.3 |
612 | 2024-02-27 15:36:16 | invest | 3 | 112716 | 529 | 5.703 | 19764.3 |
611 | 2024-02-27 15:36:15 | invest | 2 | 82551 | 58 | 3.376 | 24452.3 |
610 | 2024-02-27 15:36:14 | invest | 1 | 48755 | 7 | 1.033 | 47197.5 |
609 | 2024-02-21 05:36:36 | invest | 1 | 48755 | 7 | 0.920 | 52994.6 |
608 | 2024-01-10 23:54:37 | invest | 3 | 112716 | 529 | 4.686 | 24053.8 |
607 | 2024-01-08 09:47:36 | invest | 1 | 48755 | 7 | 0.720 | 67715.3 |
606 | 2024-01-03 17:47:51 | invest | 1 | 48755 | 7 | 0.953 | 51159.5 |
605 | 2023-12-20 06:32:47 | invest | 1 | 48755 | 7 | 0.826 | 59025.4 |
604 | 2023-12-15 17:52:58 | invest | 2 | 82551 | 58 | 2.143 | 38521.2 |
603 | 2023-12-12 10:21:31 | invest | 3 | 112716 | 529 | 4.906 | 22975.1 |
602 | 2023-12-07 11:31:46 | invest | 3 | 112716 | 529 | 5.813 | 19390.3 |
601 | 2023-12-04 08:58:08 | invest | 3 | 112716 | 529 | 5.216 | 21609.7 |
600 | 2023-12-03 15:20:56 | invest | 2 | 82551 | 58 | 2.733 | 30205.3 |
599 | 2023-11-30 19:45:50 | invest | 2 | 82551 | 58 | 2.076 | 39764.5 |
598 | 2023-11-27 03:19:23 | invest | 3 | 112716 | 529 | 6.173 | 18259.5 |
597 | 2023-11-14 17:05:05 | invest | 1 | 48755 | 7 | 0.860 | 56691.9 |
596 | 2023-11-13 19:47:23 | invest | 1 | 48755 | 7 | 0.796 | 61250.0 |
595 | 2023-11-11 20:21:55 | invest | 1 | 48755 | 7 | 0.813 | 59969.2 |
594 | 2023-11-10 01:49:00 | invest | 3 | 112716 | 529 | 5.780 | 19501.0 |
593 | 2023-11-08 10:02:26 | invest | 2 | 82551 | 58 | 2.516 | 32810.4 |
592 | 2023-11-06 06:40:53 | invest | 3 | 112716 | 529 | 8.250 | 13662.5 |
591 | 2023-11-04 09:27:02 | invest | 3 | 112716 | 529 | 7.233 | 15583.6 |
590 | 2023-11-01 03:06:30 | invest | 3 | 112716 | 529 | 4.780 | 23580.8 |
589 | 2023-10-30 19:13:36 | invest | 1 | 48755 | 7 | 0.796 | 61250.0 |
588 | 2023-10-23 19:27:17 | invest | 1 | 48755 | 7 | 0.860 | 56691.9 |
587 | 2023-10-21 18:16:53 | invest | 3 | 112716 | 529 | 6.610 | 17052.3 |
586 | 2023-10-18 15:12:58 | invest | 1 | 48755 | 7 | 0.733 | 66514.3 |
585 | 2023-10-16 23:27:04 | invest | 3 | 112716 | 529 | 4.860 | 23192.6 |
584 | 2023-10-15 11:49:21 | invest | 2 | 82551 | 58 | 2.860 | 28864.0 |
583 | 2023-10-10 22:23:38 | invest | 1 | 48755 | 7 | 0.750 | 65006.7 |
582 | 2023-09-27 08:34:55 | invest | 1 | 48755 | 7 | 0.796 | 61250.0 |
581 | 2023-09-24 16:53:25 | invest | 1 | 48755 | 7 | 0.720 | 67715.3 |
580 | 2023-09-16 05:40:12 | invest | 2 | 82551 | 58 | 2.126 | 38829.3 |
579 | 2023-09-04 16:44:40 | invest | 1 | 48755 | 7 | 0.750 | 65006.7 |
578 | 2023-08-23 12:12:08 | invest | 1 | 48755 | 7 | 0.736 | 66243.2 |
577 | 2023-06-17 03:59:47 | invest | 2 | 82551 | 58 | 2.530 | 32628.9 |
576 | 2023-05-25 01:52:43 | invest | 1 | 48755 | 7 | 0.796 | 61250.0 |
575 | 2023-05-15 12:40:25 | invest | 1 | 48755 | 7 | 0.810 | 60191.4 |
574 | 2023-03-19 18:50:34 | invest | 1 | 48755 | 7 | 0.736 | 66243.2 |
573 | 2023-03-15 16:22:42 | invest | 2 | 82551 | 58 | 2.343 | 35233.0 |
572 | 2023-02-05 14:16:05 | invest | 1 | 48755 | 7 | 0.736 | 66243.2 |
571 | 2023-01-24 06:04:58 | invest | 2 | 82551 | 58 | 2.253 | 36640.5 |
570 | 2023-01-06 22:10:33 | invest | 1 | 48755 | 7 | 0.796 | 61250.0 |
569 | 2022-12-19 04:39:48 | invest | 2 | 82551 | 58 | 2.046 | 40347.5 |
568 | 2022-12-10 00:23:07 | invest | 2 | 82551 | 58 | 2.343 | 35233.0 |
567 | 2022-11-08 10:15:03 | invest | 2 | 82551 | 58 | 2.686 | 30733.8 |
566 | 2022-10-15 12:31:38 | invest | 1 | 48755 | 7 | 0.830 | 58741.0 |
565 | 2022-10-04 23:07:15 | invest | 1 | 48755 | 7 | 0.733 | 66514.3 |
564 | 2022-09-19 23:42:13 | invest | 1 | 48755 | 7 | 0.720 | 67715.3 |
563 | 2022-09-18 16:34:58 | invest | 1 | 48755 | 7 | 0.843 | 57835.1 |
562 | 2022-08-26 02:59:48 | invest | 1 | 48755 | 7 | 0.736 | 66243.2 |
561 | 2022-08-17 14:43:23 | invest | 1 | 48755 | 7 | 0.796 | 61250.0 |
560 | 2022-08-12 13:50:12 | invest | 2 | 82551 | 58 | 2.296 | 35954.3 |
559 | 2022-08-07 00:49:38 | invest | 1 | 48755 | 7 | 1.546 | 31536.2 |
558 | 2022-08-06 06:09:50 | invest | 1 | 48755 | 7 | 0.733 | 66514.3 |
557 | 2022-07-30 02:09:25 | invest | 1 | 48755 | 7 | 0.733 | 66514.3 |
556 | 2022-07-12 04:55:36 | invest | 1 | 48755 | 7 | 1.030 | 47335.0 |
555 | 2022-07-03 10:04:47 | invest | 1 | 48755 | 7 | 0.763 | 63899.1 |
554 | 2022-06-21 11:09:07 | invest | 1 | 48755 | 7 | 0.733 | 66514.3 |
553 | 2022-06-16 10:02:42 | invest | 1 | 48755 | 7 | 0.796 | 61250.0 |
552 | 2022-06-15 17:00:09 | invest | 1 | 48755 | 7 | 0.860 | 56691.9 |
551 | 2022-05-30 07:24:40 | invest | 1 | 48755 | 7 | 0.733 | 66514.3 |
550 | 2022-05-20 18:46:04 | invest | 1 | 48755 | 7 | 0.766 | 63648.8 |
549 | 2022-05-04 03:50:02 | invest | 1 | 48755 | 7 | 0.843 | 57835.1 |
548 | 2022-04-06 13:06:45 | invest | 1 | 48755 | 7 | 1.110 | 43923.4 |
547 | 2022-03-12 10:49:58 | invest | 1 | 48755 | 7 | 0.750 | 65006.7 |
546 | 2022-03-02 05:53:18 | invest | 1 | 48755 | 7 | 0.796 | 61250.0 |
545 | 2022-02-21 15:49:47 | invest | 1 | 48755 | 7 | 0.983 | 49598.2 |
544 | 2022-02-20 07:46:13 | invest | 1 | 48755 | 7 | 0.860 | 56691.9 |
543 | 2022-02-19 11:25:24 | invest | 1 | 48755 | 7 | 0.906 | 53813.5 |
542 | 2022-01-15 23:01:26 | invest | 1 | 48755 | 7 | 0.856 | 56956.8 |
541 | 2021-11-18 13:19:35 | invest | 1 | 48755 | 7 | 0.876 | 55656.4 |
540 | 2021-11-13 17:56:34 | invest | 1 | 48755 | 7 | 0.843 | 57835.1 |
539 | 2021-10-03 13:37:59 | invest | 1 | 48755 | 7 | 0.890 | 54780.9 |
538 | 2021-10-01 10:58:10 | invest | 1 | 48755 | 7 | 0.750 | 65006.7 |
537 | 2021-09-10 01:38:06 | invest | 1 | 48755 | 7 | 0.800 | 60943.8 |
536 | 2021-08-15 18:09:12 | invest | 1 | 48755 | 7 | 0.750 | 65006.7 |