History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"haystack"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 398 | 2025-10-25 21:14:49 | haystack | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 397 | 2025-10-11 05:39:35 | haystack | 1 | 82945 | 2 | 2.766 | 29987.3 |
| 396 | 2025-10-05 08:41:10 | haystack | 4 | 161609 | 237 | 11.360 | 14226.1 |
| 395 | 2025-09-16 20:55:48 | haystack | 4 | 161609 | 237 | 12.343 | 13093.2 |
| 394 | 2025-09-10 07:48:43 | haystack | 2 | 121059 | 4 | 3.610 | 33534.3 |
| 393 | 2025-09-07 09:37:22 | haystack | 1 | 82945 | 2 | 1.310 | 63316.8 |
| 392 | 2025-08-22 14:57:18 | haystack | 3 | 146162 | 29 | 7.610 | 19206.6 |
| 391 | 2025-08-08 00:20:28 | haystack | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 390 | 2025-08-05 10:25:28 | haystack | 3 | 146162 | 29 | 19.766 | 7394.6 |
| 389 | 2025-08-05 03:27:18 | haystack | 2 | 121059 | 4 | 11.376 | 10641.6 |
| 388 | 2025-08-04 04:27:14 | haystack | 1 | 82945 | 2 | 1.360 | 60989.0 |
| 387 | 2025-08-03 23:42:32 | haystack | 1 | 82945 | 2 | 4.203 | 19734.7 |
| 386 | 2025-08-01 06:40:13 | haystack | 1 | 82945 | 2 | 9.626 | 8616.8 |
| 385 | 2025-07-27 01:36:28 | haystack | 1 | 82945 | 2 | 3.953 | 20982.8 |
| 384 | 2025-07-26 02:48:02 | haystack | 1 | 82945 | 2 | 1.456 | 56967.7 |
| 383 | 2025-07-25 00:17:45 | haystack | 1 | 82945 | 2 | 9.406 | 8818.3 |
| 382 | 2025-07-20 07:13:58 | haystack | 1 | 82945 | 2 | 1.513 | 54821.5 |
| 381 | 2025-07-04 23:21:26 | haystack | 1 | 82945 | 2 | 10.406 | 7970.9 |
| 380 | 2025-06-22 06:13:04 | haystack | 1 | 82945 | 2 | 6.360 | 13041.7 |
| 379 | 2025-06-15 23:11:59 | haystack | 1 | 82945 | 2 | 7.063 | 11743.6 |
| 378 | 2025-06-08 00:03:49 | haystack | 1 | 82945 | 2 | 6.406 | 12948.0 |
| 377 | 2025-05-27 15:00:18 | haystack | 2 | 121059 | 4 | 23.956 | 5053.4 |
| 376 | 2025-05-22 03:54:42 | haystack | 1 | 82945 | 2 | 5.470 | 15163.6 |
| 375 | 2025-05-14 05:55:02 | haystack | 1 | 82945 | 2 | 5.000 | 16589.0 |
| 374 | 2025-05-13 15:01:06 | haystack | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 373 | 2025-05-06 23:46:23 | haystack | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 372 | 2025-04-11 07:48:03 | haystack | 3 | 146162 | 29 | 36.330 | 4023.2 |
| 371 | 2025-04-11 02:41:19 | haystack | 2 | 121059 | 4 | 16.720 | 7240.4 |
| 370 | 2025-04-10 02:11:50 | haystack | 1 | 82945 | 2 | 1.440 | 57600.7 |
| 369 | 2025-04-08 05:10:44 | haystack | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 368 | 2025-04-05 22:48:10 | haystack | 4 | 161609 | 237 | 44.720 | 3613.8 |
| 367 | 2025-04-03 15:39:53 | haystack | 4 | 161609 | 237 | 25.703 | 6287.6 |
| 366 | 2025-03-26 15:15:32 | haystack | 4 | 161609 | 237 | 57.050 | 2832.8 |
| 365 | 2025-03-26 01:58:21 | haystack | 3 | 146162 | 29 | 7.830 | 18666.9 |
| 364 | 2025-03-21 09:12:46 | haystack | 3 | 146162 | 29 | 39.613 | 3689.7 |
| 363 | 2025-03-21 08:28:39 | haystack | 2 | 121059 | 4 | 27.190 | 4452.3 |
| 362 | 2025-03-21 07:25:18 | haystack | 4 | 161609 | 237 | 56.956 | 2837.4 |
| 361 | 2025-03-20 05:07:26 | haystack | 1 | 82945 | 2 | 5.846 | 14188.3 |
| 360 | 2025-03-19 23:53:17 | haystack | 1 | 82945 | 2 | 4.000 | 20736.3 |
| 359 | 2025-03-19 23:31:58 | haystack | 1 | 82945 | 2 | 7.100 | 11682.4 |
| 358 | 2025-02-23 18:45:27 | haystack | 4 | 161609 | 237 | 51.720 | 3124.7 |
| 357 | 2025-02-23 00:10:39 | haystack | 4 | 161609 | 237 | 77.850 | 2075.9 |
| 356 | 2025-02-19 00:15:21 | haystack | 4 | 161609 | 237 | 45.533 | 3549.3 |
| 355 | 2025-02-18 22:57:09 | haystack | 4 | 161609 | 237 | 63.873 | 2530.2 |
| 354 | 2025-02-15 13:24:15 | haystack | 4 | 161609 | 237 | 69.370 | 2329.7 |
| 353 | 2025-02-15 01:04:48 | haystack | 4 | 161609 | 237 | 63.880 | 2529.9 |
| 352 | 2025-02-09 14:35:24 | haystack | 1 | 82945 | 2 | 8.076 | 10270.6 |
| 351 | 2025-02-05 19:56:03 | haystack | 1 | 82945 | 2 | 6.360 | 13041.7 |
| 350 | 2025-01-29 11:37:00 | haystack | 1 | 82945 | 2 | 6.143 | 13502.4 |
| 349 | 2025-01-18 00:02:03 | haystack | 4 | 161609 | 237 | 64.473 | 2506.6 |
| 348 | 2025-01-15 02:00:08 | haystack | 4 | 161609 | 237 | 59.096 | 2734.7 |
| 347 | 2025-01-13 14:17:17 | haystack | 4 | 161609 | 237 | 68.583 | 2356.4 |
| 346 | 2025-01-10 12:42:53 | haystack | 4 | 161609 | 237 | 12.486 | 12943.2 |
| 345 | 2025-01-10 12:42:27 | haystack | 3 | 146162 | 29 | 7.000 | 20880.3 |
| 344 | 2025-01-05 13:02:01 | haystack | 2 | 121059 | 4 | 17.766 | 6814.1 |
| 343 | 2025-01-05 13:02:02 | haystack | 1 | 82945 | 2 | 7.220 | 11488.2 |
| 342 | 2025-01-05 12:51:01 | haystack | 3 | 146162 | 29 | 6.686 | 21860.9 |
| 341 | 2024-12-30 21:27:18 | haystack | 3 | 146162 | 29 | 13.593 | 10752.7 |
| 340 | 2024-12-26 17:57:48 | haystack | 1 | 82945 | 2 | 3.923 | 21143.3 |
| 339 | 2024-12-24 23:12:22 | haystack | 1 | 82945 | 2 | 3.936 | 21073.4 |
| 338 | 2024-12-17 10:41:48 | haystack | 3 | 146162 | 29 | 37.020 | 3948.2 |
| 337 | 2024-12-14 09:05:44 | haystack | 2 | 121059 | 4 | 18.733 | 6462.3 |
| 336 | 2024-12-14 09:05:23 | haystack | 1 | 82945 | 2 | 3.296 | 25165.4 |
| 335 | 2024-12-13 13:37:17 | haystack | 3 | 146162 | 29 | 34.503 | 4236.2 |
| 334 | 2024-12-10 02:22:05 | haystack | 3 | 146162 | 29 | 38.126 | 3833.7 |
| 333 | 2024-12-09 00:20:35 | haystack | 3 | 146162 | 29 | 43.830 | 3334.7 |
| 332 | 2024-12-07 02:39:29 | haystack | 4 | 161609 | 237 | 12.436 | 12995.3 |
| 331 | 2024-12-06 01:45:21 | haystack | 3 | 146162 | 29 | 7.063 | 20694.0 |
| 330 | 2024-12-06 01:45:22 | haystack | 2 | 121059 | 4 | 3.610 | 33534.3 |
| 329 | 2024-12-06 01:45:10 | haystack | 1 | 82945 | 2 | 1.250 | 66356.0 |
| 328 | 2024-12-05 06:18:30 | haystack | 4 | 161609 | 237 | 60.990 | 2649.8 |
| 327 | 2024-11-29 03:37:28 | haystack | 3 | 146162 | 29 | 17.673 | 8270.4 |
| 326 | 2024-11-26 11:40:17 | haystack | 1 | 82945 | 2 | 9.593 | 8646.4 |
| 325 | 2024-11-16 17:25:05 | haystack | 4 | 161609 | 237 | 69.646 | 2320.4 |
| 324 | 2024-11-07 07:35:42 | haystack | 4 | 161609 | 237 | 65.020 | 2485.5 |
| 323 | 2024-11-06 02:05:55 | haystack | 4 | 161609 | 237 | 16.330 | 9896.4 |
| 322 | 2024-11-06 02:05:41 | haystack | 3 | 146162 | 29 | 22.630 | 6458.8 |
| 321 | 2024-11-06 02:05:52 | haystack | 2 | 121059 | 4 | 7.250 | 16697.8 |
| 320 | 2024-11-06 02:05:51 | haystack | 1 | 82945 | 2 | 2.860 | 29001.7 |
| 319 | 2024-11-04 04:33:27 | haystack | 3 | 146162 | 29 | 7.376 | 19815.9 |
| 318 | 2024-11-04 04:33:26 | haystack | 3 | 146162 | 29 | 7.063 | 20694.0 |
| 317 | 2024-11-04 04:33:28 | haystack | 2 | 121059 | 4 | 3.703 | 32692.1 |
| 316 | 2024-11-04 04:33:24 | haystack | 1 | 82945 | 2 | 1.250 | 66356.0 |
| 315 | 2024-10-31 15:57:54 | haystack | 1 | 82945 | 2 | 8.296 | 9998.2 |
| 314 | 2024-10-15 20:05:23 | haystack | 2 | 121059 | 4 | 27.203 | 4450.2 |
| 313 | 2024-10-15 20:05:20 | haystack | 2 | 121059 | 4 | 24.686 | 4904.0 |
| 312 | 2024-10-15 20:05:26 | haystack | 2 | 121059 | 4 | 17.440 | 6941.5 |
| 311 | 2024-10-05 10:47:41 | haystack | 1 | 82945 | 2 | 5.110 | 16231.9 |
| 310 | 2024-09-28 03:34:36 | haystack | 1 | 82945 | 2 | 7.970 | 10407.2 |
| 309 | 2024-09-21 03:55:00 | haystack | 1 | 82945 | 2 | 10.876 | 7626.4 |
| 308 | 2024-09-18 05:58:07 | haystack | 2 | 121059 | 4 | 37.470 | 3230.8 |
| 307 | 2024-09-18 05:58:08 | haystack | 3 | 146162 | 29 | 31.330 | 4665.2 |
| 306 | 2024-09-10 11:34:11 | haystack | 1 | 82945 | 2 | 12.703 | 6529.6 |
| 305 | 2024-08-18 17:59:17 | haystack | 1 | 82945 | 2 | 10.406 | 7970.9 |
| 304 | 2024-08-04 08:18:34 | haystack | 1 | 82945 | 2 | 3.126 | 26533.9 |
| 303 | 2024-07-19 01:57:27 | haystack | 3 | 146162 | 29 | 33.753 | 4330.3 |
| 302 | 2024-07-19 01:57:34 | haystack | 2 | 121059 | 4 | 8.660 | 13979.1 |
| 301 | 2024-07-19 01:56:18 | haystack | 1 | 82945 | 2 | 5.516 | 15037.2 |
| 300 | 2024-07-15 23:19:31 | haystack | 3 | 146162 | 29 | 37.160 | 3933.3 |
| 299 | 2024-07-15 23:19:34 | haystack | 3 | 146162 | 29 | 25.300 | 5777.2 |