History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drosera"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 343 | 2025-10-24 14:53:16 | drosera | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 342 | 2025-10-23 11:54:42 | drosera | 1 | 69583 | 2 | 7.606 | 9148.4 |
| 341 | 2025-10-23 11:54:21 | drosera | 1 | 69583 | 2 | 6.123 | 11364.2 |
| 340 | 2025-10-23 11:53:52 | drosera | 1 | 69583 | 2 | 2.940 | 23667.7 |
| 339 | 2025-10-23 11:53:25 | drosera | 1 | 69583 | 2 | 2.953 | 23563.5 |
| 338 | 2025-10-21 15:58:43 | drosera | 1 | 69583 | 2 | 2.953 | 23563.5 |
| 337 | 2025-09-25 18:59:18 | drosera | 1 | 69583 | 2 | 2.736 | 25432.4 |
| 336 | 2025-09-18 14:05:05 | drosera | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 335 | 2025-08-31 18:24:23 | drosera | 1 | 69583 | 2 | 1.076 | 64668.2 |
| 334 | 2025-08-27 09:39:09 | drosera | 1 | 69583 | 2 | 1.263 | 55093.4 |
| 333 | 2025-08-24 21:41:37 | drosera | 1 | 69583 | 2 | 2.830 | 24587.6 |
| 332 | 2025-08-16 21:48:44 | drosera | 1 | 69583 | 2 | 5.826 | 11943.5 |
| 331 | 2025-08-15 04:50:17 | drosera | 1 | 69583 | 2 | 2.203 | 31585.6 |
| 330 | 2025-08-03 18:13:48 | drosera | 1 | 69583 | 2 | 2.283 | 30478.8 |
| 329 | 2025-08-02 16:15:57 | drosera | 2 | 107671 | 14 | 7.796 | 13811.1 |
| 328 | 2025-08-01 07:29:05 | drosera | 1 | 69583 | 2 | 3.686 | 18877.6 |
| 327 | 2025-07-31 11:47:03 | drosera | 1 | 69583 | 2 | 1.390 | 50059.7 |
| 326 | 2025-07-24 23:52:48 | drosera | 1 | 69583 | 2 | 4.846 | 14358.9 |
| 325 | 2025-07-13 22:26:23 | drosera | 1 | 69583 | 2 | 2.983 | 23326.5 |
| 324 | 2025-07-09 08:54:21 | drosera | 1 | 69583 | 2 | 5.720 | 12164.9 |
| 323 | 2025-07-02 10:05:47 | drosera | 1 | 69583 | 2 | 8.156 | 8531.5 |
| 322 | 2025-06-26 16:43:12 | drosera | 3 | 134027 | 211 | 34.610 | 3872.5 |
| 321 | 2025-06-25 02:30:49 | drosera | 3 | 134027 | 211 | 23.826 | 5625.2 |
| 320 | 2025-06-24 10:51:40 | drosera | 1 | 69583 | 2 | 5.940 | 11714.3 |
| 319 | 2025-06-14 07:13:10 | drosera | 2 | 107671 | 14 | 14.720 | 7314.6 |
| 318 | 2025-06-13 05:43:45 | drosera | 1 | 69583 | 2 | 5.453 | 12760.5 |
| 317 | 2025-06-13 00:46:11 | drosera | 3 | 134027 | 211 | 22.720 | 5899.1 |
| 316 | 2025-06-12 21:43:12 | drosera | 1 | 69583 | 2 | 4.263 | 16322.5 |
| 315 | 2025-06-12 09:46:17 | drosera | 3 | 134027 | 211 | 31.253 | 4288.5 |
| 314 | 2025-06-10 23:05:53 | drosera | 3 | 134027 | 211 | 33.156 | 4042.3 |
| 313 | 2025-06-10 15:11:15 | drosera | 3 | 134027 | 211 | 33.466 | 4004.9 |
| 312 | 2025-06-08 06:47:09 | drosera | 3 | 134027 | 211 | 43.083 | 3110.9 |
| 311 | 2025-06-08 01:43:45 | drosera | 2 | 107671 | 14 | 18.206 | 5914.0 |
| 310 | 2025-06-07 22:41:30 | drosera | 1 | 69583 | 2 | 5.563 | 12508.2 |
| 309 | 2025-06-07 08:21:37 | drosera | 1 | 69583 | 2 | 1.170 | 59472.6 |
| 308 | 2025-06-02 02:20:29 | drosera | 2 | 107671 | 14 | 20.390 | 5280.6 |
| 307 | 2025-05-31 00:18:18 | drosera | 1 | 69583 | 2 | 4.456 | 15615.6 |
| 306 | 2025-05-30 15:02:15 | drosera | 1 | 69583 | 2 | 5.893 | 11807.7 |
| 305 | 2025-05-26 05:57:25 | drosera | 1 | 69583 | 2 | 3.030 | 22964.7 |
| 304 | 2025-05-22 11:31:24 | drosera | 1 | 69583 | 2 | 2.983 | 23326.5 |
| 303 | 2025-05-17 16:54:02 | drosera | 1 | 69583 | 2 | 1.140 | 61037.7 |
| 302 | 2025-05-11 21:58:25 | drosera | 1 | 69583 | 2 | 4.266 | 16311.1 |
| 301 | 2025-05-04 22:10:18 | drosera | 1 | 69583 | 2 | 5.753 | 12095.1 |
| 300 | 2025-05-02 03:39:01 | drosera | 1 | 69583 | 2 | 6.750 | 10308.6 |
| 299 | 2025-04-27 01:04:15 | drosera | 2 | 107671 | 14 | 3.016 | 35699.9 |
| 298 | 2025-04-23 16:52:22 | drosera | 2 | 107671 | 14 | 29.563 | 3642.1 |
| 297 | 2025-04-22 09:24:11 | drosera | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 296 | 2025-04-21 15:03:54 | drosera | 3 | 134027 | 211 | 45.673 | 2934.5 |
| 295 | 2025-04-21 06:12:52 | drosera | 3 | 134027 | 211 | 39.626 | 3382.3 |
| 294 | 2025-04-21 00:53:05 | drosera | 3 | 134027 | 211 | 45.910 | 2919.3 |
| 293 | 2025-04-20 00:29:50 | drosera | 3 | 134027 | 211 | 33.953 | 3947.4 |
| 292 | 2025-04-19 16:21:57 | drosera | 3 | 134027 | 211 | 5.796 | 23124.1 |
| 291 | 2025-04-10 21:55:05 | drosera | 1 | 69583 | 2 | 3.046 | 22844.1 |
| 290 | 2025-04-04 22:03:54 | drosera | 1 | 69583 | 2 | 3.593 | 19366.3 |
| 289 | 2025-04-02 00:36:33 | drosera | 2 | 107671 | 14 | 15.593 | 6905.1 |
| 288 | 2025-04-01 04:47:06 | drosera | 1 | 69583 | 2 | 1.263 | 55093.4 |
| 287 | 2025-03-20 23:08:48 | drosera | 3 | 134027 | 211 | 29.673 | 4516.8 |
| 286 | 2025-03-20 13:07:57 | drosera | 3 | 134027 | 211 | 31.706 | 4227.2 |
| 285 | 2025-03-20 11:25:14 | drosera | 1 | 69583 | 2 | 3.070 | 22665.5 |
| 284 | 2025-03-20 04:41:43 | drosera | 3 | 134027 | 211 | 32.143 | 4169.7 |
| 283 | 2025-03-18 01:23:16 | drosera | 3 | 134027 | 211 | 33.703 | 3976.7 |
| 282 | 2025-03-15 10:51:18 | drosera | 1 | 69583 | 2 | 4.316 | 16122.1 |
| 281 | 2025-03-14 12:55:03 | drosera | 1 | 69583 | 2 | 1.046 | 66522.9 |
| 280 | 2025-03-08 00:50:19 | drosera | 1 | 69583 | 2 | 8.220 | 8465.1 |
| 279 | 2025-03-05 04:38:48 | drosera | 1 | 69583 | 2 | 2.970 | 23428.6 |
| 278 | 2025-02-18 08:53:36 | drosera | 1 | 69583 | 2 | 3.826 | 18186.9 |
| 277 | 2025-02-09 03:32:19 | drosera | 1 | 69583 | 2 | 4.546 | 15306.4 |
| 276 | 2025-01-29 15:57:14 | drosera | 3 | 134027 | 211 | 24.826 | 5398.7 |
| 275 | 2025-01-28 19:19:00 | drosera | 3 | 134027 | 211 | 31.563 | 4246.3 |
| 274 | 2025-01-28 15:21:54 | drosera | 3 | 134027 | 211 | 30.376 | 4412.3 |
| 273 | 2025-01-28 10:35:34 | drosera | 3 | 134027 | 211 | 26.160 | 5123.4 |
| 272 | 2025-01-08 15:31:27 | drosera | 1 | 69583 | 2 | 2.983 | 23326.5 |
| 271 | 2025-01-03 02:33:54 | drosera | 1 | 69583 | 2 | 5.670 | 12272.1 |
| 270 | 2024-12-29 13:10:38 | drosera | 1 | 69583 | 2 | 5.220 | 13330.1 |
| 269 | 2024-12-10 03:23:29 | drosera | 1 | 69583 | 2 | 8.343 | 8340.3 |
| 268 | 2024-12-09 13:23:21 | drosera | 1 | 69583 | 2 | 8.860 | 7853.6 |
| 267 | 2024-11-10 22:59:02 | drosera | 3 | 134027 | 211 | 37.613 | 3563.3 |
| 266 | 2024-11-09 10:35:48 | drosera | 2 | 107671 | 14 | 16.533 | 6512.5 |
| 265 | 2024-11-09 09:28:49 | drosera | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 264 | 2024-11-08 16:15:40 | drosera | 2 | 107671 | 14 | 15.003 | 7176.6 |
| 263 | 2024-11-08 13:34:11 | drosera | 3 | 134027 | 211 | 38.066 | 3520.9 |
| 262 | 2024-11-08 11:06:14 | drosera | 3 | 134027 | 211 | 37.610 | 3563.6 |
| 261 | 2024-11-08 06:31:51 | drosera | 3 | 134027 | 211 | 33.330 | 4021.2 |
| 260 | 2024-11-08 06:31:50 | drosera | 2 | 107671 | 14 | 13.826 | 7787.6 |
| 259 | 2024-11-08 05:40:09 | drosera | 1 | 69583 | 2 | 4.373 | 15912.0 |
| 258 | 2024-10-26 21:16:33 | drosera | 1 | 69583 | 2 | 2.966 | 23460.2 |
| 257 | 2024-10-25 16:55:12 | drosera | 1 | 69583 | 2 | 6.873 | 10124.1 |
| 256 | 2024-09-29 11:30:26 | drosera | 1 | 69583 | 2 | 8.766 | 7937.8 |
| 255 | 2024-09-25 02:50:12 | drosera | 1 | 69583 | 2 | 13.063 | 5326.7 |
| 254 | 2024-09-04 13:24:17 | drosera | 1 | 69583 | 2 | 4.360 | 15959.4 |
| 253 | 2024-08-29 11:44:51 | drosera | 1 | 69583 | 2 | 8.310 | 8373.4 |
| 252 | 2024-08-19 02:21:04 | drosera | 1 | 69583 | 2 | 12.236 | 5686.7 |
| 251 | 2024-08-11 22:23:07 | drosera | 1 | 69583 | 2 | 3.563 | 19529.3 |
| 250 | 2024-08-09 05:50:40 | drosera | 3 | 134027 | 211 | 33.640 | 3984.2 |
| 249 | 2024-08-08 18:46:40 | drosera | 3 | 134027 | 211 | 35.986 | 3724.4 |
| 248 | 2024-08-08 18:46:43 | drosera | 2 | 107671 | 14 | 13.733 | 7840.3 |
| 247 | 2024-08-08 18:42:13 | drosera | 1 | 69583 | 2 | 5.470 | 12720.8 |
| 246 | 2024-08-01 07:59:44 | drosera | 1 | 69583 | 2 | 2.300 | 30253.5 |
| 245 | 2024-07-31 13:29:57 | drosera | 1 | 69583 | 2 | 4.156 | 16742.8 |
| 244 | 2024-07-30 05:33:08 | drosera | 1 | 69583 | 2 | 4.470 | 15566.7 |