History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1932 | 2024-04-27 02:49:56 | loan | 1 | 13983 | 15 | 0.280 | 49939.3 |
1931 | 2024-04-26 07:41:49 | loan | 2 | 29872 | 293 | 0.936 | 31914.5 |
1930 | 2024-04-23 07:18:58 | loan | 1 | 13983 | 15 | 0.266 | 52567.7 |
1929 | 2024-04-21 07:34:06 | loan | 1 | 13983 | 15 | 0.266 | 52567.7 |
1928 | 2024-04-21 02:17:07 | loan | 1 | 13983 | 15 | 0.296 | 47239.9 |
1927 | 2024-04-05 00:29:08 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1926 | 2024-04-02 20:47:26 | loan | 1 | 13983 | 15 | 0.216 | 64736.1 |
1925 | 2024-03-31 00:52:06 | loan | 2 | 29872 | 293 | 1.466 | 20376.5 |
1924 | 2024-03-31 00:42:37 | loan | 2 | 29872 | 293 | 1.470 | 20321.1 |
1923 | 2024-03-30 23:58:36 | loan | 1 | 13983 | 15 | 0.280 | 49939.3 |
1922 | 2024-03-28 14:16:48 | loan | 1 | 13983 | 15 | 0.263 | 53167.3 |
1921 | 2024-03-28 14:16:36 | loan | 2 | 29872 | 293 | 1.000 | 29872.0 |
1920 | 2024-03-27 19:28:29 | loan | 2 | 29872 | 293 | 0.796 | 37527.6 |
1919 | 2024-03-26 21:33:31 | loan | 1 | 13983 | 15 | 0.843 | 16587.2 |
1918 | 2024-03-25 21:28:02 | loan | 1 | 13983 | 15 | 0.560 | 24969.6 |
1917 | 2024-03-24 11:04:56 | loan | 1 | 13983 | 15 | 0.843 | 16587.2 |
1916 | 2024-03-23 09:58:11 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1915 | 2024-03-22 18:49:10 | loan | 1 | 13983 | 15 | 0.830 | 16847.0 |
1914 | 2024-03-21 14:46:26 | loan | 1 | 13983 | 15 | 0.266 | 52567.7 |
1913 | 2024-03-21 02:45:56 | loan | 1 | 13983 | 15 | 0.690 | 20265.2 |
1912 | 2024-03-20 02:44:18 | loan | 1 | 13983 | 15 | 0.203 | 68881.8 |
1911 | 2024-03-07 19:23:31 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1910 | 2024-03-06 08:44:27 | loan | 1 | 13983 | 15 | 0.283 | 49409.9 |
1909 | 2024-03-05 19:49:00 | loan | 1 | 13983 | 15 | 0.266 | 52567.7 |
1908 | 2024-03-04 04:07:48 | loan | 1 | 13983 | 15 | 0.280 | 49939.3 |
1907 | 2024-03-03 19:38:30 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1906 | 2024-03-03 08:05:55 | loan | 1 | 13983 | 15 | 0.653 | 21413.5 |
1905 | 2024-03-02 14:54:57 | loan | 1 | 13983 | 15 | 0.360 | 38841.7 |
1904 | 2024-03-01 15:28:49 | loan | 1 | 13983 | 15 | 0.283 | 49409.9 |
1903 | 2024-02-29 20:52:30 | loan | 1 | 13983 | 15 | 0.530 | 26383.0 |
1902 | 2024-02-25 16:21:11 | loan | 1 | 13983 | 15 | 0.470 | 29751.1 |
1901 | 2024-02-22 10:09:26 | loan | 1 | 13983 | 15 | 0.220 | 63559.1 |
1900 | 2024-02-21 18:24:50 | loan | 1 | 13983 | 15 | 0.283 | 49409.9 |
1899 | 2024-02-20 16:57:51 | loan | 1 | 13983 | 15 | 0.263 | 53167.3 |
1898 | 2024-02-19 08:08:00 | loan | 1 | 13983 | 15 | 0.390 | 35853.8 |
1897 | 2024-02-18 06:58:22 | loan | 1 | 13983 | 15 | 0.546 | 25609.9 |
1896 | 2024-02-17 15:59:39 | loan | 1 | 13983 | 15 | 0.263 | 53167.3 |
1895 | 2024-02-16 16:54:19 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1894 | 2024-02-15 21:29:23 | loan | 1 | 13983 | 15 | 0.563 | 24836.6 |
1893 | 2024-02-10 01:13:23 | loan | 1 | 13983 | 15 | 0.280 | 49939.3 |
1892 | 2024-02-09 02:02:53 | loan | 1 | 13983 | 15 | 0.266 | 52567.7 |
1891 | 2024-02-07 21:44:09 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1890 | 2024-02-02 15:33:19 | loan | 1 | 13983 | 15 | 0.500 | 27966.0 |
1889 | 2024-01-28 13:30:12 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1888 | 2024-01-25 19:06:21 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1887 | 2024-01-24 07:46:11 | loan | 1 | 13983 | 15 | 0.216 | 64736.1 |
1886 | 2024-01-21 19:16:32 | loan | 1 | 13983 | 15 | 0.216 | 64736.1 |
1885 | 2024-01-20 15:54:49 | loan | 1 | 13983 | 15 | 0.220 | 63559.1 |
1884 | 2024-01-19 21:08:04 | loan | 1 | 13983 | 15 | 0.216 | 64736.1 |
1883 | 2024-01-18 13:19:22 | loan | 1 | 13983 | 15 | 0.266 | 52567.7 |
1882 | 2024-01-17 21:46:37 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1881 | 2024-01-03 07:04:32 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1880 | 2023-12-22 01:55:55 | loan | 2 | 29872 | 293 | 0.923 | 32364.0 |
1879 | 2023-12-15 12:09:35 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1878 | 2023-12-07 13:48:00 | loan | 1 | 13983 | 15 | 0.500 | 27966.0 |
1877 | 2023-12-07 13:47:59 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1876 | 2023-12-03 03:56:06 | loan | 2 | 29872 | 293 | 0.750 | 39829.3 |
1875 | 2023-11-28 07:11:46 | loan | 2 | 29872 | 293 | 0.780 | 38297.4 |
1874 | 2023-11-12 19:26:41 | loan | 2 | 29872 | 293 | 0.876 | 34100.5 |
1873 | 2023-11-12 17:55:24 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1872 | 2023-11-09 22:30:17 | loan | 1 | 13983 | 15 | 0.216 | 64736.1 |
1871 | 2023-11-02 08:23:28 | loan | 2 | 29872 | 293 | 0.936 | 31914.5 |
1870 | 2023-11-02 04:46:16 | loan | 2 | 29872 | 293 | 0.906 | 32971.3 |
1869 | 2023-11-01 01:39:25 | loan | 1 | 13983 | 15 | 0.203 | 68881.8 |
1868 | 2023-10-31 22:19:01 | loan | 1 | 13983 | 15 | 0.220 | 63559.1 |
1867 | 2023-10-30 09:06:31 | loan | 1 | 13983 | 15 | 0.266 | 52567.7 |
1866 | 2023-10-29 11:05:35 | loan | 2 | 29872 | 293 | 0.826 | 36164.6 |
1865 | 2023-10-26 18:01:25 | loan | 1 | 13983 | 15 | 0.236 | 59250.0 |
1864 | 2023-10-25 21:13:20 | loan | 1 | 13983 | 15 | 0.220 | 63559.1 |
1863 | 2023-10-25 10:14:59 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1862 | 2023-10-19 21:27:08 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1861 | 2023-10-17 06:47:13 | loan | 1 | 13983 | 15 | 0.220 | 63559.1 |
1860 | 2023-10-16 21:54:32 | loan | 2 | 29872 | 293 | 0.856 | 34897.2 |
1859 | 2023-10-16 04:50:20 | loan | 2 | 29872 | 293 | 0.766 | 38997.4 |
1858 | 2023-10-10 20:10:10 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1857 | 2023-10-04 00:21:19 | loan | 1 | 13983 | 15 | 0.216 | 64736.1 |
1856 | 2023-09-23 06:44:02 | loan | 1 | 13983 | 15 | 0.220 | 63559.1 |
1855 | 2023-09-20 17:18:23 | loan | 1 | 13983 | 15 | 0.470 | 29751.1 |
1854 | 2023-09-16 02:00:47 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1853 | 2023-09-14 08:18:26 | loan | 1 | 13983 | 15 | 0.216 | 64736.1 |
1852 | 2023-09-05 08:57:30 | loan | 1 | 13983 | 15 | 0.203 | 68881.8 |
1851 | 2023-09-05 06:54:02 | loan | 2 | 29872 | 293 | 0.750 | 39829.3 |
1850 | 2023-09-03 20:42:08 | loan | 2 | 29872 | 293 | 0.906 | 32971.3 |
1849 | 2023-09-02 18:35:35 | loan | 2 | 29872 | 293 | 0.936 | 31914.5 |
1848 | 2023-08-31 15:28:01 | loan | 2 | 29872 | 293 | 0.750 | 39829.3 |
1847 | 2023-08-30 22:36:45 | loan | 2 | 29872 | 293 | 0.750 | 39829.3 |
1846 | 2023-08-30 05:49:00 | loan | 2 | 29872 | 293 | 0.766 | 38997.4 |
1845 | 2023-08-26 20:51:47 | loan | 1 | 13983 | 15 | 0.220 | 63559.1 |
1844 | 2023-08-26 05:17:40 | loan | 1 | 13983 | 15 | 0.216 | 64736.1 |
1843 | 2023-08-24 03:08:02 | loan | 1 | 13983 | 15 | 0.220 | 63559.1 |
1842 | 2023-08-22 10:40:07 | loan | 1 | 13983 | 15 | 0.470 | 29751.1 |
1841 | 2023-08-21 04:07:10 | loan | 1 | 13983 | 15 | 0.220 | 63559.1 |
1840 | 2023-08-21 01:35:55 | loan | 1 | 13983 | 15 | 0.236 | 59250.0 |
1839 | 2023-08-20 17:12:29 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1838 | 2023-08-19 04:10:21 | loan | 1 | 13983 | 15 | 0.233 | 60012.9 |
1837 | 2023-08-15 03:47:58 | loan | 2 | 29872 | 293 | 0.826 | 36164.6 |
1836 | 2023-07-31 07:58:02 | loan | 1 | 13983 | 15 | 0.250 | 55932.0 |
1835 | 2023-07-22 00:40:25 | loan | 1 | 13983 | 15 | 0.236 | 59250.0 |
1834 | 2023-07-09 03:11:01 | loan | 2 | 29872 | 293 | 0.843 | 35435.3 |
1833 | 2023-07-08 12:04:34 | loan | 2 | 29872 | 293 | 0.780 | 38297.4 |