History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"exurb"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
588 | 2024-05-11 11:29:06 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
587 | 2024-05-06 08:33:03 | exurb | 2 | 53800 | 15 | 1.576 | 34137.1 |
586 | 2024-05-06 08:32:23 | exurb | 1 | 28756 | 2 | 0.983 | 29253.3 |
585 | 2024-05-01 15:06:27 | exurb | 3 | 83667 | 326 | 11.546 | 7246.4 |
584 | 2024-05-01 15:06:30 | exurb | 2 | 53800 | 15 | 1.783 | 30173.9 |
583 | 2024-05-01 15:06:22 | exurb | 3 | 83667 | 326 | 4.580 | 18267.9 |
582 | 2024-05-01 15:06:22 | exurb | 1 | 28756 | 2 | 1.656 | 17364.7 |
581 | 2024-05-01 15:06:18 | exurb | 2 | 53800 | 15 | 1.903 | 28271.2 |
580 | 2024-05-01 15:06:14 | exurb | 1 | 28756 | 2 | 1.030 | 27918.4 |
579 | 2024-04-29 23:11:57 | exurb | 1 | 28756 | 2 | 0.513 | 56054.6 |
578 | 2024-04-28 10:35:40 | exurb | 1 | 28756 | 2 | 0.513 | 56054.6 |
577 | 2024-04-27 05:21:10 | exurb | 1 | 28756 | 2 | 0.453 | 63479.0 |
576 | 2024-04-06 01:13:30 | exurb | 1 | 28756 | 2 | 0.550 | 52283.6 |
575 | 2024-03-31 16:04:25 | exurb | 1 | 28756 | 2 | 0.983 | 29253.3 |
574 | 2024-03-28 20:02:03 | exurb | 1 | 28756 | 2 | 0.483 | 59536.2 |
573 | 2024-03-28 11:22:46 | exurb | 1 | 28756 | 2 | 0.516 | 55728.7 |
572 | 2024-03-27 20:10:56 | exurb | 1 | 28756 | 2 | 0.450 | 63902.2 |
571 | 2024-03-07 00:24:30 | exurb | 3 | 83667 | 326 | 4.280 | 19548.4 |
570 | 2024-03-07 00:24:31 | exurb | 2 | 53800 | 15 | 1.846 | 29144.1 |
569 | 2024-03-06 21:37:37 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
568 | 2024-03-01 13:34:49 | exurb | 1 | 28756 | 2 | 0.500 | 57512.0 |
567 | 2024-02-27 10:05:00 | exurb | 2 | 53800 | 15 | 1.640 | 32804.9 |
566 | 2024-02-27 10:04:32 | exurb | 3 | 83667 | 326 | 4.016 | 20833.4 |
565 | 2024-02-26 15:41:20 | exurb | 3 | 83667 | 326 | 4.110 | 20356.9 |
564 | 2024-02-26 15:41:20 | exurb | 2 | 53800 | 15 | 1.703 | 31591.3 |
563 | 2024-02-26 15:41:11 | exurb | 1 | 28756 | 2 | 0.516 | 55728.7 |
562 | 2024-02-03 18:53:31 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
561 | 2024-01-29 04:24:51 | exurb | 1 | 28756 | 2 | 0.906 | 31739.5 |
560 | 2024-01-27 08:27:41 | exurb | 1 | 28756 | 2 | 0.486 | 59168.7 |
559 | 2024-01-12 16:31:00 | exurb | 2 | 53800 | 15 | 1.440 | 37361.1 |
558 | 2024-01-06 03:27:17 | exurb | 3 | 83667 | 326 | 3.296 | 25384.4 |
557 | 2023-12-23 06:42:50 | exurb | 1 | 28756 | 2 | 0.470 | 61183.0 |
556 | 2023-12-19 23:23:46 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
555 | 2023-12-17 19:47:19 | exurb | 3 | 83667 | 326 | 3.283 | 25484.9 |
554 | 2023-12-17 19:47:18 | exurb | 2 | 53800 | 15 | 1.453 | 37026.8 |
553 | 2023-12-11 14:53:31 | exurb | 3 | 83667 | 326 | 3.406 | 24564.6 |
552 | 2023-12-11 14:53:32 | exurb | 2 | 53800 | 15 | 1.610 | 33416.1 |
551 | 2023-12-04 10:39:37 | exurb | 3 | 83667 | 326 | 3.563 | 23482.2 |
550 | 2023-12-03 12:46:43 | exurb | 2 | 53800 | 15 | 1.610 | 33416.1 |
549 | 2023-11-29 08:25:49 | exurb | 3 | 83667 | 326 | 3.360 | 24900.9 |
548 | 2023-11-29 08:25:48 | exurb | 2 | 53800 | 15 | 1.376 | 39098.8 |
547 | 2023-11-12 09:27:57 | exurb | 1 | 28756 | 2 | 0.423 | 67981.1 |
546 | 2023-11-11 01:14:00 | exurb | 1 | 28756 | 2 | 0.500 | 57512.0 |
545 | 2023-11-03 20:44:01 | exurb | 2 | 53800 | 15 | 1.550 | 34709.7 |
544 | 2023-10-27 15:55:26 | exurb | 1 | 28756 | 2 | 0.483 | 59536.2 |
543 | 2023-10-20 17:53:07 | exurb | 1 | 28756 | 2 | 0.500 | 57512.0 |
542 | 2023-10-20 15:12:54 | exurb | 2 | 53800 | 15 | 1.860 | 28924.7 |
541 | 2023-10-18 00:29:49 | exurb | 1 | 28756 | 2 | 0.466 | 61708.2 |
540 | 2023-10-12 19:45:32 | exurb | 3 | 83667 | 326 | 3.360 | 24900.9 |
539 | 2023-10-11 19:52:32 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
538 | 2023-10-07 01:57:18 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
537 | 2023-10-04 12:48:44 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
536 | 2023-09-27 15:28:40 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
535 | 2023-09-21 15:17:06 | exurb | 1 | 28756 | 2 | 0.470 | 61183.0 |
534 | 2023-08-20 15:47:13 | exurb | 1 | 28756 | 2 | 0.466 | 61708.2 |
533 | 2023-08-03 05:14:19 | exurb | 1 | 28756 | 2 | 0.546 | 52666.7 |
532 | 2023-07-31 20:26:53 | exurb | 2 | 53800 | 15 | 1.546 | 34799.5 |
531 | 2023-07-22 16:05:49 | exurb | 3 | 83667 | 326 | 3.436 | 24350.1 |
530 | 2023-07-08 23:56:52 | exurb | 3 | 83667 | 326 | 3.203 | 26121.4 |
529 | 2023-06-23 01:05:44 | exurb | 3 | 83667 | 326 | 3.640 | 22985.4 |
528 | 2023-06-10 20:37:34 | exurb | 3 | 83667 | 326 | 3.266 | 25617.6 |
527 | 2023-06-09 23:19:31 | exurb | 3 | 83667 | 326 | 3.423 | 24442.6 |
526 | 2023-04-28 21:54:06 | exurb | 1 | 28756 | 2 | 0.470 | 61183.0 |
525 | 2023-04-25 14:41:08 | exurb | 1 | 28756 | 2 | 0.440 | 65354.5 |
524 | 2023-04-19 09:07:59 | exurb | 3 | 83667 | 326 | 3.606 | 23202.2 |
523 | 2023-04-10 01:06:46 | exurb | 2 | 53800 | 15 | 1.326 | 40573.2 |
522 | 2023-04-04 03:09:51 | exurb | 3 | 83667 | 326 | 3.170 | 26393.4 |
521 | 2023-02-25 06:59:37 | exurb | 3 | 83667 | 326 | 3.233 | 25879.1 |
520 | 2023-02-19 23:19:41 | exurb | 2 | 53800 | 15 | 1.330 | 40451.1 |
519 | 2023-02-18 07:58:23 | exurb | 1 | 28756 | 2 | 0.423 | 67981.1 |
518 | 2023-02-03 00:17:48 | exurb | 3 | 83667 | 326 | 3.156 | 26510.5 |
517 | 2023-01-15 05:35:57 | exurb | 2 | 53800 | 15 | 1.530 | 35163.4 |
516 | 2023-01-14 17:18:07 | exurb | 3 | 83667 | 326 | 6.720 | 12450.4 |
515 | 2023-01-11 21:29:21 | exurb | 3 | 83667 | 326 | 3.140 | 26645.5 |
514 | 2023-01-11 20:33:46 | exurb | 2 | 53800 | 15 | 3.110 | 17299.0 |
513 | 2023-01-04 15:28:39 | exurb | 3 | 83667 | 326 | 3.216 | 26015.9 |
512 | 2023-01-03 00:12:22 | exurb | 3 | 83667 | 326 | 3.220 | 25983.5 |
511 | 2022-12-29 07:46:06 | exurb | 1 | 28756 | 2 | 0.483 | 59536.2 |
510 | 2022-12-22 13:39:04 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
509 | 2022-12-18 02:01:01 | exurb | 3 | 83667 | 326 | 4.450 | 18801.6 |
508 | 2022-12-15 15:43:46 | exurb | 1 | 28756 | 2 | 0.423 | 67981.1 |
507 | 2022-11-27 14:53:30 | exurb | 3 | 83667 | 326 | 3.626 | 23074.2 |
506 | 2022-11-25 04:25:27 | exurb | 1 | 28756 | 2 | 0.420 | 68466.7 |
505 | 2022-11-23 09:55:34 | exurb | 1 | 28756 | 2 | 0.513 | 56054.6 |
504 | 2022-11-21 00:54:43 | exurb | 3 | 83667 | 326 | 3.296 | 25384.4 |
503 | 2022-11-11 09:23:39 | exurb | 3 | 83667 | 326 | 3.970 | 21074.8 |
502 | 2022-11-11 03:24:54 | exurb | 3 | 83667 | 326 | 3.530 | 23701.7 |
501 | 2022-10-31 11:54:02 | exurb | 3 | 83667 | 326 | 3.393 | 24658.7 |
500 | 2022-10-20 14:16:20 | exurb | 2 | 53800 | 15 | 1.483 | 36277.8 |
499 | 2022-10-05 03:27:15 | exurb | 3 | 83667 | 326 | 3.186 | 26260.8 |
498 | 2022-09-26 21:13:59 | exurb | 3 | 83667 | 326 | 3.813 | 21942.6 |
497 | 2022-09-19 10:31:02 | exurb | 3 | 83667 | 326 | 3.296 | 25384.4 |
496 | 2022-09-17 13:36:27 | exurb | 3 | 83667 | 326 | 3.690 | 22674.0 |
495 | 2022-09-16 08:27:59 | exurb | 3 | 83667 | 326 | 3.173 | 26368.4 |
494 | 2022-09-04 11:12:01 | exurb | 3 | 83667 | 326 | 3.263 | 25641.1 |
493 | 2022-08-31 15:58:37 | exurb | 3 | 83667 | 326 | 3.626 | 23074.2 |
492 | 2022-08-25 23:12:23 | exurb | 1 | 28756 | 2 | 0.453 | 63479.0 |
491 | 2022-08-25 10:07:43 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |
490 | 2022-08-22 14:34:02 | exurb | 3 | 83667 | 326 | 3.283 | 25484.9 |
489 | 2022-08-21 18:38:08 | exurb | 1 | 28756 | 2 | 0.436 | 65954.1 |