History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"items"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1921 | 2025-08-03 23:50:53 | items | 1 | 28756 | 3 | 2.220 | 12953.2 |
1920 | 2025-07-25 19:49:20 | items | 1 | 28756 | 3 | 0.466 | 61708.2 |
1919 | 2025-07-24 18:45:42 | items | 1 | 28756 | 3 | 0.970 | 29645.4 |
1918 | 2025-07-24 12:49:27 | items | 1 | 28756 | 3 | 2.313 | 12432.3 |
1917 | 2025-07-23 04:40:41 | items | 1 | 28756 | 3 | 1.483 | 19390.4 |
1916 | 2025-07-17 19:14:06 | items | 1 | 28756 | 3 | 2.280 | 12612.3 |
1915 | 2025-07-13 06:57:27 | items | 1 | 28756 | 3 | 0.453 | 63479.0 |
1914 | 2025-07-10 23:28:50 | items | 1 | 28756 | 3 | 2.313 | 12432.3 |
1913 | 2025-07-10 23:01:27 | items | 1 | 28756 | 3 | 2.110 | 13628.4 |
1912 | 2025-07-01 23:55:21 | items | 1 | 28756 | 3 | 4.156 | 6919.2 |
1911 | 2025-06-30 03:32:04 | items | 1 | 28756 | 3 | 1.250 | 23004.8 |
1910 | 2025-06-28 05:41:13 | items | 1 | 28756 | 3 | 1.046 | 27491.4 |
1909 | 2025-06-16 14:22:20 | items | 1 | 28756 | 3 | 2.500 | 11502.4 |
1908 | 2025-06-12 06:42:07 | items | 1 | 28756 | 3 | 2.063 | 13938.9 |
1907 | 2025-06-09 23:57:37 | items | 3 | 83667 | 1464 | 18.690 | 4476.6 |
1906 | 2025-06-08 04:13:38 | items | 1 | 28756 | 3 | 1.436 | 20025.1 |
1905 | 2025-06-02 16:35:13 | items | 1 | 28756 | 3 | 2.530 | 11366.0 |
1904 | 2025-05-29 12:34:48 | items | 1 | 28756 | 3 | 1.156 | 24875.4 |
1903 | 2025-05-29 02:56:22 | items | 1 | 28756 | 3 | 3.703 | 7765.6 |
1902 | 2025-05-28 22:57:30 | items | 1 | 28756 | 3 | 1.156 | 24875.4 |
1901 | 2025-05-24 10:00:22 | items | 3 | 83667 | 1464 | 16.890 | 4953.6 |
1900 | 2025-05-21 04:24:53 | items | 1 | 28756 | 3 | 0.513 | 56054.6 |
1899 | 2025-05-16 18:10:21 | items | 3 | 83667 | 1464 | 13.796 | 6064.6 |
1898 | 2025-05-16 10:26:08 | items | 1 | 28756 | 3 | 2.140 | 13437.4 |
1897 | 2025-05-14 14:24:56 | items | 2 | 53800 | 73 | 11.080 | 4855.6 |
1896 | 2025-05-14 10:55:46 | items | 3 | 83667 | 1464 | 34.453 | 2428.4 |
1895 | 2025-05-13 13:59:43 | items | 1 | 28756 | 3 | 2.736 | 10510.2 |
1894 | 2025-05-10 06:44:41 | items | 1 | 28756 | 3 | 3.516 | 8178.6 |
1893 | 2025-05-05 06:59:17 | items | 1 | 28756 | 3 | 0.516 | 55728.7 |
1892 | 2025-05-04 18:54:31 | items | 1 | 28756 | 3 | 0.530 | 54256.6 |
1891 | 2025-04-27 23:57:44 | items | 1 | 28756 | 3 | 2.313 | 12432.3 |
1890 | 2025-04-27 07:07:26 | items | 1 | 28756 | 3 | 1.046 | 27491.4 |
1889 | 2025-04-26 12:06:46 | items | 1 | 28756 | 3 | 3.936 | 7305.9 |
1888 | 2025-04-24 07:58:45 | items | 1 | 28756 | 3 | 2.720 | 10572.1 |
1887 | 2025-04-22 01:54:20 | items | 1 | 28756 | 3 | 0.436 | 65954.1 |
1886 | 2025-04-20 17:37:14 | items | 1 | 28756 | 3 | 0.483 | 59536.2 |
1885 | 2025-04-08 16:09:57 | items | 3 | 83667 | 1464 | 3.986 | 20990.2 |
1884 | 2025-04-08 16:05:45 | items | 3 | 83667 | 1464 | 3.936 | 21256.9 |
1883 | 2025-04-08 13:09:21 | items | 2 | 53800 | 73 | 7.656 | 7027.2 |
1882 | 2025-04-08 10:10:21 | items | 3 | 83667 | 1464 | 19.740 | 4238.4 |
1881 | 2025-04-08 08:08:59 | items | 3 | 83667 | 1464 | 14.830 | 5641.7 |
1880 | 2025-04-08 06:10:06 | items | 1 | 28756 | 3 | 1.483 | 19390.4 |
1879 | 2025-04-08 03:13:42 | items | 1 | 28756 | 3 | 2.750 | 10456.7 |
1878 | 2025-04-08 00:07:52 | items | 1 | 28756 | 3 | 2.076 | 13851.6 |
1877 | 2025-04-07 13:41:27 | items | 1 | 28756 | 3 | 1.420 | 20250.7 |
1876 | 2025-04-07 03:48:22 | items | 1 | 28756 | 3 | 3.250 | 8848.0 |
1875 | 2025-04-07 00:18:28 | items | 3 | 83667 | 1464 | 21.236 | 3939.9 |
1874 | 2025-03-31 10:49:06 | items | 1 | 28756 | 3 | 1.783 | 16127.9 |
1873 | 2025-03-27 01:35:42 | items | 1 | 28756 | 3 | 2.143 | 13418.6 |
1872 | 2025-03-24 00:10:19 | items | 1 | 28756 | 3 | 0.470 | 61183.0 |
1871 | 2025-03-17 11:34:26 | items | 3 | 83667 | 1464 | 12.453 | 6718.6 |
1870 | 2025-03-15 00:54:50 | items | 3 | 83667 | 1464 | 12.080 | 6926.1 |
1869 | 2025-03-15 00:54:43 | items | 2 | 53800 | 73 | 6.280 | 8566.9 |
1868 | 2025-03-14 23:28:16 | items | 1 | 28756 | 3 | 0.423 | 67981.1 |
1867 | 2025-03-10 11:16:40 | items | 2 | 53800 | 73 | 7.843 | 6859.6 |
1866 | 2025-03-10 10:30:25 | items | 2 | 53800 | 73 | 7.656 | 7027.2 |
1865 | 2025-03-09 10:49:10 | items | 3 | 83667 | 1464 | 16.923 | 4944.0 |
1864 | 2025-03-09 04:19:56 | items | 3 | 83667 | 1464 | 26.733 | 3129.7 |
1863 | 2025-03-08 21:00:45 | items | 1 | 28756 | 3 | 3.453 | 8327.8 |
1862 | 2025-03-08 21:00:34 | items | 2 | 53800 | 73 | 12.016 | 4477.4 |
1861 | 2025-03-08 09:41:54 | items | 3 | 83667 | 1464 | 8.576 | 9755.9 |
1860 | 2025-03-08 07:52:05 | items | 3 | 83667 | 1464 | 32.580 | 2568.0 |
1859 | 2025-03-08 07:02:39 | items | 3 | 83667 | 1464 | 22.126 | 3781.4 |
1858 | 2025-03-08 07:02:38 | items | 2 | 53800 | 73 | 13.406 | 4013.1 |
1857 | 2025-03-08 07:02:00 | items | 1 | 28756 | 3 | 2.670 | 10770.0 |
1856 | 2025-03-07 19:29:54 | items | 1 | 28756 | 3 | 0.860 | 33437.2 |
1855 | 2025-02-26 04:14:21 | items | 1 | 28756 | 3 | 1.360 | 21144.1 |
1854 | 2025-02-24 02:46:44 | items | 1 | 28756 | 3 | 2.813 | 10222.5 |
1853 | 2025-02-05 06:42:29 | items | 1 | 28756 | 3 | 1.440 | 19969.4 |
1852 | 2025-02-04 21:36:29 | items | 1 | 28756 | 3 | 3.610 | 7965.7 |
1851 | 2025-02-04 02:22:25 | items | 2 | 53800 | 73 | 8.283 | 6495.2 |
1850 | 2025-02-01 01:43:07 | items | 1 | 28756 | 3 | 0.440 | 65354.5 |
1849 | 2025-01-24 17:14:19 | items | 1 | 28756 | 3 | 1.483 | 19390.4 |
1848 | 2025-01-06 08:14:56 | items | 1 | 28756 | 3 | 1.403 | 20496.1 |
1847 | 2025-01-06 08:14:04 | items | 2 | 53800 | 73 | 4.083 | 13176.6 |
1846 | 2025-01-06 06:25:17 | items | 2 | 53800 | 73 | 6.983 | 7704.4 |
1845 | 2025-01-06 05:48:48 | items | 3 | 83667 | 1464 | 6.126 | 13657.7 |
1844 | 2025-01-06 02:25:43 | items | 3 | 83667 | 1464 | 17.703 | 4726.1 |
1843 | 2025-01-06 01:43:12 | items | 3 | 83667 | 1464 | 18.456 | 4533.3 |
1842 | 2025-01-06 01:43:13 | items | 2 | 53800 | 73 | 10.233 | 5257.5 |
1841 | 2025-01-06 01:42:49 | items | 1 | 28756 | 3 | 2.530 | 11366.0 |
1840 | 2025-01-01 22:21:44 | items | 3 | 83667 | 1464 | 8.533 | 9805.1 |
1839 | 2025-01-01 18:35:23 | items | 1 | 28756 | 3 | 1.843 | 15602.8 |
1838 | 2024-12-25 15:45:02 | items | 1 | 28756 | 3 | 1.563 | 18398.0 |
1837 | 2024-12-16 05:20:54 | items | 3 | 83667 | 1464 | 18.986 | 4406.8 |
1836 | 2024-12-16 04:44:31 | items | 1 | 28756 | 3 | 1.343 | 21411.8 |
1835 | 2024-12-13 09:32:27 | items | 3 | 83667 | 1464 | 18.236 | 4588.0 |
1834 | 2024-12-12 15:31:53 | items | 2 | 53800 | 73 | 1.516 | 35488.1 |
1833 | 2024-12-07 00:04:05 | items | 1 | 28756 | 3 | 1.203 | 23903.6 |
1832 | 2024-12-06 21:37:45 | items | 3 | 83667 | 1464 | 9.516 | 8792.2 |
1831 | 2024-12-06 17:03:03 | items | 3 | 83667 | 1464 | 16.906 | 4949.0 |
1830 | 2024-12-06 16:42:47 | items | 3 | 83667 | 1464 | 13.063 | 6404.9 |
1829 | 2024-12-06 16:42:57 | items | 2 | 53800 | 73 | 4.250 | 12658.8 |
1828 | 2024-12-06 16:41:28 | items | 1 | 28756 | 3 | 1.173 | 24514.9 |
1827 | 2024-12-02 14:41:50 | items | 2 | 53800 | 73 | 1.530 | 35163.4 |
1826 | 2024-12-02 14:41:49 | items | 1 | 28756 | 3 | 0.486 | 59168.7 |
1825 | 2024-11-21 23:36:48 | items | 1 | 28756 | 3 | 2.563 | 11219.7 |
1824 | 2024-11-14 03:56:34 | items | 3 | 83667 | 1464 | 11.233 | 7448.3 |
1823 | 2024-11-08 01:59:30 | items | 3 | 83667 | 1464 | 20.626 | 4056.4 |
1822 | 2024-11-06 22:14:25 | items | 1 | 28756 | 3 | 4.436 | 6482.4 |