History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shear"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
645 | 2024-04-19 03:30:52 | shear | 1 | 28756 | 13 | 0.533 | 53951.2 |
644 | 2024-04-06 17:14:33 | shear | 2 | 53800 | 150 | 3.686 | 14595.8 |
643 | 2024-04-03 06:40:50 | shear | 1 | 28756 | 13 | 0.750 | 38341.3 |
642 | 2024-03-31 08:11:39 | shear | 1 | 28756 | 13 | 0.580 | 49579.3 |
641 | 2024-03-31 07:50:22 | shear | 1 | 28756 | 13 | 0.580 | 49579.3 |
640 | 2024-03-27 06:20:44 | shear | 1 | 28756 | 13 | 0.516 | 55728.7 |
639 | 2024-03-04 02:27:50 | shear | 2 | 53800 | 150 | 3.640 | 14780.2 |
638 | 2024-03-04 02:19:59 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
637 | 2024-03-01 07:52:36 | shear | 1 | 28756 | 13 | 0.550 | 52283.6 |
636 | 2024-02-25 22:19:08 | shear | 2 | 53800 | 150 | 1.876 | 28678.0 |
635 | 2024-02-25 22:15:38 | shear | 1 | 28756 | 13 | 1.170 | 24577.8 |
634 | 2024-02-09 04:11:11 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
633 | 2024-02-03 00:07:43 | shear | 1 | 28756 | 13 | 0.983 | 29253.3 |
632 | 2024-01-31 10:21:29 | shear | 1 | 28756 | 13 | 1.076 | 26724.9 |
631 | 2024-01-29 04:22:57 | shear | 1 | 28756 | 13 | 0.470 | 61183.0 |
630 | 2024-01-28 17:26:23 | shear | 1 | 28756 | 13 | 0.466 | 61708.2 |
629 | 2024-01-26 18:59:45 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
628 | 2023-12-24 18:18:36 | shear | 2 | 53800 | 150 | 1.576 | 34137.1 |
627 | 2023-12-19 21:58:14 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
626 | 2023-12-07 01:51:14 | shear | 1 | 28756 | 13 | 0.436 | 65954.1 |
625 | 2023-12-07 01:51:13 | shear | 1 | 28756 | 13 | 0.486 | 59168.7 |
624 | 2023-12-05 01:24:48 | shear | 2 | 53800 | 150 | 1.546 | 34799.5 |
623 | 2023-12-02 08:03:27 | shear | 2 | 53800 | 150 | 1.343 | 40059.6 |
622 | 2023-11-30 18:12:51 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
621 | 2023-11-19 02:04:21 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
620 | 2023-11-12 08:30:52 | shear | 1 | 28756 | 13 | 0.486 | 59168.7 |
619 | 2023-11-12 01:17:46 | shear | 1 | 28756 | 13 | 0.470 | 61183.0 |
618 | 2023-10-27 21:06:36 | shear | 1 | 28756 | 13 | 0.656 | 43835.4 |
617 | 2023-10-24 03:58:30 | shear | 1 | 28756 | 13 | 1.076 | 26724.9 |
616 | 2023-10-20 14:21:10 | shear | 1 | 28756 | 13 | 0.576 | 49923.6 |
615 | 2023-10-11 11:54:56 | shear | 1 | 28756 | 13 | 0.656 | 43835.4 |
614 | 2023-10-09 04:59:39 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
613 | 2023-10-05 04:20:31 | shear | 1 | 28756 | 13 | 0.440 | 65354.5 |
612 | 2023-09-26 02:08:36 | shear | 1 | 28756 | 13 | 0.513 | 56054.6 |
611 | 2023-09-25 15:04:39 | shear | 1 | 28756 | 13 | 0.436 | 65954.1 |
610 | 2023-09-14 18:44:24 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
609 | 2023-09-02 20:57:52 | shear | 2 | 53800 | 150 | 1.626 | 33087.3 |
608 | 2023-07-03 06:13:28 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
607 | 2023-06-18 23:51:20 | shear | 1 | 28756 | 13 | 0.486 | 59168.7 |
606 | 2023-05-23 10:15:48 | shear | 2 | 53800 | 150 | 1.376 | 39098.8 |
605 | 2023-04-11 22:33:33 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
604 | 2023-03-03 05:17:50 | shear | 2 | 53800 | 150 | 1.466 | 36698.5 |
603 | 2023-02-27 21:38:45 | shear | 1 | 28756 | 13 | 0.436 | 65954.1 |
602 | 2023-02-05 01:34:38 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
601 | 2022-12-09 15:38:09 | shear | 2 | 53800 | 150 | 1.356 | 39675.5 |
600 | 2022-12-02 17:00:48 | shear | 1 | 28756 | 13 | 0.436 | 65954.1 |
599 | 2022-11-07 13:37:44 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
598 | 2022-07-28 22:50:21 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
597 | 2022-07-19 04:31:35 | shear | 2 | 53800 | 150 | 1.593 | 33772.8 |
596 | 2022-07-18 03:22:54 | shear | 1 | 28756 | 13 | 0.436 | 65954.1 |
595 | 2022-07-17 06:55:20 | shear | 2 | 53800 | 150 | 1.390 | 38705.0 |
594 | 2022-03-31 01:13:54 | shear | 1 | 28756 | 13 | 0.513 | 56054.6 |
593 | 2022-03-25 18:03:59 | shear | 1 | 28756 | 13 | 0.516 | 55728.7 |
592 | 2022-02-21 07:24:37 | shear | 2 | 53800 | 150 | 1.406 | 38264.6 |
591 | 2022-02-10 17:31:47 | shear | 1 | 28756 | 13 | 0.546 | 52666.7 |
590 | 2022-02-10 00:22:27 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
589 | 2022-02-09 12:23:58 | shear | 1 | 28756 | 13 | 0.530 | 54256.6 |
588 | 2022-02-08 20:07:52 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
587 | 2022-02-08 09:29:00 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
586 | 2022-02-07 14:40:21 | shear | 1 | 28756 | 13 | 0.530 | 54256.6 |
585 | 2022-02-06 21:24:02 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
584 | 2022-02-06 11:26:24 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
583 | 2022-02-05 14:37:47 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
582 | 2022-02-04 18:25:22 | shear | 1 | 28756 | 13 | 0.450 | 63902.2 |
581 | 2022-02-04 04:20:23 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
580 | 2022-02-03 16:48:01 | shear | 1 | 28756 | 13 | 0.560 | 51350.0 |
579 | 2022-02-03 05:27:30 | shear | 1 | 28756 | 13 | 0.470 | 61183.0 |
578 | 2022-02-02 22:32:31 | shear | 1 | 28756 | 13 | 0.470 | 61183.0 |
577 | 2022-02-02 07:24:35 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
576 | 2022-02-01 22:57:15 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
575 | 2022-02-01 13:21:22 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
574 | 2022-02-01 02:31:09 | shear | 1 | 28756 | 13 | 0.516 | 55728.7 |
573 | 2022-01-31 10:52:51 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
572 | 2022-01-30 21:21:46 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
571 | 2022-01-30 08:00:07 | shear | 1 | 28756 | 13 | 0.470 | 61183.0 |
570 | 2022-01-29 15:24:53 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
569 | 2021-12-29 11:24:49 | shear | 1 | 28756 | 13 | 0.530 | 54256.6 |
568 | 2021-12-19 19:16:00 | shear | 1 | 28756 | 13 | 0.513 | 56054.6 |
567 | 2021-12-17 12:10:39 | shear | 1 | 28756 | 13 | 0.516 | 55728.7 |
566 | 2021-12-16 16:49:53 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
565 | 2021-12-15 17:59:12 | shear | 1 | 28756 | 13 | 1.016 | 28303.1 |
564 | 2021-12-14 05:29:56 | shear | 1 | 28756 | 13 | 0.546 | 52666.7 |
563 | 2021-12-13 19:50:36 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
562 | 2021-12-13 08:19:06 | shear | 1 | 28756 | 13 | 0.470 | 61183.0 |
561 | 2021-12-12 17:13:56 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
560 | 2021-12-12 07:16:57 | shear | 1 | 28756 | 13 | 1.000 | 28756.0 |
559 | 2021-12-07 23:44:56 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
558 | 2021-12-07 14:28:57 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
557 | 2021-12-07 02:54:41 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
556 | 2021-12-06 17:57:42 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
555 | 2021-12-06 03:48:20 | shear | 1 | 28756 | 13 | 0.440 | 65354.5 |
554 | 2021-12-05 17:51:12 | shear | 1 | 28756 | 13 | 0.530 | 54256.6 |
553 | 2021-11-23 17:30:45 | shear | 2 | 53800 | 150 | 1.390 | 38705.0 |
552 | 2021-11-05 05:44:32 | shear | 1 | 28756 | 13 | 0.453 | 63479.0 |
551 | 2021-10-26 20:26:28 | shear | 1 | 28756 | 13 | 0.516 | 55728.7 |
550 | 2021-10-26 10:52:01 | shear | 1 | 28756 | 13 | 0.516 | 55728.7 |
549 | 2021-10-25 15:04:14 | shear | 1 | 28756 | 13 | 0.483 | 59536.2 |
548 | 2021-10-25 04:58:45 | shear | 1 | 28756 | 13 | 0.500 | 57512.0 |
547 | 2021-10-24 21:00:09 | shear | 1 | 28756 | 13 | 0.533 | 53951.2 |
546 | 2021-10-24 10:57:14 | shear | 1 | 28756 | 13 | 0.550 | 52283.6 |