History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wilily"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 335 | 2024-05-01 12:18:45 | wilily | 3 | 112716 | 496 | 14.453 | 7798.8 |
| 334 | 2024-05-01 03:25:56 | wilily | 3 | 112716 | 496 | 8.906 | 12656.2 |
| 333 | 2024-05-01 03:26:00 | wilily | 2 | 82551 | 45 | 2.500 | 33020.4 |
| 332 | 2024-05-01 03:25:52 | wilily | 1 | 48755 | 5 | 1.186 | 41108.8 |
| 331 | 2024-05-01 03:25:44 | wilily | 2 | 82551 | 45 | 2.876 | 28703.4 |
| 330 | 2024-04-28 02:35:35 | wilily | 1 | 48755 | 5 | 0.983 | 49598.2 |
| 329 | 2024-04-06 12:24:35 | wilily | 1 | 48755 | 5 | 3.000 | 16251.7 |
| 328 | 2024-03-30 20:00:01 | wilily | 3 | 112716 | 496 | 11.063 | 10188.6 |
| 327 | 2024-03-30 01:58:20 | wilily | 3 | 112716 | 496 | 16.126 | 6989.7 |
| 326 | 2024-03-28 21:26:34 | wilily | 3 | 112716 | 496 | 12.423 | 9073.2 |
| 325 | 2024-03-28 21:26:35 | wilily | 2 | 82551 | 45 | 5.826 | 14169.4 |
| 324 | 2024-03-28 21:26:24 | wilily | 3 | 112716 | 496 | 12.610 | 8938.6 |
| 323 | 2024-03-28 21:26:30 | wilily | 1 | 48755 | 5 | 1.780 | 27390.4 |
| 322 | 2024-03-28 21:26:23 | wilily | 2 | 82551 | 45 | 2.750 | 30018.5 |
| 321 | 2024-03-28 21:26:15 | wilily | 1 | 48755 | 5 | 0.966 | 50471.0 |
| 320 | 2024-03-23 08:01:54 | wilily | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 319 | 2024-01-04 02:05:33 | wilily | 3 | 112716 | 496 | 5.173 | 21789.3 |
| 318 | 2024-01-04 02:05:32 | wilily | 2 | 82551 | 45 | 2.250 | 36689.3 |
| 317 | 2023-12-19 20:01:36 | wilily | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 316 | 2023-12-07 20:10:03 | wilily | 2 | 82551 | 45 | 2.063 | 40015.0 |
| 315 | 2023-12-07 20:10:00 | wilily | 2 | 82551 | 45 | 2.470 | 33421.5 |
| 314 | 2023-12-06 06:19:27 | wilily | 3 | 112716 | 496 | 5.156 | 21861.1 |
| 313 | 2023-12-06 06:19:22 | wilily | 2 | 82551 | 45 | 2.046 | 40347.5 |
| 312 | 2023-11-14 03:35:26 | wilily | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 311 | 2023-11-11 01:27:15 | wilily | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 310 | 2023-11-04 04:22:28 | wilily | 1 | 48755 | 5 | 1.733 | 28133.3 |
| 309 | 2023-10-22 13:25:29 | wilily | 1 | 48755 | 5 | 1.670 | 29194.6 |
| 308 | 2023-10-19 00:41:41 | wilily | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 307 | 2023-10-15 10:23:36 | wilily | 1 | 48755 | 5 | 1.750 | 27860.0 |
| 306 | 2023-10-14 00:34:45 | wilily | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 305 | 2023-10-07 16:31:22 | wilily | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 304 | 2023-10-03 17:29:17 | wilily | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 303 | 2023-09-29 02:45:22 | wilily | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 302 | 2023-09-13 11:45:20 | wilily | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 301 | 2023-08-03 21:34:00 | wilily | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 300 | 2023-06-08 09:10:40 | wilily | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 299 | 2023-05-04 22:44:26 | wilily | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 298 | 2023-02-26 20:22:20 | wilily | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 297 | 2023-02-10 00:47:14 | wilily | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 296 | 2022-12-25 10:31:15 | wilily | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 295 | 2022-10-01 15:55:59 | wilily | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 294 | 2022-09-13 14:30:01 | wilily | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 293 | 2022-07-17 09:47:44 | wilily | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 292 | 2022-05-08 01:52:13 | wilily | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 291 | 2022-03-19 06:44:59 | wilily | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 290 | 2022-01-07 04:21:55 | wilily | 1 | 48755 | 5 | 0.940 | 51867.0 |
| 289 | 2021-12-29 11:56:23 | wilily | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 288 | 2021-11-03 03:40:07 | wilily | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 287 | 2021-11-01 02:08:52 | wilily | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 286 | 2021-09-24 14:20:01 | wilily | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 285 | 2021-09-18 09:35:33 | wilily | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 284 | 2021-09-03 04:15:20 | wilily | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 283 | 2021-06-15 00:26:25 | wilily | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 282 | 2021-06-02 16:15:30 | wilily | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 281 | 2021-05-08 11:01:03 | wilily | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 280 | 2021-04-06 21:29:46 | wilily | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 279 | 2021-03-08 10:26:17 | wilily | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 278 | 2020-12-23 02:30:17 | wilily | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 277 | 2020-12-04 22:18:53 | wilily | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 276 | 2020-10-25 16:13:56 | wilily | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 275 | 2020-10-23 06:34:21 | wilily | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 274 | 2020-10-21 04:07:54 | wilily | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 273 | 2020-10-12 06:52:10 | wilily | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 272 | 2020-10-11 07:02:06 | wilily | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 271 | 2020-09-15 22:49:09 | wilily | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 270 | 2020-08-23 17:48:57 | wilily | 1 | 48755 | 5 | 0.800 | 60943.8 |
| 269 | 2020-08-14 06:28:08 | wilily | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 268 | 2020-07-26 14:50:02 | wilily | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 267 | 2020-05-07 01:38:35 | wilily | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 266 | 2020-04-21 12:57:09 | wilily | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 265 | 2020-03-28 06:46:30 | wilily | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 264 | 2020-03-25 12:11:03 | wilily | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 263 | 2020-03-24 07:16:13 | wilily | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 262 | 2020-03-23 17:47:34 | wilily | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 261 | 2020-03-20 01:01:00 | wilily | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 260 | 2020-02-28 14:23:25 | wilily | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 259 | 2020-02-23 02:14:14 | wilily | 1 | 48755 | 5 | 1.796 | 27146.4 |
| 258 | 2020-02-18 09:55:12 | wilily | 1 | 48755 | 5 | 2.360 | 20658.9 |
| 257 | 2020-02-06 07:21:06 | wilily | 1 | 48755 | 5 | 1.500 | 32503.3 |
| 256 | 2020-02-05 20:24:13 | wilily | 1 | 48755 | 5 | 1.330 | 36657.9 |
| 255 | 2020-02-05 15:08:40 | wilily | 1 | 48755 | 5 | 1.890 | 25796.3 |
| 254 | 2020-02-05 05:38:48 | wilily | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 253 | 2020-02-04 13:44:22 | wilily | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 252 | 2020-02-01 13:11:32 | wilily | 1 | 48755 | 5 | 1.890 | 25796.3 |
| 251 | 2020-01-27 18:37:26 | wilily | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 250 | 2020-01-24 16:24:28 | wilily | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 249 | 2020-01-16 02:23:26 | wilily | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 248 | 2020-01-15 09:15:01 | wilily | 1 | 48755 | 5 | 1.420 | 34334.5 |
| 247 | 2020-01-12 12:58:52 | wilily | 1 | 48755 | 5 | 1.000 | 48755.0 |
| 246 | 2020-01-08 06:42:59 | wilily | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 245 | 2019-12-27 22:23:16 | wilily | 1 | 48755 | 5 | 1.673 | 29142.3 |
| 244 | 2019-12-27 05:35:36 | wilily | 1 | 48755 | 5 | 1.783 | 27344.4 |
| 243 | 2019-12-27 03:56:31 | wilily | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 242 | 2019-12-26 17:47:06 | wilily | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 241 | 2019-11-03 19:40:53 | wilily | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 240 | 2019-08-02 16:12:19 | wilily | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 239 | 2019-06-04 14:04:25 | wilily | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 238 | 2019-05-30 19:51:26 | wilily | 1 | 48755 | 5 | 0.930 | 52424.7 |
| 237 | 2019-04-26 10:02:05 | wilily | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 236 | 2019-02-21 00:14:43 | wilily | 1 | 48755 | 5 | 0.803 | 60716.1 |