History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bacterial"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
429 | 2024-06-02 15:06:30 | bacterial | 1 | 81242 | 5 | 4.126 | 19690.3 |
428 | 2024-06-02 11:44:34 | bacterial | 1 | 81242 | 5 | 6.126 | 13261.8 |
427 | 2024-05-13 18:32:39 | bacterial | 1 | 81242 | 5 | 3.250 | 24997.5 |
426 | 2024-05-12 00:12:45 | bacterial | 1 | 81242 | 5 | 4.643 | 17497.7 |
425 | 2024-05-05 02:54:50 | bacterial | 2 | 121436 | 13 | 3.420 | 35507.6 |
424 | 2024-04-28 23:03:51 | bacterial | 1 | 81242 | 5 | 1.483 | 54782.2 |
423 | 2024-04-17 12:50:37 | bacterial | 1 | 81242 | 5 | 1.406 | 57782.4 |
422 | 2024-04-13 12:29:36 | bacterial | 1 | 81242 | 5 | 2.936 | 27671.0 |
421 | 2024-04-11 07:01:37 | bacterial | 1 | 81242 | 5 | 1.250 | 64993.6 |
420 | 2024-04-08 10:03:45 | bacterial | 3 | 148641 | 63 | 25.753 | 5771.8 |
419 | 2024-04-08 10:02:54 | bacterial | 3 | 148641 | 63 | 8.970 | 16570.9 |
418 | 2024-04-08 05:56:15 | bacterial | 1 | 81242 | 5 | 1.516 | 53589.7 |
417 | 2024-03-29 19:35:41 | bacterial | 4 | 165329 | 367 | 39.376 | 4198.7 |
416 | 2024-03-29 19:35:41 | bacterial | 3 | 148641 | 63 | 20.626 | 7206.5 |
415 | 2024-03-29 14:35:01 | bacterial | 4 | 165329 | 367 | 23.436 | 7054.5 |
414 | 2024-03-29 14:13:51 | bacterial | 4 | 165329 | 367 | 29.800 | 5548.0 |
413 | 2024-03-29 14:13:51 | bacterial | 3 | 148641 | 63 | 26.143 | 5685.7 |
412 | 2024-03-29 14:13:55 | bacterial | 2 | 121436 | 13 | 11.890 | 10213.3 |
411 | 2024-03-29 13:53:46 | bacterial | 1 | 81242 | 5 | 3.080 | 26377.3 |
410 | 2024-03-26 16:25:49 | bacterial | 1 | 81242 | 5 | 2.813 | 28880.9 |
409 | 2024-03-14 10:28:50 | bacterial | 1 | 81242 | 5 | 1.470 | 55266.7 |
408 | 2024-03-07 05:33:06 | bacterial | 1 | 81242 | 5 | 1.436 | 56575.2 |
407 | 2024-03-06 03:05:40 | bacterial | 1 | 81242 | 5 | 1.470 | 55266.7 |
406 | 2024-03-01 09:17:49 | bacterial | 1 | 81242 | 5 | 2.953 | 27511.7 |
405 | 2024-02-27 14:01:15 | bacterial | 1 | 81242 | 5 | 1.283 | 63321.9 |
404 | 2024-02-10 15:44:05 | bacterial | 1 | 81242 | 5 | 1.580 | 51419.0 |
403 | 2024-01-29 05:51:26 | bacterial | 1 | 81242 | 5 | 1.436 | 56575.2 |
402 | 2024-01-25 17:48:31 | bacterial | 1 | 81242 | 5 | 1.466 | 55417.5 |
401 | 2024-01-10 07:17:52 | bacterial | 1 | 81242 | 5 | 1.266 | 64172.2 |
400 | 2023-12-30 17:41:04 | bacterial | 1 | 81242 | 5 | 1.236 | 65729.8 |
399 | 2023-12-28 17:14:56 | bacterial | 2 | 121436 | 13 | 3.250 | 37364.9 |
398 | 2023-12-24 19:32:08 | bacterial | 1 | 81242 | 5 | 1.343 | 60492.9 |
397 | 2023-12-16 11:21:54 | bacterial | 1 | 81242 | 5 | 1.423 | 57092.1 |
396 | 2023-12-09 18:47:12 | bacterial | 3 | 148641 | 63 | 6.780 | 21923.5 |
395 | 2023-11-11 07:08:58 | bacterial | 1 | 81242 | 5 | 1.296 | 62686.7 |
394 | 2023-10-19 19:51:56 | bacterial | 1 | 81242 | 5 | 1.346 | 60358.1 |
393 | 2023-09-30 15:06:49 | bacterial | 2 | 121436 | 13 | 3.110 | 39046.9 |
392 | 2023-09-23 21:17:39 | bacterial | 3 | 148641 | 63 | 14.373 | 10341.7 |
391 | 2023-09-23 20:38:18 | bacterial | 1 | 81242 | 5 | 1.436 | 56575.2 |
390 | 2023-09-09 02:38:14 | bacterial | 3 | 148641 | 63 | 6.046 | 24585.0 |
389 | 2023-08-25 15:39:24 | bacterial | 1 | 81242 | 5 | 1.356 | 59913.0 |
388 | 2023-08-14 09:08:36 | bacterial | 1 | 81242 | 5 | 1.406 | 57782.4 |
387 | 2023-07-11 02:28:35 | bacterial | 2 | 121436 | 13 | 3.126 | 38847.1 |
386 | 2023-05-29 20:59:03 | bacterial | 3 | 148641 | 63 | 6.156 | 24145.7 |
385 | 2023-05-14 17:00:11 | bacterial | 1 | 81242 | 5 | 1.233 | 65889.7 |
384 | 2023-05-11 23:11:22 | bacterial | 1 | 81242 | 5 | 1.216 | 66810.9 |
383 | 2023-03-30 06:03:27 | bacterial | 2 | 121436 | 13 | 3.486 | 34835.3 |
382 | 2023-03-09 14:33:28 | bacterial | 3 | 148641 | 63 | 6.500 | 22867.8 |
381 | 2023-03-08 17:29:17 | bacterial | 1 | 81242 | 5 | 1.233 | 65889.7 |
380 | 2023-01-26 04:43:37 | bacterial | 1 | 81242 | 5 | 1.280 | 63470.3 |
379 | 2022-12-30 09:55:27 | bacterial | 1 | 81242 | 5 | 1.216 | 66810.9 |
378 | 2022-12-27 14:07:14 | bacterial | 2 | 121436 | 13 | 3.483 | 34865.3 |
377 | 2022-12-13 21:33:08 | bacterial | 3 | 148641 | 63 | 6.093 | 24395.4 |
376 | 2022-10-04 15:58:54 | bacterial | 1 | 81242 | 5 | 1.236 | 65729.8 |
375 | 2022-09-19 06:46:34 | bacterial | 1 | 81242 | 5 | 1.250 | 64993.6 |
374 | 2022-08-27 18:20:02 | bacterial | 2 | 121436 | 13 | 3.406 | 35653.6 |
373 | 2022-06-29 22:05:14 | bacterial | 1 | 81242 | 5 | 1.216 | 66810.9 |
372 | 2022-06-29 15:40:52 | bacterial | 3 | 148641 | 63 | 6.186 | 24028.6 |
371 | 2022-06-10 10:34:05 | bacterial | 1 | 81242 | 5 | 1.500 | 54161.3 |
370 | 2022-04-06 18:42:57 | bacterial | 2 | 121436 | 13 | 5.220 | 23263.6 |
369 | 2022-02-28 13:14:43 | bacterial | 1 | 81242 | 5 | 1.313 | 61875.1 |
368 | 2022-02-20 00:01:22 | bacterial | 1 | 81242 | 5 | 1.233 | 65889.7 |
367 | 2022-02-16 16:01:14 | bacterial | 1 | 81242 | 5 | 1.343 | 60492.9 |
366 | 2022-02-06 15:42:03 | bacterial | 3 | 148641 | 63 | 6.563 | 22648.3 |
365 | 2022-01-01 07:14:33 | bacterial | 1 | 81242 | 5 | 1.313 | 61875.1 |
364 | 2021-10-29 10:34:06 | bacterial | 1 | 81242 | 5 | 2.500 | 32496.8 |
363 | 2021-10-26 04:40:01 | bacterial | 1 | 81242 | 5 | 1.250 | 64993.6 |
362 | 2021-07-19 06:57:08 | bacterial | 1 | 81242 | 5 | 1.220 | 66591.8 |
361 | 2021-07-15 16:43:48 | bacterial | 1 | 81242 | 5 | 1.423 | 57092.1 |
360 | 2021-07-06 15:19:50 | bacterial | 4 | 165329 | 367 | 13.016 | 12702.0 |
359 | 2021-07-03 02:05:33 | bacterial | 4 | 165329 | 367 | 10.700 | 15451.3 |
358 | 2021-07-01 08:19:54 | bacterial | 4 | 165329 | 367 | 10.656 | 15515.1 |
357 | 2021-04-13 06:30:41 | bacterial | 4 | 165329 | 367 | 13.156 | 12566.8 |
356 | 2021-04-12 19:23:06 | bacterial | 1 | 81242 | 5 | 1.640 | 49537.8 |
355 | 2021-03-29 06:49:19 | bacterial | 4 | 165329 | 367 | 13.170 | 12553.5 |
354 | 2021-03-05 18:34:01 | bacterial | 1 | 81242 | 5 | 1.296 | 62686.7 |
353 | 2021-01-29 17:25:14 | bacterial | 4 | 165329 | 367 | 11.580 | 14277.1 |
352 | 2021-01-27 01:35:04 | bacterial | 4 | 165329 | 367 | 11.486 | 14394.0 |
351 | 2021-01-03 01:52:03 | bacterial | 1 | 81242 | 5 | 1.236 | 65729.8 |
350 | 2020-12-06 13:44:24 | bacterial | 4 | 165329 | 367 | 16.623 | 9945.8 |
349 | 2020-11-10 05:52:07 | bacterial | 4 | 165329 | 367 | 11.626 | 14220.6 |
348 | 2020-11-08 00:21:15 | bacterial | 4 | 165329 | 367 | 11.406 | 14494.9 |
347 | 2020-10-25 18:53:09 | bacterial | 1 | 81242 | 5 | 1.326 | 61268.5 |
346 | 2020-10-24 19:46:36 | bacterial | 1 | 81242 | 5 | 1.470 | 55266.7 |
345 | 2020-10-24 18:04:52 | bacterial | 1 | 81242 | 5 | 1.250 | 64993.6 |
344 | 2020-10-22 00:18:41 | bacterial | 1 | 81242 | 5 | 1.406 | 57782.4 |
343 | 2020-10-15 03:05:14 | bacterial | 4 | 165329 | 367 | 10.860 | 15223.7 |
342 | 2020-10-01 04:49:51 | bacterial | 1 | 81242 | 5 | 1.220 | 66591.8 |
341 | 2020-08-15 13:55:15 | bacterial | 4 | 165329 | 367 | 11.283 | 14652.9 |
340 | 2020-08-06 14:01:22 | bacterial | 1 | 81242 | 5 | 1.313 | 61875.1 |
339 | 2020-07-19 00:16:17 | bacterial | 1 | 81242 | 5 | 1.516 | 53589.7 |
338 | 2020-06-21 05:46:11 | bacterial | 1 | 81242 | 5 | 1.813 | 44810.8 |
337 | 2020-06-18 01:30:21 | bacterial | 1 | 81242 | 5 | 1.266 | 64172.2 |
336 | 2020-04-06 22:14:10 | bacterial | 4 | 165329 | 367 | 11.156 | 14819.7 |
335 | 2020-03-28 04:48:01 | bacterial | 1 | 81242 | 5 | 1.453 | 55913.3 |
334 | 2020-03-24 12:09:39 | bacterial | 1 | 81242 | 5 | 1.533 | 52995.4 |
333 | 2020-03-21 04:31:02 | bacterial | 1 | 81242 | 5 | 1.436 | 56575.2 |
332 | 2020-03-07 10:35:15 | bacterial | 1 | 81242 | 5 | 1.360 | 59736.8 |
331 | 2020-02-29 03:24:45 | bacterial | 1 | 81242 | 5 | 1.436 | 56575.2 |
330 | 2020-02-29 01:28:32 | bacterial | 4 | 165329 | 367 | 16.096 | 10271.4 |