History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"byroads"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
296 | 2024-04-09 03:25:08 | byroads | 3 | 134027 | 182 | 14.936 | 8973.4 |
295 | 2024-04-09 03:25:07 | byroads | 2 | 107671 | 11 | 8.140 | 13227.4 |
294 | 2024-04-09 03:18:51 | byroads | 1 | 69583 | 3 | 1.296 | 53690.6 |
293 | 2024-03-10 08:18:37 | byroads | 2 | 107671 | 11 | 10.190 | 10566.3 |
292 | 2024-03-10 08:17:33 | byroads | 3 | 134027 | 182 | 6.906 | 19407.3 |
291 | 2024-03-09 22:51:52 | byroads | 3 | 134027 | 182 | 10.000 | 13402.7 |
290 | 2024-03-09 00:10:25 | byroads | 2 | 107671 | 11 | 10.046 | 10717.8 |
289 | 2024-03-09 00:10:22 | byroads | 3 | 134027 | 182 | 7.876 | 17017.1 |
288 | 2024-03-08 22:09:39 | byroads | 1 | 69583 | 3 | 1.263 | 55093.4 |
287 | 2024-03-05 10:00:12 | byroads | 2 | 107671 | 11 | 3.703 | 29076.7 |
286 | 2024-03-05 09:59:55 | byroads | 3 | 134027 | 182 | 8.033 | 16684.6 |
285 | 2024-03-04 14:46:00 | byroads | 3 | 134027 | 182 | 17.923 | 7477.9 |
284 | 2024-03-04 14:45:59 | byroads | 2 | 107671 | 11 | 7.203 | 14948.1 |
283 | 2024-02-02 20:30:10 | byroads | 1 | 69583 | 3 | 1.173 | 59320.5 |
282 | 2024-01-23 14:42:48 | byroads | 3 | 134027 | 182 | 7.330 | 18284.7 |
281 | 2024-01-09 11:23:00 | byroads | 3 | 134027 | 182 | 6.343 | 21129.9 |
280 | 2024-01-07 10:22:10 | byroads | 2 | 107671 | 11 | 2.966 | 36301.8 |
279 | 2023-12-31 00:05:52 | byroads | 1 | 69583 | 3 | 1.830 | 38023.5 |
278 | 2023-12-30 15:28:55 | byroads | 1 | 69583 | 3 | 1.423 | 48898.8 |
277 | 2023-12-05 09:58:37 | byroads | 1 | 69583 | 3 | 1.046 | 66522.9 |
276 | 2023-11-30 06:39:03 | byroads | 1 | 69583 | 3 | 1.203 | 57841.2 |
275 | 2023-11-26 16:43:12 | byroads | 1 | 69583 | 3 | 1.190 | 58473.1 |
274 | 2023-11-15 01:18:20 | byroads | 3 | 134027 | 182 | 7.796 | 17191.8 |
273 | 2023-11-13 02:40:58 | byroads | 1 | 69583 | 3 | 2.283 | 30478.8 |
272 | 2023-11-03 19:09:23 | byroads | 3 | 134027 | 182 | 6.403 | 20931.9 |
271 | 2023-10-29 05:42:45 | byroads | 1 | 69583 | 3 | 1.063 | 65459.1 |
270 | 2023-10-17 11:19:08 | byroads | 1 | 69583 | 3 | 1.500 | 46388.7 |
269 | 2023-09-28 05:56:26 | byroads | 1 | 69583 | 3 | 1.093 | 63662.4 |
268 | 2023-09-26 13:55:23 | byroads | 1 | 69583 | 3 | 1.063 | 65459.1 |
267 | 2023-09-12 14:06:06 | byroads | 1 | 69583 | 3 | 1.173 | 59320.5 |
266 | 2023-08-28 13:25:41 | byroads | 1 | 69583 | 3 | 1.153 | 60349.5 |
265 | 2023-08-11 06:35:18 | byroads | 3 | 134027 | 182 | 6.250 | 21444.3 |
264 | 2023-06-27 14:55:17 | byroads | 1 | 69583 | 3 | 1.030 | 67556.3 |
263 | 2023-05-07 20:45:26 | byroads | 1 | 69583 | 3 | 1.110 | 62687.4 |
262 | 2023-04-27 04:52:43 | byroads | 3 | 134027 | 182 | 5.436 | 24655.4 |
261 | 2023-04-08 19:15:40 | byroads | 1 | 69583 | 3 | 1.050 | 66269.5 |
260 | 2023-01-31 06:53:25 | byroads | 3 | 134027 | 182 | 6.283 | 21331.7 |
259 | 2023-01-30 02:41:49 | byroads | 1 | 69583 | 3 | 1.143 | 60877.5 |
258 | 2023-01-14 07:53:07 | byroads | 1 | 69583 | 3 | 1.016 | 68487.2 |
257 | 2022-11-28 02:56:24 | byroads | 1 | 69583 | 3 | 1.063 | 65459.1 |
256 | 2022-11-12 10:32:43 | byroads | 3 | 134027 | 182 | 6.000 | 22337.8 |
255 | 2022-09-19 13:01:12 | byroads | 1 | 69583 | 3 | 1.046 | 66522.9 |
254 | 2022-07-22 10:54:11 | byroads | 1 | 69583 | 3 | 1.016 | 68487.2 |
253 | 2022-05-17 04:08:29 | byroads | 1 | 69583 | 3 | 1.076 | 64668.2 |
252 | 2022-05-10 20:14:09 | byroads | 3 | 134027 | 182 | 6.410 | 20909.0 |
251 | 2022-03-26 03:31:05 | byroads | 1 | 69583 | 3 | 1.186 | 58670.3 |
250 | 2022-03-23 23:38:40 | byroads | 1 | 69583 | 3 | 1.280 | 54361.7 |
249 | 2022-01-26 00:32:04 | byroads | 1 | 69583 | 3 | 1.156 | 60192.9 |
248 | 2021-12-27 19:20:17 | byroads | 1 | 69583 | 3 | 1.186 | 58670.3 |
247 | 2021-11-15 20:47:06 | byroads | 1 | 69583 | 3 | 1.170 | 59472.6 |
246 | 2021-11-14 19:36:08 | byroads | 1 | 69583 | 3 | 1.203 | 57841.2 |
245 | 2021-11-13 21:29:11 | byroads | 1 | 69583 | 3 | 1.063 | 65459.1 |
244 | 2021-11-12 23:47:02 | byroads | 1 | 69583 | 3 | 1.173 | 59320.5 |
243 | 2021-11-11 16:33:14 | byroads | 1 | 69583 | 3 | 1.156 | 60192.9 |
242 | 2021-10-30 10:47:10 | byroads | 1 | 69583 | 3 | 1.326 | 52475.9 |
241 | 2021-10-12 15:50:18 | byroads | 1 | 69583 | 3 | 1.093 | 63662.4 |
240 | 2021-10-01 13:55:57 | byroads | 1 | 69583 | 3 | 1.060 | 65644.3 |
239 | 2021-09-29 10:39:47 | byroads | 1 | 69583 | 3 | 1.110 | 62687.4 |
238 | 2021-09-27 19:55:20 | byroads | 1 | 69583 | 3 | 1.033 | 67360.1 |
237 | 2021-09-26 19:29:41 | byroads | 1 | 69583 | 3 | 2.450 | 28401.2 |
236 | 2021-09-22 06:59:22 | byroads | 1 | 69583 | 3 | 1.110 | 62687.4 |
235 | 2021-07-11 13:59:22 | byroads | 1 | 69583 | 3 | 1.033 | 67360.1 |
234 | 2021-05-19 10:54:07 | byroads | 1 | 69583 | 3 | 1.046 | 66522.9 |
233 | 2021-04-07 15:23:31 | byroads | 1 | 69583 | 3 | 1.046 | 66522.9 |
232 | 2021-04-03 11:50:39 | byroads | 1 | 69583 | 3 | 1.046 | 66522.9 |
231 | 2021-03-21 22:58:20 | byroads | 1 | 69583 | 3 | 1.203 | 57841.2 |
230 | 2021-02-22 10:30:15 | byroads | 1 | 69583 | 3 | 1.140 | 61037.7 |
229 | 2021-01-03 17:46:43 | byroads | 1 | 69583 | 3 | 1.030 | 67556.3 |
228 | 2020-12-03 09:56:06 | byroads | 1 | 69583 | 3 | 1.096 | 63488.1 |
227 | 2020-10-27 20:50:26 | byroads | 1 | 69583 | 3 | 1.220 | 57035.2 |
226 | 2020-10-18 15:02:40 | byroads | 1 | 69583 | 3 | 1.250 | 55666.4 |
225 | 2020-10-15 18:07:09 | byroads | 1 | 69583 | 3 | 1.170 | 59472.6 |
224 | 2020-09-30 07:30:06 | byroads | 1 | 69583 | 3 | 1.013 | 68690.0 |
223 | 2020-08-31 10:57:38 | byroads | 1 | 69583 | 3 | 1.063 | 65459.1 |
222 | 2020-08-22 13:47:58 | byroads | 1 | 69583 | 3 | 1.153 | 60349.5 |
221 | 2020-08-18 06:05:51 | byroads | 1 | 69583 | 3 | 1.046 | 66522.9 |
220 | 2020-07-22 15:29:12 | byroads | 1 | 69583 | 3 | 1.330 | 52318.0 |
219 | 2020-05-18 03:49:02 | byroads | 1 | 69583 | 3 | 1.030 | 67556.3 |
218 | 2020-03-29 03:06:05 | byroads | 1 | 69583 | 3 | 1.046 | 66522.9 |
217 | 2020-03-26 21:59:33 | byroads | 1 | 69583 | 3 | 1.500 | 46388.7 |
216 | 2020-03-24 18:02:20 | byroads | 1 | 69583 | 3 | 1.233 | 56433.9 |
215 | 2020-03-23 14:38:32 | byroads | 1 | 69583 | 3 | 1.813 | 38380.0 |
214 | 2020-03-20 19:59:15 | byroads | 1 | 69583 | 3 | 1.063 | 65459.1 |
213 | 2020-02-29 23:31:55 | byroads | 1 | 69583 | 3 | 2.143 | 32469.9 |
212 | 2020-02-22 13:26:53 | byroads | 1 | 69583 | 3 | 1.250 | 55666.4 |
211 | 2020-02-20 10:22:46 | byroads | 1 | 69583 | 3 | 1.233 | 56433.9 |
210 | 2020-02-15 07:12:46 | byroads | 1 | 69583 | 3 | 1.216 | 57222.9 |
209 | 2020-02-11 15:08:57 | byroads | 1 | 69583 | 3 | 2.296 | 30306.2 |
208 | 2020-02-08 00:24:02 | byroads | 1 | 69583 | 3 | 3.920 | 17750.8 |
207 | 2020-02-07 19:36:19 | byroads | 1 | 69583 | 3 | 4.000 | 17395.8 |
206 | 2020-02-06 22:21:40 | byroads | 1 | 69583 | 3 | 1.186 | 58670.3 |
205 | 2020-02-03 20:37:24 | byroads | 1 | 69583 | 3 | 2.560 | 27180.9 |
204 | 2020-01-23 16:58:08 | byroads | 1 | 69583 | 3 | 2.716 | 25619.7 |
203 | 2020-01-18 04:58:21 | byroads | 1 | 69583 | 3 | 1.140 | 61037.7 |
202 | 2020-01-17 14:29:21 | byroads | 1 | 69583 | 3 | 2.623 | 26528.0 |
201 | 2020-01-14 18:55:43 | byroads | 1 | 69583 | 3 | 1.076 | 64668.2 |
200 | 2020-01-14 01:16:39 | byroads | 1 | 69583 | 3 | 1.153 | 60349.5 |
199 | 2020-01-07 23:56:48 | byroads | 1 | 69583 | 3 | 1.266 | 54962.9 |
198 | 2020-01-04 13:11:04 | byroads | 1 | 69583 | 3 | 1.063 | 65459.1 |
197 | 2019-12-27 18:52:07 | byroads | 1 | 69583 | 3 | 1.233 | 56433.9 |