History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"willy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1064 | 2024-04-27 09:51:45 | willy | 2 | 53800 | 166 | 2.690 | 20000.0 |
1063 | 2024-04-27 07:23:16 | willy | 1 | 28756 | 15 | 0.856 | 33593.5 |
1062 | 2024-04-23 12:29:11 | willy | 1 | 28756 | 15 | 0.530 | 54256.6 |
1061 | 2024-04-20 18:54:15 | willy | 1 | 28756 | 15 | 2.486 | 11567.2 |
1060 | 2024-04-04 23:01:11 | willy | 1 | 28756 | 15 | 0.656 | 43835.4 |
1059 | 2024-04-03 04:05:19 | willy | 1 | 28756 | 15 | 0.593 | 48492.4 |
1058 | 2024-04-02 23:53:05 | willy | 2 | 53800 | 166 | 1.830 | 29398.9 |
1057 | 2024-04-02 21:58:05 | willy | 2 | 53800 | 166 | 1.623 | 33148.5 |
1056 | 2024-04-01 23:43:24 | willy | 2 | 53800 | 166 | 1.563 | 34421.0 |
1055 | 2024-03-31 00:40:11 | willy | 1 | 28756 | 15 | 1.296 | 22188.3 |
1054 | 2024-03-29 02:40:25 | willy | 1 | 28756 | 15 | 1.080 | 26625.9 |
1053 | 2024-03-29 02:40:14 | willy | 2 | 53800 | 166 | 3.110 | 17299.0 |
1052 | 2024-03-29 00:10:19 | willy | 2 | 53800 | 166 | 1.983 | 27130.6 |
1051 | 2024-03-28 22:57:42 | willy | 1 | 28756 | 15 | 0.530 | 54256.6 |
1050 | 2024-03-25 04:28:10 | willy | 1 | 28756 | 15 | 0.500 | 57512.0 |
1049 | 2024-03-15 22:10:33 | willy | 1 | 28756 | 15 | 1.610 | 17860.9 |
1048 | 2024-03-03 21:45:31 | willy | 1 | 28756 | 15 | 0.420 | 68466.7 |
1047 | 2024-02-27 20:02:53 | willy | 1 | 28756 | 15 | 0.513 | 56054.6 |
1046 | 2024-02-13 14:11:05 | willy | 1 | 28756 | 15 | 0.516 | 55728.7 |
1045 | 2024-01-28 17:28:37 | willy | 1 | 28756 | 15 | 0.483 | 59536.2 |
1044 | 2024-01-10 22:44:10 | willy | 1 | 28756 | 15 | 0.550 | 52283.6 |
1043 | 2024-01-04 14:19:02 | willy | 2 | 53800 | 166 | 1.343 | 40059.6 |
1042 | 2023-12-30 01:38:19 | willy | 1 | 28756 | 15 | 0.516 | 55728.7 |
1041 | 2023-12-29 08:55:12 | willy | 1 | 28756 | 15 | 0.436 | 65954.1 |
1040 | 2023-12-27 10:29:21 | willy | 2 | 53800 | 166 | 1.326 | 40573.2 |
1039 | 2023-12-26 20:52:32 | willy | 2 | 53800 | 166 | 1.406 | 38264.6 |
1038 | 2023-12-18 10:24:08 | willy | 1 | 28756 | 15 | 0.420 | 68466.7 |
1037 | 2023-12-06 06:43:48 | willy | 2 | 53800 | 166 | 1.376 | 39098.8 |
1036 | 2023-11-27 21:38:55 | willy | 1 | 28756 | 15 | 0.986 | 29164.3 |
1035 | 2023-11-16 18:00:48 | willy | 2 | 53800 | 166 | 1.343 | 40059.6 |
1034 | 2023-11-15 04:15:37 | willy | 1 | 28756 | 15 | 0.486 | 59168.7 |
1033 | 2023-11-14 12:24:28 | willy | 1 | 28756 | 15 | 0.500 | 57512.0 |
1032 | 2023-11-12 22:46:25 | willy | 1 | 28756 | 15 | 0.470 | 61183.0 |
1031 | 2023-11-11 18:08:48 | willy | 1 | 28756 | 15 | 0.420 | 68466.7 |
1030 | 2023-10-30 07:30:05 | willy | 1 | 28756 | 15 | 0.486 | 59168.7 |
1029 | 2023-10-21 11:34:55 | willy | 1 | 28756 | 15 | 0.436 | 65954.1 |
1028 | 2023-10-19 00:27:38 | willy | 1 | 28756 | 15 | 0.483 | 59536.2 |
1027 | 2023-10-13 22:02:15 | willy | 1 | 28756 | 15 | 0.453 | 63479.0 |
1026 | 2023-10-06 07:15:02 | willy | 1 | 28756 | 15 | 0.500 | 57512.0 |
1025 | 2023-10-03 17:21:14 | willy | 1 | 28756 | 15 | 0.436 | 65954.1 |
1024 | 2023-09-24 10:39:00 | willy | 1 | 28756 | 15 | 0.423 | 67981.1 |
1023 | 2023-09-14 12:52:04 | willy | 1 | 28756 | 15 | 0.483 | 59536.2 |
1022 | 2023-09-02 22:17:43 | willy | 2 | 53800 | 166 | 3.000 | 17933.3 |
1021 | 2023-08-30 17:19:33 | willy | 2 | 53800 | 166 | 1.456 | 36950.5 |
1020 | 2023-08-15 06:01:29 | willy | 2 | 53800 | 166 | 1.343 | 40059.6 |
1019 | 2023-08-13 22:51:55 | willy | 1 | 28756 | 15 | 0.420 | 68466.7 |
1018 | 2023-08-03 00:03:57 | willy | 1 | 28756 | 15 | 0.420 | 68466.7 |
1017 | 2023-07-20 08:56:55 | willy | 1 | 28756 | 15 | 0.423 | 67981.1 |
1016 | 2023-05-18 17:53:48 | willy | 2 | 53800 | 166 | 1.530 | 35163.4 |
1015 | 2023-04-28 15:29:18 | willy | 1 | 28756 | 15 | 0.470 | 61183.0 |
1014 | 2023-04-01 08:06:41 | willy | 1 | 28756 | 15 | 0.453 | 63479.0 |
1013 | 2023-03-10 03:56:13 | willy | 2 | 53800 | 166 | 1.343 | 40059.6 |
1012 | 2023-02-24 22:01:24 | willy | 2 | 53800 | 166 | 1.486 | 36204.6 |
1011 | 2023-02-19 21:09:34 | willy | 1 | 28756 | 15 | 0.530 | 54256.6 |
1010 | 2022-12-18 01:03:59 | willy | 1 | 28756 | 15 | 0.466 | 61708.2 |
1009 | 2022-12-10 03:54:26 | willy | 1 | 28756 | 15 | 0.500 | 57512.0 |
1008 | 2022-12-08 01:16:13 | willy | 2 | 53800 | 166 | 1.533 | 35094.6 |
1007 | 2022-11-04 19:51:44 | willy | 1 | 28756 | 15 | 0.486 | 59168.7 |
1006 | 2022-08-28 05:26:00 | willy | 1 | 28756 | 15 | 0.466 | 61708.2 |
1005 | 2022-08-06 15:37:29 | willy | 1 | 28756 | 15 | 0.420 | 68466.7 |
1004 | 2022-04-20 22:27:42 | willy | 2 | 53800 | 166 | 1.513 | 35558.5 |
1003 | 2022-04-15 04:12:17 | willy | 1 | 28756 | 15 | 0.530 | 54256.6 |
1002 | 2022-04-06 20:49:27 | willy | 2 | 53800 | 166 | 1.736 | 30990.8 |
1001 | 2022-04-05 07:38:24 | willy | 1 | 28756 | 15 | 0.436 | 65954.1 |
1000 | 2022-04-01 20:41:44 | willy | 1 | 28756 | 15 | 0.436 | 65954.1 |
999 | 2022-03-19 21:43:32 | willy | 2 | 53800 | 166 | 1.373 | 39184.3 |
998 | 2022-03-18 21:50:00 | willy | 2 | 53800 | 166 | 1.500 | 35866.7 |
997 | 2022-03-17 14:24:36 | willy | 2 | 53800 | 166 | 1.860 | 28924.7 |
996 | 2022-03-16 18:53:30 | willy | 2 | 53800 | 166 | 1.906 | 28226.7 |
995 | 2022-02-24 23:01:23 | willy | 2 | 53800 | 166 | 1.860 | 28924.7 |
994 | 2022-02-21 22:30:16 | willy | 2 | 53800 | 166 | 1.313 | 40974.9 |
993 | 2022-02-19 23:12:12 | willy | 2 | 53800 | 166 | 1.376 | 39098.8 |
992 | 2022-02-18 22:01:18 | willy | 2 | 53800 | 166 | 1.576 | 34137.1 |
991 | 2022-02-07 14:39:02 | willy | 2 | 53800 | 166 | 1.593 | 33772.8 |
990 | 2022-02-06 20:30:27 | willy | 1 | 28756 | 15 | 0.500 | 57512.0 |
989 | 2022-02-06 19:12:05 | willy | 2 | 53800 | 166 | 1.576 | 34137.1 |
988 | 2022-02-05 16:21:56 | willy | 1 | 28756 | 15 | 0.436 | 65954.1 |
987 | 2022-02-05 12:31:49 | willy | 2 | 53800 | 166 | 1.546 | 34799.5 |
986 | 2022-02-04 19:24:20 | willy | 2 | 53800 | 166 | 1.486 | 36204.6 |
985 | 2022-02-04 17:29:26 | willy | 1 | 28756 | 15 | 0.436 | 65954.1 |
984 | 2022-02-04 06:04:45 | willy | 2 | 53800 | 166 | 1.516 | 35488.1 |
983 | 2022-02-03 18:00:15 | willy | 2 | 53800 | 166 | 1.733 | 31044.4 |
982 | 2022-02-03 13:37:27 | willy | 1 | 28756 | 15 | 0.453 | 63479.0 |
981 | 2022-02-03 05:43:46 | willy | 2 | 53800 | 166 | 1.546 | 34799.5 |
980 | 2022-02-02 15:49:37 | willy | 2 | 53800 | 166 | 1.486 | 36204.6 |
979 | 2022-02-02 10:51:34 | willy | 1 | 28756 | 15 | 0.500 | 57512.0 |
978 | 2022-02-01 20:37:26 | willy | 2 | 53800 | 166 | 1.330 | 40451.1 |
977 | 2022-02-01 12:22:16 | willy | 1 | 28756 | 15 | 0.440 | 65354.5 |
976 | 2022-02-01 07:22:02 | willy | 2 | 53800 | 166 | 1.873 | 28724.0 |
975 | 2022-01-31 18:09:46 | willy | 2 | 53800 | 166 | 1.550 | 34709.7 |
974 | 2022-01-31 12:32:11 | willy | 1 | 28756 | 15 | 0.436 | 65954.1 |
973 | 2022-01-31 06:18:38 | willy | 2 | 53800 | 166 | 3.173 | 16955.6 |
972 | 2022-01-30 23:03:57 | willy | 2 | 53800 | 166 | 3.206 | 16781.0 |
971 | 2022-01-30 18:38:11 | willy | 1 | 28756 | 15 | 0.470 | 61183.0 |
970 | 2022-01-30 10:54:47 | willy | 2 | 53800 | 166 | 1.343 | 40059.6 |
969 | 2022-01-29 18:48:15 | willy | 1 | 28756 | 15 | 0.453 | 63479.0 |
968 | 2022-01-29 16:43:53 | willy | 2 | 53800 | 166 | 1.546 | 34799.5 |
967 | 2022-01-13 01:15:11 | willy | 1 | 28756 | 15 | 0.500 | 57512.0 |
966 | 2022-01-10 22:30:17 | willy | 1 | 28756 | 15 | 0.500 | 57512.0 |
965 | 2022-01-02 08:26:38 | willy | 2 | 53800 | 166 | 3.330 | 16156.2 |