History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oilman"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 518 | 2025-02-01 08:48:36 | oilman | 1 | 48755 | 3 | 3.546 | 13749.3 |
| 517 | 2025-01-23 22:01:03 | oilman | 1 | 48755 | 3 | 4.640 | 10507.5 |
| 516 | 2025-01-11 21:08:47 | oilman | 1 | 48755 | 3 | 2.046 | 23829.4 |
| 515 | 2024-12-30 06:20:40 | oilman | 1 | 48755 | 3 | 1.986 | 24549.3 |
| 514 | 2024-12-29 12:43:52 | oilman | 3 | 112716 | 296 | 26.796 | 4206.4 |
| 513 | 2024-12-29 12:43:56 | oilman | 2 | 82551 | 21 | 18.313 | 4507.8 |
| 512 | 2024-12-29 02:39:12 | oilman | 2 | 82551 | 21 | 12.580 | 6562.1 |
| 511 | 2024-12-29 01:21:33 | oilman | 3 | 112716 | 296 | 36.000 | 3131.0 |
| 510 | 2024-12-28 20:36:28 | oilman | 3 | 112716 | 296 | 27.943 | 4033.8 |
| 509 | 2024-12-28 12:34:31 | oilman | 1 | 48755 | 3 | 2.106 | 23150.5 |
| 508 | 2024-12-28 12:19:27 | oilman | 3 | 112716 | 296 | 11.876 | 9491.1 |
| 507 | 2024-12-28 12:19:28 | oilman | 2 | 82551 | 21 | 3.436 | 24025.3 |
| 506 | 2024-12-23 10:16:08 | oilman | 1 | 48755 | 3 | 4.140 | 11776.6 |
| 505 | 2024-12-13 11:29:34 | oilman | 1 | 48755 | 3 | 1.796 | 27146.4 |
| 504 | 2024-12-12 13:32:52 | oilman | 1 | 48755 | 3 | 2.173 | 22436.7 |
| 503 | 2024-11-18 14:20:00 | oilman | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 502 | 2024-11-16 19:20:06 | oilman | 2 | 82551 | 21 | 13.250 | 6230.3 |
| 501 | 2024-11-09 19:13:12 | oilman | 2 | 82551 | 21 | 2.373 | 34787.6 |
| 500 | 2024-11-09 09:48:06 | oilman | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 499 | 2024-10-31 23:01:06 | oilman | 3 | 112716 | 296 | 13.343 | 8447.6 |
| 498 | 2024-10-31 22:27:45 | oilman | 3 | 112716 | 296 | 29.296 | 3847.5 |
| 497 | 2024-10-30 17:03:22 | oilman | 3 | 112716 | 296 | 23.190 | 4860.5 |
| 496 | 2024-10-30 13:37:05 | oilman | 3 | 112716 | 296 | 21.093 | 5343.8 |
| 495 | 2024-10-30 13:36:59 | oilman | 2 | 82551 | 21 | 6.406 | 12886.5 |
| 494 | 2024-10-30 13:36:47 | oilman | 1 | 48755 | 3 | 4.203 | 11600.0 |
| 493 | 2024-10-20 16:38:19 | oilman | 1 | 48755 | 3 | 6.093 | 8001.8 |
| 492 | 2024-10-18 12:08:13 | oilman | 1 | 48755 | 3 | 4.046 | 12050.2 |
| 491 | 2024-10-10 01:42:36 | oilman | 1 | 48755 | 3 | 6.076 | 8024.2 |
| 490 | 2024-09-30 13:30:45 | oilman | 1 | 48755 | 3 | 7.546 | 6461.0 |
| 489 | 2024-09-03 06:12:18 | oilman | 1 | 48755 | 3 | 7.023 | 6942.2 |
| 488 | 2024-09-02 21:41:17 | oilman | 1 | 48755 | 3 | 7.486 | 6512.8 |
| 487 | 2024-08-31 06:36:53 | oilman | 1 | 48755 | 3 | 5.923 | 8231.5 |
| 486 | 2024-08-28 14:22:50 | oilman | 1 | 48755 | 3 | 3.030 | 16090.8 |
| 485 | 2024-08-27 14:06:06 | oilman | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 484 | 2024-08-19 22:10:59 | oilman | 1 | 48755 | 3 | 5.873 | 8301.5 |
| 483 | 2024-08-15 04:15:18 | oilman | 1 | 48755 | 3 | 2.326 | 20960.9 |
| 482 | 2024-08-09 03:21:45 | oilman | 1 | 48755 | 3 | 3.220 | 15141.3 |
| 481 | 2024-08-02 11:14:28 | oilman | 3 | 112716 | 296 | 28.456 | 3961.1 |
| 480 | 2024-08-02 08:56:05 | oilman | 3 | 112716 | 296 | 27.893 | 4041.0 |
| 479 | 2024-07-31 19:47:02 | oilman | 3 | 112716 | 296 | 19.046 | 5918.1 |
| 478 | 2024-07-31 11:52:33 | oilman | 3 | 112716 | 296 | 15.343 | 7346.4 |
| 477 | 2024-07-31 11:23:17 | oilman | 2 | 82551 | 21 | 14.766 | 5590.6 |
| 476 | 2024-07-31 11:23:17 | oilman | 3 | 112716 | 296 | 12.563 | 8972.1 |
| 475 | 2024-07-31 11:23:10 | oilman | 1 | 48755 | 3 | 3.623 | 13457.1 |
| 474 | 2024-07-28 23:56:38 | oilman | 1 | 48755 | 3 | 2.936 | 16605.9 |
| 473 | 2024-07-28 11:58:47 | oilman | 1 | 48755 | 3 | 3.233 | 15080.4 |
| 472 | 2024-07-24 04:28:59 | oilman | 1 | 48755 | 3 | 1.470 | 33166.7 |
| 471 | 2024-07-13 15:37:14 | oilman | 1 | 48755 | 3 | 4.703 | 10366.8 |
| 470 | 2024-07-13 06:34:37 | oilman | 1 | 48755 | 3 | 2.623 | 18587.5 |
| 469 | 2024-07-02 20:28:42 | oilman | 1 | 48755 | 3 | 1.296 | 37619.6 |
| 468 | 2024-06-28 03:55:54 | oilman | 1 | 48755 | 3 | 4.780 | 10199.8 |
| 467 | 2024-06-28 02:13:24 | oilman | 1 | 48755 | 3 | 3.110 | 15676.8 |
| 466 | 2024-06-07 12:23:35 | oilman | 1 | 48755 | 3 | 2.796 | 17437.4 |
| 465 | 2024-06-04 02:00:03 | oilman | 1 | 48755 | 3 | 4.626 | 10539.3 |
| 464 | 2024-05-29 03:19:55 | oilman | 1 | 48755 | 3 | 4.093 | 11911.8 |
| 463 | 2024-05-28 22:15:30 | oilman | 1 | 48755 | 3 | 2.936 | 16605.9 |
| 462 | 2024-05-09 15:21:15 | oilman | 3 | 112716 | 296 | 12.733 | 8852.3 |
| 461 | 2024-05-09 15:01:33 | oilman | 3 | 112716 | 296 | 9.016 | 12501.8 |
| 460 | 2024-05-09 14:07:40 | oilman | 3 | 112716 | 296 | 9.343 | 12064.2 |
| 459 | 2024-05-09 13:48:42 | oilman | 3 | 112716 | 296 | 9.313 | 12103.1 |
| 458 | 2024-05-08 06:06:52 | oilman | 2 | 82551 | 21 | 2.966 | 27832.4 |
| 457 | 2024-05-08 06:05:59 | oilman | 3 | 112716 | 296 | 5.780 | 19501.0 |
| 456 | 2024-05-06 15:50:59 | oilman | 3 | 112716 | 296 | 10.610 | 10623.6 |
| 455 | 2024-05-05 21:58:15 | oilman | 2 | 82551 | 21 | 5.360 | 15401.3 |
| 454 | 2024-05-05 21:38:15 | oilman | 3 | 112716 | 296 | 9.250 | 12185.5 |
| 453 | 2024-05-05 07:02:00 | oilman | 2 | 82551 | 21 | 2.796 | 29524.7 |
| 452 | 2024-05-05 06:30:35 | oilman | 3 | 112716 | 296 | 6.390 | 17639.4 |
| 451 | 2024-05-05 00:37:12 | oilman | 2 | 82551 | 21 | 8.890 | 9285.8 |
| 450 | 2024-05-05 00:37:08 | oilman | 3 | 112716 | 296 | 11.596 | 9720.2 |
| 449 | 2024-05-05 00:36:53 | oilman | 3 | 112716 | 296 | 12.203 | 9236.7 |
| 448 | 2024-05-05 00:37:04 | oilman | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 447 | 2024-05-05 00:36:51 | oilman | 2 | 82551 | 21 | 8.236 | 10023.2 |
| 446 | 2024-05-05 00:36:46 | oilman | 1 | 48755 | 3 | 0.983 | 49598.2 |
| 445 | 2024-04-19 11:43:04 | oilman | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 444 | 2024-04-02 13:46:39 | oilman | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 443 | 2023-12-30 13:13:16 | oilman | 3 | 112716 | 296 | 5.640 | 19985.1 |
| 442 | 2023-12-30 13:13:12 | oilman | 2 | 82551 | 21 | 2.423 | 34069.7 |
| 441 | 2023-12-24 08:31:14 | oilman | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 440 | 2023-12-08 05:02:28 | oilman | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 439 | 2023-12-08 05:02:27 | oilman | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 438 | 2023-11-21 18:07:05 | oilman | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 437 | 2023-11-14 03:26:12 | oilman | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 436 | 2023-11-13 22:50:24 | oilman | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 435 | 2023-11-03 17:28:33 | oilman | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 434 | 2023-10-25 01:28:24 | oilman | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 433 | 2023-10-19 04:35:51 | oilman | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 432 | 2023-10-11 22:20:25 | oilman | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 431 | 2023-10-11 21:15:01 | oilman | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 430 | 2023-10-08 01:24:51 | oilman | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 429 | 2023-10-01 08:13:58 | oilman | 3 | 112716 | 296 | 6.093 | 18499.3 |
| 428 | 2023-09-28 01:07:49 | oilman | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 427 | 2023-09-27 05:25:18 | oilman | 3 | 112716 | 296 | 4.890 | 23050.3 |
| 426 | 2023-09-27 05:25:17 | oilman | 2 | 82551 | 21 | 2.376 | 34743.7 |
| 425 | 2023-09-12 19:01:25 | oilman | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 424 | 2023-08-08 03:37:46 | oilman | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 423 | 2023-07-19 17:31:11 | oilman | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 422 | 2023-05-05 20:32:41 | oilman | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 421 | 2023-03-28 00:21:57 | oilman | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 420 | 2023-03-01 10:30:19 | oilman | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 419 | 2022-12-27 04:05:19 | oilman | 1 | 48755 | 3 | 0.860 | 56691.9 |