History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"recepts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
376 | 2024-04-25 20:28:24 | recepts | 1 | 69583 | 4 | 5.360 | 12981.9 |
375 | 2024-04-20 06:24:29 | recepts | 3 | 134027 | 395 | 20.033 | 6690.3 |
374 | 2024-04-18 23:25:34 | recepts | 2 | 107671 | 48 | 5.046 | 21337.9 |
373 | 2024-04-18 20:41:42 | recepts | 3 | 134027 | 395 | 8.233 | 16279.2 |
372 | 2024-04-17 21:53:28 | recepts | 3 | 134027 | 395 | 9.720 | 13788.8 |
371 | 2024-04-17 21:53:29 | recepts | 2 | 107671 | 48 | 6.030 | 17855.9 |
370 | 2024-04-17 13:44:38 | recepts | 2 | 107671 | 48 | 7.656 | 14063.6 |
369 | 2024-04-17 13:44:14 | recepts | 3 | 134027 | 395 | 9.046 | 14816.2 |
368 | 2024-04-16 22:28:08 | recepts | 2 | 107671 | 48 | 4.283 | 25139.2 |
367 | 2024-04-16 22:06:13 | recepts | 3 | 134027 | 395 | 22.170 | 6045.4 |
366 | 2024-04-16 22:05:06 | recepts | 3 | 134027 | 395 | 22.250 | 6023.7 |
365 | 2024-04-16 21:59:52 | recepts | 2 | 107671 | 48 | 9.393 | 11462.9 |
364 | 2024-04-16 21:58:42 | recepts | 1 | 69583 | 4 | 3.296 | 21111.3 |
363 | 2024-04-16 21:58:14 | recepts | 1 | 69583 | 4 | 1.796 | 38743.3 |
362 | 2024-03-10 18:26:08 | recepts | 3 | 134027 | 395 | 17.093 | 7841.0 |
361 | 2024-03-10 15:46:11 | recepts | 3 | 134027 | 395 | 15.063 | 8897.8 |
360 | 2024-03-07 18:17:29 | recepts | 2 | 107671 | 48 | 4.076 | 26415.8 |
359 | 2024-03-07 18:17:01 | recepts | 3 | 134027 | 395 | 8.373 | 16007.0 |
358 | 2024-03-07 13:20:15 | recepts | 3 | 134027 | 395 | 7.360 | 18210.2 |
357 | 2024-03-07 13:20:13 | recepts | 2 | 107671 | 48 | 3.623 | 29718.7 |
356 | 2024-03-07 12:17:18 | recepts | 1 | 69583 | 4 | 1.110 | 62687.4 |
355 | 2024-01-25 05:13:06 | recepts | 1 | 69583 | 4 | 1.110 | 62687.4 |
354 | 2024-01-24 02:05:31 | recepts | 1 | 69583 | 4 | 1.250 | 55666.4 |
353 | 2024-01-18 08:13:58 | recepts | 3 | 134027 | 395 | 6.050 | 22153.2 |
352 | 2023-12-28 23:29:18 | recepts | 3 | 134027 | 395 | 11.673 | 11481.8 |
351 | 2023-12-28 23:29:17 | recepts | 2 | 107671 | 48 | 3.436 | 31336.1 |
350 | 2023-12-25 22:11:27 | recepts | 3 | 134027 | 395 | 7.173 | 18684.9 |
349 | 2023-12-09 13:23:20 | recepts | 3 | 134027 | 395 | 10.406 | 12879.8 |
348 | 2023-12-09 13:23:15 | recepts | 2 | 107671 | 48 | 7.360 | 14629.2 |
347 | 2023-11-22 14:23:53 | recepts | 1 | 69583 | 4 | 1.203 | 57841.2 |
346 | 2023-11-21 04:52:08 | recepts | 1 | 69583 | 4 | 1.300 | 53525.4 |
345 | 2023-11-13 05:36:12 | recepts | 1 | 69583 | 4 | 1.110 | 62687.4 |
344 | 2023-11-11 06:44:57 | recepts | 1 | 69583 | 4 | 1.123 | 61961.7 |
343 | 2023-10-30 05:56:47 | recepts | 1 | 69583 | 4 | 1.343 | 51811.6 |
342 | 2023-10-30 01:33:45 | recepts | 3 | 134027 | 395 | 6.080 | 22043.9 |
341 | 2023-10-23 18:18:52 | recepts | 1 | 69583 | 4 | 1.076 | 64668.2 |
340 | 2023-10-15 22:44:47 | recepts | 1 | 69583 | 4 | 1.076 | 64668.2 |
339 | 2023-09-29 15:12:15 | recepts | 1 | 69583 | 4 | 1.093 | 63662.4 |
338 | 2023-09-25 17:52:40 | recepts | 1 | 69583 | 4 | 1.093 | 63662.4 |
337 | 2023-09-25 03:58:57 | recepts | 1 | 69583 | 4 | 2.453 | 28366.5 |
336 | 2023-09-08 16:45:15 | recepts | 1 | 69583 | 4 | 1.110 | 62687.4 |
335 | 2023-08-22 12:52:52 | recepts | 1 | 69583 | 4 | 1.296 | 53690.6 |
334 | 2023-08-07 05:09:01 | recepts | 3 | 134027 | 395 | 5.906 | 22693.4 |
333 | 2023-07-19 03:52:34 | recepts | 2 | 107671 | 48 | 3.360 | 32044.9 |
332 | 2023-07-04 04:49:38 | recepts | 1 | 69583 | 4 | 1.313 | 52995.4 |
331 | 2023-06-15 07:24:20 | recepts | 1 | 69583 | 4 | 1.236 | 56296.9 |
330 | 2023-06-12 13:17:00 | recepts | 1 | 69583 | 4 | 1.326 | 52475.9 |
329 | 2023-05-17 20:07:57 | recepts | 2 | 107671 | 48 | 2.893 | 37217.8 |
328 | 2023-05-17 06:56:10 | recepts | 1 | 69583 | 4 | 1.190 | 58473.1 |
327 | 2023-04-21 16:57:01 | recepts | 3 | 134027 | 395 | 5.890 | 22755.0 |
326 | 2023-04-01 01:48:16 | recepts | 1 | 69583 | 4 | 1.076 | 64668.2 |
325 | 2023-03-03 12:41:41 | recepts | 1 | 69583 | 4 | 1.233 | 56433.9 |
324 | 2023-01-27 09:04:42 | recepts | 3 | 134027 | 395 | 6.533 | 20515.4 |
323 | 2023-01-17 13:38:20 | recepts | 1 | 69583 | 4 | 1.203 | 57841.2 |
322 | 2022-11-14 07:02:10 | recepts | 1 | 69583 | 4 | 1.080 | 64428.7 |
321 | 2022-11-11 02:53:39 | recepts | 1 | 69583 | 4 | 1.093 | 63662.4 |
320 | 2022-11-08 18:17:51 | recepts | 3 | 134027 | 395 | 6.170 | 21722.4 |
319 | 2022-11-07 16:06:15 | recepts | 1 | 69583 | 4 | 1.266 | 54962.9 |
318 | 2022-09-11 02:35:14 | recepts | 3 | 134027 | 395 | 5.953 | 22514.2 |
317 | 2022-08-14 19:33:49 | recepts | 3 | 134027 | 395 | 6.186 | 21666.2 |
316 | 2022-07-21 22:45:43 | recepts | 1 | 69583 | 4 | 1.096 | 63488.1 |
315 | 2022-07-05 22:28:09 | recepts | 1 | 69583 | 4 | 1.106 | 62914.1 |
314 | 2022-06-11 11:49:21 | recepts | 3 | 134027 | 395 | 5.953 | 22514.2 |
313 | 2022-04-03 14:36:54 | recepts | 1 | 69583 | 4 | 1.263 | 55093.4 |
312 | 2022-03-06 09:50:26 | recepts | 1 | 69583 | 4 | 1.110 | 62687.4 |
311 | 2022-02-01 18:53:31 | recepts | 3 | 134027 | 395 | 6.986 | 19185.1 |
310 | 2021-12-19 21:20:43 | recepts | 1 | 69583 | 4 | 1.220 | 57035.2 |
309 | 2021-12-16 20:41:52 | recepts | 1 | 69583 | 4 | 1.296 | 53690.6 |
308 | 2021-11-15 16:57:44 | recepts | 1 | 69583 | 4 | 1.233 | 56433.9 |
307 | 2021-11-15 08:39:23 | recepts | 1 | 69583 | 4 | 1.220 | 57035.2 |
306 | 2021-11-14 16:24:18 | recepts | 1 | 69583 | 4 | 1.233 | 56433.9 |
305 | 2021-11-14 08:07:27 | recepts | 1 | 69583 | 4 | 1.250 | 55666.4 |
304 | 2021-11-13 17:58:23 | recepts | 1 | 69583 | 4 | 1.110 | 62687.4 |
303 | 2021-11-13 09:38:00 | recepts | 1 | 69583 | 4 | 2.016 | 34515.4 |
302 | 2021-11-12 20:32:06 | recepts | 1 | 69583 | 4 | 1.376 | 50569.0 |
301 | 2021-11-12 07:02:49 | recepts | 1 | 69583 | 4 | 1.263 | 55093.4 |
300 | 2021-11-11 13:38:26 | recepts | 1 | 69583 | 4 | 1.283 | 54234.6 |
299 | 2021-11-09 10:39:58 | recepts | 1 | 69583 | 4 | 2.530 | 27503.2 |
298 | 2021-11-07 08:21:27 | recepts | 1 | 69583 | 4 | 1.280 | 54361.7 |
297 | 2021-10-14 14:39:29 | recepts | 1 | 69583 | 4 | 1.483 | 46920.4 |
296 | 2021-10-13 17:53:57 | recepts | 1 | 69583 | 4 | 1.076 | 64668.2 |
295 | 2021-10-12 10:25:45 | recepts | 1 | 69583 | 4 | 1.390 | 50059.7 |
294 | 2021-10-11 13:16:22 | recepts | 1 | 69583 | 4 | 1.263 | 55093.4 |
293 | 2021-10-10 10:18:03 | recepts | 1 | 69583 | 4 | 1.283 | 54234.6 |
292 | 2021-09-22 03:07:46 | recepts | 1 | 69583 | 4 | 1.233 | 56433.9 |
291 | 2021-09-21 15:28:32 | recepts | 1 | 69583 | 4 | 1.110 | 62687.4 |
290 | 2021-09-14 18:58:04 | recepts | 1 | 69583 | 4 | 1.220 | 57035.2 |
289 | 2021-09-12 15:58:06 | recepts | 1 | 69583 | 4 | 1.096 | 63488.1 |
288 | 2021-07-05 10:56:37 | recepts | 3 | 134027 | 395 | 5.966 | 22465.1 |
287 | 2021-06-30 15:35:26 | recepts | 2 | 107671 | 48 | 3.063 | 35152.1 |
286 | 2021-06-12 11:53:43 | recepts | 1 | 69583 | 4 | 1.280 | 54361.7 |
285 | 2021-06-12 11:17:31 | recepts | 1 | 69583 | 4 | 1.110 | 62687.4 |
284 | 2021-04-22 11:50:15 | recepts | 1 | 69583 | 4 | 1.283 | 54234.6 |
283 | 2021-04-12 08:56:18 | recepts | 2 | 107671 | 48 | 3.453 | 31181.9 |
282 | 2021-03-22 00:44:11 | recepts | 1 | 69583 | 4 | 1.140 | 61037.7 |
281 | 2021-03-06 04:28:37 | recepts | 1 | 69583 | 4 | 1.250 | 55666.4 |
280 | 2021-02-27 02:05:28 | recepts | 1 | 69583 | 4 | 1.266 | 54962.9 |
279 | 2021-01-31 15:00:07 | recepts | 1 | 69583 | 4 | 1.093 | 63662.4 |
278 | 2021-01-26 07:14:14 | recepts | 2 | 107671 | 48 | 3.186 | 33795.0 |
277 | 2021-01-03 20:17:24 | recepts | 1 | 69583 | 4 | 1.233 | 56433.9 |