History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pennant"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 430 | 2025-10-26 00:44:20 | pennant | 3 | 134027 | 188 | 5.970 | 22450.1 |
| 429 | 2025-10-23 22:25:12 | pennant | 3 | 134027 | 188 | 6.300 | 21274.1 |
| 428 | 2025-10-12 19:24:26 | pennant | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 427 | 2025-09-30 14:54:20 | pennant | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 426 | 2025-09-18 22:09:04 | pennant | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 425 | 2025-08-29 02:53:33 | pennant | 3 | 134027 | 188 | 5.940 | 22563.5 |
| 424 | 2025-08-27 06:23:40 | pennant | 3 | 134027 | 188 | 7.000 | 19146.7 |
| 423 | 2025-08-27 04:01:38 | pennant | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 422 | 2025-08-24 11:10:46 | pennant | 1 | 69583 | 3 | 5.826 | 11943.5 |
| 421 | 2025-08-23 01:12:47 | pennant | 1 | 69583 | 3 | 5.830 | 11935.3 |
| 420 | 2025-08-10 20:23:14 | pennant | 1 | 69583 | 3 | 2.170 | 32065.9 |
| 419 | 2025-08-09 07:38:17 | pennant | 3 | 134027 | 188 | 48.426 | 2767.7 |
| 418 | 2025-08-07 16:45:31 | pennant | 1 | 69583 | 3 | 5.156 | 13495.5 |
| 417 | 2025-08-06 00:55:39 | pennant | 2 | 107671 | 24 | 13.576 | 7931.0 |
| 416 | 2025-08-05 05:46:15 | pennant | 3 | 134027 | 188 | 17.016 | 7876.5 |
| 415 | 2025-08-04 13:16:43 | pennant | 1 | 69583 | 3 | 2.920 | 23829.8 |
| 414 | 2025-08-01 04:32:14 | pennant | 3 | 134027 | 188 | 28.703 | 4669.4 |
| 413 | 2025-07-31 22:28:38 | pennant | 3 | 134027 | 188 | 24.906 | 5381.3 |
| 412 | 2025-07-29 00:52:19 | pennant | 3 | 134027 | 188 | 23.000 | 5827.3 |
| 411 | 2025-07-28 16:50:04 | pennant | 2 | 107671 | 24 | 8.313 | 12952.1 |
| 410 | 2025-07-27 10:34:31 | pennant | 1 | 69583 | 3 | 5.106 | 13627.7 |
| 409 | 2025-07-27 00:48:56 | pennant | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 408 | 2025-07-26 06:39:22 | pennant | 3 | 134027 | 188 | 23.876 | 5613.5 |
| 407 | 2025-07-25 05:31:17 | pennant | 1 | 69583 | 3 | 3.110 | 22374.0 |
| 406 | 2025-07-24 10:44:19 | pennant | 3 | 134027 | 188 | 26.600 | 5038.6 |
| 405 | 2025-07-24 06:21:20 | pennant | 1 | 69583 | 3 | 6.690 | 10401.0 |
| 404 | 2025-07-22 04:05:08 | pennant | 3 | 134027 | 188 | 32.346 | 4143.5 |
| 403 | 2025-07-21 22:41:30 | pennant | 3 | 134027 | 188 | 6.640 | 20184.8 |
| 402 | 2025-07-21 12:45:26 | pennant | 3 | 134027 | 188 | 12.533 | 10693.9 |
| 401 | 2025-07-19 12:47:11 | pennant | 1 | 69583 | 3 | 1.376 | 50569.0 |
| 400 | 2025-07-19 08:53:44 | pennant | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 399 | 2025-07-19 03:24:44 | pennant | 1 | 69583 | 3 | 2.406 | 28920.6 |
| 398 | 2025-07-18 20:21:10 | pennant | 3 | 134027 | 188 | 34.940 | 3835.9 |
| 397 | 2025-07-18 17:49:37 | pennant | 3 | 134027 | 188 | 23.813 | 5628.3 |
| 396 | 2025-07-18 01:45:58 | pennant | 1 | 69583 | 3 | 6.626 | 10501.5 |
| 395 | 2025-07-17 03:22:31 | pennant | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 394 | 2025-07-16 09:26:50 | pennant | 3 | 134027 | 188 | 16.330 | 8207.4 |
| 393 | 2025-07-11 21:29:29 | pennant | 1 | 69583 | 3 | 6.250 | 11133.3 |
| 392 | 2025-06-22 07:21:18 | pennant | 1 | 69583 | 3 | 3.000 | 23194.3 |
| 391 | 2025-06-20 05:57:42 | pennant | 1 | 69583 | 3 | 7.360 | 9454.2 |
| 390 | 2025-06-19 17:43:25 | pennant | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 389 | 2025-06-16 20:42:08 | pennant | 1 | 69583 | 3 | 2.986 | 23303.1 |
| 388 | 2025-06-14 14:01:24 | pennant | 1 | 69583 | 3 | 5.953 | 11688.7 |
| 387 | 2025-06-14 12:33:50 | pennant | 3 | 134027 | 188 | 27.783 | 4824.1 |
| 386 | 2025-06-13 14:21:59 | pennant | 3 | 134027 | 188 | 7.733 | 17331.8 |
| 385 | 2025-06-13 08:20:09 | pennant | 3 | 134027 | 188 | 29.500 | 4543.3 |
| 384 | 2025-06-12 07:02:41 | pennant | 3 | 134027 | 188 | 38.110 | 3516.8 |
| 383 | 2025-06-11 13:05:29 | pennant | 2 | 107671 | 24 | 8.576 | 12554.9 |
| 382 | 2025-06-11 12:29:09 | pennant | 3 | 134027 | 188 | 33.003 | 4061.1 |
| 381 | 2025-06-08 20:53:19 | pennant | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 380 | 2025-05-31 09:23:36 | pennant | 1 | 69583 | 3 | 6.000 | 11597.2 |
| 379 | 2025-05-22 07:35:48 | pennant | 1 | 69583 | 3 | 5.313 | 13096.7 |
| 378 | 2025-05-18 10:26:18 | pennant | 1 | 69583 | 3 | 3.000 | 23194.3 |
| 377 | 2025-05-16 20:33:04 | pennant | 1 | 69583 | 3 | 1.813 | 38380.0 |
| 376 | 2025-05-16 02:12:31 | pennant | 1 | 69583 | 3 | 9.063 | 7677.7 |
| 375 | 2025-05-13 15:13:53 | pennant | 2 | 107671 | 24 | 3.593 | 29966.9 |
| 374 | 2025-05-13 14:32:23 | pennant | 3 | 134027 | 188 | 6.593 | 20328.7 |
| 373 | 2025-05-13 05:34:46 | pennant | 2 | 107671 | 24 | 14.610 | 7369.7 |
| 372 | 2025-05-11 12:37:07 | pennant | 3 | 134027 | 188 | 44.563 | 3007.6 |
| 371 | 2025-05-11 12:30:58 | pennant | 2 | 107671 | 24 | 14.453 | 7449.7 |
| 370 | 2025-05-02 13:32:10 | pennant | 1 | 69583 | 3 | 7.466 | 9320.0 |
| 369 | 2025-04-29 11:54:58 | pennant | 3 | 134027 | 188 | 13.313 | 10067.4 |
| 368 | 2025-04-24 03:33:51 | pennant | 2 | 107671 | 24 | 14.186 | 7589.9 |
| 367 | 2025-04-23 18:59:59 | pennant | 3 | 134027 | 188 | 12.736 | 10523.5 |
| 366 | 2025-04-22 22:53:43 | pennant | 3 | 134027 | 188 | 31.953 | 4194.5 |
| 365 | 2025-04-22 15:26:11 | pennant | 3 | 134027 | 188 | 6.690 | 20033.9 |
| 364 | 2025-04-22 06:11:23 | pennant | 3 | 134027 | 188 | 8.296 | 16155.6 |
| 363 | 2025-04-21 09:03:02 | pennant | 3 | 134027 | 188 | 50.676 | 2644.8 |
| 362 | 2025-04-21 06:12:51 | pennant | 3 | 134027 | 188 | 34.426 | 3893.2 |
| 361 | 2025-04-20 10:54:15 | pennant | 3 | 134027 | 188 | 24.733 | 5419.0 |
| 360 | 2025-04-16 10:12:05 | pennant | 1 | 69583 | 3 | 2.966 | 23460.2 |
| 359 | 2025-04-16 01:14:50 | pennant | 1 | 69583 | 3 | 6.030 | 11539.5 |
| 358 | 2025-04-15 20:53:55 | pennant | 1 | 69583 | 3 | 2.936 | 23699.9 |
| 357 | 2025-04-11 03:38:34 | pennant | 1 | 69583 | 3 | 6.203 | 11217.6 |
| 356 | 2025-04-07 10:49:19 | pennant | 1 | 69583 | 3 | 7.046 | 9875.5 |
| 355 | 2025-04-05 16:51:16 | pennant | 3 | 134027 | 188 | 19.283 | 6950.5 |
| 354 | 2025-03-27 16:07:17 | pennant | 3 | 134027 | 188 | 36.066 | 3716.2 |
| 353 | 2025-03-23 15:03:41 | pennant | 3 | 134027 | 188 | 31.706 | 4227.2 |
| 352 | 2025-03-22 08:30:32 | pennant | 3 | 134027 | 188 | 34.203 | 3918.6 |
| 351 | 2025-03-21 22:07:15 | pennant | 2 | 107671 | 24 | 3.436 | 31336.1 |
| 350 | 2025-03-21 22:01:28 | pennant | 3 | 134027 | 188 | 33.890 | 3954.8 |
| 349 | 2025-03-21 15:06:05 | pennant | 3 | 134027 | 188 | 35.956 | 3727.5 |
| 348 | 2025-03-21 15:06:07 | pennant | 2 | 107671 | 24 | 16.923 | 6362.4 |
| 347 | 2025-03-20 08:20:41 | pennant | 1 | 69583 | 3 | 5.826 | 11943.5 |
| 346 | 2025-03-19 13:42:39 | pennant | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 345 | 2025-03-18 13:25:06 | pennant | 3 | 134027 | 188 | 54.643 | 2452.8 |
| 344 | 2025-03-18 13:20:35 | pennant | 2 | 107671 | 24 | 19.783 | 5442.6 |
| 343 | 2025-03-17 23:58:59 | pennant | 3 | 134027 | 188 | 40.346 | 3321.9 |
| 342 | 2025-03-16 20:06:39 | pennant | 1 | 69583 | 3 | 5.376 | 12943.3 |
| 341 | 2025-03-15 19:28:10 | pennant | 3 | 134027 | 188 | 27.780 | 4824.6 |
| 340 | 2025-03-15 19:28:09 | pennant | 2 | 107671 | 24 | 17.906 | 6013.1 |
| 339 | 2025-03-15 19:27:36 | pennant | 1 | 69583 | 3 | 6.876 | 10119.7 |
| 338 | 2025-03-12 18:17:15 | pennant | 1 | 69583 | 3 | 8.860 | 7853.6 |
| 337 | 2025-03-11 19:30:15 | pennant | 1 | 69583 | 3 | 8.750 | 7952.3 |
| 336 | 2025-03-07 04:51:39 | pennant | 1 | 69583 | 3 | 6.283 | 11074.8 |
| 335 | 2025-02-12 03:34:34 | pennant | 1 | 69583 | 3 | 2.953 | 23563.5 |
| 334 | 2025-01-07 20:51:00 | pennant | 1 | 69583 | 3 | 6.330 | 10992.6 |
| 333 | 2024-12-19 18:17:24 | pennant | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 332 | 2024-12-10 04:44:21 | pennant | 1 | 69583 | 3 | 5.796 | 12005.3 |
| 331 | 2024-12-07 05:03:44 | pennant | 1 | 69583 | 3 | 9.063 | 7677.7 |