History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"faucet"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 560 | 2024-03-30 19:59:21 | faucet | 1 | 48755 | 4 | 0.953 | 51159.5 |
| 559 | 2024-03-29 01:28:05 | faucet | 1 | 48755 | 4 | 1.000 | 48755.0 |
| 558 | 2024-03-28 05:51:55 | faucet | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 557 | 2024-01-22 03:15:37 | faucet | 3 | 112716 | 515 | 4.656 | 24208.8 |
| 556 | 2024-01-10 03:47:54 | faucet | 3 | 112716 | 515 | 4.766 | 23650.0 |
| 555 | 2024-01-04 21:39:12 | faucet | 3 | 112716 | 515 | 5.466 | 20621.3 |
| 554 | 2024-01-04 21:39:11 | faucet | 2 | 82551 | 32 | 2.500 | 33020.4 |
| 553 | 2023-12-30 07:16:50 | faucet | 3 | 112716 | 515 | 4.703 | 23966.8 |
| 552 | 2023-12-30 07:16:45 | faucet | 2 | 82551 | 32 | 2.343 | 35233.0 |
| 551 | 2023-12-20 03:52:43 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 550 | 2023-12-13 04:59:08 | faucet | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 549 | 2023-11-23 14:42:32 | faucet | 3 | 112716 | 515 | 5.076 | 22205.7 |
| 548 | 2023-11-23 14:42:21 | faucet | 2 | 82551 | 32 | 5.423 | 15222.4 |
| 547 | 2023-11-14 18:18:30 | faucet | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 546 | 2023-11-13 14:29:25 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 545 | 2023-11-05 07:12:22 | faucet | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 544 | 2023-11-02 07:14:56 | faucet | 3 | 112716 | 515 | 5.453 | 20670.5 |
| 543 | 2023-11-01 02:23:34 | faucet | 3 | 112716 | 515 | 4.873 | 23130.7 |
| 542 | 2023-10-21 23:28:41 | faucet | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 541 | 2023-10-18 17:20:28 | faucet | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 540 | 2023-10-12 23:44:09 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 539 | 2023-10-07 07:37:40 | faucet | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 538 | 2023-10-05 03:02:25 | faucet | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 537 | 2023-09-26 08:42:02 | faucet | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 536 | 2023-09-12 20:32:06 | faucet | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 535 | 2023-08-23 13:30:32 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 534 | 2023-08-11 00:35:26 | faucet | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 533 | 2023-08-08 18:45:39 | faucet | 3 | 112716 | 515 | 5.330 | 21147.5 |
| 532 | 2023-08-03 13:43:13 | faucet | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 531 | 2023-06-24 19:48:06 | faucet | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 530 | 2023-05-09 09:06:32 | faucet | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 529 | 2023-05-06 07:44:08 | faucet | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 528 | 2023-05-03 15:53:59 | faucet | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 527 | 2023-05-02 16:24:08 | faucet | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 526 | 2023-03-19 14:14:06 | faucet | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 525 | 2023-03-13 01:17:39 | faucet | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 524 | 2023-02-23 05:48:08 | faucet | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 523 | 2023-02-20 15:16:28 | faucet | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 522 | 2023-01-20 06:34:26 | faucet | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 521 | 2022-12-31 17:05:04 | faucet | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 520 | 2022-12-19 02:44:10 | faucet | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 519 | 2022-12-10 22:18:02 | faucet | 3 | 112716 | 515 | 5.170 | 21801.9 |
| 518 | 2022-12-05 06:55:12 | faucet | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 517 | 2022-11-16 05:05:24 | faucet | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 516 | 2022-10-01 03:00:55 | faucet | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 515 | 2022-09-28 20:36:14 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 514 | 2022-09-15 18:46:23 | faucet | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 513 | 2022-09-05 15:51:54 | faucet | 1 | 48755 | 4 | 0.810 | 60191.4 |
| 512 | 2022-09-03 00:07:35 | faucet | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 511 | 2022-08-31 19:41:41 | faucet | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 510 | 2022-08-17 19:56:59 | faucet | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 509 | 2022-07-19 20:52:31 | faucet | 3 | 112716 | 515 | 4.580 | 24610.5 |
| 508 | 2022-07-14 19:31:05 | faucet | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 507 | 2022-06-27 00:05:51 | faucet | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 506 | 2022-06-15 12:30:08 | faucet | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 505 | 2022-05-27 17:56:44 | faucet | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 504 | 2022-05-12 17:52:21 | faucet | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 503 | 2022-05-09 10:29:38 | faucet | 1 | 48755 | 4 | 1.046 | 46610.9 |
| 502 | 2022-05-09 06:47:31 | faucet | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 501 | 2022-04-16 05:49:17 | faucet | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 500 | 2022-04-09 05:02:58 | faucet | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 499 | 2022-03-21 18:49:53 | faucet | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 498 | 2022-02-28 06:29:51 | faucet | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 497 | 2022-02-19 09:28:09 | faucet | 3 | 112716 | 515 | 5.533 | 20371.6 |
| 496 | 2022-01-11 23:16:06 | faucet | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 495 | 2022-01-02 19:20:50 | faucet | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 494 | 2021-11-23 10:30:34 | faucet | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 493 | 2021-11-22 01:56:59 | faucet | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 492 | 2021-11-05 21:28:50 | faucet | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 491 | 2021-10-25 06:03:59 | faucet | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 490 | 2021-10-08 19:24:37 | faucet | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 489 | 2021-10-08 03:53:57 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 488 | 2021-10-06 01:46:18 | faucet | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 487 | 2021-09-07 04:54:19 | faucet | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 486 | 2021-08-20 10:08:40 | faucet | 1 | 48755 | 4 | 1.733 | 28133.3 |
| 485 | 2021-08-18 15:18:26 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 484 | 2021-08-12 16:41:26 | faucet | 3 | 112716 | 515 | 5.563 | 20261.7 |
| 483 | 2021-08-12 16:41:26 | faucet | 2 | 82551 | 32 | 2.356 | 35038.6 |
| 482 | 2021-08-12 16:32:15 | faucet | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 481 | 2021-07-21 17:40:52 | faucet | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 480 | 2021-07-04 11:29:29 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 479 | 2021-06-05 09:00:55 | faucet | 1 | 48755 | 4 | 0.923 | 52822.3 |
| 478 | 2021-05-19 18:13:49 | faucet | 1 | 48755 | 4 | 1.046 | 46610.9 |
| 477 | 2021-05-19 00:13:44 | faucet | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 476 | 2021-05-18 07:06:57 | faucet | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 475 | 2021-05-11 07:15:29 | faucet | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 474 | 2021-04-18 07:09:06 | faucet | 1 | 48755 | 4 | 0.970 | 50262.9 |
| 473 | 2021-02-26 05:17:53 | faucet | 1 | 48755 | 4 | 0.970 | 50262.9 |
| 472 | 2021-02-16 21:35:11 | faucet | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 471 | 2021-01-30 15:18:44 | faucet | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 470 | 2020-12-26 06:45:00 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 469 | 2020-12-05 23:48:45 | faucet | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 468 | 2020-11-12 15:35:06 | faucet | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 467 | 2020-11-11 22:08:01 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 466 | 2020-10-03 13:51:33 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 465 | 2020-09-18 16:53:38 | faucet | 1 | 48755 | 4 | 0.856 | 56956.8 |
| 464 | 2020-08-27 00:52:54 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 463 | 2020-08-06 00:41:40 | faucet | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 462 | 2020-07-24 23:29:53 | faucet | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 461 | 2020-07-24 09:51:33 | faucet | 1 | 48755 | 4 | 0.796 | 61250.0 |