History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fairy"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 732 | 2025-10-27 12:43:35 | fairy | 2 | 53800 | 107 | 1.420 | 37887.3 |
| 731 | 2025-10-14 05:35:08 | fairy | 2 | 53800 | 107 | 1.673 | 32157.8 |
| 730 | 2025-10-10 11:19:18 | fairy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 729 | 2025-10-07 10:34:18 | fairy | 2 | 53800 | 107 | 1.580 | 34050.6 |
| 728 | 2025-10-07 09:09:04 | fairy | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 727 | 2025-10-07 02:42:50 | fairy | 2 | 53800 | 107 | 1.593 | 33772.8 |
| 726 | 2025-10-06 01:40:56 | fairy | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 725 | 2025-09-30 13:36:59 | fairy | 1 | 28756 | 8 | 0.503 | 57169.0 |
| 724 | 2025-09-16 04:58:15 | fairy | 1 | 28756 | 8 | 0.640 | 44931.3 |
| 723 | 2025-09-14 04:17:54 | fairy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 722 | 2025-09-08 13:51:23 | fairy | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 721 | 2025-08-25 13:00:09 | fairy | 1 | 28756 | 8 | 3.720 | 7730.1 |
| 720 | 2025-08-25 10:39:26 | fairy | 1 | 28756 | 8 | 2.750 | 10456.7 |
| 719 | 2025-08-21 15:37:29 | fairy | 1 | 28756 | 8 | 2.326 | 12362.9 |
| 718 | 2025-08-09 21:57:25 | fairy | 1 | 28756 | 8 | 1.266 | 22714.1 |
| 717 | 2025-08-09 01:50:46 | fairy | 1 | 28756 | 8 | 2.750 | 10456.7 |
| 716 | 2025-08-03 21:44:41 | fairy | 2 | 53800 | 107 | 3.813 | 14109.6 |
| 715 | 2025-08-01 22:43:26 | fairy | 2 | 53800 | 107 | 10.856 | 4955.8 |
| 714 | 2025-08-01 04:06:05 | fairy | 1 | 28756 | 8 | 1.156 | 24875.4 |
| 713 | 2025-07-31 02:22:30 | fairy | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 712 | 2025-07-21 21:12:31 | fairy | 1 | 28756 | 8 | 1.140 | 25224.6 |
| 711 | 2025-07-21 08:51:41 | fairy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 710 | 2025-07-11 23:22:13 | fairy | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 709 | 2025-07-10 06:25:02 | fairy | 1 | 28756 | 8 | 1.216 | 23648.0 |
| 708 | 2025-07-09 21:44:04 | fairy | 1 | 28756 | 8 | 3.736 | 7697.0 |
| 707 | 2025-07-07 01:30:52 | fairy | 1 | 28756 | 8 | 2.500 | 11502.4 |
| 706 | 2025-07-06 15:08:54 | fairy | 1 | 28756 | 8 | 2.470 | 11642.1 |
| 705 | 2025-07-02 02:26:24 | fairy | 1 | 28756 | 8 | 3.326 | 8645.8 |
| 704 | 2025-06-30 21:52:20 | fairy | 1 | 28756 | 8 | 0.533 | 53951.2 |
| 703 | 2025-06-21 14:03:33 | fairy | 1 | 28756 | 8 | 3.000 | 9585.3 |
| 702 | 2025-06-21 05:01:57 | fairy | 1 | 28756 | 8 | 2.720 | 10572.1 |
| 701 | 2025-06-13 03:50:24 | fairy | 1 | 28756 | 8 | 0.936 | 30722.2 |
| 700 | 2025-06-10 04:28:49 | fairy | 1 | 28756 | 8 | 1.080 | 26625.9 |
| 699 | 2025-06-07 21:01:32 | fairy | 2 | 53800 | 107 | 8.173 | 6582.7 |
| 698 | 2025-06-07 00:48:21 | fairy | 1 | 28756 | 8 | 2.046 | 14054.7 |
| 697 | 2025-06-05 19:53:33 | fairy | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 696 | 2025-06-02 01:55:58 | fairy | 1 | 28756 | 8 | 2.313 | 12432.3 |
| 695 | 2025-06-01 01:28:26 | fairy | 1 | 28756 | 8 | 2.296 | 12524.4 |
| 694 | 2025-05-29 18:58:28 | fairy | 2 | 53800 | 107 | 1.563 | 34421.0 |
| 693 | 2025-05-27 13:00:28 | fairy | 1 | 28756 | 8 | 1.203 | 23903.6 |
| 692 | 2025-05-18 15:20:03 | fairy | 1 | 28756 | 8 | 3.670 | 7835.4 |
| 691 | 2025-05-17 00:39:41 | fairy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 690 | 2025-05-15 17:44:22 | fairy | 1 | 28756 | 8 | 0.513 | 56054.6 |
| 689 | 2025-05-11 18:10:01 | fairy | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 688 | 2025-05-11 16:59:48 | fairy | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 687 | 2025-05-10 04:39:44 | fairy | 1 | 28756 | 8 | 1.296 | 22188.3 |
| 686 | 2025-05-09 19:35:35 | fairy | 1 | 28756 | 8 | 2.516 | 11429.3 |
| 685 | 2025-05-07 00:20:40 | fairy | 1 | 28756 | 8 | 1.580 | 18200.0 |
| 684 | 2025-05-04 23:29:29 | fairy | 2 | 53800 | 107 | 2.500 | 21520.0 |
| 683 | 2025-05-04 07:53:35 | fairy | 1 | 28756 | 8 | 2.420 | 11882.6 |
| 682 | 2025-05-02 19:44:55 | fairy | 2 | 53800 | 107 | 1.686 | 31909.8 |
| 681 | 2025-05-02 01:41:51 | fairy | 1 | 28756 | 8 | 2.593 | 11089.9 |
| 680 | 2025-05-02 01:19:17 | fairy | 2 | 53800 | 107 | 5.813 | 9255.1 |
| 679 | 2025-05-01 20:45:24 | fairy | 2 | 53800 | 107 | 8.233 | 6534.7 |
| 678 | 2025-05-01 10:33:44 | fairy | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 677 | 2025-04-30 21:07:46 | fairy | 2 | 53800 | 107 | 4.406 | 12210.6 |
| 676 | 2025-04-14 12:49:01 | fairy | 1 | 28756 | 8 | 4.576 | 6284.1 |
| 675 | 2025-04-13 06:10:29 | fairy | 2 | 53800 | 107 | 1.750 | 30742.9 |
| 674 | 2025-04-09 04:34:17 | fairy | 1 | 28756 | 8 | 3.576 | 8041.4 |
| 673 | 2025-04-07 00:11:05 | fairy | 1 | 28756 | 8 | 2.296 | 12524.4 |
| 672 | 2025-04-06 21:56:22 | fairy | 1 | 28756 | 8 | 3.893 | 7386.6 |
| 671 | 2025-04-03 13:19:13 | fairy | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 670 | 2025-04-01 17:26:02 | fairy | 2 | 53800 | 107 | 3.000 | 17933.3 |
| 669 | 2025-03-15 16:24:09 | fairy | 1 | 28756 | 8 | 1.186 | 24246.2 |
| 668 | 2025-03-15 10:30:01 | fairy | 2 | 53800 | 107 | 11.796 | 4560.9 |
| 667 | 2025-03-15 10:25:00 | fairy | 1 | 28756 | 8 | 3.406 | 8442.7 |
| 666 | 2025-03-09 09:53:42 | fairy | 1 | 28756 | 8 | 1.610 | 17860.9 |
| 665 | 2025-03-07 16:19:22 | fairy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 664 | 2025-03-05 03:24:57 | fairy | 2 | 53800 | 107 | 6.593 | 8160.2 |
| 663 | 2025-03-05 03:24:23 | fairy | 1 | 28756 | 8 | 3.670 | 7835.4 |
| 662 | 2025-03-03 21:41:25 | fairy | 1 | 28756 | 8 | 0.953 | 30174.2 |
| 661 | 2025-02-27 08:13:58 | fairy | 2 | 53800 | 107 | 8.453 | 6364.6 |
| 660 | 2025-02-27 07:14:46 | fairy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 659 | 2025-02-24 02:43:16 | fairy | 2 | 53800 | 107 | 8.173 | 6582.7 |
| 658 | 2025-02-10 17:07:49 | fairy | 2 | 53800 | 107 | 6.673 | 8062.3 |
| 657 | 2025-02-09 13:45:21 | fairy | 2 | 53800 | 107 | 8.500 | 6329.4 |
| 656 | 2025-02-09 11:24:09 | fairy | 2 | 53800 | 107 | 8.453 | 6364.6 |
| 655 | 2025-02-07 17:18:38 | fairy | 1 | 28756 | 8 | 1.203 | 23903.6 |
| 654 | 2025-02-01 00:43:15 | fairy | 2 | 53800 | 107 | 4.186 | 12852.4 |
| 653 | 2025-02-01 00:34:03 | fairy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 652 | 2025-01-27 16:44:41 | fairy | 2 | 53800 | 107 | 8.140 | 6609.3 |
| 651 | 2025-01-26 18:41:52 | fairy | 2 | 53800 | 107 | 8.203 | 6558.6 |
| 650 | 2025-01-26 18:33:03 | fairy | 1 | 28756 | 8 | 1.080 | 26625.9 |
| 649 | 2025-01-25 08:51:40 | fairy | 1 | 28756 | 8 | 2.920 | 9847.9 |
| 648 | 2025-01-01 18:18:29 | fairy | 2 | 53800 | 107 | 11.563 | 4652.8 |
| 647 | 2025-01-01 18:08:11 | fairy | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 646 | 2024-12-27 15:03:51 | fairy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 645 | 2024-12-02 08:35:03 | fairy | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 644 | 2024-11-27 17:16:01 | fairy | 2 | 53800 | 107 | 4.516 | 11913.2 |
| 643 | 2024-11-27 16:04:46 | fairy | 2 | 53800 | 107 | 9.516 | 5653.6 |
| 642 | 2024-11-27 15:06:06 | fairy | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 641 | 2024-11-26 05:31:14 | fairy | 1 | 28756 | 8 | 2.936 | 9794.3 |
| 640 | 2024-11-07 05:05:37 | fairy | 1 | 28756 | 8 | 1.670 | 17219.2 |
| 639 | 2024-11-01 05:07:54 | fairy | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 638 | 2024-10-28 07:50:08 | fairy | 2 | 53800 | 107 | 11.500 | 4678.3 |
| 637 | 2024-10-28 07:33:33 | fairy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 636 | 2024-10-27 04:42:28 | fairy | 1 | 28756 | 8 | 1.420 | 20250.7 |
| 635 | 2024-10-15 21:57:38 | fairy | 2 | 53800 | 107 | 7.953 | 6764.7 |
| 634 | 2024-10-11 20:56:03 | fairy | 1 | 28756 | 8 | 2.390 | 12031.8 |
| 633 | 2024-10-01 20:48:35 | fairy | 1 | 28756 | 8 | 3.593 | 8003.3 |