History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"viticulture"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
238 | 2024-05-21 10:31:38 | viticulture | 2 | 86808 | 6 | 5.673 | 15302.0 |
237 | 2024-05-21 10:29:49 | viticulture | 1 | 49908 | 3 | 1.013 | 49267.5 |
236 | 2024-05-19 02:35:55 | viticulture | 1 | 49908 | 3 | 2.733 | 18261.3 |
235 | 2024-05-17 05:33:14 | viticulture | 2 | 86808 | 6 | 8.830 | 9831.0 |
234 | 2024-05-17 03:52:10 | viticulture | 4 | 148819 | 40 | 16.016 | 9291.9 |
233 | 2024-05-13 16:44:59 | viticulture | 4 | 148819 | 40 | 26.190 | 5682.3 |
232 | 2024-05-11 22:06:22 | viticulture | 2 | 86808 | 6 | 4.186 | 20737.7 |
231 | 2024-05-08 13:38:36 | viticulture | 4 | 148819 | 40 | 28.580 | 5207.1 |
230 | 2024-05-07 19:58:49 | viticulture | 4 | 148819 | 40 | 20.156 | 7383.4 |
229 | 2024-05-06 13:57:42 | viticulture | 3 | 121633 | 17 | 14.673 | 8289.6 |
228 | 2024-05-06 13:49:51 | viticulture | 4 | 148819 | 40 | 21.143 | 7038.7 |
227 | 2024-05-06 13:49:47 | viticulture | 5 | 164607 | 115 | 19.780 | 8321.9 |
226 | 2024-05-06 13:49:55 | viticulture | 2 | 86808 | 6 | 5.393 | 16096.4 |
225 | 2024-05-06 13:41:11 | viticulture | 1 | 49908 | 3 | 0.813 | 61387.5 |
224 | 2024-05-06 13:36:12 | viticulture | 1 | 49908 | 3 | 0.940 | 53093.6 |
223 | 2024-05-05 19:05:57 | viticulture | 3 | 121633 | 17 | 8.986 | 13535.8 |
222 | 2024-04-24 13:05:03 | viticulture | 3 | 121633 | 17 | 11.940 | 10187.0 |
221 | 2024-04-24 11:43:02 | viticulture | 3 | 121633 | 17 | 21.983 | 5533.0 |
220 | 2024-04-24 11:26:07 | viticulture | 3 | 121633 | 17 | 15.033 | 8091.1 |
219 | 2024-04-22 00:40:20 | viticulture | 3 | 121633 | 17 | 14.093 | 8630.7 |
218 | 2024-04-20 20:48:32 | viticulture | 3 | 121633 | 17 | 12.750 | 9539.8 |
217 | 2024-04-20 20:48:33 | viticulture | 2 | 86808 | 6 | 8.843 | 9816.6 |
216 | 2024-04-20 20:47:19 | viticulture | 1 | 49908 | 3 | 1.280 | 38990.6 |
215 | 2024-04-06 02:17:32 | viticulture | 4 | 148819 | 40 | 26.190 | 5682.3 |
214 | 2024-04-05 14:16:47 | viticulture | 2 | 86808 | 6 | 3.593 | 24160.3 |
213 | 2024-04-05 14:15:09 | viticulture | 1 | 49908 | 3 | 2.170 | 22999.1 |
212 | 2024-04-03 01:46:57 | viticulture | 5 | 164607 | 115 | 43.860 | 3753.0 |
211 | 2024-03-29 21:42:29 | viticulture | 5 | 164607 | 115 | 36.173 | 4550.5 |
210 | 2024-03-29 12:16:14 | viticulture | 2 | 86808 | 6 | 7.623 | 11387.6 |
209 | 2024-03-29 05:46:04 | viticulture | 4 | 148819 | 40 | 27.626 | 5386.9 |
208 | 2024-03-28 19:10:34 | viticulture | 5 | 164607 | 115 | 37.330 | 4409.5 |
207 | 2024-03-28 01:07:33 | viticulture | 4 | 148819 | 40 | 14.376 | 10351.9 |
206 | 2024-03-28 01:06:04 | viticulture | 3 | 121633 | 17 | 6.390 | 19034.9 |
205 | 2024-03-28 01:06:04 | viticulture | 2 | 86808 | 6 | 5.156 | 16836.3 |
204 | 2024-03-28 01:05:55 | viticulture | 1 | 49908 | 3 | 0.923 | 54071.5 |
203 | 2024-03-28 01:05:47 | viticulture | 2 | 86808 | 6 | 2.513 | 34543.6 |
202 | 2024-03-28 01:05:35 | viticulture | 1 | 49908 | 3 | 0.810 | 61614.8 |
201 | 2024-03-28 00:52:07 | viticulture | 5 | 164607 | 115 | 42.706 | 3854.4 |
200 | 2024-03-22 20:21:23 | viticulture | 2 | 86808 | 6 | 4.076 | 21297.4 |
199 | 2024-03-22 20:15:31 | viticulture | 5 | 164607 | 115 | 15.970 | 10307.3 |
198 | 2024-03-22 20:15:32 | viticulture | 4 | 148819 | 40 | 10.920 | 13628.1 |
197 | 2024-03-22 20:15:28 | viticulture | 1 | 49908 | 3 | 0.890 | 56076.4 |
196 | 2024-03-22 20:15:22 | viticulture | 1 | 49908 | 3 | 0.860 | 58032.6 |
195 | 2024-03-22 14:39:26 | viticulture | 4 | 148819 | 40 | 19.266 | 7724.4 |
194 | 2024-03-20 12:46:55 | viticulture | 4 | 148819 | 40 | 7.563 | 19677.2 |
193 | 2024-03-17 15:25:12 | viticulture | 4 | 148819 | 40 | 8.546 | 17413.9 |
192 | 2024-03-17 15:25:03 | viticulture | 4 | 148819 | 40 | 7.703 | 19319.6 |
191 | 2024-03-16 17:53:08 | viticulture | 3 | 121633 | 17 | 18.233 | 6671.0 |
190 | 2024-03-13 02:14:42 | viticulture | 3 | 121633 | 17 | 18.783 | 6475.7 |
189 | 2024-03-08 14:44:10 | viticulture | 4 | 148819 | 40 | 33.910 | 4388.6 |
188 | 2024-03-08 14:44:14 | viticulture | 3 | 121633 | 17 | 12.563 | 9681.8 |
187 | 2024-03-08 13:39:21 | viticulture | 3 | 121633 | 17 | 18.393 | 6613.0 |
186 | 2024-03-08 13:39:24 | viticulture | 2 | 86808 | 6 | 8.110 | 10703.8 |
185 | 2024-03-08 13:38:48 | viticulture | 1 | 49908 | 3 | 2.843 | 17554.7 |
184 | 2024-03-03 20:15:23 | viticulture | 1 | 49908 | 3 | 0.813 | 61387.5 |
183 | 2024-03-03 07:32:30 | viticulture | 4 | 148819 | 40 | 31.220 | 4766.8 |
182 | 2024-02-26 17:32:28 | viticulture | 5 | 164607 | 115 | 19.656 | 8374.4 |
181 | 2024-02-26 00:19:24 | viticulture | 4 | 148819 | 40 | 22.440 | 6631.9 |
180 | 2024-02-26 00:19:12 | viticulture | 5 | 164607 | 115 | 26.640 | 6178.9 |
179 | 2024-02-23 21:59:55 | viticulture | 2 | 86808 | 6 | 2.313 | 37530.5 |
178 | 2024-02-21 18:02:52 | viticulture | 4 | 148819 | 40 | 24.873 | 5983.2 |
177 | 2024-02-21 18:02:51 | viticulture | 4 | 148819 | 40 | 22.406 | 6641.9 |
176 | 2024-02-21 11:31:24 | viticulture | 5 | 164607 | 115 | 41.486 | 3967.8 |
175 | 2024-02-21 11:31:24 | viticulture | 4 | 148819 | 40 | 31.640 | 4703.5 |
174 | 2024-02-21 11:31:26 | viticulture | 2 | 86808 | 6 | 6.346 | 13679.2 |
173 | 2024-02-21 01:49:18 | viticulture | 1 | 49908 | 3 | 1.063 | 46950.1 |
172 | 2024-02-18 23:13:22 | viticulture | 1 | 49908 | 3 | 2.846 | 17536.2 |
171 | 2024-02-16 12:03:18 | viticulture | 1 | 49908 | 3 | 1.873 | 26646.0 |
170 | 2024-02-16 10:59:44 | viticulture | 1 | 49908 | 3 | 1.750 | 28518.9 |
169 | 2024-01-09 04:37:50 | viticulture | 1 | 49908 | 3 | 0.703 | 70992.9 |
168 | 2024-01-04 13:43:11 | viticulture | 2 | 86808 | 6 | 2.216 | 39173.3 |
167 | 2023-12-23 20:11:57 | viticulture | 3 | 121633 | 17 | 4.203 | 28939.6 |
166 | 2023-12-10 19:29:59 | viticulture | 1 | 49908 | 3 | 0.703 | 70992.9 |
165 | 2023-11-28 00:20:20 | viticulture | 4 | 148819 | 40 | 7.606 | 19566.0 |
164 | 2023-11-27 11:28:55 | viticulture | 5 | 164607 | 115 | 12.266 | 13419.8 |
163 | 2023-11-27 04:22:59 | viticulture | 1 | 49908 | 3 | 0.813 | 61387.5 |
162 | 2023-11-27 04:10:32 | viticulture | 5 | 164607 | 115 | 24.440 | 6735.1 |
161 | 2023-10-08 17:08:26 | viticulture | 2 | 86808 | 6 | 2.233 | 38875.1 |
160 | 2023-09-25 21:19:59 | viticulture | 1 | 49908 | 3 | 1.656 | 30137.7 |
159 | 2023-09-24 14:55:18 | viticulture | 5 | 164607 | 115 | 12.313 | 13368.6 |
158 | 2023-09-23 20:54:29 | viticulture | 3 | 121633 | 17 | 4.186 | 29057.1 |
157 | 2023-08-27 15:40:33 | viticulture | 4 | 148819 | 40 | 7.643 | 19471.3 |
156 | 2023-08-26 18:40:45 | viticulture | 5 | 164607 | 115 | 15.046 | 10940.2 |
155 | 2023-08-17 01:16:30 | viticulture | 1 | 49908 | 3 | 1.643 | 30376.1 |
154 | 2023-08-13 17:57:30 | viticulture | 1 | 49908 | 3 | 0.703 | 70992.9 |
153 | 2023-07-23 21:31:37 | viticulture | 1 | 49908 | 3 | 0.716 | 69703.9 |
152 | 2023-07-20 20:57:12 | viticulture | 2 | 86808 | 6 | 2.000 | 43404.0 |
151 | 2023-07-05 10:34:41 | viticulture | 5 | 164607 | 115 | 14.000 | 11757.6 |
150 | 2023-07-04 04:14:39 | viticulture | 3 | 121633 | 17 | 4.846 | 25099.7 |
149 | 2023-05-22 02:55:28 | viticulture | 5 | 164607 | 115 | 12.233 | 13456.0 |
148 | 2023-05-18 17:23:06 | viticulture | 5 | 164607 | 115 | 14.733 | 11172.7 |
147 | 2023-05-12 07:53:18 | viticulture | 4 | 148819 | 40 | 7.656 | 19438.2 |
146 | 2023-05-10 05:01:39 | viticulture | 5 | 164607 | 115 | 12.313 | 13368.6 |
145 | 2023-04-23 17:37:47 | viticulture | 1 | 49908 | 3 | 0.813 | 61387.5 |
144 | 2023-04-10 16:35:49 | viticulture | 1 | 49908 | 3 | 0.766 | 65154.0 |
143 | 2023-03-30 20:20:55 | viticulture | 2 | 86808 | 6 | 2.173 | 39948.5 |
142 | 2023-03-24 05:54:23 | viticulture | 3 | 121633 | 17 | 4.876 | 24945.2 |
141 | 2023-02-19 03:57:22 | viticulture | 4 | 148819 | 40 | 7.513 | 19808.2 |
140 | 2023-02-15 20:23:14 | viticulture | 1 | 49908 | 3 | 0.703 | 70992.9 |
139 | 2023-02-13 11:46:50 | viticulture | 5 | 164607 | 115 | 13.360 | 12320.9 |