History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"starches"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
363 | 2024-04-27 09:46:54 | starches | 1 | 82945 | 4 | 2.330 | 35598.7 |
362 | 2024-04-25 12:38:57 | starches | 2 | 121059 | 37 | 8.860 | 13663.5 |
361 | 2024-04-24 18:39:39 | starches | 2 | 121059 | 37 | 3.813 | 31749.0 |
360 | 2024-04-06 01:56:39 | starches | 1 | 82945 | 4 | 4.733 | 17524.8 |
359 | 2024-04-01 05:09:03 | starches | 2 | 121059 | 37 | 10.626 | 11392.7 |
358 | 2024-03-31 01:24:43 | starches | 3 | 146162 | 322 | 33.876 | 4314.6 |
357 | 2024-03-30 20:48:46 | starches | 3 | 146162 | 322 | 21.080 | 6933.7 |
356 | 2024-03-30 12:50:54 | starches | 3 | 146162 | 322 | 27.780 | 5261.4 |
355 | 2024-03-30 12:50:53 | starches | 2 | 121059 | 37 | 12.783 | 9470.3 |
354 | 2024-03-30 12:31:56 | starches | 1 | 82945 | 4 | 3.076 | 26965.2 |
353 | 2024-03-30 06:36:18 | starches | 1 | 82945 | 4 | 4.983 | 16645.6 |
352 | 2024-03-07 23:36:52 | starches | 3 | 146162 | 322 | 9.500 | 15385.5 |
351 | 2024-03-07 17:46:00 | starches | 3 | 146162 | 322 | 13.436 | 10878.4 |
350 | 2024-03-07 02:46:53 | starches | 2 | 121059 | 37 | 8.296 | 14592.5 |
349 | 2024-03-07 02:46:49 | starches | 3 | 146162 | 322 | 8.216 | 17789.9 |
348 | 2024-03-06 21:04:27 | starches | 1 | 82945 | 4 | 1.513 | 54821.5 |
347 | 2024-03-04 11:42:40 | starches | 1 | 82945 | 4 | 1.890 | 43886.2 |
346 | 2024-02-29 04:54:36 | starches | 1 | 82945 | 4 | 3.030 | 27374.6 |
345 | 2024-02-22 04:15:43 | starches | 2 | 121059 | 37 | 3.826 | 31641.1 |
344 | 2024-02-22 04:15:04 | starches | 3 | 146162 | 322 | 8.673 | 16852.5 |
343 | 2024-02-21 07:51:27 | starches | 3 | 146162 | 322 | 18.686 | 7822.0 |
342 | 2024-02-21 07:05:31 | starches | 3 | 146162 | 322 | 10.626 | 13755.1 |
341 | 2024-02-05 10:05:42 | starches | 3 | 146162 | 322 | 8.623 | 16950.2 |
340 | 2024-02-05 07:59:02 | starches | 3 | 146162 | 322 | 10.436 | 14005.6 |
339 | 2024-01-29 00:11:03 | starches | 1 | 82945 | 4 | 1.483 | 55930.5 |
338 | 2024-01-26 14:58:29 | starches | 3 | 146162 | 322 | 7.610 | 19206.6 |
337 | 2024-01-18 12:46:13 | starches | 3 | 146162 | 322 | 7.580 | 19282.6 |
336 | 2024-01-17 22:11:05 | starches | 3 | 146162 | 322 | 6.453 | 22650.2 |
335 | 2024-01-16 07:59:08 | starches | 1 | 82945 | 4 | 1.296 | 64000.8 |
334 | 2024-01-09 16:50:56 | starches | 3 | 146162 | 322 | 14.816 | 9865.1 |
333 | 2023-12-19 03:11:38 | starches | 1 | 82945 | 4 | 1.453 | 57085.3 |
332 | 2023-12-17 11:16:42 | starches | 2 | 121059 | 37 | 3.563 | 33976.7 |
331 | 2023-12-09 05:29:32 | starches | 1 | 82945 | 4 | 1.313 | 63172.1 |
330 | 2023-12-07 02:37:54 | starches | 1 | 82945 | 4 | 1.326 | 62552.8 |
329 | 2023-11-29 12:18:19 | starches | 1 | 82945 | 4 | 1.343 | 61761.0 |
328 | 2023-11-22 23:55:06 | starches | 1 | 82945 | 4 | 1.313 | 63172.1 |
327 | 2023-11-16 16:41:38 | starches | 3 | 146162 | 322 | 6.670 | 21913.3 |
326 | 2023-11-12 10:13:01 | starches | 1 | 82945 | 4 | 1.406 | 58993.6 |
325 | 2023-11-12 03:42:28 | starches | 1 | 82945 | 4 | 1.470 | 56425.2 |
324 | 2023-11-06 09:05:40 | starches | 1 | 82945 | 4 | 1.453 | 57085.3 |
323 | 2023-10-20 16:47:17 | starches | 1 | 82945 | 4 | 1.626 | 51011.7 |
322 | 2023-10-14 02:53:31 | starches | 1 | 82945 | 4 | 1.296 | 64000.8 |
321 | 2023-09-29 22:06:24 | starches | 1 | 82945 | 4 | 1.300 | 63803.8 |
320 | 2023-09-17 20:33:42 | starches | 2 | 121059 | 37 | 3.690 | 32807.3 |
319 | 2023-09-13 21:48:12 | starches | 1 | 82945 | 4 | 1.310 | 63316.8 |
318 | 2023-09-01 13:16:25 | starches | 1 | 82945 | 4 | 1.296 | 64000.8 |
317 | 2023-08-16 23:10:26 | starches | 3 | 146162 | 322 | 6.406 | 22816.4 |
316 | 2023-08-03 19:10:42 | starches | 1 | 82945 | 4 | 1.280 | 64800.8 |
315 | 2023-06-22 21:47:12 | starches | 2 | 121059 | 37 | 3.233 | 37444.8 |
314 | 2023-06-06 05:57:11 | starches | 1 | 82945 | 4 | 1.266 | 65517.4 |
313 | 2023-04-30 13:08:51 | starches | 3 | 146162 | 322 | 6.890 | 21213.6 |
312 | 2023-04-11 15:50:59 | starches | 1 | 82945 | 4 | 1.280 | 64800.8 |
311 | 2023-03-30 04:44:56 | starches | 1 | 82945 | 4 | 1.263 | 65673.0 |
310 | 2023-03-20 23:25:36 | starches | 2 | 121059 | 37 | 6.313 | 19176.1 |
309 | 2023-02-18 03:19:11 | starches | 3 | 146162 | 322 | 6.330 | 23090.4 |
308 | 2023-02-06 08:44:58 | starches | 3 | 146162 | 322 | 6.296 | 23215.1 |
307 | 2023-02-01 22:28:08 | starches | 1 | 82945 | 4 | 1.686 | 49196.3 |
306 | 2023-01-12 13:56:41 | starches | 1 | 82945 | 4 | 1.283 | 64649.3 |
305 | 2022-12-26 08:33:37 | starches | 1 | 82945 | 4 | 1.373 | 60411.5 |
304 | 2022-12-22 16:15:09 | starches | 1 | 82945 | 4 | 1.263 | 65673.0 |
303 | 2022-12-22 07:37:08 | starches | 2 | 121059 | 37 | 3.190 | 37949.5 |
302 | 2022-12-17 03:37:41 | starches | 1 | 82945 | 4 | 1.453 | 57085.3 |
301 | 2022-12-10 08:03:23 | starches | 1 | 82945 | 4 | 2.440 | 33993.9 |
300 | 2022-12-07 19:45:42 | starches | 3 | 146162 | 322 | 6.580 | 22213.1 |
299 | 2022-11-26 04:52:45 | starches | 3 | 146162 | 322 | 7.703 | 18974.7 |
298 | 2022-11-21 14:26:46 | starches | 1 | 82945 | 4 | 1.500 | 55296.7 |
297 | 2022-11-21 13:46:06 | starches | 1 | 82945 | 4 | 1.423 | 58288.8 |
296 | 2022-11-19 20:54:25 | starches | 3 | 146162 | 322 | 6.390 | 22873.6 |
295 | 2022-11-16 11:17:04 | starches | 1 | 82945 | 4 | 1.690 | 49079.9 |
294 | 2022-11-15 11:34:33 | starches | 3 | 146162 | 322 | 8.076 | 18098.3 |
293 | 2022-11-11 04:04:40 | starches | 1 | 82945 | 4 | 1.296 | 64000.8 |
292 | 2022-11-07 08:53:43 | starches | 3 | 146162 | 322 | 6.530 | 22383.2 |
291 | 2022-10-26 21:54:12 | starches | 1 | 82945 | 4 | 1.266 | 65517.4 |
290 | 2022-10-21 16:37:02 | starches | 3 | 146162 | 322 | 7.063 | 20694.0 |
289 | 2022-09-18 07:11:47 | starches | 3 | 146162 | 322 | 6.860 | 21306.4 |
288 | 2022-09-08 04:08:52 | starches | 3 | 146162 | 322 | 6.313 | 23152.5 |
287 | 2022-09-01 07:12:25 | starches | 3 | 146162 | 322 | 7.420 | 19698.4 |
286 | 2022-08-26 04:18:10 | starches | 1 | 82945 | 4 | 1.436 | 57761.1 |
285 | 2022-08-19 22:33:06 | starches | 2 | 121059 | 37 | 3.220 | 37596.0 |
284 | 2022-08-05 03:50:57 | starches | 3 | 146162 | 322 | 6.563 | 22270.6 |
283 | 2022-06-24 04:13:20 | starches | 3 | 146162 | 322 | 7.220 | 20244.0 |
282 | 2022-06-17 12:28:49 | starches | 1 | 82945 | 4 | 1.280 | 64800.8 |
281 | 2022-06-15 06:48:46 | starches | 1 | 82945 | 4 | 1.296 | 64000.8 |
280 | 2022-04-15 00:12:20 | starches | 1 | 82945 | 4 | 1.546 | 53651.4 |
279 | 2022-02-20 16:25:51 | starches | 1 | 82945 | 4 | 1.390 | 59672.7 |
278 | 2022-02-18 12:53:22 | starches | 1 | 82945 | 4 | 1.263 | 65673.0 |
277 | 2021-12-25 17:11:22 | starches | 1 | 82945 | 4 | 1.420 | 58412.0 |
276 | 2021-12-23 23:20:31 | starches | 1 | 82945 | 4 | 1.720 | 48223.8 |
275 | 2021-11-18 20:32:32 | starches | 1 | 82945 | 4 | 1.453 | 57085.3 |
274 | 2021-09-21 19:18:21 | starches | 1 | 82945 | 4 | 1.373 | 60411.5 |
273 | 2021-09-21 01:53:17 | starches | 1 | 82945 | 4 | 1.280 | 64800.8 |
272 | 2021-09-20 08:21:14 | starches | 1 | 82945 | 4 | 1.576 | 52630.1 |
271 | 2021-09-14 08:13:22 | starches | 1 | 82945 | 4 | 1.390 | 59672.7 |
270 | 2021-09-10 08:06:37 | starches | 1 | 82945 | 4 | 1.283 | 64649.3 |
269 | 2021-06-09 10:48:12 | starches | 1 | 82945 | 4 | 1.466 | 56579.1 |
268 | 2021-05-27 17:52:44 | starches | 1 | 82945 | 4 | 1.466 | 56579.1 |
267 | 2021-05-01 22:36:55 | starches | 1 | 82945 | 4 | 1.580 | 52496.8 |
266 | 2021-03-31 05:17:54 | starches | 1 | 82945 | 4 | 2.920 | 28405.8 |
265 | 2021-03-10 10:54:27 | starches | 1 | 82945 | 4 | 1.796 | 46183.2 |
264 | 2021-02-23 15:01:58 | starches | 1 | 82945 | 4 | 1.580 | 52496.8 |