History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"peter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
584 | 2024-04-29 15:43:36 | peter | 1 | 28756 | 11 | 0.516 | 55728.7 |
583 | 2024-04-29 14:03:36 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
582 | 2024-04-24 17:45:09 | peter | 1 | 28756 | 11 | 0.513 | 56054.6 |
581 | 2024-04-24 17:44:22 | peter | 1 | 28756 | 11 | 0.610 | 47141.0 |
580 | 2024-04-08 19:59:59 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
579 | 2024-04-06 07:28:05 | peter | 1 | 28756 | 11 | 2.236 | 12860.5 |
578 | 2024-03-31 02:22:41 | peter | 1 | 28756 | 11 | 0.610 | 47141.0 |
577 | 2024-03-29 01:06:46 | peter | 1 | 28756 | 11 | 1.140 | 25224.6 |
576 | 2024-03-27 08:02:07 | peter | 1 | 28756 | 11 | 0.486 | 59168.7 |
575 | 2024-03-07 08:37:06 | peter | 2 | 53800 | 249 | 1.906 | 28226.7 |
574 | 2024-03-07 04:18:48 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
573 | 2024-03-01 00:18:49 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
572 | 2024-02-25 18:31:40 | peter | 1 | 28756 | 11 | 1.093 | 26309.2 |
571 | 2024-02-22 14:19:25 | peter | 1 | 28756 | 11 | 1.126 | 25538.2 |
570 | 2024-02-03 22:05:03 | peter | 1 | 28756 | 11 | 0.580 | 49579.3 |
569 | 2024-01-26 13:12:17 | peter | 1 | 28756 | 11 | 0.513 | 56054.6 |
568 | 2023-12-27 09:16:19 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
567 | 2023-12-16 17:21:40 | peter | 2 | 53800 | 249 | 1.360 | 39558.8 |
566 | 2023-12-11 15:30:43 | peter | 2 | 53800 | 249 | 1.440 | 37361.1 |
565 | 2023-12-09 19:07:59 | peter | 1 | 28756 | 11 | 0.466 | 61708.2 |
564 | 2023-12-01 13:52:04 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
563 | 2023-11-29 09:05:28 | peter | 2 | 53800 | 249 | 1.436 | 37465.2 |
562 | 2023-11-28 10:05:52 | peter | 1 | 28756 | 11 | 0.516 | 55728.7 |
561 | 2023-11-12 09:29:04 | peter | 1 | 28756 | 11 | 0.513 | 56054.6 |
560 | 2023-11-11 01:14:55 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
559 | 2023-11-10 20:13:45 | peter | 1 | 28756 | 11 | 0.466 | 61708.2 |
558 | 2023-10-27 15:56:42 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
557 | 2023-10-20 17:53:41 | peter | 1 | 28756 | 11 | 0.486 | 59168.7 |
556 | 2023-10-17 23:47:52 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
555 | 2023-10-16 01:35:36 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
554 | 2023-10-11 19:54:18 | peter | 1 | 28756 | 11 | 0.483 | 59536.2 |
553 | 2023-10-04 12:33:29 | peter | 1 | 28756 | 11 | 0.440 | 65354.5 |
552 | 2023-09-25 21:11:07 | peter | 1 | 28756 | 11 | 0.483 | 59536.2 |
551 | 2023-09-20 14:42:30 | peter | 1 | 28756 | 11 | 0.440 | 65354.5 |
550 | 2023-08-25 04:17:50 | peter | 2 | 53800 | 249 | 3.283 | 16387.5 |
549 | 2023-08-25 04:17:47 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
548 | 2023-08-12 11:14:23 | peter | 1 | 28756 | 11 | 0.440 | 65354.5 |
547 | 2023-08-01 10:33:05 | peter | 1 | 28756 | 11 | 0.440 | 65354.5 |
546 | 2023-05-12 14:49:11 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
545 | 2023-04-05 17:07:08 | peter | 1 | 28756 | 11 | 0.440 | 65354.5 |
544 | 2023-03-08 17:29:43 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
543 | 2022-12-30 10:08:51 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
542 | 2022-12-20 10:10:51 | peter | 1 | 28756 | 11 | 0.483 | 59536.2 |
541 | 2022-09-19 11:29:50 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
540 | 2022-08-20 06:51:35 | peter | 1 | 28756 | 11 | 0.890 | 32310.1 |
539 | 2022-06-09 20:49:25 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
538 | 2022-05-01 16:49:44 | peter | 1 | 28756 | 11 | 0.483 | 59536.2 |
537 | 2022-04-16 07:46:12 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
536 | 2022-01-22 21:26:10 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
535 | 2021-12-28 07:42:20 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
534 | 2021-12-25 04:23:56 | peter | 1 | 28756 | 11 | 0.466 | 61708.2 |
533 | 2021-11-16 08:40:40 | peter | 1 | 28756 | 11 | 0.440 | 65354.5 |
532 | 2021-10-04 03:21:29 | peter | 1 | 28756 | 11 | 0.860 | 33437.2 |
531 | 2021-10-02 00:54:02 | peter | 1 | 28756 | 11 | 0.483 | 59536.2 |
530 | 2021-09-14 18:50:50 | peter | 1 | 28756 | 11 | 0.513 | 56054.6 |
529 | 2021-09-12 19:02:14 | peter | 1 | 28756 | 11 | 0.440 | 65354.5 |
528 | 2021-07-27 04:42:03 | peter | 1 | 28756 | 11 | 0.440 | 65354.5 |
527 | 2021-06-14 16:58:21 | peter | 1 | 28756 | 11 | 0.486 | 59168.7 |
526 | 2021-05-17 23:16:13 | peter | 1 | 28756 | 11 | 0.513 | 56054.6 |
525 | 2021-04-17 23:14:34 | peter | 1 | 28756 | 11 | 0.516 | 55728.7 |
524 | 2021-03-08 05:48:59 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
523 | 2021-01-30 09:38:18 | peter | 1 | 28756 | 11 | 0.503 | 57169.0 |
522 | 2021-01-30 03:51:47 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
521 | 2021-01-02 08:50:58 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
520 | 2020-12-05 17:31:39 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
519 | 2020-12-04 15:54:16 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
518 | 2020-10-19 08:02:01 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
517 | 2020-10-03 10:38:31 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
516 | 2020-09-25 15:59:02 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
515 | 2020-08-29 20:59:37 | peter | 1 | 28756 | 11 | 0.486 | 59168.7 |
514 | 2020-07-29 13:36:41 | peter | 1 | 28756 | 11 | 0.470 | 61183.0 |
513 | 2020-07-27 20:18:20 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
512 | 2020-07-21 23:29:19 | peter | 1 | 28756 | 11 | 0.470 | 61183.0 |
511 | 2020-05-28 05:07:52 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
510 | 2020-05-25 05:48:11 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
509 | 2020-05-04 09:36:42 | peter | 1 | 28756 | 11 | 0.453 | 63479.0 |
508 | 2020-03-25 14:10:01 | peter | 1 | 28756 | 11 | 0.516 | 55728.7 |
507 | 2020-03-25 06:20:23 | peter | 1 | 28756 | 11 | 0.530 | 54256.6 |
506 | 2020-03-22 09:39:31 | peter | 1 | 28756 | 11 | 0.440 | 65354.5 |
505 | 2020-03-21 15:56:28 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
504 | 2020-03-21 05:24:10 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
503 | 2020-03-18 03:38:44 | peter | 1 | 28756 | 11 | 0.530 | 54256.6 |
502 | 2020-03-01 07:44:33 | peter | 1 | 28756 | 11 | 0.513 | 56054.6 |
501 | 2020-02-27 17:41:26 | peter | 1 | 28756 | 11 | 0.606 | 47452.1 |
500 | 2020-02-22 16:16:37 | peter | 1 | 28756 | 11 | 0.576 | 49923.6 |
499 | 2020-02-21 09:34:16 | peter | 1 | 28756 | 11 | 1.596 | 18017.5 |
498 | 2020-02-19 01:14:27 | peter | 1 | 28756 | 11 | 0.500 | 57512.0 |
497 | 2020-02-17 05:01:49 | peter | 1 | 28756 | 11 | 0.876 | 32826.5 |
496 | 2020-02-15 08:28:12 | peter | 1 | 28756 | 11 | 1.673 | 17188.3 |
495 | 2020-02-11 10:04:43 | peter | 2 | 53800 | 249 | 3.656 | 14715.5 |
494 | 2020-02-10 17:40:50 | peter | 2 | 53800 | 249 | 3.656 | 14715.5 |
493 | 2020-02-10 12:55:02 | peter | 2 | 53800 | 249 | 1.780 | 30224.7 |
492 | 2020-02-10 06:04:09 | peter | 2 | 53800 | 249 | 1.530 | 35163.4 |
491 | 2020-02-09 09:04:32 | peter | 1 | 28756 | 11 | 0.580 | 49579.3 |
490 | 2020-02-08 04:29:51 | peter | 1 | 28756 | 11 | 1.126 | 25538.2 |
489 | 2020-02-06 08:56:38 | peter | 1 | 28756 | 11 | 0.436 | 65954.1 |
488 | 2020-01-28 18:37:28 | peter | 1 | 28756 | 11 | 0.533 | 53951.2 |
487 | 2020-01-28 00:00:51 | peter | 1 | 28756 | 11 | 1.093 | 26309.2 |
486 | 2020-01-27 13:07:56 | peter | 1 | 28756 | 11 | 0.546 | 52666.7 |
485 | 2020-01-22 23:07:36 | peter | 2 | 53800 | 249 | 1.673 | 32157.8 |