History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"plumbs"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 473 | 2024-05-03 18:15:36 | plumbs | 1 | 48755 | 5 | 1.843 | 26454.2 |
| 472 | 2024-05-01 19:35:07 | plumbs | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 471 | 2024-04-29 16:38:54 | plumbs | 2 | 82551 | 57 | 2.390 | 34540.2 |
| 470 | 2024-04-29 16:38:50 | plumbs | 1 | 48755 | 5 | 1.796 | 27146.4 |
| 469 | 2024-04-29 16:38:26 | plumbs | 3 | 112716 | 500 | 9.266 | 12164.5 |
| 468 | 2024-04-29 15:58:13 | plumbs | 3 | 112716 | 500 | 19.203 | 5869.7 |
| 467 | 2024-04-28 12:04:24 | plumbs | 3 | 112716 | 500 | 5.860 | 19234.8 |
| 466 | 2024-04-27 04:25:55 | plumbs | 1 | 48755 | 5 | 2.000 | 24377.5 |
| 465 | 2024-04-14 23:59:32 | plumbs | 1 | 48755 | 5 | 3.406 | 14314.4 |
| 464 | 2024-04-14 23:56:12 | plumbs | 1 | 48755 | 5 | 2.500 | 19502.0 |
| 463 | 2024-04-09 20:22:59 | plumbs | 1 | 48755 | 5 | 1.033 | 47197.5 |
| 462 | 2024-03-30 03:13:33 | plumbs | 3 | 112716 | 500 | 11.890 | 9479.9 |
| 461 | 2024-03-29 01:31:23 | plumbs | 2 | 82551 | 57 | 3.953 | 20883.1 |
| 460 | 2024-03-28 22:50:45 | plumbs | 3 | 112716 | 500 | 18.330 | 6149.3 |
| 459 | 2024-03-28 22:33:34 | plumbs | 3 | 112716 | 500 | 10.190 | 11061.4 |
| 458 | 2024-03-28 22:33:35 | plumbs | 2 | 82551 | 57 | 2.906 | 28407.1 |
| 457 | 2024-03-28 22:33:31 | plumbs | 1 | 48755 | 5 | 2.890 | 16870.2 |
| 456 | 2024-03-06 01:54:19 | plumbs | 1 | 48755 | 5 | 2.796 | 17437.4 |
| 455 | 2024-03-06 01:54:03 | plumbs | 2 | 82551 | 57 | 8.200 | 10067.2 |
| 454 | 2024-03-04 03:21:44 | plumbs | 2 | 82551 | 57 | 4.736 | 17430.5 |
| 453 | 2024-03-04 03:21:44 | plumbs | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 452 | 2024-02-25 21:17:47 | plumbs | 1 | 48755 | 5 | 1.750 | 27860.0 |
| 451 | 2024-02-07 02:01:38 | plumbs | 3 | 112716 | 500 | 10.703 | 10531.3 |
| 450 | 2024-02-05 06:06:17 | plumbs | 3 | 112716 | 500 | 10.453 | 10783.1 |
| 449 | 2024-01-30 08:34:39 | plumbs | 2 | 82551 | 57 | 2.436 | 33887.9 |
| 448 | 2024-01-30 08:34:19 | plumbs | 3 | 112716 | 500 | 4.593 | 24540.8 |
| 447 | 2024-01-30 07:03:26 | plumbs | 2 | 82551 | 57 | 2.423 | 34069.7 |
| 446 | 2024-01-30 07:01:54 | plumbs | 3 | 112716 | 500 | 5.966 | 18893.1 |
| 445 | 2024-01-29 16:47:13 | plumbs | 3 | 112716 | 500 | 9.190 | 12265.1 |
| 444 | 2024-01-23 15:06:51 | plumbs | 3 | 112716 | 500 | 13.186 | 8548.2 |
| 443 | 2024-01-19 23:25:03 | plumbs | 3 | 112716 | 500 | 5.266 | 21404.5 |
| 442 | 2024-01-05 22:21:37 | plumbs | 2 | 82551 | 57 | 2.373 | 34787.6 |
| 441 | 2023-12-31 04:39:00 | plumbs | 2 | 82551 | 57 | 2.546 | 32423.8 |
| 440 | 2023-12-31 04:38:57 | plumbs | 3 | 112716 | 500 | 5.016 | 22471.3 |
| 439 | 2023-12-28 12:10:12 | plumbs | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 438 | 2023-12-25 21:13:26 | plumbs | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 437 | 2023-12-13 13:44:45 | plumbs | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 436 | 2023-12-04 14:10:17 | plumbs | 3 | 112716 | 500 | 5.343 | 21096.0 |
| 435 | 2023-12-04 14:10:11 | plumbs | 3 | 112716 | 500 | 5.300 | 21267.2 |
| 434 | 2023-12-03 23:51:43 | plumbs | 3 | 112716 | 500 | 4.623 | 24381.6 |
| 433 | 2023-11-13 22:27:38 | plumbs | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 432 | 2023-11-05 16:27:24 | plumbs | 1 | 48755 | 5 | 1.796 | 27146.4 |
| 431 | 2023-11-04 02:06:26 | plumbs | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 430 | 2023-10-27 21:26:01 | plumbs | 3 | 112716 | 500 | 5.076 | 22205.7 |
| 429 | 2023-10-16 23:44:43 | plumbs | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 428 | 2023-10-12 10:23:31 | plumbs | 2 | 82551 | 57 | 2.093 | 39441.5 |
| 427 | 2023-10-11 06:35:57 | plumbs | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 426 | 2023-09-26 19:28:01 | plumbs | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 425 | 2023-09-13 12:47:33 | plumbs | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 424 | 2023-08-23 08:30:18 | plumbs | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 423 | 2023-08-20 01:15:54 | plumbs | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 422 | 2023-08-13 15:51:26 | plumbs | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 421 | 2023-08-08 20:55:40 | plumbs | 3 | 112716 | 500 | 4.546 | 24794.5 |
| 420 | 2023-07-23 10:04:38 | plumbs | 2 | 82551 | 57 | 2.093 | 39441.5 |
| 419 | 2023-05-15 04:55:57 | plumbs | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 418 | 2023-04-28 14:37:13 | plumbs | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 417 | 2023-04-21 16:29:31 | plumbs | 3 | 112716 | 500 | 4.516 | 24959.3 |
| 416 | 2023-04-17 03:35:50 | plumbs | 3 | 112716 | 500 | 4.500 | 25048.0 |
| 415 | 2023-04-04 17:54:16 | plumbs | 2 | 82551 | 57 | 2.343 | 35233.0 |
| 414 | 2023-03-25 09:39:10 | plumbs | 3 | 112716 | 500 | 4.843 | 23274.0 |
| 413 | 2023-03-10 23:52:42 | plumbs | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 412 | 2023-02-27 10:48:09 | plumbs | 3 | 112716 | 500 | 5.123 | 22002.0 |
| 411 | 2023-01-23 20:51:01 | plumbs | 3 | 112716 | 500 | 4.500 | 25048.0 |
| 410 | 2023-01-07 14:53:28 | plumbs | 3 | 112716 | 500 | 4.500 | 25048.0 |
| 409 | 2023-01-05 06:44:19 | plumbs | 3 | 112716 | 500 | 4.516 | 24959.3 |
| 408 | 2023-01-05 01:59:54 | plumbs | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 407 | 2023-01-02 11:21:49 | plumbs | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 406 | 2022-12-31 08:46:43 | plumbs | 2 | 82551 | 57 | 2.343 | 35233.0 |
| 405 | 2022-12-17 12:54:18 | plumbs | 3 | 112716 | 500 | 5.143 | 21916.4 |
| 404 | 2022-12-15 05:10:19 | plumbs | 3 | 112716 | 500 | 4.703 | 23966.8 |
| 403 | 2022-11-14 19:59:42 | plumbs | 3 | 112716 | 500 | 4.500 | 25048.0 |
| 402 | 2022-11-05 15:52:20 | plumbs | 3 | 112716 | 500 | 4.516 | 24959.3 |
| 401 | 2022-10-30 22:36:03 | plumbs | 3 | 112716 | 500 | 6.156 | 18309.9 |
| 400 | 2022-10-29 19:38:03 | plumbs | 3 | 112716 | 500 | 4.653 | 24224.4 |
| 399 | 2022-10-28 11:13:19 | plumbs | 3 | 112716 | 500 | 10.686 | 10548.0 |
| 398 | 2022-09-29 22:07:31 | plumbs | 3 | 112716 | 500 | 4.563 | 24702.2 |
| 397 | 2022-09-23 10:58:24 | plumbs | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 396 | 2022-09-03 21:46:57 | plumbs | 2 | 82551 | 57 | 2.203 | 37472.1 |
| 395 | 2022-08-24 09:50:20 | plumbs | 3 | 112716 | 500 | 5.343 | 21096.0 |
| 394 | 2022-08-21 03:16:51 | plumbs | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 393 | 2022-07-13 05:54:19 | plumbs | 3 | 112716 | 500 | 4.513 | 24975.8 |
| 392 | 2022-06-08 03:11:04 | plumbs | 3 | 112716 | 500 | 4.580 | 24610.5 |
| 391 | 2022-05-06 08:32:47 | plumbs | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 390 | 2022-04-20 13:34:51 | plumbs | 1 | 48755 | 5 | 1.596 | 30548.2 |
| 389 | 2022-01-25 07:13:02 | plumbs | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 388 | 2022-01-23 03:27:02 | plumbs | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 387 | 2021-12-29 02:19:19 | plumbs | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 386 | 2021-11-18 16:12:48 | plumbs | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 385 | 2021-10-06 11:35:38 | plumbs | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 384 | 2021-10-04 09:21:23 | plumbs | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 383 | 2021-09-15 05:42:40 | plumbs | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 382 | 2021-09-12 08:50:06 | plumbs | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 381 | 2021-03-24 10:40:15 | plumbs | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 380 | 2021-01-07 03:30:44 | plumbs | 1 | 48755 | 5 | 1.920 | 25393.2 |
| 379 | 2020-10-30 07:26:43 | plumbs | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 378 | 2020-10-29 21:42:54 | plumbs | 1 | 48755 | 5 | 1.436 | 33951.9 |
| 377 | 2020-10-20 12:08:20 | plumbs | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 376 | 2020-10-17 04:46:36 | plumbs | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 375 | 2020-10-14 11:39:33 | plumbs | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 374 | 2020-10-11 00:07:01 | plumbs | 1 | 48755 | 5 | 0.780 | 62506.4 |