History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"patten"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
465 | 2024-05-04 23:33:57 | patten | 2 | 82551 | 112 | 3.060 | 26977.5 |
464 | 2024-05-04 17:31:40 | patten | 2 | 82551 | 112 | 2.953 | 27955.0 |
463 | 2024-05-04 17:31:35 | patten | 1 | 48755 | 11 | 1.013 | 48129.3 |
462 | 2024-05-04 17:31:27 | patten | 1 | 48755 | 11 | 0.843 | 57835.1 |
461 | 2024-05-04 17:31:23 | patten | 2 | 82551 | 112 | 2.376 | 34743.7 |
460 | 2024-04-30 06:57:37 | patten | 1 | 48755 | 11 | 0.983 | 49598.2 |
459 | 2024-04-28 01:05:03 | patten | 1 | 48755 | 11 | 2.033 | 23981.8 |
458 | 2024-04-27 23:52:32 | patten | 1 | 48755 | 11 | 3.050 | 15985.2 |
457 | 2024-04-17 12:27:18 | patten | 1 | 48755 | 11 | 0.813 | 59969.2 |
456 | 2024-04-16 03:33:24 | patten | 1 | 48755 | 11 | 1.546 | 31536.2 |
455 | 2024-04-03 07:59:20 | patten | 1 | 48755 | 11 | 2.123 | 22965.1 |
454 | 2024-03-31 16:22:39 | patten | 2 | 82551 | 112 | 8.126 | 10158.9 |
453 | 2024-03-31 16:22:27 | patten | 1 | 48755 | 11 | 1.000 | 48755.0 |
452 | 2024-02-28 07:35:12 | patten | 2 | 82551 | 112 | 3.376 | 24452.3 |
451 | 2024-02-27 09:51:11 | patten | 2 | 82551 | 112 | 2.640 | 31269.3 |
450 | 2024-02-27 09:51:08 | patten | 1 | 48755 | 11 | 0.923 | 52822.3 |
449 | 2024-02-26 01:48:04 | patten | 1 | 48755 | 11 | 1.000 | 48755.0 |
448 | 2024-02-19 13:40:38 | patten | 1 | 48755 | 11 | 0.906 | 53813.5 |
447 | 2024-01-01 06:45:45 | patten | 1 | 48755 | 11 | 0.843 | 57835.1 |
446 | 2023-12-09 23:43:34 | patten | 2 | 82551 | 112 | 2.330 | 35429.6 |
445 | 2023-11-30 09:30:58 | patten | 2 | 82551 | 112 | 2.330 | 35429.6 |
444 | 2023-11-20 10:44:20 | patten | 2 | 82551 | 112 | 2.250 | 36689.3 |
443 | 2023-11-14 05:47:44 | patten | 1 | 48755 | 11 | 0.750 | 65006.7 |
442 | 2023-11-11 07:33:31 | patten | 1 | 48755 | 11 | 0.766 | 63648.8 |
441 | 2023-11-09 00:34:37 | patten | 1 | 48755 | 11 | 0.750 | 65006.7 |
440 | 2023-11-06 21:01:06 | patten | 1 | 48755 | 11 | 0.750 | 65006.7 |
439 | 2023-11-06 19:10:44 | patten | 1 | 48755 | 11 | 0.826 | 59025.4 |
438 | 2023-10-30 12:50:55 | patten | 2 | 82551 | 112 | 2.686 | 30733.8 |
437 | 2023-10-27 16:56:37 | patten | 1 | 48755 | 11 | 0.890 | 54780.9 |
436 | 2023-10-21 21:44:12 | patten | 1 | 48755 | 11 | 0.906 | 53813.5 |
435 | 2023-10-20 19:29:13 | patten | 1 | 48755 | 11 | 0.763 | 63899.1 |
434 | 2023-10-18 00:01:32 | patten | 1 | 48755 | 11 | 0.920 | 52994.6 |
433 | 2023-10-11 19:14:55 | patten | 1 | 48755 | 11 | 0.813 | 59969.2 |
432 | 2023-10-04 12:42:25 | patten | 1 | 48755 | 11 | 0.843 | 57835.1 |
431 | 2023-09-25 21:33:17 | patten | 1 | 48755 | 11 | 0.906 | 53813.5 |
430 | 2023-09-20 21:29:27 | patten | 1 | 48755 | 11 | 0.750 | 65006.7 |
429 | 2023-08-17 09:41:41 | patten | 1 | 48755 | 11 | 0.890 | 54780.9 |
428 | 2023-08-11 18:23:21 | patten | 1 | 48755 | 11 | 0.843 | 57835.1 |
427 | 2023-05-17 18:11:02 | patten | 1 | 48755 | 11 | 0.766 | 63648.8 |
426 | 2023-05-08 01:29:11 | patten | 1 | 48755 | 11 | 1.203 | 40527.8 |
425 | 2023-03-11 00:43:05 | patten | 1 | 48755 | 11 | 0.750 | 65006.7 |
424 | 2023-02-01 17:12:28 | patten | 1 | 48755 | 11 | 0.783 | 62266.9 |
423 | 2022-12-31 21:58:54 | patten | 1 | 48755 | 11 | 0.750 | 65006.7 |
422 | 2022-10-18 19:14:03 | patten | 1 | 48755 | 11 | 0.766 | 63648.8 |
421 | 2022-09-22 01:47:32 | patten | 1 | 48755 | 11 | 0.810 | 60191.4 |
420 | 2022-08-23 13:03:16 | patten | 1 | 48755 | 11 | 0.783 | 62266.9 |
419 | 2022-07-29 10:23:18 | patten | 1 | 48755 | 11 | 0.750 | 65006.7 |
418 | 2022-07-02 11:10:35 | patten | 1 | 48755 | 11 | 0.906 | 53813.5 |
417 | 2022-05-04 15:17:38 | patten | 1 | 48755 | 11 | 0.876 | 55656.4 |
416 | 2022-03-18 20:10:38 | patten | 1 | 48755 | 11 | 0.766 | 63648.8 |
415 | 2022-01-21 12:09:58 | patten | 1 | 48755 | 11 | 0.906 | 53813.5 |
414 | 2021-12-21 16:48:50 | patten | 1 | 48755 | 11 | 0.923 | 52822.3 |
413 | 2021-12-16 19:13:31 | patten | 1 | 48755 | 11 | 0.923 | 52822.3 |
412 | 2021-12-11 14:21:42 | patten | 1 | 48755 | 11 | 0.906 | 53813.5 |
411 | 2021-11-26 03:23:35 | patten | 1 | 48755 | 11 | 0.783 | 62266.9 |
410 | 2021-11-15 00:19:36 | patten | 1 | 48755 | 11 | 0.890 | 54780.9 |
409 | 2021-11-12 23:01:42 | patten | 1 | 48755 | 11 | 0.940 | 51867.0 |
408 | 2021-11-02 08:01:18 | patten | 1 | 48755 | 11 | 0.873 | 55847.7 |
407 | 2021-10-30 13:56:04 | patten | 1 | 48755 | 11 | 0.813 | 59969.2 |
406 | 2021-09-26 11:06:16 | patten | 1 | 48755 | 11 | 0.876 | 55656.4 |
405 | 2021-09-24 05:33:24 | patten | 1 | 48755 | 11 | 0.890 | 54780.9 |
404 | 2021-09-13 21:17:41 | patten | 1 | 48755 | 11 | 0.843 | 57835.1 |
403 | 2021-09-07 12:41:15 | patten | 1 | 48755 | 11 | 0.843 | 57835.1 |
402 | 2021-09-07 00:01:43 | patten | 1 | 48755 | 11 | 0.830 | 58741.0 |
401 | 2021-06-06 15:01:49 | patten | 1 | 48755 | 11 | 0.873 | 55847.7 |
400 | 2021-06-03 10:46:16 | patten | 1 | 48755 | 11 | 0.783 | 62266.9 |
399 | 2021-03-01 00:06:55 | patten | 1 | 48755 | 11 | 0.783 | 62266.9 |
398 | 2021-01-29 17:05:12 | patten | 1 | 48755 | 11 | 0.766 | 63648.8 |
397 | 2020-11-29 06:16:32 | patten | 1 | 48755 | 11 | 0.766 | 63648.8 |
396 | 2020-11-25 01:04:23 | patten | 1 | 48755 | 11 | 0.780 | 62506.4 |
395 | 2020-10-30 13:51:09 | patten | 1 | 48755 | 11 | 1.686 | 28917.6 |
394 | 2020-10-28 01:19:20 | patten | 1 | 48755 | 11 | 0.826 | 59025.4 |
393 | 2020-10-14 22:20:07 | patten | 1 | 48755 | 11 | 0.783 | 62266.9 |
392 | 2020-09-03 10:28:26 | patten | 1 | 48755 | 11 | 0.983 | 49598.2 |
391 | 2020-09-02 03:14:29 | patten | 1 | 48755 | 11 | 0.860 | 56691.9 |
390 | 2020-08-31 10:12:05 | patten | 1 | 48755 | 11 | 0.873 | 55847.7 |
389 | 2020-08-29 02:13:32 | patten | 1 | 48755 | 11 | 0.780 | 62506.4 |
388 | 2020-08-28 05:01:57 | patten | 1 | 48755 | 11 | 0.800 | 60943.8 |
387 | 2020-08-25 21:35:44 | patten | 1 | 48755 | 11 | 0.780 | 62506.4 |
386 | 2020-08-24 04:17:13 | patten | 1 | 48755 | 11 | 0.876 | 55656.4 |
385 | 2020-07-28 02:43:13 | patten | 1 | 48755 | 11 | 0.796 | 61250.0 |
384 | 2020-07-25 14:35:27 | patten | 1 | 48755 | 11 | 0.796 | 61250.0 |
383 | 2020-07-23 05:40:18 | patten | 1 | 48755 | 11 | 0.890 | 54780.9 |
382 | 2020-06-19 03:03:55 | patten | 1 | 48755 | 11 | 0.783 | 62266.9 |
381 | 2020-06-04 06:55:17 | patten | 1 | 48755 | 11 | 0.860 | 56691.9 |
380 | 2020-05-24 11:59:31 | patten | 1 | 48755 | 11 | 0.860 | 56691.9 |
379 | 2020-04-06 07:02:49 | patten | 1 | 48755 | 11 | 0.906 | 53813.5 |
378 | 2020-03-27 00:30:57 | patten | 1 | 48755 | 11 | 0.843 | 57835.1 |
377 | 2020-03-26 22:18:25 | patten | 1 | 48755 | 11 | 1.156 | 42175.6 |
376 | 2020-03-25 14:20:14 | patten | 1 | 48755 | 11 | 0.860 | 56691.9 |
375 | 2020-03-23 01:57:51 | patten | 1 | 48755 | 11 | 0.843 | 57835.1 |
374 | 2020-03-21 21:01:44 | patten | 1 | 48755 | 11 | 0.780 | 62506.4 |
373 | 2020-03-18 18:52:22 | patten | 1 | 48755 | 11 | 0.813 | 59969.2 |
372 | 2020-03-05 21:25:49 | patten | 1 | 48755 | 11 | 0.906 | 53813.5 |
371 | 2020-02-23 22:45:06 | patten | 1 | 48755 | 11 | 1.893 | 25755.4 |
370 | 2020-02-21 10:49:28 | patten | 1 | 48755 | 11 | 0.840 | 58041.7 |
369 | 2020-02-21 06:20:33 | patten | 1 | 48755 | 11 | 0.830 | 58741.0 |
368 | 2020-02-19 09:54:01 | patten | 1 | 48755 | 11 | 1.876 | 25988.8 |
367 | 2020-02-02 04:45:41 | patten | 1 | 48755 | 11 | 1.843 | 26454.2 |
366 | 2020-02-02 04:29:22 | patten | 1 | 48755 | 11 | 1.236 | 39445.8 |