History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"contacts"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 431 | 2025-06-23 22:38:11 | contacts | 1 | 82945 | 3 | 4.610 | 17992.4 |
| 430 | 2025-06-20 06:03:25 | contacts | 1 | 82945 | 3 | 7.610 | 10899.5 |
| 429 | 2025-06-15 05:49:56 | contacts | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 428 | 2025-06-13 14:34:56 | contacts | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 427 | 2025-06-10 08:44:33 | contacts | 1 | 82945 | 3 | 9.126 | 9088.9 |
| 426 | 2025-06-08 06:33:00 | contacts | 1 | 82945 | 3 | 7.170 | 11568.3 |
| 425 | 2025-06-04 10:29:53 | contacts | 1 | 82945 | 3 | 7.733 | 10726.1 |
| 424 | 2025-06-02 09:27:37 | contacts | 1 | 82945 | 3 | 3.673 | 22582.4 |
| 423 | 2025-06-01 05:55:42 | contacts | 1 | 82945 | 3 | 7.330 | 11315.8 |
| 422 | 2025-05-24 09:29:35 | contacts | 2 | 121059 | 28 | 13.503 | 8965.3 |
| 421 | 2025-05-24 05:31:45 | contacts | 3 | 146162 | 145 | 34.313 | 4259.7 |
| 420 | 2025-05-23 23:10:11 | contacts | 1 | 82945 | 3 | 9.956 | 8331.2 |
| 419 | 2025-05-22 13:10:18 | contacts | 2 | 121059 | 28 | 15.890 | 7618.6 |
| 418 | 2025-05-20 04:36:10 | contacts | 1 | 82945 | 3 | 5.140 | 16137.2 |
| 417 | 2025-05-09 18:41:42 | contacts | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 416 | 2025-05-07 21:33:21 | contacts | 3 | 146162 | 145 | 22.173 | 6591.9 |
| 415 | 2025-05-07 14:10:44 | contacts | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 414 | 2025-05-04 23:17:25 | contacts | 3 | 146162 | 145 | 32.600 | 4483.5 |
| 413 | 2025-05-03 20:48:07 | contacts | 1 | 82945 | 3 | 5.190 | 15981.7 |
| 412 | 2025-05-02 09:16:55 | contacts | 1 | 82945 | 3 | 7.753 | 10698.4 |
| 411 | 2025-04-29 15:44:55 | contacts | 3 | 146162 | 145 | 7.750 | 18859.6 |
| 410 | 2025-04-27 09:10:01 | contacts | 2 | 121059 | 28 | 4.000 | 30264.8 |
| 409 | 2025-04-22 21:41:59 | contacts | 1 | 82945 | 3 | 4.690 | 17685.5 |
| 408 | 2025-04-16 03:44:08 | contacts | 1 | 82945 | 3 | 6.736 | 12313.7 |
| 407 | 2025-04-14 17:24:25 | contacts | 2 | 121059 | 28 | 19.313 | 6268.3 |
| 406 | 2025-04-05 08:40:57 | contacts | 1 | 82945 | 3 | 3.186 | 26034.2 |
| 405 | 2025-04-03 09:43:53 | contacts | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 404 | 2025-03-27 12:19:12 | contacts | 1 | 82945 | 3 | 9.813 | 8452.6 |
| 403 | 2025-03-23 11:58:31 | contacts | 2 | 121059 | 28 | 19.266 | 6283.6 |
| 402 | 2025-03-21 21:39:18 | contacts | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 401 | 2025-03-18 17:55:51 | contacts | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 400 | 2025-03-14 23:07:33 | contacts | 2 | 121059 | 28 | 31.533 | 3839.1 |
| 399 | 2025-03-11 23:30:36 | contacts | 1 | 82945 | 3 | 7.013 | 11827.3 |
| 398 | 2025-03-11 23:28:57 | contacts | 2 | 121059 | 28 | 14.096 | 8588.2 |
| 397 | 2025-03-01 15:06:26 | contacts | 3 | 146162 | 145 | 37.750 | 3871.8 |
| 396 | 2025-03-01 14:39:12 | contacts | 3 | 146162 | 145 | 34.813 | 4198.5 |
| 395 | 2025-03-01 10:48:05 | contacts | 3 | 146162 | 145 | 40.050 | 3649.5 |
| 394 | 2025-02-28 07:07:12 | contacts | 3 | 146162 | 145 | 42.753 | 3418.8 |
| 393 | 2025-02-28 07:07:10 | contacts | 2 | 121059 | 28 | 15.156 | 7987.5 |
| 392 | 2025-02-28 07:06:08 | contacts | 1 | 82945 | 3 | 6.656 | 12461.7 |
| 391 | 2025-02-25 12:17:11 | contacts | 1 | 82945 | 3 | 10.220 | 8115.9 |
| 390 | 2025-02-24 18:53:35 | contacts | 1 | 82945 | 3 | 7.076 | 11722.0 |
| 389 | 2025-01-29 23:27:22 | contacts | 1 | 82945 | 3 | 7.266 | 11415.5 |
| 388 | 2025-01-28 20:47:25 | contacts | 3 | 146162 | 145 | 34.843 | 4194.9 |
| 387 | 2025-01-25 17:23:24 | contacts | 1 | 82945 | 3 | 5.110 | 16231.9 |
| 386 | 2025-01-24 18:33:32 | contacts | 3 | 146162 | 145 | 8.016 | 18233.8 |
| 385 | 2025-01-20 11:47:37 | contacts | 3 | 146162 | 145 | 38.006 | 3845.8 |
| 384 | 2025-01-19 04:18:55 | contacts | 3 | 146162 | 145 | 41.300 | 3539.0 |
| 383 | 2025-01-18 18:57:02 | contacts | 3 | 146162 | 145 | 20.830 | 7016.9 |
| 382 | 2024-12-30 18:16:55 | contacts | 1 | 82945 | 3 | 1.550 | 53512.9 |
| 381 | 2024-12-27 17:24:16 | contacts | 1 | 82945 | 3 | 3.420 | 24252.9 |
| 380 | 2024-12-26 18:31:33 | contacts | 2 | 121059 | 28 | 16.890 | 7167.5 |
| 379 | 2024-12-26 18:31:18 | contacts | 1 | 82945 | 3 | 7.016 | 11822.3 |
| 378 | 2024-12-21 16:54:29 | contacts | 3 | 146162 | 145 | 37.050 | 3945.0 |
| 377 | 2024-12-20 06:59:11 | contacts | 3 | 146162 | 145 | 28.386 | 5149.1 |
| 376 | 2024-12-19 16:53:38 | contacts | 3 | 146162 | 145 | 41.410 | 3529.6 |
| 375 | 2024-12-19 16:53:34 | contacts | 1 | 82945 | 3 | 1.780 | 46598.3 |
| 374 | 2024-12-11 16:28:13 | contacts | 2 | 121059 | 28 | 19.703 | 6144.2 |
| 373 | 2024-12-07 11:18:52 | contacts | 2 | 121059 | 28 | 18.253 | 6632.3 |
| 372 | 2024-12-07 11:18:52 | contacts | 2 | 121059 | 28 | 18.470 | 6554.4 |
| 371 | 2024-12-07 11:18:39 | contacts | 1 | 82945 | 3 | 6.686 | 12405.8 |
| 370 | 2024-11-26 12:20:47 | contacts | 1 | 82945 | 3 | 7.110 | 11666.0 |
| 369 | 2024-11-26 03:14:18 | contacts | 1 | 82945 | 3 | 10.500 | 7899.5 |
| 368 | 2024-11-07 11:08:36 | contacts | 1 | 82945 | 3 | 4.750 | 17462.1 |
| 367 | 2024-10-29 20:59:12 | contacts | 1 | 82945 | 3 | 7.016 | 11822.3 |
| 366 | 2024-10-27 03:22:23 | contacts | 1 | 82945 | 3 | 4.453 | 18626.8 |
| 365 | 2024-10-26 01:00:37 | contacts | 1 | 82945 | 3 | 6.936 | 11958.6 |
| 364 | 2024-09-29 14:12:08 | contacts | 1 | 82945 | 3 | 5.750 | 14425.2 |
| 363 | 2024-09-21 03:54:44 | contacts | 1 | 82945 | 3 | 6.330 | 13103.5 |
| 362 | 2024-09-21 03:52:59 | contacts | 3 | 146162 | 145 | 73.783 | 1981.0 |
| 361 | 2024-09-21 03:52:58 | contacts | 2 | 121059 | 28 | 33.563 | 3606.9 |
| 360 | 2024-09-20 11:54:31 | contacts | 3 | 146162 | 145 | 15.203 | 9614.0 |
| 359 | 2024-09-20 01:40:27 | contacts | 3 | 146162 | 145 | 30.143 | 4849.0 |
| 358 | 2024-09-20 01:40:29 | contacts | 2 | 121059 | 28 | 24.690 | 4903.2 |
| 357 | 2024-09-05 00:01:16 | contacts | 1 | 82945 | 3 | 15.046 | 5512.8 |
| 356 | 2024-08-27 13:52:55 | contacts | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 355 | 2024-08-19 10:03:56 | contacts | 1 | 82945 | 3 | 10.453 | 7935.0 |
| 354 | 2024-08-15 09:17:22 | contacts | 2 | 121059 | 28 | 29.080 | 4163.0 |
| 353 | 2024-08-14 18:53:24 | contacts | 2 | 121059 | 28 | 22.033 | 5494.4 |
| 352 | 2024-08-14 18:53:16 | contacts | 3 | 146162 | 145 | 27.843 | 5249.5 |
| 351 | 2024-08-14 18:52:40 | contacts | 1 | 82945 | 3 | 4.686 | 17700.6 |
| 350 | 2024-08-10 12:04:34 | contacts | 1 | 82945 | 3 | 5.296 | 15661.8 |
| 349 | 2024-08-07 23:07:40 | contacts | 1 | 82945 | 3 | 3.096 | 26791.0 |
| 348 | 2024-07-31 15:42:56 | contacts | 2 | 121059 | 28 | 16.426 | 7370.0 |
| 347 | 2024-07-31 15:42:33 | contacts | 1 | 82945 | 3 | 5.220 | 15889.8 |
| 346 | 2024-07-31 08:04:00 | contacts | 3 | 146162 | 145 | 47.296 | 3090.4 |
| 345 | 2024-07-31 08:01:15 | contacts | 3 | 146162 | 145 | 32.563 | 4488.6 |
| 344 | 2024-07-31 04:23:39 | contacts | 3 | 146162 | 145 | 21.393 | 6832.2 |
| 343 | 2024-07-31 04:23:39 | contacts | 2 | 121059 | 28 | 15.623 | 7748.8 |
| 342 | 2024-07-31 04:12:30 | contacts | 1 | 82945 | 3 | 5.236 | 15841.3 |
| 341 | 2024-07-26 14:43:08 | contacts | 2 | 121059 | 28 | 13.966 | 8668.1 |
| 340 | 2024-07-25 08:28:13 | contacts | 3 | 146162 | 145 | 27.720 | 5272.8 |
| 339 | 2024-07-25 07:09:17 | contacts | 3 | 146162 | 145 | 34.516 | 4234.6 |
| 338 | 2024-07-25 07:09:10 | contacts | 2 | 121059 | 28 | 15.170 | 7980.2 |
| 337 | 2024-07-25 07:09:04 | contacts | 1 | 82945 | 3 | 6.330 | 13103.5 |
| 336 | 2024-07-18 14:04:38 | contacts | 1 | 82945 | 3 | 2.686 | 30880.5 |
| 335 | 2024-07-02 13:15:11 | contacts | 1 | 82945 | 3 | 7.440 | 11148.5 |
| 334 | 2024-07-01 04:55:08 | contacts | 3 | 146162 | 145 | 34.283 | 4263.4 |
| 333 | 2024-07-01 02:23:25 | contacts | 3 | 146162 | 145 | 41.590 | 3514.4 |
| 332 | 2024-07-01 02:23:27 | contacts | 2 | 121059 | 28 | 12.706 | 9527.7 |