History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pennants"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 413 | 2025-11-12 01:44:34 | pennants | 1 | 82945 | 3 | 1.703 | 48705.2 |
| 412 | 2025-11-04 23:31:45 | pennants | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 411 | 2025-11-04 16:32:45 | pennants | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 410 | 2025-10-28 12:46:51 | pennants | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 409 | 2025-10-28 03:54:38 | pennants | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 408 | 2025-10-22 00:40:44 | pennants | 1 | 82945 | 3 | 7.593 | 10923.9 |
| 407 | 2025-10-10 05:07:32 | pennants | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 406 | 2025-10-03 01:07:36 | pennants | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 405 | 2025-09-22 16:40:45 | pennants | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 404 | 2025-09-14 09:49:20 | pennants | 1 | 82945 | 3 | 1.936 | 42843.5 |
| 403 | 2025-09-13 22:43:14 | pennants | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 402 | 2025-09-02 23:08:50 | pennants | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 401 | 2025-08-22 19:49:20 | pennants | 1 | 82945 | 3 | 7.343 | 11295.8 |
| 400 | 2025-08-16 21:56:07 | pennants | 1 | 82945 | 3 | 6.640 | 12491.7 |
| 399 | 2025-08-10 11:13:35 | pennants | 1 | 82945 | 3 | 3.140 | 26415.6 |
| 398 | 2025-08-03 22:44:40 | pennants | 1 | 82945 | 3 | 5.703 | 14544.1 |
| 397 | 2025-07-28 21:54:35 | pennants | 3 | 146162 | 130 | 31.580 | 4628.3 |
| 396 | 2025-07-28 05:00:31 | pennants | 3 | 146162 | 130 | 29.360 | 4978.3 |
| 395 | 2025-07-26 23:20:25 | pennants | 1 | 82945 | 3 | 4.550 | 18229.7 |
| 394 | 2025-07-25 23:15:35 | pennants | 3 | 146162 | 130 | 13.530 | 10802.8 |
| 393 | 2025-07-25 12:56:34 | pennants | 1 | 82945 | 3 | 3.283 | 25265.0 |
| 392 | 2025-07-22 03:16:00 | pennants | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 391 | 2025-07-15 22:44:18 | pennants | 2 | 121059 | 16 | 3.813 | 31749.0 |
| 390 | 2025-07-09 23:49:18 | pennants | 1 | 82945 | 3 | 6.093 | 13613.2 |
| 389 | 2025-07-08 10:22:09 | pennants | 1 | 82945 | 3 | 9.440 | 8786.5 |
| 388 | 2025-07-06 11:45:54 | pennants | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 387 | 2025-06-29 21:13:26 | pennants | 1 | 82945 | 3 | 3.706 | 22381.3 |
| 386 | 2025-06-25 22:14:51 | pennants | 2 | 121059 | 16 | 22.843 | 5299.6 |
| 385 | 2025-06-24 16:31:33 | pennants | 1 | 82945 | 3 | 6.716 | 12350.4 |
| 384 | 2025-06-23 00:25:50 | pennants | 1 | 82945 | 3 | 9.080 | 9134.9 |
| 383 | 2025-06-22 22:51:47 | pennants | 3 | 146162 | 130 | 30.396 | 4808.6 |
| 382 | 2025-06-20 20:10:16 | pennants | 3 | 146162 | 130 | 33.800 | 4324.3 |
| 381 | 2025-06-20 10:12:35 | pennants | 1 | 82945 | 3 | 4.936 | 16804.1 |
| 380 | 2025-06-18 12:29:52 | pennants | 3 | 146162 | 130 | 22.910 | 6379.8 |
| 379 | 2025-06-16 19:19:14 | pennants | 3 | 146162 | 130 | 29.953 | 4879.7 |
| 378 | 2025-06-16 03:07:56 | pennants | 1 | 82945 | 3 | 7.153 | 11595.8 |
| 377 | 2025-06-15 14:00:32 | pennants | 3 | 146162 | 130 | 30.110 | 4854.3 |
| 376 | 2025-06-15 05:30:43 | pennants | 2 | 121059 | 16 | 16.266 | 7442.5 |
| 375 | 2025-06-13 23:22:51 | pennants | 1 | 82945 | 3 | 7.266 | 11415.5 |
| 374 | 2025-06-09 22:38:42 | pennants | 1 | 82945 | 3 | 10.283 | 8066.2 |
| 373 | 2025-06-07 09:50:45 | pennants | 1 | 82945 | 3 | 6.610 | 12548.4 |
| 372 | 2025-06-03 19:00:44 | pennants | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 371 | 2025-05-28 10:13:32 | pennants | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 370 | 2025-05-15 05:41:39 | pennants | 2 | 121059 | 16 | 4.046 | 29920.7 |
| 369 | 2025-05-13 23:24:31 | pennants | 1 | 82945 | 3 | 5.440 | 15247.2 |
| 368 | 2025-05-13 14:00:24 | pennants | 3 | 146162 | 130 | 43.266 | 3378.2 |
| 367 | 2025-05-12 15:10:17 | pennants | 3 | 146162 | 130 | 39.143 | 3734.1 |
| 366 | 2025-05-11 12:03:37 | pennants | 3 | 146162 | 130 | 7.843 | 18636.0 |
| 365 | 2025-05-11 01:22:04 | pennants | 2 | 121059 | 16 | 21.423 | 5650.9 |
| 364 | 2025-05-08 09:30:11 | pennants | 1 | 82945 | 3 | 7.346 | 11291.2 |
| 363 | 2025-05-07 22:10:32 | pennants | 1 | 82945 | 3 | 8.950 | 9267.6 |
| 362 | 2025-05-01 02:21:34 | pennants | 1 | 82945 | 3 | 9.826 | 8441.4 |
| 361 | 2025-04-30 13:50:49 | pennants | 2 | 121059 | 16 | 26.453 | 4576.4 |
| 360 | 2025-04-29 02:14:35 | pennants | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 359 | 2025-04-23 16:13:43 | pennants | 1 | 82945 | 3 | 10.906 | 7605.4 |
| 358 | 2025-04-08 12:46:19 | pennants | 1 | 82945 | 3 | 2.186 | 37943.7 |
| 357 | 2025-04-01 21:40:29 | pennants | 1 | 82945 | 3 | 7.050 | 11765.2 |
| 356 | 2025-03-29 03:10:10 | pennants | 1 | 82945 | 3 | 7.046 | 11771.9 |
| 355 | 2025-03-20 17:57:52 | pennants | 1 | 82945 | 3 | 5.890 | 14082.3 |
| 354 | 2025-03-20 10:26:08 | pennants | 1 | 82945 | 3 | 4.763 | 17414.4 |
| 353 | 2025-03-14 05:31:48 | pennants | 1 | 82945 | 3 | 8.826 | 9397.8 |
| 352 | 2025-03-13 21:13:59 | pennants | 1 | 82945 | 3 | 3.953 | 20982.8 |
| 351 | 2025-03-08 08:35:14 | pennants | 1 | 82945 | 3 | 10.376 | 7993.9 |
| 350 | 2025-02-25 19:22:44 | pennants | 1 | 82945 | 3 | 3.203 | 25896.0 |
| 349 | 2025-02-18 20:18:41 | pennants | 1 | 82945 | 3 | 8.563 | 9686.4 |
| 348 | 2025-02-14 16:27:06 | pennants | 1 | 82945 | 3 | 6.393 | 12974.3 |
| 347 | 2025-02-08 12:28:38 | pennants | 1 | 82945 | 3 | 4.503 | 18419.9 |
| 346 | 2025-02-03 23:46:08 | pennants | 3 | 146162 | 130 | 12.406 | 11781.6 |
| 345 | 2025-02-03 22:18:55 | pennants | 3 | 146162 | 130 | 48.143 | 3036.0 |
| 344 | 2025-02-03 22:12:02 | pennants | 3 | 146162 | 130 | 22.253 | 6568.2 |
| 343 | 2025-02-01 11:01:04 | pennants | 3 | 146162 | 130 | 27.813 | 5255.2 |
| 342 | 2025-02-01 11:01:04 | pennants | 2 | 121059 | 16 | 10.376 | 11667.2 |
| 341 | 2025-02-01 11:01:02 | pennants | 1 | 82945 | 3 | 5.703 | 14544.1 |
| 340 | 2025-01-28 23:27:27 | pennants | 1 | 82945 | 3 | 5.703 | 14544.1 |
| 339 | 2025-01-08 18:10:28 | pennants | 1 | 82945 | 3 | 4.983 | 16645.6 |
| 338 | 2025-01-07 18:54:04 | pennants | 1 | 82945 | 3 | 10.656 | 7783.9 |
| 337 | 2024-12-28 10:27:36 | pennants | 1 | 82945 | 3 | 1.610 | 51518.6 |
| 336 | 2024-12-22 03:02:41 | pennants | 2 | 121059 | 16 | 17.046 | 7101.9 |
| 335 | 2024-12-22 03:01:39 | pennants | 1 | 82945 | 3 | 7.156 | 11591.0 |
| 334 | 2024-12-08 21:36:42 | pennants | 3 | 146162 | 130 | 41.160 | 3551.1 |
| 333 | 2024-12-06 08:54:13 | pennants | 3 | 146162 | 130 | 40.360 | 3621.5 |
| 332 | 2024-12-06 07:49:55 | pennants | 3 | 146162 | 130 | 60.896 | 2400.2 |
| 331 | 2024-12-06 00:50:00 | pennants | 3 | 146162 | 130 | 26.826 | 5448.5 |
| 330 | 2024-12-06 00:50:01 | pennants | 2 | 121059 | 16 | 11.420 | 10600.6 |
| 329 | 2024-12-04 13:26:04 | pennants | 1 | 82945 | 3 | 4.966 | 16702.6 |
| 328 | 2024-12-04 03:19:10 | pennants | 1 | 82945 | 3 | 4.373 | 18967.5 |
| 327 | 2024-11-20 09:46:05 | pennants | 1 | 82945 | 3 | 7.250 | 11440.7 |
| 326 | 2024-11-12 16:18:23 | pennants | 2 | 121059 | 16 | 19.686 | 6149.5 |
| 325 | 2024-11-04 19:57:21 | pennants | 2 | 121059 | 16 | 4.030 | 30039.5 |
| 324 | 2024-11-03 17:22:43 | pennants | 1 | 82945 | 3 | 5.686 | 14587.6 |
| 323 | 2024-11-01 20:18:38 | pennants | 3 | 146162 | 130 | 34.970 | 4179.6 |
| 322 | 2024-11-01 20:18:53 | pennants | 2 | 121059 | 16 | 9.733 | 12438.0 |
| 321 | 2024-11-01 20:18:44 | pennants | 1 | 82945 | 3 | 3.453 | 24021.1 |
| 320 | 2024-11-01 06:36:04 | pennants | 3 | 146162 | 130 | 37.516 | 3896.0 |
| 319 | 2024-10-31 05:47:53 | pennants | 3 | 146162 | 130 | 29.910 | 4886.7 |
| 318 | 2024-10-31 00:48:05 | pennants | 3 | 146162 | 130 | 6.686 | 21860.9 |
| 317 | 2024-10-31 00:48:03 | pennants | 2 | 121059 | 16 | 3.390 | 35710.6 |
| 316 | 2024-10-20 10:22:45 | pennants | 1 | 82945 | 3 | 4.406 | 18825.5 |
| 315 | 2024-10-19 21:46:46 | pennants | 1 | 82945 | 3 | 6.686 | 12405.8 |
| 314 | 2024-10-14 06:44:03 | pennants | 1 | 82945 | 3 | 7.060 | 11748.6 |