History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affiliates"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 421 | 2025-07-14 10:36:28 | affiliates | 2 | 108824 | 5 | 12.546 | 8674.0 |
| 420 | 2025-07-13 22:38:39 | affiliates | 3 | 140603 | 28 | 40.740 | 3451.2 |
| 419 | 2025-07-12 21:46:11 | affiliates | 1 | 67641 | 3 | 1.576 | 42919.4 |
| 418 | 2025-07-07 07:51:04 | affiliates | 1 | 67641 | 3 | 6.453 | 10482.1 |
| 417 | 2025-07-06 19:05:08 | affiliates | 1 | 67641 | 3 | 1.160 | 58311.2 |
| 416 | 2025-07-02 07:03:32 | affiliates | 1 | 67641 | 3 | 5.670 | 11929.6 |
| 415 | 2025-06-24 19:47:13 | affiliates | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 414 | 2025-06-21 16:43:05 | affiliates | 1 | 67641 | 3 | 5.923 | 11420.1 |
| 413 | 2025-06-15 00:07:28 | affiliates | 2 | 108824 | 5 | 3.843 | 28317.5 |
| 412 | 2025-06-10 04:02:17 | affiliates | 1 | 67641 | 3 | 6.390 | 10585.4 |
| 411 | 2025-05-29 14:53:17 | affiliates | 1 | 67641 | 3 | 4.936 | 13703.6 |
| 410 | 2025-05-28 21:13:31 | affiliates | 1 | 67641 | 3 | 5.343 | 12659.7 |
| 409 | 2025-05-28 16:05:36 | affiliates | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 408 | 2025-05-26 02:01:37 | affiliates | 4 | 161450 | 169 | 55.630 | 2902.2 |
| 407 | 2025-05-25 21:59:37 | affiliates | 1 | 67641 | 3 | 2.953 | 22905.9 |
| 406 | 2025-05-24 20:23:36 | affiliates | 1 | 67641 | 3 | 6.596 | 10254.9 |
| 405 | 2025-05-24 17:26:47 | affiliates | 4 | 161450 | 169 | 38.560 | 4187.0 |
| 404 | 2025-05-23 22:26:43 | affiliates | 4 | 161450 | 169 | 30.873 | 5229.5 |
| 403 | 2025-05-23 07:50:22 | affiliates | 4 | 161450 | 169 | 39.800 | 4056.5 |
| 402 | 2025-05-21 13:35:47 | affiliates | 4 | 161450 | 169 | 11.170 | 14453.9 |
| 401 | 2025-05-10 18:06:00 | affiliates | 2 | 108824 | 5 | 17.470 | 6229.2 |
| 400 | 2025-05-10 10:37:06 | affiliates | 4 | 161450 | 169 | 50.626 | 3189.1 |
| 399 | 2025-05-09 16:23:08 | affiliates | 1 | 67641 | 3 | 1.500 | 45094.0 |
| 398 | 2025-04-28 06:55:12 | affiliates | 1 | 67641 | 3 | 5.016 | 13485.0 |
| 397 | 2025-04-17 20:52:30 | affiliates | 3 | 140603 | 28 | 28.126 | 4999.0 |
| 396 | 2025-04-14 23:30:19 | affiliates | 3 | 140603 | 28 | 34.673 | 4055.1 |
| 395 | 2025-04-11 16:49:06 | affiliates | 4 | 161450 | 169 | 47.896 | 3370.8 |
| 394 | 2025-04-11 16:27:11 | affiliates | 1 | 67641 | 3 | 2.860 | 23650.7 |
| 393 | 2025-04-11 04:58:34 | affiliates | 3 | 140603 | 28 | 28.613 | 4914.0 |
| 392 | 2025-04-11 02:52:40 | affiliates | 3 | 140603 | 28 | 30.096 | 4671.8 |
| 391 | 2025-04-10 21:45:38 | affiliates | 4 | 161450 | 169 | 47.956 | 3366.6 |
| 390 | 2025-04-09 15:41:53 | affiliates | 2 | 108824 | 5 | 12.830 | 8482.0 |
| 389 | 2025-04-09 09:14:59 | affiliates | 3 | 140603 | 28 | 18.266 | 7697.5 |
| 388 | 2025-04-09 07:46:23 | affiliates | 4 | 161450 | 169 | 44.000 | 3669.3 |
| 387 | 2025-04-02 03:33:48 | affiliates | 1 | 67641 | 3 | 5.046 | 13404.9 |
| 386 | 2025-03-29 02:03:27 | affiliates | 1 | 67641 | 3 | 7.310 | 9253.2 |
| 385 | 2025-03-25 07:15:21 | affiliates | 1 | 67641 | 3 | 3.140 | 21541.7 |
| 384 | 2025-03-23 18:55:03 | affiliates | 1 | 67641 | 3 | 2.733 | 24749.7 |
| 383 | 2025-02-22 14:22:52 | affiliates | 3 | 140603 | 28 | 23.346 | 6022.6 |
| 382 | 2025-02-19 20:14:48 | affiliates | 3 | 140603 | 28 | 37.780 | 3721.6 |
| 381 | 2025-02-19 10:41:05 | affiliates | 1 | 67641 | 3 | 2.843 | 23792.1 |
| 380 | 2025-02-18 10:35:47 | affiliates | 3 | 140603 | 28 | 31.266 | 4497.0 |
| 379 | 2025-02-18 04:37:07 | affiliates | 3 | 140603 | 28 | 5.593 | 25139.1 |
| 378 | 2025-02-16 04:50:24 | affiliates | 3 | 140603 | 28 | 19.660 | 7151.7 |
| 377 | 2025-02-16 04:50:22 | affiliates | 2 | 108824 | 5 | 6.970 | 15613.2 |
| 376 | 2025-02-16 04:48:57 | affiliates | 1 | 67641 | 3 | 2.670 | 25333.7 |
| 375 | 2025-02-15 20:53:28 | affiliates | 1 | 67641 | 3 | 5.360 | 12619.6 |
| 374 | 2025-01-21 02:45:22 | affiliates | 2 | 108824 | 5 | 9.123 | 11928.5 |
| 373 | 2025-01-21 02:42:06 | affiliates | 1 | 67641 | 3 | 2.936 | 23038.5 |
| 372 | 2025-01-21 01:23:26 | affiliates | 3 | 140603 | 28 | 29.986 | 4689.0 |
| 371 | 2025-01-11 09:15:57 | affiliates | 3 | 140603 | 28 | 32.253 | 4359.4 |
| 370 | 2025-01-11 09:15:59 | affiliates | 2 | 108824 | 5 | 16.580 | 6563.6 |
| 369 | 2025-01-11 09:12:06 | affiliates | 1 | 67641 | 3 | 5.453 | 12404.4 |
| 368 | 2025-01-08 17:44:18 | affiliates | 1 | 67641 | 3 | 5.346 | 12652.6 |
| 367 | 2025-01-08 10:30:36 | affiliates | 3 | 140603 | 28 | 43.520 | 3230.8 |
| 366 | 2025-01-08 10:30:28 | affiliates | 2 | 108824 | 5 | 13.940 | 7806.6 |
| 365 | 2025-01-06 16:30:55 | affiliates | 3 | 140603 | 28 | 30.393 | 4626.2 |
| 364 | 2025-01-06 16:31:02 | affiliates | 2 | 108824 | 5 | 15.123 | 7195.9 |
| 363 | 2025-01-06 16:28:33 | affiliates | 1 | 67641 | 3 | 2.500 | 27056.4 |
| 362 | 2025-01-03 22:01:43 | affiliates | 4 | 161450 | 169 | 50.876 | 3173.4 |
| 361 | 2025-01-03 01:29:21 | affiliates | 4 | 161450 | 169 | 62.973 | 2563.8 |
| 360 | 2024-12-20 11:52:59 | affiliates | 4 | 161450 | 169 | 56.610 | 2852.0 |
| 359 | 2024-12-17 00:51:19 | affiliates | 4 | 161450 | 169 | 45.000 | 3587.8 |
| 358 | 2024-12-10 04:02:27 | affiliates | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 357 | 2024-12-08 16:50:52 | affiliates | 4 | 161450 | 169 | 62.633 | 2577.7 |
| 356 | 2024-12-07 20:41:10 | affiliates | 3 | 140603 | 28 | 25.016 | 5620.5 |
| 355 | 2024-12-07 15:12:36 | affiliates | 1 | 67641 | 3 | 4.470 | 15132.2 |
| 354 | 2024-12-04 22:04:04 | affiliates | 3 | 140603 | 28 | 33.703 | 4171.8 |
| 353 | 2024-12-04 22:01:03 | affiliates | 2 | 108824 | 5 | 8.016 | 13575.8 |
| 352 | 2024-12-04 21:59:28 | affiliates | 1 | 67641 | 3 | 3.000 | 22547.0 |
| 351 | 2024-12-04 10:20:32 | affiliates | 3 | 140603 | 28 | 38.063 | 3694.0 |
| 350 | 2024-12-04 04:59:47 | affiliates | 3 | 140603 | 28 | 31.113 | 4519.1 |
| 349 | 2024-12-03 13:48:40 | affiliates | 4 | 161450 | 169 | 46.846 | 3446.4 |
| 348 | 2024-12-03 13:48:38 | affiliates | 3 | 140603 | 28 | 34.376 | 4090.2 |
| 347 | 2024-12-03 13:45:26 | affiliates | 1 | 67641 | 3 | 1.780 | 38000.6 |
| 346 | 2024-11-27 15:15:07 | affiliates | 4 | 161450 | 169 | 17.513 | 9218.9 |
| 345 | 2024-11-19 23:06:48 | affiliates | 4 | 161450 | 169 | 67.763 | 2382.6 |
| 344 | 2024-11-16 04:20:57 | affiliates | 4 | 161450 | 169 | 57.550 | 2805.4 |
| 343 | 2024-11-09 00:19:18 | affiliates | 2 | 108824 | 5 | 18.530 | 5872.9 |
| 342 | 2024-11-05 14:17:29 | affiliates | 2 | 108824 | 5 | 14.656 | 7425.2 |
| 341 | 2024-11-04 06:10:32 | affiliates | 2 | 108824 | 5 | 17.736 | 6135.8 |
| 340 | 2024-11-04 04:55:09 | affiliates | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 339 | 2024-11-01 11:48:18 | affiliates | 4 | 161450 | 169 | 71.270 | 2265.3 |
| 338 | 2024-11-01 11:45:50 | affiliates | 1 | 67641 | 3 | 4.940 | 13692.5 |
| 337 | 2024-10-29 22:11:47 | affiliates | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 336 | 2024-10-28 00:09:42 | affiliates | 1 | 67641 | 3 | 4.420 | 15303.4 |
| 335 | 2024-10-20 08:27:01 | affiliates | 3 | 140603 | 28 | 26.656 | 5274.7 |
| 334 | 2024-10-17 20:07:56 | affiliates | 3 | 140603 | 28 | 29.953 | 4694.1 |
| 333 | 2024-10-13 21:50:03 | affiliates | 3 | 140603 | 28 | 31.410 | 4476.4 |
| 332 | 2024-10-13 17:33:07 | affiliates | 2 | 108824 | 5 | 16.360 | 6651.8 |
| 331 | 2024-10-06 01:51:58 | affiliates | 2 | 108824 | 5 | 33.813 | 3218.4 |
| 330 | 2024-10-05 15:35:31 | affiliates | 2 | 108824 | 5 | 22.220 | 4897.6 |
| 329 | 2024-10-03 22:13:12 | affiliates | 2 | 108824 | 5 | 31.740 | 3428.6 |
| 328 | 2024-10-03 22:12:57 | affiliates | 3 | 140603 | 28 | 44.976 | 3126.2 |
| 327 | 2024-09-22 20:40:26 | affiliates | 4 | 161450 | 169 | 102.083 | 1581.6 |
| 326 | 2024-09-19 19:53:51 | affiliates | 1 | 67641 | 3 | 8.033 | 8420.4 |
| 325 | 2024-09-16 10:24:57 | affiliates | 4 | 161450 | 169 | 119.100 | 1355.6 |
| 324 | 2024-09-13 04:01:46 | affiliates | 4 | 161450 | 169 | 113.163 | 1426.7 |
| 323 | 2024-09-12 18:08:21 | affiliates | 1 | 67641 | 3 | 7.593 | 8908.3 |
| 322 | 2024-09-07 14:47:09 | affiliates | 1 | 67641 | 3 | 8.436 | 8018.1 |