History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jerky"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
517 | 2024-04-28 15:10:37 | jerky | 1 | 28756 | 5 | 0.530 | 54256.6 |
516 | 2024-04-28 02:15:54 | jerky | 1 | 28756 | 5 | 0.550 | 52283.6 |
515 | 2024-04-16 14:31:57 | jerky | 1 | 28756 | 5 | 0.436 | 65954.1 |
514 | 2024-04-05 11:52:35 | jerky | 2 | 53800 | 70 | 4.390 | 12255.1 |
513 | 2024-04-05 11:52:08 | jerky | 3 | 83667 | 836 | 4.580 | 18267.9 |
512 | 2024-04-04 23:33:37 | jerky | 3 | 83667 | 836 | 4.610 | 18149.0 |
511 | 2024-04-03 05:45:48 | jerky | 3 | 83667 | 836 | 11.753 | 7118.8 |
510 | 2024-04-03 05:45:46 | jerky | 2 | 53800 | 70 | 2.453 | 21932.3 |
509 | 2024-04-03 05:25:29 | jerky | 1 | 28756 | 5 | 1.030 | 27918.4 |
508 | 2024-03-31 02:01:09 | jerky | 1 | 28756 | 5 | 0.516 | 55728.7 |
507 | 2024-03-30 20:02:58 | jerky | 3 | 83667 | 836 | 12.640 | 6619.2 |
506 | 2024-03-29 19:03:23 | jerky | 3 | 83667 | 836 | 4.453 | 18788.9 |
505 | 2024-03-29 19:03:22 | jerky | 2 | 53800 | 70 | 3.546 | 15172.0 |
504 | 2024-03-29 19:03:18 | jerky | 1 | 28756 | 5 | 0.530 | 54256.6 |
503 | 2024-03-29 02:57:13 | jerky | 1 | 28756 | 5 | 0.486 | 59168.7 |
502 | 2024-03-05 21:01:36 | jerky | 2 | 53800 | 70 | 1.486 | 36204.6 |
501 | 2024-02-28 01:38:35 | jerky | 2 | 53800 | 70 | 3.046 | 17662.5 |
500 | 2024-02-28 01:20:43 | jerky | 3 | 83667 | 836 | 3.830 | 21845.2 |
499 | 2024-02-28 01:20:41 | jerky | 2 | 53800 | 70 | 1.593 | 33772.8 |
498 | 2024-02-28 01:20:37 | jerky | 1 | 28756 | 5 | 0.516 | 55728.7 |
497 | 2024-02-12 00:12:01 | jerky | 3 | 83667 | 836 | 10.283 | 8136.4 |
496 | 2024-02-11 19:17:48 | jerky | 3 | 83667 | 836 | 4.563 | 18336.0 |
495 | 2024-02-09 23:02:04 | jerky | 3 | 83667 | 836 | 8.546 | 9790.2 |
494 | 2024-02-09 13:13:11 | jerky | 3 | 83667 | 836 | 13.093 | 6390.2 |
493 | 2024-02-09 13:12:48 | jerky | 3 | 83667 | 836 | 13.076 | 6398.5 |
492 | 2024-01-29 00:26:25 | jerky | 1 | 28756 | 5 | 0.453 | 63479.0 |
491 | 2024-01-16 08:22:38 | jerky | 2 | 53800 | 70 | 1.343 | 40059.6 |
490 | 2024-01-12 15:57:52 | jerky | 2 | 53800 | 70 | 1.373 | 39184.3 |
489 | 2024-01-04 07:37:28 | jerky | 3 | 83667 | 836 | 3.530 | 23701.7 |
488 | 2024-01-01 02:38:12 | jerky | 1 | 28756 | 5 | 0.420 | 68466.7 |
487 | 2023-12-11 18:32:42 | jerky | 3 | 83667 | 836 | 3.813 | 21942.6 |
486 | 2023-12-11 10:30:00 | jerky | 3 | 83667 | 836 | 3.500 | 23904.9 |
485 | 2023-12-10 21:58:10 | jerky | 3 | 83667 | 836 | 4.156 | 20131.6 |
484 | 2023-12-09 22:03:15 | jerky | 3 | 83667 | 836 | 3.813 | 21942.6 |
483 | 2023-12-08 04:17:28 | jerky | 3 | 83667 | 836 | 3.953 | 21165.4 |
482 | 2023-12-08 01:26:17 | jerky | 1 | 28756 | 5 | 0.596 | 48248.3 |
481 | 2023-12-08 01:26:16 | jerky | 1 | 28756 | 5 | 1.063 | 27051.7 |
480 | 2023-12-06 18:56:20 | jerky | 3 | 83667 | 836 | 3.266 | 25617.6 |
479 | 2023-11-30 05:11:06 | jerky | 1 | 28756 | 5 | 0.483 | 59536.2 |
478 | 2023-11-26 23:42:36 | jerky | 2 | 53800 | 70 | 1.296 | 41512.3 |
477 | 2023-11-25 10:12:46 | jerky | 3 | 83667 | 836 | 3.500 | 23904.9 |
476 | 2023-11-25 10:12:48 | jerky | 2 | 53800 | 70 | 1.483 | 36277.8 |
475 | 2023-11-17 14:50:42 | jerky | 1 | 28756 | 5 | 0.420 | 68466.7 |
474 | 2023-11-16 07:37:13 | jerky | 1 | 28756 | 5 | 0.423 | 67981.1 |
473 | 2023-11-13 00:25:57 | jerky | 3 | 83667 | 836 | 3.813 | 21942.6 |
472 | 2023-11-12 20:00:40 | jerky | 3 | 83667 | 836 | 3.140 | 26645.5 |
471 | 2023-11-11 22:32:51 | jerky | 3 | 83667 | 836 | 3.186 | 26260.8 |
470 | 2023-11-11 16:28:29 | jerky | 3 | 83667 | 836 | 3.250 | 25743.7 |
469 | 2023-11-10 22:12:24 | jerky | 3 | 83667 | 836 | 3.313 | 25254.2 |
468 | 2023-11-04 02:14:15 | jerky | 1 | 28756 | 5 | 0.423 | 67981.1 |
467 | 2023-10-22 03:06:43 | jerky | 1 | 28756 | 5 | 0.470 | 61183.0 |
466 | 2023-10-22 01:52:05 | jerky | 1 | 28756 | 5 | 0.533 | 53951.2 |
465 | 2023-10-19 22:04:08 | jerky | 1 | 28756 | 5 | 0.483 | 59536.2 |
464 | 2023-10-15 00:15:48 | jerky | 1 | 28756 | 5 | 0.470 | 61183.0 |
463 | 2023-10-04 15:10:53 | jerky | 1 | 28756 | 5 | 0.453 | 63479.0 |
462 | 2023-09-24 18:41:32 | jerky | 1 | 28756 | 5 | 0.440 | 65354.5 |
461 | 2023-09-12 20:25:43 | jerky | 1 | 28756 | 5 | 0.966 | 29768.1 |
460 | 2023-08-26 03:50:38 | jerky | 2 | 53800 | 70 | 2.610 | 20613.0 |
459 | 2023-08-17 06:59:34 | jerky | 1 | 28756 | 5 | 0.486 | 59168.7 |
458 | 2023-08-15 22:43:55 | jerky | 3 | 83667 | 836 | 3.703 | 22594.4 |
457 | 2023-08-06 14:25:18 | jerky | 3 | 83667 | 836 | 3.266 | 25617.6 |
456 | 2023-07-30 21:30:22 | jerky | 1 | 28756 | 5 | 0.423 | 67981.1 |
455 | 2023-06-27 21:23:14 | jerky | 3 | 83667 | 836 | 3.220 | 25983.5 |
454 | 2023-06-23 02:03:08 | jerky | 3 | 83667 | 836 | 3.673 | 22778.9 |
453 | 2023-06-15 09:41:45 | jerky | 3 | 83667 | 836 | 3.766 | 22216.4 |
452 | 2023-06-14 11:36:16 | jerky | 3 | 83667 | 836 | 3.233 | 25879.1 |
451 | 2023-06-13 10:46:02 | jerky | 3 | 83667 | 836 | 4.060 | 20607.6 |
450 | 2023-06-11 11:42:17 | jerky | 3 | 83667 | 836 | 3.920 | 21343.6 |
449 | 2023-06-10 20:21:50 | jerky | 3 | 83667 | 836 | 3.500 | 23904.9 |
448 | 2023-06-10 17:44:37 | jerky | 3 | 83667 | 836 | 3.330 | 25125.2 |
447 | 2023-06-09 13:24:11 | jerky | 3 | 83667 | 836 | 3.640 | 22985.4 |
446 | 2023-06-08 20:35:15 | jerky | 3 | 83667 | 836 | 3.843 | 21771.3 |
445 | 2023-06-07 20:49:21 | jerky | 3 | 83667 | 836 | 3.813 | 21942.6 |
444 | 2023-05-17 10:24:48 | jerky | 3 | 83667 | 836 | 3.186 | 26260.8 |
443 | 2023-05-15 08:42:51 | jerky | 1 | 28756 | 5 | 0.470 | 61183.0 |
442 | 2023-05-11 18:49:15 | jerky | 2 | 53800 | 70 | 1.313 | 40974.9 |
441 | 2023-04-29 23:47:13 | jerky | 3 | 83667 | 836 | 3.173 | 26368.4 |
440 | 2023-04-16 10:30:29 | jerky | 3 | 83667 | 836 | 3.110 | 26902.6 |
439 | 2023-04-11 13:14:38 | jerky | 1 | 28756 | 5 | 0.483 | 59536.2 |
438 | 2023-03-08 13:28:28 | jerky | 1 | 28756 | 5 | 0.420 | 68466.7 |
437 | 2023-02-16 21:42:35 | jerky | 2 | 53800 | 70 | 1.296 | 41512.3 |
436 | 2023-02-04 05:06:40 | jerky | 3 | 83667 | 836 | 3.140 | 26645.5 |
435 | 2022-12-31 21:07:51 | jerky | 1 | 28756 | 5 | 0.423 | 67981.1 |
434 | 2022-12-26 05:30:39 | jerky | 1 | 28756 | 5 | 0.486 | 59168.7 |
433 | 2022-11-28 07:39:58 | jerky | 2 | 53800 | 70 | 1.330 | 40451.1 |
432 | 2022-11-16 22:17:32 | jerky | 3 | 83667 | 836 | 3.686 | 22698.6 |
431 | 2022-09-19 06:27:29 | jerky | 1 | 28756 | 5 | 0.436 | 65954.1 |
430 | 2022-09-18 04:05:21 | jerky | 1 | 28756 | 5 | 0.436 | 65954.1 |
429 | 2022-08-29 08:18:47 | jerky | 1 | 28756 | 5 | 0.423 | 67981.1 |
428 | 2022-08-23 08:59:05 | jerky | 1 | 28756 | 5 | 0.436 | 65954.1 |
427 | 2022-07-10 04:19:27 | jerky | 1 | 28756 | 5 | 0.453 | 63479.0 |
426 | 2022-06-25 16:58:22 | jerky | 1 | 28756 | 5 | 0.486 | 59168.7 |
425 | 2022-06-25 09:25:04 | jerky | 1 | 28756 | 5 | 0.470 | 61183.0 |
424 | 2022-06-19 17:03:57 | jerky | 3 | 83667 | 836 | 3.220 | 25983.5 |
423 | 2022-04-30 19:49:36 | jerky | 1 | 28756 | 5 | 0.423 | 67981.1 |
422 | 2022-04-30 17:56:48 | jerky | 2 | 53800 | 70 | 1.486 | 36204.6 |
421 | 2022-04-25 06:40:25 | jerky | 1 | 28756 | 5 | 0.483 | 59536.2 |
420 | 2022-01-22 00:46:39 | jerky | 1 | 28756 | 5 | 0.486 | 59168.7 |
419 | 2022-01-05 14:04:59 | jerky | 1 | 28756 | 5 | 1.063 | 27051.7 |
418 | 2021-11-19 16:00:49 | jerky | 1 | 28756 | 5 | 0.440 | 65354.5 |