History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prawns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
406 | 2024-04-30 08:22:06 | prawns | 1 | 48755 | 4 | 0.936 | 52088.7 |
405 | 2024-04-05 17:28:17 | prawns | 3 | 112716 | 807 | 20.753 | 5431.3 |
404 | 2024-04-05 16:49:24 | prawns | 3 | 112716 | 807 | 6.283 | 17939.8 |
403 | 2024-04-05 16:49:23 | prawns | 2 | 82551 | 71 | 4.906 | 16826.5 |
402 | 2024-04-05 16:49:21 | prawns | 1 | 48755 | 4 | 1.826 | 26700.4 |
401 | 2024-03-29 06:47:07 | prawns | 1 | 48755 | 4 | 2.876 | 16952.4 |
400 | 2024-03-28 04:33:47 | prawns | 1 | 48755 | 4 | 0.780 | 62506.4 |
399 | 2024-03-06 11:55:32 | prawns | 3 | 112716 | 807 | 8.780 | 12837.8 |
398 | 2024-03-06 11:55:30 | prawns | 2 | 82551 | 71 | 7.096 | 11633.5 |
397 | 2024-03-06 11:54:48 | prawns | 1 | 48755 | 4 | 1.860 | 26212.4 |
396 | 2024-03-04 14:30:28 | prawns | 3 | 112716 | 807 | 11.280 | 9992.6 |
395 | 2024-03-04 08:23:59 | prawns | 3 | 112716 | 807 | 20.453 | 5511.0 |
394 | 2024-03-04 08:23:58 | prawns | 2 | 82551 | 71 | 5.656 | 14595.3 |
393 | 2024-03-04 01:10:01 | prawns | 3 | 112716 | 807 | 9.983 | 11290.8 |
392 | 2024-03-04 01:10:05 | prawns | 2 | 82551 | 71 | 6.033 | 13683.2 |
391 | 2024-03-04 01:09:50 | prawns | 1 | 48755 | 4 | 0.860 | 56691.9 |
390 | 2024-01-27 15:52:35 | prawns | 1 | 48755 | 4 | 1.826 | 26700.4 |
389 | 2024-01-25 22:10:29 | prawns | 1 | 48755 | 4 | 0.860 | 56691.9 |
388 | 2024-01-18 14:29:02 | prawns | 2 | 82551 | 71 | 2.280 | 36206.6 |
387 | 2024-01-06 19:47:34 | prawns | 2 | 82551 | 71 | 2.843 | 29036.6 |
386 | 2023-12-08 12:16:37 | prawns | 1 | 48755 | 4 | 0.843 | 57835.1 |
385 | 2023-12-08 12:16:36 | prawns | 1 | 48755 | 4 | 0.843 | 57835.1 |
384 | 2023-11-26 01:33:05 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
383 | 2023-11-22 07:52:06 | prawns | 1 | 48755 | 4 | 0.826 | 59025.4 |
382 | 2023-11-20 21:58:01 | prawns | 1 | 48755 | 4 | 0.830 | 58741.0 |
381 | 2023-11-19 01:47:10 | prawns | 1 | 48755 | 4 | 0.780 | 62506.4 |
380 | 2023-10-31 22:29:11 | prawns | 1 | 48755 | 4 | 0.733 | 66514.3 |
379 | 2023-10-31 04:05:35 | prawns | 2 | 82551 | 71 | 2.170 | 38041.9 |
378 | 2023-10-25 13:27:38 | prawns | 1 | 48755 | 4 | 0.843 | 57835.1 |
377 | 2023-10-15 01:49:40 | prawns | 1 | 48755 | 4 | 0.860 | 56691.9 |
376 | 2023-10-03 16:14:59 | prawns | 1 | 48755 | 4 | 0.736 | 66243.2 |
375 | 2023-09-26 12:47:12 | prawns | 1 | 48755 | 4 | 0.736 | 66243.2 |
374 | 2023-09-22 17:16:03 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
373 | 2023-09-19 18:08:10 | prawns | 1 | 48755 | 4 | 0.860 | 56691.9 |
372 | 2023-09-08 11:10:09 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
371 | 2023-08-07 07:18:41 | prawns | 2 | 82551 | 71 | 2.156 | 38289.0 |
370 | 2023-06-11 18:36:56 | prawns | 1 | 48755 | 4 | 0.736 | 66243.2 |
369 | 2023-05-13 11:30:07 | prawns | 1 | 48755 | 4 | 0.766 | 63648.8 |
368 | 2023-04-19 10:02:49 | prawns | 2 | 82551 | 71 | 2.250 | 36689.3 |
367 | 2023-03-31 01:53:20 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
366 | 2023-01-22 00:19:39 | prawns | 2 | 82551 | 71 | 2.376 | 34743.7 |
365 | 2023-01-13 12:50:25 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
364 | 2023-01-09 01:26:14 | prawns | 1 | 48755 | 4 | 0.733 | 66514.3 |
363 | 2022-11-03 07:32:23 | prawns | 2 | 82551 | 71 | 2.156 | 38289.0 |
362 | 2022-10-23 14:32:46 | prawns | 1 | 48755 | 4 | 0.733 | 66514.3 |
361 | 2022-09-04 00:07:43 | prawns | 1 | 48755 | 4 | 0.813 | 59969.2 |
360 | 2022-08-31 16:20:47 | prawns | 1 | 48755 | 4 | 0.783 | 62266.9 |
359 | 2022-08-28 13:18:46 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
358 | 2022-07-19 01:42:45 | prawns | 1 | 48755 | 4 | 0.783 | 62266.9 |
357 | 2022-06-13 17:54:15 | prawns | 1 | 48755 | 4 | 0.780 | 62506.4 |
356 | 2022-06-13 15:16:01 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
355 | 2022-05-11 00:09:04 | prawns | 2 | 82551 | 71 | 2.530 | 32628.9 |
354 | 2022-04-27 22:55:10 | prawns | 1 | 48755 | 4 | 0.846 | 57630.0 |
353 | 2022-02-16 22:08:53 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
352 | 2022-02-14 17:50:15 | prawns | 1 | 48755 | 4 | 1.846 | 26411.2 |
351 | 2022-01-08 09:53:11 | prawns | 2 | 82551 | 71 | 2.500 | 33020.4 |
350 | 2022-01-04 15:40:53 | prawns | 1 | 48755 | 4 | 0.906 | 53813.5 |
349 | 2021-12-02 00:54:05 | prawns | 1 | 48755 | 4 | 0.860 | 56691.9 |
348 | 2021-11-29 22:33:21 | prawns | 1 | 48755 | 4 | 0.876 | 55656.4 |
347 | 2021-11-12 19:41:58 | prawns | 1 | 48755 | 4 | 0.876 | 55656.4 |
346 | 2021-10-25 22:00:28 | prawns | 1 | 48755 | 4 | 0.890 | 54780.9 |
345 | 2021-10-25 20:41:47 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
344 | 2021-10-24 22:08:52 | prawns | 1 | 48755 | 4 | 0.953 | 51159.5 |
343 | 2021-10-23 19:01:52 | prawns | 1 | 48755 | 4 | 0.843 | 57835.1 |
342 | 2021-09-27 19:02:42 | prawns | 1 | 48755 | 4 | 0.860 | 56691.9 |
341 | 2021-09-26 14:27:50 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
340 | 2021-09-21 22:45:15 | prawns | 1 | 48755 | 4 | 0.763 | 63899.1 |
339 | 2021-09-18 23:38:32 | prawns | 1 | 48755 | 4 | 0.843 | 57835.1 |
338 | 2021-08-10 16:41:48 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
337 | 2021-07-24 07:34:57 | prawns | 2 | 82551 | 71 | 2.126 | 38829.3 |
336 | 2021-06-15 20:44:57 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
335 | 2021-06-03 00:05:31 | prawns | 1 | 48755 | 4 | 1.080 | 45143.5 |
334 | 2021-05-14 07:41:18 | prawns | 2 | 82551 | 71 | 2.470 | 33421.5 |
333 | 2021-05-08 19:05:48 | prawns | 1 | 48755 | 4 | 0.813 | 59969.2 |
332 | 2021-05-08 04:33:51 | prawns | 1 | 48755 | 4 | 0.860 | 56691.9 |
331 | 2021-04-09 20:07:11 | prawns | 3 | 112716 | 807 | 6.030 | 18692.5 |
330 | 2021-03-16 11:18:14 | prawns | 1 | 48755 | 4 | 0.846 | 57630.0 |
329 | 2021-03-11 11:30:01 | prawns | 1 | 48755 | 4 | 0.843 | 57835.1 |
328 | 2021-02-20 01:54:54 | prawns | 2 | 82551 | 71 | 2.216 | 37252.3 |
327 | 2021-01-24 09:44:06 | prawns | 3 | 112716 | 807 | 4.796 | 23502.1 |
326 | 2021-01-22 08:30:24 | prawns | 1 | 48755 | 4 | 0.876 | 55656.4 |
325 | 2020-12-09 18:15:46 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
324 | 2020-11-09 11:21:04 | prawns | 1 | 48755 | 4 | 0.890 | 54780.9 |
323 | 2020-11-04 13:57:16 | prawns | 3 | 112716 | 807 | 5.093 | 22131.6 |
322 | 2020-10-07 05:59:53 | prawns | 1 | 48755 | 4 | 1.500 | 32503.3 |
321 | 2020-08-21 06:51:03 | prawns | 1 | 48755 | 4 | 0.783 | 62266.9 |
320 | 2020-08-02 00:44:31 | prawns | 1 | 48755 | 4 | 0.783 | 62266.9 |
319 | 2020-07-31 16:27:36 | prawns | 1 | 48755 | 4 | 0.796 | 61250.0 |
318 | 2020-07-29 13:27:53 | prawns | 1 | 48755 | 4 | 0.830 | 58741.0 |
317 | 2020-06-01 14:40:20 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
316 | 2020-05-10 18:21:12 | prawns | 1 | 48755 | 4 | 0.763 | 63899.1 |
315 | 2020-05-02 11:50:00 | prawns | 1 | 48755 | 4 | 0.876 | 55656.4 |
314 | 2020-04-22 08:04:18 | prawns | 1 | 48755 | 4 | 0.750 | 65006.7 |
313 | 2020-04-18 09:00:23 | prawns | 1 | 48755 | 4 | 0.766 | 63648.8 |
312 | 2020-04-17 09:46:33 | prawns | 1 | 48755 | 4 | 0.763 | 63899.1 |
311 | 2020-04-16 09:43:25 | prawns | 1 | 48755 | 4 | 0.873 | 55847.7 |
310 | 2020-04-15 09:05:16 | prawns | 1 | 48755 | 4 | 0.763 | 63899.1 |
309 | 2020-03-27 21:10:03 | prawns | 1 | 48755 | 4 | 0.923 | 52822.3 |
308 | 2020-03-26 10:26:44 | prawns | 1 | 48755 | 4 | 0.876 | 55656.4 |
307 | 2020-03-26 04:23:35 | prawns | 1 | 48755 | 4 | 1.810 | 26936.5 |