History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shamrock"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 377 | 2025-10-19 06:46:15 | shamrock | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 376 | 2025-09-25 03:38:13 | shamrock | 1 | 82945 | 2 | 5.373 | 15437.4 |
| 375 | 2025-09-25 03:38:06 | shamrock | 1 | 82945 | 2 | 5.830 | 14227.3 |
| 374 | 2025-09-25 03:38:02 | shamrock | 1 | 82945 | 2 | 6.610 | 12548.4 |
| 373 | 2025-09-08 05:59:43 | shamrock | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 372 | 2025-08-14 09:13:24 | shamrock | 3 | 146162 | 42 | 6.313 | 23152.5 |
| 371 | 2025-08-04 12:38:11 | shamrock | 1 | 82945 | 2 | 5.016 | 16536.1 |
| 370 | 2025-08-01 16:12:18 | shamrock | 1 | 82945 | 2 | 6.500 | 12760.8 |
| 369 | 2025-07-27 14:35:46 | shamrock | 1 | 82945 | 2 | 3.013 | 27529.0 |
| 368 | 2025-07-27 06:32:54 | shamrock | 3 | 146162 | 42 | 26.113 | 5597.3 |
| 367 | 2025-07-26 05:40:29 | shamrock | 3 | 146162 | 42 | 38.770 | 3770.0 |
| 366 | 2025-07-23 14:58:53 | shamrock | 3 | 146162 | 42 | 19.280 | 7581.0 |
| 365 | 2025-07-19 17:01:46 | shamrock | 3 | 146162 | 42 | 10.813 | 13517.2 |
| 364 | 2025-07-13 08:01:34 | shamrock | 1 | 82945 | 2 | 1.610 | 51518.6 |
| 363 | 2025-06-24 04:16:44 | shamrock | 1 | 82945 | 2 | 6.230 | 13313.8 |
| 362 | 2025-06-16 00:56:17 | shamrock | 1 | 82945 | 2 | 7.156 | 11591.0 |
| 361 | 2025-06-06 10:47:07 | shamrock | 3 | 146162 | 42 | 31.270 | 4674.2 |
| 360 | 2025-06-03 03:40:50 | shamrock | 3 | 146162 | 42 | 19.440 | 7518.6 |
| 359 | 2025-05-29 22:59:20 | shamrock | 3 | 146162 | 42 | 37.053 | 3944.7 |
| 358 | 2025-05-14 01:29:22 | shamrock | 1 | 82945 | 2 | 3.343 | 24811.5 |
| 357 | 2025-05-12 10:09:22 | shamrock | 3 | 146162 | 42 | 40.923 | 3571.6 |
| 356 | 2025-05-09 17:11:55 | shamrock | 3 | 146162 | 42 | 8.576 | 17043.1 |
| 355 | 2025-05-06 04:13:03 | shamrock | 1 | 82945 | 2 | 4.610 | 17992.4 |
| 354 | 2025-05-02 10:18:45 | shamrock | 1 | 82945 | 2 | 9.783 | 8478.5 |
| 353 | 2025-04-29 03:15:40 | shamrock | 3 | 146162 | 42 | 41.330 | 3536.5 |
| 352 | 2025-04-28 06:31:17 | shamrock | 3 | 146162 | 42 | 41.643 | 3509.9 |
| 351 | 2025-04-26 21:01:52 | shamrock | 3 | 146162 | 42 | 12.283 | 11899.5 |
| 350 | 2025-04-06 02:27:40 | shamrock | 1 | 82945 | 2 | 6.766 | 12259.1 |
| 349 | 2025-04-04 10:27:04 | shamrock | 3 | 146162 | 42 | 29.546 | 4946.9 |
| 348 | 2025-04-02 00:36:35 | shamrock | 1 | 82945 | 2 | 6.753 | 12282.7 |
| 347 | 2025-03-28 11:59:19 | shamrock | 3 | 146162 | 42 | 37.550 | 3892.5 |
| 346 | 2025-03-22 04:06:34 | shamrock | 3 | 146162 | 42 | 39.516 | 3698.8 |
| 345 | 2025-03-21 19:12:35 | shamrock | 3 | 146162 | 42 | 44.860 | 3258.2 |
| 344 | 2025-03-21 12:07:35 | shamrock | 1 | 82945 | 2 | 8.046 | 10308.8 |
| 343 | 2025-03-20 18:21:20 | shamrock | 1 | 82945 | 2 | 7.330 | 11315.8 |
| 342 | 2025-03-17 08:15:43 | shamrock | 3 | 146162 | 42 | 40.843 | 3578.6 |
| 341 | 2025-03-16 15:52:38 | shamrock | 1 | 82945 | 2 | 7.190 | 11536.2 |
| 340 | 2025-03-16 03:16:27 | shamrock | 1 | 82945 | 2 | 8.280 | 10017.5 |
| 339 | 2025-03-12 08:32:35 | shamrock | 3 | 146162 | 42 | 39.483 | 3701.9 |
| 338 | 2025-03-04 19:13:44 | shamrock | 3 | 146162 | 42 | 36.500 | 4004.4 |
| 337 | 2025-03-04 12:34:40 | shamrock | 3 | 146162 | 42 | 43.050 | 3395.2 |
| 336 | 2025-03-04 12:32:04 | shamrock | 1 | 82945 | 2 | 10.873 | 7628.5 |
| 335 | 2025-03-01 13:17:45 | shamrock | 1 | 82945 | 2 | 7.843 | 10575.7 |
| 334 | 2025-03-01 07:50:55 | shamrock | 3 | 146162 | 42 | 29.610 | 4936.2 |
| 333 | 2025-03-01 06:33:17 | shamrock | 3 | 146162 | 42 | 38.070 | 3839.3 |
| 332 | 2025-02-16 22:08:09 | shamrock | 1 | 82945 | 2 | 7.016 | 11822.3 |
| 331 | 2025-02-09 23:06:57 | shamrock | 1 | 82945 | 2 | 6.983 | 11878.1 |
| 330 | 2025-02-02 19:09:03 | shamrock | 2 | 121059 | 4 | 18.516 | 6538.1 |
| 329 | 2025-02-02 19:08:19 | shamrock | 1 | 82945 | 2 | 8.173 | 10148.7 |
| 328 | 2025-01-29 11:20:33 | shamrock | 4 | 161609 | 341 | 72.923 | 2216.2 |
| 327 | 2025-01-28 16:03:40 | shamrock | 4 | 161609 | 341 | 62.943 | 2567.5 |
| 326 | 2025-01-28 13:51:08 | shamrock | 4 | 161609 | 341 | 55.000 | 2938.3 |
| 325 | 2025-01-27 04:06:16 | shamrock | 3 | 146162 | 42 | 18.033 | 8105.3 |
| 324 | 2025-01-26 19:45:51 | shamrock | 1 | 82945 | 2 | 6.906 | 12010.6 |
| 323 | 2025-01-25 15:57:40 | shamrock | 3 | 146162 | 42 | 9.876 | 14799.7 |
| 322 | 2025-01-12 10:09:35 | shamrock | 3 | 146162 | 42 | 41.503 | 3521.7 |
| 321 | 2025-01-08 21:13:43 | shamrock | 4 | 161609 | 341 | 45.086 | 3584.5 |
| 320 | 2025-01-08 12:58:47 | shamrock | 3 | 146162 | 42 | 7.500 | 19488.3 |
| 319 | 2025-01-08 12:58:46 | shamrock | 2 | 121059 | 4 | 3.843 | 31501.2 |
| 318 | 2025-01-07 21:02:44 | shamrock | 3 | 146162 | 42 | 8.170 | 17890.1 |
| 317 | 2025-01-07 21:02:45 | shamrock | 2 | 121059 | 4 | 5.483 | 22079.0 |
| 316 | 2025-01-07 21:02:37 | shamrock | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 315 | 2025-01-04 20:46:32 | shamrock | 1 | 82945 | 2 | 11.030 | 7519.9 |
| 314 | 2024-12-28 07:55:21 | shamrock | 4 | 161609 | 341 | 31.970 | 5055.0 |
| 313 | 2024-12-26 20:49:55 | shamrock | 4 | 161609 | 341 | 63.300 | 2553.1 |
| 312 | 2024-12-26 18:11:24 | shamrock | 4 | 161609 | 341 | 57.503 | 2810.4 |
| 311 | 2024-12-26 15:22:33 | shamrock | 4 | 161609 | 341 | 66.326 | 2436.6 |
| 310 | 2024-12-23 05:40:30 | shamrock | 1 | 82945 | 2 | 7.843 | 10575.7 |
| 309 | 2024-12-15 18:58:43 | shamrock | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 308 | 2024-12-07 12:53:53 | shamrock | 2 | 121059 | 4 | 18.296 | 6616.7 |
| 307 | 2024-11-30 01:56:54 | shamrock | 2 | 121059 | 4 | 19.063 | 6350.5 |
| 306 | 2024-11-30 01:56:17 | shamrock | 1 | 82945 | 2 | 7.390 | 11224.0 |
| 305 | 2024-11-29 11:44:54 | shamrock | 1 | 82945 | 2 | 6.813 | 12174.5 |
| 304 | 2024-11-29 10:53:03 | shamrock | 3 | 146162 | 42 | 24.423 | 5984.6 |
| 303 | 2024-11-28 01:38:32 | shamrock | 4 | 161609 | 341 | 60.850 | 2655.9 |
| 302 | 2024-11-26 16:30:58 | shamrock | 3 | 146162 | 42 | 7.703 | 18974.7 |
| 301 | 2024-11-25 11:27:21 | shamrock | 3 | 146162 | 42 | 28.236 | 5176.4 |
| 300 | 2024-11-22 13:35:12 | shamrock | 4 | 161609 | 341 | 53.113 | 3042.7 |
| 299 | 2024-11-20 19:23:28 | shamrock | 3 | 146162 | 42 | 28.673 | 5097.5 |
| 298 | 2024-11-20 09:13:16 | shamrock | 4 | 161609 | 341 | 64.553 | 2503.5 |
| 297 | 2024-11-20 09:13:15 | shamrock | 3 | 146162 | 42 | 38.350 | 3811.3 |
| 296 | 2024-11-20 09:13:16 | shamrock | 2 | 121059 | 4 | 15.750 | 7686.3 |
| 295 | 2024-11-20 09:11:21 | shamrock | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 294 | 2024-11-14 14:49:35 | shamrock | 1 | 82945 | 2 | 1.953 | 42470.6 |
| 293 | 2024-10-30 20:47:55 | shamrock | 2 | 121059 | 4 | 9.143 | 13240.6 |
| 292 | 2024-10-30 20:47:57 | shamrock | 1 | 82945 | 2 | 6.780 | 12233.8 |
| 291 | 2024-10-29 21:58:46 | shamrock | 1 | 82945 | 2 | 7.560 | 10971.6 |
| 290 | 2024-10-28 22:43:15 | shamrock | 3 | 146162 | 42 | 7.436 | 19656.0 |
| 289 | 2024-10-28 21:04:39 | shamrock | 2 | 121059 | 4 | 3.750 | 32282.4 |
| 288 | 2024-10-28 10:51:26 | shamrock | 3 | 146162 | 42 | 34.156 | 4279.2 |
| 287 | 2024-10-21 20:03:20 | shamrock | 3 | 146162 | 42 | 31.883 | 4584.3 |
| 286 | 2024-10-19 15:43:35 | shamrock | 3 | 146162 | 42 | 51.253 | 2851.8 |
| 285 | 2024-10-18 10:18:54 | shamrock | 1 | 82945 | 2 | 3.296 | 25165.4 |
| 284 | 2024-10-14 17:02:34 | shamrock | 3 | 146162 | 42 | 32.133 | 4548.7 |
| 283 | 2024-10-14 17:02:35 | shamrock | 2 | 121059 | 4 | 18.583 | 6514.5 |
| 282 | 2024-10-14 17:01:14 | shamrock | 1 | 82945 | 2 | 1.533 | 54106.3 |
| 281 | 2024-10-02 06:31:57 | shamrock | 4 | 161609 | 341 | 76.943 | 2100.4 |
| 280 | 2024-10-01 16:51:17 | shamrock | 4 | 161609 | 341 | 108.333 | 1491.8 |
| 279 | 2024-09-30 21:01:17 | shamrock | 4 | 161609 | 341 | 105.006 | 1539.0 |
| 278 | 2024-09-21 07:59:49 | shamrock | 1 | 82945 | 2 | 15.503 | 5350.3 |