History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"candle"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 739 | 2024-05-11 19:09:55 | candle | 1 | 48755 | 9 | 0.953 | 51159.5 |
| 738 | 2024-05-08 01:12:13 | candle | 3 | 112716 | 859 | 11.843 | 9517.5 |
| 737 | 2024-05-08 01:06:25 | candle | 3 | 112716 | 859 | 7.610 | 14811.6 |
| 736 | 2024-05-07 16:32:02 | candle | 2 | 82551 | 89 | 5.423 | 15222.4 |
| 735 | 2024-05-07 16:31:16 | candle | 3 | 112716 | 859 | 8.530 | 13214.1 |
| 734 | 2024-05-07 11:35:15 | candle | 3 | 112716 | 859 | 7.160 | 15742.5 |
| 733 | 2024-05-06 04:21:05 | candle | 1 | 48755 | 9 | 2.986 | 16327.9 |
| 732 | 2024-05-03 23:22:27 | candle | 2 | 82551 | 89 | 2.966 | 27832.4 |
| 731 | 2024-05-03 18:35:08 | candle | 1 | 48755 | 9 | 0.860 | 56691.9 |
| 730 | 2024-05-03 18:34:16 | candle | 3 | 112716 | 859 | 7.626 | 14780.5 |
| 729 | 2024-05-03 18:34:00 | candle | 2 | 82551 | 89 | 8.796 | 9385.1 |
| 728 | 2024-05-02 05:21:26 | candle | 1 | 48755 | 9 | 0.983 | 49598.2 |
| 727 | 2024-04-09 02:59:25 | candle | 1 | 48755 | 9 | 1.516 | 32160.3 |
| 726 | 2024-04-05 23:47:05 | candle | 1 | 48755 | 9 | 2.050 | 23782.9 |
| 725 | 2024-04-05 15:11:41 | candle | 3 | 112716 | 859 | 11.656 | 9670.2 |
| 724 | 2024-04-03 11:34:54 | candle | 2 | 82551 | 89 | 7.063 | 11687.8 |
| 723 | 2024-04-03 10:42:36 | candle | 3 | 112716 | 859 | 20.126 | 5600.5 |
| 722 | 2024-04-03 10:35:35 | candle | 3 | 112716 | 859 | 11.533 | 9773.3 |
| 721 | 2024-04-03 10:35:25 | candle | 2 | 82551 | 89 | 9.093 | 9078.5 |
| 720 | 2024-03-14 13:10:41 | candle | 3 | 112716 | 859 | 5.343 | 21096.0 |
| 719 | 2024-03-14 13:10:04 | candle | 2 | 82551 | 89 | 2.796 | 29524.7 |
| 718 | 2024-03-13 15:45:02 | candle | 2 | 82551 | 89 | 2.736 | 30172.1 |
| 717 | 2024-03-06 23:55:43 | candle | 1 | 48755 | 9 | 3.046 | 16006.2 |
| 716 | 2024-03-05 23:30:44 | candle | 2 | 82551 | 89 | 6.643 | 12426.8 |
| 715 | 2024-03-05 20:00:52 | candle | 3 | 112716 | 859 | 9.720 | 11596.3 |
| 714 | 2024-03-05 16:11:10 | candle | 2 | 82551 | 89 | 3.046 | 27101.4 |
| 713 | 2024-03-05 16:10:02 | candle | 3 | 112716 | 859 | 6.000 | 18786.0 |
| 712 | 2024-03-04 08:29:08 | candle | 2 | 82551 | 89 | 5.890 | 14015.4 |
| 711 | 2024-03-04 07:53:24 | candle | 3 | 112716 | 859 | 6.250 | 18034.6 |
| 710 | 2024-03-04 07:46:49 | candle | 3 | 112716 | 859 | 11.266 | 10005.0 |
| 709 | 2024-03-04 07:46:50 | candle | 2 | 82551 | 89 | 2.903 | 28436.4 |
| 708 | 2024-02-03 00:43:14 | candle | 2 | 82551 | 89 | 4.706 | 17541.6 |
| 707 | 2024-02-03 00:42:26 | candle | 3 | 112716 | 859 | 5.080 | 22188.2 |
| 706 | 2024-02-02 20:41:33 | candle | 2 | 82551 | 89 | 2.690 | 30688.1 |
| 705 | 2024-02-02 20:40:05 | candle | 3 | 112716 | 859 | 5.280 | 21347.7 |
| 704 | 2024-02-02 11:18:07 | candle | 2 | 82551 | 89 | 2.186 | 37763.5 |
| 703 | 2024-02-02 11:15:39 | candle | 3 | 112716 | 859 | 4.813 | 23419.1 |
| 702 | 2024-02-02 05:43:32 | candle | 3 | 112716 | 859 | 5.923 | 19030.2 |
| 701 | 2024-02-02 05:43:28 | candle | 2 | 82551 | 89 | 2.656 | 31080.9 |
| 700 | 2024-01-26 22:41:13 | candle | 1 | 48755 | 9 | 0.876 | 55656.4 |
| 699 | 2023-12-29 21:07:01 | candle | 1 | 48755 | 9 | 0.830 | 58741.0 |
| 698 | 2023-12-28 10:37:12 | candle | 2 | 82551 | 89 | 2.390 | 34540.2 |
| 697 | 2023-12-28 10:37:07 | candle | 3 | 112716 | 859 | 4.750 | 23729.7 |
| 696 | 2023-12-26 23:22:06 | candle | 3 | 112716 | 859 | 5.170 | 21801.9 |
| 695 | 2023-12-09 13:53:54 | candle | 2 | 82551 | 89 | 2.580 | 31996.5 |
| 694 | 2023-12-09 13:53:35 | candle | 3 | 112716 | 859 | 5.063 | 22262.7 |
| 693 | 2023-12-07 20:17:36 | candle | 1 | 48755 | 9 | 0.903 | 53992.2 |
| 692 | 2023-12-07 20:17:35 | candle | 1 | 48755 | 9 | 0.843 | 57835.1 |
| 691 | 2023-12-07 14:59:54 | candle | 1 | 48755 | 9 | 0.893 | 54596.9 |
| 690 | 2023-12-07 14:59:53 | candle | 1 | 48755 | 9 | 0.890 | 54780.9 |
| 689 | 2023-11-24 07:25:32 | candle | 2 | 82551 | 89 | 2.703 | 30540.5 |
| 688 | 2023-11-24 07:25:26 | candle | 3 | 112716 | 859 | 5.576 | 20214.5 |
| 687 | 2023-11-15 03:10:48 | candle | 3 | 112716 | 859 | 4.843 | 23274.0 |
| 686 | 2023-11-13 20:05:19 | candle | 1 | 48755 | 9 | 0.813 | 59969.2 |
| 685 | 2023-11-11 01:53:38 | candle | 1 | 48755 | 9 | 0.860 | 56691.9 |
| 684 | 2023-11-03 19:19:32 | candle | 1 | 48755 | 9 | 0.906 | 53813.5 |
| 683 | 2023-10-21 22:39:53 | candle | 1 | 48755 | 9 | 0.873 | 55847.7 |
| 682 | 2023-10-18 21:10:29 | candle | 1 | 48755 | 9 | 0.780 | 62506.4 |
| 681 | 2023-10-18 06:03:08 | candle | 1 | 48755 | 9 | 0.763 | 63899.1 |
| 680 | 2023-10-14 17:13:57 | candle | 1 | 48755 | 9 | 0.860 | 56691.9 |
| 679 | 2023-10-12 01:00:24 | candle | 1 | 48755 | 9 | 0.843 | 57835.1 |
| 678 | 2023-10-08 01:52:50 | candle | 1 | 48755 | 9 | 0.766 | 63648.8 |
| 677 | 2023-10-01 03:53:44 | candle | 3 | 112716 | 859 | 12.326 | 9144.6 |
| 676 | 2023-09-27 19:37:40 | candle | 3 | 112716 | 859 | 4.783 | 23566.0 |
| 675 | 2023-09-24 12:11:04 | candle | 1 | 48755 | 9 | 0.876 | 55656.4 |
| 674 | 2023-09-15 11:47:34 | candle | 1 | 48755 | 9 | 0.783 | 62266.9 |
| 673 | 2023-09-03 11:45:42 | candle | 1 | 48755 | 9 | 0.783 | 62266.9 |
| 672 | 2023-08-12 21:36:42 | candle | 1 | 48755 | 9 | 0.876 | 55656.4 |
| 671 | 2023-08-05 23:12:57 | candle | 1 | 48755 | 9 | 0.860 | 56691.9 |
| 670 | 2023-07-07 09:16:13 | candle | 3 | 112716 | 859 | 4.906 | 22975.1 |
| 669 | 2023-07-02 09:44:06 | candle | 1 | 48755 | 9 | 0.796 | 61250.0 |
| 668 | 2023-05-12 19:09:59 | candle | 1 | 48755 | 9 | 0.780 | 62506.4 |
| 667 | 2023-03-31 14:56:17 | candle | 3 | 112716 | 859 | 5.716 | 19719.4 |
| 666 | 2023-03-25 22:19:41 | candle | 1 | 48755 | 9 | 0.843 | 57835.1 |
| 665 | 2023-03-25 03:02:18 | candle | 3 | 112716 | 859 | 5.360 | 21029.1 |
| 664 | 2023-03-07 15:09:08 | candle | 1 | 48755 | 9 | 0.780 | 62506.4 |
| 663 | 2022-12-28 16:02:22 | candle | 1 | 48755 | 9 | 0.750 | 65006.7 |
| 662 | 2022-12-23 14:01:21 | candle | 3 | 112716 | 859 | 4.763 | 23664.9 |
| 661 | 2022-12-17 09:24:41 | candle | 1 | 48755 | 9 | 0.750 | 65006.7 |
| 660 | 2022-12-14 04:30:23 | candle | 1 | 48755 | 9 | 0.766 | 63648.8 |
| 659 | 2022-09-15 13:21:45 | candle | 1 | 48755 | 9 | 0.890 | 54780.9 |
| 658 | 2022-09-02 12:03:34 | candle | 1 | 48755 | 9 | 0.810 | 60191.4 |
| 657 | 2022-08-27 18:34:22 | candle | 1 | 48755 | 9 | 0.763 | 63899.1 |
| 656 | 2022-08-19 20:20:32 | candle | 3 | 112716 | 859 | 5.123 | 22002.0 |
| 655 | 2022-08-17 10:26:06 | candle | 3 | 112716 | 859 | 4.796 | 23502.1 |
| 654 | 2022-05-17 21:44:34 | candle | 2 | 82551 | 89 | 2.186 | 37763.5 |
| 653 | 2022-05-15 02:52:01 | candle | 1 | 48755 | 9 | 0.766 | 63648.8 |
| 652 | 2022-04-20 02:24:05 | candle | 1 | 48755 | 9 | 1.110 | 43923.4 |
| 651 | 2022-04-17 23:25:26 | candle | 1 | 48755 | 9 | 0.890 | 54780.9 |
| 650 | 2022-02-10 07:19:53 | candle | 1 | 48755 | 9 | 0.966 | 50471.0 |
| 649 | 2022-01-10 20:33:30 | candle | 2 | 82551 | 89 | 2.563 | 32208.7 |
| 648 | 2022-01-09 09:24:31 | candle | 1 | 48755 | 9 | 0.986 | 49447.3 |
| 647 | 2022-01-07 07:23:18 | candle | 1 | 48755 | 9 | 0.893 | 54596.9 |
| 646 | 2021-11-10 20:58:06 | candle | 3 | 112716 | 859 | 6.156 | 18309.9 |
| 645 | 2021-11-06 00:50:09 | candle | 1 | 48755 | 9 | 0.923 | 52822.3 |
| 644 | 2021-11-05 11:20:01 | candle | 1 | 48755 | 9 | 0.953 | 51159.5 |
| 643 | 2021-11-03 10:43:52 | candle | 1 | 48755 | 9 | 0.766 | 63648.8 |
| 642 | 2021-09-18 16:01:33 | candle | 1 | 48755 | 9 | 0.923 | 52822.3 |
| 641 | 2021-08-29 22:52:55 | candle | 1 | 48755 | 9 | 0.860 | 56691.9 |
| 640 | 2021-08-06 08:13:08 | candle | 1 | 48755 | 9 | 0.763 | 63899.1 |