History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"daffodil"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 338 | 2025-10-03 12:34:16 | daffodil | 4 | 161609 | 80 | 10.500 | 15391.3 |
| 337 | 2025-09-19 09:32:04 | daffodil | 1 | 82945 | 2 | 1.420 | 58412.0 |
| 336 | 2025-09-17 13:32:00 | daffodil | 4 | 161609 | 80 | 11.983 | 13486.5 |
| 335 | 2025-09-15 03:57:42 | daffodil | 4 | 161609 | 80 | 16.000 | 10100.6 |
| 334 | 2025-09-13 04:11:40 | daffodil | 4 | 161609 | 80 | 11.783 | 13715.4 |
| 333 | 2025-09-06 14:30:11 | daffodil | 3 | 146162 | 5 | 6.236 | 23438.4 |
| 332 | 2025-08-31 22:01:28 | daffodil | 1 | 82945 | 2 | 2.003 | 41410.4 |
| 331 | 2025-07-19 17:03:15 | daffodil | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 330 | 2025-07-17 01:57:54 | daffodil | 1 | 82945 | 2 | 5.750 | 14425.2 |
| 329 | 2025-07-12 08:51:32 | daffodil | 1 | 82945 | 2 | 2.873 | 28870.5 |
| 328 | 2025-05-28 16:27:14 | daffodil | 1 | 82945 | 2 | 1.703 | 48705.2 |
| 327 | 2025-05-27 11:19:54 | daffodil | 1 | 82945 | 2 | 5.173 | 16034.2 |
| 326 | 2025-05-26 01:09:33 | daffodil | 1 | 82945 | 2 | 7.000 | 11849.3 |
| 325 | 2025-04-23 06:12:22 | daffodil | 1 | 82945 | 2 | 3.873 | 21416.2 |
| 324 | 2025-04-05 22:24:49 | daffodil | 1 | 82945 | 2 | 10.486 | 7910.1 |
| 323 | 2025-03-21 03:02:28 | daffodil | 1 | 82945 | 2 | 3.500 | 23698.6 |
| 322 | 2025-03-17 05:22:05 | daffodil | 1 | 82945 | 2 | 6.780 | 12233.8 |
| 321 | 2025-03-10 17:45:07 | daffodil | 1 | 82945 | 2 | 3.453 | 24021.1 |
| 320 | 2025-02-20 18:53:45 | daffodil | 3 | 146162 | 5 | 45.220 | 3232.2 |
| 319 | 2025-02-20 18:53:42 | daffodil | 2 | 121059 | 2 | 17.673 | 6849.9 |
| 318 | 2025-02-20 18:52:46 | daffodil | 1 | 82945 | 2 | 3.653 | 22706.0 |
| 317 | 2025-02-09 23:02:36 | daffodil | 1 | 82945 | 2 | 7.110 | 11666.0 |
| 316 | 2025-02-05 23:32:45 | daffodil | 1 | 82945 | 2 | 1.326 | 62552.8 |
| 315 | 2025-02-04 03:28:37 | daffodil | 3 | 146162 | 5 | 44.346 | 3295.9 |
| 314 | 2025-02-01 12:12:16 | daffodil | 3 | 146162 | 5 | 46.096 | 3170.8 |
| 313 | 2025-01-30 22:14:55 | daffodil | 2 | 121059 | 2 | 19.330 | 6262.8 |
| 312 | 2025-01-30 22:14:34 | daffodil | 3 | 146162 | 5 | 33.940 | 4306.5 |
| 311 | 2025-01-30 22:13:57 | daffodil | 1 | 82945 | 2 | 3.606 | 23001.9 |
| 310 | 2025-01-29 20:10:26 | daffodil | 4 | 161609 | 80 | 71.440 | 2262.2 |
| 309 | 2025-01-28 00:41:01 | daffodil | 4 | 161609 | 80 | 11.940 | 13535.1 |
| 308 | 2025-01-24 23:23:11 | daffodil | 4 | 161609 | 80 | 11.736 | 13770.4 |
| 307 | 2025-01-24 23:23:15 | daffodil | 3 | 146162 | 5 | 7.190 | 20328.5 |
| 306 | 2025-01-23 21:55:39 | daffodil | 3 | 146162 | 5 | 15.940 | 9169.5 |
| 305 | 2025-01-19 00:05:50 | daffodil | 1 | 82945 | 2 | 9.420 | 8805.2 |
| 304 | 2025-01-13 17:53:15 | daffodil | 4 | 161609 | 80 | 63.596 | 2541.2 |
| 303 | 2025-01-13 17:53:19 | daffodil | 3 | 146162 | 5 | 35.906 | 4070.7 |
| 302 | 2025-01-13 17:53:21 | daffodil | 2 | 121059 | 2 | 23.173 | 5224.1 |
| 301 | 2025-01-13 17:53:08 | daffodil | 1 | 82945 | 2 | 9.953 | 8333.7 |
| 300 | 2025-01-01 21:25:35 | daffodil | 4 | 161609 | 80 | 67.050 | 2410.3 |
| 299 | 2024-12-31 22:48:23 | daffodil | 4 | 161609 | 80 | 77.566 | 2083.5 |
| 298 | 2024-12-28 08:42:14 | daffodil | 2 | 121059 | 2 | 16.516 | 7329.8 |
| 297 | 2024-12-28 08:17:39 | daffodil | 3 | 146162 | 5 | 7.593 | 19249.6 |
| 296 | 2024-12-27 20:12:08 | daffodil | 4 | 161609 | 80 | 41.896 | 3857.4 |
| 295 | 2024-12-27 20:12:09 | daffodil | 4 | 161609 | 80 | 34.813 | 4642.2 |
| 294 | 2024-12-27 20:12:11 | daffodil | 3 | 146162 | 5 | 30.080 | 4859.1 |
| 293 | 2024-12-27 20:12:10 | daffodil | 2 | 121059 | 2 | 6.813 | 17768.8 |
| 292 | 2024-12-27 20:12:03 | daffodil | 1 | 82945 | 2 | 6.220 | 13335.2 |
| 291 | 2024-12-11 16:06:42 | daffodil | 1 | 82945 | 2 | 6.486 | 12788.3 |
| 290 | 2024-12-04 07:07:15 | daffodil | 1 | 82945 | 2 | 5.296 | 15661.8 |
| 289 | 2024-12-02 08:39:08 | daffodil | 3 | 146162 | 5 | 22.703 | 6438.0 |
| 288 | 2024-11-25 15:03:54 | daffodil | 3 | 146162 | 5 | 45.110 | 3240.1 |
| 287 | 2024-11-25 15:03:52 | daffodil | 3 | 146162 | 5 | 29.253 | 4996.5 |
| 286 | 2024-11-25 15:03:49 | daffodil | 3 | 146162 | 5 | 26.473 | 5521.2 |
| 285 | 2024-11-25 15:03:52 | daffodil | 2 | 121059 | 2 | 15.830 | 7647.4 |
| 284 | 2024-11-25 15:03:46 | daffodil | 1 | 82945 | 2 | 2.796 | 29665.6 |
| 283 | 2024-11-24 22:37:04 | daffodil | 3 | 146162 | 5 | 53.266 | 2744.0 |
| 282 | 2024-11-24 22:37:08 | daffodil | 3 | 146162 | 5 | 33.983 | 4301.0 |
| 281 | 2024-11-24 22:36:57 | daffodil | 3 | 146162 | 5 | 36.220 | 4035.4 |
| 280 | 2024-11-24 22:36:57 | daffodil | 2 | 121059 | 2 | 12.983 | 9324.4 |
| 279 | 2024-11-24 22:36:41 | daffodil | 1 | 82945 | 2 | 3.330 | 24908.4 |
| 278 | 2024-11-03 14:47:08 | daffodil | 3 | 146162 | 5 | 37.983 | 3848.1 |
| 277 | 2024-11-01 09:43:11 | daffodil | 3 | 146162 | 5 | 39.206 | 3728.1 |
| 276 | 2024-11-01 09:43:21 | daffodil | 2 | 121059 | 2 | 10.406 | 11633.6 |
| 275 | 2024-11-01 09:42:18 | daffodil | 1 | 82945 | 2 | 3.330 | 24908.4 |
| 274 | 2024-10-26 09:07:57 | daffodil | 1 | 82945 | 2 | 3.750 | 22118.7 |
| 273 | 2024-10-04 18:23:40 | daffodil | 1 | 82945 | 2 | 14.110 | 5878.5 |
| 272 | 2024-09-28 14:25:52 | daffodil | 1 | 82945 | 2 | 8.953 | 9264.5 |
| 271 | 2024-09-20 12:23:44 | daffodil | 1 | 82945 | 2 | 16.613 | 4992.8 |
| 270 | 2024-09-16 11:02:01 | daffodil | 1 | 82945 | 2 | 4.860 | 17066.9 |
| 269 | 2024-08-08 23:56:17 | daffodil | 4 | 161609 | 80 | 53.363 | 3028.5 |
| 268 | 2024-08-08 23:56:21 | daffodil | 3 | 146162 | 5 | 36.093 | 4049.6 |
| 267 | 2024-08-08 23:56:26 | daffodil | 2 | 121059 | 2 | 17.330 | 6985.5 |
| 266 | 2024-08-08 21:12:55 | daffodil | 2 | 121059 | 2 | 17.170 | 7050.6 |
| 265 | 2024-08-08 21:12:51 | daffodil | 3 | 146162 | 5 | 16.126 | 9063.7 |
| 264 | 2024-08-08 21:11:58 | daffodil | 1 | 82945 | 2 | 6.156 | 13473.8 |
| 263 | 2024-07-29 01:47:54 | daffodil | 1 | 82945 | 2 | 4.796 | 17294.6 |
| 262 | 2024-07-27 01:13:21 | daffodil | 1 | 82945 | 2 | 9.920 | 8361.4 |
| 261 | 2024-07-20 04:30:25 | daffodil | 3 | 146162 | 5 | 33.330 | 4385.3 |
| 260 | 2024-07-20 00:51:01 | daffodil | 4 | 161609 | 80 | 55.346 | 2920.0 |
| 259 | 2024-07-20 00:51:03 | daffodil | 3 | 146162 | 5 | 36.876 | 3963.6 |
| 258 | 2024-07-20 00:51:03 | daffodil | 2 | 121059 | 2 | 24.296 | 4982.7 |
| 257 | 2024-07-20 00:49:06 | daffodil | 1 | 82945 | 2 | 4.720 | 17573.1 |
| 256 | 2024-07-16 21:41:44 | daffodil | 1 | 82945 | 2 | 2.500 | 33178.0 |
| 255 | 2024-07-16 21:41:29 | daffodil | 1 | 82945 | 2 | 2.983 | 27805.9 |
| 254 | 2024-07-07 17:36:58 | daffodil | 1 | 82945 | 2 | 7.783 | 10657.2 |
| 253 | 2024-06-19 20:09:27 | daffodil | 1 | 82945 | 2 | 4.483 | 18502.1 |
| 252 | 2024-05-30 17:32:19 | daffodil | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 251 | 2024-05-29 05:46:18 | daffodil | 1 | 82945 | 2 | 6.516 | 12729.4 |
| 250 | 2024-05-24 04:06:17 | daffodil | 4 | 161609 | 80 | 40.706 | 3970.2 |
| 249 | 2024-05-24 04:06:28 | daffodil | 2 | 121059 | 2 | 12.970 | 9333.8 |
| 248 | 2024-05-24 04:06:21 | daffodil | 3 | 146162 | 5 | 12.470 | 11721.1 |
| 247 | 2024-05-24 04:05:42 | daffodil | 1 | 82945 | 2 | 4.860 | 17066.9 |
| 246 | 2024-05-23 09:05:52 | daffodil | 1 | 82945 | 2 | 6.843 | 12121.1 |
| 245 | 2024-05-14 15:25:06 | daffodil | 4 | 161609 | 80 | 15.236 | 10607.0 |
| 244 | 2024-05-12 07:16:29 | daffodil | 2 | 121059 | 2 | 4.373 | 27683.3 |
| 243 | 2024-05-12 07:15:39 | daffodil | 3 | 146162 | 5 | 27.313 | 5351.4 |
| 242 | 2024-05-12 07:15:39 | daffodil | 4 | 161609 | 80 | 21.720 | 7440.6 |
| 241 | 2024-05-12 07:15:50 | daffodil | 1 | 82945 | 2 | 4.783 | 17341.6 |
| 240 | 2024-05-12 07:15:27 | daffodil | 2 | 121059 | 2 | 8.923 | 13567.1 |
| 239 | 2024-05-12 07:15:21 | daffodil | 1 | 82945 | 2 | 3.406 | 24352.6 |