History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roofs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
547 | 2024-04-18 11:41:01 | roofs | 1 | 28756 | 14 | 0.546 | 52666.7 |
546 | 2024-04-18 10:47:54 | roofs | 1 | 28756 | 14 | 1.796 | 16011.1 |
545 | 2024-04-18 10:45:45 | roofs | 1 | 28756 | 14 | 1.140 | 25224.6 |
544 | 2024-04-03 04:33:54 | roofs | 1 | 28756 | 14 | 1.876 | 15328.4 |
543 | 2024-03-30 22:02:32 | roofs | 1 | 28756 | 14 | 0.546 | 52666.7 |
542 | 2024-03-30 19:36:09 | roofs | 2 | 53800 | 179 | 4.576 | 11757.0 |
541 | 2024-03-30 04:21:20 | roofs | 2 | 53800 | 179 | 4.546 | 11834.6 |
540 | 2024-03-29 07:20:33 | roofs | 1 | 28756 | 14 | 1.733 | 16593.2 |
539 | 2024-03-29 07:20:14 | roofs | 2 | 53800 | 179 | 3.203 | 16796.8 |
538 | 2024-03-29 06:53:48 | roofs | 2 | 53800 | 179 | 4.236 | 12700.7 |
537 | 2024-03-29 04:24:40 | roofs | 1 | 28756 | 14 | 0.530 | 54256.6 |
536 | 2024-02-28 01:04:48 | roofs | 1 | 28756 | 14 | 0.516 | 55728.7 |
535 | 2024-01-28 19:52:37 | roofs | 1 | 28756 | 14 | 0.436 | 65954.1 |
534 | 2024-01-08 19:13:17 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
533 | 2024-01-05 11:53:12 | roofs | 2 | 53800 | 179 | 1.593 | 33772.8 |
532 | 2023-11-21 18:51:48 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
531 | 2023-11-13 22:54:31 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
530 | 2023-11-04 10:03:28 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
529 | 2023-11-01 05:25:42 | roofs | 1 | 28756 | 14 | 0.516 | 55728.7 |
528 | 2023-11-01 02:13:42 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
527 | 2023-10-20 06:50:36 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
526 | 2023-10-18 07:30:52 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
525 | 2023-10-14 13:23:01 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
524 | 2023-10-08 02:22:47 | roofs | 1 | 28756 | 14 | 0.436 | 65954.1 |
523 | 2023-10-07 23:02:33 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
522 | 2023-09-29 11:46:31 | roofs | 1 | 28756 | 14 | 0.513 | 56054.6 |
521 | 2023-08-24 05:39:35 | roofs | 1 | 28756 | 14 | 0.456 | 63061.4 |
520 | 2023-06-08 00:23:42 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
519 | 2023-05-24 11:35:32 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
518 | 2023-03-19 10:41:22 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
517 | 2023-02-16 11:54:29 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
516 | 2023-01-08 05:43:30 | roofs | 1 | 28756 | 14 | 0.486 | 59168.7 |
515 | 2022-10-15 20:13:36 | roofs | 1 | 28756 | 14 | 0.436 | 65954.1 |
514 | 2022-10-01 17:33:06 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
513 | 2022-06-10 15:47:59 | roofs | 1 | 28756 | 14 | 0.560 | 51350.0 |
512 | 2022-05-18 10:57:30 | roofs | 1 | 28756 | 14 | 0.513 | 56054.6 |
511 | 2022-02-06 08:47:59 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
510 | 2022-01-30 23:19:11 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
509 | 2021-11-26 02:01:23 | roofs | 1 | 28756 | 14 | 0.466 | 61708.2 |
508 | 2021-11-23 23:07:43 | roofs | 1 | 28756 | 14 | 0.513 | 56054.6 |
507 | 2021-10-21 04:18:17 | roofs | 1 | 28756 | 14 | 0.440 | 65354.5 |
506 | 2021-10-10 06:03:43 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
505 | 2021-10-05 13:36:13 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
504 | 2021-08-29 19:58:31 | roofs | 1 | 28756 | 14 | 0.923 | 31154.9 |
503 | 2021-08-14 14:21:08 | roofs | 1 | 28756 | 14 | 0.436 | 65954.1 |
502 | 2021-07-28 04:21:43 | roofs | 1 | 28756 | 14 | 0.530 | 54256.6 |
501 | 2021-07-27 10:39:47 | roofs | 1 | 28756 | 14 | 0.516 | 55728.7 |
500 | 2021-07-08 10:07:05 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
499 | 2021-05-18 06:53:24 | roofs | 1 | 28756 | 14 | 0.530 | 54256.6 |
498 | 2021-04-18 06:54:24 | roofs | 1 | 28756 | 14 | 0.530 | 54256.6 |
497 | 2021-04-08 14:40:43 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
496 | 2021-04-04 10:45:34 | roofs | 1 | 28756 | 14 | 1.050 | 27386.7 |
495 | 2021-02-22 10:00:06 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
494 | 2021-02-10 15:52:02 | roofs | 1 | 28756 | 14 | 0.466 | 61708.2 |
493 | 2021-02-03 12:37:46 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
492 | 2021-01-30 15:00:20 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
491 | 2021-01-02 17:16:37 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
490 | 2020-12-30 11:33:27 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
489 | 2020-11-03 02:26:21 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
488 | 2020-10-30 22:45:53 | roofs | 1 | 28756 | 14 | 0.486 | 59168.7 |
487 | 2020-10-17 01:08:42 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
486 | 2020-10-01 11:02:55 | roofs | 1 | 28756 | 14 | 0.440 | 65354.5 |
485 | 2020-09-28 07:39:40 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
484 | 2020-09-18 04:41:26 | roofs | 1 | 28756 | 14 | 0.533 | 53951.2 |
483 | 2020-08-11 15:16:15 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
482 | 2020-08-09 09:07:50 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
481 | 2020-06-21 10:58:31 | roofs | 1 | 28756 | 14 | 0.763 | 37688.1 |
480 | 2020-06-19 14:13:33 | roofs | 1 | 28756 | 14 | 0.690 | 41675.4 |
479 | 2020-06-14 13:27:52 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
478 | 2020-06-13 05:23:39 | roofs | 1 | 28756 | 14 | 0.533 | 53951.2 |
477 | 2020-05-31 05:20:54 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
476 | 2020-05-28 07:54:51 | roofs | 1 | 28756 | 14 | 0.436 | 65954.1 |
475 | 2020-05-27 07:15:05 | roofs | 1 | 28756 | 14 | 0.486 | 59168.7 |
474 | 2020-05-24 17:03:59 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
473 | 2020-05-23 03:01:43 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
472 | 2020-05-20 16:46:53 | roofs | 1 | 28756 | 14 | 0.466 | 61708.2 |
471 | 2020-05-19 16:02:37 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
470 | 2020-05-16 04:26:10 | roofs | 1 | 28756 | 14 | 0.436 | 65954.1 |
469 | 2020-05-14 02:25:29 | roofs | 1 | 28756 | 14 | 0.533 | 53951.2 |
468 | 2020-05-13 03:44:44 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
467 | 2020-05-11 05:04:37 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
466 | 2020-05-10 04:27:10 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
465 | 2020-05-09 04:21:07 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
464 | 2020-05-08 04:25:14 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
463 | 2020-05-07 03:43:28 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
462 | 2020-05-06 04:27:30 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
461 | 2020-05-05 03:47:28 | roofs | 1 | 28756 | 14 | 0.513 | 56054.6 |
460 | 2020-05-04 03:47:35 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
459 | 2020-05-02 04:25:35 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
458 | 2020-05-01 03:43:28 | roofs | 1 | 28756 | 14 | 0.516 | 55728.7 |
457 | 2020-04-30 03:48:27 | roofs | 1 | 28756 | 14 | 0.466 | 61708.2 |
456 | 2020-04-29 03:46:37 | roofs | 1 | 28756 | 14 | 0.466 | 61708.2 |
455 | 2020-04-22 14:01:38 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
454 | 2020-04-18 02:45:45 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
453 | 2020-04-17 03:23:54 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
452 | 2020-04-16 03:20:46 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
451 | 2020-04-15 02:38:53 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
450 | 2020-04-10 13:15:35 | roofs | 1 | 28756 | 14 | 0.546 | 52666.7 |
449 | 2020-04-09 12:33:50 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
448 | 2020-04-08 13:15:56 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |