History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"olivine"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 374 | 2025-12-15 13:44:09 | olivine | 3 | 134027 | 174 | 12.156 | 11025.6 |
| 373 | 2025-12-14 19:13:31 | olivine | 3 | 134027 | 174 | 6.953 | 19276.1 |
| 372 | 2025-11-23 13:15:20 | olivine | 1 | 69583 | 2 | 1.080 | 64428.7 |
| 371 | 2025-11-01 07:05:31 | olivine | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 370 | 2025-09-18 21:27:45 | olivine | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 369 | 2025-09-02 14:29:17 | olivine | 1 | 69583 | 2 | 1.093 | 63662.4 |
| 368 | 2025-08-26 19:11:07 | olivine | 1 | 69583 | 2 | 1.123 | 61961.7 |
| 367 | 2025-08-26 02:16:36 | olivine | 1 | 69583 | 2 | 2.983 | 23326.5 |
| 366 | 2025-08-12 14:21:28 | olivine | 2 | 107671 | 13 | 15.703 | 6856.7 |
| 365 | 2025-08-08 23:43:04 | olivine | 2 | 107671 | 13 | 15.283 | 7045.1 |
| 364 | 2025-08-04 19:46:38 | olivine | 1 | 69583 | 2 | 4.796 | 14508.5 |
| 363 | 2025-08-02 04:46:13 | olivine | 2 | 107671 | 13 | 6.360 | 16929.4 |
| 362 | 2025-08-02 04:21:46 | olivine | 3 | 134027 | 174 | 33.750 | 3971.2 |
| 361 | 2025-08-02 01:19:41 | olivine | 1 | 69583 | 2 | 2.640 | 26357.2 |
| 360 | 2025-08-01 15:07:03 | olivine | 1 | 69583 | 2 | 7.313 | 9515.0 |
| 359 | 2025-07-31 11:34:03 | olivine | 1 | 69583 | 2 | 4.656 | 14944.8 |
| 358 | 2025-07-26 19:50:04 | olivine | 1 | 69583 | 2 | 2.953 | 23563.5 |
| 357 | 2025-07-25 03:01:48 | olivine | 1 | 69583 | 2 | 3.780 | 18408.2 |
| 356 | 2025-07-25 00:31:25 | olivine | 1 | 69583 | 2 | 4.440 | 15671.8 |
| 355 | 2025-07-20 23:41:03 | olivine | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 354 | 2025-07-10 06:25:05 | olivine | 1 | 69583 | 2 | 7.720 | 9013.3 |
| 353 | 2025-07-05 14:13:05 | olivine | 3 | 134027 | 174 | 28.673 | 4674.3 |
| 352 | 2025-07-05 12:43:20 | olivine | 3 | 134027 | 174 | 45.063 | 2974.2 |
| 351 | 2025-07-05 06:22:06 | olivine | 3 | 134027 | 174 | 35.236 | 3803.7 |
| 350 | 2025-07-03 17:16:47 | olivine | 3 | 134027 | 174 | 12.453 | 10762.6 |
| 349 | 2025-06-30 03:43:08 | olivine | 1 | 69583 | 2 | 6.110 | 11388.4 |
| 348 | 2025-06-17 14:14:50 | olivine | 2 | 107671 | 13 | 8.986 | 11982.1 |
| 347 | 2025-06-15 20:20:11 | olivine | 1 | 69583 | 2 | 8.046 | 8648.1 |
| 346 | 2025-06-15 19:29:08 | olivine | 1 | 69583 | 2 | 1.686 | 41271.1 |
| 345 | 2025-06-07 14:15:40 | olivine | 1 | 69583 | 2 | 6.580 | 10574.9 |
| 344 | 2025-05-30 03:22:09 | olivine | 1 | 69583 | 2 | 4.080 | 17054.7 |
| 343 | 2025-05-27 06:29:08 | olivine | 1 | 69583 | 2 | 5.360 | 12981.9 |
| 342 | 2025-05-23 23:22:10 | olivine | 1 | 69583 | 2 | 5.843 | 11908.8 |
| 341 | 2025-05-23 03:34:42 | olivine | 1 | 69583 | 2 | 4.793 | 14517.6 |
| 340 | 2025-05-20 15:27:24 | olivine | 1 | 69583 | 2 | 8.876 | 7839.5 |
| 339 | 2025-05-13 11:58:33 | olivine | 2 | 107671 | 13 | 8.266 | 13025.8 |
| 338 | 2025-05-09 04:23:15 | olivine | 1 | 69583 | 2 | 1.236 | 56296.9 |
| 337 | 2025-05-06 18:43:14 | olivine | 1 | 69583 | 2 | 2.906 | 23944.6 |
| 336 | 2025-05-06 14:54:00 | olivine | 1 | 69583 | 2 | 6.800 | 10232.8 |
| 335 | 2025-05-01 20:51:46 | olivine | 2 | 107671 | 13 | 16.300 | 6605.6 |
| 334 | 2025-05-01 09:19:59 | olivine | 3 | 134027 | 174 | 7.033 | 19056.9 |
| 333 | 2025-04-29 02:38:22 | olivine | 3 | 134027 | 174 | 37.423 | 3581.4 |
| 332 | 2025-04-27 14:10:35 | olivine | 2 | 107671 | 13 | 7.626 | 14118.9 |
| 331 | 2025-04-26 11:57:58 | olivine | 3 | 134027 | 174 | 32.393 | 4137.5 |
| 330 | 2025-04-25 19:22:10 | olivine | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 329 | 2025-04-25 01:33:52 | olivine | 3 | 134027 | 174 | 21.000 | 6382.2 |
| 328 | 2025-04-24 06:48:26 | olivine | 3 | 134027 | 174 | 34.206 | 3918.2 |
| 327 | 2025-04-22 02:10:40 | olivine | 1 | 69583 | 2 | 1.686 | 41271.1 |
| 326 | 2025-04-17 18:30:55 | olivine | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 325 | 2025-04-11 15:58:37 | olivine | 1 | 69583 | 2 | 3.420 | 20345.9 |
| 324 | 2025-03-31 02:54:27 | olivine | 1 | 69583 | 2 | 6.360 | 10940.7 |
| 323 | 2025-03-27 12:00:45 | olivine | 3 | 134027 | 174 | 34.126 | 3927.4 |
| 322 | 2025-03-26 22:06:20 | olivine | 2 | 107671 | 13 | 15.846 | 6794.8 |
| 321 | 2025-03-26 03:06:21 | olivine | 1 | 69583 | 2 | 3.343 | 20814.5 |
| 320 | 2025-03-25 00:42:15 | olivine | 2 | 107671 | 13 | 12.530 | 8593.1 |
| 319 | 2025-03-24 23:12:28 | olivine | 3 | 134027 | 174 | 32.906 | 4073.0 |
| 318 | 2025-03-22 03:51:19 | olivine | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 317 | 2025-03-19 20:39:48 | olivine | 1 | 69583 | 2 | 5.780 | 12038.6 |
| 316 | 2025-03-15 02:53:24 | olivine | 1 | 69583 | 2 | 5.953 | 11688.7 |
| 315 | 2025-03-10 19:40:44 | olivine | 1 | 69583 | 2 | 2.576 | 27012.0 |
| 314 | 2025-03-08 20:12:26 | olivine | 1 | 69583 | 2 | 2.876 | 24194.4 |
| 313 | 2025-02-27 23:39:22 | olivine | 1 | 69583 | 2 | 5.046 | 13789.7 |
| 312 | 2025-02-10 14:24:17 | olivine | 1 | 69583 | 2 | 5.580 | 12470.1 |
| 311 | 2025-01-26 17:07:23 | olivine | 1 | 69583 | 2 | 1.076 | 64668.2 |
| 310 | 2025-01-15 04:01:18 | olivine | 1 | 69583 | 2 | 5.483 | 12690.7 |
| 309 | 2024-12-13 12:27:37 | olivine | 1 | 69583 | 2 | 2.876 | 24194.4 |
| 308 | 2024-11-12 14:54:12 | olivine | 3 | 134027 | 174 | 34.330 | 3904.1 |
| 307 | 2024-11-12 10:01:45 | olivine | 3 | 134027 | 174 | 39.470 | 3395.7 |
| 306 | 2024-11-12 06:06:55 | olivine | 3 | 134027 | 174 | 43.456 | 3084.2 |
| 305 | 2024-11-11 13:49:32 | olivine | 3 | 134027 | 174 | 34.720 | 3860.2 |
| 304 | 2024-11-11 13:49:36 | olivine | 2 | 107671 | 13 | 11.470 | 9387.2 |
| 303 | 2024-11-11 08:44:34 | olivine | 1 | 69583 | 2 | 1.046 | 66522.9 |
| 302 | 2024-11-06 21:56:22 | olivine | 1 | 69583 | 2 | 4.453 | 15626.1 |
| 301 | 2024-10-26 09:26:17 | olivine | 1 | 69583 | 2 | 6.096 | 11414.5 |
| 300 | 2024-10-25 14:48:38 | olivine | 1 | 69583 | 2 | 5.076 | 13708.2 |
| 299 | 2024-10-15 09:41:44 | olivine | 1 | 69583 | 2 | 3.970 | 17527.2 |
| 298 | 2024-10-07 21:13:51 | olivine | 1 | 69583 | 2 | 10.550 | 6595.5 |
| 297 | 2024-09-26 06:07:14 | olivine | 1 | 69583 | 2 | 8.910 | 7809.5 |
| 296 | 2024-09-24 23:16:44 | olivine | 1 | 69583 | 2 | 4.376 | 15901.1 |
| 295 | 2024-09-10 23:09:24 | olivine | 1 | 69583 | 2 | 9.673 | 7193.5 |
| 294 | 2024-08-31 08:55:31 | olivine | 1 | 69583 | 2 | 10.313 | 6747.1 |
| 293 | 2024-08-20 04:17:18 | olivine | 1 | 69583 | 2 | 13.000 | 5352.5 |
| 292 | 2024-08-16 06:14:35 | olivine | 1 | 69583 | 2 | 9.093 | 7652.4 |
| 291 | 2024-08-12 19:33:52 | olivine | 1 | 69583 | 2 | 10.813 | 6435.1 |
| 290 | 2024-08-11 04:14:27 | olivine | 1 | 69583 | 2 | 4.533 | 15350.3 |
| 289 | 2024-08-02 09:39:17 | olivine | 1 | 69583 | 2 | 1.813 | 38380.0 |
| 288 | 2024-07-31 11:44:17 | olivine | 1 | 69583 | 2 | 2.190 | 31773.1 |
| 287 | 2024-07-19 00:09:52 | olivine | 1 | 69583 | 2 | 2.220 | 31343.7 |
| 286 | 2024-07-18 15:53:23 | olivine | 1 | 69583 | 2 | 5.576 | 12479.0 |
| 285 | 2024-07-13 09:18:27 | olivine | 1 | 69583 | 2 | 3.860 | 18026.7 |
| 284 | 2024-07-08 08:56:33 | olivine | 1 | 69583 | 2 | 6.283 | 11074.8 |
| 283 | 2024-07-03 06:02:46 | olivine | 2 | 107671 | 13 | 15.046 | 7156.1 |
| 282 | 2024-07-02 17:04:07 | olivine | 2 | 107671 | 13 | 2.893 | 37217.8 |
| 281 | 2024-07-02 13:18:28 | olivine | 1 | 69583 | 2 | 5.233 | 13297.0 |
| 280 | 2024-06-21 02:36:54 | olivine | 1 | 69583 | 2 | 3.750 | 18555.5 |
| 279 | 2024-06-20 03:42:42 | olivine | 1 | 69583 | 2 | 6.203 | 11217.6 |
| 278 | 2024-06-17 11:24:44 | olivine | 1 | 69583 | 2 | 2.233 | 31161.2 |
| 277 | 2024-06-17 07:38:23 | olivine | 1 | 69583 | 2 | 3.220 | 21609.6 |
| 276 | 2024-06-15 19:27:14 | olivine | 1 | 69583 | 2 | 4.406 | 15792.8 |
| 275 | 2024-06-03 06:49:15 | olivine | 1 | 69583 | 2 | 1.216 | 57222.9 |