History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hajji"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
602 | 2024-04-27 11:48:07 | hajji | 1 | 28756 | 5 | 1.126 | 25538.2 |
601 | 2024-04-26 20:21:59 | hajji | 3 | 83667 | 287 | 14.420 | 5802.1 |
600 | 2024-04-26 19:12:04 | hajji | 3 | 83667 | 287 | 4.626 | 18086.3 |
599 | 2024-04-06 06:01:52 | hajji | 1 | 28756 | 5 | 0.436 | 65954.1 |
598 | 2024-03-31 16:30:50 | hajji | 1 | 28756 | 5 | 0.546 | 52666.7 |
597 | 2024-03-29 09:04:31 | hajji | 1 | 28756 | 5 | 0.563 | 51076.4 |
596 | 2024-03-28 08:49:14 | hajji | 1 | 28756 | 5 | 0.483 | 59536.2 |
595 | 2024-03-21 04:49:10 | hajji | 3 | 83667 | 287 | 10.923 | 7659.7 |
594 | 2024-03-07 08:45:07 | hajji | 2 | 53800 | 12 | 5.783 | 9303.1 |
593 | 2024-03-07 03:49:08 | hajji | 1 | 28756 | 5 | 0.546 | 52666.7 |
592 | 2024-03-04 02:12:18 | hajji | 3 | 83667 | 287 | 4.110 | 20356.9 |
591 | 2024-03-01 12:37:43 | hajji | 3 | 83667 | 287 | 4.266 | 19612.5 |
590 | 2024-03-01 12:37:44 | hajji | 2 | 53800 | 12 | 1.766 | 30464.3 |
589 | 2024-03-01 12:37:30 | hajji | 1 | 28756 | 5 | 0.563 | 51076.4 |
588 | 2024-02-28 07:14:34 | hajji | 2 | 53800 | 12 | 2.173 | 24758.4 |
587 | 2024-02-28 07:14:21 | hajji | 3 | 83667 | 287 | 4.283 | 19534.7 |
586 | 2024-02-28 06:50:31 | hajji | 3 | 83667 | 287 | 10.546 | 7933.5 |
585 | 2024-02-28 06:50:30 | hajji | 2 | 53800 | 12 | 1.813 | 29674.6 |
584 | 2024-02-28 06:49:00 | hajji | 1 | 28756 | 5 | 0.546 | 52666.7 |
583 | 2024-02-08 23:20:28 | hajji | 3 | 83667 | 287 | 8.360 | 10008.0 |
582 | 2024-02-06 06:33:32 | hajji | 2 | 53800 | 12 | 1.736 | 30990.8 |
581 | 2024-02-03 18:15:07 | hajji | 2 | 53800 | 12 | 1.686 | 31909.8 |
580 | 2024-02-03 18:14:55 | hajji | 1 | 28756 | 5 | 0.500 | 57512.0 |
579 | 2024-02-02 14:02:37 | hajji | 3 | 83667 | 287 | 3.843 | 21771.3 |
578 | 2024-01-29 06:09:47 | hajji | 1 | 28756 | 5 | 0.500 | 57512.0 |
577 | 2024-01-29 05:37:01 | hajji | 1 | 28756 | 5 | 0.436 | 65954.1 |
576 | 2024-01-26 09:21:47 | hajji | 1 | 28756 | 5 | 0.516 | 55728.7 |
575 | 2024-01-16 16:41:34 | hajji | 3 | 83667 | 287 | 3.436 | 24350.1 |
574 | 2024-01-10 14:46:45 | hajji | 3 | 83667 | 287 | 4.080 | 20506.6 |
573 | 2023-12-21 23:39:01 | hajji | 2 | 53800 | 12 | 1.643 | 32745.0 |
572 | 2023-12-16 17:06:33 | hajji | 2 | 53800 | 12 | 2.330 | 23090.1 |
571 | 2023-12-11 10:34:32 | hajji | 1 | 28756 | 5 | 0.970 | 29645.4 |
570 | 2023-11-24 17:14:39 | hajji | 3 | 83667 | 287 | 3.500 | 23904.9 |
569 | 2023-11-21 08:12:11 | hajji | 1 | 28756 | 5 | 0.516 | 55728.7 |
568 | 2023-11-21 04:43:43 | hajji | 1 | 28756 | 5 | 0.486 | 59168.7 |
567 | 2023-11-16 20:17:47 | hajji | 1 | 28756 | 5 | 0.533 | 53951.2 |
566 | 2023-11-11 21:46:11 | hajji | 2 | 53800 | 12 | 1.593 | 33772.8 |
565 | 2023-11-03 10:09:55 | hajji | 1 | 28756 | 5 | 0.486 | 59168.7 |
564 | 2023-11-01 08:43:41 | hajji | 1 | 28756 | 5 | 0.453 | 63479.0 |
563 | 2023-10-27 07:00:08 | hajji | 3 | 83667 | 287 | 3.893 | 21491.7 |
562 | 2023-10-20 16:46:24 | hajji | 1 | 28756 | 5 | 0.500 | 57512.0 |
561 | 2023-10-15 14:07:44 | hajji | 1 | 28756 | 5 | 0.486 | 59168.7 |
560 | 2023-10-05 19:35:17 | hajji | 1 | 28756 | 5 | 0.486 | 59168.7 |
559 | 2023-09-27 08:58:52 | hajji | 1 | 28756 | 5 | 0.983 | 29253.3 |
558 | 2023-09-22 11:26:15 | hajji | 3 | 83667 | 287 | 3.326 | 25155.4 |
557 | 2023-09-15 12:41:16 | hajji | 1 | 28756 | 5 | 0.483 | 59536.2 |
556 | 2023-09-07 07:37:50 | hajji | 1 | 28756 | 5 | 0.500 | 57512.0 |
555 | 2023-08-21 10:27:57 | hajji | 3 | 83667 | 287 | 4.003 | 20901.1 |
554 | 2023-08-15 02:23:58 | hajji | 2 | 53800 | 12 | 1.376 | 39098.8 |
553 | 2023-08-14 10:31:56 | hajji | 3 | 83667 | 287 | 3.640 | 22985.4 |
552 | 2023-08-13 04:16:18 | hajji | 1 | 28756 | 5 | 0.453 | 63479.0 |
551 | 2023-08-11 00:27:21 | hajji | 3 | 83667 | 287 | 3.893 | 21491.7 |
550 | 2023-08-05 02:18:21 | hajji | 3 | 83667 | 287 | 3.326 | 25155.4 |
549 | 2023-07-24 04:08:17 | hajji | 1 | 28756 | 5 | 0.436 | 65954.1 |
548 | 2023-07-05 07:49:44 | hajji | 1 | 28756 | 5 | 0.470 | 61183.0 |
547 | 2023-06-11 13:03:58 | hajji | 1 | 28756 | 5 | 0.466 | 61708.2 |
546 | 2023-04-25 02:05:18 | hajji | 2 | 53800 | 12 | 1.326 | 40573.2 |
545 | 2023-04-16 10:42:19 | hajji | 3 | 83667 | 287 | 3.156 | 26510.5 |
544 | 2023-03-30 01:17:57 | hajji | 1 | 28756 | 5 | 0.436 | 65954.1 |
543 | 2023-03-21 14:28:35 | hajji | 1 | 28756 | 5 | 0.436 | 65954.1 |
542 | 2023-03-04 07:28:52 | hajji | 1 | 28756 | 5 | 0.500 | 57512.0 |
541 | 2023-02-11 01:25:14 | hajji | 1 | 28756 | 5 | 0.453 | 63479.0 |
540 | 2023-02-01 00:29:22 | hajji | 2 | 53800 | 12 | 1.516 | 35488.1 |
539 | 2023-01-27 19:13:41 | hajji | 2 | 53800 | 12 | 1.373 | 39184.3 |
538 | 2023-01-23 13:43:48 | hajji | 3 | 83667 | 287 | 3.640 | 22985.4 |
537 | 2023-01-21 06:45:59 | hajji | 3 | 83667 | 287 | 3.593 | 23286.1 |
536 | 2023-01-13 03:48:07 | hajji | 1 | 28756 | 5 | 0.876 | 32826.5 |
535 | 2022-12-25 21:01:58 | hajji | 3 | 83667 | 287 | 3.736 | 22394.8 |
534 | 2022-12-23 11:13:06 | hajji | 1 | 28756 | 5 | 0.466 | 61708.2 |
533 | 2022-12-20 14:30:42 | hajji | 2 | 53800 | 12 | 1.516 | 35488.1 |
532 | 2022-12-14 01:28:43 | hajji | 3 | 83667 | 287 | 3.720 | 22491.1 |
531 | 2022-11-14 19:58:37 | hajji | 3 | 83667 | 287 | 3.780 | 22134.1 |
530 | 2022-11-10 07:39:19 | hajji | 1 | 28756 | 5 | 0.500 | 57512.0 |
529 | 2022-11-10 02:38:39 | hajji | 2 | 53800 | 12 | 1.390 | 38705.0 |
528 | 2022-11-09 08:15:31 | hajji | 1 | 28756 | 5 | 0.533 | 53951.2 |
527 | 2022-11-09 04:10:16 | hajji | 3 | 83667 | 287 | 3.593 | 23286.1 |
526 | 2022-11-06 08:41:53 | hajji | 3 | 83667 | 287 | 8.250 | 10141.5 |
525 | 2022-11-05 22:57:33 | hajji | 1 | 28756 | 5 | 0.966 | 29768.1 |
524 | 2022-11-04 02:44:33 | hajji | 3 | 83667 | 287 | 3.250 | 25743.7 |
523 | 2022-10-30 03:07:53 | hajji | 1 | 28756 | 5 | 0.436 | 65954.1 |
522 | 2022-09-22 13:26:27 | hajji | 3 | 83667 | 287 | 3.360 | 24900.9 |
521 | 2022-09-13 11:40:41 | hajji | 3 | 83667 | 287 | 3.373 | 24804.9 |
520 | 2022-09-08 05:52:53 | hajji | 3 | 83667 | 287 | 3.516 | 23796.1 |
519 | 2022-09-04 16:50:40 | hajji | 3 | 83667 | 287 | 3.203 | 26121.4 |
518 | 2022-08-16 14:17:30 | hajji | 3 | 83667 | 287 | 3.626 | 23074.2 |
517 | 2022-07-26 15:11:07 | hajji | 3 | 83667 | 287 | 3.643 | 22966.5 |
516 | 2022-06-28 20:08:26 | hajji | 1 | 28756 | 5 | 0.436 | 65954.1 |
515 | 2022-06-18 15:40:27 | hajji | 1 | 28756 | 5 | 0.436 | 65954.1 |
514 | 2022-06-15 15:18:25 | hajji | 2 | 53800 | 12 | 1.500 | 35866.7 |
513 | 2022-06-13 11:08:24 | hajji | 2 | 53800 | 12 | 1.530 | 35163.4 |
512 | 2022-06-07 13:53:17 | hajji | 3 | 83667 | 287 | 3.500 | 23904.9 |
511 | 2022-06-04 03:42:03 | hajji | 3 | 83667 | 287 | 3.266 | 25617.6 |
510 | 2022-05-26 10:08:41 | hajji | 3 | 83667 | 287 | 3.250 | 25743.7 |
509 | 2022-05-15 23:14:58 | hajji | 1 | 28756 | 5 | 0.483 | 59536.2 |
508 | 2022-04-25 03:56:09 | hajji | 3 | 83667 | 287 | 3.690 | 22674.0 |
507 | 2022-04-20 13:13:55 | hajji | 3 | 83667 | 287 | 4.296 | 19475.6 |
506 | 2022-03-01 19:45:05 | hajji | 3 | 83667 | 287 | 4.093 | 20441.5 |
505 | 2022-02-23 22:27:20 | hajji | 1 | 28756 | 5 | 0.516 | 55728.7 |
504 | 2022-02-17 15:05:59 | hajji | 3 | 83667 | 287 | 3.530 | 23701.7 |
503 | 2022-02-16 10:28:45 | hajji | 1 | 28756 | 5 | 0.436 | 65954.1 |