History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fishways"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
288 | 2024-06-04 01:51:17 | fishways | 4 | 161609 | 373 | 58.880 | 2744.7 |
287 | 2024-06-04 01:50:32 | fishways | 3 | 146162 | 63 | 19.906 | 7342.6 |
286 | 2024-06-04 00:40:51 | fishways | 4 | 161609 | 373 | 41.516 | 3892.7 |
285 | 2024-06-03 20:38:53 | fishways | 4 | 161609 | 373 | 54.426 | 2969.3 |
284 | 2024-06-03 19:22:00 | fishways | 4 | 161609 | 373 | 12.610 | 12815.9 |
283 | 2024-06-03 17:51:35 | fishways | 2 | 121059 | 3 | 12.690 | 9539.7 |
282 | 2024-06-03 17:51:19 | fishways | 3 | 146162 | 63 | 27.520 | 5311.1 |
281 | 2024-06-03 17:51:14 | fishways | 4 | 161609 | 373 | 23.313 | 6932.1 |
280 | 2024-06-03 14:31:57 | fishways | 1 | 82945 | 2 | 1.516 | 54713.1 |
279 | 2024-05-16 05:26:53 | fishways | 2 | 121059 | 3 | 8.406 | 14401.5 |
278 | 2024-05-16 05:26:48 | fishways | 1 | 82945 | 2 | 3.280 | 25288.1 |
277 | 2024-05-15 12:27:52 | fishways | 3 | 146162 | 63 | 7.216 | 20255.3 |
276 | 2024-05-11 19:59:08 | fishways | 1 | 82945 | 2 | 3.200 | 25920.3 |
275 | 2024-05-11 16:35:26 | fishways | 4 | 161609 | 373 | 16.500 | 9794.5 |
274 | 2024-05-11 06:00:45 | fishways | 3 | 146162 | 63 | 23.626 | 6186.5 |
273 | 2024-05-09 10:18:03 | fishways | 3 | 146162 | 63 | 10.000 | 14616.2 |
272 | 2024-05-01 13:50:23 | fishways | 4 | 161609 | 373 | 20.423 | 7913.1 |
271 | 2024-05-01 12:52:55 | fishways | 4 | 161609 | 373 | 27.360 | 5906.8 |
270 | 2024-05-01 12:44:26 | fishways | 1 | 82945 | 2 | 1.466 | 56579.1 |
269 | 2024-05-01 12:44:23 | fishways | 2 | 121059 | 3 | 3.893 | 31096.6 |
268 | 2024-05-01 12:41:41 | fishways | 3 | 146162 | 63 | 19.470 | 7507.0 |
267 | 2024-04-29 11:29:20 | fishways | 1 | 82945 | 2 | 1.983 | 41828.0 |
266 | 2024-04-26 19:07:43 | fishways | 4 | 161609 | 373 | 17.610 | 9177.1 |
265 | 2024-04-26 15:57:48 | fishways | 3 | 146162 | 63 | 9.796 | 14920.6 |
264 | 2024-04-26 15:57:39 | fishways | 1 | 82945 | 2 | 2.796 | 29665.6 |
263 | 2024-04-26 15:57:13 | fishways | 2 | 121059 | 3 | 7.483 | 16177.9 |
262 | 2024-04-26 15:56:51 | fishways | 3 | 146162 | 63 | 7.453 | 19611.2 |
261 | 2024-04-26 15:55:37 | fishways | 4 | 161609 | 373 | 12.483 | 12946.3 |
260 | 2024-04-26 15:01:07 | fishways | 4 | 161609 | 373 | 12.890 | 12537.5 |
259 | 2024-04-26 12:21:18 | fishways | 4 | 161609 | 373 | 37.046 | 4362.4 |
258 | 2024-04-26 12:21:29 | fishways | 2 | 121059 | 3 | 11.546 | 10484.9 |
257 | 2024-04-26 12:21:20 | fishways | 3 | 146162 | 63 | 8.813 | 16584.8 |
256 | 2024-04-26 11:02:38 | fishways | 1 | 82945 | 2 | 1.580 | 52496.8 |
255 | 2024-04-05 18:31:00 | fishways | 1 | 82945 | 2 | 1.750 | 47397.1 |
254 | 2024-04-01 13:35:19 | fishways | 2 | 121059 | 3 | 11.126 | 10880.7 |
253 | 2024-04-01 10:48:12 | fishways | 3 | 146162 | 63 | 8.140 | 17956.0 |
252 | 2024-03-29 20:35:00 | fishways | 3 | 146162 | 63 | 18.910 | 7729.3 |
251 | 2024-03-29 20:34:59 | fishways | 2 | 121059 | 3 | 11.343 | 10672.6 |
250 | 2024-03-29 20:34:47 | fishways | 1 | 82945 | 2 | 3.093 | 26817.0 |
249 | 2024-03-28 23:25:13 | fishways | 2 | 121059 | 3 | 3.843 | 31501.2 |
248 | 2024-03-28 23:25:13 | fishways | 1 | 82945 | 2 | 1.450 | 57203.4 |
247 | 2024-03-15 05:30:10 | fishways | 2 | 121059 | 3 | 12.266 | 9869.5 |
246 | 2024-03-15 05:29:48 | fishways | 1 | 82945 | 2 | 1.610 | 51518.6 |
245 | 2024-03-13 16:12:06 | fishways | 4 | 161609 | 373 | 17.750 | 9104.7 |
244 | 2024-03-12 07:50:43 | fishways | 1 | 82945 | 2 | 1.610 | 51518.6 |
243 | 2024-03-10 20:07:30 | fishways | 4 | 161609 | 373 | 17.143 | 9427.1 |
242 | 2024-03-09 17:40:33 | fishways | 3 | 146162 | 63 | 9.140 | 15991.5 |
241 | 2024-03-08 12:59:35 | fishways | 4 | 161609 | 373 | 46.923 | 3444.1 |
240 | 2024-03-08 06:24:02 | fishways | 4 | 161609 | 373 | 24.733 | 6534.1 |
239 | 2024-03-07 18:44:34 | fishways | 4 | 161609 | 373 | 21.190 | 7626.7 |
238 | 2024-03-07 18:44:38 | fishways | 2 | 121059 | 3 | 6.406 | 18897.8 |
237 | 2024-03-07 11:48:40 | fishways | 3 | 146162 | 63 | 23.483 | 6224.2 |
236 | 2024-03-06 12:10:01 | fishways | 3 | 146162 | 63 | 20.936 | 6981.4 |
235 | 2024-03-06 00:48:49 | fishways | 3 | 146162 | 63 | 9.843 | 14849.3 |
234 | 2024-03-06 00:48:48 | fishways | 2 | 121059 | 3 | 4.076 | 29700.4 |
233 | 2024-03-06 00:48:44 | fishways | 1 | 82945 | 2 | 1.546 | 53651.4 |
232 | 2024-02-29 17:48:54 | fishways | 1 | 82945 | 2 | 1.466 | 56579.1 |
231 | 2024-02-04 16:12:40 | fishways | 1 | 82945 | 2 | 1.966 | 42189.7 |
230 | 2024-02-02 07:36:03 | fishways | 1 | 82945 | 2 | 1.233 | 67270.9 |
229 | 2024-01-23 01:24:52 | fishways | 4 | 161609 | 373 | 27.220 | 5937.1 |
228 | 2024-01-22 12:36:20 | fishways | 4 | 161609 | 373 | 24.626 | 6562.5 |
227 | 2024-01-11 07:24:40 | fishways | 4 | 161609 | 373 | 10.156 | 15912.7 |
226 | 2024-01-02 12:44:51 | fishways | 3 | 146162 | 63 | 7.500 | 19488.3 |
225 | 2024-01-02 12:44:48 | fishways | 2 | 121059 | 3 | 3.686 | 32842.9 |
224 | 2023-12-15 04:29:30 | fishways | 1 | 82945 | 2 | 1.266 | 65517.4 |
223 | 2023-12-08 14:50:37 | fishways | 3 | 146162 | 63 | 6.970 | 20970.2 |
222 | 2023-12-08 14:50:39 | fishways | 2 | 121059 | 3 | 3.656 | 33112.4 |
221 | 2023-12-04 20:48:45 | fishways | 4 | 161609 | 373 | 13.610 | 11874.3 |
220 | 2023-12-03 22:55:37 | fishways | 4 | 161609 | 373 | 12.610 | 12815.9 |
219 | 2023-11-28 03:18:01 | fishways | 4 | 161609 | 373 | 11.126 | 14525.3 |
218 | 2023-11-28 03:18:03 | fishways | 3 | 146162 | 63 | 7.283 | 20068.9 |
217 | 2023-11-28 03:18:04 | fishways | 2 | 121059 | 3 | 3.703 | 32692.1 |
216 | 2023-11-14 18:00:55 | fishways | 1 | 82945 | 2 | 1.233 | 67270.9 |
215 | 2023-11-10 15:33:25 | fishways | 1 | 82945 | 2 | 1.220 | 67987.7 |
214 | 2023-11-10 00:34:50 | fishways | 4 | 161609 | 373 | 10.283 | 15716.1 |
213 | 2023-11-02 05:19:45 | fishways | 4 | 161609 | 373 | 11.580 | 13955.9 |
212 | 2023-10-28 08:59:40 | fishways | 1 | 82945 | 2 | 1.233 | 67270.9 |
211 | 2023-10-27 14:28:36 | fishways | 1 | 82945 | 2 | 1.313 | 63172.1 |
210 | 2023-10-21 07:38:23 | fishways | 4 | 161609 | 373 | 10.300 | 15690.2 |
209 | 2023-10-17 03:39:32 | fishways | 1 | 82945 | 2 | 1.423 | 58288.8 |
208 | 2023-10-04 13:23:19 | fishways | 1 | 82945 | 2 | 1.250 | 66356.0 |
207 | 2023-10-02 13:25:34 | fishways | 1 | 82945 | 2 | 1.233 | 67270.9 |
206 | 2023-09-13 11:46:05 | fishways | 1 | 82945 | 2 | 1.250 | 66356.0 |
205 | 2023-08-01 21:34:31 | fishways | 4 | 161609 | 373 | 11.733 | 13773.9 |
204 | 2023-07-30 19:46:25 | fishways | 1 | 82945 | 2 | 1.343 | 61761.0 |
203 | 2023-05-28 23:48:43 | fishways | 1 | 82945 | 2 | 1.250 | 66356.0 |
202 | 2023-04-28 10:25:57 | fishways | 1 | 82945 | 2 | 2.780 | 29836.3 |
201 | 2023-04-10 15:44:21 | fishways | 4 | 161609 | 373 | 11.063 | 14608.1 |
200 | 2023-02-19 20:43:15 | fishways | 1 | 82945 | 2 | 1.250 | 66356.0 |
199 | 2023-01-26 03:36:55 | fishways | 1 | 82945 | 2 | 1.343 | 61761.0 |
198 | 2023-01-18 00:26:56 | fishways | 4 | 161609 | 373 | 9.953 | 16237.2 |
197 | 2022-12-18 02:50:18 | fishways | 1 | 82945 | 2 | 1.236 | 67107.6 |
196 | 2022-10-29 15:59:19 | fishways | 4 | 161609 | 373 | 10.610 | 15231.8 |
195 | 2022-09-16 14:57:13 | fishways | 1 | 82945 | 2 | 1.233 | 67270.9 |
194 | 2022-08-26 21:01:55 | fishways | 1 | 82945 | 2 | 1.360 | 60989.0 |
193 | 2022-06-22 07:18:14 | fishways | 4 | 161609 | 373 | 10.876 | 14859.2 |
192 | 2022-05-26 08:39:25 | fishways | 4 | 161609 | 373 | 10.110 | 15985.1 |
191 | 2022-04-30 02:15:40 | fishways | 1 | 82945 | 2 | 1.233 | 67270.9 |
190 | 2022-04-11 16:56:46 | fishways | 1 | 82945 | 2 | 1.626 | 51011.7 |
189 | 2022-01-11 21:11:02 | fishways | 1 | 82945 | 2 | 1.390 | 59672.7 |