History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bollard"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 482 | 2025-10-22 17:18:39 | bollard | 1 | 69583 | 4 | 3.140 | 22160.2 |
| 481 | 2025-10-21 14:58:20 | bollard | 1 | 69583 | 4 | 4.593 | 15149.8 |
| 480 | 2025-10-21 14:58:14 | bollard | 1 | 69583 | 4 | 3.420 | 20345.9 |
| 479 | 2025-10-21 14:58:05 | bollard | 1 | 69583 | 4 | 7.813 | 8906.1 |
| 478 | 2025-10-21 14:57:57 | bollard | 1 | 69583 | 4 | 5.546 | 12546.5 |
| 477 | 2025-10-21 00:13:46 | bollard | 1 | 69583 | 4 | 2.733 | 25460.3 |
| 476 | 2025-10-01 04:28:49 | bollard | 1 | 69583 | 4 | 1.406 | 49490.0 |
| 475 | 2025-09-24 17:13:36 | bollard | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 474 | 2025-09-22 10:46:23 | bollard | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 473 | 2025-09-14 21:30:57 | bollard | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 472 | 2025-09-03 03:15:10 | bollard | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 471 | 2025-08-27 00:37:46 | bollard | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 470 | 2025-08-15 17:06:11 | bollard | 1 | 69583 | 4 | 2.750 | 25302.9 |
| 469 | 2025-08-12 07:57:59 | bollard | 1 | 69583 | 4 | 5.500 | 12651.5 |
| 468 | 2025-08-11 15:33:16 | bollard | 3 | 134027 | 209 | 16.830 | 7963.6 |
| 467 | 2025-08-09 17:53:40 | bollard | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 466 | 2025-08-06 01:53:31 | bollard | 3 | 134027 | 209 | 28.503 | 4702.2 |
| 465 | 2025-08-03 03:00:51 | bollard | 3 | 134027 | 209 | 32.110 | 4174.0 |
| 464 | 2025-08-03 02:57:49 | bollard | 2 | 107671 | 27 | 8.296 | 12978.7 |
| 463 | 2025-07-31 00:32:23 | bollard | 1 | 69583 | 4 | 1.283 | 54234.6 |
| 462 | 2025-07-28 01:32:12 | bollard | 3 | 134027 | 209 | 28.686 | 4672.2 |
| 461 | 2025-07-27 12:50:53 | bollard | 2 | 107671 | 27 | 8.423 | 12783.0 |
| 460 | 2025-07-27 01:21:47 | bollard | 3 | 134027 | 209 | 17.470 | 7671.8 |
| 459 | 2025-07-26 22:39:18 | bollard | 2 | 107671 | 27 | 12.546 | 8582.1 |
| 458 | 2025-07-26 20:41:47 | bollard | 1 | 69583 | 4 | 2.576 | 27012.0 |
| 457 | 2025-07-26 01:09:33 | bollard | 1 | 69583 | 4 | 1.096 | 63488.1 |
| 456 | 2025-07-25 12:49:46 | bollard | 1 | 69583 | 4 | 3.000 | 23194.3 |
| 455 | 2025-07-22 17:42:21 | bollard | 1 | 69583 | 4 | 3.033 | 22942.0 |
| 454 | 2025-07-19 15:59:31 | bollard | 1 | 69583 | 4 | 2.250 | 30925.8 |
| 453 | 2025-07-18 03:23:22 | bollard | 1 | 69583 | 4 | 6.233 | 11163.6 |
| 452 | 2025-07-13 11:05:07 | bollard | 2 | 107671 | 27 | 3.486 | 30886.7 |
| 451 | 2025-07-10 21:39:49 | bollard | 1 | 69583 | 4 | 2.983 | 23326.5 |
| 450 | 2025-07-10 05:45:36 | bollard | 2 | 107671 | 27 | 23.830 | 4518.3 |
| 449 | 2025-07-09 14:46:25 | bollard | 3 | 134027 | 209 | 26.283 | 5099.4 |
| 448 | 2025-07-09 14:16:12 | bollard | 3 | 134027 | 209 | 6.470 | 20715.1 |
| 447 | 2025-07-07 11:42:41 | bollard | 3 | 134027 | 209 | 19.283 | 6950.5 |
| 446 | 2025-06-23 02:19:35 | bollard | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 445 | 2025-06-21 22:05:23 | bollard | 2 | 107671 | 27 | 13.623 | 7903.6 |
| 444 | 2025-06-21 15:21:56 | bollard | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 443 | 2025-06-14 05:21:46 | bollard | 2 | 107671 | 27 | 17.533 | 6141.0 |
| 442 | 2025-06-10 05:03:06 | bollard | 1 | 69583 | 4 | 5.813 | 11970.2 |
| 441 | 2025-06-03 14:45:17 | bollard | 2 | 107671 | 27 | 3.343 | 32207.9 |
| 440 | 2025-05-28 06:26:15 | bollard | 1 | 69583 | 4 | 5.393 | 12902.5 |
| 439 | 2025-05-27 14:48:02 | bollard | 3 | 134027 | 209 | 28.690 | 4671.6 |
| 438 | 2025-05-26 18:12:28 | bollard | 1 | 69583 | 4 | 2.483 | 28023.8 |
| 437 | 2025-05-24 12:19:03 | bollard | 2 | 107671 | 27 | 16.923 | 6362.4 |
| 436 | 2025-05-23 23:14:22 | bollard | 3 | 134027 | 209 | 37.626 | 3562.1 |
| 435 | 2025-05-22 18:58:08 | bollard | 3 | 134027 | 209 | 7.033 | 19056.9 |
| 434 | 2025-05-21 22:51:03 | bollard | 2 | 107671 | 27 | 12.393 | 8688.0 |
| 433 | 2025-05-21 15:51:07 | bollard | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 432 | 2025-05-19 11:40:23 | bollard | 3 | 134027 | 209 | 11.470 | 11685.0 |
| 431 | 2025-05-18 18:19:29 | bollard | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 430 | 2025-05-18 01:01:21 | bollard | 1 | 69583 | 4 | 4.313 | 16133.3 |
| 429 | 2025-04-30 15:59:07 | bollard | 1 | 69583 | 4 | 7.876 | 8834.8 |
| 428 | 2025-04-22 23:59:56 | bollard | 1 | 69583 | 4 | 3.234 | 21516.1 |
| 427 | 2025-04-21 09:39:27 | bollard | 3 | 134027 | 209 | 29.143 | 4598.9 |
| 426 | 2025-04-20 14:44:53 | bollard | 1 | 69583 | 4 | 4.653 | 14954.4 |
| 425 | 2025-04-16 01:00:02 | bollard | 1 | 69583 | 4 | 5.796 | 12005.3 |
| 424 | 2025-04-11 17:15:00 | bollard | 1 | 69583 | 4 | 5.550 | 12537.5 |
| 423 | 2025-03-29 18:12:38 | bollard | 1 | 69583 | 4 | 3.030 | 22964.7 |
| 422 | 2025-03-29 05:36:27 | bollard | 1 | 69583 | 4 | 4.170 | 16686.6 |
| 421 | 2025-03-26 18:49:42 | bollard | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 420 | 2025-03-23 01:22:42 | bollard | 1 | 69583 | 4 | 3.936 | 17678.6 |
| 419 | 2025-03-16 17:21:42 | bollard | 1 | 69583 | 4 | 6.080 | 11444.6 |
| 418 | 2025-03-15 00:34:50 | bollard | 3 | 134027 | 209 | 26.016 | 5151.7 |
| 417 | 2025-03-13 07:01:52 | bollard | 3 | 134027 | 209 | 31.190 | 4297.1 |
| 416 | 2025-03-11 15:43:21 | bollard | 3 | 134027 | 209 | 28.846 | 4646.3 |
| 415 | 2025-03-11 12:35:05 | bollard | 3 | 134027 | 209 | 34.020 | 3939.7 |
| 414 | 2025-03-10 18:43:03 | bollard | 3 | 134027 | 209 | 47.536 | 2819.5 |
| 413 | 2025-03-10 14:10:56 | bollard | 3 | 134027 | 209 | 27.576 | 4860.3 |
| 412 | 2025-03-10 14:10:56 | bollard | 2 | 107671 | 27 | 11.720 | 9186.9 |
| 411 | 2025-03-10 12:59:18 | bollard | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 410 | 2025-03-07 16:20:47 | bollard | 1 | 69583 | 4 | 5.640 | 12337.4 |
| 409 | 2025-02-26 16:30:03 | bollard | 1 | 69583 | 4 | 2.843 | 24475.2 |
| 408 | 2025-02-26 10:44:49 | bollard | 1 | 69583 | 4 | 8.376 | 8307.4 |
| 407 | 2025-02-02 16:39:53 | bollard | 1 | 69583 | 4 | 5.796 | 12005.3 |
| 406 | 2025-01-27 21:52:13 | bollard | 1 | 69583 | 4 | 5.656 | 12302.5 |
| 405 | 2025-01-27 09:34:30 | bollard | 1 | 69583 | 4 | 3.093 | 22496.9 |
| 404 | 2025-01-26 14:56:47 | bollard | 1 | 69583 | 4 | 3.313 | 21003.0 |
| 403 | 2024-12-30 09:53:04 | bollard | 3 | 134027 | 209 | 22.313 | 6006.7 |
| 402 | 2024-12-28 03:14:26 | bollard | 3 | 134027 | 209 | 37.343 | 3589.1 |
| 401 | 2024-12-28 02:26:08 | bollard | 3 | 134027 | 209 | 31.703 | 4227.6 |
| 400 | 2024-12-28 01:54:43 | bollard | 3 | 134027 | 209 | 35.033 | 3825.7 |
| 399 | 2024-12-27 23:30:45 | bollard | 3 | 134027 | 209 | 39.550 | 3388.8 |
| 398 | 2024-12-24 05:43:32 | bollard | 1 | 69583 | 4 | 3.280 | 21214.3 |
| 397 | 2024-11-29 08:33:43 | bollard | 1 | 69583 | 4 | 2.890 | 24077.2 |
| 396 | 2024-11-28 10:52:23 | bollard | 3 | 134027 | 209 | 12.970 | 10333.6 |
| 395 | 2024-11-26 07:44:25 | bollard | 3 | 134027 | 209 | 36.033 | 3719.6 |
| 394 | 2024-11-26 07:42:48 | bollard | 2 | 107671 | 27 | 23.940 | 4497.5 |
| 393 | 2024-11-26 07:21:24 | bollard | 1 | 69583 | 4 | 3.906 | 17814.4 |
| 392 | 2024-11-26 02:22:16 | bollard | 3 | 134027 | 209 | 16.046 | 8352.7 |
| 391 | 2024-11-25 22:16:57 | bollard | 2 | 107671 | 27 | 8.110 | 13276.3 |
| 390 | 2024-11-25 22:16:29 | bollard | 3 | 134027 | 209 | 33.206 | 4036.2 |
| 389 | 2024-11-25 22:16:17 | bollard | 1 | 69583 | 4 | 3.860 | 18026.7 |
| 388 | 2024-11-21 15:24:01 | bollard | 1 | 69583 | 4 | 6.236 | 11158.3 |
| 387 | 2024-10-30 12:19:42 | bollard | 1 | 69583 | 4 | 3.310 | 21022.1 |
| 386 | 2024-10-28 23:25:35 | bollard | 1 | 69583 | 4 | 5.750 | 12101.4 |
| 385 | 2024-10-26 10:39:23 | bollard | 1 | 69583 | 4 | 6.720 | 10354.6 |
| 384 | 2024-10-26 03:52:28 | bollard | 3 | 134027 | 209 | 21.670 | 6184.9 |
| 383 | 2024-10-25 10:16:51 | bollard | 3 | 134027 | 209 | 31.453 | 4261.2 |