History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"plants"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
487 | 2024-03-03 23:15:03 | plants | 1 | 48755 | 12 | 1.453 | 33554.7 |
486 | 2024-02-28 10:32:15 | plants | 1 | 48755 | 12 | 2.563 | 19022.6 |
485 | 2024-01-27 02:58:40 | plants | 1 | 48755 | 12 | 0.843 | 57835.1 |
484 | 2024-01-16 15:56:56 | plants | 2 | 82551 | 134 | 2.220 | 37185.1 |
483 | 2024-01-11 11:44:50 | plants | 2 | 82551 | 134 | 2.170 | 38041.9 |
482 | 2024-01-09 05:37:05 | plants | 1 | 48755 | 12 | 0.736 | 66243.2 |
481 | 2024-01-07 05:14:18 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
480 | 2023-11-20 21:57:01 | plants | 1 | 48755 | 12 | 0.826 | 59025.4 |
479 | 2023-11-19 13:12:32 | plants | 1 | 48755 | 12 | 0.813 | 59969.2 |
478 | 2023-11-19 12:48:20 | plants | 1 | 48755 | 12 | 0.860 | 56691.9 |
477 | 2023-11-17 16:59:03 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
476 | 2023-11-03 00:42:40 | plants | 1 | 48755 | 12 | 0.733 | 66514.3 |
475 | 2023-11-02 08:00:54 | plants | 1 | 48755 | 12 | 0.843 | 57835.1 |
474 | 2023-10-29 22:31:46 | plants | 1 | 48755 | 12 | 0.810 | 60191.4 |
473 | 2023-10-26 13:47:19 | plants | 2 | 82551 | 134 | 2.483 | 33246.5 |
472 | 2023-10-25 17:37:09 | plants | 2 | 82551 | 134 | 2.123 | 38884.1 |
471 | 2023-10-23 10:41:39 | plants | 2 | 82551 | 134 | 3.263 | 25299.1 |
470 | 2023-10-11 07:10:28 | plants | 1 | 48755 | 12 | 0.860 | 56691.9 |
469 | 2023-10-05 18:29:09 | plants | 1 | 48755 | 12 | 0.766 | 63648.8 |
468 | 2023-09-26 19:27:35 | plants | 1 | 48755 | 12 | 0.826 | 59025.4 |
467 | 2023-09-13 13:08:22 | plants | 1 | 48755 | 12 | 0.843 | 57835.1 |
466 | 2023-09-13 05:29:08 | plants | 1 | 48755 | 12 | 0.830 | 58741.0 |
465 | 2023-09-09 21:36:46 | plants | 1 | 48755 | 12 | 0.783 | 62266.9 |
464 | 2023-09-05 16:54:27 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
463 | 2023-08-02 18:24:34 | plants | 2 | 82551 | 134 | 2.156 | 38289.0 |
462 | 2023-07-04 08:12:06 | plants | 1 | 48755 | 12 | 0.826 | 59025.4 |
461 | 2023-06-10 05:26:33 | plants | 1 | 48755 | 12 | 0.660 | 73871.2 |
460 | 2023-05-27 06:15:12 | plants | 1 | 48755 | 12 | 0.673 | 72444.3 |
459 | 2023-04-11 09:45:48 | plants | 2 | 82551 | 134 | 2.406 | 34310.5 |
458 | 2023-03-26 22:02:47 | plants | 1 | 48755 | 12 | 0.830 | 58741.0 |
457 | 2023-02-14 09:14:46 | plants | 1 | 48755 | 12 | 0.830 | 58741.0 |
456 | 2023-01-18 00:45:17 | plants | 2 | 82551 | 134 | 2.080 | 39688.0 |
455 | 2023-01-11 22:19:12 | plants | 1 | 48755 | 12 | 0.826 | 59025.4 |
454 | 2022-10-29 18:32:03 | plants | 2 | 82551 | 134 | 2.093 | 39441.5 |
453 | 2022-10-28 02:23:22 | plants | 1 | 48755 | 12 | 0.733 | 66514.3 |
452 | 2022-10-23 17:25:19 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
451 | 2022-07-14 12:15:15 | plants | 1 | 48755 | 12 | 0.830 | 58741.0 |
450 | 2022-06-13 06:54:04 | plants | 1 | 48755 | 12 | 0.826 | 59025.4 |
449 | 2022-05-25 16:51:33 | plants | 2 | 82551 | 134 | 2.580 | 31996.5 |
448 | 2022-03-20 22:12:10 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
447 | 2022-03-17 11:37:40 | plants | 1 | 48755 | 12 | 1.016 | 47987.2 |
446 | 2022-02-23 01:02:16 | plants | 1 | 48755 | 12 | 0.766 | 63648.8 |
445 | 2022-02-20 22:09:26 | plants | 1 | 48755 | 12 | 0.783 | 62266.9 |
444 | 2022-02-18 16:44:35 | plants | 1 | 48755 | 12 | 0.873 | 55847.7 |
443 | 2022-02-12 19:24:54 | plants | 1 | 48755 | 12 | 0.860 | 56691.9 |
442 | 2021-12-07 22:19:33 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
441 | 2021-12-07 00:40:57 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
440 | 2021-12-05 21:19:06 | plants | 1 | 48755 | 12 | 0.830 | 58741.0 |
439 | 2021-12-03 18:03:38 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
438 | 2021-10-11 04:16:11 | plants | 1 | 48755 | 12 | 0.876 | 55656.4 |
437 | 2021-09-22 06:45:05 | plants | 2 | 82551 | 134 | 2.296 | 35954.3 |
436 | 2021-09-15 02:34:56 | plants | 2 | 82551 | 134 | 3.750 | 22013.6 |
435 | 2021-09-07 02:45:38 | plants | 1 | 48755 | 12 | 0.733 | 66514.3 |
434 | 2021-08-30 15:56:13 | plants | 1 | 48755 | 12 | 0.860 | 56691.9 |
433 | 2021-08-20 11:41:06 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
432 | 2021-05-29 23:09:35 | plants | 1 | 48755 | 12 | 0.920 | 52994.6 |
431 | 2021-02-27 07:31:10 | plants | 1 | 48755 | 12 | 0.766 | 63648.8 |
430 | 2021-01-28 11:30:51 | plants | 1 | 48755 | 12 | 0.766 | 63648.8 |
429 | 2020-11-27 09:48:54 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
428 | 2020-11-02 09:34:32 | plants | 1 | 48755 | 12 | 0.873 | 55847.7 |
427 | 2020-11-01 11:19:24 | plants | 1 | 48755 | 12 | 0.796 | 61250.0 |
426 | 2020-10-18 10:14:41 | plants | 1 | 48755 | 12 | 1.670 | 29194.6 |
425 | 2020-10-17 17:52:39 | plants | 1 | 48755 | 12 | 0.846 | 57630.0 |
424 | 2020-10-16 09:08:52 | plants | 1 | 48755 | 12 | 0.763 | 63899.1 |
423 | 2020-10-14 11:47:14 | plants | 1 | 48755 | 12 | 0.766 | 63648.8 |
422 | 2020-10-03 16:18:45 | plants | 1 | 48755 | 12 | 0.796 | 61250.0 |
421 | 2020-09-07 10:52:07 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
420 | 2020-08-27 19:14:54 | plants | 1 | 48755 | 12 | 1.470 | 33166.7 |
419 | 2020-08-20 18:21:04 | plants | 1 | 48755 | 12 | 0.763 | 63899.1 |
418 | 2020-07-28 21:51:17 | plants | 1 | 48755 | 12 | 0.920 | 52994.6 |
417 | 2020-07-18 03:27:54 | plants | 1 | 48755 | 12 | 1.546 | 31536.2 |
416 | 2020-07-17 03:37:47 | plants | 1 | 48755 | 12 | 0.796 | 61250.0 |
415 | 2020-06-11 06:26:53 | plants | 1 | 48755 | 12 | 0.856 | 56956.8 |
414 | 2020-05-26 06:33:45 | plants | 1 | 48755 | 12 | 0.856 | 56956.8 |
413 | 2020-03-25 15:16:48 | plants | 1 | 48755 | 12 | 1.656 | 29441.4 |
412 | 2020-03-25 12:54:51 | plants | 1 | 48755 | 12 | 1.656 | 29441.4 |
411 | 2020-03-25 10:23:23 | plants | 1 | 48755 | 12 | 0.860 | 56691.9 |
410 | 2020-03-23 23:03:15 | plants | 1 | 48755 | 12 | 0.843 | 57835.1 |
409 | 2020-03-22 20:36:24 | plants | 1 | 48755 | 12 | 0.923 | 52822.3 |
408 | 2020-03-21 18:48:01 | plants | 1 | 48755 | 12 | 0.970 | 50262.9 |
407 | 2020-03-18 00:31:26 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
406 | 2020-02-27 10:44:05 | plants | 1 | 48755 | 12 | 0.983 | 49598.2 |
405 | 2020-02-26 15:26:27 | plants | 1 | 48755 | 12 | 0.923 | 52822.3 |
404 | 2020-02-25 13:39:51 | plants | 1 | 48755 | 12 | 1.923 | 25353.6 |
403 | 2020-02-24 08:03:29 | plants | 1 | 48755 | 12 | 0.860 | 56691.9 |
402 | 2020-02-23 01:05:37 | plants | 1 | 48755 | 12 | 0.873 | 55847.7 |
401 | 2020-02-21 15:07:53 | plants | 1 | 48755 | 12 | 1.703 | 28628.9 |
400 | 2020-02-12 23:36:16 | plants | 1 | 48755 | 12 | 0.843 | 57835.1 |
399 | 2020-02-08 23:39:09 | plants | 1 | 48755 | 12 | 0.970 | 50262.9 |
398 | 2020-02-01 07:40:17 | plants | 1 | 48755 | 12 | 1.046 | 46610.9 |
397 | 2020-01-30 02:43:13 | plants | 1 | 48755 | 12 | 1.903 | 25620.1 |
396 | 2020-01-30 00:56:20 | plants | 1 | 48755 | 12 | 0.873 | 55847.7 |
395 | 2020-01-29 18:32:01 | plants | 1 | 48755 | 12 | 1.126 | 43299.3 |
394 | 2020-01-24 03:28:59 | plants | 1 | 48755 | 12 | 0.750 | 65006.7 |
393 | 2020-01-21 19:08:00 | plants | 1 | 48755 | 12 | 0.953 | 51159.5 |
392 | 2020-01-20 12:55:15 | plants | 1 | 48755 | 12 | 2.893 | 16852.7 |
391 | 2020-01-12 08:25:17 | plants | 1 | 48755 | 12 | 0.940 | 51867.0 |
390 | 2020-01-11 15:11:14 | plants | 1 | 48755 | 12 | 0.890 | 54780.9 |
389 | 2020-01-10 10:18:23 | plants | 1 | 48755 | 12 | 0.953 | 51159.5 |
388 | 2020-01-10 06:39:01 | plants | 1 | 48755 | 12 | 1.016 | 47987.2 |