History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pierced"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 425 | 2025-09-07 15:34:44 | pierced | 1 | 69583 | 6 | 2.530 | 27503.2 |
| 424 | 2025-08-26 06:54:06 | pierced | 1 | 69583 | 6 | 8.453 | 8231.8 |
| 423 | 2025-08-24 06:45:11 | pierced | 1 | 69583 | 6 | 5.983 | 11630.1 |
| 422 | 2025-08-23 07:19:43 | pierced | 1 | 69583 | 6 | 5.936 | 11722.2 |
| 421 | 2025-08-15 16:19:11 | pierced | 1 | 69583 | 6 | 3.170 | 21950.5 |
| 420 | 2025-08-02 14:25:56 | pierced | 2 | 107671 | 25 | 7.376 | 14597.5 |
| 419 | 2025-08-02 14:25:48 | pierced | 2 | 107671 | 25 | 7.360 | 14629.2 |
| 418 | 2025-08-02 14:14:48 | pierced | 3 | 134027 | 306 | 32.063 | 4180.1 |
| 417 | 2025-08-02 14:14:44 | pierced | 3 | 134027 | 306 | 22.843 | 5867.3 |
| 416 | 2025-08-01 00:40:33 | pierced | 1 | 69583 | 6 | 2.986 | 23303.1 |
| 415 | 2025-07-31 19:43:57 | pierced | 3 | 134027 | 306 | 34.940 | 3835.9 |
| 414 | 2025-07-31 16:27:17 | pierced | 1 | 69583 | 6 | 4.266 | 16311.1 |
| 413 | 2025-07-30 16:38:36 | pierced | 2 | 107671 | 25 | 13.483 | 7985.7 |
| 412 | 2025-07-30 13:34:47 | pierced | 3 | 134027 | 306 | 18.923 | 7082.8 |
| 411 | 2025-07-29 13:00:57 | pierced | 2 | 107671 | 25 | 10.420 | 10333.1 |
| 410 | 2025-07-29 12:33:06 | pierced | 3 | 134027 | 306 | 18.780 | 7136.7 |
| 409 | 2025-07-27 00:35:38 | pierced | 2 | 107671 | 25 | 12.330 | 8732.4 |
| 408 | 2025-07-26 23:31:55 | pierced | 1 | 69583 | 6 | 3.330 | 20895.8 |
| 407 | 2025-07-23 08:01:25 | pierced | 1 | 69583 | 6 | 3.906 | 17814.4 |
| 406 | 2025-07-23 04:32:21 | pierced | 1 | 69583 | 6 | 2.750 | 25302.9 |
| 405 | 2025-07-22 19:58:19 | pierced | 1 | 69583 | 6 | 4.533 | 15350.3 |
| 404 | 2025-07-21 07:20:35 | pierced | 1 | 69583 | 6 | 1.106 | 62914.1 |
| 403 | 2025-07-19 22:59:45 | pierced | 2 | 107671 | 25 | 3.313 | 32499.5 |
| 402 | 2025-07-19 22:52:41 | pierced | 3 | 134027 | 306 | 6.453 | 20769.7 |
| 401 | 2025-07-17 21:55:54 | pierced | 1 | 69583 | 6 | 3.623 | 19205.9 |
| 400 | 2025-07-14 08:36:59 | pierced | 1 | 69583 | 6 | 5.813 | 11970.2 |
| 399 | 2025-07-12 07:26:09 | pierced | 3 | 134027 | 306 | 6.360 | 21073.4 |
| 398 | 2025-07-10 10:50:41 | pierced | 3 | 134027 | 306 | 21.546 | 6220.5 |
| 397 | 2025-07-09 18:29:40 | pierced | 1 | 69583 | 6 | 1.283 | 54234.6 |
| 396 | 2025-07-08 18:08:56 | pierced | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 395 | 2025-06-27 15:00:47 | pierced | 1 | 69583 | 6 | 5.610 | 12403.4 |
| 394 | 2025-06-22 21:38:02 | pierced | 2 | 107671 | 25 | 3.356 | 32083.1 |
| 393 | 2025-06-21 07:08:02 | pierced | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 392 | 2025-06-21 06:23:14 | pierced | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 391 | 2025-06-20 04:06:55 | pierced | 3 | 134027 | 306 | 33.486 | 4002.5 |
| 390 | 2025-06-19 21:18:07 | pierced | 3 | 134027 | 306 | 23.690 | 5657.5 |
| 389 | 2025-06-19 20:55:57 | pierced | 3 | 134027 | 306 | 6.423 | 20866.7 |
| 388 | 2025-06-18 15:37:14 | pierced | 3 | 134027 | 306 | 37.296 | 3593.6 |
| 387 | 2025-06-14 07:40:29 | pierced | 1 | 69583 | 6 | 5.626 | 12368.1 |
| 386 | 2025-06-14 07:28:41 | pierced | 1 | 69583 | 6 | 7.516 | 9258.0 |
| 385 | 2025-06-12 15:51:17 | pierced | 3 | 134027 | 306 | 45.983 | 2914.7 |
| 384 | 2025-06-10 10:19:22 | pierced | 3 | 134027 | 306 | 29.533 | 4538.2 |
| 383 | 2025-06-08 17:45:22 | pierced | 1 | 69583 | 6 | 6.750 | 10308.6 |
| 382 | 2025-05-31 16:36:49 | pierced | 3 | 134027 | 306 | 28.076 | 4773.7 |
| 381 | 2025-05-31 06:11:17 | pierced | 1 | 69583 | 6 | 5.470 | 12720.8 |
| 380 | 2025-05-30 03:21:26 | pierced | 2 | 107671 | 25 | 3.876 | 27778.9 |
| 379 | 2025-05-30 01:02:36 | pierced | 3 | 134027 | 306 | 9.470 | 14152.8 |
| 378 | 2025-05-29 19:17:51 | pierced | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 377 | 2025-05-24 11:25:20 | pierced | 2 | 107671 | 25 | 16.890 | 6374.8 |
| 376 | 2025-05-22 00:48:37 | pierced | 1 | 69583 | 6 | 5.860 | 11874.2 |
| 375 | 2025-05-20 07:39:32 | pierced | 1 | 69583 | 6 | 9.000 | 7731.4 |
| 374 | 2025-05-18 07:45:28 | pierced | 1 | 69583 | 6 | 3.046 | 22844.1 |
| 373 | 2025-05-12 07:35:02 | pierced | 1 | 69583 | 6 | 8.203 | 8482.6 |
| 372 | 2025-05-11 09:26:47 | pierced | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 371 | 2025-05-10 20:02:41 | pierced | 1 | 69583 | 6 | 3.063 | 22717.3 |
| 370 | 2025-05-08 07:28:32 | pierced | 1 | 69583 | 6 | 6.143 | 11327.2 |
| 369 | 2025-05-02 19:09:43 | pierced | 1 | 69583 | 6 | 1.280 | 54361.7 |
| 368 | 2025-05-02 13:44:54 | pierced | 1 | 69583 | 6 | 3.266 | 21305.3 |
| 367 | 2025-04-20 07:04:02 | pierced | 1 | 69583 | 6 | 5.360 | 12981.9 |
| 366 | 2025-04-19 19:53:11 | pierced | 1 | 69583 | 6 | 5.406 | 12871.4 |
| 365 | 2025-04-18 08:37:09 | pierced | 3 | 134027 | 306 | 17.406 | 7700.0 |
| 364 | 2025-04-15 21:30:03 | pierced | 2 | 107671 | 25 | 22.703 | 4742.6 |
| 363 | 2025-04-15 04:11:00 | pierced | 2 | 107671 | 25 | 15.453 | 6967.6 |
| 362 | 2025-04-14 02:37:55 | pierced | 3 | 134027 | 306 | 52.130 | 2571.0 |
| 361 | 2025-04-12 17:49:54 | pierced | 3 | 134027 | 306 | 7.203 | 18607.1 |
| 360 | 2025-04-12 07:17:19 | pierced | 3 | 134027 | 306 | 33.393 | 4013.6 |
| 359 | 2025-04-12 01:55:46 | pierced | 3 | 134027 | 306 | 47.736 | 2807.7 |
| 358 | 2025-04-11 00:32:39 | pierced | 1 | 69583 | 6 | 5.250 | 13253.9 |
| 357 | 2025-04-10 06:19:52 | pierced | 2 | 107671 | 25 | 3.516 | 30623.2 |
| 356 | 2025-04-10 04:46:03 | pierced | 3 | 134027 | 306 | 7.016 | 19103.1 |
| 355 | 2025-04-08 06:10:46 | pierced | 1 | 69583 | 6 | 1.313 | 52995.4 |
| 354 | 2025-04-06 17:03:49 | pierced | 1 | 69583 | 6 | 5.360 | 12981.9 |
| 353 | 2025-04-05 05:30:00 | pierced | 1 | 69583 | 6 | 2.486 | 27989.9 |
| 352 | 2025-03-20 09:19:30 | pierced | 1 | 69583 | 6 | 7.110 | 9786.6 |
| 351 | 2025-03-18 10:47:19 | pierced | 1 | 69583 | 6 | 3.763 | 18491.4 |
| 350 | 2025-03-15 18:04:05 | pierced | 1 | 69583 | 6 | 5.750 | 12101.4 |
| 349 | 2025-03-11 11:03:33 | pierced | 1 | 69583 | 6 | 7.640 | 9107.7 |
| 348 | 2025-03-10 04:11:57 | pierced | 2 | 107671 | 25 | 15.156 | 7104.2 |
| 347 | 2025-03-10 03:28:07 | pierced | 1 | 69583 | 6 | 10.813 | 6435.1 |
| 346 | 2025-03-08 22:59:18 | pierced | 1 | 69583 | 6 | 1.296 | 53690.6 |
| 345 | 2025-03-08 19:13:05 | pierced | 3 | 134027 | 306 | 40.080 | 3344.0 |
| 344 | 2025-03-08 17:47:31 | pierced | 3 | 134027 | 306 | 68.940 | 1944.1 |
| 343 | 2025-03-07 19:31:53 | pierced | 3 | 134027 | 306 | 33.393 | 4013.6 |
| 342 | 2025-03-07 01:20:12 | pierced | 3 | 134027 | 306 | 29.906 | 4481.6 |
| 341 | 2025-03-06 04:13:12 | pierced | 3 | 134027 | 306 | 33.923 | 3950.9 |
| 340 | 2025-03-05 03:48:11 | pierced | 3 | 134027 | 306 | 22.610 | 5927.8 |
| 339 | 2025-03-02 17:26:29 | pierced | 1 | 69583 | 6 | 7.970 | 8730.6 |
| 338 | 2025-02-27 22:30:00 | pierced | 1 | 69583 | 6 | 8.906 | 7813.0 |
| 337 | 2025-01-15 05:20:29 | pierced | 3 | 134027 | 306 | 16.596 | 8075.9 |
| 336 | 2025-01-14 16:05:21 | pierced | 3 | 134027 | 306 | 24.846 | 5394.3 |
| 335 | 2025-01-14 16:05:31 | pierced | 2 | 107671 | 25 | 14.673 | 7338.0 |
| 334 | 2025-01-14 16:04:34 | pierced | 1 | 69583 | 6 | 6.656 | 10454.2 |
| 333 | 2025-01-06 07:55:39 | pierced | 1 | 69583 | 6 | 5.250 | 13253.9 |
| 332 | 2024-12-29 06:13:28 | pierced | 1 | 69583 | 6 | 3.016 | 23071.3 |
| 331 | 2024-12-15 11:55:00 | pierced | 1 | 69583 | 6 | 6.656 | 10454.2 |
| 330 | 2024-11-28 09:35:25 | pierced | 1 | 69583 | 6 | 5.876 | 11841.9 |
| 329 | 2024-11-12 13:07:00 | pierced | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 328 | 2024-11-09 02:50:48 | pierced | 2 | 107671 | 25 | 8.156 | 13201.4 |
| 327 | 2024-11-07 18:10:45 | pierced | 2 | 107671 | 25 | 13.063 | 8242.4 |
| 326 | 2024-11-07 12:34:51 | pierced | 2 | 107671 | 25 | 3.233 | 33303.7 |