History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"logon"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
7604 | 2024-03-22 16:19:16 | logon | 1 | 28756 | 10 | 0.983 | 29253.3 |
7603 | 2024-03-21 23:03:17 | logon | 2 | 53800 | 83 | 5.500 | 9781.8 |
7602 | 2024-03-21 23:03:15 | logon | 1 | 28756 | 10 | 0.576 | 49923.6 |
7601 | 2024-03-21 18:05:56 | logon | 1 | 28756 | 10 | 1.143 | 25158.4 |
7600 | 2024-03-21 15:39:15 | logon | 1 | 28756 | 10 | 1.203 | 23903.6 |
7599 | 2024-03-20 18:54:24 | logon | 1 | 28756 | 10 | 0.530 | 54256.6 |
7598 | 2024-03-19 12:22:47 | logon | 1 | 28756 | 10 | 1.153 | 24940.2 |
7597 | 2024-03-08 10:23:53 | logon | 1 | 28756 | 10 | 0.576 | 49923.6 |
7596 | 2024-03-07 18:35:56 | logon | 2 | 53800 | 83 | 1.906 | 28226.7 |
7595 | 2024-03-07 05:25:22 | logon | 3 | 83667 | 998 | 9.000 | 9296.3 |
7594 | 2024-03-07 05:25:23 | logon | 2 | 53800 | 83 | 2.173 | 24758.4 |
7593 | 2024-03-05 19:02:18 | logon | 2 | 53800 | 83 | 7.606 | 7073.4 |
7592 | 2024-03-05 09:20:16 | logon | 3 | 83667 | 998 | 5.173 | 16173.8 |
7591 | 2024-03-05 09:20:13 | logon | 2 | 53800 | 83 | 3.106 | 17321.3 |
7590 | 2024-03-05 08:46:49 | logon | 1 | 28756 | 10 | 1.123 | 25606.4 |
7589 | 2024-02-28 10:34:12 | logon | 2 | 53800 | 83 | 3.000 | 17933.3 |
7588 | 2024-02-28 10:33:36 | logon | 3 | 83667 | 998 | 5.846 | 14311.8 |
7587 | 2024-02-28 06:46:54 | logon | 2 | 53800 | 83 | 3.606 | 14919.6 |
7586 | 2024-02-28 06:46:21 | logon | 3 | 83667 | 998 | 4.483 | 18663.2 |
7585 | 2024-02-25 15:59:36 | logon | 3 | 83667 | 998 | 4.360 | 19189.7 |
7584 | 2024-02-25 15:59:35 | logon | 2 | 53800 | 83 | 1.750 | 30742.9 |
7583 | 2024-02-25 15:47:19 | logon | 1 | 28756 | 10 | 0.576 | 49923.6 |
7582 | 2024-02-21 07:07:35 | logon | 1 | 28756 | 10 | 0.546 | 52666.7 |
7581 | 2024-02-21 06:00:57 | logon | 1 | 28756 | 10 | 0.516 | 55728.7 |
7580 | 2024-02-21 03:59:26 | logon | 1 | 28756 | 10 | 1.156 | 24875.4 |
7579 | 2024-02-20 19:51:38 | logon | 1 | 28756 | 10 | 1.093 | 26309.2 |
7578 | 2024-02-19 09:31:59 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
7577 | 2024-02-07 15:23:00 | logon | 3 | 83667 | 998 | 3.936 | 21256.9 |
7576 | 2024-01-29 11:20:25 | logon | 3 | 83667 | 998 | 3.533 | 23681.6 |
7575 | 2024-01-29 02:59:15 | logon | 2 | 53800 | 83 | 1.546 | 34799.5 |
7574 | 2024-01-29 02:58:31 | logon | 3 | 83667 | 998 | 3.263 | 25641.1 |
7573 | 2024-01-26 13:34:44 | logon | 3 | 83667 | 998 | 4.063 | 20592.4 |
7572 | 2024-01-26 13:34:42 | logon | 2 | 53800 | 83 | 1.546 | 34799.5 |
7571 | 2024-01-26 13:09:41 | logon | 1 | 28756 | 10 | 0.513 | 56054.6 |
7570 | 2024-01-24 11:04:36 | logon | 3 | 83667 | 998 | 3.766 | 22216.4 |
7569 | 2024-01-24 00:30:16 | logon | 3 | 83667 | 998 | 3.876 | 21585.9 |
7568 | 2024-01-24 00:30:12 | logon | 2 | 53800 | 83 | 3.123 | 17227.0 |
7567 | 2024-01-24 00:02:19 | logon | 1 | 28756 | 10 | 0.516 | 55728.7 |
7566 | 2024-01-22 17:21:42 | logon | 1 | 28756 | 10 | 0.436 | 65954.1 |
7565 | 2024-01-22 03:40:50 | logon | 1 | 28756 | 10 | 0.486 | 59168.7 |
7564 | 2024-01-21 23:24:30 | logon | 1 | 28756 | 10 | 0.436 | 65954.1 |
7563 | 2024-01-21 14:34:39 | logon | 1 | 28756 | 10 | 0.516 | 55728.7 |
7562 | 2024-01-21 07:06:10 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
7561 | 2024-01-21 01:39:17 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
7560 | 2024-01-20 02:46:19 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7559 | 2024-01-20 01:00:11 | logon | 1 | 28756 | 10 | 0.486 | 59168.7 |
7558 | 2024-01-19 18:51:21 | logon | 1 | 28756 | 10 | 0.533 | 53951.2 |
7557 | 2024-01-19 15:44:49 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
7556 | 2024-01-19 04:20:57 | logon | 1 | 28756 | 10 | 0.486 | 59168.7 |
7555 | 2024-01-18 17:48:50 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
7554 | 2024-01-18 16:36:28 | logon | 1 | 28756 | 10 | 0.563 | 51076.4 |
7553 | 2024-01-18 15:49:05 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
7552 | 2024-01-18 14:45:33 | logon | 1 | 28756 | 10 | 0.533 | 53951.2 |
7551 | 2024-01-18 07:40:18 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7550 | 2024-01-17 21:20:08 | logon | 1 | 28756 | 10 | 0.516 | 55728.7 |
7549 | 2024-01-17 18:21:41 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
7548 | 2024-01-17 10:23:21 | logon | 1 | 28756 | 10 | 0.563 | 51076.4 |
7547 | 2024-01-17 07:30:46 | logon | 1 | 28756 | 10 | 0.486 | 59168.7 |
7546 | 2024-01-17 00:37:45 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
7545 | 2024-01-16 18:10:07 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7544 | 2024-01-16 17:50:10 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
7543 | 2024-01-16 14:26:58 | logon | 1 | 28756 | 10 | 0.530 | 54256.6 |
7542 | 2024-01-16 06:47:57 | logon | 1 | 28756 | 10 | 0.470 | 61183.0 |
7541 | 2024-01-15 09:31:24 | logon | 1 | 28756 | 10 | 1.000 | 28756.0 |
7540 | 2024-01-15 04:22:47 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
7539 | 2024-01-13 14:08:32 | logon | 1 | 28756 | 10 | 0.533 | 53951.2 |
7538 | 2024-01-11 19:04:47 | logon | 1 | 28756 | 10 | 0.513 | 56054.6 |
7537 | 2024-01-10 15:45:17 | logon | 1 | 28756 | 10 | 0.546 | 52666.7 |
7536 | 2024-01-10 13:16:40 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7535 | 2024-01-09 21:49:26 | logon | 1 | 28756 | 10 | 0.830 | 34645.8 |
7534 | 2024-01-09 15:02:44 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
7533 | 2024-01-09 14:53:02 | logon | 1 | 28756 | 10 | 0.470 | 61183.0 |
7532 | 2024-01-09 14:43:58 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
7531 | 2024-01-09 08:19:32 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
7530 | 2024-01-08 09:13:58 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7529 | 2024-01-08 06:01:31 | logon | 1 | 28756 | 10 | 0.516 | 55728.7 |
7528 | 2024-01-08 00:32:12 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7527 | 2024-01-08 00:26:06 | logon | 1 | 28756 | 10 | 0.516 | 55728.7 |
7526 | 2024-01-07 19:34:55 | logon | 1 | 28756 | 10 | 0.470 | 61183.0 |
7525 | 2024-01-07 18:00:11 | logon | 3 | 83667 | 998 | 3.796 | 22040.8 |
7524 | 2024-01-07 18:00:11 | logon | 2 | 53800 | 83 | 1.580 | 34050.6 |
7523 | 2024-01-07 17:14:53 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
7522 | 2024-01-07 07:25:27 | logon | 1 | 28756 | 10 | 0.470 | 61183.0 |
7521 | 2024-01-07 03:04:45 | logon | 1 | 28756 | 10 | 0.563 | 51076.4 |
7520 | 2024-01-06 20:14:37 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
7519 | 2024-01-06 19:36:10 | logon | 1 | 28756 | 10 | 0.516 | 55728.7 |
7518 | 2024-01-06 16:16:39 | logon | 3 | 83667 | 998 | 3.373 | 24804.9 |
7517 | 2024-01-06 12:38:55 | logon | 1 | 28756 | 10 | 0.483 | 59536.2 |
7516 | 2024-01-06 03:25:55 | logon | 1 | 28756 | 10 | 0.440 | 65354.5 |
7515 | 2024-01-05 23:50:42 | logon | 1 | 28756 | 10 | 0.466 | 61708.2 |
7514 | 2024-01-05 12:58:55 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7513 | 2024-01-05 09:01:32 | logon | 1 | 28756 | 10 | 0.470 | 61183.0 |
7512 | 2024-01-04 17:37:12 | logon | 1 | 28756 | 10 | 0.450 | 63902.2 |
7511 | 2024-01-04 14:39:09 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7510 | 2024-01-04 13:40:38 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |
7509 | 2024-01-04 10:39:58 | logon | 3 | 83667 | 998 | 4.123 | 20292.7 |
7508 | 2024-01-03 20:09:29 | logon | 1 | 28756 | 10 | 0.516 | 55728.7 |
7507 | 2024-01-03 19:54:12 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7506 | 2024-01-03 16:30:25 | logon | 1 | 28756 | 10 | 0.453 | 63479.0 |
7505 | 2024-01-03 07:41:18 | logon | 1 | 28756 | 10 | 0.500 | 57512.0 |