History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trait"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
561 | 2024-04-30 05:40:33 | trait | 1 | 28756 | 9 | 0.513 | 56054.6 |
560 | 2024-04-29 11:16:55 | trait | 1 | 28756 | 9 | 1.140 | 25224.6 |
559 | 2024-04-28 22:16:31 | trait | 1 | 28756 | 9 | 0.440 | 65354.5 |
558 | 2024-04-19 01:59:59 | trait | 1 | 28756 | 9 | 0.830 | 34645.8 |
557 | 2024-04-03 06:05:35 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
556 | 2024-03-31 02:07:15 | trait | 1 | 28756 | 9 | 1.110 | 25906.3 |
555 | 2024-03-29 01:37:56 | trait | 1 | 28756 | 9 | 1.343 | 21411.8 |
554 | 2024-03-03 20:52:34 | trait | 1 | 28756 | 9 | 0.580 | 49579.3 |
553 | 2024-03-01 00:35:36 | trait | 1 | 28756 | 9 | 1.096 | 26237.2 |
552 | 2024-02-27 20:21:00 | trait | 1 | 28756 | 9 | 0.720 | 39938.9 |
551 | 2024-02-23 02:59:15 | trait | 1 | 28756 | 9 | 1.576 | 18246.2 |
550 | 2024-01-29 00:36:32 | trait | 1 | 28756 | 9 | 0.533 | 53951.2 |
549 | 2024-01-28 20:16:25 | trait | 1 | 28756 | 9 | 0.560 | 51350.0 |
548 | 2024-01-21 05:06:54 | trait | 2 | 53800 | 127 | 1.530 | 35163.4 |
547 | 2023-12-16 18:11:55 | trait | 2 | 53800 | 127 | 1.626 | 33087.3 |
546 | 2023-12-07 12:42:51 | trait | 1 | 28756 | 9 | 0.483 | 59536.2 |
545 | 2023-12-07 12:42:50 | trait | 1 | 28756 | 9 | 0.440 | 65354.5 |
544 | 2023-12-06 03:16:30 | trait | 1 | 28756 | 9 | 1.043 | 27570.5 |
543 | 2023-11-18 06:47:36 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
542 | 2023-11-12 03:40:46 | trait | 1 | 28756 | 9 | 0.466 | 61708.2 |
541 | 2023-11-04 01:43:18 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
540 | 2023-10-23 03:04:06 | trait | 1 | 28756 | 9 | 0.516 | 55728.7 |
539 | 2023-10-19 22:28:17 | trait | 1 | 28756 | 9 | 0.483 | 59536.2 |
538 | 2023-10-14 04:38:26 | trait | 1 | 28756 | 9 | 0.453 | 63479.0 |
537 | 2023-10-13 07:36:16 | trait | 1 | 28756 | 9 | 0.436 | 65954.1 |
536 | 2023-10-03 16:11:54 | trait | 1 | 28756 | 9 | 0.440 | 65354.5 |
535 | 2023-09-26 07:46:38 | trait | 1 | 28756 | 9 | 0.450 | 63902.2 |
534 | 2023-09-20 14:25:10 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
533 | 2023-07-14 17:35:50 | trait | 1 | 28756 | 9 | 0.483 | 59536.2 |
532 | 2023-06-17 01:46:56 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
531 | 2023-04-19 22:29:53 | trait | 1 | 28756 | 9 | 0.453 | 63479.0 |
530 | 2023-02-22 11:34:40 | trait | 1 | 28756 | 9 | 0.466 | 61708.2 |
529 | 2023-02-07 08:25:29 | trait | 1 | 28756 | 9 | 0.420 | 68466.7 |
528 | 2022-12-20 07:54:36 | trait | 1 | 28756 | 9 | 0.436 | 65954.1 |
527 | 2022-12-06 17:21:48 | trait | 1 | 28756 | 9 | 1.030 | 27918.4 |
526 | 2022-11-27 05:48:30 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
525 | 2022-11-23 02:31:55 | trait | 1 | 28756 | 9 | 0.513 | 56054.6 |
524 | 2022-10-22 05:24:14 | trait | 1 | 28756 | 9 | 0.470 | 61183.0 |
523 | 2022-09-01 02:26:25 | trait | 1 | 28756 | 9 | 0.530 | 54256.6 |
522 | 2022-08-03 03:38:57 | trait | 1 | 28756 | 9 | 0.453 | 63479.0 |
521 | 2022-06-09 19:15:11 | trait | 1 | 28756 | 9 | 0.470 | 61183.0 |
520 | 2022-06-06 04:40:17 | trait | 1 | 28756 | 9 | 0.440 | 65354.5 |
519 | 2022-04-03 18:37:30 | trait | 1 | 28756 | 9 | 0.453 | 63479.0 |
518 | 2022-04-01 14:38:52 | trait | 1 | 28756 | 9 | 0.436 | 65954.1 |
517 | 2022-01-26 01:30:26 | trait | 1 | 28756 | 9 | 0.796 | 36125.6 |
516 | 2022-01-03 06:06:37 | trait | 1 | 28756 | 9 | 0.563 | 51076.4 |
515 | 2021-12-28 02:49:55 | trait | 1 | 28756 | 9 | 0.436 | 65954.1 |
514 | 2021-11-29 04:40:04 | trait | 1 | 28756 | 9 | 0.766 | 37540.5 |
513 | 2021-11-24 18:25:19 | trait | 2 | 53800 | 127 | 1.640 | 32804.9 |
512 | 2021-11-01 14:27:24 | trait | 1 | 28756 | 9 | 0.563 | 51076.4 |
511 | 2021-10-06 06:58:20 | trait | 1 | 28756 | 9 | 0.513 | 56054.6 |
510 | 2021-09-23 03:54:02 | trait | 1 | 28756 | 9 | 0.436 | 65954.1 |
509 | 2021-09-21 01:38:26 | trait | 1 | 28756 | 9 | 0.513 | 56054.6 |
508 | 2021-09-03 16:28:19 | trait | 1 | 28756 | 9 | 0.436 | 65954.1 |
507 | 2021-07-07 12:02:19 | trait | 1 | 28756 | 9 | 0.466 | 61708.2 |
506 | 2021-06-14 03:42:23 | trait | 2 | 53800 | 127 | 1.670 | 32215.6 |
505 | 2021-04-07 16:14:21 | trait | 1 | 28756 | 9 | 0.593 | 48492.4 |
504 | 2021-04-03 12:33:00 | trait | 1 | 28756 | 9 | 0.486 | 59168.7 |
503 | 2021-03-24 08:55:53 | trait | 2 | 53800 | 127 | 1.406 | 38264.6 |
502 | 2021-02-02 17:14:59 | trait | 2 | 53800 | 127 | 1.530 | 35163.4 |
501 | 2021-01-07 00:20:59 | trait | 2 | 53800 | 127 | 1.716 | 31352.0 |
500 | 2020-12-07 13:23:43 | trait | 1 | 28756 | 9 | 0.436 | 65954.1 |
499 | 2020-11-23 11:53:26 | trait | 1 | 28756 | 9 | 0.436 | 65954.1 |
498 | 2020-11-12 12:08:13 | trait | 2 | 53800 | 127 | 1.513 | 35558.5 |
497 | 2020-11-08 17:33:52 | trait | 2 | 53800 | 127 | 1.406 | 38264.6 |
496 | 2020-10-26 13:45:42 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
495 | 2020-10-25 12:07:55 | trait | 1 | 28756 | 9 | 0.516 | 55728.7 |
494 | 2020-10-20 10:15:05 | trait | 2 | 53800 | 127 | 1.580 | 34050.6 |
493 | 2020-10-18 05:55:52 | trait | 1 | 28756 | 9 | 0.483 | 59536.2 |
492 | 2020-10-17 06:30:27 | trait | 1 | 28756 | 9 | 0.453 | 63479.0 |
491 | 2020-10-03 22:27:52 | trait | 1 | 28756 | 9 | 0.563 | 51076.4 |
490 | 2020-09-16 06:34:55 | trait | 2 | 53800 | 127 | 1.390 | 38705.0 |
489 | 2020-09-12 10:28:38 | trait | 1 | 28756 | 9 | 0.453 | 63479.0 |
488 | 2020-08-25 02:41:11 | trait | 1 | 28756 | 9 | 0.450 | 63902.2 |
487 | 2020-08-19 10:18:43 | trait | 1 | 28756 | 9 | 0.516 | 55728.7 |
486 | 2020-08-04 00:15:13 | trait | 1 | 28756 | 9 | 0.483 | 59536.2 |
485 | 2020-07-20 20:01:31 | trait | 1 | 28756 | 9 | 0.483 | 59536.2 |
484 | 2020-07-20 05:55:26 | trait | 1 | 28756 | 9 | 0.466 | 61708.2 |
483 | 2020-07-12 14:38:06 | trait | 1 | 28756 | 9 | 0.470 | 61183.0 |
482 | 2020-05-15 00:05:07 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
481 | 2020-04-04 01:25:32 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
480 | 2020-03-30 03:28:43 | trait | 1 | 28756 | 9 | 0.516 | 55728.7 |
479 | 2020-03-26 21:34:33 | trait | 1 | 28756 | 9 | 1.093 | 26309.2 |
478 | 2020-03-24 13:40:07 | trait | 1 | 28756 | 9 | 0.546 | 52666.7 |
477 | 2020-03-23 08:00:38 | trait | 1 | 28756 | 9 | 1.033 | 27837.4 |
476 | 2020-03-21 14:21:35 | trait | 1 | 28756 | 9 | 0.436 | 65954.1 |
475 | 2020-03-20 01:14:45 | trait | 1 | 28756 | 9 | 0.513 | 56054.6 |
474 | 2020-03-18 17:17:23 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
473 | 2020-03-17 18:40:38 | trait | 1 | 28756 | 9 | 0.453 | 63479.0 |
472 | 2020-03-01 03:36:35 | trait | 1 | 28756 | 9 | 0.513 | 56054.6 |
471 | 2020-02-23 08:12:51 | trait | 1 | 28756 | 9 | 0.550 | 52283.6 |
470 | 2020-02-22 08:17:33 | trait | 1 | 28756 | 9 | 0.796 | 36125.6 |
469 | 2020-02-22 06:48:45 | trait | 1 | 28756 | 9 | 0.533 | 53951.2 |
468 | 2020-02-19 19:45:55 | trait | 1 | 28756 | 9 | 1.126 | 25538.2 |
467 | 2020-02-12 08:48:37 | trait | 1 | 28756 | 9 | 0.500 | 57512.0 |
466 | 2020-02-09 08:46:46 | trait | 1 | 28756 | 9 | 0.546 | 52666.7 |
465 | 2020-02-07 16:07:56 | trait | 1 | 28756 | 9 | 0.530 | 54256.6 |
464 | 2020-01-29 00:47:31 | trait | 1 | 28756 | 9 | 0.533 | 53951.2 |
463 | 2020-01-26 16:04:05 | trait | 1 | 28756 | 9 | 0.653 | 44036.8 |
462 | 2020-01-25 09:25:03 | trait | 1 | 28756 | 9 | 0.530 | 54256.6 |