History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trope"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
600 | 2024-04-03 03:52:26 | trope | 1 | 28756 | 13 | 1.216 | 23648.0 |
599 | 2024-03-30 21:23:15 | trope | 2 | 53800 | 184 | 3.690 | 14579.9 |
598 | 2024-03-30 21:23:05 | trope | 1 | 28756 | 13 | 0.546 | 52666.7 |
597 | 2024-03-30 21:22:45 | trope | 2 | 53800 | 184 | 5.186 | 10374.1 |
596 | 2024-03-30 21:21:04 | trope | 1 | 28756 | 13 | 1.076 | 26724.9 |
595 | 2024-03-29 09:22:55 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
594 | 2024-03-11 04:12:19 | trope | 1 | 28756 | 13 | 0.436 | 65954.1 |
593 | 2024-03-04 02:04:43 | trope | 2 | 53800 | 184 | 2.076 | 25915.2 |
592 | 2024-03-04 01:56:26 | trope | 1 | 28756 | 13 | 0.453 | 63479.0 |
591 | 2024-02-28 01:25:35 | trope | 1 | 28756 | 13 | 1.203 | 23903.6 |
590 | 2024-02-20 23:44:30 | trope | 2 | 53800 | 184 | 1.830 | 29398.9 |
589 | 2024-02-20 03:42:47 | trope | 2 | 53800 | 184 | 1.906 | 28226.7 |
588 | 2024-01-31 02:12:37 | trope | 1 | 28756 | 13 | 0.513 | 56054.6 |
587 | 2024-01-29 02:06:03 | trope | 1 | 28756 | 13 | 0.516 | 55728.7 |
586 | 2024-01-28 21:02:53 | trope | 1 | 28756 | 13 | 0.533 | 53951.2 |
585 | 2024-01-17 19:57:00 | trope | 2 | 53800 | 184 | 1.703 | 31591.3 |
584 | 2024-01-15 16:54:07 | trope | 2 | 53800 | 184 | 1.673 | 32157.8 |
583 | 2023-12-30 05:46:33 | trope | 2 | 53800 | 184 | 1.393 | 38621.7 |
582 | 2023-12-23 11:30:40 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
581 | 2023-12-04 18:47:55 | trope | 1 | 28756 | 13 | 0.436 | 65954.1 |
580 | 2023-12-04 18:47:54 | trope | 1 | 28756 | 13 | 0.436 | 65954.1 |
579 | 2023-11-26 03:42:49 | trope | 1 | 28756 | 13 | 0.453 | 63479.0 |
578 | 2023-11-18 12:14:40 | trope | 1 | 28756 | 13 | 0.513 | 56054.6 |
577 | 2023-11-18 04:02:05 | trope | 2 | 53800 | 184 | 1.513 | 35558.5 |
576 | 2023-11-13 05:56:32 | trope | 1 | 28756 | 13 | 0.483 | 59536.2 |
575 | 2023-11-10 01:12:24 | trope | 1 | 28756 | 13 | 0.420 | 68466.7 |
574 | 2023-11-07 08:14:27 | trope | 1 | 28756 | 13 | 0.486 | 59168.7 |
573 | 2023-11-03 23:25:48 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
572 | 2023-11-02 08:46:55 | trope | 2 | 53800 | 184 | 3.623 | 14849.6 |
571 | 2023-11-02 07:44:39 | trope | 1 | 28756 | 13 | 0.530 | 54256.6 |
570 | 2023-10-22 01:23:50 | trope | 1 | 28756 | 13 | 0.513 | 56054.6 |
569 | 2023-10-21 09:40:48 | trope | 1 | 28756 | 13 | 0.546 | 52666.7 |
568 | 2023-10-19 07:20:01 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
567 | 2023-10-11 16:32:48 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
566 | 2023-10-08 18:49:08 | trope | 1 | 28756 | 13 | 0.456 | 63061.4 |
565 | 2023-10-05 10:58:03 | trope | 2 | 53800 | 184 | 1.750 | 30742.9 |
564 | 2023-10-01 05:40:12 | trope | 2 | 53800 | 184 | 1.670 | 32215.6 |
563 | 2023-09-29 04:47:34 | trope | 1 | 28756 | 13 | 0.423 | 67981.1 |
562 | 2023-09-28 13:21:47 | trope | 2 | 53800 | 184 | 1.390 | 38705.0 |
561 | 2023-09-22 11:30:24 | trope | 1 | 28756 | 13 | 0.483 | 59536.2 |
560 | 2023-09-11 13:59:07 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
559 | 2023-08-19 20:51:07 | trope | 2 | 53800 | 184 | 2.720 | 19779.4 |
558 | 2023-06-27 17:16:17 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
557 | 2023-06-19 17:14:37 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
556 | 2023-05-06 18:39:47 | trope | 2 | 53800 | 184 | 1.360 | 39558.8 |
555 | 2023-04-03 06:22:25 | trope | 1 | 28756 | 13 | 0.420 | 68466.7 |
554 | 2023-03-08 13:45:41 | trope | 1 | 28756 | 13 | 0.423 | 67981.1 |
553 | 2023-02-11 01:10:48 | trope | 2 | 53800 | 184 | 1.360 | 39558.8 |
552 | 2023-01-18 17:50:39 | trope | 1 | 28756 | 13 | 0.440 | 65354.5 |
551 | 2022-11-23 12:56:06 | trope | 2 | 53800 | 184 | 1.423 | 37807.4 |
550 | 2022-11-13 20:26:54 | trope | 1 | 28756 | 13 | 0.483 | 59536.2 |
549 | 2022-11-13 00:40:39 | trope | 1 | 28756 | 13 | 0.440 | 65354.5 |
548 | 2022-07-20 03:30:39 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
547 | 2022-07-05 15:52:15 | trope | 1 | 28756 | 13 | 0.420 | 68466.7 |
546 | 2022-04-22 01:09:00 | trope | 2 | 53800 | 184 | 2.343 | 22962.0 |
545 | 2022-03-22 14:57:37 | trope | 1 | 28756 | 13 | 0.580 | 49579.3 |
544 | 2022-03-14 18:20:32 | trope | 1 | 28756 | 13 | 0.640 | 44931.3 |
543 | 2022-03-12 13:47:41 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
542 | 2022-02-12 12:29:06 | trope | 1 | 28756 | 13 | 0.593 | 48492.4 |
541 | 2022-02-06 23:59:34 | trope | 1 | 28756 | 13 | 0.456 | 63061.4 |
540 | 2022-02-06 12:43:41 | trope | 1 | 28756 | 13 | 0.513 | 56054.6 |
539 | 2022-02-05 17:29:29 | trope | 1 | 28756 | 13 | 0.563 | 51076.4 |
538 | 2022-02-05 01:46:21 | trope | 1 | 28756 | 13 | 0.436 | 65954.1 |
537 | 2022-02-04 17:29:08 | trope | 1 | 28756 | 13 | 0.516 | 55728.7 |
536 | 2022-02-04 04:29:01 | trope | 1 | 28756 | 13 | 0.483 | 59536.2 |
535 | 2022-02-03 18:18:54 | trope | 1 | 28756 | 13 | 0.530 | 54256.6 |
534 | 2022-02-03 10:17:21 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
533 | 2022-02-02 20:22:18 | trope | 1 | 28756 | 13 | 0.453 | 63479.0 |
532 | 2022-02-02 04:52:10 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
531 | 2022-02-01 16:24:10 | trope | 1 | 28756 | 13 | 0.453 | 63479.0 |
530 | 2022-02-01 05:19:12 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
529 | 2022-01-31 13:38:17 | trope | 1 | 28756 | 13 | 0.466 | 61708.2 |
528 | 2022-01-31 04:08:01 | trope | 1 | 28756 | 13 | 1.080 | 26625.9 |
527 | 2022-01-30 20:59:21 | trope | 1 | 28756 | 13 | 0.453 | 63479.0 |
526 | 2022-01-30 09:18:55 | trope | 1 | 28756 | 13 | 0.453 | 63479.0 |
525 | 2022-01-29 15:53:08 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
524 | 2021-12-20 19:33:49 | trope | 1 | 28756 | 13 | 0.513 | 56054.6 |
523 | 2021-12-17 15:34:27 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |
522 | 2021-12-17 04:49:52 | trope | 1 | 28756 | 13 | 1.063 | 27051.7 |
521 | 2021-12-16 21:27:04 | trope | 1 | 28756 | 13 | 0.486 | 59168.7 |
520 | 2021-12-15 18:46:57 | trope | 1 | 28756 | 13 | 0.440 | 65354.5 |
519 | 2021-12-15 02:44:03 | trope | 1 | 28756 | 13 | 0.436 | 65954.1 |
518 | 2021-12-14 15:46:16 | trope | 1 | 28756 | 13 | 0.456 | 63061.4 |
517 | 2021-12-02 02:15:07 | trope | 1 | 28756 | 13 | 0.453 | 63479.0 |
516 | 2021-11-15 22:27:33 | trope | 1 | 28756 | 13 | 0.860 | 33437.2 |
515 | 2021-11-15 11:24:00 | trope | 1 | 28756 | 13 | 0.516 | 55728.7 |
514 | 2021-11-14 16:27:06 | trope | 1 | 28756 | 13 | 0.546 | 52666.7 |
513 | 2021-11-14 00:33:29 | trope | 1 | 28756 | 13 | 1.016 | 28303.1 |
512 | 2021-11-13 13:29:23 | trope | 1 | 28756 | 13 | 0.533 | 53951.2 |
511 | 2021-11-12 22:48:41 | trope | 1 | 28756 | 13 | 0.513 | 56054.6 |
510 | 2021-11-12 12:52:12 | trope | 1 | 28756 | 13 | 0.516 | 55728.7 |
509 | 2021-11-11 20:20:41 | trope | 1 | 28756 | 13 | 0.436 | 65954.1 |
508 | 2021-11-11 09:32:39 | trope | 1 | 28756 | 13 | 0.533 | 53951.2 |
507 | 2021-11-10 22:53:47 | trope | 1 | 28756 | 13 | 0.516 | 55728.7 |
506 | 2021-11-10 19:29:37 | trope | 1 | 28756 | 13 | 0.516 | 55728.7 |
505 | 2021-10-27 20:41:33 | trope | 1 | 28756 | 13 | 0.453 | 63479.0 |
504 | 2021-10-26 17:02:39 | trope | 1 | 28756 | 13 | 0.483 | 59536.2 |
503 | 2021-10-25 20:03:46 | trope | 1 | 28756 | 13 | 0.483 | 59536.2 |
502 | 2021-10-25 06:37:50 | trope | 1 | 28756 | 13 | 0.453 | 63479.0 |
501 | 2021-10-24 22:18:05 | trope | 1 | 28756 | 13 | 0.500 | 57512.0 |