History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"flier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
657 | 2024-05-04 23:33:14 | flier | 1 | 28756 | 12 | 1.686 | 17055.8 |
656 | 2024-04-30 16:11:11 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
655 | 2024-04-29 10:29:51 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
654 | 2024-04-29 08:26:47 | flier | 1 | 28756 | 12 | 0.530 | 54256.6 |
653 | 2024-04-29 08:26:39 | flier | 2 | 53800 | 191 | 1.640 | 32804.9 |
652 | 2024-04-29 05:04:48 | flier | 2 | 53800 | 191 | 1.720 | 31279.1 |
651 | 2024-04-27 07:48:06 | flier | 1 | 28756 | 12 | 0.470 | 61183.0 |
650 | 2024-04-26 19:16:31 | flier | 1 | 28756 | 12 | 0.563 | 51076.4 |
649 | 2024-04-25 14:19:59 | flier | 1 | 28756 | 12 | 0.546 | 52666.7 |
648 | 2024-04-20 05:07:51 | flier | 1 | 28756 | 12 | 0.686 | 41918.4 |
647 | 2024-04-02 22:40:59 | flier | 2 | 53800 | 191 | 4.156 | 12945.1 |
646 | 2024-04-02 21:09:27 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
645 | 2024-03-31 14:50:20 | flier | 2 | 53800 | 191 | 1.890 | 28465.6 |
644 | 2024-03-31 14:42:25 | flier | 1 | 28756 | 12 | 1.076 | 26724.9 |
643 | 2024-03-30 01:31:12 | flier | 2 | 53800 | 191 | 3.000 | 17933.3 |
642 | 2024-03-29 07:17:33 | flier | 2 | 53800 | 191 | 5.343 | 10069.2 |
641 | 2024-03-29 01:23:34 | flier | 2 | 53800 | 191 | 4.936 | 10899.5 |
640 | 2024-03-29 01:12:43 | flier | 1 | 28756 | 12 | 0.673 | 42728.1 |
639 | 2024-03-01 07:06:44 | flier | 1 | 28756 | 12 | 0.533 | 53951.2 |
638 | 2024-02-29 14:14:30 | flier | 1 | 28756 | 12 | 0.546 | 52666.7 |
637 | 2024-02-27 19:41:28 | flier | 1 | 28756 | 12 | 0.483 | 59536.2 |
636 | 2024-02-12 22:14:31 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |
635 | 2024-01-28 18:57:01 | flier | 1 | 28756 | 12 | 0.530 | 54256.6 |
634 | 2024-01-21 17:39:16 | flier | 2 | 53800 | 191 | 1.486 | 36204.6 |
633 | 2024-01-14 19:26:58 | flier | 2 | 53800 | 191 | 1.393 | 38621.7 |
632 | 2024-01-12 08:10:50 | flier | 2 | 53800 | 191 | 1.533 | 35094.6 |
631 | 2023-12-23 00:33:05 | flier | 1 | 28756 | 12 | 0.453 | 63479.0 |
630 | 2023-12-14 22:37:28 | flier | 2 | 53800 | 191 | 1.533 | 35094.6 |
629 | 2023-12-09 03:39:01 | flier | 1 | 28756 | 12 | 0.440 | 65354.5 |
628 | 2023-11-22 02:52:36 | flier | 1 | 28756 | 12 | 0.516 | 55728.7 |
627 | 2023-11-18 00:23:56 | flier | 1 | 28756 | 12 | 0.530 | 54256.6 |
626 | 2023-11-17 03:10:02 | flier | 2 | 53800 | 191 | 1.530 | 35163.4 |
625 | 2023-11-11 08:39:37 | flier | 1 | 28756 | 12 | 0.483 | 59536.2 |
624 | 2023-11-01 20:43:16 | flier | 1 | 28756 | 12 | 0.530 | 54256.6 |
623 | 2023-10-28 13:20:39 | flier | 1 | 28756 | 12 | 0.530 | 54256.6 |
622 | 2023-10-25 06:30:59 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
621 | 2023-10-20 17:22:14 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
620 | 2023-10-17 16:00:21 | flier | 1 | 28756 | 12 | 1.030 | 27918.4 |
619 | 2023-10-13 14:48:33 | flier | 1 | 28756 | 12 | 0.483 | 59536.2 |
618 | 2023-10-05 02:53:10 | flier | 1 | 28756 | 12 | 0.483 | 59536.2 |
617 | 2023-10-03 02:40:45 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |
616 | 2023-09-23 09:15:21 | flier | 1 | 28756 | 12 | 0.546 | 52666.7 |
615 | 2023-09-22 22:40:51 | flier | 1 | 28756 | 12 | 0.420 | 68466.7 |
614 | 2023-09-22 18:27:57 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |
613 | 2023-08-14 18:09:25 | flier | 1 | 28756 | 12 | 0.440 | 65354.5 |
612 | 2023-07-20 01:27:51 | flier | 1 | 28756 | 12 | 0.470 | 61183.0 |
611 | 2023-07-19 22:49:24 | flier | 1 | 28756 | 12 | 0.986 | 29164.3 |
610 | 2023-04-25 01:51:17 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
609 | 2023-04-12 01:11:31 | flier | 1 | 28756 | 12 | 0.420 | 68466.7 |
608 | 2023-02-14 21:42:40 | flier | 1 | 28756 | 12 | 0.453 | 63479.0 |
607 | 2023-01-06 23:12:56 | flier | 1 | 28756 | 12 | 0.486 | 59168.7 |
606 | 2022-12-12 22:01:30 | flier | 1 | 28756 | 12 | 0.423 | 67981.1 |
605 | 2022-11-26 03:44:20 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
604 | 2022-09-30 10:15:39 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |
603 | 2022-09-07 19:32:38 | flier | 2 | 53800 | 191 | 1.326 | 40573.2 |
602 | 2022-09-01 20:26:44 | flier | 2 | 53800 | 191 | 1.373 | 39184.3 |
601 | 2022-08-18 20:09:52 | flier | 1 | 28756 | 12 | 0.423 | 67981.1 |
600 | 2022-08-16 10:07:58 | flier | 1 | 28756 | 12 | 0.440 | 65354.5 |
599 | 2022-08-15 01:37:02 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |
598 | 2022-08-01 12:26:09 | flier | 1 | 28756 | 12 | 0.470 | 61183.0 |
597 | 2022-07-29 09:40:56 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |
596 | 2022-06-17 03:32:07 | flier | 1 | 28756 | 12 | 0.423 | 67981.1 |
595 | 2022-04-07 06:36:11 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |
594 | 2022-04-05 03:38:15 | flier | 1 | 28756 | 12 | 0.483 | 59536.2 |
593 | 2022-03-05 03:44:54 | flier | 1 | 28756 | 12 | 0.423 | 67981.1 |
592 | 2022-01-21 12:41:36 | flier | 1 | 28756 | 12 | 0.483 | 59536.2 |
591 | 2022-01-20 10:59:32 | flier | 1 | 28756 | 12 | 0.423 | 67981.1 |
590 | 2022-01-19 17:31:41 | flier | 1 | 28756 | 12 | 0.560 | 51350.0 |
589 | 2022-01-18 17:52:31 | flier | 1 | 28756 | 12 | 0.470 | 61183.0 |
588 | 2022-01-13 07:14:01 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
587 | 2022-01-12 07:23:56 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |
586 | 2022-01-11 10:59:11 | flier | 1 | 28756 | 12 | 0.516 | 55728.7 |
585 | 2022-01-10 12:37:52 | flier | 1 | 28756 | 12 | 0.626 | 45936.1 |
584 | 2022-01-05 20:06:48 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
583 | 2022-01-02 15:16:02 | flier | 1 | 28756 | 12 | 0.483 | 59536.2 |
582 | 2022-01-02 10:46:58 | flier | 1 | 28756 | 12 | 0.560 | 51350.0 |
581 | 2022-01-02 06:26:32 | flier | 1 | 28756 | 12 | 0.453 | 63479.0 |
580 | 2022-01-01 11:33:33 | flier | 1 | 28756 | 12 | 0.470 | 61183.0 |
579 | 2021-12-31 17:43:31 | flier | 1 | 28756 | 12 | 0.530 | 54256.6 |
578 | 2021-12-31 07:02:32 | flier | 1 | 28756 | 12 | 0.470 | 61183.0 |
577 | 2021-12-30 13:30:06 | flier | 1 | 28756 | 12 | 0.466 | 61708.2 |
576 | 2021-12-29 23:02:58 | flier | 1 | 28756 | 12 | 0.500 | 57512.0 |
575 | 2021-12-29 12:12:08 | flier | 1 | 28756 | 12 | 0.453 | 63479.0 |
574 | 2021-12-29 03:16:55 | flier | 1 | 28756 | 12 | 0.453 | 63479.0 |
573 | 2021-12-28 11:34:05 | flier | 1 | 28756 | 12 | 0.516 | 55728.7 |
572 | 2021-12-27 15:23:30 | flier | 1 | 28756 | 12 | 0.466 | 61708.2 |
571 | 2021-12-26 22:35:37 | flier | 1 | 28756 | 12 | 0.516 | 55728.7 |
570 | 2021-12-26 11:49:54 | flier | 1 | 28756 | 12 | 0.516 | 55728.7 |
569 | 2021-12-26 03:01:34 | flier | 1 | 28756 | 12 | 0.453 | 63479.0 |
568 | 2021-12-25 10:45:07 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |
567 | 2021-12-24 22:03:03 | flier | 1 | 28756 | 12 | 0.516 | 55728.7 |
566 | 2021-12-24 08:20:06 | flier | 1 | 28756 | 12 | 0.533 | 53951.2 |
565 | 2021-12-24 01:09:38 | flier | 1 | 28756 | 12 | 0.483 | 59536.2 |
564 | 2021-12-19 10:17:31 | flier | 1 | 28756 | 12 | 0.423 | 67981.1 |
563 | 2021-12-19 01:27:50 | flier | 1 | 28756 | 12 | 1.060 | 27128.3 |
562 | 2021-12-18 16:34:56 | flier | 1 | 28756 | 12 | 0.483 | 59536.2 |
561 | 2021-12-17 22:20:17 | flier | 1 | 28756 | 12 | 0.530 | 54256.6 |
560 | 2021-12-02 22:20:54 | flier | 1 | 28756 | 12 | 0.546 | 52666.7 |
559 | 2021-12-01 23:35:06 | flier | 1 | 28756 | 12 | 0.453 | 63479.0 |
558 | 2021-12-01 14:41:29 | flier | 1 | 28756 | 12 | 0.436 | 65954.1 |