History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mandate"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 499 | 2025-10-21 22:34:29 | mandate | 1 | 69583 | 3 | 5.936 | 11722.2 |
| 498 | 2025-10-21 09:53:45 | mandate | 1 | 69583 | 3 | 6.033 | 11533.7 |
| 497 | 2025-10-20 13:57:17 | mandate | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 496 | 2025-10-20 13:57:07 | mandate | 1 | 69583 | 3 | 5.406 | 12871.4 |
| 495 | 2025-10-17 06:42:44 | mandate | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 494 | 2025-10-16 23:34:09 | mandate | 1 | 69583 | 3 | 1.486 | 46825.7 |
| 493 | 2025-09-27 02:44:42 | mandate | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 492 | 2025-09-26 10:35:16 | mandate | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 491 | 2025-09-26 04:22:31 | mandate | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 490 | 2025-09-26 04:22:02 | mandate | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 489 | 2025-09-21 00:44:13 | mandate | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 488 | 2025-09-20 19:09:01 | mandate | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 487 | 2025-09-18 20:02:26 | mandate | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 486 | 2025-09-16 20:02:09 | mandate | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 485 | 2025-09-14 13:28:42 | mandate | 1 | 69583 | 3 | 1.436 | 48456.1 |
| 484 | 2025-08-29 11:56:55 | mandate | 2 | 107671 | 31 | 2.953 | 36461.6 |
| 483 | 2025-08-28 04:20:54 | mandate | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 482 | 2025-08-27 11:19:14 | mandate | 1 | 69583 | 3 | 1.610 | 43219.3 |
| 481 | 2025-08-24 09:28:30 | mandate | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 480 | 2025-08-11 02:38:50 | mandate | 1 | 69583 | 3 | 2.763 | 25183.9 |
| 479 | 2025-08-09 12:38:09 | mandate | 1 | 69583 | 3 | 6.983 | 9964.6 |
| 478 | 2025-08-06 22:37:54 | mandate | 3 | 134027 | 325 | 17.703 | 7570.9 |
| 477 | 2025-08-05 21:58:38 | mandate | 3 | 134027 | 325 | 16.470 | 8137.6 |
| 476 | 2025-08-05 19:27:38 | mandate | 3 | 134027 | 325 | 26.126 | 5130.0 |
| 475 | 2025-08-05 17:20:06 | mandate | 3 | 134027 | 325 | 17.296 | 7749.0 |
| 474 | 2025-08-05 16:33:28 | mandate | 3 | 134027 | 325 | 23.330 | 5744.8 |
| 473 | 2025-08-05 04:01:35 | mandate | 3 | 134027 | 325 | 16.016 | 8368.3 |
| 472 | 2025-08-05 01:31:35 | mandate | 3 | 134027 | 325 | 26.016 | 5151.7 |
| 471 | 2025-08-04 04:01:39 | mandate | 3 | 134027 | 325 | 33.160 | 4041.8 |
| 470 | 2025-08-04 01:52:55 | mandate | 1 | 69583 | 3 | 3.156 | 22047.8 |
| 469 | 2025-08-04 00:52:44 | mandate | 1 | 69583 | 3 | 4.576 | 15206.1 |
| 468 | 2025-08-03 09:15:04 | mandate | 3 | 134027 | 325 | 6.983 | 19193.3 |
| 467 | 2025-08-01 04:07:23 | mandate | 3 | 134027 | 325 | 18.003 | 7444.7 |
| 466 | 2025-07-31 23:52:39 | mandate | 2 | 107671 | 31 | 18.156 | 5930.3 |
| 465 | 2025-07-31 17:35:45 | mandate | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 464 | 2025-07-27 16:27:53 | mandate | 1 | 69583 | 3 | 4.453 | 15626.1 |
| 463 | 2025-07-24 17:14:52 | mandate | 1 | 69583 | 3 | 5.846 | 11902.7 |
| 462 | 2025-07-24 16:35:45 | mandate | 1 | 69583 | 3 | 3.123 | 22280.8 |
| 461 | 2025-07-23 15:26:29 | mandate | 1 | 69583 | 3 | 4.266 | 16311.1 |
| 460 | 2025-07-23 14:04:16 | mandate | 1 | 69583 | 3 | 3.530 | 19711.9 |
| 459 | 2025-07-23 04:41:48 | mandate | 1 | 69583 | 3 | 2.830 | 24587.6 |
| 458 | 2025-07-22 16:51:40 | mandate | 1 | 69583 | 3 | 6.373 | 10918.4 |
| 457 | 2025-07-22 13:44:25 | mandate | 1 | 69583 | 3 | 2.796 | 24886.6 |
| 456 | 2025-07-22 12:23:57 | mandate | 1 | 69583 | 3 | 3.126 | 22259.4 |
| 455 | 2025-07-22 00:56:04 | mandate | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 454 | 2025-07-10 10:13:41 | mandate | 1 | 69583 | 3 | 4.080 | 17054.7 |
| 453 | 2025-07-04 01:24:08 | mandate | 1 | 69583 | 3 | 6.373 | 10918.4 |
| 452 | 2025-07-03 03:45:23 | mandate | 2 | 107671 | 31 | 20.470 | 5259.9 |
| 451 | 2025-07-01 15:11:05 | mandate | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 450 | 2025-06-28 11:31:26 | mandate | 1 | 69583 | 3 | 6.110 | 11388.4 |
| 449 | 2025-06-22 19:23:54 | mandate | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 448 | 2025-06-20 01:17:54 | mandate | 1 | 69583 | 3 | 8.203 | 8482.6 |
| 447 | 2025-06-19 11:50:33 | mandate | 1 | 69583 | 3 | 12.283 | 5665.0 |
| 446 | 2025-06-15 04:01:05 | mandate | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 445 | 2025-06-11 06:29:37 | mandate | 3 | 134027 | 325 | 20.296 | 6603.6 |
| 444 | 2025-06-11 01:37:57 | mandate | 1 | 69583 | 3 | 1.376 | 50569.0 |
| 443 | 2025-06-10 16:46:26 | mandate | 3 | 134027 | 325 | 25.673 | 5220.5 |
| 442 | 2025-06-09 13:42:25 | mandate | 3 | 134027 | 325 | 7.233 | 18529.9 |
| 441 | 2025-06-08 07:41:29 | mandate | 3 | 134027 | 325 | 21.470 | 6242.5 |
| 440 | 2025-06-05 21:45:05 | mandate | 3 | 134027 | 325 | 17.313 | 7741.4 |
| 439 | 2025-06-04 00:11:41 | mandate | 1 | 69583 | 3 | 5.610 | 12403.4 |
| 438 | 2025-06-03 18:25:04 | mandate | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 437 | 2025-06-02 19:32:25 | mandate | 3 | 134027 | 325 | 5.906 | 22693.4 |
| 436 | 2025-06-02 02:36:09 | mandate | 3 | 134027 | 325 | 29.106 | 4604.8 |
| 435 | 2025-06-01 23:59:17 | mandate | 3 | 134027 | 325 | 22.470 | 5964.7 |
| 434 | 2025-06-01 21:10:35 | mandate | 3 | 134027 | 325 | 18.923 | 7082.8 |
| 433 | 2025-06-01 12:47:24 | mandate | 3 | 134027 | 325 | 7.500 | 17870.3 |
| 432 | 2025-05-31 17:50:09 | mandate | 1 | 69583 | 3 | 4.063 | 17126.0 |
| 431 | 2025-05-29 09:58:18 | mandate | 1 | 69583 | 3 | 2.780 | 25029.9 |
| 430 | 2025-05-24 20:01:18 | mandate | 1 | 69583 | 3 | 5.596 | 12434.4 |
| 429 | 2025-05-20 01:14:05 | mandate | 1 | 69583 | 3 | 6.440 | 10804.8 |
| 428 | 2025-05-19 11:29:52 | mandate | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 427 | 2025-05-15 22:41:44 | mandate | 2 | 107671 | 31 | 15.143 | 7110.3 |
| 426 | 2025-05-15 04:27:48 | mandate | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 425 | 2025-05-10 18:03:02 | mandate | 1 | 69583 | 3 | 4.140 | 16807.5 |
| 424 | 2025-05-08 01:32:08 | mandate | 1 | 69583 | 3 | 4.143 | 16795.3 |
| 423 | 2025-05-07 16:11:14 | mandate | 2 | 107671 | 31 | 6.220 | 17310.5 |
| 422 | 2025-05-02 15:04:55 | mandate | 3 | 134027 | 325 | 30.033 | 4462.7 |
| 421 | 2025-05-01 23:22:27 | mandate | 3 | 134027 | 325 | 37.236 | 3599.4 |
| 420 | 2025-05-01 08:07:03 | mandate | 3 | 134027 | 325 | 6.530 | 20524.8 |
| 419 | 2025-04-29 21:26:14 | mandate | 3 | 134027 | 325 | 31.686 | 4229.8 |
| 418 | 2025-04-29 20:51:02 | mandate | 3 | 134027 | 325 | 25.440 | 5268.4 |
| 417 | 2025-04-29 03:37:07 | mandate | 3 | 134027 | 325 | 6.140 | 21828.5 |
| 416 | 2025-04-28 10:19:27 | mandate | 1 | 69583 | 3 | 6.143 | 11327.2 |
| 415 | 2025-04-20 00:34:07 | mandate | 1 | 69583 | 3 | 3.453 | 20151.5 |
| 414 | 2025-04-16 11:00:50 | mandate | 1 | 69583 | 3 | 11.483 | 6059.7 |
| 413 | 2025-04-01 23:56:37 | mandate | 1 | 69583 | 3 | 5.923 | 11747.9 |
| 412 | 2025-03-20 01:47:43 | mandate | 1 | 69583 | 3 | 3.076 | 22621.3 |
| 411 | 2025-03-14 16:33:47 | mandate | 1 | 69583 | 3 | 7.140 | 9745.5 |
| 410 | 2025-03-14 06:11:22 | mandate | 1 | 69583 | 3 | 8.766 | 7937.8 |
| 409 | 2025-03-12 16:48:21 | mandate | 1 | 69583 | 3 | 5.546 | 12546.5 |
| 408 | 2025-03-12 16:46:18 | mandate | 2 | 107671 | 31 | 13.936 | 7726.1 |
| 407 | 2025-03-10 21:08:21 | mandate | 3 | 134027 | 325 | 41.750 | 3210.2 |
| 406 | 2025-03-10 17:38:37 | mandate | 3 | 134027 | 325 | 16.250 | 8247.8 |
| 405 | 2025-03-10 11:57:19 | mandate | 3 | 134027 | 325 | 33.970 | 3945.5 |
| 404 | 2025-03-10 11:15:09 | mandate | 3 | 134027 | 325 | 46.736 | 2867.7 |
| 403 | 2025-03-10 10:17:57 | mandate | 3 | 134027 | 325 | 29.533 | 4538.2 |
| 402 | 2025-03-10 08:33:13 | mandate | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 401 | 2025-03-08 03:03:31 | mandate | 1 | 69583 | 3 | 5.890 | 11813.8 |
| 400 | 2025-02-26 23:31:35 | mandate | 1 | 69583 | 3 | 3.513 | 19807.3 |