History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wastries"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
325 | 2024-04-28 03:05:05 | wastries | 1 | 82945 | 4 | 2.533 | 32745.8 |
324 | 2024-04-13 12:03:00 | wastries | 1 | 82945 | 4 | 1.596 | 51970.6 |
323 | 2024-04-05 07:22:44 | wastries | 1 | 82945 | 4 | 3.516 | 23590.7 |
322 | 2024-04-05 07:22:09 | wastries | 3 | 146162 | 247 | 8.920 | 16385.9 |
321 | 2024-04-05 07:22:08 | wastries | 2 | 121059 | 16 | 6.046 | 20023.0 |
320 | 2024-04-05 02:20:32 | wastries | 1 | 82945 | 4 | 5.093 | 16286.1 |
319 | 2024-04-05 02:18:15 | wastries | 3 | 146162 | 247 | 19.313 | 7568.1 |
318 | 2024-04-05 02:18:17 | wastries | 2 | 121059 | 16 | 6.106 | 19826.2 |
317 | 2024-03-31 20:33:58 | wastries | 1 | 82945 | 4 | 1.360 | 60989.0 |
316 | 2024-03-31 18:29:45 | wastries | 1 | 82945 | 4 | 1.470 | 56425.2 |
315 | 2024-02-29 19:28:01 | wastries | 1 | 82945 | 4 | 1.500 | 55296.7 |
314 | 2024-01-29 21:52:18 | wastries | 1 | 82945 | 4 | 1.393 | 59544.1 |
313 | 2024-01-13 14:07:19 | wastries | 1 | 82945 | 4 | 1.393 | 59544.1 |
312 | 2023-12-24 08:52:31 | wastries | 2 | 121059 | 16 | 3.110 | 38925.7 |
311 | 2023-12-23 18:52:07 | wastries | 1 | 82945 | 4 | 1.266 | 65517.4 |
310 | 2023-12-18 06:54:23 | wastries | 2 | 121059 | 16 | 3.186 | 37997.2 |
309 | 2023-12-14 10:27:55 | wastries | 1 | 82945 | 4 | 1.436 | 57761.1 |
308 | 2023-12-04 15:43:07 | wastries | 1 | 82945 | 4 | 1.436 | 57761.1 |
307 | 2023-12-03 07:45:28 | wastries | 3 | 146162 | 247 | 6.766 | 21602.4 |
306 | 2023-12-02 07:04:36 | wastries | 2 | 121059 | 16 | 3.623 | 33414.0 |
305 | 2023-12-01 18:16:56 | wastries | 1 | 82945 | 4 | 1.390 | 59672.7 |
304 | 2023-11-27 06:10:05 | wastries | 1 | 82945 | 4 | 1.423 | 58288.8 |
303 | 2023-11-10 19:32:38 | wastries | 1 | 82945 | 4 | 1.233 | 67270.9 |
302 | 2023-11-10 04:08:36 | wastries | 1 | 82945 | 4 | 1.216 | 68211.3 |
301 | 2023-10-24 15:19:31 | wastries | 1 | 82945 | 4 | 1.500 | 55296.7 |
300 | 2023-10-10 16:24:31 | wastries | 1 | 82945 | 4 | 1.236 | 67107.6 |
299 | 2023-10-06 17:24:55 | wastries | 1 | 82945 | 4 | 1.266 | 65517.4 |
298 | 2023-09-22 20:34:42 | wastries | 1 | 82945 | 4 | 1.376 | 60279.8 |
297 | 2023-09-15 22:02:07 | wastries | 2 | 121059 | 16 | 3.173 | 38152.9 |
296 | 2023-08-06 03:41:49 | wastries | 1 | 82945 | 4 | 1.233 | 67270.9 |
295 | 2023-07-27 10:05:04 | wastries | 1 | 82945 | 4 | 1.266 | 65517.4 |
294 | 2023-06-06 14:48:56 | wastries | 2 | 121059 | 16 | 3.563 | 33976.7 |
293 | 2023-05-02 04:21:11 | wastries | 1 | 82945 | 4 | 1.233 | 67270.9 |
292 | 2023-03-28 01:26:36 | wastries | 1 | 82945 | 4 | 1.360 | 60989.0 |
291 | 2023-03-09 18:30:17 | wastries | 2 | 121059 | 16 | 3.143 | 38517.0 |
290 | 2023-02-21 15:12:28 | wastries | 1 | 82945 | 4 | 1.250 | 66356.0 |
289 | 2022-12-19 02:37:53 | wastries | 1 | 82945 | 4 | 1.250 | 66356.0 |
288 | 2022-12-13 22:17:29 | wastries | 2 | 121059 | 16 | 3.093 | 39139.7 |
287 | 2022-11-26 10:25:24 | wastries | 1 | 82945 | 4 | 1.233 | 67270.9 |
286 | 2022-11-23 01:59:46 | wastries | 1 | 82945 | 4 | 1.390 | 59672.7 |
285 | 2022-09-30 19:04:34 | wastries | 1 | 82945 | 4 | 1.456 | 56967.7 |
284 | 2022-09-18 16:31:40 | wastries | 1 | 82945 | 4 | 1.263 | 65673.0 |
283 | 2022-08-30 23:42:36 | wastries | 1 | 82945 | 4 | 1.420 | 58412.0 |
282 | 2022-08-23 20:15:51 | wastries | 1 | 82945 | 4 | 1.250 | 66356.0 |
281 | 2022-07-31 02:27:36 | wastries | 2 | 121059 | 16 | 3.096 | 39101.7 |
280 | 2022-07-15 19:11:39 | wastries | 1 | 82945 | 4 | 1.330 | 62364.7 |
279 | 2022-05-18 05:26:43 | wastries | 1 | 82945 | 4 | 1.236 | 67107.6 |
278 | 2022-04-15 10:45:43 | wastries | 1 | 82945 | 4 | 1.470 | 56425.2 |
277 | 2022-03-19 02:54:05 | wastries | 2 | 121059 | 16 | 3.126 | 38726.5 |
276 | 2022-03-04 23:31:03 | wastries | 1 | 82945 | 4 | 1.250 | 66356.0 |
275 | 2022-01-30 15:57:48 | wastries | 1 | 82945 | 4 | 1.530 | 54212.4 |
274 | 2022-01-28 11:02:36 | wastries | 1 | 82945 | 4 | 1.393 | 59544.1 |
273 | 2021-11-07 23:07:24 | wastries | 1 | 82945 | 4 | 1.390 | 59672.7 |
272 | 2021-07-22 06:38:29 | wastries | 1 | 82945 | 4 | 1.233 | 67270.9 |
271 | 2021-06-19 13:31:43 | wastries | 1 | 82945 | 4 | 2.813 | 29486.3 |
270 | 2021-04-19 12:38:48 | wastries | 1 | 82945 | 4 | 1.513 | 54821.5 |
269 | 2021-04-05 09:34:40 | wastries | 1 | 82945 | 4 | 1.376 | 60279.8 |
268 | 2021-03-30 17:58:27 | wastries | 1 | 82945 | 4 | 1.406 | 58993.6 |
267 | 2021-02-02 20:15:16 | wastries | 1 | 82945 | 4 | 1.266 | 65517.4 |
266 | 2021-01-14 02:44:03 | wastries | 1 | 82945 | 4 | 1.283 | 64649.3 |
265 | 2021-01-02 03:22:45 | wastries | 1 | 82945 | 4 | 1.283 | 64649.3 |
264 | 2020-12-15 04:40:02 | wastries | 1 | 82945 | 4 | 1.390 | 59672.7 |
263 | 2020-12-09 06:49:21 | wastries | 1 | 82945 | 4 | 1.500 | 55296.7 |
262 | 2020-10-25 23:02:58 | wastries | 1 | 82945 | 4 | 1.936 | 42843.5 |
261 | 2020-10-17 12:18:40 | wastries | 1 | 82945 | 4 | 1.280 | 64800.8 |
260 | 2020-09-30 06:54:40 | wastries | 1 | 82945 | 4 | 1.250 | 66356.0 |
259 | 2020-08-07 17:16:43 | wastries | 1 | 82945 | 4 | 1.373 | 60411.5 |
258 | 2020-07-26 11:29:42 | wastries | 1 | 82945 | 4 | 1.326 | 62552.8 |
257 | 2020-06-17 07:27:18 | wastries | 1 | 82945 | 4 | 1.373 | 60411.5 |
256 | 2020-03-29 18:18:01 | wastries | 1 | 82945 | 4 | 1.640 | 50576.2 |
255 | 2020-03-28 21:07:21 | wastries | 1 | 82945 | 4 | 1.453 | 57085.3 |
254 | 2020-03-26 17:35:43 | wastries | 1 | 82945 | 4 | 1.436 | 57761.1 |
253 | 2020-03-21 03:25:54 | wastries | 1 | 82945 | 4 | 1.500 | 55296.7 |
252 | 2020-03-12 13:44:00 | wastries | 1 | 82945 | 4 | 1.330 | 62364.7 |
251 | 2020-03-01 15:47:40 | wastries | 1 | 82945 | 4 | 1.483 | 55930.5 |
250 | 2020-02-26 05:37:49 | wastries | 1 | 82945 | 4 | 1.440 | 57600.7 |
249 | 2020-02-24 23:18:22 | wastries | 1 | 82945 | 4 | 1.516 | 54713.1 |
248 | 2020-02-24 17:06:36 | wastries | 1 | 82945 | 4 | 1.843 | 45005.4 |
247 | 2020-02-10 07:36:31 | wastries | 1 | 82945 | 4 | 2.063 | 40206.0 |
246 | 2020-02-04 09:44:31 | wastries | 1 | 82945 | 4 | 1.470 | 56425.2 |
245 | 2020-02-03 18:33:30 | wastries | 1 | 82945 | 4 | 2.156 | 38471.7 |
244 | 2020-01-31 05:10:00 | wastries | 1 | 82945 | 4 | 3.123 | 26559.4 |
243 | 2020-01-30 17:46:55 | wastries | 1 | 82945 | 4 | 1.500 | 55296.7 |
242 | 2020-01-27 19:41:14 | wastries | 1 | 82945 | 4 | 1.516 | 54713.1 |
241 | 2020-01-19 01:27:02 | wastries | 1 | 82945 | 4 | 2.530 | 32784.6 |
240 | 2020-01-14 01:14:57 | wastries | 1 | 82945 | 4 | 3.170 | 26165.6 |
239 | 2020-01-08 05:03:32 | wastries | 1 | 82945 | 4 | 2.813 | 29486.3 |
238 | 2020-01-07 03:13:12 | wastries | 1 | 82945 | 4 | 4.093 | 20265.1 |
237 | 2019-12-31 23:22:39 | wastries | 1 | 82945 | 4 | 1.626 | 51011.7 |
236 | 2019-12-30 03:53:11 | wastries | 1 | 82945 | 4 | 1.420 | 58412.0 |
235 | 2019-12-29 07:58:38 | wastries | 1 | 82945 | 4 | 1.470 | 56425.2 |
234 | 2019-12-12 13:23:44 | wastries | 1 | 82945 | 4 | 1.453 | 57085.3 |
233 | 2019-09-10 20:30:47 | wastries | 1 | 82945 | 4 | 1.190 | 69701.7 |
232 | 2019-06-11 03:58:05 | wastries | 1 | 82945 | 4 | 1.373 | 60411.5 |
231 | 2019-03-17 15:44:25 | wastries | 1 | 82945 | 4 | 1.226 | 67655.0 |
230 | 2019-02-26 19:12:23 | wastries | 1 | 82945 | 4 | 1.230 | 67435.0 |
229 | 2019-02-19 12:35:12 | wastries | 1 | 82945 | 4 | 1.276 | 65003.9 |
228 | 2019-02-11 07:51:30 | wastries | 1 | 82945 | 4 | 1.353 | 61304.5 |
227 | 2019-02-02 08:17:04 | wastries | 1 | 82945 | 4 | 1.203 | 68948.5 |
226 | 2019-01-24 13:50:38 | wastries | 1 | 82945 | 4 | 1.306 | 63510.7 |