History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
579 | 2024-05-09 14:30:36 | chain | 1 | 28756 | 8 | 0.563 | 51076.4 |
578 | 2024-05-04 13:25:31 | chain | 1 | 28756 | 8 | 1.063 | 27051.7 |
577 | 2024-05-02 01:46:57 | chain | 1 | 28756 | 8 | 0.546 | 52666.7 |
576 | 2024-05-01 04:52:16 | chain | 2 | 53800 | 130 | 3.656 | 14715.5 |
575 | 2024-05-01 04:52:12 | chain | 1 | 28756 | 8 | 1.016 | 28303.1 |
574 | 2024-05-01 04:52:04 | chain | 2 | 53800 | 130 | 3.420 | 15731.0 |
573 | 2024-05-01 04:51:59 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
572 | 2024-04-27 19:14:56 | chain | 1 | 28756 | 8 | 0.530 | 54256.6 |
571 | 2024-04-18 22:26:25 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
570 | 2024-04-03 06:41:14 | chain | 1 | 28756 | 8 | 1.156 | 24875.4 |
569 | 2024-03-31 15:23:00 | chain | 1 | 28756 | 8 | 0.513 | 56054.6 |
568 | 2024-03-27 02:56:49 | chain | 1 | 28756 | 8 | 0.563 | 51076.4 |
567 | 2024-03-04 01:09:11 | chain | 2 | 53800 | 130 | 1.623 | 33148.5 |
566 | 2024-03-04 01:08:47 | chain | 1 | 28756 | 8 | 0.513 | 56054.6 |
565 | 2024-03-01 07:40:20 | chain | 1 | 28756 | 8 | 0.513 | 56054.6 |
564 | 2024-02-25 22:58:30 | chain | 1 | 28756 | 8 | 1.110 | 25906.3 |
563 | 2024-02-02 21:13:03 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
562 | 2024-01-26 21:16:17 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
561 | 2024-01-14 22:03:09 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
560 | 2024-01-04 20:04:15 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
559 | 2023-12-27 05:20:36 | chain | 2 | 53800 | 130 | 1.530 | 35163.4 |
558 | 2023-12-05 15:06:39 | chain | 2 | 53800 | 130 | 1.326 | 40573.2 |
557 | 2023-11-25 00:10:27 | chain | 2 | 53800 | 130 | 1.516 | 35488.1 |
556 | 2023-11-13 04:07:18 | chain | 1 | 28756 | 8 | 0.530 | 54256.6 |
555 | 2023-11-09 14:57:09 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
554 | 2023-10-28 02:56:49 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
553 | 2023-10-26 20:02:43 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
552 | 2023-10-20 17:38:57 | chain | 1 | 28756 | 8 | 0.440 | 65354.5 |
551 | 2023-10-17 22:32:40 | chain | 1 | 28756 | 8 | 0.576 | 49923.6 |
550 | 2023-10-13 10:24:09 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
549 | 2023-10-04 14:28:59 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
548 | 2023-10-01 08:35:19 | chain | 1 | 28756 | 8 | 0.456 | 63061.4 |
547 | 2023-09-28 02:21:38 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
546 | 2023-09-26 10:29:21 | chain | 2 | 53800 | 130 | 1.500 | 35866.7 |
545 | 2023-09-24 01:51:19 | chain | 1 | 28756 | 8 | 0.470 | 61183.0 |
544 | 2023-09-19 15:36:15 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
543 | 2023-09-12 23:28:01 | chain | 1 | 28756 | 8 | 0.450 | 63902.2 |
542 | 2023-08-21 06:05:10 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
541 | 2023-06-24 04:08:33 | chain | 1 | 28756 | 8 | 0.470 | 61183.0 |
540 | 2023-06-20 19:08:39 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
539 | 2023-05-22 03:51:22 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
538 | 2023-03-31 15:07:58 | chain | 1 | 28756 | 8 | 0.533 | 53951.2 |
537 | 2023-03-18 12:23:39 | chain | 1 | 28756 | 8 | 0.423 | 67981.1 |
536 | 2023-03-16 09:17:08 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
535 | 2023-01-05 05:06:44 | chain | 1 | 28756 | 8 | 0.486 | 59168.7 |
534 | 2022-12-07 00:39:29 | chain | 1 | 28756 | 8 | 0.876 | 32826.5 |
533 | 2022-09-27 20:32:56 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
532 | 2022-09-02 01:07:46 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
531 | 2022-08-27 01:50:05 | chain | 1 | 28756 | 8 | 0.440 | 65354.5 |
530 | 2022-08-15 18:45:18 | chain | 1 | 28756 | 8 | 0.486 | 59168.7 |
529 | 2022-08-14 16:54:25 | chain | 1 | 28756 | 8 | 0.456 | 63061.4 |
528 | 2022-08-06 06:46:49 | chain | 1 | 28756 | 8 | 0.470 | 61183.0 |
527 | 2022-07-30 07:54:26 | chain | 1 | 28756 | 8 | 0.546 | 52666.7 |
526 | 2022-07-29 01:25:27 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
525 | 2022-07-17 18:39:26 | chain | 1 | 28756 | 8 | 0.440 | 65354.5 |
524 | 2022-05-29 13:16:10 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
523 | 2022-05-14 07:26:02 | chain | 1 | 28756 | 8 | 0.440 | 65354.5 |
522 | 2022-05-10 21:50:38 | chain | 1 | 28756 | 8 | 0.546 | 52666.7 |
521 | 2022-05-09 04:16:21 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
520 | 2022-03-14 08:58:01 | chain | 1 | 28756 | 8 | 0.716 | 40162.0 |
519 | 2022-02-06 02:55:42 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
518 | 2022-01-25 22:28:59 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
517 | 2021-11-29 16:42:13 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
516 | 2021-11-27 15:00:08 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
515 | 2021-11-18 18:11:52 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
514 | 2021-11-01 21:23:51 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
513 | 2021-10-07 02:32:03 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
512 | 2021-08-31 10:14:39 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
511 | 2021-08-16 04:12:01 | chain | 1 | 28756 | 8 | 0.610 | 47141.0 |
510 | 2021-08-02 01:54:56 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
509 | 2021-06-30 21:08:33 | chain | 1 | 28756 | 8 | 0.466 | 61708.2 |
508 | 2021-05-01 11:43:45 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
507 | 2021-04-12 16:10:11 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
506 | 2021-01-29 01:31:12 | chain | 1 | 28756 | 8 | 0.440 | 65354.5 |
505 | 2021-01-26 22:40:18 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
504 | 2021-01-26 22:26:07 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
503 | 2021-01-26 22:13:51 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
502 | 2021-01-26 22:02:25 | chain | 1 | 28756 | 8 | 0.486 | 59168.7 |
501 | 2021-01-26 13:50:13 | chain | 1 | 28756 | 8 | 0.546 | 52666.7 |
500 | 2020-12-28 16:10:51 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
499 | 2020-10-26 06:31:08 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
498 | 2020-10-26 02:07:59 | chain | 1 | 28756 | 8 | 0.513 | 56054.6 |
497 | 2020-10-14 18:06:59 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
496 | 2020-09-26 10:41:51 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
495 | 2020-08-24 23:59:26 | chain | 1 | 28756 | 8 | 0.563 | 51076.4 |
494 | 2020-08-17 04:49:36 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
493 | 2020-08-08 10:15:31 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
492 | 2020-07-22 14:47:13 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
491 | 2020-05-22 16:03:48 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
490 | 2020-04-20 16:47:24 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
489 | 2020-03-24 12:12:02 | chain | 1 | 28756 | 8 | 0.546 | 52666.7 |
488 | 2020-03-23 12:49:09 | chain | 1 | 28756 | 8 | 0.546 | 52666.7 |
487 | 2020-03-21 21:01:21 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
486 | 2020-03-21 01:32:15 | chain | 1 | 28756 | 8 | 0.533 | 53951.2 |
485 | 2020-03-19 20:05:18 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
484 | 2020-03-18 22:47:31 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
483 | 2020-03-17 19:20:18 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
482 | 2020-03-06 15:45:29 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
481 | 2020-02-28 09:00:47 | chain | 2 | 53800 | 130 | 1.783 | 30173.9 |
480 | 2020-02-23 05:43:15 | chain | 1 | 28756 | 8 | 0.546 | 52666.7 |