History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"role"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1155 | 2024-04-27 04:29:15 | role | 1 | 13983 | 29 | 0.266 | 52567.7 |
1154 | 2024-04-27 03:47:02 | role | 2 | 29872 | 428 | 1.983 | 15064.0 |
1153 | 2024-04-26 22:57:50 | role | 2 | 29872 | 428 | 1.876 | 15923.2 |
1152 | 2024-04-26 21:47:12 | role | 1 | 13983 | 29 | 0.733 | 19076.4 |
1151 | 2024-04-21 07:21:07 | role | 1 | 13983 | 29 | 0.390 | 35853.8 |
1150 | 2024-04-20 11:55:33 | role | 1 | 13983 | 29 | 0.750 | 18644.0 |
1149 | 2024-04-11 00:01:01 | role | 2 | 29872 | 428 | 1.063 | 28101.6 |
1148 | 2024-04-02 18:27:55 | role | 1 | 13983 | 29 | 0.343 | 40766.8 |
1147 | 2024-04-01 16:11:51 | role | 1 | 13983 | 29 | 0.876 | 15962.3 |
1146 | 2024-03-31 00:29:02 | role | 1 | 13983 | 29 | 0.843 | 16587.2 |
1145 | 2024-03-28 17:46:59 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1144 | 2024-03-27 14:59:40 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1143 | 2024-03-27 14:59:30 | role | 1 | 13983 | 29 | 0.516 | 27098.8 |
1142 | 2024-03-27 14:59:26 | role | 2 | 29872 | 428 | 0.920 | 32469.6 |
1141 | 2024-03-02 14:20:15 | role | 2 | 29872 | 428 | 2.110 | 14157.3 |
1140 | 2024-03-02 13:59:23 | role | 1 | 13983 | 29 | 0.576 | 24276.0 |
1139 | 2024-02-29 19:31:56 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1138 | 2024-02-26 19:21:33 | role | 1 | 13983 | 29 | 0.843 | 16587.2 |
1137 | 2024-02-25 21:10:52 | role | 1 | 13983 | 29 | 0.826 | 16928.6 |
1136 | 2024-02-22 01:48:02 | role | 2 | 29872 | 428 | 1.033 | 28917.7 |
1135 | 2024-02-21 06:02:48 | role | 1 | 13983 | 29 | 1.280 | 10924.2 |
1134 | 2024-02-20 00:43:21 | role | 2 | 29872 | 428 | 2.123 | 14070.7 |
1133 | 2024-02-19 14:49:22 | role | 2 | 29872 | 428 | 1.033 | 28917.7 |
1132 | 2024-01-27 18:46:45 | role | 1 | 13983 | 29 | 0.233 | 60012.9 |
1131 | 2024-01-23 05:16:46 | role | 2 | 29872 | 428 | 0.766 | 38997.4 |
1130 | 2024-01-06 22:30:54 | role | 1 | 13983 | 29 | 0.233 | 60012.9 |
1129 | 2023-12-20 07:35:41 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1128 | 2023-12-09 19:35:54 | role | 2 | 29872 | 428 | 0.766 | 38997.4 |
1127 | 2023-12-06 23:28:22 | role | 2 | 29872 | 428 | 0.903 | 33080.8 |
1126 | 2023-12-06 23:28:21 | role | 2 | 29872 | 428 | 0.873 | 34217.6 |
1125 | 2023-12-05 17:35:08 | role | 2 | 29872 | 428 | 0.920 | 32469.6 |
1124 | 2023-11-18 03:44:50 | role | 1 | 13983 | 29 | 0.266 | 52567.7 |
1123 | 2023-11-15 12:38:49 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1122 | 2023-11-11 08:00:20 | role | 1 | 13983 | 29 | 0.563 | 24836.6 |
1121 | 2023-11-10 15:17:33 | role | 1 | 13983 | 29 | 0.236 | 59250.0 |
1120 | 2023-11-02 07:40:45 | role | 2 | 29872 | 428 | 1.016 | 29401.6 |
1119 | 2023-11-01 16:30:09 | role | 1 | 13983 | 29 | 0.216 | 64736.1 |
1118 | 2023-10-31 17:16:03 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1117 | 2023-10-27 01:55:53 | role | 2 | 29872 | 428 | 0.766 | 38997.4 |
1116 | 2023-10-19 20:01:51 | role | 1 | 13983 | 29 | 0.266 | 52567.7 |
1115 | 2023-10-18 11:22:30 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1114 | 2023-10-14 06:16:30 | role | 1 | 13983 | 29 | 0.236 | 59250.0 |
1113 | 2023-10-13 19:02:17 | role | 1 | 13983 | 29 | 0.266 | 52567.7 |
1112 | 2023-10-03 17:09:32 | role | 1 | 13983 | 29 | 0.483 | 28950.3 |
1111 | 2023-09-24 07:14:55 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1110 | 2023-09-07 10:44:16 | role | 2 | 29872 | 428 | 0.766 | 38997.4 |
1109 | 2023-09-03 09:26:23 | role | 1 | 13983 | 29 | 0.216 | 64736.1 |
1108 | 2023-08-23 20:29:06 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1107 | 2023-05-27 16:19:13 | role | 2 | 29872 | 428 | 0.873 | 34217.6 |
1106 | 2023-05-24 10:47:43 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1105 | 2023-05-24 08:38:35 | role | 1 | 13983 | 29 | 0.216 | 64736.1 |
1104 | 2023-03-19 05:14:39 | role | 1 | 13983 | 29 | 0.203 | 68881.8 |
1103 | 2023-03-06 10:44:14 | role | 2 | 29872 | 428 | 0.860 | 34734.9 |
1102 | 2023-02-07 20:49:43 | role | 1 | 13983 | 29 | 0.216 | 64736.1 |
1101 | 2023-01-06 10:38:54 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1100 | 2022-12-12 18:51:29 | role | 2 | 29872 | 428 | 0.876 | 34100.5 |
1099 | 2022-10-28 13:44:58 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1098 | 2022-10-01 12:54:44 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1097 | 2022-09-19 22:05:42 | role | 1 | 13983 | 29 | 0.233 | 60012.9 |
1096 | 2022-09-17 17:42:14 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1095 | 2022-09-10 18:41:08 | role | 1 | 13983 | 29 | 0.266 | 52567.7 |
1094 | 2022-08-31 02:28:48 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1093 | 2022-08-15 11:07:37 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1092 | 2022-08-14 20:01:28 | role | 1 | 13983 | 29 | 0.216 | 64736.1 |
1091 | 2022-07-29 04:14:06 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1090 | 2022-07-28 23:31:59 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1089 | 2022-07-19 14:11:49 | role | 2 | 29872 | 428 | 0.780 | 38297.4 |
1088 | 2022-07-18 19:13:11 | role | 1 | 13983 | 29 | 0.216 | 64736.1 |
1087 | 2022-07-14 20:22:03 | role | 2 | 29872 | 428 | 0.796 | 37527.6 |
1086 | 2022-05-13 07:53:37 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1085 | 2022-04-15 23:10:31 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1084 | 2022-04-14 23:52:47 | role | 1 | 13983 | 29 | 0.373 | 37487.9 |
1083 | 2022-03-24 19:16:11 | role | 1 | 13983 | 29 | 0.326 | 42892.6 |
1082 | 2022-03-21 21:46:29 | role | 1 | 13983 | 29 | 0.233 | 60012.9 |
1081 | 2022-03-20 23:00:18 | role | 1 | 13983 | 29 | 0.233 | 60012.9 |
1080 | 2022-03-01 17:52:18 | role | 1 | 13983 | 29 | 0.233 | 60012.9 |
1079 | 2022-02-28 15:59:06 | role | 1 | 13983 | 29 | 0.280 | 49939.3 |
1078 | 2022-02-27 22:23:58 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1077 | 2022-02-27 11:06:21 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1076 | 2022-02-26 17:35:15 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1075 | 2022-02-26 03:45:11 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1074 | 2022-02-26 00:15:30 | role | 1 | 13983 | 29 | 0.263 | 53167.3 |
1073 | 2022-02-25 15:12:21 | role | 1 | 13983 | 29 | 0.266 | 52567.7 |
1072 | 2022-02-21 05:52:43 | role | 2 | 29872 | 428 | 0.873 | 34217.6 |
1071 | 2022-02-13 00:20:23 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1070 | 2022-02-12 12:38:59 | role | 1 | 13983 | 29 | 0.280 | 49939.3 |
1069 | 2022-02-11 21:42:55 | role | 1 | 13983 | 29 | 0.233 | 60012.9 |
1068 | 2022-02-11 05:10:10 | role | 1 | 13983 | 29 | 0.233 | 60012.9 |
1067 | 2022-01-30 03:38:13 | role | 1 | 13983 | 29 | 0.233 | 60012.9 |
1066 | 2022-01-27 22:58:34 | role | 1 | 13983 | 29 | 0.313 | 44674.1 |
1065 | 2021-12-31 21:48:25 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1064 | 2021-12-31 10:41:43 | role | 1 | 13983 | 29 | 0.530 | 26383.0 |
1063 | 2021-12-30 21:36:47 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1062 | 2021-12-30 03:02:26 | role | 1 | 13983 | 29 | 0.266 | 52567.7 |
1061 | 2021-12-29 15:16:07 | role | 1 | 13983 | 29 | 0.216 | 64736.1 |
1060 | 2021-12-29 06:45:08 | role | 1 | 13983 | 29 | 0.250 | 55932.0 |
1059 | 2021-12-28 14:10:12 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1058 | 2021-12-27 19:27:34 | role | 1 | 13983 | 29 | 0.220 | 63559.1 |
1057 | 2021-12-27 02:24:07 | role | 1 | 13983 | 29 | 0.263 | 53167.3 |
1056 | 2021-12-26 15:17:39 | role | 1 | 13983 | 29 | 0.266 | 52567.7 |