History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nation"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
520 | 2024-04-25 11:59:02 | nation | 1 | 48755 | 9 | 1.703 | 28628.9 |
519 | 2024-04-10 23:29:32 | nation | 1 | 48755 | 9 | 1.106 | 44082.3 |
518 | 2024-04-10 14:24:35 | nation | 3 | 112716 | 639 | 11.720 | 9617.4 |
517 | 2024-04-03 00:29:42 | nation | 3 | 112716 | 639 | 19.436 | 5799.3 |
516 | 2024-04-02 18:47:17 | nation | 3 | 112716 | 639 | 7.013 | 16072.4 |
515 | 2024-04-01 12:40:42 | nation | 3 | 112716 | 639 | 19.406 | 5808.3 |
514 | 2024-04-01 05:10:17 | nation | 1 | 48755 | 9 | 1.796 | 27146.4 |
513 | 2024-04-01 05:10:16 | nation | 2 | 82551 | 74 | 3.406 | 24236.9 |
512 | 2024-04-01 05:09:49 | nation | 3 | 112716 | 639 | 6.126 | 18399.6 |
511 | 2024-03-31 16:19:10 | nation | 3 | 112716 | 639 | 18.703 | 6026.6 |
510 | 2024-03-31 16:19:10 | nation | 2 | 82551 | 74 | 6.233 | 13244.2 |
509 | 2024-03-31 16:17:54 | nation | 1 | 48755 | 9 | 0.966 | 50471.0 |
508 | 2024-02-29 13:01:08 | nation | 1 | 48755 | 9 | 0.843 | 57835.1 |
507 | 2024-01-29 16:16:35 | nation | 1 | 48755 | 9 | 0.906 | 53813.5 |
506 | 2024-01-15 07:42:45 | nation | 2 | 82551 | 74 | 2.186 | 37763.5 |
505 | 2024-01-11 16:01:38 | nation | 3 | 112716 | 639 | 5.846 | 19280.9 |
504 | 2023-12-26 11:15:37 | nation | 1 | 48755 | 9 | 0.736 | 66243.2 |
503 | 2023-12-25 00:39:38 | nation | 2 | 82551 | 74 | 2.890 | 28564.4 |
502 | 2023-12-12 07:58:53 | nation | 1 | 48755 | 9 | 0.763 | 63899.1 |
501 | 2023-12-10 03:00:00 | nation | 3 | 112716 | 639 | 5.673 | 19868.9 |
500 | 2023-11-20 10:09:51 | nation | 3 | 112716 | 639 | 5.016 | 22471.3 |
499 | 2023-11-20 10:09:49 | nation | 2 | 82551 | 74 | 2.360 | 34979.2 |
498 | 2023-11-17 02:01:12 | nation | 1 | 48755 | 9 | 0.766 | 63648.8 |
497 | 2023-11-13 01:57:28 | nation | 2 | 82551 | 74 | 2.156 | 38289.0 |
496 | 2023-11-12 01:05:36 | nation | 1 | 48755 | 9 | 0.826 | 59025.4 |
495 | 2023-11-09 00:33:42 | nation | 1 | 48755 | 9 | 0.843 | 57835.1 |
494 | 2023-11-01 06:08:44 | nation | 1 | 48755 | 9 | 0.890 | 54780.9 |
493 | 2023-10-28 21:13:00 | nation | 1 | 48755 | 9 | 0.876 | 55656.4 |
492 | 2023-10-26 17:19:46 | nation | 2 | 82551 | 74 | 2.530 | 32628.9 |
491 | 2023-10-25 17:16:22 | nation | 1 | 48755 | 9 | 0.860 | 56691.9 |
490 | 2023-10-14 11:39:15 | nation | 1 | 48755 | 9 | 0.826 | 59025.4 |
489 | 2023-10-11 15:38:14 | nation | 1 | 48755 | 9 | 0.796 | 61250.0 |
488 | 2023-10-04 15:06:57 | nation | 1 | 48755 | 9 | 0.813 | 59969.2 |
487 | 2023-09-24 00:03:59 | nation | 1 | 48755 | 9 | 0.810 | 60191.4 |
486 | 2023-09-13 14:56:11 | nation | 1 | 48755 | 9 | 0.750 | 65006.7 |
485 | 2023-09-10 21:43:42 | nation | 3 | 112716 | 639 | 6.330 | 17806.6 |
484 | 2023-09-09 07:59:06 | nation | 3 | 112716 | 639 | 4.860 | 23192.6 |
483 | 2023-08-09 19:20:49 | nation | 1 | 48755 | 9 | 0.750 | 65006.7 |
482 | 2023-08-04 17:34:51 | nation | 2 | 82551 | 74 | 2.266 | 36430.3 |
481 | 2023-07-12 14:47:58 | nation | 1 | 48755 | 9 | 0.736 | 66243.2 |
480 | 2023-06-16 07:17:59 | nation | 2 | 82551 | 74 | 2.406 | 34310.5 |
479 | 2023-06-16 06:48:17 | nation | 2 | 82551 | 74 | 2.190 | 37694.5 |
478 | 2023-05-09 07:57:00 | nation | 1 | 48755 | 9 | 0.736 | 66243.2 |
477 | 2023-04-16 08:27:03 | nation | 2 | 82551 | 74 | 2.156 | 38289.0 |
476 | 2023-04-05 01:26:50 | nation | 1 | 48755 | 9 | 0.750 | 65006.7 |
475 | 2023-03-13 11:32:26 | nation | 3 | 112716 | 639 | 4.766 | 23650.0 |
474 | 2023-03-04 08:47:11 | nation | 1 | 48755 | 9 | 0.733 | 66514.3 |
473 | 2023-03-04 07:48:25 | nation | 1 | 48755 | 9 | 0.830 | 58741.0 |
472 | 2023-01-21 21:11:52 | nation | 2 | 82551 | 74 | 2.453 | 33653.1 |
471 | 2022-12-29 23:53:31 | nation | 1 | 48755 | 9 | 0.720 | 67715.3 |
470 | 2022-12-27 03:27:19 | nation | 1 | 48755 | 9 | 0.733 | 66514.3 |
469 | 2022-12-16 07:40:05 | nation | 3 | 112716 | 639 | 5.656 | 19928.6 |
468 | 2022-11-03 02:12:50 | nation | 2 | 82551 | 74 | 2.156 | 38289.0 |
467 | 2022-09-18 15:20:53 | nation | 1 | 48755 | 9 | 0.763 | 63899.1 |
466 | 2022-09-17 18:02:19 | nation | 1 | 48755 | 9 | 0.733 | 66514.3 |
465 | 2022-09-17 14:38:05 | nation | 1 | 48755 | 9 | 0.733 | 66514.3 |
464 | 2022-09-12 19:23:16 | nation | 1 | 48755 | 9 | 0.733 | 66514.3 |
463 | 2022-08-26 21:31:24 | nation | 3 | 112716 | 639 | 5.313 | 21215.1 |
462 | 2022-08-25 18:40:20 | nation | 3 | 112716 | 639 | 5.873 | 19192.2 |
461 | 2022-08-14 04:24:44 | nation | 1 | 48755 | 9 | 1.766 | 27607.6 |
460 | 2022-08-07 03:55:51 | nation | 3 | 112716 | 639 | 5.436 | 20735.1 |
459 | 2022-08-07 03:22:29 | nation | 1 | 48755 | 9 | 0.890 | 54780.9 |
458 | 2022-08-06 06:04:35 | nation | 1 | 48755 | 9 | 0.843 | 57835.1 |
457 | 2022-07-30 04:09:04 | nation | 1 | 48755 | 9 | 0.766 | 63648.8 |
456 | 2022-07-18 15:24:08 | nation | 3 | 112716 | 639 | 5.110 | 22057.9 |
455 | 2022-07-10 04:58:00 | nation | 1 | 48755 | 9 | 0.826 | 59025.4 |
454 | 2022-07-06 11:13:30 | nation | 3 | 112716 | 639 | 4.796 | 23502.1 |
453 | 2022-07-03 11:19:12 | nation | 1 | 48755 | 9 | 0.750 | 65006.7 |
452 | 2022-07-02 16:24:28 | nation | 1 | 48755 | 9 | 0.766 | 63648.8 |
451 | 2022-07-01 01:37:47 | nation | 1 | 48755 | 9 | 0.750 | 65006.7 |
450 | 2022-06-28 20:34:28 | nation | 1 | 48755 | 9 | 0.736 | 66243.2 |
449 | 2022-06-16 11:18:48 | nation | 1 | 48755 | 9 | 0.736 | 66243.2 |
448 | 2022-06-15 17:10:57 | nation | 1 | 48755 | 9 | 0.953 | 51159.5 |
447 | 2022-06-05 08:51:36 | nation | 2 | 82551 | 74 | 2.140 | 38575.2 |
446 | 2022-05-27 19:00:01 | nation | 1 | 48755 | 9 | 0.783 | 62266.9 |
445 | 2022-05-18 16:11:25 | nation | 3 | 112716 | 639 | 5.373 | 20978.2 |
444 | 2022-05-16 06:55:35 | nation | 1 | 48755 | 9 | 0.826 | 59025.4 |
443 | 2022-04-29 12:36:32 | nation | 3 | 112716 | 639 | 5.576 | 20214.5 |
442 | 2022-04-20 14:02:44 | nation | 3 | 112716 | 639 | 6.126 | 18399.6 |
441 | 2022-03-10 12:59:25 | nation | 3 | 112716 | 639 | 6.250 | 18034.6 |
440 | 2022-03-08 09:14:34 | nation | 3 | 112716 | 639 | 7.203 | 15648.5 |
439 | 2022-03-01 16:09:14 | nation | 1 | 48755 | 9 | 1.093 | 44606.6 |
438 | 2022-02-27 11:40:01 | nation | 1 | 48755 | 9 | 0.796 | 61250.0 |
437 | 2022-02-12 21:51:44 | nation | 1 | 48755 | 9 | 0.953 | 51159.5 |
436 | 2021-12-14 09:10:29 | nation | 1 | 48755 | 9 | 0.873 | 55847.7 |
435 | 2021-12-02 02:23:47 | nation | 3 | 112716 | 639 | 5.360 | 21029.1 |
434 | 2021-11-05 02:30:09 | nation | 1 | 48755 | 9 | 0.763 | 63899.1 |
433 | 2021-10-19 13:02:42 | nation | 1 | 48755 | 9 | 0.750 | 65006.7 |
432 | 2021-09-27 09:17:22 | nation | 1 | 48755 | 9 | 0.826 | 59025.4 |
431 | 2021-09-26 16:30:59 | nation | 1 | 48755 | 9 | 0.936 | 52088.7 |
430 | 2021-09-22 13:15:47 | nation | 1 | 48755 | 9 | 0.813 | 59969.2 |
429 | 2021-09-09 09:27:16 | nation | 1 | 48755 | 9 | 0.750 | 65006.7 |
428 | 2021-09-07 05:35:07 | nation | 1 | 48755 | 9 | 0.920 | 52994.6 |
427 | 2021-08-11 04:51:49 | nation | 2 | 82551 | 74 | 2.153 | 38342.3 |
426 | 2021-08-01 20:48:38 | nation | 1 | 48755 | 9 | 0.813 | 59969.2 |
425 | 2021-07-22 07:52:44 | nation | 2 | 82551 | 74 | 4.626 | 17845.0 |
424 | 2021-06-13 18:11:14 | nation | 1 | 48755 | 9 | 0.843 | 57835.1 |
423 | 2021-05-06 20:22:28 | nation | 1 | 48755 | 9 | 0.923 | 52822.3 |
422 | 2021-04-27 10:57:56 | nation | 1 | 48755 | 9 | 0.763 | 63899.1 |
421 | 2021-04-21 04:20:19 | nation | 1 | 48755 | 9 | 0.750 | 65006.7 |