History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sophs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
578 | 2024-04-05 17:29:26 | sophs | 2 | 53800 | 133 | 5.313 | 10126.1 |
577 | 2024-04-05 17:15:10 | sophs | 1 | 28756 | 9 | 0.580 | 49579.3 |
576 | 2024-04-01 17:37:55 | sophs | 1 | 28756 | 9 | 1.826 | 15748.1 |
575 | 2024-03-31 02:25:35 | sophs | 1 | 28756 | 9 | 0.516 | 55728.7 |
574 | 2024-03-29 08:49:45 | sophs | 2 | 53800 | 133 | 2.140 | 25140.2 |
573 | 2024-03-29 08:46:25 | sophs | 1 | 28756 | 9 | 0.780 | 36866.7 |
572 | 2024-03-20 07:50:40 | sophs | 1 | 28756 | 9 | 1.140 | 25224.6 |
571 | 2024-03-04 18:34:29 | sophs | 2 | 53800 | 133 | 1.876 | 28678.0 |
570 | 2024-03-04 18:18:22 | sophs | 1 | 28756 | 9 | 0.533 | 53951.2 |
569 | 2024-03-02 14:15:19 | sophs | 1 | 28756 | 9 | 1.533 | 18758.0 |
568 | 2024-03-02 14:14:57 | sophs | 2 | 53800 | 133 | 2.046 | 26295.2 |
567 | 2024-02-28 16:52:34 | sophs | 1 | 28756 | 9 | 0.530 | 54256.6 |
566 | 2024-02-28 07:34:21 | sophs | 1 | 28756 | 9 | 0.500 | 57512.0 |
565 | 2024-02-20 22:19:50 | sophs | 2 | 53800 | 133 | 1.813 | 29674.6 |
564 | 2024-02-03 17:18:39 | sophs | 1 | 28756 | 9 | 0.530 | 54256.6 |
563 | 2024-01-30 19:36:28 | sophs | 2 | 53800 | 133 | 1.576 | 34137.1 |
562 | 2024-01-29 04:38:45 | sophs | 1 | 28756 | 9 | 0.516 | 55728.7 |
561 | 2024-01-03 13:45:52 | sophs | 1 | 28756 | 9 | 0.546 | 52666.7 |
560 | 2023-12-13 03:11:48 | sophs | 1 | 28756 | 9 | 0.470 | 61183.0 |
559 | 2023-11-28 11:56:54 | sophs | 2 | 53800 | 133 | 1.530 | 35163.4 |
558 | 2023-11-20 02:02:59 | sophs | 2 | 53800 | 133 | 1.640 | 32804.9 |
557 | 2023-11-19 13:55:33 | sophs | 1 | 28756 | 9 | 0.516 | 55728.7 |
556 | 2023-11-18 09:10:25 | sophs | 2 | 53800 | 133 | 1.796 | 29955.5 |
555 | 2023-11-13 21:58:28 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
554 | 2023-11-08 21:17:14 | sophs | 2 | 53800 | 133 | 1.436 | 37465.2 |
553 | 2023-11-04 11:58:08 | sophs | 1 | 28756 | 9 | 0.563 | 51076.4 |
552 | 2023-10-26 21:03:55 | sophs | 1 | 28756 | 9 | 0.530 | 54256.6 |
551 | 2023-10-22 02:28:42 | sophs | 1 | 28756 | 9 | 0.483 | 59536.2 |
550 | 2023-10-19 22:29:26 | sophs | 1 | 28756 | 9 | 1.123 | 25606.4 |
549 | 2023-10-11 14:15:09 | sophs | 1 | 28756 | 9 | 0.466 | 61708.2 |
548 | 2023-10-07 10:20:26 | sophs | 1 | 28756 | 9 | 0.513 | 56054.6 |
547 | 2023-09-29 12:03:48 | sophs | 1 | 28756 | 9 | 0.546 | 52666.7 |
546 | 2023-09-23 16:06:36 | sophs | 1 | 28756 | 9 | 0.486 | 59168.7 |
545 | 2023-08-20 21:22:53 | sophs | 1 | 28756 | 9 | 0.483 | 59536.2 |
544 | 2023-08-12 04:54:09 | sophs | 2 | 53800 | 133 | 1.623 | 33148.5 |
543 | 2023-08-10 00:20:29 | sophs | 1 | 28756 | 9 | 1.000 | 28756.0 |
542 | 2023-05-23 13:27:59 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
541 | 2023-05-06 21:00:13 | sophs | 2 | 53800 | 133 | 1.423 | 37807.4 |
540 | 2023-04-24 00:09:10 | sophs | 2 | 53800 | 133 | 1.813 | 29674.6 |
539 | 2023-04-21 09:21:51 | sophs | 1 | 28756 | 9 | 0.513 | 56054.6 |
538 | 2023-04-02 02:02:33 | sophs | 2 | 53800 | 133 | 2.190 | 24566.2 |
537 | 2023-03-19 17:34:15 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
536 | 2023-03-18 21:01:39 | sophs | 1 | 28756 | 9 | 0.456 | 63061.4 |
535 | 2023-02-18 08:15:05 | sophs | 2 | 53800 | 133 | 1.376 | 39098.8 |
534 | 2023-01-28 19:39:43 | sophs | 2 | 53800 | 133 | 1.376 | 39098.8 |
533 | 2023-01-24 09:55:36 | sophs | 1 | 28756 | 9 | 0.906 | 31739.5 |
532 | 2023-01-08 05:06:22 | sophs | 1 | 28756 | 9 | 0.483 | 59536.2 |
531 | 2023-01-04 23:29:58 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
530 | 2022-12-31 06:53:19 | sophs | 2 | 53800 | 133 | 3.313 | 16239.1 |
529 | 2022-12-17 22:45:16 | sophs | 1 | 28756 | 9 | 0.500 | 57512.0 |
528 | 2022-12-13 15:27:49 | sophs | 2 | 53800 | 133 | 1.563 | 34421.0 |
527 | 2022-12-13 13:28:16 | sophs | 2 | 53800 | 133 | 1.376 | 39098.8 |
526 | 2022-12-10 04:01:30 | sophs | 1 | 28756 | 9 | 0.500 | 57512.0 |
525 | 2022-11-10 22:01:24 | sophs | 2 | 53800 | 133 | 1.436 | 37465.2 |
524 | 2022-11-06 11:55:01 | sophs | 1 | 28756 | 9 | 0.546 | 52666.7 |
523 | 2022-11-06 02:55:59 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
522 | 2022-10-30 08:34:49 | sophs | 1 | 28756 | 9 | 0.466 | 61708.2 |
521 | 2022-10-03 18:53:28 | sophs | 1 | 28756 | 9 | 0.470 | 61183.0 |
520 | 2022-08-28 23:58:19 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
519 | 2022-08-18 16:52:50 | sophs | 1 | 28756 | 9 | 0.503 | 57169.0 |
518 | 2022-08-14 14:24:54 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
517 | 2022-07-26 11:20:16 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
516 | 2022-06-13 12:18:24 | sophs | 2 | 53800 | 133 | 1.500 | 35866.7 |
515 | 2022-05-23 01:53:45 | sophs | 1 | 28756 | 9 | 0.513 | 56054.6 |
514 | 2022-04-17 07:25:32 | sophs | 1 | 28756 | 9 | 0.450 | 63902.2 |
513 | 2022-04-13 19:00:17 | sophs | 1 | 28756 | 9 | 0.466 | 61708.2 |
512 | 2022-03-22 09:12:48 | sophs | 1 | 28756 | 9 | 0.656 | 43835.4 |
511 | 2022-02-08 19:42:27 | sophs | 1 | 28756 | 9 | 0.470 | 61183.0 |
510 | 2022-02-06 20:08:02 | sophs | 1 | 28756 | 9 | 0.500 | 57512.0 |
509 | 2022-02-06 14:53:08 | sophs | 1 | 28756 | 9 | 0.533 | 53951.2 |
508 | 2022-02-01 00:08:18 | sophs | 1 | 28756 | 9 | 0.563 | 51076.4 |
507 | 2022-01-30 12:30:44 | sophs | 2 | 53800 | 133 | 1.406 | 38264.6 |
506 | 2022-01-28 07:40:07 | sophs | 2 | 53800 | 133 | 1.420 | 37887.3 |
505 | 2022-01-21 04:21:24 | sophs | 1 | 28756 | 9 | 0.546 | 52666.7 |
504 | 2021-12-30 14:18:22 | sophs | 1 | 28756 | 9 | 1.046 | 27491.4 |
503 | 2021-12-22 21:49:47 | sophs | 1 | 28756 | 9 | 0.530 | 54256.6 |
502 | 2021-11-24 04:02:01 | sophs | 1 | 28756 | 9 | 0.580 | 49579.3 |
501 | 2021-11-22 02:28:26 | sophs | 1 | 28756 | 9 | 0.500 | 57512.0 |
500 | 2021-10-29 20:05:56 | sophs | 2 | 53800 | 133 | 2.156 | 24953.6 |
499 | 2021-10-05 18:04:34 | sophs | 1 | 28756 | 9 | 0.533 | 53951.2 |
498 | 2021-09-12 11:29:48 | sophs | 1 | 28756 | 9 | 0.516 | 55728.7 |
497 | 2021-09-06 00:07:37 | sophs | 1 | 28756 | 9 | 1.013 | 28387.0 |
496 | 2021-09-03 12:34:28 | sophs | 1 | 28756 | 9 | 0.486 | 59168.7 |
495 | 2021-09-01 06:31:08 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
494 | 2021-08-29 00:05:26 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
493 | 2021-08-21 00:08:37 | sophs | 1 | 28756 | 9 | 0.513 | 56054.6 |
492 | 2021-08-14 19:32:24 | sophs | 1 | 28756 | 9 | 0.530 | 54256.6 |
491 | 2021-08-13 00:02:23 | sophs | 1 | 28756 | 9 | 0.436 | 65954.1 |
490 | 2021-07-18 06:25:33 | sophs | 1 | 28756 | 9 | 0.500 | 57512.0 |
489 | 2021-07-17 10:53:05 | sophs | 1 | 28756 | 9 | 0.453 | 63479.0 |
488 | 2021-07-02 13:49:50 | sophs | 2 | 53800 | 133 | 1.546 | 34799.5 |
487 | 2021-06-25 17:10:00 | sophs | 1 | 28756 | 9 | 0.530 | 54256.6 |
486 | 2021-06-12 15:51:46 | sophs | 1 | 28756 | 9 | 0.500 | 57512.0 |
485 | 2021-06-12 06:08:24 | sophs | 1 | 28756 | 9 | 0.533 | 53951.2 |
484 | 2021-05-07 11:11:58 | sophs | 1 | 28756 | 9 | 0.500 | 57512.0 |
483 | 2021-04-06 22:16:45 | sophs | 1 | 28756 | 9 | 0.546 | 52666.7 |
482 | 2021-03-21 08:30:02 | sophs | 1 | 28756 | 9 | 0.470 | 61183.0 |
481 | 2021-03-09 04:41:10 | sophs | 1 | 28756 | 9 | 0.470 | 61183.0 |
480 | 2021-02-23 23:47:31 | sophs | 1 | 28756 | 9 | 0.450 | 63902.2 |
479 | 2021-01-31 00:00:52 | sophs | 1 | 28756 | 9 | 0.513 | 56054.6 |