History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trainer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 498 | 2024-04-23 22:59:40 | trainer | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 497 | 2024-04-21 05:58:23 | trainer | 1 | 69583 | 8 | 1.780 | 39091.6 |
| 496 | 2024-04-20 23:11:04 | trainer | 1 | 69583 | 8 | 2.890 | 24077.2 |
| 495 | 2024-04-16 03:04:40 | trainer | 3 | 134027 | 673 | 8.063 | 16622.5 |
| 494 | 2024-03-25 23:41:43 | trainer | 2 | 107671 | 63 | 4.033 | 26697.5 |
| 493 | 2024-03-25 23:25:54 | trainer | 3 | 134027 | 673 | 7.986 | 16782.7 |
| 492 | 2024-03-25 17:33:09 | trainer | 3 | 134027 | 673 | 9.626 | 13923.4 |
| 491 | 2024-03-20 19:42:22 | trainer | 3 | 134027 | 673 | 7.013 | 19111.2 |
| 490 | 2024-03-20 19:42:18 | trainer | 2 | 107671 | 63 | 6.843 | 15734.5 |
| 489 | 2024-03-20 19:41:46 | trainer | 1 | 69583 | 8 | 2.300 | 30253.5 |
| 488 | 2024-03-20 19:41:24 | trainer | 3 | 134027 | 673 | 7.326 | 18294.7 |
| 487 | 2024-03-20 19:41:28 | trainer | 2 | 107671 | 63 | 3.513 | 30649.3 |
| 486 | 2024-03-20 19:40:58 | trainer | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 485 | 2024-03-15 15:16:20 | trainer | 1 | 69583 | 8 | 1.033 | 67360.1 |
| 484 | 2024-02-21 11:28:12 | trainer | 3 | 134027 | 673 | 19.360 | 6922.9 |
| 483 | 2024-02-18 08:13:46 | trainer | 3 | 134027 | 673 | 17.093 | 7841.0 |
| 482 | 2024-02-18 08:13:44 | trainer | 2 | 107671 | 63 | 11.893 | 9053.3 |
| 481 | 2024-02-18 03:37:32 | trainer | 1 | 69583 | 8 | 1.190 | 58473.1 |
| 480 | 2024-01-26 17:22:49 | trainer | 1 | 69583 | 8 | 1.373 | 50679.5 |
| 479 | 2024-01-16 13:11:58 | trainer | 1 | 69583 | 8 | 1.393 | 49951.9 |
| 478 | 2024-01-07 14:47:18 | trainer | 2 | 107671 | 63 | 3.016 | 35699.9 |
| 477 | 2024-01-02 16:30:32 | trainer | 1 | 69583 | 8 | 1.236 | 56296.9 |
| 476 | 2023-12-22 18:01:55 | trainer | 1 | 69583 | 8 | 1.170 | 59472.6 |
| 475 | 2023-12-10 13:52:51 | trainer | 3 | 134027 | 673 | 6.563 | 20421.6 |
| 474 | 2023-12-10 00:59:08 | trainer | 3 | 134027 | 673 | 6.296 | 21287.6 |
| 473 | 2023-12-10 00:59:11 | trainer | 2 | 107671 | 63 | 3.216 | 33479.8 |
| 472 | 2023-12-03 18:51:46 | trainer | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 471 | 2023-12-03 18:51:44 | trainer | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 470 | 2023-12-02 04:31:36 | trainer | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 469 | 2023-11-11 05:54:53 | trainer | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 468 | 2023-11-06 19:50:22 | trainer | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 467 | 2023-11-05 01:59:14 | trainer | 1 | 69583 | 8 | 2.453 | 28366.5 |
| 466 | 2023-10-24 08:04:13 | trainer | 1 | 69583 | 8 | 1.170 | 59472.6 |
| 465 | 2023-10-15 17:52:14 | trainer | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 464 | 2023-10-13 09:47:32 | trainer | 2 | 107671 | 63 | 2.873 | 37476.9 |
| 463 | 2023-09-26 02:00:17 | trainer | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 462 | 2023-09-10 20:09:25 | trainer | 1 | 69583 | 8 | 2.453 | 28366.5 |
| 461 | 2023-09-10 19:59:13 | trainer | 3 | 134027 | 673 | 8.576 | 15628.1 |
| 460 | 2023-09-07 00:27:44 | trainer | 3 | 134027 | 673 | 5.796 | 23124.1 |
| 459 | 2023-08-19 18:59:54 | trainer | 1 | 69583 | 8 | 2.343 | 29698.3 |
| 458 | 2023-08-13 10:03:49 | trainer | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 457 | 2023-08-09 12:24:03 | trainer | 3 | 134027 | 673 | 7.096 | 18887.7 |
| 456 | 2023-07-23 12:52:25 | trainer | 2 | 107671 | 63 | 2.860 | 37647.2 |
| 455 | 2023-07-14 03:01:42 | trainer | 3 | 134027 | 673 | 6.986 | 19185.1 |
| 454 | 2023-07-09 17:58:34 | trainer | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 453 | 2023-05-22 17:38:32 | trainer | 3 | 134027 | 673 | 5.936 | 22578.7 |
| 452 | 2023-05-20 08:39:17 | trainer | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 451 | 2023-04-28 15:44:37 | trainer | 1 | 69583 | 8 | 1.110 | 62687.4 |
| 450 | 2023-04-05 02:42:59 | trainer | 2 | 107671 | 63 | 2.830 | 38046.3 |
| 449 | 2023-03-18 01:34:09 | trainer | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 448 | 2023-03-02 12:47:59 | trainer | 3 | 134027 | 673 | 6.720 | 19944.5 |
| 447 | 2023-01-23 19:21:19 | trainer | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 446 | 2023-01-05 17:11:25 | trainer | 1 | 69583 | 8 | 1.060 | 65644.3 |
| 445 | 2023-01-03 20:11:02 | trainer | 2 | 107671 | 63 | 3.063 | 35152.1 |
| 444 | 2022-12-20 04:46:07 | trainer | 3 | 134027 | 673 | 10.846 | 12357.3 |
| 443 | 2022-12-11 11:33:35 | trainer | 3 | 134027 | 673 | 5.856 | 22887.1 |
| 442 | 2022-11-26 15:49:06 | trainer | 3 | 134027 | 673 | 6.843 | 19586.0 |
| 441 | 2022-11-20 23:47:21 | trainer | 3 | 134027 | 673 | 5.876 | 22809.2 |
| 440 | 2022-11-07 12:14:14 | trainer | 3 | 134027 | 673 | 6.123 | 21889.1 |
| 439 | 2022-11-05 19:08:49 | trainer | 3 | 134027 | 673 | 5.966 | 22465.1 |
| 438 | 2022-10-11 14:23:53 | trainer | 3 | 134027 | 673 | 6.173 | 21711.8 |
| 437 | 2022-10-01 07:46:05 | trainer | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 436 | 2022-09-14 06:52:20 | trainer | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 435 | 2022-09-09 22:13:28 | trainer | 2 | 107671 | 63 | 2.860 | 37647.2 |
| 434 | 2022-09-01 11:48:08 | trainer | 3 | 134027 | 673 | 7.106 | 18861.1 |
| 433 | 2022-09-01 05:16:08 | trainer | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 432 | 2022-07-27 20:37:49 | trainer | 3 | 134027 | 673 | 6.890 | 19452.4 |
| 431 | 2022-05-15 11:35:17 | trainer | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 430 | 2022-05-12 02:30:50 | trainer | 1 | 69583 | 8 | 1.516 | 45899.1 |
| 429 | 2022-03-31 03:16:47 | trainer | 2 | 107671 | 63 | 3.860 | 27894.0 |
| 428 | 2022-02-01 07:48:06 | trainer | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 427 | 2022-01-30 02:48:01 | trainer | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 426 | 2022-01-24 10:03:50 | trainer | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 425 | 2021-12-13 18:00:07 | trainer | 2 | 107671 | 63 | 3.436 | 31336.1 |
| 424 | 2021-11-21 03:50:08 | trainer | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 423 | 2021-11-19 02:12:38 | trainer | 1 | 69583 | 8 | 1.300 | 53525.4 |
| 422 | 2021-10-14 10:16:58 | trainer | 1 | 69583 | 8 | 1.263 | 55093.4 |
| 421 | 2021-10-08 23:19:13 | trainer | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 420 | 2021-10-06 21:48:00 | trainer | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 419 | 2021-09-25 09:24:20 | trainer | 1 | 69583 | 8 | 1.123 | 61961.7 |
| 418 | 2021-09-21 02:43:09 | trainer | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 417 | 2021-09-17 19:13:43 | trainer | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 416 | 2021-07-13 09:08:02 | trainer | 1 | 69583 | 8 | 1.280 | 54361.7 |
| 415 | 2021-05-29 11:03:31 | trainer | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 414 | 2021-05-17 18:18:25 | trainer | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 413 | 2021-05-03 23:27:13 | trainer | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 412 | 2021-04-09 22:43:41 | trainer | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 411 | 2021-04-02 02:40:05 | trainer | 1 | 69583 | 8 | 1.313 | 52995.4 |
| 410 | 2021-01-17 02:56:10 | trainer | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 409 | 2020-12-24 07:05:35 | trainer | 1 | 69583 | 8 | 1.096 | 63488.1 |
| 408 | 2020-12-01 17:43:14 | trainer | 1 | 69583 | 8 | 1.110 | 62687.4 |
| 407 | 2020-11-20 23:21:29 | trainer | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 406 | 2020-09-20 11:40:48 | trainer | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 405 | 2020-08-27 07:28:48 | trainer | 1 | 69583 | 8 | 1.110 | 62687.4 |
| 404 | 2020-08-07 20:07:44 | trainer | 1 | 69583 | 8 | 1.143 | 60877.5 |
| 403 | 2020-07-31 11:39:25 | trainer | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 402 | 2020-06-10 01:20:33 | trainer | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 401 | 2020-06-09 04:32:48 | trainer | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 400 | 2020-06-08 01:16:44 | trainer | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 399 | 2020-06-07 01:44:46 | trainer | 1 | 69583 | 8 | 1.280 | 54361.7 |