History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
642 | 2024-04-27 17:07:44 | harry | 1 | 28756 | 12 | 0.673 | 42728.1 |
641 | 2024-04-24 04:57:38 | harry | 1 | 28756 | 12 | 1.906 | 15087.1 |
640 | 2024-04-24 04:00:28 | harry | 1 | 28756 | 12 | 0.563 | 51076.4 |
639 | 2024-04-24 02:45:57 | harry | 1 | 28756 | 12 | 0.626 | 45936.1 |
638 | 2024-04-24 02:44:06 | harry | 1 | 28756 | 12 | 0.826 | 34813.6 |
637 | 2024-04-24 02:43:13 | harry | 1 | 28756 | 12 | 1.140 | 25224.6 |
636 | 2024-04-24 02:28:42 | harry | 1 | 28756 | 12 | 0.653 | 44036.8 |
635 | 2024-04-18 15:51:15 | harry | 1 | 28756 | 12 | 1.436 | 20025.1 |
634 | 2024-04-02 21:58:19 | harry | 1 | 28756 | 12 | 0.563 | 51076.4 |
633 | 2024-03-31 03:50:51 | harry | 1 | 28756 | 12 | 1.110 | 25906.3 |
632 | 2024-03-31 03:26:11 | harry | 1 | 28756 | 12 | 1.766 | 16283.1 |
631 | 2024-03-29 01:17:55 | harry | 1 | 28756 | 12 | 1.686 | 17055.8 |
630 | 2024-03-21 10:07:13 | harry | 1 | 28756 | 12 | 0.686 | 41918.4 |
629 | 2024-03-15 22:40:59 | harry | 1 | 28756 | 12 | 0.533 | 53951.2 |
628 | 2024-03-03 23:27:00 | harry | 2 | 53800 | 125 | 6.140 | 8762.2 |
627 | 2024-03-03 22:17:04 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
626 | 2024-03-01 09:30:22 | harry | 1 | 28756 | 12 | 1.796 | 16011.1 |
625 | 2024-02-27 20:08:30 | harry | 1 | 28756 | 12 | 0.546 | 52666.7 |
624 | 2024-02-13 12:40:16 | harry | 1 | 28756 | 12 | 1.153 | 24940.2 |
623 | 2024-01-29 00:24:37 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
622 | 2024-01-10 16:54:11 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
621 | 2024-01-07 13:44:56 | harry | 2 | 53800 | 125 | 1.500 | 35866.7 |
620 | 2024-01-03 08:48:17 | harry | 2 | 53800 | 125 | 1.686 | 31909.8 |
619 | 2023-12-25 19:33:24 | harry | 1 | 28756 | 12 | 0.533 | 53951.2 |
618 | 2023-12-15 14:24:01 | harry | 1 | 28756 | 12 | 0.513 | 56054.6 |
617 | 2023-12-07 01:59:07 | harry | 1 | 28756 | 12 | 0.440 | 65354.5 |
616 | 2023-12-07 01:59:06 | harry | 1 | 28756 | 12 | 0.470 | 61183.0 |
615 | 2023-11-23 10:13:06 | harry | 2 | 53800 | 125 | 1.376 | 39098.8 |
614 | 2023-11-16 07:59:54 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
613 | 2023-11-15 19:09:39 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
612 | 2023-11-09 03:23:30 | harry | 1 | 28756 | 12 | 0.486 | 59168.7 |
611 | 2023-11-03 14:51:22 | harry | 1 | 28756 | 12 | 0.533 | 53951.2 |
610 | 2023-10-31 00:33:00 | harry | 2 | 53800 | 125 | 1.423 | 37807.4 |
609 | 2023-10-20 19:59:23 | harry | 1 | 28756 | 12 | 0.530 | 54256.6 |
608 | 2023-10-17 16:20:51 | harry | 1 | 28756 | 12 | 0.516 | 55728.7 |
607 | 2023-10-13 02:31:45 | harry | 1 | 28756 | 12 | 0.533 | 53951.2 |
606 | 2023-10-03 16:32:44 | harry | 1 | 28756 | 12 | 0.486 | 59168.7 |
605 | 2023-10-01 11:35:04 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
604 | 2023-09-24 18:41:26 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
603 | 2023-09-22 05:09:05 | harry | 1 | 28756 | 12 | 0.470 | 61183.0 |
602 | 2023-09-02 12:53:47 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
601 | 2023-07-29 05:32:25 | harry | 1 | 28756 | 12 | 0.440 | 65354.5 |
600 | 2023-05-16 18:05:36 | harry | 1 | 28756 | 12 | 0.450 | 63902.2 |
599 | 2023-04-24 16:09:02 | harry | 1 | 28756 | 12 | 0.466 | 61708.2 |
598 | 2023-02-12 22:21:00 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
597 | 2023-02-06 20:30:07 | harry | 1 | 28756 | 12 | 0.470 | 61183.0 |
596 | 2022-12-11 11:05:30 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
595 | 2022-10-20 09:58:00 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
594 | 2022-09-19 17:59:55 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
593 | 2022-09-12 08:42:46 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
592 | 2022-08-16 00:33:17 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
591 | 2022-08-14 18:14:13 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
590 | 2022-08-06 23:55:20 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
589 | 2022-07-30 01:26:37 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
588 | 2022-07-29 02:27:23 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
587 | 2022-07-17 21:59:08 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
586 | 2022-07-02 22:05:31 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
585 | 2022-06-30 09:35:19 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
584 | 2022-05-31 20:51:41 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
583 | 2022-04-10 12:44:22 | harry | 1 | 28756 | 12 | 0.530 | 54256.6 |
582 | 2022-04-09 01:51:59 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
581 | 2022-03-10 04:22:27 | harry | 1 | 28756 | 12 | 0.466 | 61708.2 |
580 | 2022-03-01 11:23:21 | harry | 1 | 28756 | 12 | 0.516 | 55728.7 |
579 | 2022-02-28 11:38:16 | harry | 1 | 28756 | 12 | 0.626 | 45936.1 |
578 | 2022-02-27 09:23:38 | harry | 1 | 28756 | 12 | 0.546 | 52666.7 |
577 | 2022-02-26 08:31:38 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
576 | 2022-02-25 05:11:44 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
575 | 2022-01-10 15:37:03 | harry | 1 | 28756 | 12 | 0.546 | 52666.7 |
574 | 2021-11-23 04:19:57 | harry | 1 | 28756 | 12 | 0.533 | 53951.2 |
573 | 2021-11-14 21:49:21 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
572 | 2021-11-12 21:03:39 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
571 | 2021-10-04 18:14:34 | harry | 1 | 28756 | 12 | 0.470 | 61183.0 |
570 | 2021-09-06 22:36:13 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
569 | 2021-08-22 11:35:18 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
568 | 2021-08-16 20:41:28 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
567 | 2021-07-10 20:54:40 | harry | 1 | 28756 | 12 | 0.516 | 55728.7 |
566 | 2021-07-09 18:39:36 | harry | 1 | 28756 | 12 | 0.533 | 53951.2 |
565 | 2021-07-04 12:40:00 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
564 | 2021-07-03 23:30:57 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
563 | 2021-07-02 13:38:25 | harry | 1 | 28756 | 12 | 0.530 | 54256.6 |
562 | 2021-06-30 17:40:30 | harry | 1 | 28756 | 12 | 0.470 | 61183.0 |
561 | 2021-06-29 23:17:41 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
560 | 2021-06-29 08:33:04 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
559 | 2021-06-28 21:54:30 | harry | 1 | 28756 | 12 | 1.093 | 26309.2 |
558 | 2021-06-28 01:51:49 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
557 | 2021-06-20 22:29:33 | harry | 1 | 28756 | 12 | 0.626 | 45936.1 |
556 | 2021-06-11 15:08:15 | harry | 1 | 28756 | 12 | 0.516 | 55728.7 |
555 | 2021-06-10 22:31:22 | harry | 1 | 28756 | 12 | 0.530 | 54256.6 |
554 | 2021-06-09 23:50:22 | harry | 1 | 28756 | 12 | 0.513 | 56054.6 |
553 | 2021-06-09 03:58:54 | harry | 1 | 28756 | 12 | 0.906 | 31739.5 |
552 | 2021-06-08 12:54:34 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
551 | 2021-06-07 07:28:22 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
550 | 2021-06-06 20:44:35 | harry | 1 | 28756 | 12 | 1.000 | 28756.0 |
549 | 2021-06-06 10:27:08 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
548 | 2021-06-05 19:43:54 | harry | 1 | 28756 | 12 | 0.436 | 65954.1 |
547 | 2021-06-05 09:46:41 | harry | 1 | 28756 | 12 | 1.076 | 26724.9 |
546 | 2021-06-04 20:57:44 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
545 | 2021-06-04 06:18:51 | harry | 1 | 28756 | 12 | 1.000 | 28756.0 |
544 | 2021-06-04 02:09:33 | harry | 1 | 28756 | 12 | 0.500 | 57512.0 |
543 | 2021-06-03 19:42:01 | harry | 1 | 28756 | 12 | 0.466 | 61708.2 |