History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jimmy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
560 | 2024-04-27 12:16:30 | jimmy | 1 | 28756 | 5 | 0.986 | 29164.3 |
559 | 2024-04-26 09:10:32 | jimmy | 1 | 28756 | 5 | 0.516 | 55728.7 |
558 | 2024-04-04 04:37:56 | jimmy | 3 | 83667 | 478 | 7.983 | 10480.6 |
557 | 2024-04-03 05:49:23 | jimmy | 1 | 28756 | 5 | 1.110 | 25906.3 |
556 | 2024-04-03 02:57:29 | jimmy | 2 | 53800 | 46 | 5.640 | 9539.0 |
555 | 2024-04-01 17:45:05 | jimmy | 2 | 53800 | 46 | 1.843 | 29191.5 |
554 | 2024-04-01 10:39:50 | jimmy | 3 | 83667 | 478 | 6.300 | 13280.5 |
553 | 2024-04-01 10:39:45 | jimmy | 1 | 28756 | 5 | 0.546 | 52666.7 |
552 | 2024-04-01 10:39:24 | jimmy | 2 | 53800 | 46 | 1.766 | 30464.3 |
551 | 2024-03-31 05:43:01 | jimmy | 2 | 53800 | 46 | 5.516 | 9753.4 |
550 | 2024-03-31 03:54:33 | jimmy | 1 | 28756 | 5 | 0.983 | 29253.3 |
549 | 2024-03-29 08:25:12 | jimmy | 3 | 83667 | 478 | 8.986 | 9310.8 |
548 | 2024-03-29 08:25:14 | jimmy | 2 | 53800 | 46 | 1.780 | 30224.7 |
547 | 2024-03-29 08:20:14 | jimmy | 1 | 28756 | 5 | 0.640 | 44931.3 |
546 | 2024-03-16 15:22:46 | jimmy | 2 | 53800 | 46 | 3.686 | 14595.8 |
545 | 2024-03-05 20:53:28 | jimmy | 1 | 28756 | 5 | 0.560 | 51350.0 |
544 | 2024-03-04 16:17:22 | jimmy | 3 | 83667 | 478 | 11.283 | 7415.3 |
543 | 2024-03-04 03:55:28 | jimmy | 3 | 83667 | 478 | 4.033 | 20745.6 |
542 | 2024-03-04 03:55:27 | jimmy | 2 | 53800 | 46 | 1.610 | 33416.1 |
541 | 2024-03-04 00:43:17 | jimmy | 1 | 28756 | 5 | 0.486 | 59168.7 |
540 | 2024-02-28 02:18:50 | jimmy | 1 | 28756 | 5 | 0.466 | 61708.2 |
539 | 2024-02-02 23:21:27 | jimmy | 1 | 28756 | 5 | 0.500 | 57512.0 |
538 | 2024-01-29 00:47:21 | jimmy | 1 | 28756 | 5 | 0.423 | 67981.1 |
537 | 2024-01-28 20:37:35 | jimmy | 1 | 28756 | 5 | 0.486 | 59168.7 |
536 | 2024-01-19 06:37:03 | jimmy | 1 | 28756 | 5 | 0.483 | 59536.2 |
535 | 2023-12-31 19:03:39 | jimmy | 3 | 83667 | 478 | 3.360 | 24900.9 |
534 | 2023-12-31 19:03:38 | jimmy | 2 | 53800 | 46 | 1.390 | 38705.0 |
533 | 2023-11-30 23:23:12 | jimmy | 2 | 53800 | 46 | 1.563 | 34421.0 |
532 | 2023-11-29 22:55:23 | jimmy | 2 | 53800 | 46 | 1.470 | 36598.6 |
531 | 2023-11-29 22:55:20 | jimmy | 3 | 83667 | 478 | 3.610 | 23176.5 |
530 | 2023-11-22 07:38:02 | jimmy | 2 | 53800 | 46 | 1.643 | 32745.0 |
529 | 2023-11-14 15:00:55 | jimmy | 1 | 28756 | 5 | 0.486 | 59168.7 |
528 | 2023-11-13 22:31:17 | jimmy | 1 | 28756 | 5 | 0.466 | 61708.2 |
527 | 2023-11-09 19:26:34 | jimmy | 1 | 28756 | 5 | 0.466 | 61708.2 |
526 | 2023-11-04 02:25:28 | jimmy | 1 | 28756 | 5 | 0.500 | 57512.0 |
525 | 2023-11-03 10:46:53 | jimmy | 3 | 83667 | 478 | 3.813 | 21942.6 |
524 | 2023-11-01 03:36:13 | jimmy | 1 | 28756 | 5 | 0.483 | 59536.2 |
523 | 2023-10-21 18:06:22 | jimmy | 1 | 28756 | 5 | 0.436 | 65954.1 |
522 | 2023-10-18 15:41:53 | jimmy | 1 | 28756 | 5 | 0.436 | 65954.1 |
521 | 2023-10-14 21:35:38 | jimmy | 2 | 53800 | 46 | 1.326 | 40573.2 |
520 | 2023-10-13 09:07:09 | jimmy | 3 | 83667 | 478 | 3.313 | 25254.2 |
519 | 2023-10-11 08:19:47 | jimmy | 1 | 28756 | 5 | 0.470 | 61183.0 |
518 | 2023-10-10 14:49:08 | jimmy | 1 | 28756 | 5 | 0.436 | 65954.1 |
517 | 2023-10-03 17:20:37 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |
516 | 2023-09-27 03:52:07 | jimmy | 3 | 83667 | 478 | 6.046 | 13838.4 |
515 | 2023-09-27 03:50:46 | jimmy | 2 | 53800 | 46 | 1.360 | 39558.8 |
514 | 2023-09-24 10:06:23 | jimmy | 3 | 83667 | 478 | 3.123 | 26790.6 |
513 | 2023-09-24 10:06:18 | jimmy | 2 | 53800 | 46 | 1.330 | 40451.1 |
512 | 2023-09-19 10:58:25 | jimmy | 1 | 28756 | 5 | 0.470 | 61183.0 |
511 | 2023-09-12 18:54:36 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |
510 | 2023-09-01 21:44:18 | jimmy | 1 | 28756 | 5 | 0.953 | 30174.2 |
509 | 2023-08-29 22:03:05 | jimmy | 2 | 53800 | 46 | 1.330 | 40451.1 |
508 | 2023-06-11 03:50:33 | jimmy | 1 | 28756 | 5 | 0.466 | 61708.2 |
507 | 2023-06-06 21:22:53 | jimmy | 1 | 28756 | 5 | 0.423 | 67981.1 |
506 | 2023-05-26 05:26:23 | jimmy | 1 | 28756 | 5 | 0.423 | 67981.1 |
505 | 2023-05-16 07:35:05 | jimmy | 2 | 53800 | 46 | 1.296 | 41512.3 |
504 | 2023-03-28 19:39:47 | jimmy | 1 | 28756 | 5 | 0.500 | 57512.0 |
503 | 2023-02-24 05:17:32 | jimmy | 2 | 53800 | 46 | 1.560 | 34487.2 |
502 | 2023-02-19 18:15:45 | jimmy | 1 | 28756 | 5 | 0.406 | 70827.6 |
501 | 2023-01-11 17:14:26 | jimmy | 1 | 28756 | 5 | 0.423 | 67981.1 |
500 | 2022-12-05 14:55:47 | jimmy | 2 | 53800 | 46 | 1.296 | 41512.3 |
499 | 2022-10-25 19:24:16 | jimmy | 1 | 28756 | 5 | 0.423 | 67981.1 |
498 | 2022-10-19 07:49:46 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |
497 | 2022-08-15 10:46:55 | jimmy | 1 | 28756 | 5 | 0.483 | 59536.2 |
496 | 2022-08-14 03:46:15 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |
495 | 2022-07-12 10:05:41 | jimmy | 2 | 53800 | 46 | 1.313 | 40974.9 |
494 | 2022-06-14 14:21:34 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |
493 | 2022-06-10 11:32:27 | jimmy | 1 | 28756 | 5 | 0.466 | 61708.2 |
492 | 2022-02-19 22:52:53 | jimmy | 1 | 28756 | 5 | 0.436 | 65954.1 |
491 | 2022-02-19 01:57:18 | jimmy | 2 | 53800 | 46 | 1.516 | 35488.1 |
490 | 2022-02-06 04:41:37 | jimmy | 1 | 28756 | 5 | 0.513 | 56054.6 |
489 | 2021-12-09 04:52:40 | jimmy | 1 | 28756 | 5 | 0.486 | 59168.7 |
488 | 2021-12-07 01:45:37 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |
487 | 2021-10-24 16:04:46 | jimmy | 1 | 28756 | 5 | 0.436 | 65954.1 |
486 | 2021-10-22 14:49:26 | jimmy | 1 | 28756 | 5 | 0.500 | 57512.0 |
485 | 2021-10-10 02:08:27 | jimmy | 1 | 28756 | 5 | 0.440 | 65354.5 |
484 | 2021-09-12 16:23:57 | jimmy | 1 | 28756 | 5 | 0.843 | 34111.5 |
483 | 2021-09-10 13:27:42 | jimmy | 1 | 28756 | 5 | 0.470 | 61183.0 |
482 | 2021-07-08 05:24:32 | jimmy | 1 | 28756 | 5 | 0.486 | 59168.7 |
481 | 2021-07-03 10:42:46 | jimmy | 1 | 28756 | 5 | 0.423 | 67981.1 |
480 | 2021-05-01 00:29:46 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |
479 | 2021-04-17 00:15:09 | jimmy | 1 | 28756 | 5 | 0.936 | 30722.2 |
478 | 2021-04-08 10:07:05 | jimmy | 1 | 28756 | 5 | 0.436 | 65954.1 |
477 | 2021-04-04 06:14:44 | jimmy | 1 | 28756 | 5 | 0.470 | 61183.0 |
476 | 2021-02-22 17:39:50 | jimmy | 1 | 28756 | 5 | 0.466 | 61708.2 |
475 | 2021-01-29 15:42:29 | jimmy | 1 | 28756 | 5 | 0.470 | 61183.0 |
474 | 2021-01-27 00:31:26 | jimmy | 1 | 28756 | 5 | 0.436 | 65954.1 |
473 | 2020-12-30 05:48:28 | jimmy | 1 | 28756 | 5 | 0.466 | 61708.2 |
472 | 2020-12-26 16:09:26 | jimmy | 1 | 28756 | 5 | 0.423 | 67981.1 |
471 | 2020-11-03 11:03:32 | jimmy | 1 | 28756 | 5 | 0.470 | 61183.0 |
470 | 2020-09-29 08:58:04 | jimmy | 1 | 28756 | 5 | 0.466 | 61708.2 |
469 | 2020-09-23 18:22:17 | jimmy | 1 | 28756 | 5 | 0.453 | 63479.0 |
468 | 2020-09-22 23:22:10 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |
467 | 2020-08-30 23:15:00 | jimmy | 1 | 28756 | 5 | 0.436 | 65954.1 |
466 | 2020-08-22 10:31:34 | jimmy | 1 | 28756 | 5 | 0.423 | 67981.1 |
465 | 2020-08-16 12:55:32 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |
464 | 2020-08-06 16:41:23 | jimmy | 1 | 28756 | 5 | 0.513 | 56054.6 |
463 | 2020-08-03 08:03:04 | jimmy | 1 | 28756 | 5 | 0.440 | 65354.5 |
462 | 2020-06-06 01:57:17 | jimmy | 1 | 28756 | 5 | 0.483 | 59536.2 |
461 | 2020-06-03 05:01:03 | jimmy | 1 | 28756 | 5 | 0.420 | 68466.7 |