History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"suborders"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
525 | 2024-06-02 08:18:17 | suborders | 2 | 121436 | 7 | 5.203 | 23339.6 |
524 | 2024-05-31 21:39:27 | suborders | 1 | 81242 | 3 | 1.436 | 56575.2 |
523 | 2024-05-31 01:01:48 | suborders | 1 | 81242 | 3 | 1.250 | 64993.6 |
522 | 2024-05-27 20:31:42 | suborders | 4 | 165329 | 709 | 46.220 | 3577.0 |
521 | 2024-05-27 02:02:35 | suborders | 4 | 165329 | 709 | 37.343 | 4427.3 |
520 | 2024-05-25 17:07:55 | suborders | 4 | 165329 | 709 | 41.176 | 4015.2 |
519 | 2024-05-25 06:31:56 | suborders | 4 | 165329 | 709 | 43.066 | 3839.0 |
518 | 2024-05-25 01:17:01 | suborders | 4 | 165329 | 709 | 20.190 | 8188.7 |
517 | 2024-05-24 19:02:25 | suborders | 4 | 165329 | 709 | 33.843 | 4885.2 |
516 | 2024-05-24 18:02:08 | suborders | 4 | 165329 | 709 | 40.800 | 4052.2 |
515 | 2024-05-15 01:53:29 | suborders | 1 | 81242 | 3 | 4.190 | 19389.5 |
514 | 2024-05-12 22:41:37 | suborders | 1 | 81242 | 3 | 4.720 | 17212.3 |
513 | 2024-05-12 22:41:24 | suborders | 2 | 121436 | 7 | 4.170 | 29121.3 |
512 | 2024-05-12 13:53:52 | suborders | 2 | 121436 | 7 | 12.596 | 9640.8 |
511 | 2024-05-12 13:53:47 | suborders | 3 | 148641 | 72 | 12.533 | 11860.0 |
510 | 2024-05-12 02:06:01 | suborders | 3 | 148641 | 72 | 9.860 | 15075.2 |
509 | 2024-05-12 01:12:56 | suborders | 3 | 148641 | 72 | 17.733 | 8382.2 |
508 | 2024-05-12 01:12:55 | suborders | 2 | 121436 | 7 | 4.266 | 28466.0 |
507 | 2024-05-12 01:09:28 | suborders | 1 | 81242 | 3 | 2.436 | 33350.6 |
506 | 2024-04-27 20:33:40 | suborders | 1 | 81242 | 3 | 4.686 | 17337.2 |
505 | 2024-04-22 11:41:25 | suborders | 4 | 165329 | 709 | 40.296 | 4102.9 |
504 | 2024-04-21 14:36:05 | suborders | 4 | 165329 | 709 | 41.786 | 3956.6 |
503 | 2024-04-19 21:45:25 | suborders | 4 | 165329 | 709 | 35.986 | 4594.3 |
502 | 2024-04-19 19:02:41 | suborders | 4 | 165329 | 709 | 53.673 | 3080.3 |
501 | 2024-04-19 16:54:48 | suborders | 4 | 165329 | 709 | 47.876 | 3453.3 |
500 | 2024-04-19 14:53:15 | suborders | 4 | 165329 | 709 | 12.563 | 13160.0 |
499 | 2024-04-13 09:54:37 | suborders | 1 | 81242 | 3 | 1.470 | 55266.7 |
498 | 2024-04-10 20:12:36 | suborders | 1 | 81242 | 3 | 2.576 | 31538.0 |
497 | 2024-04-10 15:36:15 | suborders | 3 | 148641 | 72 | 17.720 | 8388.3 |
496 | 2024-04-10 15:36:12 | suborders | 2 | 121436 | 7 | 13.703 | 8862.0 |
495 | 2024-04-10 14:23:09 | suborders | 1 | 81242 | 3 | 1.513 | 53696.0 |
494 | 2024-04-10 01:14:19 | suborders | 3 | 148641 | 72 | 27.286 | 5447.5 |
493 | 2024-04-10 01:14:19 | suborders | 2 | 121436 | 7 | 9.983 | 12164.3 |
492 | 2024-04-10 01:02:16 | suborders | 1 | 81242 | 3 | 1.453 | 55913.3 |
491 | 2024-04-01 03:09:06 | suborders | 1 | 81242 | 3 | 3.000 | 27080.7 |
490 | 2024-03-30 07:18:21 | suborders | 1 | 81242 | 3 | 1.530 | 53099.3 |
489 | 2024-03-28 12:14:25 | suborders | 1 | 81242 | 3 | 1.593 | 50999.4 |
488 | 2024-03-28 10:05:33 | suborders | 4 | 165329 | 709 | 11.046 | 14967.3 |
487 | 2024-03-15 08:10:50 | suborders | 4 | 165329 | 709 | 26.236 | 6301.6 |
486 | 2024-03-14 21:17:03 | suborders | 4 | 165329 | 709 | 48.893 | 3381.4 |
485 | 2024-03-14 14:52:08 | suborders | 4 | 165329 | 709 | 39.033 | 4235.6 |
484 | 2024-03-13 20:17:10 | suborders | 4 | 165329 | 709 | 17.203 | 9610.5 |
483 | 2024-03-13 18:18:56 | suborders | 4 | 165329 | 709 | 39.083 | 4230.2 |
482 | 2024-03-13 18:19:03 | suborders | 3 | 148641 | 72 | 17.376 | 8554.4 |
481 | 2024-03-13 18:18:50 | suborders | 2 | 121436 | 7 | 12.873 | 9433.4 |
480 | 2024-03-13 17:06:12 | suborders | 1 | 81242 | 3 | 1.423 | 57092.1 |
479 | 2024-03-10 22:23:32 | suborders | 1 | 81242 | 3 | 1.530 | 53099.3 |
478 | 2024-03-06 00:27:42 | suborders | 1 | 81242 | 3 | 2.720 | 29868.4 |
477 | 2024-02-27 10:36:48 | suborders | 1 | 81242 | 3 | 1.563 | 51978.2 |
476 | 2024-02-12 14:42:51 | suborders | 1 | 81242 | 3 | 3.280 | 24768.9 |
475 | 2024-02-10 14:58:38 | suborders | 4 | 165329 | 709 | 15.363 | 10761.5 |
474 | 2024-01-30 09:10:42 | suborders | 1 | 81242 | 3 | 1.453 | 55913.3 |
473 | 2024-01-11 03:45:22 | suborders | 4 | 165329 | 709 | 10.500 | 15745.6 |
472 | 2024-01-07 23:05:05 | suborders | 2 | 121436 | 7 | 3.563 | 34082.5 |
471 | 2024-01-06 16:59:45 | suborders | 1 | 81242 | 3 | 1.343 | 60492.9 |
470 | 2023-12-22 16:31:14 | suborders | 1 | 81242 | 3 | 1.436 | 56575.2 |
469 | 2023-12-21 12:29:17 | suborders | 4 | 165329 | 709 | 12.623 | 13097.4 |
468 | 2023-12-20 21:39:42 | suborders | 1 | 81242 | 3 | 1.423 | 57092.1 |
467 | 2023-12-05 23:56:47 | suborders | 1 | 81242 | 3 | 1.513 | 53696.0 |
466 | 2023-11-05 20:24:56 | suborders | 1 | 81242 | 3 | 1.390 | 58447.5 |
465 | 2023-11-02 04:57:29 | suborders | 4 | 165329 | 709 | 10.186 | 16231.0 |
464 | 2023-10-30 10:20:12 | suborders | 4 | 165329 | 709 | 25.936 | 6374.5 |
463 | 2023-10-24 00:12:18 | suborders | 4 | 165329 | 709 | 22.423 | 7373.2 |
462 | 2023-10-19 23:51:54 | suborders | 4 | 165329 | 709 | 11.436 | 14456.9 |
461 | 2023-10-14 10:48:43 | suborders | 2 | 121436 | 7 | 3.923 | 30954.9 |
460 | 2023-10-10 09:46:26 | suborders | 1 | 81242 | 3 | 1.376 | 59042.2 |
459 | 2023-10-09 12:53:27 | suborders | 1 | 81242 | 3 | 1.410 | 57618.4 |
458 | 2023-08-21 21:57:39 | suborders | 4 | 165329 | 709 | 12.080 | 13686.2 |
457 | 2023-08-06 04:54:30 | suborders | 1 | 81242 | 3 | 1.423 | 57092.1 |
456 | 2023-08-05 13:21:43 | suborders | 4 | 165329 | 709 | 11.283 | 14652.9 |
455 | 2023-08-01 08:09:01 | suborders | 4 | 165329 | 709 | 11.703 | 14127.1 |
454 | 2023-07-29 10:12:00 | suborders | 4 | 165329 | 709 | 10.466 | 15796.8 |
453 | 2023-07-25 15:08:49 | suborders | 2 | 121436 | 7 | 3.563 | 34082.5 |
452 | 2023-05-04 21:37:12 | suborders | 1 | 81242 | 3 | 1.263 | 64324.6 |
451 | 2023-04-08 17:41:51 | suborders | 4 | 165329 | 709 | 10.110 | 16353.0 |
450 | 2023-04-04 15:02:28 | suborders | 2 | 121436 | 7 | 3.470 | 34996.0 |
449 | 2023-02-26 22:53:11 | suborders | 1 | 81242 | 3 | 1.233 | 65889.7 |
448 | 2023-01-23 15:36:25 | suborders | 4 | 165329 | 709 | 10.143 | 16299.8 |
447 | 2023-01-06 07:46:26 | suborders | 4 | 165329 | 709 | 10.220 | 16177.0 |
446 | 2022-12-31 06:51:12 | suborders | 2 | 121436 | 7 | 4.500 | 26985.8 |
445 | 2022-12-25 08:07:39 | suborders | 1 | 81242 | 3 | 1.233 | 65889.7 |
444 | 2022-12-24 09:06:00 | suborders | 4 | 165329 | 709 | 10.953 | 15094.4 |
443 | 2022-12-09 10:31:42 | suborders | 4 | 165329 | 709 | 12.656 | 13063.3 |
442 | 2022-10-30 19:21:18 | suborders | 4 | 165329 | 709 | 12.500 | 13226.3 |
441 | 2022-10-24 03:13:04 | suborders | 4 | 165329 | 709 | 10.516 | 15721.7 |
440 | 2022-09-13 04:24:12 | suborders | 1 | 81242 | 3 | 1.343 | 60492.9 |
439 | 2022-09-11 12:44:27 | suborders | 4 | 165329 | 709 | 10.516 | 15721.7 |
438 | 2022-09-04 06:06:52 | suborders | 2 | 121436 | 7 | 3.046 | 39867.4 |
437 | 2022-09-02 04:29:24 | suborders | 2 | 121436 | 7 | 3.143 | 38637.0 |
436 | 2022-07-15 17:42:12 | suborders | 1 | 81242 | 3 | 1.233 | 65889.7 |
435 | 2022-07-04 06:08:32 | suborders | 1 | 81242 | 3 | 1.373 | 59171.2 |
434 | 2022-06-18 10:41:43 | suborders | 4 | 165329 | 709 | 10.373 | 15938.4 |
433 | 2022-06-11 08:02:55 | suborders | 4 | 165329 | 709 | 11.733 | 14090.9 |
432 | 2022-04-09 11:51:38 | suborders | 2 | 121436 | 7 | 3.250 | 37364.9 |
431 | 2022-04-06 05:10:59 | suborders | 4 | 165329 | 709 | 12.080 | 13686.2 |
430 | 2022-04-01 18:09:35 | suborders | 1 | 81242 | 3 | 1.343 | 60492.9 |
429 | 2021-12-20 08:37:44 | suborders | 4 | 165329 | 709 | 13.016 | 12702.0 |
428 | 2021-12-16 11:04:13 | suborders | 3 | 148641 | 72 | 6.940 | 21418.0 |
427 | 2021-12-16 09:57:31 | suborders | 4 | 165329 | 709 | 11.813 | 13995.5 |
426 | 2021-12-15 03:19:05 | suborders | 4 | 165329 | 709 | 12.360 | 13376.1 |