History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pavements"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
315 | 2024-04-16 09:19:01 | pavements | 2 | 121436 | 11 | 4.876 | 24904.8 |
314 | 2024-04-14 23:27:34 | pavements | 2 | 121436 | 11 | 16.876 | 7195.8 |
313 | 2024-04-14 23:26:24 | pavements | 2 | 121436 | 11 | 4.656 | 26081.6 |
312 | 2024-04-14 23:25:16 | pavements | 1 | 81242 | 2 | 5.063 | 16046.2 |
311 | 2024-04-05 12:39:47 | pavements | 1 | 81242 | 2 | 1.716 | 47343.8 |
310 | 2024-04-01 09:45:45 | pavements | 1 | 81242 | 2 | 4.530 | 17934.2 |
309 | 2024-03-30 14:06:56 | pavements | 1 | 81242 | 2 | 1.423 | 57092.1 |
308 | 2024-03-28 20:05:55 | pavements | 1 | 81242 | 2 | 1.390 | 58447.5 |
307 | 2024-03-27 13:29:12 | pavements | 4 | 165329 | 431 | 15.686 | 10539.9 |
306 | 2024-03-27 13:26:05 | pavements | 3 | 148641 | 63 | 11.656 | 12752.3 |
305 | 2024-03-27 13:24:20 | pavements | 2 | 121436 | 11 | 8.466 | 14344.0 |
304 | 2024-03-26 06:35:08 | pavements | 2 | 121436 | 11 | 4.030 | 30133.0 |
303 | 2024-03-26 06:24:41 | pavements | 3 | 148641 | 63 | 7.846 | 18944.8 |
302 | 2024-03-24 13:06:02 | pavements | 4 | 165329 | 431 | 39.316 | 4205.1 |
301 | 2024-03-24 10:25:46 | pavements | 3 | 148641 | 63 | 10.063 | 14771.0 |
300 | 2024-03-23 10:44:31 | pavements | 3 | 148641 | 63 | 29.830 | 4982.9 |
299 | 2024-03-23 08:45:42 | pavements | 4 | 165329 | 431 | 31.063 | 5322.4 |
298 | 2024-03-22 16:57:32 | pavements | 4 | 165329 | 431 | 24.910 | 6637.1 |
297 | 2024-03-22 12:10:27 | pavements | 4 | 165329 | 431 | 29.426 | 5618.5 |
296 | 2024-03-22 12:10:36 | pavements | 3 | 148641 | 63 | 13.783 | 10784.4 |
295 | 2024-03-22 12:10:35 | pavements | 2 | 121436 | 11 | 12.670 | 9584.5 |
294 | 2024-03-22 11:42:35 | pavements | 1 | 81242 | 2 | 1.546 | 52549.8 |
293 | 2024-03-07 14:28:21 | pavements | 1 | 81242 | 2 | 1.373 | 59171.2 |
292 | 2024-03-06 05:49:25 | pavements | 1 | 81242 | 2 | 4.796 | 16939.5 |
291 | 2024-03-02 07:19:39 | pavements | 1 | 81242 | 2 | 2.796 | 29056.5 |
290 | 2024-02-27 12:37:27 | pavements | 1 | 81242 | 2 | 1.250 | 64993.6 |
289 | 2024-02-22 08:18:52 | pavements | 4 | 165329 | 431 | 39.250 | 4212.2 |
288 | 2024-02-22 08:08:15 | pavements | 3 | 148641 | 63 | 17.330 | 8577.1 |
287 | 2024-02-21 04:35:30 | pavements | 3 | 148641 | 63 | 7.940 | 18720.5 |
286 | 2024-02-20 16:35:20 | pavements | 4 | 165329 | 431 | 19.986 | 8272.2 |
285 | 2024-02-19 20:46:18 | pavements | 3 | 148641 | 63 | 8.296 | 17917.2 |
284 | 2024-02-18 12:43:15 | pavements | 4 | 165329 | 431 | 13.940 | 11860.0 |
283 | 2024-02-18 06:20:04 | pavements | 2 | 121436 | 11 | 13.516 | 8984.6 |
282 | 2024-02-18 03:27:05 | pavements | 4 | 165329 | 431 | 19.000 | 8701.5 |
281 | 2024-02-17 22:52:07 | pavements | 4 | 165329 | 431 | 12.656 | 13063.3 |
280 | 2024-02-17 22:52:08 | pavements | 3 | 148641 | 63 | 7.626 | 19491.3 |
279 | 2024-02-17 22:09:34 | pavements | 1 | 81242 | 2 | 3.280 | 24768.9 |
278 | 2024-02-02 01:02:05 | pavements | 1 | 81242 | 2 | 1.406 | 57782.4 |
277 | 2024-01-23 21:05:29 | pavements | 1 | 81242 | 2 | 1.296 | 62686.7 |
276 | 2024-01-15 02:43:09 | pavements | 1 | 81242 | 2 | 1.563 | 51978.2 |
275 | 2024-01-10 02:40:42 | pavements | 3 | 148641 | 63 | 6.436 | 23095.2 |
274 | 2023-12-24 07:56:26 | pavements | 4 | 165329 | 431 | 10.673 | 15490.4 |
273 | 2023-12-21 11:54:58 | pavements | 1 | 81242 | 2 | 1.263 | 64324.6 |
272 | 2023-11-17 22:22:11 | pavements | 1 | 81242 | 2 | 1.250 | 64993.6 |
271 | 2023-10-23 04:41:50 | pavements | 1 | 81242 | 2 | 1.423 | 57092.1 |
270 | 2023-10-19 07:54:03 | pavements | 3 | 148641 | 63 | 6.266 | 23721.8 |
269 | 2023-09-25 05:48:43 | pavements | 4 | 165329 | 431 | 11.076 | 14926.8 |
268 | 2023-09-04 06:48:45 | pavements | 1 | 81242 | 2 | 1.343 | 60492.9 |
267 | 2023-07-29 22:37:58 | pavements | 3 | 148641 | 63 | 6.906 | 21523.5 |
266 | 2023-07-20 08:41:02 | pavements | 1 | 81242 | 2 | 1.470 | 55266.7 |
265 | 2023-07-07 03:12:59 | pavements | 4 | 165329 | 431 | 10.830 | 15265.8 |
264 | 2023-06-21 16:16:34 | pavements | 1 | 81242 | 2 | 1.250 | 64993.6 |
263 | 2023-04-09 11:51:34 | pavements | 3 | 148641 | 63 | 6.983 | 21286.1 |
262 | 2023-03-28 13:06:54 | pavements | 4 | 165329 | 431 | 10.393 | 15907.7 |
261 | 2023-02-27 08:38:33 | pavements | 1 | 81242 | 2 | 1.233 | 65889.7 |
260 | 2023-01-18 12:36:54 | pavements | 3 | 148641 | 63 | 6.093 | 24395.4 |
259 | 2023-01-11 18:34:49 | pavements | 1 | 81242 | 2 | 1.266 | 64172.2 |
258 | 2023-01-01 06:21:18 | pavements | 1 | 81242 | 2 | 1.390 | 58447.5 |
257 | 2022-12-27 17:53:24 | pavements | 4 | 165329 | 431 | 12.313 | 13427.2 |
256 | 2022-12-24 16:50:41 | pavements | 4 | 165329 | 431 | 11.956 | 13828.1 |
255 | 2022-11-23 14:46:22 | pavements | 1 | 81242 | 2 | 1.376 | 59042.2 |
254 | 2022-11-19 21:28:18 | pavements | 4 | 165329 | 431 | 10.610 | 15582.4 |
253 | 2022-11-18 04:07:13 | pavements | 1 | 81242 | 2 | 1.246 | 65202.2 |
252 | 2022-11-17 06:35:21 | pavements | 4 | 165329 | 431 | 11.126 | 14859.7 |
251 | 2022-11-11 09:08:08 | pavements | 4 | 165329 | 431 | 12.250 | 13496.2 |
250 | 2022-11-08 21:09:01 | pavements | 4 | 165329 | 431 | 11.656 | 14184.0 |
249 | 2022-10-31 01:26:03 | pavements | 1 | 81242 | 2 | 1.236 | 65729.8 |
248 | 2022-10-30 08:04:11 | pavements | 3 | 148641 | 63 | 6.203 | 23962.8 |
247 | 2022-10-28 22:58:49 | pavements | 1 | 81242 | 2 | 1.220 | 66591.8 |
246 | 2022-10-24 17:41:12 | pavements | 4 | 165329 | 431 | 11.423 | 14473.3 |
245 | 2022-10-02 01:54:02 | pavements | 4 | 165329 | 431 | 10.206 | 16199.2 |
244 | 2022-08-27 00:42:43 | pavements | 4 | 165329 | 431 | 10.343 | 15984.6 |
243 | 2022-06-30 04:28:33 | pavements | 1 | 81242 | 2 | 1.440 | 56418.1 |
242 | 2022-06-18 00:19:44 | pavements | 1 | 81242 | 2 | 1.280 | 63470.3 |
241 | 2022-05-23 04:22:15 | pavements | 3 | 148641 | 63 | 7.046 | 21095.8 |
240 | 2022-03-03 04:08:57 | pavements | 1 | 81242 | 2 | 1.296 | 62686.7 |
239 | 2022-02-23 07:33:35 | pavements | 1 | 81242 | 2 | 1.266 | 64172.2 |
238 | 2022-02-21 03:39:57 | pavements | 1 | 81242 | 2 | 1.343 | 60492.9 |
237 | 2021-11-09 13:16:39 | pavements | 1 | 81242 | 2 | 1.360 | 59736.8 |
236 | 2021-08-06 12:46:28 | pavements | 1 | 81242 | 2 | 1.263 | 64324.6 |
235 | 2021-07-29 06:47:43 | pavements | 1 | 81242 | 2 | 1.356 | 59913.0 |
234 | 2021-07-03 10:47:37 | pavements | 1 | 81242 | 2 | 1.236 | 65729.8 |
233 | 2021-05-20 14:04:56 | pavements | 1 | 81242 | 2 | 1.280 | 63470.3 |
232 | 2021-05-02 11:39:45 | pavements | 1 | 81242 | 2 | 1.486 | 54671.6 |
231 | 2021-04-20 20:56:47 | pavements | 1 | 81242 | 2 | 1.453 | 55913.3 |
230 | 2021-03-23 12:44:28 | pavements | 1 | 81242 | 2 | 1.280 | 63470.3 |
229 | 2021-02-25 19:45:53 | pavements | 1 | 81242 | 2 | 1.280 | 63470.3 |
228 | 2021-02-25 01:34:33 | pavements | 1 | 81242 | 2 | 1.250 | 64993.6 |
227 | 2021-02-01 21:50:11 | pavements | 1 | 81242 | 2 | 1.346 | 60358.1 |
226 | 2021-01-30 05:23:56 | pavements | 1 | 81242 | 2 | 1.283 | 63321.9 |
225 | 2021-01-05 12:39:54 | pavements | 1 | 81242 | 2 | 1.453 | 55913.3 |
224 | 2020-11-19 04:12:47 | pavements | 1 | 81242 | 2 | 1.283 | 63321.9 |
223 | 2020-11-12 15:31:29 | pavements | 1 | 81242 | 2 | 1.233 | 65889.7 |
222 | 2020-11-10 01:26:36 | pavements | 1 | 81242 | 2 | 1.280 | 63470.3 |
221 | 2020-10-27 14:31:16 | pavements | 1 | 81242 | 2 | 1.250 | 64993.6 |
220 | 2020-07-26 20:13:37 | pavements | 1 | 81242 | 2 | 1.313 | 61875.1 |
219 | 2020-07-12 06:59:55 | pavements | 1 | 81242 | 2 | 1.393 | 58321.6 |
218 | 2020-04-24 14:32:55 | pavements | 1 | 81242 | 2 | 1.343 | 60492.9 |
217 | 2020-03-21 18:43:19 | pavements | 1 | 81242 | 2 | 1.280 | 63470.3 |
216 | 2020-02-29 14:38:06 | pavements | 1 | 81242 | 2 | 1.516 | 53589.7 |