History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"agile"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
608 | 2024-04-27 03:04:51 | agile | 2 | 53800 | 128 | 3.733 | 14412.0 |
607 | 2024-04-20 19:51:45 | agile | 1 | 28756 | 4 | 0.500 | 57512.0 |
606 | 2024-04-03 14:47:46 | agile | 2 | 53800 | 128 | 5.876 | 9155.9 |
605 | 2024-04-03 07:59:46 | agile | 2 | 53800 | 128 | 3.986 | 13497.2 |
604 | 2024-04-03 07:20:33 | agile | 1 | 28756 | 4 | 0.470 | 61183.0 |
603 | 2024-03-31 14:57:28 | agile | 1 | 28756 | 4 | 0.546 | 52666.7 |
602 | 2024-03-28 05:19:40 | agile | 1 | 28756 | 4 | 0.470 | 61183.0 |
601 | 2024-03-27 07:44:51 | agile | 1 | 28756 | 4 | 0.470 | 61183.0 |
600 | 2024-03-04 00:08:24 | agile | 1 | 28756 | 4 | 0.516 | 55728.7 |
599 | 2024-03-01 12:15:53 | agile | 1 | 28756 | 4 | 0.466 | 61708.2 |
598 | 2024-02-26 00:36:57 | agile | 1 | 28756 | 4 | 0.593 | 48492.4 |
597 | 2024-02-03 01:56:39 | agile | 1 | 28756 | 4 | 0.516 | 55728.7 |
596 | 2024-01-28 17:16:11 | agile | 1 | 28756 | 4 | 0.516 | 55728.7 |
595 | 2024-01-26 23:41:01 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
594 | 2024-01-25 22:15:44 | agile | 1 | 28756 | 4 | 0.530 | 54256.6 |
593 | 2024-01-21 16:28:29 | agile | 1 | 28756 | 4 | 0.483 | 59536.2 |
592 | 2023-12-28 14:43:23 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
591 | 2023-11-28 22:07:20 | agile | 2 | 53800 | 128 | 3.513 | 15314.5 |
590 | 2023-11-24 05:03:33 | agile | 1 | 28756 | 4 | 0.580 | 49579.3 |
589 | 2023-11-21 16:15:09 | agile | 2 | 53800 | 128 | 1.406 | 38264.6 |
588 | 2023-11-21 07:47:56 | agile | 1 | 28756 | 4 | 0.530 | 54256.6 |
587 | 2023-11-15 05:25:12 | agile | 2 | 53800 | 128 | 1.500 | 35866.7 |
586 | 2023-11-09 09:19:57 | agile | 2 | 53800 | 128 | 1.626 | 33087.3 |
585 | 2023-11-09 02:08:53 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
584 | 2023-11-08 15:37:36 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
583 | 2023-10-27 15:30:45 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
582 | 2023-10-26 09:56:19 | agile | 1 | 28756 | 4 | 0.483 | 59536.2 |
581 | 2023-10-23 01:10:40 | agile | 2 | 53800 | 128 | 1.436 | 37465.2 |
580 | 2023-10-21 08:41:40 | agile | 1 | 28756 | 4 | 0.440 | 65354.5 |
579 | 2023-10-17 01:14:59 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
578 | 2023-10-14 05:42:33 | agile | 1 | 28756 | 4 | 0.436 | 65954.1 |
577 | 2023-10-10 14:28:50 | agile | 1 | 28756 | 4 | 0.470 | 61183.0 |
576 | 2023-10-07 05:41:00 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
575 | 2023-10-03 16:29:07 | agile | 1 | 28756 | 4 | 0.440 | 65354.5 |
574 | 2023-09-26 03:22:42 | agile | 1 | 28756 | 4 | 0.483 | 59536.2 |
573 | 2023-09-25 07:59:43 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
572 | 2023-09-22 05:56:38 | agile | 1 | 28756 | 4 | 1.080 | 26625.9 |
571 | 2023-09-07 03:53:11 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
570 | 2023-06-30 21:12:49 | agile | 1 | 28756 | 4 | 0.440 | 65354.5 |
569 | 2023-06-11 05:24:51 | agile | 1 | 28756 | 4 | 0.436 | 65954.1 |
568 | 2023-03-30 18:14:20 | agile | 1 | 28756 | 4 | 0.436 | 65954.1 |
567 | 2023-03-28 03:49:45 | agile | 1 | 28756 | 4 | 0.436 | 65954.1 |
566 | 2023-03-26 22:39:56 | agile | 1 | 28756 | 4 | 0.483 | 59536.2 |
565 | 2023-01-14 16:07:43 | agile | 1 | 28756 | 4 | 0.436 | 65954.1 |
564 | 2022-12-26 16:19:31 | agile | 1 | 28756 | 4 | 0.436 | 65954.1 |
563 | 2022-10-29 16:23:52 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
562 | 2022-09-19 12:55:01 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
561 | 2022-08-25 19:13:57 | agile | 1 | 28756 | 4 | 0.483 | 59536.2 |
560 | 2022-06-17 21:11:45 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
559 | 2022-06-09 18:16:16 | agile | 1 | 28756 | 4 | 0.450 | 63902.2 |
558 | 2022-06-06 03:39:17 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
557 | 2022-03-01 15:58:28 | agile | 1 | 28756 | 4 | 0.610 | 47141.0 |
556 | 2022-02-25 08:25:37 | agile | 1 | 28756 | 4 | 0.703 | 40904.7 |
555 | 2021-12-27 15:46:27 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
554 | 2021-12-14 08:52:28 | agile | 1 | 28756 | 4 | 0.466 | 61708.2 |
553 | 2021-12-10 05:01:33 | agile | 1 | 28756 | 4 | 0.516 | 55728.7 |
552 | 2021-11-28 01:38:03 | agile | 1 | 28756 | 4 | 0.466 | 61708.2 |
551 | 2021-11-23 03:55:16 | agile | 1 | 28756 | 4 | 0.436 | 65954.1 |
550 | 2021-11-21 22:04:54 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
549 | 2021-11-12 17:13:56 | agile | 1 | 28756 | 4 | 0.500 | 57512.0 |
548 | 2021-11-06 13:10:55 | agile | 1 | 28756 | 4 | 0.516 | 55728.7 |
547 | 2021-11-05 22:11:53 | agile | 1 | 28756 | 4 | 0.513 | 56054.6 |
546 | 2021-11-01 15:17:34 | agile | 1 | 28756 | 4 | 0.546 | 52666.7 |
545 | 2021-10-07 04:18:16 | agile | 1 | 28756 | 4 | 0.500 | 57512.0 |
544 | 2021-08-27 03:57:09 | agile | 1 | 28756 | 4 | 0.890 | 32310.1 |
543 | 2021-08-25 05:28:49 | agile | 1 | 28756 | 4 | 0.500 | 57512.0 |
542 | 2021-08-25 00:09:24 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
541 | 2021-08-12 17:08:03 | agile | 1 | 28756 | 4 | 0.516 | 55728.7 |
540 | 2021-08-10 02:04:59 | agile | 1 | 28756 | 4 | 0.483 | 59536.2 |
539 | 2021-06-07 15:57:25 | agile | 1 | 28756 | 4 | 0.546 | 52666.7 |
538 | 2021-05-24 08:49:18 | agile | 1 | 28756 | 4 | 0.533 | 53951.2 |
537 | 2021-05-13 16:28:10 | agile | 1 | 28756 | 4 | 0.500 | 57512.0 |
536 | 2021-05-04 10:54:32 | agile | 1 | 28756 | 4 | 0.530 | 54256.6 |
535 | 2021-05-01 22:16:41 | agile | 1 | 28756 | 4 | 1.000 | 28756.0 |
534 | 2021-02-23 11:35:11 | agile | 1 | 28756 | 4 | 0.500 | 57512.0 |
533 | 2021-02-18 18:55:34 | agile | 1 | 28756 | 4 | 0.516 | 55728.7 |
532 | 2021-02-11 08:55:00 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
531 | 2020-12-01 04:07:09 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
530 | 2020-11-09 17:47:34 | agile | 1 | 28756 | 4 | 0.436 | 65954.1 |
529 | 2020-10-30 07:47:58 | agile | 1 | 28756 | 4 | 0.466 | 61708.2 |
528 | 2020-10-21 19:47:37 | agile | 1 | 28756 | 4 | 0.440 | 65354.5 |
527 | 2020-09-24 07:39:12 | agile | 1 | 28756 | 4 | 0.436 | 65954.1 |
526 | 2020-08-30 09:38:40 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
525 | 2020-08-08 06:57:06 | agile | 1 | 28756 | 4 | 0.500 | 57512.0 |
524 | 2020-08-07 06:26:38 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
523 | 2020-07-29 16:47:36 | agile | 1 | 28756 | 4 | 0.546 | 52666.7 |
522 | 2020-07-10 20:35:17 | agile | 1 | 28756 | 4 | 0.483 | 59536.2 |
521 | 2020-05-06 12:01:49 | agile | 2 | 53800 | 128 | 1.580 | 34050.6 |
520 | 2020-05-05 20:47:57 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
519 | 2020-05-05 05:25:14 | agile | 1 | 28756 | 4 | 0.576 | 49923.6 |
518 | 2020-05-02 01:24:24 | agile | 1 | 28756 | 4 | 0.546 | 52666.7 |
517 | 2020-03-27 04:19:46 | agile | 1 | 28756 | 4 | 1.110 | 25906.3 |
516 | 2020-03-24 20:56:43 | agile | 1 | 28756 | 4 | 1.046 | 27491.4 |
515 | 2020-03-23 01:35:46 | agile | 1 | 28756 | 4 | 0.546 | 52666.7 |
514 | 2020-03-22 10:33:48 | agile | 1 | 28756 | 4 | 0.453 | 63479.0 |
513 | 2020-03-22 05:08:57 | agile | 1 | 28756 | 4 | 0.483 | 59536.2 |
512 | 2020-03-20 23:41:35 | agile | 1 | 28756 | 4 | 0.546 | 52666.7 |
511 | 2020-03-18 01:04:44 | agile | 1 | 28756 | 4 | 0.500 | 57512.0 |
510 | 2020-03-05 01:48:05 | agile | 2 | 53800 | 128 | 1.610 | 33416.1 |
509 | 2020-03-03 16:51:01 | agile | 2 | 53800 | 128 | 1.766 | 30464.3 |