History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scallions"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 410 | 2025-10-16 13:29:01 | scallions | 1 | 81242 | 4 | 1.610 | 50460.9 |
| 409 | 2025-10-12 18:47:33 | scallions | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 408 | 2025-10-02 02:19:22 | scallions | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 407 | 2025-09-13 14:58:53 | scallions | 1 | 81242 | 4 | 1.516 | 53589.7 |
| 406 | 2025-08-27 13:48:03 | scallions | 1 | 81242 | 4 | 1.326 | 61268.5 |
| 405 | 2025-08-05 09:16:47 | scallions | 1 | 81242 | 4 | 3.513 | 23126.1 |
| 404 | 2025-08-04 12:56:14 | scallions | 1 | 81242 | 4 | 8.593 | 9454.4 |
| 403 | 2025-08-02 14:18:43 | scallions | 1 | 81242 | 4 | 3.626 | 22405.4 |
| 402 | 2025-08-02 09:32:07 | scallions | 1 | 81242 | 4 | 5.643 | 14397.0 |
| 401 | 2025-08-01 03:38:20 | scallions | 1 | 81242 | 4 | 9.596 | 8466.2 |
| 400 | 2025-07-31 14:04:05 | scallions | 1 | 81242 | 4 | 2.993 | 27144.0 |
| 399 | 2025-07-26 23:37:36 | scallions | 1 | 81242 | 4 | 3.673 | 22118.7 |
| 398 | 2025-07-25 09:58:37 | scallions | 1 | 81242 | 4 | 3.250 | 24997.5 |
| 397 | 2025-07-21 21:17:54 | scallions | 1 | 81242 | 4 | 1.280 | 63470.3 |
| 396 | 2025-07-19 03:13:13 | scallions | 1 | 81242 | 4 | 1.436 | 56575.2 |
| 395 | 2025-07-18 03:55:01 | scallions | 4 | 165329 | 694 | 31.843 | 5192.0 |
| 394 | 2025-07-15 05:53:45 | scallions | 4 | 165329 | 694 | 62.300 | 2653.8 |
| 393 | 2025-07-11 02:49:39 | scallions | 4 | 165329 | 694 | 45.940 | 3598.8 |
| 392 | 2025-07-11 01:53:51 | scallions | 3 | 148641 | 93 | 25.393 | 5853.6 |
| 391 | 2025-07-09 21:24:53 | scallions | 1 | 81242 | 4 | 10.783 | 7534.3 |
| 390 | 2025-07-09 14:48:46 | scallions | 3 | 148641 | 93 | 37.503 | 3963.4 |
| 389 | 2025-07-07 13:56:16 | scallions | 4 | 165329 | 694 | 63.706 | 2595.2 |
| 388 | 2025-07-07 13:55:42 | scallions | 4 | 165329 | 694 | 53.143 | 3111.0 |
| 387 | 2025-07-06 05:41:07 | scallions | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 386 | 2025-07-06 05:41:06 | scallions | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 385 | 2025-07-05 12:21:58 | scallions | 2 | 121436 | 11 | 16.123 | 7531.8 |
| 384 | 2025-07-03 18:48:27 | scallions | 3 | 148641 | 93 | 6.673 | 22275.0 |
| 383 | 2025-07-02 12:38:58 | scallions | 1 | 81242 | 4 | 7.826 | 10381.0 |
| 382 | 2025-07-01 13:38:45 | scallions | 1 | 81242 | 4 | 1.360 | 59736.8 |
| 381 | 2025-06-30 13:25:43 | scallions | 1 | 81242 | 4 | 9.703 | 8372.9 |
| 380 | 2025-06-25 23:11:46 | scallions | 1 | 81242 | 4 | 3.766 | 21572.5 |
| 379 | 2025-06-18 12:43:36 | scallions | 3 | 148641 | 93 | 49.063 | 3029.6 |
| 378 | 2025-06-14 14:36:18 | scallions | 3 | 148641 | 93 | 45.363 | 3276.7 |
| 377 | 2025-06-14 07:31:18 | scallions | 2 | 121436 | 11 | 20.313 | 5978.2 |
| 376 | 2025-06-14 05:13:58 | scallions | 1 | 81242 | 4 | 7.220 | 11252.4 |
| 375 | 2025-06-13 13:43:34 | scallions | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 374 | 2025-05-25 23:09:09 | scallions | 1 | 81242 | 4 | 6.736 | 12060.9 |
| 373 | 2025-05-15 19:48:53 | scallions | 1 | 81242 | 4 | 7.123 | 11405.6 |
| 372 | 2025-05-12 11:54:19 | scallions | 3 | 148641 | 93 | 39.830 | 3731.9 |
| 371 | 2025-05-10 07:27:18 | scallions | 2 | 121436 | 11 | 15.860 | 7656.7 |
| 370 | 2025-05-10 05:39:32 | scallions | 3 | 148641 | 93 | 27.296 | 5445.5 |
| 369 | 2025-05-09 13:46:02 | scallions | 1 | 81242 | 4 | 3.420 | 23755.0 |
| 368 | 2025-05-04 04:10:03 | scallions | 1 | 81242 | 4 | 3.343 | 24302.1 |
| 367 | 2025-05-02 13:01:45 | scallions | 1 | 81242 | 4 | 7.890 | 10296.8 |
| 366 | 2025-04-29 01:52:50 | scallions | 1 | 81242 | 4 | 6.580 | 12346.8 |
| 365 | 2025-04-22 22:37:32 | scallions | 1 | 81242 | 4 | 6.283 | 12930.4 |
| 364 | 2025-04-06 18:35:37 | scallions | 1 | 81242 | 4 | 7.000 | 11606.0 |
| 363 | 2025-04-06 13:33:00 | scallions | 1 | 81242 | 4 | 4.783 | 16985.6 |
| 362 | 2025-04-02 07:18:40 | scallions | 1 | 81242 | 4 | 6.876 | 11815.3 |
| 361 | 2025-04-02 03:55:20 | scallions | 1 | 81242 | 4 | 9.593 | 8468.9 |
| 360 | 2025-03-20 15:37:29 | scallions | 1 | 81242 | 4 | 5.576 | 14569.9 |
| 359 | 2025-03-01 08:03:58 | scallions | 3 | 148641 | 93 | 34.410 | 4319.7 |
| 358 | 2025-03-01 00:43:55 | scallions | 3 | 148641 | 93 | 33.736 | 4406.0 |
| 357 | 2025-03-01 00:43:37 | scallions | 2 | 121436 | 11 | 17.780 | 6829.9 |
| 356 | 2025-02-28 01:57:44 | scallions | 3 | 148641 | 93 | 27.563 | 5392.8 |
| 355 | 2025-02-28 01:57:40 | scallions | 2 | 121436 | 11 | 17.003 | 7142.0 |
| 354 | 2025-02-27 15:33:27 | scallions | 1 | 81242 | 4 | 7.220 | 11252.4 |
| 353 | 2025-02-27 15:32:46 | scallions | 1 | 81242 | 4 | 6.453 | 12589.8 |
| 352 | 2025-02-27 12:58:03 | scallions | 3 | 148641 | 93 | 40.610 | 3660.2 |
| 351 | 2025-02-27 12:58:01 | scallions | 3 | 148641 | 93 | 35.690 | 4164.8 |
| 350 | 2025-02-27 12:57:49 | scallions | 2 | 121436 | 11 | 19.000 | 6391.4 |
| 349 | 2025-02-27 12:56:41 | scallions | 1 | 81242 | 4 | 7.000 | 11606.0 |
| 348 | 2025-01-27 00:41:14 | scallions | 1 | 81242 | 4 | 4.643 | 17497.7 |
| 347 | 2025-01-26 11:14:17 | scallions | 3 | 148641 | 93 | 34.803 | 4270.9 |
| 346 | 2025-01-25 17:04:13 | scallions | 1 | 81242 | 4 | 3.656 | 22221.6 |
| 345 | 2025-01-24 15:26:26 | scallions | 2 | 121436 | 11 | 25.766 | 4713.0 |
| 344 | 2025-01-24 15:26:14 | scallions | 3 | 148641 | 93 | 34.876 | 4262.0 |
| 343 | 2025-01-24 15:25:36 | scallions | 1 | 81242 | 4 | 8.310 | 9776.4 |
| 342 | 2025-01-20 19:00:47 | scallions | 3 | 148641 | 93 | 32.590 | 4560.9 |
| 341 | 2025-01-20 18:22:41 | scallions | 1 | 81242 | 4 | 3.576 | 22718.7 |
| 340 | 2025-01-18 02:21:13 | scallions | 3 | 148641 | 93 | 41.393 | 3591.0 |
| 339 | 2025-01-15 21:07:04 | scallions | 1 | 81242 | 4 | 9.783 | 8304.4 |
| 338 | 2024-12-31 17:52:53 | scallions | 3 | 148641 | 93 | 46.880 | 3170.7 |
| 337 | 2024-12-26 22:18:46 | scallions | 3 | 148641 | 93 | 21.873 | 6795.6 |
| 336 | 2024-12-26 17:20:39 | scallions | 3 | 148641 | 93 | 41.936 | 3544.5 |
| 335 | 2024-12-26 17:20:40 | scallions | 2 | 121436 | 11 | 16.733 | 7257.3 |
| 334 | 2024-12-26 17:20:10 | scallions | 3 | 148641 | 93 | 35.110 | 4233.6 |
| 333 | 2024-12-26 17:20:03 | scallions | 1 | 81242 | 4 | 3.733 | 21763.2 |
| 332 | 2024-12-21 02:48:42 | scallions | 1 | 81242 | 4 | 7.560 | 10746.3 |
| 331 | 2024-12-16 15:46:45 | scallions | 1 | 81242 | 4 | 3.843 | 21140.3 |
| 330 | 2024-12-16 13:29:24 | scallions | 1 | 81242 | 4 | 5.970 | 13608.4 |
| 329 | 2024-11-22 07:30:38 | scallions | 1 | 81242 | 4 | 3.390 | 23965.2 |
| 328 | 2024-11-20 20:40:53 | scallions | 2 | 121436 | 11 | 18.890 | 6428.6 |
| 327 | 2024-11-20 19:52:33 | scallions | 1 | 81242 | 4 | 1.466 | 55417.5 |
| 326 | 2024-11-13 17:20:50 | scallions | 1 | 81242 | 4 | 9.750 | 8332.5 |
| 325 | 2024-11-11 22:00:40 | scallions | 1 | 81242 | 4 | 3.360 | 24179.2 |
| 324 | 2024-10-25 02:44:40 | scallions | 3 | 148641 | 93 | 35.893 | 4141.2 |
| 323 | 2024-10-22 11:52:53 | scallions | 3 | 148641 | 93 | 55.646 | 2671.2 |
| 322 | 2024-10-22 11:53:02 | scallions | 2 | 121436 | 11 | 16.656 | 7290.8 |
| 321 | 2024-10-22 11:52:48 | scallions | 3 | 148641 | 93 | 27.613 | 5383.0 |
| 320 | 2024-10-21 04:55:28 | scallions | 1 | 81242 | 4 | 7.220 | 11252.4 |
| 319 | 2024-10-16 07:39:43 | scallions | 1 | 81242 | 4 | 6.420 | 12654.5 |
| 318 | 2024-10-11 17:39:52 | scallions | 2 | 121436 | 11 | 17.923 | 6775.4 |
| 317 | 2024-10-10 17:01:01 | scallions | 2 | 121436 | 11 | 20.423 | 5946.0 |
| 316 | 2024-10-10 17:01:01 | scallions | 2 | 121436 | 11 | 16.406 | 7401.9 |
| 315 | 2024-10-10 17:00:11 | scallions | 1 | 81242 | 4 | 6.826 | 11901.8 |
| 314 | 2024-10-10 16:29:21 | scallions | 1 | 81242 | 4 | 5.610 | 14481.6 |
| 313 | 2024-09-28 13:55:50 | scallions | 2 | 121436 | 11 | 40.610 | 2990.3 |
| 312 | 2024-09-16 06:45:46 | scallions | 2 | 121436 | 11 | 34.313 | 3539.1 |
| 311 | 2024-09-16 06:43:20 | scallions | 1 | 81242 | 4 | 4.280 | 18981.8 |