History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gurus"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
611 | 2024-03-29 02:46:01 | gurus | 1 | 28756 | 5 | 0.530 | 54256.6 |
610 | 2024-03-29 01:47:07 | gurus | 1 | 28756 | 5 | 0.593 | 48492.4 |
609 | 2024-03-29 01:46:57 | gurus | 2 | 53800 | 144 | 2.143 | 25105.0 |
608 | 2024-03-29 00:12:31 | gurus | 2 | 53800 | 144 | 3.893 | 13819.7 |
607 | 2024-03-28 22:13:23 | gurus | 2 | 53800 | 144 | 5.580 | 9641.6 |
606 | 2024-03-08 21:54:45 | gurus | 1 | 28756 | 5 | 0.530 | 54256.6 |
605 | 2024-03-05 20:50:27 | gurus | 2 | 53800 | 144 | 7.013 | 7671.5 |
604 | 2024-03-04 18:46:33 | gurus | 2 | 53800 | 144 | 5.516 | 9753.4 |
603 | 2024-03-04 18:14:45 | gurus | 1 | 28756 | 5 | 0.436 | 65954.1 |
602 | 2024-02-25 22:04:55 | gurus | 2 | 53800 | 144 | 7.000 | 7685.7 |
601 | 2024-02-25 19:24:34 | gurus | 1 | 28756 | 5 | 0.516 | 55728.7 |
600 | 2024-02-04 01:41:13 | gurus | 1 | 28756 | 5 | 0.500 | 57512.0 |
599 | 2024-02-03 17:25:55 | gurus | 1 | 28756 | 5 | 0.486 | 59168.7 |
598 | 2024-01-28 21:15:31 | gurus | 1 | 28756 | 5 | 0.466 | 61708.2 |
597 | 2024-01-26 02:33:29 | gurus | 1 | 28756 | 5 | 0.516 | 55728.7 |
596 | 2024-01-21 05:49:42 | gurus | 1 | 28756 | 5 | 0.500 | 57512.0 |
595 | 2023-12-19 21:37:32 | gurus | 2 | 53800 | 144 | 1.670 | 32215.6 |
594 | 2023-12-09 22:03:34 | gurus | 2 | 53800 | 144 | 1.530 | 35163.4 |
593 | 2023-12-01 22:54:43 | gurus | 2 | 53800 | 144 | 1.310 | 41068.7 |
592 | 2023-11-27 02:57:03 | gurus | 1 | 28756 | 5 | 0.440 | 65354.5 |
591 | 2023-11-22 04:09:55 | gurus | 1 | 28756 | 5 | 0.483 | 59536.2 |
590 | 2023-11-20 01:19:36 | gurus | 2 | 53800 | 144 | 1.453 | 37026.8 |
589 | 2023-11-16 04:28:10 | gurus | 1 | 28756 | 5 | 0.436 | 65954.1 |
588 | 2023-11-11 04:44:55 | gurus | 2 | 53800 | 144 | 1.483 | 36277.8 |
587 | 2023-11-07 10:29:24 | gurus | 1 | 28756 | 5 | 0.500 | 57512.0 |
586 | 2023-10-27 08:09:02 | gurus | 1 | 28756 | 5 | 0.500 | 57512.0 |
585 | 2023-10-27 01:53:18 | gurus | 2 | 53800 | 144 | 1.640 | 32804.9 |
584 | 2023-10-20 20:03:58 | gurus | 2 | 53800 | 144 | 1.643 | 32745.0 |
583 | 2023-10-19 18:36:06 | gurus | 1 | 28756 | 5 | 0.970 | 29645.4 |
582 | 2023-10-19 15:02:52 | gurus | 1 | 28756 | 5 | 0.500 | 57512.0 |
581 | 2023-10-11 16:19:55 | gurus | 1 | 28756 | 5 | 0.516 | 55728.7 |
580 | 2023-10-04 22:47:32 | gurus | 1 | 28756 | 5 | 0.983 | 29253.3 |
579 | 2023-09-27 15:18:44 | gurus | 1 | 28756 | 5 | 0.453 | 63479.0 |
578 | 2023-09-12 15:44:49 | gurus | 1 | 28756 | 5 | 0.483 | 59536.2 |
577 | 2023-09-12 14:45:09 | gurus | 1 | 28756 | 5 | 0.500 | 57512.0 |
576 | 2023-08-31 01:38:32 | gurus | 2 | 53800 | 144 | 1.453 | 37026.8 |
575 | 2023-07-29 22:59:01 | gurus | 1 | 28756 | 5 | 0.466 | 61708.2 |
574 | 2023-06-26 12:03:57 | gurus | 1 | 28756 | 5 | 0.453 | 63479.0 |
573 | 2023-05-17 17:09:13 | gurus | 2 | 53800 | 144 | 1.330 | 40451.1 |
572 | 2023-04-25 07:26:09 | gurus | 1 | 28756 | 5 | 0.516 | 55728.7 |
571 | 2023-04-10 02:34:52 | gurus | 1 | 28756 | 5 | 0.423 | 67981.1 |
570 | 2023-02-25 09:45:26 | gurus | 2 | 53800 | 144 | 1.420 | 37887.3 |
569 | 2023-01-31 06:28:54 | gurus | 1 | 28756 | 5 | 0.453 | 63479.0 |
568 | 2023-01-16 15:52:05 | gurus | 1 | 28756 | 5 | 0.486 | 59168.7 |
567 | 2023-01-12 22:59:24 | gurus | 1 | 28756 | 5 | 0.423 | 67981.1 |
566 | 2022-12-06 14:40:26 | gurus | 2 | 53800 | 144 | 1.313 | 40974.9 |
565 | 2022-11-28 19:25:27 | gurus | 1 | 28756 | 5 | 0.483 | 59536.2 |
564 | 2022-09-25 10:06:28 | gurus | 1 | 28756 | 5 | 0.483 | 59536.2 |
563 | 2022-08-31 23:20:48 | gurus | 1 | 28756 | 5 | 0.483 | 59536.2 |
562 | 2022-08-07 18:13:42 | gurus | 1 | 28756 | 5 | 0.470 | 61183.0 |
561 | 2022-07-25 18:58:27 | gurus | 1 | 28756 | 5 | 0.440 | 65354.5 |
560 | 2022-07-23 11:20:02 | gurus | 1 | 28756 | 5 | 0.436 | 65954.1 |
559 | 2022-06-15 16:06:52 | gurus | 1 | 28756 | 5 | 0.436 | 65954.1 |
558 | 2022-05-01 00:08:59 | gurus | 1 | 28756 | 5 | 0.453 | 63479.0 |
557 | 2022-04-09 14:42:44 | gurus | 2 | 53800 | 144 | 1.376 | 39098.8 |
556 | 2022-03-20 14:52:46 | gurus | 1 | 28756 | 5 | 0.453 | 63479.0 |
555 | 2022-02-28 09:19:15 | gurus | 1 | 28756 | 5 | 0.703 | 40904.7 |
554 | 2021-12-28 17:47:09 | gurus | 1 | 28756 | 5 | 0.520 | 55300.0 |
553 | 2021-11-20 03:19:52 | gurus | 1 | 28756 | 5 | 0.780 | 36866.7 |
552 | 2021-10-31 08:17:21 | gurus | 1 | 28756 | 5 | 0.483 | 59536.2 |
551 | 2021-09-17 14:15:59 | gurus | 1 | 28756 | 5 | 0.470 | 61183.0 |
550 | 2021-09-02 08:29:20 | gurus | 1 | 28756 | 5 | 0.483 | 59536.2 |
549 | 2021-08-20 13:15:43 | gurus | 1 | 28756 | 5 | 0.470 | 61183.0 |
548 | 2021-07-18 05:17:16 | gurus | 1 | 28756 | 5 | 0.483 | 59536.2 |
547 | 2021-07-01 02:32:06 | gurus | 2 | 53800 | 144 | 1.563 | 34421.0 |
546 | 2021-05-19 22:23:35 | gurus | 1 | 28756 | 5 | 0.500 | 57512.0 |
545 | 2021-05-14 01:21:55 | gurus | 2 | 53800 | 144 | 2.706 | 19881.7 |
544 | 2021-05-07 10:26:36 | gurus | 1 | 28756 | 5 | 0.436 | 65954.1 |
543 | 2021-04-13 00:43:56 | gurus | 2 | 53800 | 144 | 1.513 | 35558.5 |
542 | 2021-03-25 23:07:12 | gurus | 2 | 53800 | 144 | 1.356 | 39675.5 |
541 | 2021-03-25 00:37:12 | gurus | 2 | 53800 | 144 | 1.516 | 35488.1 |
540 | 2021-03-23 04:42:31 | gurus | 2 | 53800 | 144 | 1.373 | 39184.3 |
539 | 2021-03-21 07:44:35 | gurus | 2 | 53800 | 144 | 1.423 | 37807.4 |
538 | 2021-03-16 21:00:26 | gurus | 2 | 53800 | 144 | 1.356 | 39675.5 |
537 | 2021-02-25 14:18:52 | gurus | 2 | 53800 | 144 | 1.330 | 40451.1 |
536 | 2021-02-25 00:14:48 | gurus | 2 | 53800 | 144 | 1.516 | 35488.1 |
535 | 2021-02-24 18:57:16 | gurus | 2 | 53800 | 144 | 1.483 | 36277.8 |
534 | 2021-02-23 15:21:22 | gurus | 1 | 28756 | 5 | 0.453 | 63479.0 |
533 | 2021-02-23 06:48:54 | gurus | 2 | 53800 | 144 | 2.860 | 18811.2 |
532 | 2021-02-17 02:23:21 | gurus | 1 | 28756 | 5 | 0.483 | 59536.2 |
531 | 2021-02-13 22:01:07 | gurus | 1 | 28756 | 5 | 0.450 | 63902.2 |
530 | 2021-02-09 12:22:50 | gurus | 1 | 28756 | 5 | 0.440 | 65354.5 |
529 | 2021-02-01 05:31:24 | gurus | 2 | 53800 | 144 | 1.360 | 39558.8 |
528 | 2021-01-29 18:19:35 | gurus | 1 | 28756 | 5 | 0.450 | 63902.2 |
527 | 2021-01-26 20:27:33 | gurus | 2 | 53800 | 144 | 1.373 | 39184.3 |
526 | 2021-01-21 05:13:03 | gurus | 1 | 28756 | 5 | 0.436 | 65954.1 |
525 | 2020-11-25 23:35:28 | gurus | 1 | 28756 | 5 | 0.436 | 65954.1 |
524 | 2020-11-07 19:25:25 | gurus | 1 | 28756 | 5 | 0.626 | 45936.1 |
523 | 2020-11-07 06:48:40 | gurus | 2 | 53800 | 144 | 1.686 | 31909.8 |
522 | 2020-11-02 07:38:22 | gurus | 2 | 53800 | 144 | 1.470 | 36598.6 |
521 | 2020-10-17 13:56:18 | gurus | 1 | 28756 | 5 | 0.453 | 63479.0 |
520 | 2020-10-17 08:35:40 | gurus | 1 | 28756 | 5 | 0.470 | 61183.0 |
519 | 2020-10-16 10:01:03 | gurus | 1 | 28756 | 5 | 0.423 | 67981.1 |
518 | 2020-09-08 09:56:16 | gurus | 1 | 28756 | 5 | 0.466 | 61708.2 |
517 | 2020-08-02 23:36:00 | gurus | 1 | 28756 | 5 | 0.436 | 65954.1 |
516 | 2020-07-17 09:54:57 | gurus | 1 | 28756 | 5 | 0.610 | 47141.0 |
515 | 2020-06-16 19:56:28 | gurus | 1 | 28756 | 5 | 0.436 | 65954.1 |
514 | 2020-05-04 16:28:12 | gurus | 1 | 28756 | 5 | 0.470 | 61183.0 |
513 | 2020-03-25 08:24:09 | gurus | 1 | 28756 | 5 | 0.450 | 63902.2 |
512 | 2020-03-23 04:00:31 | gurus | 1 | 28756 | 5 | 0.486 | 59168.7 |