History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spirier"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 475 | 2025-10-29 13:09:46 | spirier | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 474 | 2025-10-29 10:01:23 | spirier | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 473 | 2025-10-08 06:23:48 | spirier | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 472 | 2025-10-07 22:29:08 | spirier | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 471 | 2025-10-01 12:19:37 | spirier | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 470 | 2025-09-29 15:20:04 | spirier | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 469 | 2025-09-17 06:37:42 | spirier | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 468 | 2025-09-08 13:16:10 | spirier | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 467 | 2025-09-07 20:09:19 | spirier | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 466 | 2025-08-25 06:45:56 | spirier | 1 | 69583 | 5 | 4.280 | 16257.7 |
| 465 | 2025-08-24 09:31:58 | spirier | 1 | 69583 | 5 | 5.906 | 11781.7 |
| 464 | 2025-08-22 14:43:18 | spirier | 2 | 107671 | 64 | 3.503 | 30736.8 |
| 463 | 2025-08-20 14:44:58 | spirier | 2 | 107671 | 64 | 2.890 | 37256.4 |
| 462 | 2025-08-18 16:00:56 | spirier | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 461 | 2025-08-17 00:44:12 | spirier | 1 | 69583 | 5 | 2.626 | 26497.7 |
| 460 | 2025-08-16 22:44:37 | spirier | 1 | 69583 | 5 | 3.110 | 22374.0 |
| 459 | 2025-08-11 21:40:03 | spirier | 1 | 69583 | 5 | 3.046 | 22844.1 |
| 458 | 2025-08-04 09:47:04 | spirier | 2 | 107671 | 64 | 8.813 | 12217.3 |
| 457 | 2025-08-03 15:00:41 | spirier | 3 | 134027 | 679 | 7.936 | 16888.5 |
| 456 | 2025-08-03 07:41:03 | spirier | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 455 | 2025-08-01 06:58:51 | spirier | 1 | 69583 | 5 | 3.033 | 22942.0 |
| 454 | 2025-07-28 18:04:42 | spirier | 3 | 134027 | 679 | 46.203 | 2900.8 |
| 453 | 2025-07-28 07:04:21 | spirier | 2 | 107671 | 64 | 7.516 | 14325.6 |
| 452 | 2025-07-26 21:48:47 | spirier | 1 | 69583 | 5 | 4.546 | 15306.4 |
| 451 | 2025-07-26 01:56:40 | spirier | 3 | 134027 | 679 | 6.250 | 21444.3 |
| 450 | 2025-07-25 06:21:19 | spirier | 1 | 69583 | 5 | 5.390 | 12909.6 |
| 449 | 2025-07-23 07:26:04 | spirier | 3 | 134027 | 679 | 46.160 | 2903.5 |
| 448 | 2025-07-23 03:58:44 | spirier | 1 | 69583 | 5 | 2.483 | 28023.8 |
| 447 | 2025-07-22 23:40:56 | spirier | 1 | 69583 | 5 | 5.346 | 13015.9 |
| 446 | 2025-07-19 01:49:51 | spirier | 3 | 134027 | 679 | 7.576 | 17691.0 |
| 445 | 2025-07-18 05:26:07 | spirier | 3 | 134027 | 679 | 41.203 | 3252.8 |
| 444 | 2025-07-17 17:57:00 | spirier | 3 | 134027 | 679 | 40.650 | 3297.1 |
| 443 | 2025-07-16 21:01:39 | spirier | 2 | 107671 | 64 | 10.953 | 9830.3 |
| 442 | 2025-07-14 18:18:57 | spirier | 2 | 107671 | 64 | 22.236 | 4842.2 |
| 441 | 2025-07-14 11:54:51 | spirier | 2 | 107671 | 64 | 18.436 | 5840.3 |
| 440 | 2025-07-14 10:10:53 | spirier | 3 | 134027 | 679 | 42.066 | 3186.1 |
| 439 | 2025-07-14 00:22:47 | spirier | 3 | 134027 | 679 | 26.906 | 4981.3 |
| 438 | 2025-07-13 01:50:27 | spirier | 1 | 69583 | 5 | 1.376 | 50569.0 |
| 437 | 2025-07-12 22:34:32 | spirier | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 436 | 2025-07-12 18:49:23 | spirier | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 435 | 2025-07-12 13:08:06 | spirier | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 434 | 2025-06-24 13:52:12 | spirier | 1 | 69583 | 5 | 6.720 | 10354.6 |
| 433 | 2025-06-22 06:53:36 | spirier | 1 | 69583 | 5 | 8.516 | 8170.9 |
| 432 | 2025-06-20 11:47:30 | spirier | 1 | 69583 | 5 | 5.843 | 11908.8 |
| 431 | 2025-06-12 01:15:43 | spirier | 1 | 69583 | 5 | 6.093 | 11420.2 |
| 430 | 2025-06-09 22:34:15 | spirier | 1 | 69583 | 5 | 4.266 | 16311.1 |
| 429 | 2025-06-06 04:17:48 | spirier | 1 | 69583 | 5 | 6.253 | 11127.9 |
| 428 | 2025-05-20 13:58:30 | spirier | 1 | 69583 | 5 | 5.326 | 13064.8 |
| 427 | 2025-05-18 18:47:05 | spirier | 1 | 69583 | 5 | 5.500 | 12651.5 |
| 426 | 2025-05-17 05:51:50 | spirier | 1 | 69583 | 5 | 9.843 | 7069.3 |
| 425 | 2025-05-12 01:08:28 | spirier | 1 | 69583 | 5 | 6.110 | 11388.4 |
| 424 | 2025-05-09 22:37:24 | spirier | 1 | 69583 | 5 | 6.513 | 10683.7 |
| 423 | 2025-04-27 13:48:41 | spirier | 3 | 134027 | 679 | 11.873 | 11288.4 |
| 422 | 2025-04-23 03:57:56 | spirier | 3 | 134027 | 679 | 42.206 | 3175.5 |
| 421 | 2025-04-22 23:57:55 | spirier | 3 | 134027 | 679 | 44.173 | 3034.1 |
| 420 | 2025-04-21 16:47:17 | spirier | 3 | 134027 | 679 | 43.623 | 3072.4 |
| 419 | 2025-04-21 15:34:44 | spirier | 2 | 107671 | 64 | 13.170 | 8175.5 |
| 418 | 2025-04-20 11:47:58 | spirier | 1 | 69583 | 5 | 4.983 | 13964.1 |
| 417 | 2025-04-20 09:15:57 | spirier | 1 | 69583 | 5 | 4.560 | 15259.4 |
| 416 | 2025-04-20 06:12:37 | spirier | 1 | 69583 | 5 | 5.920 | 11753.9 |
| 415 | 2025-04-19 20:13:21 | spirier | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 414 | 2025-04-14 02:41:49 | spirier | 1 | 69583 | 5 | 8.436 | 8248.3 |
| 413 | 2025-04-11 00:50:26 | spirier | 1 | 69583 | 5 | 6.233 | 11163.6 |
| 412 | 2025-04-09 11:09:31 | spirier | 2 | 107671 | 64 | 20.406 | 5276.4 |
| 411 | 2025-04-07 22:15:08 | spirier | 1 | 69583 | 5 | 5.830 | 11935.3 |
| 410 | 2025-03-29 23:00:40 | spirier | 1 | 69583 | 5 | 8.986 | 7743.5 |
| 409 | 2025-03-20 11:40:02 | spirier | 1 | 69583 | 5 | 7.670 | 9072.1 |
| 408 | 2025-03-18 10:48:04 | spirier | 3 | 134027 | 679 | 29.970 | 4472.0 |
| 407 | 2025-03-18 10:21:41 | spirier | 3 | 134027 | 679 | 31.250 | 4288.9 |
| 406 | 2025-03-17 09:49:47 | spirier | 1 | 69583 | 5 | 4.500 | 15462.9 |
| 405 | 2025-03-17 06:47:51 | spirier | 3 | 134027 | 679 | 35.470 | 3778.6 |
| 404 | 2025-03-16 21:26:43 | spirier | 2 | 107671 | 64 | 14.923 | 7215.1 |
| 403 | 2025-03-16 20:54:15 | spirier | 3 | 134027 | 679 | 39.470 | 3395.7 |
| 402 | 2025-03-16 15:22:47 | spirier | 1 | 69583 | 5 | 4.233 | 16438.2 |
| 401 | 2025-03-16 13:33:43 | spirier | 3 | 134027 | 679 | 41.080 | 3262.6 |
| 400 | 2025-03-16 13:33:42 | spirier | 2 | 107671 | 64 | 24.016 | 4483.3 |
| 399 | 2025-03-14 08:46:51 | spirier | 1 | 69583 | 5 | 3.390 | 20526.0 |
| 398 | 2025-03-10 07:18:07 | spirier | 1 | 69583 | 5 | 5.610 | 12403.4 |
| 397 | 2025-03-07 21:15:34 | spirier | 1 | 69583 | 5 | 5.983 | 11630.1 |
| 396 | 2025-02-13 10:08:43 | spirier | 1 | 69583 | 5 | 3.313 | 21003.0 |
| 395 | 2025-02-01 05:44:06 | spirier | 1 | 69583 | 5 | 9.500 | 7324.5 |
| 394 | 2025-01-29 08:51:10 | spirier | 1 | 69583 | 5 | 6.140 | 11332.7 |
| 393 | 2025-01-26 04:32:20 | spirier | 2 | 107671 | 64 | 11.000 | 9788.3 |
| 392 | 2025-01-26 01:42:24 | spirier | 2 | 107671 | 64 | 15.080 | 7140.0 |
| 391 | 2025-01-25 22:17:28 | spirier | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 390 | 2025-01-25 17:16:12 | spirier | 3 | 134027 | 679 | 20.720 | 6468.5 |
| 389 | 2025-01-25 14:21:03 | spirier | 3 | 134027 | 679 | 19.160 | 6995.1 |
| 388 | 2025-01-25 13:27:58 | spirier | 3 | 134027 | 679 | 15.093 | 8880.1 |
| 387 | 2025-01-07 21:00:25 | spirier | 3 | 134027 | 679 | 7.640 | 17542.8 |
| 386 | 2025-01-05 02:06:40 | spirier | 3 | 134027 | 679 | 19.833 | 6757.8 |
| 385 | 2025-01-04 01:51:25 | spirier | 2 | 107671 | 64 | 16.563 | 6500.7 |
| 384 | 2025-01-02 23:32:46 | spirier | 2 | 107671 | 64 | 3.860 | 27894.0 |
| 383 | 2025-01-01 18:21:52 | spirier | 3 | 134027 | 679 | 18.393 | 7286.8 |
| 382 | 2024-12-21 05:15:03 | spirier | 3 | 134027 | 679 | 46.610 | 2875.5 |
| 381 | 2024-12-18 12:03:20 | spirier | 3 | 134027 | 679 | 43.826 | 3058.2 |
| 380 | 2024-12-16 22:18:21 | spirier | 3 | 134027 | 679 | 24.690 | 5428.4 |
| 379 | 2024-12-16 22:18:22 | spirier | 2 | 107671 | 64 | 11.686 | 9213.7 |
| 378 | 2024-12-13 14:43:35 | spirier | 2 | 107671 | 64 | 11.233 | 9585.2 |
| 377 | 2024-12-08 17:39:27 | spirier | 3 | 134027 | 679 | 36.640 | 3657.9 |
| 376 | 2024-12-05 09:02:31 | spirier | 3 | 134027 | 679 | 30.553 | 4386.7 |