History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"alpha"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 694 | 2024-04-19 07:10:22 | alpha | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 693 | 2024-04-11 00:16:38 | alpha | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 692 | 2024-04-10 21:03:39 | alpha | 3 | 83667 | 456 | 10.046 | 8328.4 |
| 691 | 2024-04-09 21:11:33 | alpha | 3 | 83667 | 456 | 11.533 | 7254.6 |
| 690 | 2024-04-09 12:16:07 | alpha | 3 | 83667 | 456 | 21.483 | 3894.6 |
| 689 | 2024-04-09 12:15:01 | alpha | 3 | 83667 | 456 | 16.470 | 5080.0 |
| 688 | 2024-04-06 05:37:41 | alpha | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 687 | 2024-03-31 15:09:25 | alpha | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 686 | 2024-03-29 08:45:47 | alpha | 2 | 53800 | 30 | 3.656 | 14715.5 |
| 685 | 2024-03-29 08:45:45 | alpha | 3 | 83667 | 456 | 4.593 | 18216.2 |
| 684 | 2024-03-29 08:45:37 | alpha | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 683 | 2024-03-29 08:45:15 | alpha | 3 | 83667 | 456 | 6.736 | 12420.9 |
| 682 | 2024-03-29 08:22:46 | alpha | 1 | 28756 | 3 | 0.576 | 49923.6 |
| 681 | 2024-03-29 03:34:05 | alpha | 3 | 83667 | 456 | 8.110 | 10316.5 |
| 680 | 2024-03-07 03:50:56 | alpha | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 679 | 2024-03-01 12:15:20 | alpha | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 678 | 2024-02-28 02:51:07 | alpha | 1 | 28756 | 3 | 1.046 | 27491.4 |
| 677 | 2024-02-20 17:28:39 | alpha | 1 | 28756 | 3 | 1.200 | 23963.3 |
| 676 | 2024-02-03 23:07:43 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 675 | 2024-01-29 04:04:19 | alpha | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 674 | 2024-01-29 02:42:05 | alpha | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 673 | 2024-01-23 21:30:36 | alpha | 3 | 83667 | 456 | 3.750 | 22311.2 |
| 672 | 2024-01-12 04:55:12 | alpha | 3 | 83667 | 456 | 3.703 | 22594.4 |
| 671 | 2024-01-12 04:55:13 | alpha | 2 | 53800 | 30 | 1.686 | 31909.8 |
| 670 | 2024-01-09 15:50:33 | alpha | 2 | 53800 | 30 | 1.420 | 37887.3 |
| 669 | 2024-01-08 07:41:53 | alpha | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 668 | 2023-12-26 19:07:08 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 667 | 2023-12-22 20:23:01 | alpha | 3 | 83667 | 456 | 3.983 | 21006.0 |
| 666 | 2023-12-22 20:23:02 | alpha | 2 | 53800 | 30 | 1.716 | 31352.0 |
| 665 | 2023-12-11 06:40:29 | alpha | 3 | 83667 | 456 | 4.123 | 20292.7 |
| 664 | 2023-11-30 18:04:55 | alpha | 3 | 83667 | 456 | 3.360 | 24900.9 |
| 663 | 2023-11-30 18:04:53 | alpha | 2 | 53800 | 30 | 1.390 | 38705.0 |
| 662 | 2023-11-26 03:47:01 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 661 | 2023-11-17 05:24:16 | alpha | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 660 | 2023-11-12 08:15:51 | alpha | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 659 | 2023-11-03 10:37:03 | alpha | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 658 | 2023-10-29 20:15:18 | alpha | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 657 | 2023-10-22 03:45:38 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 656 | 2023-10-20 07:50:08 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 655 | 2023-10-18 02:54:06 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 654 | 2023-10-13 07:10:05 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 653 | 2023-10-05 19:13:02 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 652 | 2023-09-26 07:41:09 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 651 | 2023-09-15 22:29:49 | alpha | 2 | 53800 | 30 | 1.610 | 33416.1 |
| 650 | 2023-09-15 12:00:51 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 649 | 2023-09-10 15:45:33 | alpha | 3 | 83667 | 456 | 3.440 | 24321.8 |
| 648 | 2023-09-08 22:56:33 | alpha | 3 | 83667 | 456 | 3.750 | 22311.2 |
| 647 | 2023-09-02 13:35:03 | alpha | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 646 | 2023-08-13 19:01:21 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 645 | 2023-07-21 09:39:35 | alpha | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 644 | 2023-07-16 07:44:45 | alpha | 3 | 83667 | 456 | 3.406 | 24564.6 |
| 643 | 2023-06-30 04:55:27 | alpha | 2 | 53800 | 30 | 1.626 | 33087.3 |
| 642 | 2023-05-28 02:12:35 | alpha | 3 | 83667 | 456 | 3.500 | 23904.9 |
| 641 | 2023-05-23 16:34:04 | alpha | 3 | 83667 | 456 | 3.280 | 25508.2 |
| 640 | 2023-05-20 11:56:08 | alpha | 3 | 83667 | 456 | 3.530 | 23701.7 |
| 639 | 2023-05-15 12:44:04 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 638 | 2023-04-17 19:46:16 | alpha | 3 | 83667 | 456 | 3.953 | 21165.4 |
| 637 | 2023-04-13 13:24:09 | alpha | 3 | 83667 | 456 | 4.170 | 20064.0 |
| 636 | 2023-04-13 10:04:56 | alpha | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 635 | 2023-04-12 19:09:47 | alpha | 3 | 83667 | 456 | 4.033 | 20745.6 |
| 634 | 2023-04-10 04:13:50 | alpha | 3 | 83667 | 456 | 3.393 | 24658.7 |
| 633 | 2023-04-06 07:05:58 | alpha | 3 | 83667 | 456 | 7.533 | 11106.7 |
| 632 | 2023-04-05 08:11:38 | alpha | 3 | 83667 | 456 | 3.920 | 21343.6 |
| 631 | 2023-04-04 21:14:11 | alpha | 3 | 83667 | 456 | 3.983 | 21006.0 |
| 630 | 2023-04-02 11:05:50 | alpha | 3 | 83667 | 456 | 3.330 | 25125.2 |
| 629 | 2023-03-31 14:55:58 | alpha | 3 | 83667 | 456 | 3.970 | 21074.8 |
| 628 | 2023-03-31 14:14:43 | alpha | 2 | 53800 | 30 | 1.626 | 33087.3 |
| 627 | 2023-03-27 00:24:55 | alpha | 1 | 28756 | 3 | 0.503 | 57169.0 |
| 626 | 2023-03-11 06:01:51 | alpha | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 625 | 2023-03-08 07:29:31 | alpha | 3 | 83667 | 456 | 3.813 | 21942.6 |
| 624 | 2022-12-31 20:50:48 | alpha | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 623 | 2022-12-30 07:48:38 | alpha | 1 | 28756 | 3 | 0.450 | 63902.2 |
| 622 | 2022-12-25 18:00:27 | alpha | 2 | 53800 | 30 | 1.576 | 34137.1 |
| 621 | 2022-12-19 07:50:28 | alpha | 3 | 83667 | 456 | 3.313 | 25254.2 |
| 620 | 2022-12-14 07:19:51 | alpha | 3 | 83667 | 456 | 3.343 | 25027.5 |
| 619 | 2022-11-06 04:55:06 | alpha | 3 | 83667 | 456 | 3.843 | 21771.3 |
| 618 | 2022-11-05 16:51:16 | alpha | 3 | 83667 | 456 | 3.466 | 24139.4 |
| 617 | 2022-11-04 22:39:41 | alpha | 3 | 83667 | 456 | 3.280 | 25508.2 |
| 616 | 2022-10-30 04:43:46 | alpha | 2 | 53800 | 30 | 3.313 | 16239.1 |
| 615 | 2022-10-30 03:33:57 | alpha | 2 | 53800 | 30 | 1.390 | 38705.0 |
| 614 | 2022-10-10 16:21:41 | alpha | 3 | 83667 | 456 | 3.296 | 25384.4 |
| 613 | 2022-09-20 15:04:13 | alpha | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 612 | 2022-09-13 19:05:23 | alpha | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 611 | 2022-09-04 20:13:51 | alpha | 3 | 83667 | 456 | 3.423 | 24442.6 |
| 610 | 2022-09-02 03:14:41 | alpha | 3 | 83667 | 456 | 4.050 | 20658.5 |
| 609 | 2022-09-02 00:34:20 | alpha | 3 | 83667 | 456 | 3.516 | 23796.1 |
| 608 | 2022-08-31 12:44:17 | alpha | 3 | 83667 | 456 | 3.796 | 22040.8 |
| 607 | 2022-08-27 23:12:46 | alpha | 3 | 83667 | 456 | 3.346 | 25005.1 |
| 606 | 2022-08-26 21:14:43 | alpha | 3 | 83667 | 456 | 3.326 | 25155.4 |
| 605 | 2022-08-25 21:32:32 | alpha | 3 | 83667 | 456 | 3.453 | 24230.2 |
| 604 | 2022-08-05 16:54:03 | alpha | 3 | 83667 | 456 | 3.326 | 25155.4 |
| 603 | 2022-06-13 00:04:01 | alpha | 3 | 83667 | 456 | 4.076 | 20526.7 |
| 602 | 2022-05-25 11:11:12 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 601 | 2022-05-07 12:01:30 | alpha | 3 | 83667 | 456 | 3.343 | 25027.5 |
| 600 | 2022-05-01 22:45:26 | alpha | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 599 | 2022-04-29 18:03:13 | alpha | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 598 | 2022-03-07 01:06:33 | alpha | 3 | 83667 | 456 | 3.343 | 25027.5 |
| 597 | 2022-03-06 01:29:59 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 596 | 2022-02-13 20:38:07 | alpha | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 595 | 2022-01-16 16:43:29 | alpha | 1 | 28756 | 3 | 0.546 | 52666.7 |