History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bandana"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 487 | 2025-10-29 14:59:00 | bandana | 2 | 107671 | 25 | 3.766 | 28590.3 |
| 486 | 2025-10-27 04:08:49 | bandana | 1 | 69583 | 4 | 1.356 | 51314.9 |
| 485 | 2025-10-19 19:54:12 | bandana | 1 | 69583 | 4 | 7.156 | 9723.7 |
| 484 | 2025-09-30 16:51:14 | bandana | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 483 | 2025-09-28 14:50:19 | bandana | 3 | 134027 | 172 | 6.530 | 20524.8 |
| 482 | 2025-09-26 04:27:50 | bandana | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 481 | 2025-09-14 09:48:36 | bandana | 3 | 134027 | 172 | 5.953 | 22514.2 |
| 480 | 2025-09-13 21:14:21 | bandana | 3 | 134027 | 172 | 7.220 | 18563.3 |
| 479 | 2025-09-09 19:16:23 | bandana | 2 | 107671 | 25 | 3.500 | 30763.1 |
| 478 | 2025-09-09 17:05:42 | bandana | 2 | 107671 | 25 | 3.373 | 31921.4 |
| 477 | 2025-09-08 10:43:05 | bandana | 3 | 134027 | 172 | 6.763 | 19817.7 |
| 476 | 2025-09-08 10:10:21 | bandana | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 475 | 2025-09-02 12:57:46 | bandana | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 474 | 2025-08-06 07:56:43 | bandana | 1 | 69583 | 4 | 2.623 | 26528.0 |
| 473 | 2025-08-05 07:46:04 | bandana | 3 | 134027 | 172 | 15.343 | 8735.4 |
| 472 | 2025-08-01 17:25:44 | bandana | 2 | 107671 | 25 | 24.626 | 4372.2 |
| 471 | 2025-07-31 07:22:03 | bandana | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 470 | 2025-07-27 03:06:21 | bandana | 1 | 69583 | 4 | 3.560 | 19545.8 |
| 469 | 2025-07-27 02:39:05 | bandana | 1 | 69583 | 4 | 2.813 | 24736.2 |
| 468 | 2025-07-26 08:49:46 | bandana | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 467 | 2025-07-25 00:23:43 | bandana | 1 | 69583 | 4 | 6.156 | 11303.3 |
| 466 | 2025-07-20 15:48:44 | bandana | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 465 | 2025-07-19 07:05:30 | bandana | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 464 | 2025-07-17 23:15:15 | bandana | 1 | 69583 | 4 | 4.873 | 14279.3 |
| 463 | 2025-07-16 02:29:06 | bandana | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 462 | 2025-07-05 10:23:56 | bandana | 3 | 134027 | 172 | 32.156 | 4168.0 |
| 461 | 2025-07-03 08:03:18 | bandana | 3 | 134027 | 172 | 36.740 | 3648.0 |
| 460 | 2025-07-01 18:43:17 | bandana | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 459 | 2025-06-30 04:10:53 | bandana | 3 | 134027 | 172 | 46.580 | 2877.4 |
| 458 | 2025-06-29 07:13:33 | bandana | 1 | 69583 | 4 | 2.906 | 23944.6 |
| 457 | 2025-06-23 21:26:59 | bandana | 2 | 107671 | 25 | 14.283 | 7538.4 |
| 456 | 2025-06-18 09:04:27 | bandana | 1 | 69583 | 4 | 5.250 | 13253.9 |
| 455 | 2025-06-12 17:02:14 | bandana | 1 | 69583 | 4 | 3.093 | 22496.9 |
| 454 | 2025-05-31 05:07:37 | bandana | 1 | 69583 | 4 | 5.686 | 12237.6 |
| 453 | 2025-05-22 07:09:51 | bandana | 1 | 69583 | 4 | 8.216 | 8469.2 |
| 452 | 2025-05-19 23:29:01 | bandana | 1 | 69583 | 4 | 5.080 | 13697.4 |
| 451 | 2025-05-18 09:39:47 | bandana | 1 | 69583 | 4 | 3.250 | 21410.2 |
| 450 | 2025-05-17 12:30:02 | bandana | 1 | 69583 | 4 | 8.206 | 8479.5 |
| 449 | 2025-05-14 08:44:20 | bandana | 1 | 69583 | 4 | 5.686 | 12237.6 |
| 448 | 2025-04-27 09:26:34 | bandana | 1 | 69583 | 4 | 2.453 | 28366.5 |
| 447 | 2025-04-19 22:33:25 | bandana | 1 | 69583 | 4 | 6.233 | 11163.6 |
| 446 | 2025-04-18 09:04:56 | bandana | 1 | 69583 | 4 | 6.236 | 11158.3 |
| 445 | 2025-04-15 22:47:41 | bandana | 2 | 107671 | 25 | 12.736 | 8454.1 |
| 444 | 2025-04-15 12:36:26 | bandana | 1 | 69583 | 4 | 6.266 | 11104.9 |
| 443 | 2025-04-14 07:07:00 | bandana | 1 | 69583 | 4 | 6.080 | 11444.6 |
| 442 | 2025-03-31 02:15:11 | bandana | 1 | 69583 | 4 | 7.406 | 9395.5 |
| 441 | 2025-03-26 09:00:56 | bandana | 1 | 69583 | 4 | 5.643 | 12330.9 |
| 440 | 2025-03-24 19:56:15 | bandana | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 439 | 2025-03-23 09:21:03 | bandana | 1 | 69583 | 4 | 2.906 | 23944.6 |
| 438 | 2025-03-19 23:54:20 | bandana | 1 | 69583 | 4 | 5.876 | 11841.9 |
| 437 | 2025-03-12 15:38:34 | bandana | 1 | 69583 | 4 | 8.173 | 8513.8 |
| 436 | 2025-03-10 20:53:24 | bandana | 1 | 69583 | 4 | 5.513 | 12621.6 |
| 435 | 2025-03-10 08:34:44 | bandana | 1 | 69583 | 4 | 4.346 | 16010.8 |
| 434 | 2025-03-08 17:42:07 | bandana | 1 | 69583 | 4 | 7.733 | 8998.2 |
| 433 | 2025-02-26 08:15:13 | bandana | 1 | 69583 | 4 | 2.826 | 24622.4 |
| 432 | 2025-02-07 11:45:38 | bandana | 3 | 134027 | 172 | 24.093 | 5562.9 |
| 431 | 2025-02-02 05:35:38 | bandana | 2 | 107671 | 25 | 12.300 | 8753.7 |
| 430 | 2025-02-02 05:35:23 | bandana | 1 | 69583 | 4 | 3.000 | 23194.3 |
| 429 | 2025-02-01 01:27:23 | bandana | 3 | 134027 | 172 | 35.706 | 3753.6 |
| 428 | 2025-02-01 00:36:36 | bandana | 3 | 134027 | 172 | 37.610 | 3563.6 |
| 427 | 2025-01-30 16:47:27 | bandana | 3 | 134027 | 172 | 45.016 | 2977.3 |
| 426 | 2025-01-30 16:47:30 | bandana | 2 | 107671 | 25 | 16.610 | 6482.3 |
| 425 | 2025-01-30 16:46:00 | bandana | 1 | 69583 | 4 | 4.860 | 14317.5 |
| 424 | 2025-01-06 03:10:09 | bandana | 1 | 69583 | 4 | 2.623 | 26528.0 |
| 423 | 2024-12-29 17:36:59 | bandana | 1 | 69583 | 4 | 5.220 | 13330.1 |
| 422 | 2024-12-14 06:54:26 | bandana | 1 | 69583 | 4 | 6.110 | 11388.4 |
| 421 | 2024-11-29 11:50:08 | bandana | 1 | 69583 | 4 | 5.690 | 12229.0 |
| 420 | 2024-11-27 10:17:28 | bandana | 1 | 69583 | 4 | 3.033 | 22942.0 |
| 419 | 2024-11-19 22:30:12 | bandana | 1 | 69583 | 4 | 3.233 | 21522.7 |
| 418 | 2024-10-28 09:01:40 | bandana | 3 | 134027 | 172 | 28.580 | 4689.5 |
| 417 | 2024-10-28 08:46:12 | bandana | 3 | 134027 | 172 | 31.750 | 4221.3 |
| 416 | 2024-10-28 06:19:01 | bandana | 3 | 134027 | 172 | 41.406 | 3236.9 |
| 415 | 2024-10-28 06:19:02 | bandana | 2 | 107671 | 25 | 24.956 | 4314.4 |
| 414 | 2024-10-28 05:01:45 | bandana | 1 | 69583 | 4 | 2.766 | 25156.5 |
| 413 | 2024-10-22 20:12:08 | bandana | 1 | 69583 | 4 | 5.970 | 11655.4 |
| 412 | 2024-10-16 19:02:24 | bandana | 1 | 69583 | 4 | 8.643 | 8050.8 |
| 411 | 2024-09-21 07:29:42 | bandana | 1 | 69583 | 4 | 4.610 | 15093.9 |
| 410 | 2024-09-20 00:58:57 | bandana | 1 | 69583 | 4 | 3.126 | 22259.4 |
| 409 | 2024-09-04 02:39:39 | bandana | 1 | 69583 | 4 | 10.000 | 6958.3 |
| 408 | 2024-09-01 07:54:14 | bandana | 1 | 69583 | 4 | 7.393 | 9412.0 |
| 407 | 2024-09-01 07:52:48 | bandana | 1 | 69583 | 4 | 8.393 | 8290.6 |
| 406 | 2024-08-17 09:26:33 | bandana | 1 | 69583 | 4 | 5.140 | 13537.5 |
| 405 | 2024-08-15 17:24:57 | bandana | 1 | 69583 | 4 | 8.200 | 8485.7 |
| 404 | 2024-08-13 20:11:03 | bandana | 3 | 134027 | 172 | 65.526 | 2045.4 |
| 403 | 2024-08-09 10:49:39 | bandana | 3 | 134027 | 172 | 24.156 | 5548.4 |
| 402 | 2024-08-02 08:48:37 | bandana | 1 | 69583 | 4 | 2.623 | 26528.0 |
| 401 | 2024-07-29 05:49:15 | bandana | 3 | 134027 | 172 | 74.973 | 1787.7 |
| 400 | 2024-07-29 04:28:02 | bandana | 3 | 134027 | 172 | 22.470 | 5964.7 |
| 399 | 2024-07-28 17:49:50 | bandana | 3 | 134027 | 172 | 21.173 | 6330.1 |
| 398 | 2024-07-28 01:23:04 | bandana | 3 | 134027 | 172 | 11.610 | 11544.1 |
| 397 | 2024-07-26 19:59:11 | bandana | 3 | 134027 | 172 | 25.690 | 5217.1 |
| 396 | 2024-07-18 22:25:27 | bandana | 1 | 69583 | 4 | 4.500 | 15462.9 |
| 395 | 2024-07-14 02:24:36 | bandana | 1 | 69583 | 4 | 3.560 | 19545.8 |
| 394 | 2024-07-13 18:07:19 | bandana | 1 | 69583 | 4 | 2.860 | 24329.7 |
| 393 | 2024-07-09 09:15:55 | bandana | 1 | 69583 | 4 | 4.500 | 15462.9 |
| 392 | 2024-07-01 15:37:26 | bandana | 1 | 69583 | 4 | 2.640 | 26357.2 |
| 391 | 2024-07-01 12:31:48 | bandana | 1 | 69583 | 4 | 2.000 | 34791.5 |
| 390 | 2024-06-20 15:19:38 | bandana | 1 | 69583 | 4 | 2.360 | 29484.3 |
| 389 | 2024-06-18 17:05:30 | bandana | 1 | 69583 | 4 | 4.813 | 14457.3 |
| 388 | 2024-06-15 08:20:06 | bandana | 3 | 134027 | 172 | 25.186 | 5321.5 |