History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rooms"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 846 | 2024-04-17 06:39:23 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 845 | 2024-04-03 07:17:22 | rooms | 2 | 53800 | 196 | 1.716 | 31352.0 |
| 844 | 2024-04-03 04:46:17 | rooms | 2 | 53800 | 196 | 3.283 | 16387.5 |
| 843 | 2024-04-03 04:14:42 | rooms | 1 | 28756 | 16 | 1.170 | 24577.8 |
| 842 | 2024-03-31 05:23:12 | rooms | 2 | 53800 | 196 | 1.906 | 28226.7 |
| 841 | 2024-03-31 04:01:32 | rooms | 1 | 28756 | 16 | 0.516 | 55728.7 |
| 840 | 2024-03-29 05:28:00 | rooms | 1 | 28756 | 16 | 0.593 | 48492.4 |
| 839 | 2024-03-12 19:41:37 | rooms | 1 | 28756 | 16 | 1.173 | 24514.9 |
| 838 | 2024-03-03 21:48:35 | rooms | 1 | 28756 | 16 | 0.533 | 53951.2 |
| 837 | 2024-02-26 03:56:13 | rooms | 2 | 53800 | 196 | 4.720 | 11398.3 |
| 836 | 2024-02-25 18:20:42 | rooms | 1 | 28756 | 16 | 1.013 | 28387.0 |
| 835 | 2024-02-19 02:11:35 | rooms | 1 | 28756 | 16 | 0.576 | 49923.6 |
| 834 | 2024-01-26 16:45:37 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 833 | 2024-01-17 05:16:40 | rooms | 2 | 53800 | 196 | 1.623 | 33148.5 |
| 832 | 2024-01-15 06:49:15 | rooms | 1 | 28756 | 16 | 0.530 | 54256.6 |
| 831 | 2024-01-12 00:17:04 | rooms | 2 | 53800 | 196 | 1.640 | 32804.9 |
| 830 | 2023-12-29 14:25:20 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 829 | 2023-12-14 21:18:29 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 828 | 2023-12-06 15:13:34 | rooms | 2 | 53800 | 196 | 1.406 | 38264.6 |
| 827 | 2023-12-04 07:48:46 | rooms | 2 | 53800 | 196 | 1.593 | 33772.8 |
| 826 | 2023-11-18 04:41:28 | rooms | 1 | 28756 | 16 | 0.440 | 65354.5 |
| 825 | 2023-11-15 23:28:10 | rooms | 1 | 28756 | 16 | 0.486 | 59168.7 |
| 824 | 2023-10-28 00:28:38 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 823 | 2023-10-20 07:04:18 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 822 | 2023-10-19 18:14:57 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 821 | 2023-10-13 11:05:41 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 820 | 2023-10-04 11:50:16 | rooms | 1 | 28756 | 16 | 0.483 | 59536.2 |
| 819 | 2023-09-30 17:15:11 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 818 | 2023-09-15 08:18:31 | rooms | 1 | 28756 | 16 | 0.436 | 65954.1 |
| 817 | 2023-09-14 15:42:23 | rooms | 2 | 53800 | 196 | 3.203 | 16796.8 |
| 816 | 2023-09-10 14:31:46 | rooms | 1 | 28756 | 16 | 0.513 | 56054.6 |
| 815 | 2023-09-04 01:17:26 | rooms | 2 | 53800 | 196 | 1.420 | 37887.3 |
| 814 | 2023-07-27 19:54:44 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 813 | 2023-05-29 06:52:45 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 812 | 2023-05-17 15:33:26 | rooms | 1 | 28756 | 16 | 0.440 | 65354.5 |
| 811 | 2023-04-25 05:37:52 | rooms | 1 | 28756 | 16 | 0.440 | 65354.5 |
| 810 | 2023-03-28 14:45:03 | rooms | 1 | 28756 | 16 | 0.436 | 65954.1 |
| 809 | 2023-03-25 08:09:07 | rooms | 2 | 53800 | 196 | 1.626 | 33087.3 |
| 808 | 2023-02-16 13:12:23 | rooms | 1 | 28756 | 16 | 0.483 | 59536.2 |
| 807 | 2023-02-15 04:29:10 | rooms | 1 | 28756 | 16 | 0.516 | 55728.7 |
| 806 | 2023-02-01 19:24:45 | rooms | 2 | 53800 | 196 | 1.393 | 38621.7 |
| 805 | 2023-01-29 14:52:38 | rooms | 2 | 53800 | 196 | 1.563 | 34421.0 |
| 804 | 2023-01-03 19:02:13 | rooms | 2 | 53800 | 196 | 1.580 | 34050.6 |
| 803 | 2022-12-17 01:03:44 | rooms | 2 | 53800 | 196 | 1.593 | 33772.8 |
| 802 | 2022-12-14 14:13:26 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 801 | 2022-11-19 21:35:48 | rooms | 1 | 28756 | 16 | 0.440 | 65354.5 |
| 800 | 2022-11-18 20:52:06 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 799 | 2022-10-23 03:58:00 | rooms | 1 | 28756 | 16 | 0.436 | 65954.1 |
| 798 | 2022-09-19 18:22:29 | rooms | 1 | 28756 | 16 | 0.513 | 56054.6 |
| 797 | 2022-09-18 13:39:22 | rooms | 1 | 28756 | 16 | 0.456 | 63061.4 |
| 796 | 2022-09-12 08:11:42 | rooms | 1 | 28756 | 16 | 0.483 | 59536.2 |
| 795 | 2022-09-09 05:28:03 | rooms | 2 | 53800 | 196 | 1.406 | 38264.6 |
| 794 | 2022-08-26 02:28:42 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 793 | 2022-08-22 23:49:00 | rooms | 1 | 28756 | 16 | 0.483 | 59536.2 |
| 792 | 2022-08-21 23:06:34 | rooms | 1 | 28756 | 16 | 0.466 | 61708.2 |
| 791 | 2022-08-19 11:33:53 | rooms | 1 | 28756 | 16 | 0.486 | 59168.7 |
| 790 | 2022-08-17 14:30:44 | rooms | 1 | 28756 | 16 | 0.436 | 65954.1 |
| 789 | 2022-08-06 23:35:02 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 788 | 2022-07-30 01:10:15 | rooms | 1 | 28756 | 16 | 0.470 | 61183.0 |
| 787 | 2022-07-17 21:56:22 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 786 | 2022-07-17 18:38:14 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 785 | 2022-07-02 21:59:51 | rooms | 1 | 28756 | 16 | 0.533 | 53951.2 |
| 784 | 2022-06-25 14:32:51 | rooms | 1 | 28756 | 16 | 0.436 | 65954.1 |
| 783 | 2022-06-08 11:05:08 | rooms | 2 | 53800 | 196 | 1.563 | 34421.0 |
| 782 | 2022-05-30 20:26:00 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 781 | 2022-05-02 19:36:29 | rooms | 2 | 53800 | 196 | 2.080 | 25865.4 |
| 780 | 2022-04-03 13:17:50 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 779 | 2022-03-31 06:55:54 | rooms | 1 | 28756 | 16 | 0.466 | 61708.2 |
| 778 | 2022-03-30 17:57:01 | rooms | 1 | 28756 | 16 | 0.483 | 59536.2 |
| 777 | 2022-03-30 05:59:01 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 776 | 2022-03-29 20:26:39 | rooms | 1 | 28756 | 16 | 0.860 | 33437.2 |
| 775 | 2022-03-29 08:48:42 | rooms | 1 | 28756 | 16 | 0.563 | 51076.4 |
| 774 | 2022-03-28 10:17:36 | rooms | 1 | 28756 | 16 | 0.640 | 44931.3 |
| 773 | 2022-03-27 18:02:12 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 772 | 2022-03-26 09:50:39 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 771 | 2022-03-26 05:33:49 | rooms | 2 | 53800 | 196 | 1.640 | 32804.9 |
| 770 | 2022-03-19 19:27:23 | rooms | 1 | 28756 | 16 | 0.486 | 59168.7 |
| 769 | 2022-03-18 19:33:36 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 768 | 2022-03-17 12:09:49 | rooms | 1 | 28756 | 16 | 0.593 | 48492.4 |
| 767 | 2022-03-16 16:34:29 | rooms | 1 | 28756 | 16 | 0.623 | 46157.3 |
| 766 | 2022-03-06 00:14:34 | rooms | 1 | 28756 | 16 | 0.516 | 55728.7 |
| 765 | 2022-03-01 18:00:14 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 764 | 2022-03-01 01:12:15 | rooms | 1 | 28756 | 16 | 0.686 | 41918.4 |
| 763 | 2022-02-28 11:56:23 | rooms | 1 | 28756 | 16 | 0.500 | 57512.0 |
| 762 | 2022-02-27 17:15:45 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 761 | 2022-02-26 11:29:04 | rooms | 1 | 28756 | 16 | 0.470 | 61183.0 |
| 760 | 2022-02-25 20:58:01 | rooms | 1 | 28756 | 16 | 0.470 | 61183.0 |
| 759 | 2022-02-25 10:32:42 | rooms | 1 | 28756 | 16 | 0.593 | 48492.4 |
| 758 | 2022-02-25 02:51:38 | rooms | 1 | 28756 | 16 | 0.936 | 30722.2 |
| 757 | 2022-02-24 09:50:11 | rooms | 1 | 28756 | 16 | 0.466 | 61708.2 |
| 756 | 2022-02-24 07:48:24 | rooms | 1 | 28756 | 16 | 0.486 | 59168.7 |
| 755 | 2022-02-23 19:53:54 | rooms | 1 | 28756 | 16 | 0.593 | 48492.4 |
| 754 | 2022-02-23 17:36:58 | rooms | 1 | 28756 | 16 | 0.643 | 44721.6 |
| 753 | 2022-02-23 02:33:06 | rooms | 1 | 28756 | 16 | 0.453 | 63479.0 |
| 752 | 2022-02-22 23:02:26 | rooms | 1 | 28756 | 16 | 0.513 | 56054.6 |
| 751 | 2022-02-22 15:14:54 | rooms | 1 | 28756 | 16 | 0.670 | 42919.4 |
| 750 | 2022-02-22 12:27:43 | rooms | 1 | 28756 | 16 | 0.656 | 43835.4 |
| 749 | 2022-02-22 00:18:55 | rooms | 1 | 28756 | 16 | 0.576 | 49923.6 |
| 748 | 2022-02-21 20:12:52 | rooms | 1 | 28756 | 16 | 0.530 | 54256.6 |
| 747 | 2022-02-21 02:45:32 | rooms | 1 | 28756 | 16 | 0.470 | 61183.0 |