History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pathogens"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
368 | 2025-05-18 15:20:13 | pathogens | 1 | 81242 | 5 | 3.080 | 26377.3 |
367 | 2025-05-14 03:50:37 | pathogens | 1 | 81242 | 5 | 8.966 | 9061.1 |
366 | 2025-05-12 16:07:59 | pathogens | 1 | 81242 | 5 | 4.326 | 18779.9 |
365 | 2025-05-01 19:29:23 | pathogens | 1 | 81242 | 5 | 3.580 | 22693.3 |
364 | 2025-04-23 06:58:21 | pathogens | 1 | 81242 | 5 | 9.360 | 8679.7 |
363 | 2025-04-18 14:58:01 | pathogens | 1 | 81242 | 5 | 3.266 | 24875.1 |
362 | 2025-04-18 00:34:48 | pathogens | 1 | 81242 | 5 | 6.940 | 11706.3 |
361 | 2025-04-09 06:08:50 | pathogens | 1 | 81242 | 5 | 6.750 | 12035.9 |
360 | 2025-04-02 11:37:19 | pathogens | 1 | 81242 | 5 | 3.203 | 25364.3 |
359 | 2025-03-20 17:22:37 | pathogens | 1 | 81242 | 5 | 9.110 | 8917.9 |
358 | 2025-03-10 13:37:36 | pathogens | 1 | 81242 | 5 | 4.880 | 16648.0 |
357 | 2025-03-09 00:40:21 | pathogens | 1 | 81242 | 5 | 6.516 | 12468.1 |
356 | 2025-03-04 21:42:22 | pathogens | 3 | 148641 | 36 | 54.336 | 2735.6 |
355 | 2025-03-01 19:04:12 | pathogens | 3 | 148641 | 36 | 32.660 | 4551.2 |
354 | 2025-02-28 23:59:20 | pathogens | 1 | 81242 | 5 | 6.890 | 11791.3 |
353 | 2025-02-28 15:37:51 | pathogens | 3 | 148641 | 36 | 35.910 | 4139.3 |
352 | 2025-02-28 15:37:44 | pathogens | 3 | 148641 | 36 | 38.610 | 3849.8 |
351 | 2025-02-28 15:37:34 | pathogens | 2 | 121436 | 8 | 18.076 | 6718.1 |
350 | 2025-02-28 15:35:56 | pathogens | 1 | 81242 | 5 | 5.673 | 14320.8 |
349 | 2025-02-18 01:06:10 | pathogens | 3 | 148641 | 36 | 31.486 | 4720.9 |
348 | 2025-02-18 01:06:10 | pathogens | 2 | 121436 | 8 | 13.580 | 8942.3 |
347 | 2025-02-06 04:32:58 | pathogens | 1 | 81242 | 5 | 5.736 | 14163.5 |
346 | 2025-02-05 18:28:51 | pathogens | 1 | 81242 | 5 | 3.640 | 22319.2 |
345 | 2025-01-27 08:56:07 | pathogens | 3 | 148641 | 36 | 47.750 | 3112.9 |
344 | 2025-01-27 08:56:07 | pathogens | 2 | 121436 | 8 | 14.920 | 8139.1 |
343 | 2025-01-27 08:53:56 | pathogens | 1 | 81242 | 5 | 6.000 | 13540.3 |
342 | 2025-01-24 22:21:40 | pathogens | 1 | 81242 | 5 | 1.423 | 57092.1 |
341 | 2025-01-08 00:35:48 | pathogens | 3 | 148641 | 36 | 38.096 | 3901.7 |
340 | 2025-01-06 20:19:32 | pathogens | 3 | 148641 | 36 | 33.876 | 4387.8 |
339 | 2025-01-05 03:00:45 | pathogens | 1 | 81242 | 5 | 7.466 | 10881.6 |
338 | 2025-01-03 19:07:17 | pathogens | 1 | 81242 | 5 | 5.203 | 15614.5 |
337 | 2024-12-27 18:34:53 | pathogens | 1 | 81242 | 5 | 1.470 | 55266.7 |
336 | 2024-12-26 21:14:09 | pathogens | 3 | 148641 | 36 | 41.003 | 3625.1 |
335 | 2024-12-16 18:36:46 | pathogens | 3 | 148641 | 36 | 42.860 | 3468.1 |
334 | 2024-12-16 18:36:46 | pathogens | 2 | 121436 | 8 | 14.970 | 8112.0 |
333 | 2024-12-16 18:35:12 | pathogens | 1 | 81242 | 5 | 7.810 | 10402.3 |
332 | 2024-12-06 18:16:48 | pathogens | 4 | 165329 | 311 | 15.456 | 10696.8 |
331 | 2024-12-06 13:05:46 | pathogens | 4 | 165329 | 311 | 93.723 | 1764.0 |
330 | 2024-12-06 07:10:35 | pathogens | 4 | 165329 | 311 | 11.800 | 14010.9 |
329 | 2024-12-06 02:36:38 | pathogens | 1 | 81242 | 5 | 1.423 | 57092.1 |
328 | 2024-12-02 15:46:11 | pathogens | 1 | 81242 | 5 | 6.673 | 12174.7 |
327 | 2024-11-23 14:37:37 | pathogens | 3 | 148641 | 36 | 18.250 | 8144.7 |
326 | 2024-11-23 14:37:35 | pathogens | 2 | 121436 | 8 | 10.140 | 11975.9 |
325 | 2024-11-23 14:35:19 | pathogens | 1 | 81242 | 5 | 3.343 | 24302.1 |
324 | 2024-11-09 15:00:54 | pathogens | 1 | 81242 | 5 | 3.860 | 21047.2 |
323 | 2024-11-05 05:11:15 | pathogens | 3 | 148641 | 36 | 27.426 | 5419.7 |
322 | 2024-11-05 05:11:14 | pathogens | 2 | 121436 | 8 | 18.550 | 6546.4 |
321 | 2024-11-05 00:49:51 | pathogens | 3 | 148641 | 36 | 31.140 | 4773.3 |
320 | 2024-11-05 00:49:48 | pathogens | 2 | 121436 | 8 | 16.656 | 7290.8 |
319 | 2024-11-05 00:48:23 | pathogens | 1 | 81242 | 5 | 6.653 | 12211.3 |
318 | 2024-11-03 09:33:43 | pathogens | 4 | 165329 | 311 | 78.803 | 2098.0 |
317 | 2024-11-03 08:52:39 | pathogens | 4 | 165329 | 311 | 60.503 | 2732.6 |
316 | 2024-10-22 03:34:32 | pathogens | 1 | 81242 | 5 | 5.860 | 13863.8 |
315 | 2024-10-13 23:27:51 | pathogens | 1 | 81242 | 5 | 5.843 | 13904.2 |
314 | 2024-10-10 10:34:43 | pathogens | 3 | 148641 | 36 | 19.516 | 7616.4 |
313 | 2024-10-08 23:12:41 | pathogens | 1 | 81242 | 5 | 7.076 | 11481.3 |
312 | 2024-10-02 13:51:02 | pathogens | 3 | 148641 | 36 | 48.926 | 3038.1 |
311 | 2024-10-02 11:43:30 | pathogens | 3 | 148641 | 36 | 74.770 | 1988.0 |
310 | 2024-10-02 11:43:31 | pathogens | 2 | 121436 | 8 | 28.720 | 4228.3 |
309 | 2024-10-02 11:41:41 | pathogens | 1 | 81242 | 5 | 6.860 | 11842.9 |
308 | 2024-10-01 03:45:48 | pathogens | 4 | 165329 | 311 | 50.316 | 3285.8 |
307 | 2024-09-21 00:55:35 | pathogens | 4 | 165329 | 311 | 54.880 | 3012.6 |
306 | 2024-09-12 13:41:11 | pathogens | 4 | 165329 | 311 | 50.363 | 3282.7 |
305 | 2024-09-04 12:44:42 | pathogens | 4 | 165329 | 311 | 124.226 | 1330.9 |
304 | 2024-09-04 12:34:50 | pathogens | 1 | 81242 | 5 | 13.860 | 5861.6 |
303 | 2024-09-03 11:52:12 | pathogens | 4 | 165329 | 311 | 104.646 | 1579.9 |
302 | 2024-08-25 16:46:51 | pathogens | 1 | 81242 | 5 | 4.123 | 19704.6 |
301 | 2024-08-24 23:38:01 | pathogens | 4 | 165329 | 311 | 88.910 | 1859.5 |
300 | 2024-08-23 11:45:55 | pathogens | 1 | 81242 | 5 | 9.296 | 8739.5 |
299 | 2024-08-21 20:54:57 | pathogens | 4 | 165329 | 311 | 99.503 | 1661.5 |
298 | 2024-08-15 07:24:05 | pathogens | 1 | 81242 | 5 | 11.220 | 7240.8 |
297 | 2024-08-05 09:27:17 | pathogens | 2 | 121436 | 8 | 7.110 | 17079.6 |
296 | 2024-08-05 09:20:00 | pathogens | 1 | 81242 | 5 | 6.750 | 12035.9 |
295 | 2024-08-02 18:14:29 | pathogens | 4 | 165329 | 311 | 46.613 | 3546.8 |
294 | 2024-07-29 18:52:21 | pathogens | 1 | 81242 | 5 | 5.276 | 15398.4 |
293 | 2024-07-25 19:40:21 | pathogens | 1 | 81242 | 5 | 6.966 | 11662.6 |
292 | 2024-07-19 18:07:11 | pathogens | 3 | 148641 | 36 | 16.953 | 8767.8 |
291 | 2024-07-16 19:39:51 | pathogens | 1 | 81242 | 5 | 2.596 | 31295.1 |
290 | 2024-07-16 07:48:41 | pathogens | 3 | 148641 | 36 | 30.470 | 4878.3 |
289 | 2024-07-13 21:16:59 | pathogens | 3 | 148641 | 36 | 41.783 | 3557.5 |
288 | 2024-07-13 09:48:38 | pathogens | 3 | 148641 | 36 | 13.970 | 10640.0 |
287 | 2024-07-13 09:14:39 | pathogens | 4 | 165329 | 311 | 41.210 | 4011.9 |
286 | 2024-07-13 09:14:34 | pathogens | 3 | 148641 | 36 | 15.536 | 9567.5 |
285 | 2024-07-13 09:14:30 | pathogens | 2 | 121436 | 8 | 16.863 | 7201.3 |
284 | 2024-07-13 09:09:14 | pathogens | 1 | 81242 | 5 | 6.986 | 11629.3 |
283 | 2024-07-13 06:51:01 | pathogens | 4 | 165329 | 311 | 55.880 | 2958.6 |
282 | 2024-07-13 05:18:35 | pathogens | 4 | 165329 | 311 | 32.826 | 5036.5 |
281 | 2024-07-13 05:18:37 | pathogens | 3 | 148641 | 36 | 18.923 | 7855.0 |
280 | 2024-07-13 05:18:40 | pathogens | 2 | 121436 | 8 | 12.750 | 9524.4 |
279 | 2024-07-13 05:17:35 | pathogens | 1 | 81242 | 5 | 7.860 | 10336.1 |
278 | 2024-07-06 14:27:34 | pathogens | 1 | 81242 | 5 | 5.516 | 14728.4 |
277 | 2024-07-06 13:59:15 | pathogens | 1 | 81242 | 5 | 5.610 | 14481.6 |
276 | 2024-07-04 16:36:39 | pathogens | 2 | 121436 | 8 | 18.440 | 6585.5 |
275 | 2024-07-04 16:36:32 | pathogens | 3 | 148641 | 36 | 17.470 | 8508.4 |
274 | 2024-07-04 16:35:25 | pathogens | 1 | 81242 | 5 | 2.656 | 30588.1 |
273 | 2024-06-16 00:06:02 | pathogens | 4 | 165329 | 311 | 89.030 | 1857.0 |
272 | 2024-06-13 13:18:25 | pathogens | 4 | 165329 | 311 | 43.643 | 3788.2 |
271 | 2024-06-12 11:03:26 | pathogens | 4 | 165329 | 311 | 36.830 | 4489.0 |
270 | 2024-06-09 21:02:59 | pathogens | 4 | 165329 | 311 | 69.396 | 2382.4 |
269 | 2024-06-09 16:02:07 | pathogens | 4 | 165329 | 311 | 82.270 | 2009.6 |