History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"asperse"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 543 | 2024-05-03 14:05:47 | asperse | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 542 | 2024-04-26 20:38:40 | asperse | 1 | 69583 | 5 | 1.796 | 38743.3 |
| 541 | 2024-04-15 15:34:52 | asperse | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 540 | 2024-04-01 12:16:14 | asperse | 1 | 69583 | 5 | 2.720 | 25582.0 |
| 539 | 2024-04-01 12:15:50 | asperse | 2 | 107671 | 30 | 5.376 | 20028.1 |
| 538 | 2024-03-31 09:59:24 | asperse | 3 | 134027 | 285 | 20.923 | 6405.7 |
| 537 | 2024-03-31 09:59:24 | asperse | 2 | 107671 | 30 | 10.126 | 10633.1 |
| 536 | 2024-03-31 00:39:57 | asperse | 1 | 69583 | 5 | 3.860 | 18026.7 |
| 535 | 2024-03-02 14:32:17 | asperse | 1 | 69583 | 5 | 3.266 | 21305.3 |
| 534 | 2024-02-28 08:02:31 | asperse | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 533 | 2023-12-31 12:11:52 | asperse | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 532 | 2023-12-18 15:43:27 | asperse | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 531 | 2023-12-05 05:39:59 | asperse | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 530 | 2023-11-26 14:13:31 | asperse | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 529 | 2023-11-19 11:56:44 | asperse | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 528 | 2023-11-11 06:42:15 | asperse | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 527 | 2023-10-24 17:34:16 | asperse | 1 | 69583 | 5 | 1.206 | 57697.3 |
| 526 | 2023-10-20 12:25:38 | asperse | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 525 | 2023-10-19 18:53:07 | asperse | 1 | 69583 | 5 | 1.153 | 60349.5 |
| 524 | 2023-10-06 10:10:14 | asperse | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 523 | 2023-09-26 21:55:55 | asperse | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 522 | 2023-09-22 19:27:44 | asperse | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 521 | 2023-08-15 22:38:48 | asperse | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 520 | 2023-08-07 01:22:46 | asperse | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 519 | 2023-05-16 14:18:42 | asperse | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 518 | 2023-04-25 19:47:55 | asperse | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 517 | 2023-03-12 18:19:01 | asperse | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 516 | 2023-02-11 03:55:36 | asperse | 1 | 69583 | 5 | 1.073 | 64849.0 |
| 515 | 2023-01-06 00:23:38 | asperse | 1 | 69583 | 5 | 2.110 | 32977.7 |
| 514 | 2023-01-03 18:40:11 | asperse | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 513 | 2022-12-23 11:43:13 | asperse | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 512 | 2022-12-02 15:15:20 | asperse | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 511 | 2022-11-24 17:09:57 | asperse | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 510 | 2022-11-21 08:49:09 | asperse | 1 | 69583 | 5 | 1.390 | 50059.7 |
| 509 | 2022-09-26 03:46:07 | asperse | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 508 | 2022-09-22 07:22:21 | asperse | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 507 | 2022-09-01 13:46:00 | asperse | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 506 | 2022-08-06 12:02:16 | asperse | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 505 | 2022-06-08 22:16:34 | asperse | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 504 | 2022-05-10 02:54:01 | asperse | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 503 | 2022-05-07 23:24:15 | asperse | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 502 | 2022-03-04 06:17:14 | asperse | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 501 | 2022-02-28 20:19:00 | asperse | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 500 | 2022-02-15 16:44:55 | asperse | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 499 | 2022-01-26 22:05:58 | asperse | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 498 | 2021-12-31 00:24:25 | asperse | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 497 | 2021-12-09 08:51:20 | asperse | 1 | 69583 | 5 | 1.440 | 48321.5 |
| 496 | 2021-11-30 06:39:07 | asperse | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 495 | 2021-11-22 07:56:04 | asperse | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 494 | 2021-11-17 06:41:36 | asperse | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 493 | 2021-10-05 22:48:52 | asperse | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 492 | 2021-09-05 23:22:44 | asperse | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 491 | 2021-08-21 13:31:00 | asperse | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 490 | 2021-08-14 09:52:46 | asperse | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 489 | 2021-08-10 01:36:08 | asperse | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 488 | 2021-07-12 18:53:39 | asperse | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 487 | 2021-07-02 04:41:36 | asperse | 3 | 134027 | 285 | 5.983 | 22401.3 |
| 486 | 2021-06-29 17:07:56 | asperse | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 485 | 2021-06-02 10:43:48 | asperse | 1 | 69583 | 5 | 1.690 | 41173.4 |
| 484 | 2021-05-30 17:21:25 | asperse | 3 | 134027 | 285 | 6.876 | 19492.0 |
| 483 | 2021-05-19 14:48:38 | asperse | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 482 | 2021-05-13 17:30:54 | asperse | 1 | 69583 | 5 | 2.606 | 26701.1 |
| 481 | 2021-05-11 21:18:11 | asperse | 3 | 134027 | 285 | 6.643 | 20175.7 |
| 480 | 2021-05-05 11:17:08 | asperse | 3 | 134027 | 285 | 6.966 | 19240.2 |
| 479 | 2021-05-02 19:47:54 | asperse | 1 | 69583 | 5 | 1.153 | 60349.5 |
| 478 | 2021-04-14 06:08:24 | asperse | 3 | 134027 | 285 | 6.093 | 21996.9 |
| 477 | 2021-03-30 19:38:33 | asperse | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 476 | 2021-03-15 00:28:25 | asperse | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 475 | 2021-02-10 03:09:57 | asperse | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 474 | 2021-02-05 11:35:33 | asperse | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 473 | 2021-02-05 11:15:45 | asperse | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 472 | 2021-01-27 20:22:22 | asperse | 3 | 134027 | 285 | 6.030 | 22226.7 |
| 471 | 2021-01-21 18:31:17 | asperse | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 470 | 2020-12-22 14:32:32 | asperse | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 469 | 2020-11-08 15:02:00 | asperse | 3 | 134027 | 285 | 6.420 | 20876.5 |
| 468 | 2020-11-03 08:54:16 | asperse | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 467 | 2020-10-23 06:52:35 | asperse | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 466 | 2020-07-24 15:40:33 | asperse | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 465 | 2020-07-24 06:05:53 | asperse | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 464 | 2020-04-28 21:51:32 | asperse | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 463 | 2020-04-22 11:10:12 | asperse | 1 | 69583 | 5 | 1.423 | 48898.8 |
| 462 | 2020-03-28 18:43:51 | asperse | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 461 | 2020-03-28 08:12:04 | asperse | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 460 | 2020-03-27 03:35:08 | asperse | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 459 | 2020-03-25 17:32:06 | asperse | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 458 | 2020-03-21 07:41:19 | asperse | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 457 | 2020-02-29 22:04:37 | asperse | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 456 | 2020-02-24 08:06:59 | asperse | 1 | 69583 | 5 | 2.420 | 28753.3 |
| 455 | 2020-02-23 14:39:22 | asperse | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 454 | 2020-02-22 13:45:44 | asperse | 1 | 69583 | 5 | 2.640 | 26357.2 |
| 453 | 2020-02-11 03:23:32 | asperse | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 452 | 2020-02-07 08:38:58 | asperse | 1 | 69583 | 5 | 4.143 | 16795.3 |
| 451 | 2020-02-01 11:19:57 | asperse | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 450 | 2020-01-28 02:35:23 | asperse | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 449 | 2020-01-27 12:32:05 | asperse | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 448 | 2020-01-21 23:34:53 | asperse | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 447 | 2020-01-20 23:14:01 | asperse | 1 | 69583 | 5 | 1.373 | 50679.5 |
| 446 | 2020-01-19 09:24:11 | asperse | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 445 | 2020-01-14 21:14:17 | asperse | 1 | 69583 | 5 | 2.720 | 25582.0 |
| 444 | 2020-01-07 01:38:08 | asperse | 1 | 69583 | 5 | 1.906 | 36507.3 |