History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sapphire"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 724 | 2024-05-21 15:21:28 | sapphire | 4 | 161609 | 533 | 15.830 | 10209.0 |
| 723 | 2024-05-11 19:30:46 | sapphire | 1 | 82945 | 3 | 5.046 | 16437.8 |
| 722 | 2024-05-11 19:30:31 | sapphire | 3 | 146162 | 47 | 18.346 | 7967.0 |
| 721 | 2024-05-11 19:30:28 | sapphire | 2 | 121059 | 11 | 13.143 | 9210.9 |
| 720 | 2024-05-11 09:51:41 | sapphire | 3 | 146162 | 47 | 26.550 | 5505.2 |
| 719 | 2024-05-11 09:51:43 | sapphire | 2 | 121059 | 11 | 8.890 | 13617.4 |
| 718 | 2024-05-11 09:51:29 | sapphire | 1 | 82945 | 3 | 4.986 | 16635.6 |
| 717 | 2024-05-01 17:01:33 | sapphire | 2 | 121059 | 11 | 4.343 | 27874.5 |
| 716 | 2024-05-01 17:00:49 | sapphire | 1 | 82945 | 3 | 6.923 | 11981.1 |
| 715 | 2024-05-01 13:05:54 | sapphire | 3 | 146162 | 47 | 17.750 | 8234.5 |
| 714 | 2024-05-01 12:26:46 | sapphire | 2 | 121059 | 11 | 4.906 | 24675.7 |
| 713 | 2024-04-30 23:52:14 | sapphire | 3 | 146162 | 47 | 8.063 | 18127.5 |
| 712 | 2024-04-30 23:52:09 | sapphire | 2 | 121059 | 11 | 3.733 | 32429.4 |
| 711 | 2024-04-30 09:13:43 | sapphire | 4 | 161609 | 533 | 34.990 | 4618.7 |
| 710 | 2024-04-30 08:43:29 | sapphire | 4 | 161609 | 533 | 17.813 | 9072.5 |
| 709 | 2024-04-27 12:23:13 | sapphire | 4 | 161609 | 533 | 18.500 | 8735.6 |
| 708 | 2024-04-25 23:05:56 | sapphire | 4 | 161609 | 533 | 20.016 | 8074.0 |
| 707 | 2024-04-25 10:27:21 | sapphire | 4 | 161609 | 533 | 44.500 | 3631.7 |
| 706 | 2024-04-23 05:08:51 | sapphire | 3 | 146162 | 47 | 6.406 | 22816.4 |
| 705 | 2024-04-23 01:53:08 | sapphire | 1 | 82945 | 3 | 2.936 | 28251.0 |
| 704 | 2024-04-23 01:52:42 | sapphire | 4 | 161609 | 533 | 19.906 | 8118.6 |
| 703 | 2024-04-23 01:52:47 | sapphire | 3 | 146162 | 47 | 14.516 | 10069.0 |
| 702 | 2024-04-23 01:52:45 | sapphire | 2 | 121059 | 11 | 8.093 | 14958.5 |
| 701 | 2024-04-23 01:52:39 | sapphire | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 700 | 2024-04-13 07:13:46 | sapphire | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 699 | 2024-04-10 23:34:04 | sapphire | 3 | 146162 | 47 | 7.720 | 18932.9 |
| 698 | 2024-04-10 23:34:05 | sapphire | 2 | 121059 | 11 | 4.000 | 30264.8 |
| 697 | 2024-04-10 23:34:02 | sapphire | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 696 | 2024-04-06 16:05:19 | sapphire | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 695 | 2024-04-01 06:46:09 | sapphire | 1 | 82945 | 3 | 3.343 | 24811.5 |
| 694 | 2024-03-31 21:14:42 | sapphire | 2 | 121059 | 11 | 8.373 | 14458.3 |
| 693 | 2024-03-31 05:34:38 | sapphire | 4 | 161609 | 533 | 32.766 | 4932.2 |
| 692 | 2024-03-31 05:34:54 | sapphire | 2 | 121059 | 11 | 11.673 | 10370.9 |
| 691 | 2024-03-31 03:29:52 | sapphire | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 690 | 2024-03-31 00:31:20 | sapphire | 3 | 146162 | 47 | 26.486 | 5518.5 |
| 689 | 2024-03-30 18:10:40 | sapphire | 2 | 121059 | 11 | 13.923 | 8694.9 |
| 688 | 2024-03-30 18:10:41 | sapphire | 3 | 146162 | 47 | 10.263 | 14241.6 |
| 687 | 2024-03-30 18:10:36 | sapphire | 1 | 82945 | 3 | 3.453 | 24021.1 |
| 686 | 2024-03-28 22:06:30 | sapphire | 4 | 161609 | 533 | 15.906 | 10160.3 |
| 685 | 2024-03-27 00:48:40 | sapphire | 4 | 161609 | 533 | 13.690 | 11804.9 |
| 684 | 2024-03-25 20:16:23 | sapphire | 4 | 161609 | 533 | 45.720 | 3534.8 |
| 683 | 2024-03-25 14:49:37 | sapphire | 4 | 161609 | 533 | 11.486 | 14070.1 |
| 682 | 2024-03-25 12:53:19 | sapphire | 4 | 161609 | 533 | 13.203 | 12240.3 |
| 681 | 2024-03-23 17:38:34 | sapphire | 3 | 146162 | 47 | 9.186 | 15911.4 |
| 680 | 2024-03-23 17:38:38 | sapphire | 1 | 82945 | 3 | 1.640 | 50576.2 |
| 679 | 2024-03-23 17:38:23 | sapphire | 4 | 161609 | 533 | 13.846 | 11671.9 |
| 678 | 2024-03-23 17:38:30 | sapphire | 2 | 121059 | 11 | 4.576 | 26455.2 |
| 677 | 2024-03-23 17:38:15 | sapphire | 1 | 82945 | 3 | 2.766 | 29987.3 |
| 676 | 2024-03-02 03:00:48 | sapphire | 1 | 82945 | 3 | 5.173 | 16034.2 |
| 675 | 2024-02-29 12:53:47 | sapphire | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 674 | 2024-02-26 09:39:42 | sapphire | 3 | 146162 | 47 | 11.220 | 13026.9 |
| 673 | 2024-02-26 09:39:41 | sapphire | 2 | 121059 | 11 | 4.093 | 29577.1 |
| 672 | 2024-02-22 15:09:59 | sapphire | 3 | 146162 | 47 | 14.360 | 10178.4 |
| 671 | 2024-02-22 15:10:00 | sapphire | 2 | 121059 | 11 | 4.843 | 24996.7 |
| 670 | 2024-02-22 06:29:11 | sapphire | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 669 | 2024-02-18 07:19:40 | sapphire | 1 | 82945 | 3 | 4.326 | 19173.6 |
| 668 | 2024-02-04 15:39:52 | sapphire | 4 | 161609 | 533 | 20.253 | 7979.5 |
| 667 | 2024-02-04 10:46:48 | sapphire | 4 | 161609 | 533 | 23.533 | 6867.3 |
| 666 | 2024-01-29 16:19:18 | sapphire | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 665 | 2024-01-26 04:01:33 | sapphire | 4 | 161609 | 533 | 13.110 | 12327.2 |
| 664 | 2024-01-26 00:55:11 | sapphire | 4 | 161609 | 533 | 13.376 | 12082.0 |
| 663 | 2024-01-16 19:19:03 | sapphire | 1 | 82945 | 3 | 1.560 | 53169.9 |
| 662 | 2024-01-14 05:12:29 | sapphire | 4 | 161609 | 533 | 17.673 | 9144.4 |
| 661 | 2024-01-10 21:03:47 | sapphire | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 660 | 2023-12-30 11:16:11 | sapphire | 1 | 82945 | 3 | 1.596 | 51970.6 |
| 659 | 2023-12-15 22:49:24 | sapphire | 3 | 146162 | 47 | 6.593 | 22169.3 |
| 658 | 2023-12-15 10:27:00 | sapphire | 1 | 82945 | 3 | 1.703 | 48705.2 |
| 657 | 2023-12-15 01:58:15 | sapphire | 4 | 161609 | 533 | 11.016 | 14670.4 |
| 656 | 2023-12-01 23:21:32 | sapphire | 4 | 161609 | 533 | 10.893 | 14836.0 |
| 655 | 2023-10-19 22:49:46 | sapphire | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 654 | 2023-10-17 16:03:20 | sapphire | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 653 | 2023-09-15 03:09:52 | sapphire | 3 | 146162 | 47 | 13.046 | 11203.6 |
| 652 | 2023-09-14 08:59:12 | sapphire | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 651 | 2023-08-31 13:57:22 | sapphire | 4 | 161609 | 533 | 11.610 | 13919.8 |
| 650 | 2023-08-15 17:46:27 | sapphire | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 649 | 2023-06-12 17:45:44 | sapphire | 3 | 146162 | 47 | 6.203 | 23563.1 |
| 648 | 2023-05-20 10:59:06 | sapphire | 4 | 161609 | 533 | 10.656 | 15166.0 |
| 647 | 2023-05-15 17:20:13 | sapphire | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 646 | 2023-05-05 08:43:14 | sapphire | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 645 | 2023-03-20 03:01:12 | sapphire | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 644 | 2023-03-13 21:50:03 | sapphire | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 643 | 2023-03-12 00:46:20 | sapphire | 3 | 146162 | 47 | 6.703 | 21805.5 |
| 642 | 2023-03-03 01:08:28 | sapphire | 4 | 161609 | 533 | 12.016 | 13449.5 |
| 641 | 2022-12-18 14:30:42 | sapphire | 4 | 161609 | 533 | 11.206 | 14421.6 |
| 640 | 2022-12-14 13:40:26 | sapphire | 3 | 146162 | 47 | 6.156 | 23743.0 |
| 639 | 2022-12-10 16:06:41 | sapphire | 4 | 161609 | 533 | 10.423 | 15505.0 |
| 638 | 2022-11-25 11:48:15 | sapphire | 4 | 161609 | 533 | 11.516 | 14033.4 |
| 637 | 2022-11-17 20:04:48 | sapphire | 4 | 161609 | 533 | 10.533 | 15343.1 |
| 636 | 2022-11-05 11:48:20 | sapphire | 4 | 161609 | 533 | 10.360 | 15599.3 |
| 635 | 2022-10-09 14:48:00 | sapphire | 4 | 161609 | 533 | 10.440 | 15479.8 |
| 634 | 2022-09-01 08:50:09 | sapphire | 4 | 161609 | 533 | 10.813 | 14945.8 |
| 633 | 2022-08-03 06:40:57 | sapphire | 3 | 146162 | 47 | 6.296 | 23215.1 |
| 632 | 2022-07-26 10:37:12 | sapphire | 4 | 161609 | 533 | 11.750 | 13754.0 |
| 631 | 2022-07-12 17:10:51 | sapphire | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 630 | 2022-06-12 07:56:44 | sapphire | 4 | 161609 | 533 | 10.436 | 15485.7 |
| 629 | 2022-05-31 06:38:31 | sapphire | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 628 | 2022-05-18 23:56:44 | sapphire | 4 | 161609 | 533 | 10.813 | 14945.8 |
| 627 | 2022-05-18 07:14:16 | sapphire | 4 | 161609 | 533 | 11.873 | 13611.5 |
| 626 | 2022-05-17 17:34:23 | sapphire | 4 | 161609 | 533 | 12.780 | 12645.5 |
| 625 | 2022-05-17 07:04:53 | sapphire | 4 | 161609 | 533 | 10.733 | 15057.2 |