History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aphis"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1896 | 2024-05-05 03:38:16 | aphis | 2 | 53800 | 61 | 1.623 | 33148.5 |
1895 | 2024-05-05 03:37:48 | aphis | 1 | 28756 | 7 | 0.576 | 49923.6 |
1894 | 2024-05-05 03:37:27 | aphis | 3 | 83667 | 1115 | 3.923 | 21327.3 |
1893 | 2024-05-05 02:58:17 | aphis | 1 | 28756 | 7 | 0.530 | 54256.6 |
1892 | 2024-05-05 02:35:32 | aphis | 1 | 28756 | 7 | 0.563 | 51076.4 |
1891 | 2024-05-04 13:42:19 | aphis | 3 | 83667 | 1115 | 4.470 | 18717.4 |
1890 | 2024-05-01 03:10:21 | aphis | 2 | 53800 | 61 | 1.466 | 36698.5 |
1889 | 2024-05-01 03:09:33 | aphis | 3 | 83667 | 1115 | 5.873 | 14246.0 |
1888 | 2024-04-30 21:12:41 | aphis | 1 | 28756 | 7 | 0.546 | 52666.7 |
1887 | 2024-04-30 06:58:00 | aphis | 3 | 83667 | 1115 | 13.720 | 6098.2 |
1886 | 2024-04-29 17:31:25 | aphis | 1 | 28756 | 7 | 1.080 | 26625.9 |
1885 | 2024-04-28 08:36:26 | aphis | 1 | 28756 | 7 | 0.593 | 48492.4 |
1884 | 2024-04-23 19:35:26 | aphis | 1 | 28756 | 7 | 2.796 | 10284.7 |
1883 | 2024-04-21 22:43:13 | aphis | 1 | 28756 | 7 | 0.576 | 49923.6 |
1882 | 2024-04-20 22:35:08 | aphis | 1 | 28756 | 7 | 0.580 | 49579.3 |
1881 | 2024-04-15 10:04:59 | aphis | 3 | 83667 | 1115 | 5.186 | 16133.2 |
1880 | 2024-04-07 17:24:22 | aphis | 1 | 28756 | 7 | 1.156 | 24875.4 |
1879 | 2024-04-04 19:55:54 | aphis | 3 | 83667 | 1115 | 11.500 | 7275.4 |
1878 | 2024-04-04 19:40:20 | aphis | 2 | 53800 | 61 | 4.126 | 13039.3 |
1877 | 2024-04-04 19:40:10 | aphis | 1 | 28756 | 7 | 0.796 | 36125.6 |
1876 | 2024-04-04 16:24:11 | aphis | 2 | 53800 | 61 | 2.076 | 25915.2 |
1875 | 2024-04-04 16:24:04 | aphis | 1 | 28756 | 7 | 0.546 | 52666.7 |
1874 | 2024-04-04 16:23:14 | aphis | 3 | 83667 | 1115 | 4.156 | 20131.6 |
1873 | 2024-04-03 06:33:45 | aphis | 3 | 83667 | 1115 | 11.656 | 7178.0 |
1872 | 2024-04-03 06:33:45 | aphis | 2 | 53800 | 61 | 5.296 | 10158.6 |
1871 | 2024-04-03 06:18:57 | aphis | 1 | 28756 | 7 | 0.610 | 47141.0 |
1870 | 2024-03-31 08:28:07 | aphis | 3 | 83667 | 1115 | 4.563 | 18336.0 |
1869 | 2024-03-31 08:28:06 | aphis | 2 | 53800 | 61 | 1.796 | 29955.5 |
1868 | 2024-03-31 08:28:03 | aphis | 1 | 28756 | 7 | 1.080 | 26625.9 |
1867 | 2024-03-28 20:14:22 | aphis | 1 | 28756 | 7 | 0.530 | 54256.6 |
1866 | 2024-03-18 21:26:59 | aphis | 3 | 83667 | 1115 | 5.516 | 15168.1 |
1865 | 2024-03-17 16:53:50 | aphis | 1 | 28756 | 7 | 0.533 | 53951.2 |
1864 | 2024-03-08 01:27:12 | aphis | 1 | 28756 | 7 | 0.450 | 63902.2 |
1863 | 2024-03-07 19:13:19 | aphis | 3 | 83667 | 1115 | 9.313 | 8983.9 |
1862 | 2024-03-05 18:42:02 | aphis | 3 | 83667 | 1115 | 14.016 | 5969.4 |
1861 | 2024-03-05 18:15:50 | aphis | 1 | 28756 | 7 | 0.563 | 51076.4 |
1860 | 2024-03-05 18:14:46 | aphis | 2 | 53800 | 61 | 3.733 | 14412.0 |
1859 | 2024-03-04 23:55:09 | aphis | 2 | 53800 | 61 | 1.763 | 30516.2 |
1858 | 2024-03-04 23:54:45 | aphis | 3 | 83667 | 1115 | 4.110 | 20356.9 |
1857 | 2024-03-04 12:23:59 | aphis | 2 | 53800 | 61 | 2.313 | 23259.8 |
1856 | 2024-03-04 12:23:59 | aphis | 1 | 28756 | 7 | 1.093 | 26309.2 |
1855 | 2024-03-04 12:23:37 | aphis | 3 | 83667 | 1115 | 4.406 | 18989.3 |
1854 | 2024-03-04 03:58:53 | aphis | 3 | 83667 | 1115 | 11.406 | 7335.3 |
1853 | 2024-03-04 03:58:51 | aphis | 2 | 53800 | 61 | 1.910 | 28167.5 |
1852 | 2024-03-04 00:41:10 | aphis | 1 | 28756 | 7 | 0.453 | 63479.0 |
1851 | 2024-03-01 02:29:09 | aphis | 1 | 28756 | 7 | 0.533 | 53951.2 |
1850 | 2024-02-25 19:14:16 | aphis | 1 | 28756 | 7 | 0.466 | 61708.2 |
1849 | 2024-02-02 23:53:39 | aphis | 1 | 28756 | 7 | 0.453 | 63479.0 |
1848 | 2024-01-29 01:45:31 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1847 | 2024-01-26 04:01:09 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1846 | 2023-12-31 10:41:44 | aphis | 3 | 83667 | 1115 | 3.436 | 24350.1 |
1845 | 2023-12-25 19:47:07 | aphis | 2 | 53800 | 61 | 1.390 | 38705.0 |
1844 | 2023-12-25 15:59:46 | aphis | 3 | 83667 | 1115 | 3.596 | 23266.7 |
1843 | 2023-12-25 15:59:41 | aphis | 2 | 53800 | 61 | 1.703 | 31591.3 |
1842 | 2023-12-19 10:02:23 | aphis | 3 | 83667 | 1115 | 3.406 | 24564.6 |
1841 | 2023-12-13 01:49:13 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1840 | 2023-12-12 03:09:43 | aphis | 1 | 28756 | 7 | 0.450 | 63902.2 |
1839 | 2023-12-11 03:10:16 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1838 | 2023-12-10 12:49:50 | aphis | 1 | 28756 | 7 | 0.453 | 63479.0 |
1837 | 2023-12-10 01:57:59 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1836 | 2023-12-06 03:51:17 | aphis | 1 | 28756 | 7 | 0.500 | 57512.0 |
1835 | 2023-12-05 07:51:03 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1834 | 2023-12-03 03:35:42 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1833 | 2023-12-02 00:35:54 | aphis | 1 | 28756 | 7 | 0.453 | 63479.0 |
1832 | 2023-12-01 04:30:19 | aphis | 1 | 28756 | 7 | 0.513 | 56054.6 |
1831 | 2023-11-27 10:55:51 | aphis | 1 | 28756 | 7 | 0.580 | 49579.3 |
1830 | 2023-11-26 04:02:28 | aphis | 1 | 28756 | 7 | 0.453 | 63479.0 |
1829 | 2023-11-25 05:34:50 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1828 | 2023-11-24 04:12:56 | aphis | 3 | 83667 | 1115 | 3.360 | 24900.9 |
1827 | 2023-11-24 03:06:47 | aphis | 1 | 28756 | 7 | 0.436 | 65954.1 |
1826 | 2023-11-23 09:38:10 | aphis | 1 | 28756 | 7 | 0.453 | 63479.0 |
1825 | 2023-11-17 20:44:30 | aphis | 3 | 83667 | 1115 | 3.390 | 24680.5 |
1824 | 2023-11-17 20:44:29 | aphis | 2 | 53800 | 61 | 1.516 | 35488.1 |
1823 | 2023-11-13 04:10:51 | aphis | 1 | 28756 | 7 | 0.436 | 65954.1 |
1822 | 2023-11-12 17:37:40 | aphis | 1 | 28756 | 7 | 0.500 | 57512.0 |
1821 | 2023-11-11 14:36:28 | aphis | 1 | 28756 | 7 | 0.500 | 57512.0 |
1820 | 2023-11-10 07:14:13 | aphis | 1 | 28756 | 7 | 0.453 | 63479.0 |
1819 | 2023-11-08 21:51:21 | aphis | 1 | 28756 | 7 | 0.470 | 61183.0 |
1818 | 2023-11-08 11:45:28 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1817 | 2023-11-05 02:01:25 | aphis | 2 | 53800 | 61 | 1.593 | 33772.8 |
1816 | 2023-11-05 01:53:12 | aphis | 3 | 83667 | 1115 | 3.360 | 24900.9 |
1815 | 2023-10-26 11:40:11 | aphis | 1 | 28756 | 7 | 0.563 | 51076.4 |
1814 | 2023-10-26 08:56:30 | aphis | 1 | 28756 | 7 | 0.500 | 57512.0 |
1813 | 2023-10-20 08:26:31 | aphis | 1 | 28756 | 7 | 0.500 | 57512.0 |
1812 | 2023-10-17 04:27:26 | aphis | 1 | 28756 | 7 | 0.546 | 52666.7 |
1811 | 2023-10-11 09:27:52 | aphis | 1 | 28756 | 7 | 0.500 | 57512.0 |
1810 | 2023-10-03 23:57:04 | aphis | 3 | 83667 | 1115 | 4.296 | 19475.6 |
1809 | 2023-10-03 20:48:54 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1808 | 2023-10-01 09:21:25 | aphis | 3 | 83667 | 1115 | 4.420 | 18929.2 |
1807 | 2023-09-28 00:17:38 | aphis | 3 | 83667 | 1115 | 3.983 | 21006.0 |
1806 | 2023-09-27 07:46:43 | aphis | 1 | 28756 | 7 | 0.500 | 57512.0 |
1805 | 2023-09-21 17:04:03 | aphis | 1 | 28756 | 7 | 0.513 | 56054.6 |
1804 | 2023-09-21 01:04:19 | aphis | 3 | 83667 | 1115 | 3.296 | 25384.4 |
1803 | 2023-09-16 15:59:15 | aphis | 1 | 28756 | 7 | 0.483 | 59536.2 |
1802 | 2023-09-10 23:53:06 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |
1801 | 2023-09-02 17:31:10 | aphis | 3 | 83667 | 1115 | 3.890 | 21508.2 |
1800 | 2023-08-31 11:22:09 | aphis | 1 | 28756 | 7 | 0.453 | 63479.0 |
1799 | 2023-08-30 11:44:57 | aphis | 3 | 83667 | 1115 | 3.830 | 21845.2 |
1798 | 2023-08-29 05:42:37 | aphis | 3 | 83667 | 1115 | 4.080 | 20506.6 |
1797 | 2023-08-22 14:10:11 | aphis | 1 | 28756 | 7 | 0.516 | 55728.7 |