History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"redcaps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
278 | 2024-03-28 06:02:17 | redcaps | 1 | 69583 | 3 | 2.686 | 25905.8 |
277 | 2024-01-19 13:53:00 | redcaps | 2 | 107671 | 21 | 2.906 | 37051.3 |
276 | 2024-01-18 05:48:02 | redcaps | 3 | 134027 | 236 | 6.310 | 21240.4 |
275 | 2024-01-15 07:18:45 | redcaps | 1 | 69583 | 3 | 1.110 | 62687.4 |
274 | 2023-12-27 21:07:16 | redcaps | 1 | 69583 | 3 | 1.250 | 55666.4 |
273 | 2023-12-06 11:30:56 | redcaps | 2 | 107671 | 21 | 3.703 | 29076.7 |
272 | 2023-12-06 11:30:50 | redcaps | 3 | 134027 | 236 | 6.596 | 20319.4 |
271 | 2023-11-28 18:08:28 | redcaps | 1 | 69583 | 3 | 1.080 | 64428.7 |
270 | 2023-11-23 13:52:04 | redcaps | 1 | 69583 | 3 | 1.200 | 57985.8 |
269 | 2023-11-11 03:12:13 | redcaps | 1 | 69583 | 3 | 1.250 | 55666.4 |
268 | 2023-10-31 05:29:37 | redcaps | 2 | 107671 | 21 | 7.250 | 14851.2 |
267 | 2023-10-28 20:10:52 | redcaps | 3 | 134027 | 236 | 7.626 | 17575.0 |
266 | 2023-10-28 04:00:55 | redcaps | 1 | 69583 | 3 | 1.250 | 55666.4 |
265 | 2023-10-23 17:48:20 | redcaps | 1 | 69583 | 3 | 1.203 | 57841.2 |
264 | 2023-10-17 03:56:37 | redcaps | 1 | 69583 | 3 | 1.263 | 55093.4 |
263 | 2023-09-28 06:57:51 | redcaps | 1 | 69583 | 3 | 2.546 | 27330.3 |
262 | 2023-09-14 20:15:38 | redcaps | 1 | 69583 | 3 | 1.170 | 59472.6 |
261 | 2023-08-30 15:48:06 | redcaps | 1 | 69583 | 3 | 1.126 | 61796.6 |
260 | 2023-08-22 02:35:11 | redcaps | 1 | 69583 | 3 | 1.313 | 52995.4 |
259 | 2023-08-06 21:25:29 | redcaps | 2 | 107671 | 21 | 2.923 | 36835.8 |
258 | 2023-08-05 08:07:50 | redcaps | 3 | 134027 | 236 | 5.750 | 23309.0 |
257 | 2023-06-05 22:19:02 | redcaps | 1 | 69583 | 3 | 1.126 | 61796.6 |
256 | 2023-04-27 05:46:40 | redcaps | 1 | 69583 | 3 | 1.110 | 62687.4 |
255 | 2023-04-16 12:56:59 | redcaps | 2 | 107671 | 21 | 2.813 | 38276.2 |
254 | 2023-04-16 02:04:52 | redcaps | 3 | 134027 | 236 | 5.796 | 23124.1 |
253 | 2023-03-27 20:53:52 | redcaps | 1 | 69583 | 3 | 1.126 | 61796.6 |
252 | 2023-01-23 12:08:16 | redcaps | 2 | 107671 | 21 | 2.813 | 38276.2 |
251 | 2023-01-21 15:10:25 | redcaps | 3 | 134027 | 236 | 6.546 | 20474.6 |
250 | 2023-01-11 09:37:08 | redcaps | 1 | 69583 | 3 | 1.186 | 58670.3 |
249 | 2023-01-07 10:41:07 | redcaps | 1 | 69583 | 3 | 1.060 | 65644.3 |
248 | 2023-01-03 16:46:14 | redcaps | 1 | 69583 | 3 | 1.216 | 57222.9 |
247 | 2022-11-04 09:57:17 | redcaps | 2 | 107671 | 21 | 2.873 | 37476.9 |
246 | 2022-11-02 23:52:24 | redcaps | 3 | 134027 | 236 | 6.876 | 19492.0 |
245 | 2022-10-30 03:27:34 | redcaps | 1 | 69583 | 3 | 1.216 | 57222.9 |
244 | 2022-09-02 11:47:41 | redcaps | 1 | 69583 | 3 | 1.110 | 62687.4 |
243 | 2022-06-18 05:51:16 | redcaps | 1 | 69583 | 3 | 1.093 | 63662.4 |
242 | 2022-06-06 18:45:15 | redcaps | 2 | 107671 | 21 | 2.843 | 37872.3 |
241 | 2022-05-28 08:01:55 | redcaps | 3 | 134027 | 236 | 5.810 | 23068.3 |
240 | 2022-04-22 16:38:32 | redcaps | 1 | 69583 | 3 | 1.123 | 61961.7 |
239 | 2022-02-23 12:48:19 | redcaps | 1 | 69583 | 3 | 1.436 | 48456.1 |
238 | 2022-01-20 23:11:32 | redcaps | 3 | 134027 | 236 | 7.486 | 17903.7 |
237 | 2022-01-06 11:39:25 | redcaps | 1 | 69583 | 3 | 1.330 | 52318.0 |
236 | 2021-12-14 17:53:53 | redcaps | 1 | 69583 | 3 | 1.330 | 52318.0 |
235 | 2021-12-05 03:14:34 | redcaps | 1 | 69583 | 3 | 1.310 | 53116.8 |
234 | 2021-12-04 18:00:52 | redcaps | 1 | 69583 | 3 | 1.233 | 56433.9 |
233 | 2021-12-04 07:16:00 | redcaps | 1 | 69583 | 3 | 2.076 | 33517.8 |
232 | 2021-12-03 16:38:02 | redcaps | 1 | 69583 | 3 | 1.110 | 62687.4 |
231 | 2021-12-03 05:33:42 | redcaps | 1 | 69583 | 3 | 1.250 | 55666.4 |
230 | 2021-12-02 17:22:55 | redcaps | 1 | 69583 | 3 | 1.203 | 57841.2 |
229 | 2021-11-15 23:58:17 | redcaps | 1 | 69583 | 3 | 1.266 | 54962.9 |
228 | 2021-11-14 22:37:35 | redcaps | 1 | 69583 | 3 | 1.080 | 64428.7 |
227 | 2021-11-11 19:33:33 | redcaps | 1 | 69583 | 3 | 1.156 | 60192.9 |
226 | 2021-10-21 22:36:53 | redcaps | 1 | 69583 | 3 | 1.453 | 47889.2 |
225 | 2021-09-27 03:58:07 | redcaps | 1 | 69583 | 3 | 1.110 | 62687.4 |
224 | 2021-09-26 13:34:30 | redcaps | 1 | 69583 | 3 | 1.280 | 54361.7 |
223 | 2021-09-23 23:17:03 | redcaps | 1 | 69583 | 3 | 1.140 | 61037.7 |
222 | 2021-09-22 09:27:48 | redcaps | 1 | 69583 | 3 | 1.190 | 58473.1 |
221 | 2021-09-07 14:49:31 | redcaps | 1 | 69583 | 3 | 1.093 | 63662.4 |
220 | 2021-08-18 20:17:12 | redcaps | 1 | 69583 | 3 | 1.110 | 62687.4 |
219 | 2021-03-24 06:59:23 | redcaps | 1 | 69583 | 3 | 1.236 | 56296.9 |
218 | 2021-02-02 15:39:12 | redcaps | 1 | 69583 | 3 | 1.126 | 61796.6 |
217 | 2021-01-06 21:14:46 | redcaps | 1 | 69583 | 3 | 1.110 | 62687.4 |
216 | 2020-12-09 02:20:53 | redcaps | 1 | 69583 | 3 | 1.126 | 61796.6 |
215 | 2020-11-03 15:28:48 | redcaps | 1 | 69583 | 3 | 1.140 | 61037.7 |
214 | 2020-11-01 16:38:36 | redcaps | 1 | 69583 | 3 | 1.236 | 56296.9 |
213 | 2020-10-21 19:28:04 | redcaps | 1 | 69583 | 3 | 1.173 | 59320.5 |
212 | 2020-10-14 01:29:01 | redcaps | 1 | 69583 | 3 | 1.216 | 57222.9 |
211 | 2020-08-26 08:22:23 | redcaps | 1 | 69583 | 3 | 1.173 | 59320.5 |
210 | 2020-08-17 19:05:21 | redcaps | 1 | 69583 | 3 | 1.156 | 60192.9 |
209 | 2020-08-15 19:32:35 | redcaps | 1 | 69583 | 3 | 1.173 | 59320.5 |
208 | 2020-07-28 09:08:24 | redcaps | 1 | 69583 | 3 | 1.156 | 60192.9 |
207 | 2020-04-02 07:21:05 | redcaps | 1 | 69583 | 3 | 1.220 | 57035.2 |
206 | 2020-03-28 23:53:44 | redcaps | 1 | 69583 | 3 | 1.216 | 57222.9 |
205 | 2020-03-24 16:18:46 | redcaps | 1 | 69583 | 3 | 1.330 | 52318.0 |
204 | 2020-03-23 21:40:55 | redcaps | 1 | 69583 | 3 | 1.330 | 52318.0 |
203 | 2020-03-20 12:21:40 | redcaps | 1 | 69583 | 3 | 2.656 | 26198.4 |
202 | 2020-03-07 07:55:50 | redcaps | 1 | 69583 | 3 | 1.110 | 62687.4 |
201 | 2020-03-01 03:07:11 | redcaps | 1 | 69583 | 3 | 1.423 | 48898.8 |
200 | 2020-02-28 19:25:46 | redcaps | 3 | 134027 | 236 | 16.563 | 8092.0 |
199 | 2020-02-28 18:33:45 | redcaps | 3 | 134027 | 236 | 11.376 | 11781.6 |
198 | 2020-02-28 14:29:03 | redcaps | 3 | 134027 | 236 | 24.186 | 5541.5 |
197 | 2020-02-28 07:25:33 | redcaps | 3 | 134027 | 236 | 9.220 | 14536.6 |
196 | 2020-02-28 00:52:16 | redcaps | 3 | 134027 | 236 | 8.186 | 16372.7 |
195 | 2020-02-20 12:05:26 | redcaps | 1 | 69583 | 3 | 1.360 | 51164.0 |
194 | 2020-02-11 10:49:21 | redcaps | 1 | 69583 | 3 | 3.046 | 22844.1 |
193 | 2020-02-09 20:36:17 | redcaps | 1 | 69583 | 3 | 1.236 | 56296.9 |
192 | 2020-02-09 18:05:34 | redcaps | 1 | 69583 | 3 | 1.330 | 52318.0 |
191 | 2020-02-06 02:30:00 | redcaps | 1 | 69583 | 3 | 1.576 | 44151.6 |
190 | 2020-02-05 11:14:42 | redcaps | 1 | 69583 | 3 | 1.406 | 49490.0 |
189 | 2020-02-01 10:01:00 | redcaps | 1 | 69583 | 3 | 1.530 | 45479.1 |
188 | 2020-01-24 16:14:18 | redcaps | 1 | 69583 | 3 | 1.440 | 48321.5 |
187 | 2020-01-18 00:38:00 | redcaps | 2 | 107671 | 21 | 8.266 | 13025.8 |
186 | 2020-01-17 20:40:15 | redcaps | 1 | 69583 | 3 | 1.970 | 35321.3 |
185 | 2020-01-16 08:26:55 | redcaps | 1 | 69583 | 3 | 2.686 | 25905.8 |
184 | 2020-01-13 21:15:01 | redcaps | 3 | 134027 | 236 | 18.733 | 7154.6 |
183 | 2020-01-13 21:07:00 | redcaps | 3 | 134027 | 236 | 19.296 | 6945.8 |
182 | 2020-01-13 14:58:26 | redcaps | 3 | 134027 | 236 | 8.330 | 16089.7 |
181 | 2020-01-13 14:58:25 | redcaps | 2 | 107671 | 21 | 3.826 | 28141.9 |
180 | 2020-01-13 09:40:28 | redcaps | 1 | 69583 | 3 | 1.563 | 44518.9 |
179 | 2020-01-12 14:55:33 | redcaps | 1 | 69583 | 3 | 1.236 | 56296.9 |