History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sofa"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 767 | 2025-10-31 11:57:39 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 766 | 2025-10-24 03:16:23 | sofa | 1 | 13983 | 13 | 0.216 | 64736.1 |
| 765 | 2025-10-20 03:31:45 | sofa | 1 | 13983 | 13 | 1.406 | 9945.2 |
| 764 | 2025-10-12 04:27:36 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 763 | 2025-09-26 02:56:12 | sofa | 1 | 13983 | 13 | 0.236 | 59250.0 |
| 762 | 2025-09-25 10:56:56 | sofa | 1 | 13983 | 13 | 0.720 | 19420.8 |
| 761 | 2025-09-25 10:56:51 | sofa | 1 | 13983 | 13 | 1.203 | 11623.4 |
| 760 | 2025-09-25 10:56:40 | sofa | 1 | 13983 | 13 | 1.000 | 13983.0 |
| 759 | 2025-09-25 10:56:26 | sofa | 1 | 13983 | 13 | 1.263 | 11071.3 |
| 758 | 2025-09-07 22:10:39 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 757 | 2025-09-07 09:06:29 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
| 756 | 2025-08-27 01:58:22 | sofa | 1 | 13983 | 13 | 0.216 | 64736.1 |
| 755 | 2025-08-25 13:33:51 | sofa | 1 | 13983 | 13 | 0.890 | 15711.2 |
| 754 | 2025-08-11 04:32:06 | sofa | 1 | 13983 | 13 | 1.126 | 12418.3 |
| 753 | 2025-08-09 01:23:19 | sofa | 1 | 13983 | 13 | 1.296 | 10789.4 |
| 752 | 2025-08-08 23:08:59 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 751 | 2025-08-02 20:13:34 | sofa | 1 | 13983 | 13 | 0.690 | 20265.2 |
| 750 | 2025-08-01 01:34:11 | sofa | 1 | 13983 | 13 | 0.873 | 16017.2 |
| 749 | 2025-07-31 12:32:34 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
| 748 | 2025-07-27 03:43:44 | sofa | 1 | 13983 | 13 | 1.153 | 12127.5 |
| 747 | 2025-07-25 06:08:58 | sofa | 1 | 13983 | 13 | 0.656 | 21315.5 |
| 746 | 2025-07-24 16:45:28 | sofa | 1 | 13983 | 13 | 0.513 | 27257.3 |
| 745 | 2025-07-23 19:54:26 | sofa | 1 | 13983 | 13 | 1.000 | 13983.0 |
| 744 | 2025-07-23 08:29:37 | sofa | 1 | 13983 | 13 | 0.343 | 40766.8 |
| 743 | 2025-07-23 02:46:22 | sofa | 1 | 13983 | 13 | 1.343 | 10411.8 |
| 742 | 2025-07-17 00:13:53 | sofa | 1 | 13983 | 13 | 0.703 | 19890.5 |
| 741 | 2025-07-10 20:58:50 | sofa | 2 | 29872 | 167 | 2.483 | 12030.6 |
| 740 | 2025-07-09 10:46:11 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
| 739 | 2025-07-09 00:29:57 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
| 738 | 2025-07-04 15:32:45 | sofa | 2 | 29872 | 167 | 4.436 | 6734.0 |
| 737 | 2025-07-02 19:13:31 | sofa | 2 | 29872 | 167 | 3.923 | 7614.6 |
| 736 | 2025-07-01 14:30:10 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 735 | 2025-06-30 12:35:32 | sofa | 1 | 13983 | 13 | 0.310 | 45106.5 |
| 734 | 2025-06-18 13:27:42 | sofa | 1 | 13983 | 13 | 0.720 | 19420.8 |
| 733 | 2025-06-18 13:18:11 | sofa | 1 | 13983 | 13 | 1.250 | 11186.4 |
| 732 | 2025-06-15 23:41:47 | sofa | 1 | 13983 | 13 | 0.593 | 23580.1 |
| 731 | 2025-06-05 01:54:53 | sofa | 1 | 13983 | 13 | 1.156 | 12096.0 |
| 730 | 2025-05-31 14:38:25 | sofa | 1 | 13983 | 13 | 1.390 | 10059.7 |
| 729 | 2025-05-30 12:13:39 | sofa | 1 | 13983 | 13 | 1.673 | 8358.0 |
| 728 | 2025-05-29 11:25:41 | sofa | 1 | 13983 | 13 | 1.296 | 10789.4 |
| 727 | 2025-05-25 21:56:07 | sofa | 1 | 13983 | 13 | 1.423 | 9826.4 |
| 726 | 2025-05-15 12:28:18 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 725 | 2025-05-13 00:00:00 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
| 724 | 2025-05-09 03:04:07 | sofa | 1 | 13983 | 13 | 0.236 | 59250.0 |
| 723 | 2025-05-08 09:07:15 | sofa | 1 | 13983 | 13 | 0.950 | 14718.9 |
| 722 | 2025-05-03 07:07:56 | sofa | 1 | 13983 | 13 | 1.516 | 9223.6 |
| 721 | 2025-04-30 14:33:48 | sofa | 1 | 13983 | 13 | 1.280 | 10924.2 |
| 720 | 2025-04-29 23:51:36 | sofa | 1 | 13983 | 13 | 0.313 | 44674.1 |
| 719 | 2025-04-28 12:02:10 | sofa | 1 | 13983 | 13 | 1.390 | 10059.7 |
| 718 | 2025-04-21 06:36:28 | sofa | 2 | 29872 | 167 | 2.220 | 13455.9 |
| 717 | 2025-04-20 04:05:36 | sofa | 1 | 13983 | 13 | 1.860 | 7517.7 |
| 716 | 2025-04-14 23:31:31 | sofa | 1 | 13983 | 13 | 0.983 | 14224.8 |
| 715 | 2025-04-06 00:39:47 | sofa | 1 | 13983 | 13 | 0.440 | 31779.5 |
| 714 | 2025-03-29 17:07:26 | sofa | 1 | 13983 | 13 | 1.623 | 8615.5 |
| 713 | 2025-03-29 00:41:46 | sofa | 1 | 13983 | 13 | 1.190 | 11750.4 |
| 712 | 2025-03-24 19:21:02 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
| 711 | 2025-03-19 08:03:18 | sofa | 2 | 29872 | 167 | 0.920 | 32469.6 |
| 710 | 2025-03-18 15:09:20 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
| 709 | 2025-03-18 11:52:14 | sofa | 1 | 13983 | 13 | 2.063 | 6778.0 |
| 708 | 2025-03-15 09:03:21 | sofa | 2 | 29872 | 167 | 4.470 | 6682.8 |
| 707 | 2025-03-15 08:38:21 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
| 706 | 2025-03-06 15:47:22 | sofa | 1 | 13983 | 13 | 0.296 | 47239.9 |
| 705 | 2025-02-26 05:30:15 | sofa | 1 | 13983 | 13 | 1.093 | 12793.2 |
| 704 | 2025-02-25 09:27:28 | sofa | 2 | 29872 | 167 | 4.703 | 6351.7 |
| 703 | 2025-02-25 09:14:38 | sofa | 2 | 29872 | 167 | 2.966 | 10071.5 |
| 702 | 2025-02-25 08:45:21 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
| 701 | 2025-02-25 08:44:48 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 700 | 2025-02-16 10:56:26 | sofa | 1 | 13983 | 13 | 0.876 | 15962.3 |
| 699 | 2025-02-10 15:51:38 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
| 698 | 2025-02-04 15:14:24 | sofa | 1 | 13983 | 13 | 0.920 | 15198.9 |
| 697 | 2025-01-27 04:39:36 | sofa | 1 | 13983 | 13 | 1.233 | 11340.6 |
| 696 | 2025-01-26 07:13:46 | sofa | 2 | 29872 | 167 | 4.140 | 7215.5 |
| 695 | 2025-01-26 06:59:08 | sofa | 2 | 29872 | 167 | 4.940 | 6047.0 |
| 694 | 2025-01-26 06:17:18 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 693 | 2025-01-26 06:01:38 | sofa | 2 | 29872 | 167 | 2.703 | 11051.4 |
| 692 | 2025-01-26 05:47:34 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
| 691 | 2025-01-20 23:07:02 | sofa | 1 | 13983 | 13 | 0.703 | 19890.5 |
| 690 | 2025-01-06 15:39:03 | sofa | 1 | 13983 | 13 | 0.763 | 18326.3 |
| 689 | 2025-01-05 11:28:32 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
| 688 | 2024-12-28 04:17:59 | sofa | 1 | 13983 | 13 | 0.686 | 20383.4 |
| 687 | 2024-12-27 20:29:16 | sofa | 2 | 29872 | 167 | 4.610 | 6479.8 |
| 686 | 2024-12-27 06:45:19 | sofa | 2 | 29872 | 167 | 6.300 | 4741.6 |
| 685 | 2024-12-27 06:11:14 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
| 684 | 2024-12-27 05:55:42 | sofa | 2 | 29872 | 167 | 4.393 | 6799.9 |
| 683 | 2024-12-27 05:31:49 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 682 | 2024-12-08 20:03:11 | sofa | 1 | 13983 | 13 | 1.393 | 10038.0 |
| 681 | 2024-12-06 09:00:54 | sofa | 1 | 13983 | 13 | 2.203 | 6347.3 |
| 680 | 2024-11-27 05:51:14 | sofa | 2 | 29872 | 167 | 3.016 | 9904.5 |
| 679 | 2024-11-27 05:40:39 | sofa | 1 | 13983 | 13 | 0.766 | 18254.6 |
| 678 | 2024-11-27 04:26:24 | sofa | 2 | 29872 | 167 | 5.313 | 5622.4 |
| 677 | 2024-11-27 03:16:38 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
| 676 | 2024-11-06 05:50:44 | sofa | 1 | 13983 | 13 | 0.966 | 14475.2 |
| 675 | 2024-10-28 01:06:20 | sofa | 2 | 29872 | 167 | 4.623 | 6461.6 |
| 674 | 2024-10-28 00:36:21 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 673 | 2024-10-28 00:25:45 | sofa | 2 | 29872 | 167 | 2.610 | 11445.2 |
| 672 | 2024-10-28 00:22:35 | sofa | 1 | 13983 | 13 | 1.233 | 11340.6 |
| 671 | 2024-10-07 05:18:45 | sofa | 1 | 13983 | 13 | 2.013 | 6946.3 |
| 670 | 2024-09-27 23:55:41 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
| 669 | 2024-09-27 23:00:48 | sofa | 1 | 13983 | 13 | 2.410 | 5802.1 |
| 668 | 2024-09-27 17:57:59 | sofa | 1 | 13983 | 13 | 1.763 | 7931.4 |