History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1204 | 2024-04-30 03:48:53 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1203 | 2024-04-30 00:48:54 | pies | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1202 | 2024-04-28 23:23:52 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1201 | 2024-04-28 17:32:30 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1200 | 2024-04-27 19:10:23 | pies | 1 | 13983 | 30 | 0.500 | 27966.0 |
| 1199 | 2024-04-26 21:47:57 | pies | 1 | 13983 | 30 | 0.516 | 27098.8 |
| 1198 | 2024-04-25 22:12:33 | pies | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1197 | 2024-04-25 15:22:52 | pies | 1 | 13983 | 30 | 0.483 | 28950.3 |
| 1196 | 2024-04-25 11:58:47 | pies | 1 | 13983 | 30 | 0.826 | 16928.6 |
| 1195 | 2024-04-25 07:11:16 | pies | 1 | 13983 | 30 | 0.373 | 37487.9 |
| 1194 | 2024-04-13 05:51:09 | pies | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1193 | 2024-04-13 05:50:49 | pies | 2 | 29872 | 675 | 0.843 | 35435.3 |
| 1192 | 2024-04-11 14:00:57 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1191 | 2024-04-07 23:05:40 | pies | 1 | 13983 | 30 | 0.296 | 47239.9 |
| 1190 | 2024-04-03 00:13:28 | pies | 1 | 13983 | 30 | 0.530 | 26383.0 |
| 1189 | 2024-04-01 17:34:19 | pies | 2 | 29872 | 675 | 1.046 | 28558.3 |
| 1188 | 2024-04-01 16:26:23 | pies | 1 | 13983 | 30 | 0.656 | 21315.5 |
| 1187 | 2024-03-31 00:22:55 | pies | 1 | 13983 | 30 | 0.563 | 24836.6 |
| 1186 | 2024-03-26 03:09:53 | pies | 1 | 13983 | 30 | 0.296 | 47239.9 |
| 1185 | 2024-03-25 01:55:39 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1184 | 2024-03-23 20:57:50 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1183 | 2024-03-22 23:15:26 | pies | 1 | 13983 | 30 | 0.236 | 59250.0 |
| 1182 | 2024-03-21 19:17:44 | pies | 1 | 13983 | 30 | 0.450 | 31073.3 |
| 1181 | 2024-03-21 00:07:47 | pies | 1 | 13983 | 30 | 0.563 | 24836.6 |
| 1180 | 2024-03-07 14:42:33 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1179 | 2024-03-05 06:25:49 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1178 | 2024-03-04 08:33:03 | pies | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1177 | 2024-03-03 18:46:38 | pies | 1 | 13983 | 30 | 1.140 | 12265.8 |
| 1176 | 2024-03-03 03:09:49 | pies | 1 | 13983 | 30 | 0.203 | 68881.8 |
| 1175 | 2024-03-02 12:51:35 | pies | 1 | 13983 | 30 | 0.280 | 49939.3 |
| 1174 | 2024-02-25 17:13:31 | pies | 1 | 13983 | 30 | 0.860 | 16259.3 |
| 1173 | 2024-02-22 03:06:16 | pies | 1 | 13983 | 30 | 0.483 | 28950.3 |
| 1172 | 2024-02-21 13:17:17 | pies | 1 | 13983 | 30 | 0.470 | 29751.1 |
| 1171 | 2024-02-20 11:43:44 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1170 | 2024-02-19 14:33:40 | pies | 1 | 13983 | 30 | 0.236 | 59250.0 |
| 1169 | 2024-02-18 05:42:42 | pies | 1 | 13983 | 30 | 0.546 | 25609.9 |
| 1168 | 2024-02-17 09:05:50 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1167 | 2024-02-16 05:56:48 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1166 | 2024-02-10 08:53:30 | pies | 1 | 13983 | 30 | 0.546 | 25609.9 |
| 1165 | 2024-02-09 06:52:17 | pies | 1 | 13983 | 30 | 0.313 | 44674.1 |
| 1164 | 2024-02-08 12:45:40 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1163 | 2024-02-07 17:08:20 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1162 | 2024-02-02 15:01:03 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1161 | 2024-01-27 20:57:39 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1160 | 2024-01-22 08:35:39 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1159 | 2024-01-18 07:29:22 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1158 | 2023-12-19 04:42:00 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1157 | 2023-12-15 00:22:46 | pies | 1 | 13983 | 30 | 0.263 | 53167.3 |
| 1156 | 2023-12-02 21:22:43 | pies | 2 | 29872 | 675 | 0.890 | 33564.0 |
| 1155 | 2023-11-19 23:57:00 | pies | 2 | 29872 | 675 | 0.936 | 31914.5 |
| 1154 | 2023-11-15 04:34:07 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1153 | 2023-11-14 13:34:35 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1152 | 2023-11-10 14:34:30 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1151 | 2023-11-08 23:47:32 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1150 | 2023-11-01 23:52:43 | pies | 2 | 29872 | 675 | 0.876 | 34100.5 |
| 1149 | 2023-10-29 06:30:38 | pies | 2 | 29872 | 675 | 0.780 | 38297.4 |
| 1148 | 2023-10-25 21:59:11 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1147 | 2023-10-20 23:59:01 | pies | 2 | 29872 | 675 | 0.860 | 34734.9 |
| 1146 | 2023-10-20 05:10:21 | pies | 1 | 13983 | 30 | 0.283 | 49409.9 |
| 1145 | 2023-10-19 15:11:33 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1144 | 2023-10-17 08:51:08 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1143 | 2023-10-13 11:46:56 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1142 | 2023-10-08 21:54:49 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1141 | 2023-10-03 20:11:45 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1140 | 2023-09-22 22:13:07 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1139 | 2023-09-22 02:26:52 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1138 | 2023-09-02 17:35:15 | pies | 1 | 13983 | 30 | 0.420 | 33292.9 |
| 1137 | 2023-08-18 18:07:03 | pies | 1 | 13983 | 30 | 0.236 | 59250.0 |
| 1136 | 2023-07-14 15:04:52 | pies | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1135 | 2023-06-06 18:44:44 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1134 | 2023-04-10 16:15:55 | pies | 1 | 13983 | 30 | 0.236 | 59250.0 |
| 1133 | 2023-03-28 18:17:38 | pies | 1 | 13983 | 30 | 0.466 | 30006.4 |
| 1132 | 2023-01-12 01:45:03 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1131 | 2023-01-01 18:26:04 | pies | 1 | 13983 | 30 | 0.236 | 59250.0 |
| 1130 | 2022-10-30 21:19:00 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1129 | 2022-10-29 19:40:53 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1128 | 2022-10-28 22:56:29 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1127 | 2022-10-28 20:16:32 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1126 | 2022-10-27 19:19:19 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1125 | 2022-10-25 17:46:43 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1124 | 2022-10-24 22:21:02 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1123 | 2022-10-23 21:24:06 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1122 | 2022-10-22 19:26:51 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1121 | 2022-10-19 21:58:21 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1120 | 2022-10-13 20:50:25 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1119 | 2022-10-11 22:16:58 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1118 | 2022-10-08 22:31:09 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1117 | 2022-09-21 20:12:14 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1116 | 2022-09-12 07:31:29 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1115 | 2022-08-14 07:00:06 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1114 | 2022-08-05 23:26:53 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1113 | 2022-07-30 06:47:06 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1112 | 2022-07-10 15:52:55 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1111 | 2022-07-04 03:46:46 | pies | 2 | 29872 | 675 | 0.750 | 39829.3 |
| 1110 | 2022-06-26 09:18:58 | pies | 2 | 29872 | 675 | 0.783 | 38150.7 |
| 1109 | 2022-06-26 00:04:18 | pies | 1 | 13983 | 30 | 0.483 | 28950.3 |
| 1108 | 2022-06-17 15:46:29 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1107 | 2022-06-15 17:11:33 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1106 | 2022-03-07 06:05:50 | pies | 1 | 13983 | 30 | 0.236 | 59250.0 |
| 1105 | 2022-03-03 19:53:13 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |