History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spraying"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 551 | 2024-04-30 05:23:43 | spraying | 1 | 82945 | 5 | 3.313 | 25036.2 |
| 550 | 2024-04-30 04:44:09 | spraying | 1 | 82945 | 5 | 1.640 | 50576.2 |
| 549 | 2024-04-13 03:14:28 | spraying | 2 | 121059 | 51 | 5.156 | 23479.2 |
| 548 | 2024-04-13 03:13:28 | spraying | 3 | 146162 | 442 | 9.253 | 15796.2 |
| 547 | 2024-04-12 20:41:33 | spraying | 3 | 146162 | 442 | 12.203 | 11977.5 |
| 546 | 2024-04-10 18:35:49 | spraying | 3 | 146162 | 442 | 18.516 | 7893.8 |
| 545 | 2024-04-09 17:15:53 | spraying | 3 | 146162 | 442 | 19.686 | 7424.7 |
| 544 | 2024-04-09 11:22:32 | spraying | 3 | 146162 | 442 | 18.876 | 7743.3 |
| 543 | 2024-04-09 11:07:33 | spraying | 2 | 121059 | 51 | 11.576 | 10457.8 |
| 542 | 2024-04-09 01:16:26 | spraying | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 541 | 2024-04-09 01:16:15 | spraying | 3 | 146162 | 442 | 8.330 | 17546.5 |
| 540 | 2024-04-09 01:16:14 | spraying | 2 | 121059 | 51 | 9.280 | 13045.2 |
| 539 | 2024-04-09 01:16:11 | spraying | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 538 | 2024-03-30 03:28:59 | spraying | 1 | 82945 | 5 | 3.530 | 23497.2 |
| 537 | 2024-03-11 03:24:18 | spraying | 1 | 82945 | 5 | 3.173 | 26140.9 |
| 536 | 2024-03-10 10:17:13 | spraying | 3 | 146162 | 442 | 15.500 | 9429.8 |
| 535 | 2024-03-10 09:38:03 | spraying | 3 | 146162 | 442 | 17.500 | 8352.1 |
| 534 | 2024-03-10 06:45:27 | spraying | 3 | 146162 | 442 | 23.033 | 6345.8 |
| 533 | 2024-03-09 17:35:57 | spraying | 3 | 146162 | 442 | 25.550 | 5720.6 |
| 532 | 2024-03-08 23:39:03 | spraying | 1 | 82945 | 5 | 1.843 | 45005.4 |
| 531 | 2024-03-08 23:38:50 | spraying | 3 | 146162 | 442 | 7.690 | 19006.8 |
| 530 | 2024-03-08 23:38:52 | spraying | 2 | 121059 | 51 | 4.000 | 30264.8 |
| 529 | 2024-03-08 23:38:46 | spraying | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 528 | 2024-02-28 12:09:27 | spraying | 1 | 82945 | 5 | 3.093 | 26817.0 |
| 527 | 2024-02-15 23:57:49 | spraying | 2 | 121059 | 51 | 3.983 | 30393.9 |
| 526 | 2024-02-12 07:10:11 | spraying | 1 | 82945 | 5 | 3.203 | 25896.0 |
| 525 | 2024-02-05 04:49:45 | spraying | 3 | 146162 | 442 | 10.123 | 14438.6 |
| 524 | 2024-02-04 17:48:39 | spraying | 3 | 146162 | 442 | 8.970 | 16294.5 |
| 523 | 2024-02-04 06:37:39 | spraying | 3 | 146162 | 442 | 7.500 | 19488.3 |
| 522 | 2024-02-04 05:39:21 | spraying | 3 | 146162 | 442 | 13.203 | 11070.4 |
| 521 | 2024-02-04 02:55:38 | spraying | 3 | 146162 | 442 | 8.406 | 17387.8 |
| 520 | 2024-02-04 02:55:34 | spraying | 2 | 121059 | 51 | 4.236 | 28578.6 |
| 519 | 2024-02-04 02:55:30 | spraying | 1 | 82945 | 5 | 1.970 | 42104.1 |
| 518 | 2024-01-04 19:43:26 | spraying | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 517 | 2023-12-29 11:13:57 | spraying | 2 | 121059 | 51 | 3.216 | 37642.7 |
| 516 | 2023-12-04 12:56:57 | spraying | 1 | 82945 | 5 | 2.516 | 32967.0 |
| 515 | 2023-11-30 06:37:08 | spraying | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 514 | 2023-11-30 05:23:31 | spraying | 1 | 82945 | 5 | 1.403 | 59119.7 |
| 513 | 2023-11-10 22:14:56 | spraying | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 512 | 2023-11-06 01:02:49 | spraying | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 511 | 2023-10-31 07:51:58 | spraying | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 510 | 2023-10-06 20:38:22 | spraying | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 509 | 2023-10-01 11:37:36 | spraying | 2 | 121059 | 51 | 3.173 | 38152.9 |
| 508 | 2023-09-29 17:04:37 | spraying | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 507 | 2023-09-26 10:04:35 | spraying | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 506 | 2023-09-15 03:09:36 | spraying | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 505 | 2023-07-28 02:07:11 | spraying | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 504 | 2023-07-13 16:57:56 | spraying | 2 | 121059 | 51 | 3.610 | 33534.3 |
| 503 | 2023-07-01 20:58:02 | spraying | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 502 | 2023-04-10 19:41:57 | spraying | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 501 | 2023-04-05 03:23:38 | spraying | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 500 | 2023-04-02 05:11:24 | spraying | 2 | 121059 | 51 | 3.533 | 34265.2 |
| 499 | 2023-02-04 00:33:30 | spraying | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 498 | 2023-01-27 20:55:11 | spraying | 2 | 121059 | 51 | 3.140 | 38553.8 |
| 497 | 2022-12-29 02:20:22 | spraying | 2 | 121059 | 51 | 3.123 | 38763.7 |
| 496 | 2022-12-16 13:27:46 | spraying | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 495 | 2022-12-13 03:38:33 | spraying | 2 | 121059 | 51 | 3.550 | 34101.1 |
| 494 | 2022-12-03 02:14:16 | spraying | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 493 | 2022-11-03 20:00:04 | spraying | 2 | 121059 | 51 | 3.206 | 37760.1 |
| 492 | 2022-08-28 23:37:19 | spraying | 2 | 121059 | 51 | 3.266 | 37066.4 |
| 491 | 2022-08-06 16:10:20 | spraying | 1 | 82945 | 5 | 1.410 | 58826.2 |
| 490 | 2022-07-30 08:18:40 | spraying | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 489 | 2022-07-11 14:15:35 | spraying | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 488 | 2022-04-01 21:52:44 | spraying | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 487 | 2022-03-24 19:36:05 | spraying | 1 | 82945 | 5 | 2.030 | 40859.6 |
| 486 | 2022-01-01 20:20:34 | spraying | 1 | 82945 | 5 | 1.623 | 51106.0 |
| 485 | 2021-12-18 06:41:11 | spraying | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 484 | 2021-11-08 12:26:04 | spraying | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 483 | 2021-11-06 10:34:02 | spraying | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 482 | 2021-09-23 22:04:23 | spraying | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 481 | 2021-09-21 19:08:14 | spraying | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 480 | 2021-09-04 13:54:20 | spraying | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 479 | 2021-08-02 05:26:41 | spraying | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 478 | 2021-07-30 05:20:02 | spraying | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 477 | 2021-07-14 07:16:53 | spraying | 1 | 82945 | 5 | 1.440 | 57600.7 |
| 476 | 2021-07-11 19:34:42 | spraying | 1 | 82945 | 5 | 2.653 | 31264.6 |
| 475 | 2021-07-10 21:51:01 | spraying | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 474 | 2021-07-06 16:49:36 | spraying | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 473 | 2021-07-05 17:41:10 | spraying | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 472 | 2021-06-29 18:29:52 | spraying | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 471 | 2021-06-29 02:24:11 | spraying | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 470 | 2021-06-28 08:28:02 | spraying | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 469 | 2021-06-26 21:36:43 | spraying | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 468 | 2021-06-26 08:13:24 | spraying | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 467 | 2021-06-25 18:46:28 | spraying | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 466 | 2021-06-24 09:48:42 | spraying | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 465 | 2021-06-23 07:51:38 | spraying | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 464 | 2021-06-22 21:52:14 | spraying | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 463 | 2021-06-22 01:31:54 | spraying | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 462 | 2021-06-20 18:01:35 | spraying | 1 | 82945 | 5 | 1.450 | 57203.4 |
| 461 | 2021-06-19 17:26:01 | spraying | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 460 | 2021-06-18 21:53:25 | spraying | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 459 | 2021-06-17 21:38:24 | spraying | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 458 | 2021-06-13 04:41:37 | spraying | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 457 | 2021-06-12 13:10:47 | spraying | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 456 | 2021-06-11 14:09:22 | spraying | 1 | 82945 | 5 | 1.356 | 61168.9 |
| 455 | 2021-06-10 21:18:29 | spraying | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 454 | 2021-06-08 14:23:29 | spraying | 1 | 82945 | 5 | 2.236 | 37095.3 |
| 453 | 2021-06-07 17:00:30 | spraying | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 452 | 2021-06-06 20:03:26 | spraying | 1 | 82945 | 5 | 1.300 | 63803.8 |