History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mirth"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
643 | 2024-04-18 22:31:09 | mirth | 1 | 28756 | 7 | 0.440 | 65354.5 |
642 | 2024-04-11 19:20:46 | mirth | 1 | 28756 | 7 | 1.110 | 25906.3 |
641 | 2024-04-08 14:01:23 | mirth | 1 | 28756 | 7 | 0.533 | 53951.2 |
640 | 2024-04-04 19:47:18 | mirth | 3 | 83667 | 949 | 12.160 | 6880.5 |
639 | 2024-04-03 21:46:28 | mirth | 3 | 83667 | 949 | 13.080 | 6396.6 |
638 | 2024-04-03 05:20:31 | mirth | 3 | 83667 | 949 | 5.500 | 15212.2 |
637 | 2024-04-03 03:43:13 | mirth | 3 | 83667 | 949 | 6.703 | 12482.0 |
636 | 2024-04-03 03:43:14 | mirth | 2 | 53800 | 90 | 3.700 | 14540.5 |
635 | 2024-04-03 03:41:55 | mirth | 1 | 28756 | 7 | 2.216 | 12976.5 |
634 | 2024-03-31 03:52:09 | mirth | 1 | 28756 | 7 | 0.513 | 56054.6 |
633 | 2024-03-29 02:54:27 | mirth | 1 | 28756 | 7 | 0.516 | 55728.7 |
632 | 2024-03-27 01:51:41 | mirth | 1 | 28756 | 7 | 0.500 | 57512.0 |
631 | 2024-03-15 22:23:40 | mirth | 1 | 28756 | 7 | 1.483 | 19390.4 |
630 | 2024-03-04 14:09:08 | mirth | 2 | 53800 | 90 | 3.123 | 17227.0 |
629 | 2024-03-04 14:03:57 | mirth | 1 | 28756 | 7 | 1.123 | 25606.4 |
628 | 2024-03-04 14:01:47 | mirth | 3 | 83667 | 949 | 7.673 | 10904.1 |
627 | 2024-03-04 14:01:46 | mirth | 2 | 53800 | 90 | 1.830 | 29398.9 |
626 | 2024-03-04 02:34:04 | mirth | 3 | 83667 | 949 | 4.063 | 20592.4 |
625 | 2024-03-04 02:34:03 | mirth | 2 | 53800 | 90 | 1.640 | 32804.9 |
624 | 2024-03-04 02:33:22 | mirth | 1 | 28756 | 7 | 0.543 | 52957.6 |
623 | 2024-02-29 23:54:12 | mirth | 1 | 28756 | 7 | 0.546 | 52666.7 |
622 | 2024-02-27 19:30:12 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
621 | 2024-02-05 18:21:58 | mirth | 3 | 83667 | 949 | 4.423 | 18916.3 |
620 | 2024-02-03 00:35:10 | mirth | 2 | 53800 | 90 | 1.483 | 36277.8 |
619 | 2024-02-03 00:35:06 | mirth | 3 | 83667 | 949 | 3.763 | 22234.1 |
618 | 2024-02-02 23:17:51 | mirth | 1 | 28756 | 7 | 0.500 | 57512.0 |
617 | 2024-01-09 21:21:20 | mirth | 2 | 53800 | 90 | 1.906 | 28226.7 |
616 | 2024-01-05 02:51:18 | mirth | 3 | 83667 | 949 | 4.093 | 20441.5 |
615 | 2024-01-02 20:22:56 | mirth | 3 | 83667 | 949 | 3.970 | 21074.8 |
614 | 2024-01-02 20:22:55 | mirth | 2 | 53800 | 90 | 1.643 | 32745.0 |
613 | 2023-12-28 07:46:25 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
612 | 2023-12-22 00:46:41 | mirth | 1 | 28756 | 7 | 0.486 | 59168.7 |
611 | 2023-12-15 05:40:58 | mirth | 2 | 53800 | 90 | 1.406 | 38264.6 |
610 | 2023-11-17 07:11:03 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
609 | 2023-11-15 04:33:26 | mirth | 3 | 83667 | 949 | 3.546 | 23594.8 |
608 | 2023-11-15 04:33:25 | mirth | 2 | 53800 | 90 | 1.406 | 38264.6 |
607 | 2023-11-13 22:23:19 | mirth | 1 | 28756 | 7 | 0.486 | 59168.7 |
606 | 2023-11-04 08:24:52 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
605 | 2023-10-21 10:18:35 | mirth | 1 | 28756 | 7 | 0.486 | 59168.7 |
604 | 2023-10-18 21:15:32 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
603 | 2023-10-16 17:07:59 | mirth | 1 | 28756 | 7 | 0.453 | 63479.0 |
602 | 2023-10-12 04:31:44 | mirth | 1 | 28756 | 7 | 0.500 | 57512.0 |
601 | 2023-10-05 05:03:10 | mirth | 1 | 28756 | 7 | 0.423 | 67981.1 |
600 | 2023-09-26 18:57:50 | mirth | 1 | 28756 | 7 | 0.423 | 67981.1 |
599 | 2023-09-24 13:48:04 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
598 | 2023-09-14 22:28:35 | mirth | 2 | 53800 | 90 | 1.373 | 39184.3 |
597 | 2023-08-19 08:22:07 | mirth | 1 | 28756 | 7 | 0.466 | 61708.2 |
596 | 2023-08-13 10:07:29 | mirth | 1 | 28756 | 7 | 0.440 | 65354.5 |
595 | 2023-06-14 22:36:15 | mirth | 2 | 53800 | 90 | 1.686 | 31909.8 |
594 | 2023-05-15 03:51:20 | mirth | 1 | 28756 | 7 | 0.450 | 63902.2 |
593 | 2023-05-13 07:58:43 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
592 | 2023-05-01 11:21:28 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
591 | 2023-04-27 19:10:34 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
590 | 2023-03-13 02:23:48 | mirth | 2 | 53800 | 90 | 1.593 | 33772.8 |
589 | 2023-03-08 21:06:56 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
588 | 2023-01-11 18:19:29 | mirth | 1 | 28756 | 7 | 0.420 | 68466.7 |
587 | 2022-12-30 05:59:09 | mirth | 1 | 28756 | 7 | 0.440 | 65354.5 |
586 | 2022-12-18 19:25:57 | mirth | 2 | 53800 | 90 | 1.406 | 38264.6 |
585 | 2022-11-25 08:05:05 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
584 | 2022-11-10 19:23:03 | mirth | 3 | 83667 | 949 | 6.500 | 12871.8 |
583 | 2022-10-01 04:56:42 | mirth | 3 | 83667 | 949 | 3.423 | 24442.6 |
582 | 2022-09-19 02:46:58 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
581 | 2022-09-13 11:13:44 | mirth | 1 | 28756 | 7 | 0.420 | 68466.7 |
580 | 2022-09-08 07:47:43 | mirth | 3 | 83667 | 949 | 3.266 | 25617.6 |
579 | 2022-08-15 08:32:45 | mirth | 2 | 53800 | 90 | 1.360 | 39558.8 |
578 | 2022-08-15 02:12:26 | mirth | 1 | 28756 | 7 | 0.486 | 59168.7 |
577 | 2022-08-06 18:02:39 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
576 | 2022-07-31 03:27:26 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
575 | 2022-07-29 10:49:26 | mirth | 1 | 28756 | 7 | 0.440 | 65354.5 |
574 | 2022-06-14 12:19:45 | mirth | 1 | 28756 | 7 | 0.486 | 59168.7 |
573 | 2022-06-12 10:13:27 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
572 | 2022-06-08 17:08:15 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
571 | 2022-06-07 09:50:19 | mirth | 1 | 28756 | 7 | 0.453 | 63479.0 |
570 | 2022-05-06 09:13:22 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
569 | 2022-04-30 13:36:59 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
568 | 2022-04-27 10:43:10 | mirth | 1 | 28756 | 7 | 0.720 | 39938.9 |
567 | 2022-01-20 19:51:02 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
566 | 2022-01-10 06:29:54 | mirth | 1 | 28756 | 7 | 0.453 | 63479.0 |
565 | 2021-11-20 14:46:39 | mirth | 1 | 28756 | 7 | 0.440 | 65354.5 |
564 | 2021-10-06 08:44:45 | mirth | 1 | 28756 | 7 | 0.580 | 49579.3 |
563 | 2021-09-30 20:15:20 | mirth | 1 | 28756 | 7 | 0.436 | 65954.1 |
562 | 2021-09-06 08:46:41 | mirth | 1 | 28756 | 7 | 0.453 | 63479.0 |
561 | 2021-08-19 18:34:18 | mirth | 1 | 28756 | 7 | 0.500 | 57512.0 |
560 | 2021-08-17 14:22:54 | mirth | 1 | 28756 | 7 | 0.420 | 68466.7 |
559 | 2021-07-01 11:06:22 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
558 | 2021-06-03 06:43:19 | mirth | 2 | 53800 | 90 | 1.373 | 39184.3 |
557 | 2021-05-30 16:05:06 | mirth | 1 | 28756 | 7 | 0.516 | 55728.7 |
556 | 2021-04-11 06:36:59 | mirth | 3 | 83667 | 949 | 3.313 | 25254.2 |
555 | 2021-04-03 11:11:19 | mirth | 1 | 28756 | 7 | 0.906 | 31739.5 |
554 | 2021-03-31 13:20:29 | mirth | 1 | 28756 | 7 | 0.423 | 67981.1 |
553 | 2021-03-11 19:12:43 | mirth | 2 | 53800 | 90 | 1.470 | 36598.6 |
552 | 2021-03-07 22:20:37 | mirth | 1 | 28756 | 7 | 0.440 | 65354.5 |
551 | 2021-02-20 01:49:43 | mirth | 1 | 28756 | 7 | 0.483 | 59536.2 |
550 | 2021-02-19 17:35:04 | mirth | 2 | 53800 | 90 | 1.406 | 38264.6 |
549 | 2021-02-18 09:52:25 | mirth | 3 | 83667 | 949 | 3.826 | 21868.0 |
548 | 2021-02-11 20:43:02 | mirth | 1 | 28756 | 7 | 0.516 | 55728.7 |
547 | 2021-01-22 15:34:25 | mirth | 2 | 53800 | 90 | 1.373 | 39184.3 |
546 | 2021-01-18 10:07:51 | mirth | 1 | 28756 | 7 | 0.440 | 65354.5 |
545 | 2020-12-19 21:53:53 | mirth | 1 | 28756 | 7 | 0.440 | 65354.5 |
544 | 2020-11-23 23:45:59 | mirth | 1 | 28756 | 7 | 0.500 | 57512.0 |