History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bystreet"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
326 | 2024-04-27 13:31:17 | bystreet | 3 | 146162 | 24 | 11.810 | 12376.1 |
325 | 2024-04-27 06:53:15 | bystreet | 1 | 82945 | 2 | 1.813 | 45750.1 |
324 | 2024-04-26 03:41:56 | bystreet | 2 | 121059 | 3 | 3.563 | 33976.7 |
323 | 2024-04-26 03:40:56 | bystreet | 3 | 146162 | 24 | 7.563 | 19325.9 |
322 | 2024-04-25 20:53:34 | bystreet | 3 | 146162 | 24 | 12.330 | 11854.2 |
321 | 2024-04-25 20:53:38 | bystreet | 1 | 82945 | 2 | 4.190 | 19795.9 |
320 | 2024-04-25 20:53:30 | bystreet | 2 | 121059 | 3 | 8.876 | 13638.9 |
319 | 2024-04-08 16:07:51 | bystreet | 3 | 146162 | 24 | 25.766 | 5672.7 |
318 | 2024-04-08 16:07:49 | bystreet | 2 | 121059 | 3 | 4.156 | 29128.7 |
317 | 2024-04-07 21:27:21 | bystreet | 4 | 161609 | 350 | 25.750 | 6276.1 |
316 | 2024-04-07 17:19:38 | bystreet | 4 | 161609 | 350 | 31.610 | 5112.6 |
315 | 2024-04-06 01:01:20 | bystreet | 4 | 161609 | 350 | 25.783 | 6268.0 |
314 | 2024-04-05 15:05:01 | bystreet | 4 | 161609 | 350 | 12.923 | 12505.5 |
313 | 2024-04-05 01:44:54 | bystreet | 4 | 161609 | 350 | 35.080 | 4606.9 |
312 | 2024-04-05 01:44:33 | bystreet | 4 | 161609 | 350 | 40.283 | 4011.8 |
311 | 2024-04-05 01:44:53 | bystreet | 3 | 146162 | 24 | 14.846 | 9845.2 |
310 | 2024-04-05 01:44:48 | bystreet | 2 | 121059 | 3 | 4.610 | 26260.1 |
309 | 2024-04-05 01:44:31 | bystreet | 3 | 146162 | 24 | 21.063 | 6939.3 |
308 | 2024-04-05 01:44:46 | bystreet | 1 | 82945 | 2 | 3.156 | 26281.7 |
307 | 2024-04-05 01:44:36 | bystreet | 1 | 82945 | 2 | 4.953 | 16746.4 |
306 | 2024-04-05 01:44:35 | bystreet | 2 | 121059 | 3 | 4.826 | 25084.7 |
305 | 2024-04-01 03:49:44 | bystreet | 2 | 121059 | 3 | 9.516 | 12721.6 |
304 | 2024-04-01 03:49:08 | bystreet | 2 | 121059 | 3 | 9.046 | 13382.6 |
303 | 2024-03-30 01:22:31 | bystreet | 1 | 82945 | 2 | 4.876 | 17010.9 |
302 | 2024-03-05 23:13:03 | bystreet | 1 | 82945 | 2 | 3.576 | 23194.9 |
301 | 2024-03-05 03:13:33 | bystreet | 3 | 146162 | 24 | 10.500 | 13920.2 |
300 | 2024-03-05 03:13:34 | bystreet | 2 | 121059 | 3 | 4.266 | 28377.6 |
299 | 2024-03-05 03:13:24 | bystreet | 1 | 82945 | 2 | 1.653 | 50178.5 |
298 | 2024-03-05 03:09:27 | bystreet | 4 | 161609 | 350 | 22.296 | 7248.3 |
297 | 2024-03-04 07:43:36 | bystreet | 4 | 161609 | 350 | 12.596 | 12830.2 |
296 | 2024-03-01 20:54:21 | bystreet | 4 | 161609 | 350 | 41.126 | 3929.6 |
295 | 2024-03-01 20:54:18 | bystreet | 3 | 146162 | 24 | 24.066 | 6073.4 |
294 | 2024-03-01 19:59:23 | bystreet | 4 | 161609 | 350 | 36.580 | 4418.0 |
293 | 2024-03-01 19:59:25 | bystreet | 2 | 121059 | 3 | 12.750 | 9494.8 |
292 | 2024-03-01 19:55:56 | bystreet | 3 | 146162 | 24 | 8.593 | 17009.4 |
291 | 2024-03-01 19:55:47 | bystreet | 1 | 82945 | 2 | 1.560 | 53169.9 |
290 | 2024-02-28 13:36:43 | bystreet | 1 | 82945 | 2 | 2.983 | 27805.9 |
289 | 2024-01-14 18:01:46 | bystreet | 1 | 82945 | 2 | 1.203 | 68948.5 |
288 | 2023-12-28 06:58:39 | bystreet | 1 | 82945 | 2 | 1.296 | 64000.8 |
287 | 2023-12-04 22:57:33 | bystreet | 1 | 82945 | 2 | 1.310 | 63316.8 |
286 | 2023-12-04 07:58:33 | bystreet | 2 | 121059 | 3 | 4.033 | 30017.1 |
285 | 2023-11-20 08:42:49 | bystreet | 1 | 82945 | 2 | 1.423 | 58288.8 |
284 | 2023-11-08 20:48:00 | bystreet | 1 | 82945 | 2 | 1.436 | 57761.1 |
283 | 2023-10-13 00:46:16 | bystreet | 1 | 82945 | 2 | 1.236 | 67107.6 |
282 | 2023-10-08 18:48:21 | bystreet | 1 | 82945 | 2 | 1.233 | 67270.9 |
281 | 2023-09-14 12:55:35 | bystreet | 1 | 82945 | 2 | 1.250 | 66356.0 |
280 | 2023-09-01 23:37:42 | bystreet | 2 | 121059 | 3 | 3.330 | 36354.1 |
279 | 2023-08-28 01:03:43 | bystreet | 1 | 82945 | 2 | 1.390 | 59672.7 |
278 | 2023-06-09 11:44:00 | bystreet | 1 | 82945 | 2 | 1.216 | 68211.3 |
277 | 2023-05-30 19:52:53 | bystreet | 1 | 82945 | 2 | 1.313 | 63172.1 |
276 | 2023-05-18 16:46:19 | bystreet | 2 | 121059 | 3 | 3.420 | 35397.4 |
275 | 2023-05-12 17:21:47 | bystreet | 1 | 82945 | 2 | 1.376 | 60279.8 |
274 | 2023-04-03 21:46:51 | bystreet | 1 | 82945 | 2 | 2.876 | 28840.4 |
273 | 2023-03-24 09:31:50 | bystreet | 1 | 82945 | 2 | 1.220 | 67987.7 |
272 | 2023-02-22 07:45:56 | bystreet | 2 | 121059 | 3 | 3.343 | 36212.7 |
271 | 2023-01-31 13:27:33 | bystreet | 1 | 82945 | 2 | 1.343 | 61761.0 |
270 | 2023-01-27 08:47:33 | bystreet | 1 | 82945 | 2 | 1.313 | 63172.1 |
269 | 2023-01-10 03:05:05 | bystreet | 1 | 82945 | 2 | 1.203 | 68948.5 |
268 | 2023-01-03 04:36:35 | bystreet | 1 | 82945 | 2 | 2.750 | 30161.8 |
267 | 2022-12-02 22:08:16 | bystreet | 2 | 121059 | 3 | 2.986 | 40542.2 |
266 | 2022-11-21 19:43:33 | bystreet | 1 | 82945 | 2 | 1.450 | 57203.4 |
265 | 2022-10-13 15:12:15 | bystreet | 1 | 82945 | 2 | 1.250 | 66356.0 |
264 | 2022-09-25 15:53:46 | bystreet | 1 | 82945 | 2 | 1.236 | 67107.6 |
263 | 2022-07-10 05:21:23 | bystreet | 2 | 121059 | 3 | 3.156 | 38358.4 |
262 | 2022-06-22 03:29:08 | bystreet | 1 | 82945 | 2 | 1.373 | 60411.5 |
261 | 2022-06-04 01:38:12 | bystreet | 1 | 82945 | 2 | 1.203 | 68948.5 |
260 | 2022-05-05 14:04:57 | bystreet | 1 | 82945 | 2 | 1.346 | 61623.3 |
259 | 2022-01-01 19:44:25 | bystreet | 1 | 82945 | 2 | 1.610 | 51518.6 |
258 | 2021-09-12 05:59:16 | bystreet | 1 | 82945 | 2 | 1.233 | 67270.9 |
257 | 2021-09-06 10:03:02 | bystreet | 1 | 82945 | 2 | 1.326 | 62552.8 |
256 | 2021-08-21 17:07:29 | bystreet | 1 | 82945 | 2 | 1.203 | 68948.5 |
255 | 2021-07-14 18:20:18 | bystreet | 1 | 82945 | 2 | 1.470 | 56425.2 |
254 | 2021-07-07 14:37:10 | bystreet | 1 | 82945 | 2 | 1.330 | 62364.7 |
253 | 2021-05-29 11:03:21 | bystreet | 1 | 82945 | 2 | 1.233 | 67270.9 |
252 | 2021-05-23 11:23:42 | bystreet | 1 | 82945 | 2 | 1.470 | 56425.2 |
251 | 2021-05-21 20:18:56 | bystreet | 1 | 82945 | 2 | 1.373 | 60411.5 |
250 | 2021-04-06 05:19:14 | bystreet | 1 | 82945 | 2 | 1.436 | 57761.1 |
249 | 2021-02-27 02:00:47 | bystreet | 1 | 82945 | 2 | 1.373 | 60411.5 |
248 | 2021-01-31 06:53:47 | bystreet | 1 | 82945 | 2 | 1.406 | 58993.6 |
247 | 2020-12-09 14:21:56 | bystreet | 1 | 82945 | 2 | 1.266 | 65517.4 |
246 | 2020-11-01 11:29:51 | bystreet | 1 | 82945 | 2 | 1.313 | 63172.1 |
245 | 2020-10-31 12:53:27 | bystreet | 1 | 82945 | 2 | 2.390 | 34705.0 |
244 | 2020-10-23 20:45:00 | bystreet | 1 | 82945 | 2 | 1.296 | 64000.8 |
243 | 2020-10-13 09:54:58 | bystreet | 1 | 82945 | 2 | 1.266 | 65517.4 |
242 | 2020-06-10 11:49:16 | bystreet | 1 | 82945 | 2 | 1.296 | 64000.8 |
241 | 2020-03-28 10:30:07 | bystreet | 1 | 82945 | 2 | 1.516 | 54713.1 |
240 | 2020-03-23 05:39:16 | bystreet | 1 | 82945 | 2 | 1.313 | 63172.1 |
239 | 2020-03-08 22:25:13 | bystreet | 1 | 82945 | 2 | 1.376 | 60279.8 |
238 | 2020-02-11 11:44:32 | bystreet | 1 | 82945 | 2 | 3.283 | 25265.0 |
237 | 2020-02-05 19:55:35 | bystreet | 1 | 82945 | 2 | 3.093 | 26817.0 |
236 | 2020-02-02 11:41:36 | bystreet | 1 | 82945 | 2 | 3.283 | 25265.0 |
235 | 2020-01-31 15:18:48 | bystreet | 1 | 82945 | 2 | 1.593 | 52068.4 |
234 | 2020-01-28 06:46:07 | bystreet | 1 | 82945 | 2 | 1.423 | 58288.8 |
233 | 2020-01-19 22:40:58 | bystreet | 1 | 82945 | 2 | 3.140 | 26415.6 |
232 | 2020-01-15 03:25:02 | bystreet | 1 | 82945 | 2 | 1.516 | 54713.1 |
231 | 2020-01-02 20:18:11 | bystreet | 1 | 82945 | 2 | 1.406 | 58993.6 |
230 | 2019-12-31 19:51:53 | bystreet | 1 | 82945 | 2 | 1.530 | 54212.4 |
229 | 2019-11-27 06:17:59 | bystreet | 1 | 82945 | 2 | 1.423 | 58288.8 |
228 | 2019-08-25 13:14:36 | bystreet | 1 | 82945 | 2 | 1.300 | 63803.8 |
227 | 2019-05-13 07:36:29 | bystreet | 1 | 82945 | 2 | 1.440 | 57600.7 |