History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pyrethrin"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 393 | 2025-11-06 01:15:46 | pyrethrin | 2 | 121436 | 5 | 3.530 | 34401.1 |
| 392 | 2025-11-05 16:12:19 | pyrethrin | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 391 | 2025-10-05 01:15:23 | pyrethrin | 4 | 165329 | 104 | 12.970 | 12747.0 |
| 390 | 2025-09-14 01:59:17 | pyrethrin | 4 | 165329 | 104 | 12.470 | 13258.1 |
| 389 | 2025-09-13 18:35:25 | pyrethrin | 2 | 121436 | 5 | 3.343 | 36325.5 |
| 388 | 2025-09-10 07:58:48 | pyrethrin | 2 | 121436 | 5 | 3.313 | 36654.4 |
| 387 | 2025-09-03 23:46:21 | pyrethrin | 3 | 148641 | 17 | 7.390 | 20113.8 |
| 386 | 2025-09-02 22:05:30 | pyrethrin | 1 | 81242 | 2 | 1.356 | 59913.0 |
| 385 | 2025-08-30 22:03:14 | pyrethrin | 2 | 121436 | 5 | 7.080 | 17152.0 |
| 384 | 2025-08-19 07:50:39 | pyrethrin | 4 | 165329 | 104 | 30.156 | 5482.5 |
| 383 | 2025-08-17 02:46:19 | pyrethrin | 4 | 165329 | 104 | 30.470 | 5426.0 |
| 382 | 2025-08-12 12:30:34 | pyrethrin | 4 | 165329 | 104 | 26.486 | 6242.1 |
| 381 | 2025-08-07 03:12:36 | pyrethrin | 4 | 165329 | 104 | 52.473 | 3150.7 |
| 380 | 2025-08-02 17:17:06 | pyrethrin | 4 | 165329 | 104 | 32.503 | 5086.6 |
| 379 | 2025-07-31 20:52:58 | pyrethrin | 4 | 165329 | 104 | 69.910 | 2364.9 |
| 378 | 2025-07-29 19:36:37 | pyrethrin | 4 | 165329 | 104 | 31.346 | 5274.3 |
| 377 | 2025-07-25 14:18:51 | pyrethrin | 1 | 81242 | 2 | 4.576 | 17753.9 |
| 376 | 2025-07-23 23:37:06 | pyrethrin | 1 | 81242 | 2 | 3.576 | 22718.7 |
| 375 | 2025-07-17 10:35:31 | pyrethrin | 4 | 165329 | 104 | 35.050 | 4716.9 |
| 374 | 2025-07-17 09:54:42 | pyrethrin | 3 | 148641 | 17 | 26.440 | 5621.8 |
| 373 | 2025-07-17 07:15:29 | pyrethrin | 2 | 121436 | 5 | 14.610 | 8311.8 |
| 372 | 2025-07-15 21:49:11 | pyrethrin | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 371 | 2025-07-13 13:54:08 | pyrethrin | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 370 | 2025-07-08 07:40:33 | pyrethrin | 1 | 81242 | 2 | 8.470 | 9591.7 |
| 369 | 2025-05-31 19:20:05 | pyrethrin | 1 | 81242 | 2 | 7.140 | 11378.4 |
| 368 | 2025-05-28 14:39:19 | pyrethrin | 3 | 148641 | 17 | 10.626 | 13988.4 |
| 367 | 2025-05-25 08:55:04 | pyrethrin | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 366 | 2025-05-22 07:37:42 | pyrethrin | 1 | 81242 | 2 | 3.610 | 22504.7 |
| 365 | 2025-03-17 04:11:47 | pyrethrin | 2 | 121436 | 5 | 17.880 | 6791.7 |
| 364 | 2025-03-13 02:48:27 | pyrethrin | 3 | 148641 | 17 | 47.566 | 3124.9 |
| 363 | 2025-03-09 16:39:38 | pyrethrin | 1 | 81242 | 2 | 5.876 | 13826.1 |
| 362 | 2025-03-07 13:54:47 | pyrethrin | 3 | 148641 | 17 | 40.250 | 3692.9 |
| 361 | 2025-03-07 13:54:47 | pyrethrin | 3 | 148641 | 17 | 40.220 | 3695.7 |
| 360 | 2025-03-07 13:54:46 | pyrethrin | 2 | 121436 | 5 | 20.876 | 5817.0 |
| 359 | 2025-03-07 13:53:21 | pyrethrin | 1 | 81242 | 2 | 6.860 | 11842.9 |
| 358 | 2025-03-06 04:13:01 | pyrethrin | 3 | 148641 | 17 | 49.423 | 3007.5 |
| 357 | 2025-02-22 13:51:53 | pyrethrin | 1 | 81242 | 2 | 3.486 | 23305.2 |
| 356 | 2025-02-10 00:10:19 | pyrethrin | 3 | 148641 | 17 | 44.033 | 3375.7 |
| 355 | 2025-02-07 00:35:31 | pyrethrin | 3 | 148641 | 17 | 34.253 | 4339.5 |
| 354 | 2025-02-05 15:35:01 | pyrethrin | 1 | 81242 | 2 | 3.296 | 24648.7 |
| 353 | 2025-02-03 00:50:47 | pyrethrin | 3 | 148641 | 17 | 36.520 | 4070.1 |
| 352 | 2025-01-27 04:46:55 | pyrethrin | 3 | 148641 | 17 | 43.703 | 3401.2 |
| 351 | 2025-01-27 04:46:50 | pyrethrin | 3 | 148641 | 17 | 40.113 | 3705.6 |
| 350 | 2025-01-27 04:46:53 | pyrethrin | 2 | 121436 | 5 | 25.123 | 4833.7 |
| 349 | 2025-01-27 04:17:27 | pyrethrin | 1 | 81242 | 2 | 1.216 | 66810.9 |
| 348 | 2025-01-24 04:03:23 | pyrethrin | 1 | 81242 | 2 | 3.406 | 23852.6 |
| 347 | 2025-01-18 05:35:56 | pyrethrin | 1 | 81242 | 2 | 5.733 | 14170.9 |
| 346 | 2025-01-07 04:06:37 | pyrethrin | 3 | 148641 | 17 | 37.626 | 3950.5 |
| 345 | 2025-01-07 04:06:34 | pyrethrin | 2 | 121436 | 5 | 18.300 | 6635.8 |
| 344 | 2025-01-04 03:29:57 | pyrethrin | 1 | 81242 | 2 | 6.893 | 11786.2 |
| 343 | 2025-01-01 11:54:46 | pyrethrin | 3 | 148641 | 17 | 60.083 | 2473.9 |
| 342 | 2025-01-01 11:54:36 | pyrethrin | 2 | 121436 | 5 | 17.923 | 6775.4 |
| 341 | 2024-12-25 20:34:41 | pyrethrin | 4 | 165329 | 104 | 66.270 | 2494.8 |
| 340 | 2024-12-25 10:54:15 | pyrethrin | 4 | 165329 | 104 | 72.736 | 2273.0 |
| 339 | 2024-12-25 10:02:24 | pyrethrin | 1 | 81242 | 2 | 3.876 | 20960.3 |
| 338 | 2024-12-24 01:54:54 | pyrethrin | 3 | 148641 | 17 | 23.080 | 6440.3 |
| 337 | 2024-12-24 01:54:32 | pyrethrin | 2 | 121436 | 5 | 18.140 | 6694.4 |
| 336 | 2024-12-12 15:33:39 | pyrethrin | 2 | 121436 | 5 | 17.966 | 6759.2 |
| 335 | 2024-12-12 15:33:24 | pyrethrin | 3 | 148641 | 17 | 27.330 | 5438.7 |
| 334 | 2024-12-12 15:32:19 | pyrethrin | 1 | 81242 | 2 | 10.076 | 8062.9 |
| 333 | 2024-11-26 20:41:14 | pyrethrin | 3 | 148641 | 17 | 43.893 | 3386.4 |
| 332 | 2024-11-26 20:41:29 | pyrethrin | 2 | 121436 | 5 | 16.686 | 7277.7 |
| 331 | 2024-11-26 19:11:38 | pyrethrin | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 330 | 2024-11-25 02:39:36 | pyrethrin | 2 | 121436 | 5 | 26.063 | 4659.3 |
| 329 | 2024-11-23 14:06:22 | pyrethrin | 3 | 148641 | 17 | 48.523 | 3063.3 |
| 328 | 2024-11-23 03:11:06 | pyrethrin | 3 | 148641 | 17 | 35.940 | 4135.8 |
| 327 | 2024-11-20 23:03:23 | pyrethrin | 3 | 148641 | 17 | 43.080 | 3450.3 |
| 326 | 2024-11-20 23:03:24 | pyrethrin | 3 | 148641 | 17 | 33.376 | 4453.5 |
| 325 | 2024-11-19 13:28:23 | pyrethrin | 2 | 121436 | 5 | 27.270 | 4453.1 |
| 324 | 2024-11-19 13:20:23 | pyrethrin | 1 | 81242 | 2 | 6.500 | 12498.8 |
| 323 | 2024-11-10 07:01:19 | pyrethrin | 1 | 81242 | 2 | 3.423 | 23734.2 |
| 322 | 2024-11-09 07:24:41 | pyrethrin | 1 | 81242 | 2 | 3.203 | 25364.3 |
| 321 | 2024-11-02 15:43:26 | pyrethrin | 2 | 121436 | 5 | 16.906 | 7183.0 |
| 320 | 2024-10-26 02:07:35 | pyrethrin | 1 | 81242 | 2 | 6.266 | 12965.5 |
| 319 | 2024-10-26 01:54:40 | pyrethrin | 2 | 121436 | 5 | 17.236 | 7045.5 |
| 318 | 2024-10-21 17:41:07 | pyrethrin | 3 | 148641 | 17 | 41.690 | 3565.4 |
| 317 | 2024-10-19 10:24:39 | pyrethrin | 3 | 148641 | 17 | 36.786 | 4040.7 |
| 316 | 2024-10-19 03:22:27 | pyrethrin | 3 | 148641 | 17 | 43.763 | 3396.5 |
| 315 | 2024-10-19 03:22:16 | pyrethrin | 3 | 148641 | 17 | 33.456 | 4442.9 |
| 314 | 2024-10-19 03:22:24 | pyrethrin | 2 | 121436 | 5 | 17.123 | 7092.0 |
| 313 | 2024-10-07 09:14:25 | pyrethrin | 1 | 81242 | 2 | 9.563 | 8495.5 |
| 312 | 2024-10-04 23:52:57 | pyrethrin | 1 | 81242 | 2 | 5.690 | 14278.0 |
| 311 | 2024-09-26 04:28:03 | pyrethrin | 3 | 148641 | 17 | 74.520 | 1994.6 |
| 310 | 2024-09-26 04:27:58 | pyrethrin | 2 | 121436 | 5 | 18.686 | 6498.8 |
| 309 | 2024-09-25 23:55:25 | pyrethrin | 3 | 148641 | 17 | 55.533 | 2676.6 |
| 308 | 2024-09-25 23:55:27 | pyrethrin | 2 | 121436 | 5 | 25.956 | 4678.5 |
| 307 | 2024-09-21 04:44:59 | pyrethrin | 1 | 81242 | 2 | 14.330 | 5669.4 |
| 306 | 2024-09-13 17:48:26 | pyrethrin | 3 | 148641 | 17 | 69.020 | 2153.6 |
| 305 | 2024-09-05 11:46:29 | pyrethrin | 1 | 81242 | 2 | 8.736 | 9299.7 |
| 304 | 2024-08-13 19:13:22 | pyrethrin | 3 | 148641 | 17 | 51.450 | 2889.0 |
| 303 | 2024-08-13 19:13:21 | pyrethrin | 2 | 121436 | 5 | 29.263 | 4149.8 |
| 302 | 2024-08-08 11:10:57 | pyrethrin | 3 | 148641 | 17 | 35.126 | 4231.7 |
| 301 | 2024-08-08 11:11:01 | pyrethrin | 2 | 121436 | 5 | 22.736 | 5341.1 |
| 300 | 2024-08-08 11:10:11 | pyrethrin | 1 | 81242 | 2 | 6.126 | 13261.8 |
| 299 | 2024-08-05 03:24:56 | pyrethrin | 1 | 81242 | 2 | 5.530 | 14691.1 |
| 298 | 2024-08-01 18:56:21 | pyrethrin | 3 | 148641 | 17 | 43.706 | 3400.9 |
| 297 | 2024-08-01 18:56:23 | pyrethrin | 3 | 148641 | 17 | 23.300 | 6379.4 |
| 296 | 2024-08-01 18:55:51 | pyrethrin | 2 | 121436 | 5 | 11.110 | 10930.3 |
| 295 | 2024-08-01 05:58:17 | pyrethrin | 3 | 148641 | 17 | 36.356 | 4088.5 |
| 294 | 2024-08-01 05:58:20 | pyrethrin | 3 | 148641 | 17 | 12.313 | 12071.9 |