History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bread"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
588 | 2024-05-08 07:18:55 | bread | 1 | 28756 | 14 | 1.000 | 28756.0 |
587 | 2024-05-04 06:21:51 | bread | 1 | 28756 | 14 | 1.046 | 27491.4 |
586 | 2024-05-04 01:22:31 | bread | 1 | 28756 | 14 | 1.030 | 27918.4 |
585 | 2024-04-30 15:24:19 | bread | 1 | 28756 | 14 | 0.486 | 59168.7 |
584 | 2024-04-29 23:50:17 | bread | 1 | 28756 | 14 | 0.546 | 52666.7 |
583 | 2024-04-25 21:42:17 | bread | 1 | 28756 | 14 | 0.563 | 51076.4 |
582 | 2024-04-09 18:51:49 | bread | 1 | 28756 | 14 | 0.593 | 48492.4 |
581 | 2024-04-03 06:08:02 | bread | 1 | 28756 | 14 | 0.516 | 55728.7 |
580 | 2024-03-31 07:55:00 | bread | 1 | 28756 | 14 | 0.513 | 56054.6 |
579 | 2024-03-29 01:07:10 | bread | 1 | 28756 | 14 | 1.126 | 25538.2 |
578 | 2024-03-29 01:06:57 | bread | 2 | 53800 | 135 | 1.893 | 28420.5 |
577 | 2024-03-28 18:41:33 | bread | 2 | 53800 | 135 | 5.546 | 9700.7 |
576 | 2024-03-28 18:23:50 | bread | 1 | 28756 | 14 | 0.486 | 59168.7 |
575 | 2024-03-04 00:26:48 | bread | 1 | 28756 | 14 | 0.486 | 59168.7 |
574 | 2024-03-01 05:29:28 | bread | 1 | 28756 | 14 | 0.533 | 53951.2 |
573 | 2024-02-28 04:51:16 | bread | 2 | 53800 | 135 | 2.310 | 23290.0 |
572 | 2024-02-27 21:25:04 | bread | 2 | 53800 | 135 | 4.326 | 12436.4 |
571 | 2024-02-26 22:55:45 | bread | 2 | 53800 | 135 | 1.780 | 30224.7 |
570 | 2024-02-26 19:27:16 | bread | 1 | 28756 | 14 | 0.640 | 44931.3 |
569 | 2024-02-02 21:10:27 | bread | 1 | 28756 | 14 | 0.500 | 57512.0 |
568 | 2024-01-24 09:00:54 | bread | 1 | 28756 | 14 | 0.486 | 59168.7 |
567 | 2024-01-22 02:08:43 | bread | 1 | 28756 | 14 | 0.420 | 68466.7 |
566 | 2024-01-11 18:36:56 | bread | 2 | 53800 | 135 | 1.483 | 36277.8 |
565 | 2024-01-03 02:07:06 | bread | 2 | 53800 | 135 | 2.376 | 22643.1 |
564 | 2023-12-29 00:27:11 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
563 | 2023-11-15 01:33:22 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
562 | 2023-11-14 08:46:41 | bread | 1 | 28756 | 14 | 0.466 | 61708.2 |
561 | 2023-11-03 08:43:23 | bread | 1 | 28756 | 14 | 0.530 | 54256.6 |
560 | 2023-10-24 01:56:04 | bread | 1 | 28756 | 14 | 0.500 | 57512.0 |
559 | 2023-10-20 20:47:49 | bread | 1 | 28756 | 14 | 1.000 | 28756.0 |
558 | 2023-10-19 16:51:44 | bread | 1 | 28756 | 14 | 0.440 | 65354.5 |
557 | 2023-10-16 13:56:42 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
556 | 2023-10-13 01:10:03 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
555 | 2023-10-05 03:50:14 | bread | 1 | 28756 | 14 | 0.456 | 63061.4 |
554 | 2023-09-22 23:56:33 | bread | 1 | 28756 | 14 | 0.516 | 55728.7 |
553 | 2023-09-22 07:39:50 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
552 | 2023-09-05 22:45:43 | bread | 1 | 28756 | 14 | 0.470 | 61183.0 |
551 | 2023-08-16 11:52:59 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
550 | 2023-07-07 07:04:41 | bread | 1 | 28756 | 14 | 0.440 | 65354.5 |
549 | 2023-05-21 04:47:30 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
548 | 2023-05-17 15:24:59 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
547 | 2023-03-31 12:26:30 | bread | 1 | 28756 | 14 | 0.466 | 61708.2 |
546 | 2023-03-27 02:07:35 | bread | 1 | 28756 | 14 | 0.466 | 61708.2 |
545 | 2023-03-14 14:02:50 | bread | 1 | 28756 | 14 | 0.420 | 68466.7 |
544 | 2022-12-15 04:45:28 | bread | 1 | 28756 | 14 | 0.483 | 59536.2 |
543 | 2022-09-18 21:11:32 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
542 | 2022-09-11 18:28:54 | bread | 1 | 28756 | 14 | 0.483 | 59536.2 |
541 | 2022-09-04 06:46:42 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
540 | 2022-09-03 09:45:02 | bread | 1 | 28756 | 14 | 0.423 | 67981.1 |
539 | 2022-08-26 06:16:58 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
538 | 2022-08-18 07:08:13 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
537 | 2022-08-10 12:27:38 | bread | 1 | 28756 | 14 | 0.423 | 67981.1 |
536 | 2022-08-06 15:13:21 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
535 | 2022-07-29 20:22:54 | bread | 1 | 28756 | 14 | 0.450 | 63902.2 |
534 | 2022-07-28 13:18:02 | bread | 1 | 28756 | 14 | 0.440 | 65354.5 |
533 | 2022-07-17 20:42:27 | bread | 1 | 28756 | 14 | 0.440 | 65354.5 |
532 | 2022-07-10 06:24:22 | bread | 1 | 28756 | 14 | 0.546 | 52666.7 |
531 | 2022-07-02 20:11:20 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
530 | 2022-07-02 17:13:17 | bread | 1 | 28756 | 14 | 0.440 | 65354.5 |
529 | 2022-05-23 01:57:01 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
528 | 2022-05-19 16:11:55 | bread | 1 | 28756 | 14 | 0.483 | 59536.2 |
527 | 2022-05-03 16:56:48 | bread | 1 | 28756 | 14 | 0.533 | 53951.2 |
526 | 2022-02-14 23:47:01 | bread | 1 | 28756 | 14 | 0.500 | 57512.0 |
525 | 2022-02-11 10:44:11 | bread | 1 | 28756 | 14 | 0.500 | 57512.0 |
524 | 2022-01-22 16:55:41 | bread | 1 | 28756 | 14 | 0.466 | 61708.2 |
523 | 2021-11-18 05:57:17 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
522 | 2021-11-10 10:23:18 | bread | 1 | 28756 | 14 | 0.486 | 59168.7 |
521 | 2021-10-27 15:29:10 | bread | 1 | 28756 | 14 | 0.440 | 65354.5 |
520 | 2021-10-06 00:25:53 | bread | 1 | 28756 | 14 | 0.486 | 59168.7 |
519 | 2021-09-24 00:57:26 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
518 | 2021-08-30 07:37:06 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
517 | 2021-08-12 21:42:12 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
516 | 2021-08-07 10:27:38 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
515 | 2021-07-01 07:45:48 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
514 | 2021-04-13 09:46:35 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
513 | 2021-03-17 01:59:31 | bread | 1 | 28756 | 14 | 0.500 | 57512.0 |
512 | 2021-02-10 15:59:25 | bread | 1 | 28756 | 14 | 0.500 | 57512.0 |
511 | 2020-12-29 06:42:25 | bread | 1 | 28756 | 14 | 0.440 | 65354.5 |
510 | 2020-11-02 06:26:48 | bread | 1 | 28756 | 14 | 0.483 | 59536.2 |
509 | 2020-09-28 18:15:31 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
508 | 2020-09-21 23:50:40 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
507 | 2020-08-30 23:55:31 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
506 | 2020-08-26 11:17:38 | bread | 1 | 28756 | 14 | 0.516 | 55728.7 |
505 | 2020-08-15 09:26:00 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
504 | 2020-08-11 05:56:43 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
503 | 2020-08-04 09:59:56 | bread | 1 | 28756 | 14 | 0.516 | 55728.7 |
502 | 2020-07-29 11:11:30 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
501 | 2020-07-24 07:01:18 | bread | 1 | 28756 | 14 | 0.470 | 61183.0 |
500 | 2020-07-15 08:10:41 | bread | 1 | 28756 | 14 | 0.560 | 51350.0 |
499 | 2020-06-13 01:35:01 | bread | 1 | 28756 | 14 | 0.466 | 61708.2 |
498 | 2020-06-12 01:14:53 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
497 | 2020-05-03 16:37:40 | bread | 1 | 28756 | 14 | 0.483 | 59536.2 |
496 | 2020-04-03 10:12:51 | bread | 1 | 28756 | 14 | 0.436 | 65954.1 |
495 | 2020-03-26 05:25:43 | bread | 1 | 28756 | 14 | 0.513 | 56054.6 |
494 | 2020-03-24 16:21:08 | bread | 1 | 28756 | 14 | 0.500 | 57512.0 |
493 | 2020-03-23 03:27:44 | bread | 1 | 28756 | 14 | 0.500 | 57512.0 |
492 | 2020-03-22 01:23:28 | bread | 1 | 28756 | 14 | 0.516 | 55728.7 |
491 | 2020-03-21 22:43:26 | bread | 1 | 28756 | 14 | 0.453 | 63479.0 |
490 | 2020-03-21 05:51:28 | bread | 1 | 28756 | 14 | 0.483 | 59536.2 |
489 | 2020-03-17 21:52:24 | bread | 1 | 28756 | 14 | 0.440 | 65354.5 |