History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gallon"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 720 | 2025-12-04 10:35:41 | gallon | 3 | 112716 | 574 | 5.750 | 19602.8 |
| 719 | 2025-11-30 18:16:16 | gallon | 3 | 112716 | 574 | 4.950 | 22770.9 |
| 718 | 2025-11-05 17:32:28 | gallon | 3 | 112716 | 574 | 5.436 | 20735.1 |
| 717 | 2025-11-03 21:25:41 | gallon | 1 | 48755 | 6 | 0.906 | 53813.5 |
| 716 | 2025-10-21 07:26:55 | gallon | 3 | 112716 | 574 | 32.343 | 3485.0 |
| 715 | 2025-10-04 22:05:17 | gallon | 1 | 48755 | 6 | 0.940 | 51867.0 |
| 714 | 2025-09-30 21:03:08 | gallon | 1 | 48755 | 6 | 0.890 | 54780.9 |
| 713 | 2025-09-25 22:28:49 | gallon | 3 | 112716 | 574 | 25.470 | 4425.4 |
| 712 | 2025-09-25 03:10:01 | gallon | 3 | 112716 | 574 | 26.266 | 4291.3 |
| 711 | 2025-09-25 03:09:10 | gallon | 3 | 112716 | 574 | 30.000 | 3757.2 |
| 710 | 2025-09-25 03:09:16 | gallon | 3 | 112716 | 574 | 24.030 | 4690.6 |
| 709 | 2025-09-25 03:08:55 | gallon | 3 | 112716 | 574 | 15.500 | 7272.0 |
| 708 | 2025-09-25 00:23:43 | gallon | 3 | 112716 | 574 | 30.876 | 3650.6 |
| 707 | 2025-09-21 23:32:18 | gallon | 1 | 48755 | 6 | 0.923 | 52822.3 |
| 706 | 2025-09-14 08:54:12 | gallon | 1 | 48755 | 6 | 0.783 | 62266.9 |
| 705 | 2025-09-13 17:20:30 | gallon | 3 | 112716 | 574 | 4.813 | 23419.1 |
| 704 | 2025-09-10 19:38:14 | gallon | 3 | 112716 | 574 | 5.280 | 21347.7 |
| 703 | 2025-08-30 13:14:19 | gallon | 1 | 48755 | 6 | 0.846 | 57630.0 |
| 702 | 2025-08-28 09:36:59 | gallon | 3 | 112716 | 574 | 4.906 | 22975.1 |
| 701 | 2025-08-27 21:58:42 | gallon | 3 | 112716 | 574 | 5.046 | 22337.7 |
| 700 | 2025-08-23 03:56:44 | gallon | 1 | 48755 | 6 | 2.796 | 17437.4 |
| 699 | 2025-08-17 15:15:17 | gallon | 1 | 48755 | 6 | 3.920 | 12437.5 |
| 698 | 2025-08-17 13:11:27 | gallon | 3 | 112716 | 574 | 13.110 | 8597.7 |
| 697 | 2025-08-14 01:08:45 | gallon | 3 | 112716 | 574 | 5.623 | 20045.5 |
| 696 | 2025-08-06 01:22:39 | gallon | 2 | 82551 | 69 | 18.890 | 4370.1 |
| 695 | 2025-08-05 00:57:41 | gallon | 1 | 48755 | 6 | 3.486 | 13985.9 |
| 694 | 2025-08-04 05:43:31 | gallon | 1 | 48755 | 6 | 0.876 | 55656.4 |
| 693 | 2025-08-03 23:09:41 | gallon | 1 | 48755 | 6 | 2.186 | 22303.3 |
| 692 | 2025-07-28 05:31:46 | gallon | 3 | 112716 | 574 | 14.140 | 7971.4 |
| 691 | 2025-07-28 03:01:51 | gallon | 3 | 112716 | 574 | 18.610 | 6056.7 |
| 690 | 2025-07-27 21:54:54 | gallon | 3 | 112716 | 574 | 11.546 | 9762.3 |
| 689 | 2025-07-27 00:53:13 | gallon | 2 | 82551 | 69 | 13.173 | 6266.7 |
| 688 | 2025-07-27 00:51:44 | gallon | 3 | 112716 | 574 | 20.280 | 5558.0 |
| 687 | 2025-07-24 01:04:22 | gallon | 1 | 48755 | 6 | 2.626 | 18566.3 |
| 686 | 2025-07-23 10:19:54 | gallon | 1 | 48755 | 6 | 4.110 | 11862.5 |
| 685 | 2025-07-23 02:21:03 | gallon | 1 | 48755 | 6 | 2.203 | 22131.2 |
| 684 | 2025-07-22 16:34:19 | gallon | 1 | 48755 | 6 | 2.000 | 24377.5 |
| 683 | 2025-07-22 09:22:14 | gallon | 1 | 48755 | 6 | 0.843 | 57835.1 |
| 682 | 2025-07-19 14:55:21 | gallon | 1 | 48755 | 6 | 0.906 | 53813.5 |
| 681 | 2025-07-17 09:34:18 | gallon | 1 | 48755 | 6 | 3.966 | 12293.2 |
| 680 | 2025-07-16 23:49:03 | gallon | 3 | 112716 | 574 | 15.360 | 7338.3 |
| 679 | 2025-07-13 15:38:36 | gallon | 1 | 48755 | 6 | 0.953 | 51159.5 |
| 678 | 2025-07-03 22:43:32 | gallon | 1 | 48755 | 6 | 3.343 | 14584.2 |
| 677 | 2025-06-20 20:07:00 | gallon | 2 | 82551 | 69 | 11.423 | 7226.7 |
| 676 | 2025-06-20 03:44:29 | gallon | 1 | 48755 | 6 | 4.236 | 11509.7 |
| 675 | 2025-06-19 23:21:09 | gallon | 1 | 48755 | 6 | 3.953 | 12333.7 |
| 674 | 2025-06-19 17:16:49 | gallon | 1 | 48755 | 6 | 0.846 | 57630.0 |
| 673 | 2025-06-16 08:01:53 | gallon | 1 | 48755 | 6 | 4.876 | 9999.0 |
| 672 | 2025-06-12 15:22:54 | gallon | 1 | 48755 | 6 | 6.390 | 7629.9 |
| 671 | 2025-06-04 13:43:37 | gallon | 3 | 112716 | 574 | 32.580 | 3459.7 |
| 670 | 2025-06-04 07:20:48 | gallon | 2 | 82551 | 69 | 11.986 | 6887.3 |
| 669 | 2025-06-02 04:54:49 | gallon | 2 | 82551 | 69 | 12.186 | 6774.2 |
| 668 | 2025-06-01 23:43:47 | gallon | 3 | 112716 | 574 | 33.020 | 3413.6 |
| 667 | 2025-06-01 02:47:24 | gallon | 1 | 48755 | 6 | 3.846 | 12676.8 |
| 666 | 2025-05-27 08:59:03 | gallon | 1 | 48755 | 6 | 3.873 | 12588.4 |
| 665 | 2025-05-25 17:34:25 | gallon | 1 | 48755 | 6 | 0.873 | 55847.7 |
| 664 | 2025-05-20 03:06:42 | gallon | 1 | 48755 | 6 | 4.063 | 11999.8 |
| 663 | 2025-05-17 16:07:18 | gallon | 1 | 48755 | 6 | 0.826 | 59025.4 |
| 662 | 2025-05-16 08:02:50 | gallon | 1 | 48755 | 6 | 4.110 | 11862.5 |
| 661 | 2025-05-13 22:36:45 | gallon | 3 | 112716 | 574 | 23.856 | 4724.8 |
| 660 | 2025-05-13 12:16:22 | gallon | 3 | 112716 | 574 | 29.093 | 3874.3 |
| 659 | 2025-05-12 15:18:29 | gallon | 1 | 48755 | 6 | 6.110 | 7979.5 |
| 658 | 2025-05-03 22:43:13 | gallon | 1 | 48755 | 6 | 6.406 | 7610.8 |
| 657 | 2025-05-03 03:34:26 | gallon | 1 | 48755 | 6 | 4.233 | 11517.8 |
| 656 | 2025-04-27 13:28:45 | gallon | 1 | 48755 | 6 | 0.843 | 57835.1 |
| 655 | 2025-04-21 04:56:38 | gallon | 2 | 82551 | 69 | 13.030 | 6335.5 |
| 654 | 2025-04-21 04:04:02 | gallon | 2 | 82551 | 69 | 12.876 | 6411.2 |
| 653 | 2025-04-20 15:02:34 | gallon | 3 | 112716 | 574 | 21.926 | 5140.7 |
| 652 | 2025-04-20 14:05:59 | gallon | 2 | 82551 | 69 | 9.796 | 8427.0 |
| 651 | 2025-04-20 02:08:03 | gallon | 1 | 48755 | 6 | 5.813 | 8387.2 |
| 650 | 2025-04-18 22:47:48 | gallon | 1 | 48755 | 6 | 5.186 | 9401.3 |
| 649 | 2025-04-14 07:52:32 | gallon | 1 | 48755 | 6 | 4.233 | 11517.8 |
| 648 | 2025-04-11 15:26:43 | gallon | 1 | 48755 | 6 | 2.280 | 21383.8 |
| 647 | 2025-04-01 22:36:45 | gallon | 1 | 48755 | 6 | 2.686 | 18151.5 |
| 646 | 2025-03-20 19:18:56 | gallon | 2 | 82551 | 69 | 2.436 | 33887.9 |
| 645 | 2025-03-20 19:08:51 | gallon | 3 | 112716 | 574 | 5.953 | 18934.3 |
| 644 | 2025-03-20 04:11:36 | gallon | 1 | 48755 | 6 | 2.250 | 21668.9 |
| 643 | 2025-03-18 23:48:59 | gallon | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 642 | 2025-03-12 17:39:37 | gallon | 1 | 48755 | 6 | 4.063 | 11999.8 |
| 641 | 2025-03-12 09:49:21 | gallon | 1 | 48755 | 6 | 3.860 | 12630.8 |
| 640 | 2025-03-03 16:23:07 | gallon | 3 | 112716 | 574 | 14.720 | 7657.3 |
| 639 | 2025-03-02 18:34:37 | gallon | 1 | 48755 | 6 | 4.096 | 11903.1 |
| 638 | 2025-03-02 14:43:47 | gallon | 3 | 112716 | 574 | 34.393 | 3277.3 |
| 637 | 2025-03-02 14:21:25 | gallon | 3 | 112716 | 574 | 43.223 | 2607.8 |
| 636 | 2025-03-02 05:35:43 | gallon | 3 | 112716 | 574 | 26.126 | 4314.3 |
| 635 | 2025-03-02 02:48:01 | gallon | 1 | 48755 | 6 | 2.200 | 22161.4 |
| 634 | 2025-03-02 02:44:46 | gallon | 3 | 112716 | 574 | 28.066 | 4016.1 |
| 633 | 2025-03-02 02:44:44 | gallon | 2 | 82551 | 69 | 12.580 | 6562.1 |
| 632 | 2025-02-13 00:05:35 | gallon | 1 | 48755 | 6 | 4.016 | 12140.2 |
| 631 | 2025-02-09 08:28:00 | gallon | 2 | 82551 | 69 | 15.970 | 5169.1 |
| 630 | 2025-02-08 14:37:01 | gallon | 1 | 48755 | 6 | 4.173 | 11683.4 |
| 629 | 2025-02-08 14:36:48 | gallon | 2 | 82551 | 69 | 10.046 | 8217.3 |
| 628 | 2025-02-08 08:10:36 | gallon | 1 | 48755 | 6 | 4.843 | 10067.1 |
| 627 | 2025-01-29 11:36:30 | gallon | 1 | 48755 | 6 | 4.253 | 11463.7 |
| 626 | 2025-01-28 13:11:17 | gallon | 1 | 48755 | 6 | 2.390 | 20399.6 |
| 625 | 2025-01-25 22:40:02 | gallon | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 624 | 2025-01-16 20:12:42 | gallon | 3 | 112716 | 574 | 29.406 | 3833.1 |
| 623 | 2025-01-10 08:00:34 | gallon | 3 | 112716 | 574 | 23.033 | 4893.7 |
| 622 | 2025-01-10 03:51:06 | gallon | 3 | 112716 | 574 | 26.210 | 4300.5 |
| 621 | 2025-01-10 01:34:46 | gallon | 3 | 112716 | 574 | 14.016 | 8042.0 |