History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"milepost"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
320 | 2024-05-31 06:26:45 | milepost | 1 | 82945 | 2 | 1.563 | 53067.8 |
319 | 2024-05-28 04:47:52 | milepost | 1 | 82945 | 2 | 6.940 | 11951.7 |
318 | 2024-05-28 04:45:53 | milepost | 1 | 82945 | 2 | 2.546 | 32578.6 |
317 | 2024-05-14 00:07:21 | milepost | 4 | 161609 | 412 | 21.953 | 7361.6 |
316 | 2024-05-11 18:42:33 | milepost | 1 | 82945 | 2 | 1.406 | 58993.6 |
315 | 2024-05-11 12:48:18 | milepost | 4 | 161609 | 412 | 27.250 | 5930.6 |
314 | 2024-05-10 21:36:52 | milepost | 4 | 161609 | 412 | 25.780 | 6268.8 |
313 | 2024-05-09 15:33:25 | milepost | 4 | 161609 | 412 | 44.753 | 3611.1 |
312 | 2024-05-05 00:40:30 | milepost | 3 | 146162 | 32 | 20.296 | 7201.5 |
311 | 2024-05-04 09:00:12 | milepost | 3 | 146162 | 32 | 10.983 | 13308.0 |
310 | 2024-05-04 09:00:16 | milepost | 2 | 121059 | 2 | 3.860 | 31362.4 |
309 | 2024-05-04 08:59:12 | milepost | 4 | 161609 | 412 | 14.050 | 11502.4 |
308 | 2024-05-04 08:57:52 | milepost | 2 | 121059 | 2 | 7.873 | 15376.5 |
307 | 2024-05-04 08:57:43 | milepost | 4 | 161609 | 412 | 15.406 | 10490.0 |
306 | 2024-05-04 08:57:56 | milepost | 1 | 82945 | 2 | 3.046 | 27230.8 |
305 | 2024-05-04 08:57:48 | milepost | 3 | 146162 | 32 | 9.173 | 15933.9 |
304 | 2024-05-01 00:10:54 | milepost | 2 | 121059 | 2 | 6.873 | 17613.7 |
303 | 2024-04-29 17:22:27 | milepost | 1 | 82945 | 2 | 1.546 | 53651.4 |
302 | 2024-04-29 17:21:55 | milepost | 3 | 146162 | 32 | 9.923 | 14729.6 |
301 | 2024-04-29 17:21:35 | milepost | 2 | 121059 | 2 | 4.203 | 28803.0 |
300 | 2024-04-29 12:35:26 | milepost | 1 | 82945 | 2 | 2.983 | 27805.9 |
299 | 2024-04-29 12:35:07 | milepost | 2 | 121059 | 2 | 3.280 | 36908.2 |
298 | 2024-04-28 12:46:30 | milepost | 2 | 121059 | 2 | 9.440 | 12824.0 |
297 | 2024-04-28 12:24:39 | milepost | 1 | 82945 | 2 | 1.470 | 56425.2 |
296 | 2024-04-10 21:17:22 | milepost | 4 | 161609 | 412 | 41.003 | 3941.4 |
295 | 2024-04-10 03:44:24 | milepost | 4 | 161609 | 412 | 15.563 | 10384.2 |
294 | 2024-04-07 18:17:10 | milepost | 4 | 161609 | 412 | 26.393 | 6123.2 |
293 | 2024-04-04 23:22:10 | milepost | 3 | 146162 | 32 | 20.016 | 7302.3 |
292 | 2024-04-04 06:26:51 | milepost | 4 | 161609 | 412 | 31.826 | 5077.9 |
291 | 2024-04-04 06:26:50 | milepost | 3 | 146162 | 32 | 15.816 | 9241.4 |
290 | 2024-04-04 06:26:31 | milepost | 4 | 161609 | 412 | 24.096 | 6706.9 |
289 | 2024-04-04 06:26:32 | milepost | 3 | 146162 | 32 | 13.003 | 11240.6 |
288 | 2024-04-04 06:26:39 | milepost | 2 | 121059 | 2 | 4.046 | 29920.7 |
287 | 2024-04-04 06:26:36 | milepost | 2 | 121059 | 2 | 4.203 | 28803.0 |
286 | 2024-04-04 06:26:24 | milepost | 1 | 82945 | 2 | 3.156 | 26281.7 |
285 | 2024-04-01 05:34:37 | milepost | 2 | 121059 | 2 | 4.313 | 28068.4 |
284 | 2024-03-29 06:59:18 | milepost | 1 | 82945 | 2 | 4.640 | 17876.1 |
283 | 2024-03-25 18:03:53 | milepost | 2 | 121059 | 2 | 6.203 | 19516.2 |
282 | 2024-03-19 17:28:10 | milepost | 2 | 121059 | 2 | 11.830 | 10233.2 |
281 | 2024-03-19 17:09:38 | milepost | 1 | 82945 | 2 | 1.390 | 59672.7 |
280 | 2024-03-11 02:29:16 | milepost | 2 | 121059 | 2 | 3.983 | 30393.9 |
279 | 2024-03-11 02:24:23 | milepost | 3 | 146162 | 32 | 7.846 | 18628.9 |
278 | 2024-03-10 20:53:23 | milepost | 4 | 161609 | 412 | 21.723 | 7439.5 |
277 | 2024-03-10 09:51:00 | milepost | 4 | 161609 | 412 | 21.140 | 7644.7 |
276 | 2024-03-10 09:49:56 | milepost | 1 | 82945 | 2 | 1.580 | 52496.8 |
275 | 2024-03-09 21:47:25 | milepost | 1 | 82945 | 2 | 3.313 | 25036.2 |
274 | 2024-03-02 09:00:37 | milepost | 4 | 161609 | 412 | 17.390 | 9293.2 |
273 | 2024-03-02 09:00:38 | milepost | 3 | 146162 | 32 | 7.983 | 18309.2 |
272 | 2024-03-02 09:00:40 | milepost | 2 | 121059 | 2 | 4.003 | 30242.1 |
271 | 2024-03-02 09:00:37 | milepost | 1 | 82945 | 2 | 1.546 | 53651.4 |
270 | 2024-02-28 19:24:31 | milepost | 2 | 121059 | 2 | 3.390 | 35710.6 |
269 | 2024-02-26 16:01:32 | milepost | 2 | 121059 | 2 | 4.250 | 28484.5 |
268 | 2024-02-26 16:01:33 | milepost | 1 | 82945 | 2 | 1.610 | 51518.6 |
267 | 2024-02-26 10:40:55 | milepost | 3 | 146162 | 32 | 7.170 | 20385.2 |
266 | 2024-02-25 08:13:23 | milepost | 1 | 82945 | 2 | 1.513 | 54821.5 |
265 | 2024-02-25 08:13:01 | milepost | 4 | 161609 | 412 | 13.983 | 11557.5 |
264 | 2024-02-25 08:12:46 | milepost | 3 | 146162 | 32 | 7.610 | 19206.6 |
263 | 2024-02-20 16:15:06 | milepost | 3 | 146162 | 32 | 9.453 | 15462.0 |
262 | 2024-02-12 00:38:46 | milepost | 2 | 121059 | 2 | 10.063 | 12030.1 |
261 | 2024-02-11 18:07:18 | milepost | 3 | 146162 | 32 | 24.483 | 5969.9 |
260 | 2024-02-08 09:37:43 | milepost | 3 | 146162 | 32 | 8.250 | 17716.6 |
259 | 2024-02-08 09:37:41 | milepost | 2 | 121059 | 2 | 4.050 | 29891.1 |
258 | 2024-02-08 09:17:19 | milepost | 1 | 82945 | 2 | 2.296 | 36125.9 |
257 | 2024-02-08 08:30:29 | milepost | 4 | 161609 | 412 | 28.576 | 5655.4 |
256 | 2024-02-06 20:09:06 | milepost | 4 | 161609 | 412 | 13.486 | 11983.5 |
255 | 2024-02-03 22:19:47 | milepost | 1 | 82945 | 2 | 1.423 | 58288.8 |
254 | 2024-01-31 15:37:28 | milepost | 1 | 82945 | 2 | 1.453 | 57085.3 |
253 | 2024-01-27 12:10:47 | milepost | 2 | 121059 | 2 | 4.233 | 28598.9 |
252 | 2024-01-25 22:28:43 | milepost | 1 | 82945 | 2 | 1.440 | 57600.7 |
251 | 2024-01-25 22:28:39 | milepost | 2 | 121059 | 2 | 3.953 | 30624.6 |
250 | 2024-01-25 22:28:35 | milepost | 3 | 146162 | 32 | 7.750 | 18859.6 |
249 | 2024-01-22 21:14:23 | milepost | 4 | 161609 | 412 | 28.580 | 5654.6 |
248 | 2024-01-17 05:20:13 | milepost | 4 | 161609 | 412 | 10.750 | 15033.4 |
247 | 2024-01-10 10:22:32 | milepost | 3 | 146162 | 32 | 7.720 | 18932.9 |
246 | 2023-12-05 10:40:40 | milepost | 2 | 121059 | 2 | 3.173 | 38152.9 |
245 | 2023-11-27 05:37:16 | milepost | 1 | 82945 | 2 | 1.296 | 64000.8 |
244 | 2023-11-22 13:37:03 | milepost | 4 | 161609 | 412 | 11.843 | 13646.0 |
243 | 2023-11-16 15:02:33 | milepost | 3 | 146162 | 32 | 6.266 | 23326.2 |
242 | 2023-10-27 05:33:41 | milepost | 4 | 161609 | 412 | 11.986 | 13483.1 |
241 | 2023-10-19 00:24:41 | milepost | 1 | 82945 | 2 | 1.610 | 51518.6 |
240 | 2023-09-12 10:30:48 | milepost | 1 | 82945 | 2 | 1.500 | 55296.7 |
239 | 2023-09-03 00:44:13 | milepost | 2 | 121059 | 2 | 3.390 | 35710.6 |
238 | 2023-08-17 12:34:33 | milepost | 3 | 146162 | 32 | 6.186 | 23627.9 |
237 | 2023-08-09 22:07:44 | milepost | 1 | 82945 | 2 | 1.420 | 58412.0 |
236 | 2023-08-08 22:58:48 | milepost | 1 | 82945 | 2 | 1.393 | 59544.1 |
235 | 2023-08-05 16:39:00 | milepost | 4 | 161609 | 412 | 10.733 | 15057.2 |
234 | 2023-08-04 12:53:01 | milepost | 1 | 82945 | 2 | 1.406 | 58993.6 |
233 | 2023-06-24 10:42:06 | milepost | 1 | 82945 | 2 | 1.250 | 66356.0 |
232 | 2023-06-08 06:36:48 | milepost | 1 | 82945 | 2 | 1.236 | 67107.6 |
231 | 2023-05-21 00:50:29 | milepost | 2 | 121059 | 2 | 3.483 | 34757.1 |
230 | 2023-05-06 11:39:58 | milepost | 1 | 82945 | 2 | 1.296 | 64000.8 |
229 | 2023-04-30 07:30:13 | milepost | 3 | 146162 | 32 | 6.483 | 22545.4 |
228 | 2023-04-16 14:03:32 | milepost | 4 | 161609 | 412 | 10.606 | 15237.5 |
227 | 2023-04-05 23:08:50 | milepost | 1 | 82945 | 2 | 1.906 | 43517.8 |
226 | 2023-03-19 15:21:57 | milepost | 1 | 82945 | 2 | 1.216 | 68211.3 |
225 | 2023-02-27 16:57:33 | milepost | 2 | 121059 | 2 | 3.186 | 37997.2 |
224 | 2023-02-02 15:45:22 | milepost | 1 | 82945 | 2 | 1.233 | 67270.9 |
223 | 2023-02-02 10:47:46 | milepost | 3 | 146162 | 32 | 6.030 | 24239.1 |
222 | 2023-01-30 06:39:55 | milepost | 1 | 82945 | 2 | 1.250 | 66356.0 |
221 | 2023-01-23 15:53:30 | milepost | 4 | 161609 | 412 | 10.470 | 15435.4 |