History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loyal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
605 | 2024-04-08 22:17:01 | loyal | 3 | 83667 | 901 | 10.843 | 7716.2 |
604 | 2024-04-08 06:19:32 | loyal | 2 | 53800 | 66 | 1.550 | 34709.7 |
603 | 2024-04-08 06:19:06 | loyal | 3 | 83667 | 901 | 4.483 | 18663.2 |
602 | 2024-04-05 20:26:52 | loyal | 3 | 83667 | 901 | 9.906 | 8446.1 |
601 | 2024-04-05 17:31:21 | loyal | 3 | 83667 | 901 | 18.236 | 4588.0 |
600 | 2024-04-05 17:30:00 | loyal | 2 | 53800 | 66 | 4.080 | 13186.3 |
599 | 2024-04-05 17:14:47 | loyal | 1 | 28756 | 4 | 0.516 | 55728.7 |
598 | 2024-04-04 18:01:48 | loyal | 3 | 83667 | 901 | 5.813 | 14393.1 |
597 | 2024-03-31 06:12:25 | loyal | 1 | 28756 | 4 | 1.203 | 23903.6 |
596 | 2024-03-29 02:35:27 | loyal | 1 | 28756 | 4 | 0.530 | 54256.6 |
595 | 2024-03-14 16:05:04 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
594 | 2024-03-04 18:33:54 | loyal | 3 | 83667 | 901 | 12.626 | 6626.6 |
593 | 2024-03-04 18:33:53 | loyal | 2 | 53800 | 66 | 1.906 | 28226.7 |
592 | 2024-03-04 18:18:47 | loyal | 1 | 28756 | 4 | 1.733 | 16593.2 |
591 | 2024-03-01 03:53:04 | loyal | 1 | 28756 | 4 | 0.483 | 59536.2 |
590 | 2024-02-28 05:27:44 | loyal | 3 | 83667 | 901 | 8.516 | 9824.7 |
589 | 2024-02-27 22:03:21 | loyal | 2 | 53800 | 66 | 3.343 | 16093.3 |
588 | 2024-02-27 22:02:56 | loyal | 3 | 83667 | 901 | 4.563 | 18336.0 |
587 | 2024-02-27 21:57:45 | loyal | 3 | 83667 | 901 | 9.093 | 9201.3 |
586 | 2024-02-27 21:57:43 | loyal | 2 | 53800 | 66 | 2.360 | 22796.6 |
585 | 2024-02-27 21:07:26 | loyal | 1 | 28756 | 4 | 0.486 | 59168.7 |
584 | 2024-02-13 06:53:47 | loyal | 1 | 28756 | 4 | 0.453 | 63479.0 |
583 | 2024-02-03 17:47:51 | loyal | 1 | 28756 | 4 | 0.516 | 55728.7 |
582 | 2024-01-29 06:03:19 | loyal | 1 | 28756 | 4 | 0.516 | 55728.7 |
581 | 2024-01-28 20:02:21 | loyal | 1 | 28756 | 4 | 0.483 | 59536.2 |
580 | 2024-01-24 00:21:06 | loyal | 1 | 28756 | 4 | 0.516 | 55728.7 |
579 | 2024-01-11 07:31:14 | loyal | 1 | 28756 | 4 | 0.530 | 54256.6 |
578 | 2024-01-06 17:19:26 | loyal | 1 | 28756 | 4 | 0.483 | 59536.2 |
577 | 2023-12-27 08:09:27 | loyal | 3 | 83667 | 901 | 3.856 | 21697.9 |
576 | 2023-12-27 08:09:26 | loyal | 2 | 53800 | 66 | 1.580 | 34050.6 |
575 | 2023-12-06 12:48:17 | loyal | 3 | 83667 | 901 | 3.330 | 25125.2 |
574 | 2023-11-26 17:16:59 | loyal | 2 | 53800 | 66 | 1.453 | 37026.8 |
573 | 2023-11-26 17:16:53 | loyal | 3 | 83667 | 901 | 3.420 | 24464.0 |
572 | 2023-11-20 00:30:21 | loyal | 1 | 28756 | 4 | 0.483 | 59536.2 |
571 | 2023-11-12 22:02:00 | loyal | 1 | 28756 | 4 | 0.513 | 56054.6 |
570 | 2023-11-03 15:10:34 | loyal | 1 | 28756 | 4 | 0.453 | 63479.0 |
569 | 2023-10-29 11:16:02 | loyal | 1 | 28756 | 4 | 0.500 | 57512.0 |
568 | 2023-10-21 23:07:19 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
567 | 2023-10-19 12:25:55 | loyal | 1 | 28756 | 4 | 0.530 | 54256.6 |
566 | 2023-10-13 18:01:13 | loyal | 1 | 28756 | 4 | 0.483 | 59536.2 |
565 | 2023-10-11 02:13:51 | loyal | 1 | 28756 | 4 | 0.500 | 57512.0 |
564 | 2023-10-05 19:19:51 | loyal | 1 | 28756 | 4 | 0.486 | 59168.7 |
563 | 2023-09-28 22:50:16 | loyal | 1 | 28756 | 4 | 0.486 | 59168.7 |
562 | 2023-09-15 17:26:38 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
561 | 2023-09-02 07:44:55 | loyal | 3 | 83667 | 901 | 3.720 | 22491.1 |
560 | 2023-08-23 01:45:58 | loyal | 1 | 28756 | 4 | 0.453 | 63479.0 |
559 | 2023-06-20 15:41:00 | loyal | 1 | 28756 | 4 | 0.453 | 63479.0 |
558 | 2023-05-24 00:58:40 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
557 | 2023-05-19 16:06:32 | loyal | 3 | 83667 | 901 | 3.233 | 25879.1 |
556 | 2023-05-19 15:17:41 | loyal | 3 | 83667 | 901 | 3.236 | 25855.1 |
555 | 2023-04-22 00:58:58 | loyal | 3 | 83667 | 901 | 3.203 | 26121.4 |
554 | 2023-03-23 07:10:00 | loyal | 3 | 83667 | 901 | 3.313 | 25254.2 |
553 | 2023-03-20 18:48:00 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
552 | 2023-03-05 05:13:43 | loyal | 1 | 28756 | 4 | 0.500 | 57512.0 |
551 | 2023-03-01 18:23:56 | loyal | 1 | 28756 | 4 | 0.453 | 63479.0 |
550 | 2023-02-28 07:31:22 | loyal | 3 | 83667 | 901 | 3.233 | 25879.1 |
549 | 2023-01-07 17:41:30 | loyal | 1 | 28756 | 4 | 0.440 | 65354.5 |
548 | 2022-12-08 08:30:45 | loyal | 3 | 83667 | 901 | 3.266 | 25617.6 |
547 | 2022-11-09 08:54:45 | loyal | 1 | 28756 | 4 | 1.313 | 21901.0 |
546 | 2022-11-05 23:44:10 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
545 | 2022-10-30 19:06:03 | loyal | 3 | 83667 | 901 | 3.893 | 21491.7 |
544 | 2022-10-01 06:11:30 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
543 | 2022-09-20 01:09:12 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
542 | 2022-09-10 18:59:45 | loyal | 1 | 28756 | 4 | 0.440 | 65354.5 |
541 | 2022-08-15 01:38:02 | loyal | 1 | 28756 | 4 | 0.453 | 63479.0 |
540 | 2022-08-14 21:19:05 | loyal | 1 | 28756 | 4 | 0.466 | 61708.2 |
539 | 2022-07-29 05:31:10 | loyal | 1 | 28756 | 4 | 0.453 | 63479.0 |
538 | 2022-07-21 01:23:51 | loyal | 3 | 83667 | 901 | 3.360 | 24900.9 |
537 | 2022-07-16 09:19:55 | loyal | 1 | 28756 | 4 | 0.500 | 57512.0 |
536 | 2022-07-15 02:52:00 | loyal | 2 | 53800 | 66 | 1.423 | 37807.4 |
535 | 2022-05-15 22:35:13 | loyal | 1 | 28756 | 4 | 0.440 | 65354.5 |
534 | 2022-05-13 17:18:45 | loyal | 1 | 28756 | 4 | 0.500 | 57512.0 |
533 | 2022-04-27 18:38:55 | loyal | 1 | 28756 | 4 | 0.500 | 57512.0 |
532 | 2022-04-27 06:37:17 | loyal | 1 | 28756 | 4 | 0.440 | 65354.5 |
531 | 2022-04-26 15:11:28 | loyal | 1 | 28756 | 4 | 0.546 | 52666.7 |
530 | 2022-04-26 02:55:26 | loyal | 1 | 28756 | 4 | 0.483 | 59536.2 |
529 | 2022-04-25 11:01:45 | loyal | 1 | 28756 | 4 | 0.656 | 43835.4 |
528 | 2022-04-24 02:10:15 | loyal | 1 | 28756 | 4 | 0.486 | 59168.7 |
527 | 2022-04-23 09:16:39 | loyal | 1 | 28756 | 4 | 0.483 | 59536.2 |
526 | 2022-04-22 12:05:14 | loyal | 1 | 28756 | 4 | 0.783 | 36725.4 |
525 | 2022-04-21 11:30:14 | loyal | 1 | 28756 | 4 | 0.610 | 47141.0 |
524 | 2022-04-20 17:45:22 | loyal | 1 | 28756 | 4 | 0.546 | 52666.7 |
523 | 2022-04-20 00:30:18 | loyal | 1 | 28756 | 4 | 0.483 | 59536.2 |
522 | 2022-04-19 11:30:19 | loyal | 1 | 28756 | 4 | 0.530 | 54256.6 |
521 | 2022-04-18 22:29:35 | loyal | 1 | 28756 | 4 | 0.466 | 61708.2 |
520 | 2022-04-17 22:01:52 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
519 | 2022-04-17 08:52:16 | loyal | 1 | 28756 | 4 | 0.436 | 65954.1 |
518 | 2022-04-16 13:03:53 | loyal | 1 | 28756 | 4 | 0.450 | 63902.2 |
517 | 2022-03-15 10:25:50 | loyal | 1 | 28756 | 4 | 0.530 | 54256.6 |
516 | 2022-03-14 14:14:21 | loyal | 1 | 28756 | 4 | 0.673 | 42728.1 |
515 | 2022-03-13 16:45:37 | loyal | 1 | 28756 | 4 | 0.486 | 59168.7 |
514 | 2022-03-12 18:09:00 | loyal | 1 | 28756 | 4 | 0.530 | 54256.6 |
513 | 2022-03-12 06:12:21 | loyal | 1 | 28756 | 4 | 0.453 | 63479.0 |
512 | 2022-02-27 12:18:16 | loyal | 3 | 83667 | 901 | 3.326 | 25155.4 |
511 | 2022-02-26 23:15:01 | loyal | 3 | 83667 | 901 | 3.360 | 24900.9 |
510 | 2022-02-24 19:08:32 | loyal | 3 | 83667 | 901 | 3.266 | 25617.6 |
509 | 2022-01-30 12:59:12 | loyal | 1 | 28756 | 4 | 0.516 | 55728.7 |
508 | 2022-01-28 09:24:31 | loyal | 1 | 28756 | 4 | 0.516 | 55728.7 |
507 | 2022-01-15 17:51:07 | loyal | 3 | 83667 | 901 | 3.733 | 22412.8 |
506 | 2021-12-13 07:42:52 | loyal | 3 | 83667 | 901 | 3.423 | 24442.6 |