History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"varicella"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 346 | 2025-11-03 00:56:12 | varicella | 3 | 148641 | 15 | 7.046 | 21095.8 |
| 345 | 2025-11-02 18:00:08 | varicella | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 344 | 2025-09-18 08:00:37 | varicella | 1 | 81242 | 2 | 1.283 | 63321.9 |
| 343 | 2025-09-14 23:57:38 | varicella | 1 | 81242 | 2 | 1.483 | 54782.2 |
| 342 | 2025-09-12 03:06:50 | varicella | 2 | 121436 | 3 | 3.733 | 32530.4 |
| 341 | 2025-09-11 16:22:19 | varicella | 1 | 81242 | 2 | 1.343 | 60492.9 |
| 340 | 2025-09-10 03:19:03 | varicella | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 339 | 2025-09-09 01:57:25 | varicella | 1 | 81242 | 2 | 1.326 | 61268.5 |
| 338 | 2025-09-08 08:41:24 | varicella | 1 | 81242 | 2 | 1.233 | 65889.7 |
| 337 | 2025-09-07 14:25:35 | varicella | 1 | 81242 | 2 | 1.420 | 57212.7 |
| 336 | 2025-09-05 01:56:44 | varicella | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 335 | 2025-09-01 18:34:00 | varicella | 1 | 81242 | 2 | 2.080 | 39058.7 |
| 334 | 2025-08-29 10:53:15 | varicella | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 333 | 2025-08-27 18:48:17 | varicella | 4 | 165329 | 143 | 20.063 | 8240.5 |
| 332 | 2025-08-26 04:12:03 | varicella | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 331 | 2025-08-24 09:58:41 | varicella | 4 | 165329 | 143 | 75.566 | 2187.9 |
| 330 | 2025-08-23 14:26:27 | varicella | 2 | 121436 | 3 | 12.096 | 10039.4 |
| 329 | 2025-08-23 12:21:29 | varicella | 1 | 81242 | 2 | 3.656 | 22221.6 |
| 328 | 2025-08-23 10:14:27 | varicella | 3 | 148641 | 15 | 25.816 | 5757.7 |
| 327 | 2025-08-22 10:26:28 | varicella | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 326 | 2025-08-16 02:27:29 | varicella | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 325 | 2025-07-25 07:04:02 | varicella | 1 | 81242 | 2 | 3.906 | 20799.3 |
| 324 | 2025-07-20 06:51:47 | varicella | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 323 | 2025-07-13 21:58:54 | varicella | 2 | 121436 | 3 | 15.920 | 7627.9 |
| 322 | 2025-07-13 15:04:44 | varicella | 1 | 81242 | 2 | 1.440 | 56418.1 |
| 321 | 2025-07-13 12:22:12 | varicella | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 320 | 2025-07-10 17:06:14 | varicella | 1 | 81242 | 2 | 7.156 | 11353.0 |
| 319 | 2025-07-10 02:30:52 | varicella | 3 | 148641 | 15 | 36.533 | 4068.7 |
| 318 | 2025-07-08 11:56:33 | varicella | 3 | 148641 | 15 | 10.656 | 13949.0 |
| 317 | 2025-07-08 02:18:38 | varicella | 3 | 148641 | 15 | 38.620 | 3848.8 |
| 316 | 2025-07-07 11:42:02 | varicella | 3 | 148641 | 15 | 37.690 | 3943.8 |
| 315 | 2025-07-05 11:35:06 | varicella | 3 | 148641 | 15 | 41.470 | 3584.3 |
| 314 | 2025-07-05 05:29:19 | varicella | 2 | 121436 | 3 | 15.503 | 7833.1 |
| 313 | 2025-07-04 19:19:20 | varicella | 4 | 165329 | 143 | 52.516 | 3148.2 |
| 312 | 2025-07-03 14:53:27 | varicella | 1 | 81242 | 2 | 2.280 | 35632.5 |
| 311 | 2025-06-30 01:41:21 | varicella | 1 | 81242 | 2 | 6.640 | 12235.2 |
| 310 | 2025-05-22 11:42:32 | varicella | 1 | 81242 | 2 | 9.296 | 8739.5 |
| 309 | 2025-05-12 00:48:42 | varicella | 1 | 81242 | 2 | 7.126 | 11400.8 |
| 308 | 2025-04-17 03:10:43 | varicella | 3 | 148641 | 15 | 7.343 | 20242.5 |
| 307 | 2025-04-15 23:50:58 | varicella | 1 | 81242 | 2 | 6.716 | 12096.8 |
| 306 | 2025-04-14 15:57:45 | varicella | 1 | 81242 | 2 | 6.920 | 11740.2 |
| 305 | 2025-04-14 12:37:05 | varicella | 1 | 81242 | 2 | 7.703 | 10546.8 |
| 304 | 2025-03-29 04:53:52 | varicella | 3 | 148641 | 15 | 27.330 | 5438.7 |
| 303 | 2025-03-29 00:12:44 | varicella | 1 | 81242 | 2 | 3.670 | 22136.8 |
| 302 | 2025-03-27 13:34:49 | varicella | 3 | 148641 | 15 | 56.456 | 2632.9 |
| 301 | 2025-03-24 02:20:04 | varicella | 3 | 148641 | 15 | 45.910 | 3237.7 |
| 300 | 2025-03-23 23:04:32 | varicella | 2 | 121436 | 3 | 15.876 | 7649.0 |
| 299 | 2025-03-23 21:40:03 | varicella | 3 | 148641 | 15 | 32.706 | 4544.8 |
| 298 | 2025-03-22 12:45:47 | varicella | 1 | 81242 | 2 | 5.000 | 16248.4 |
| 297 | 2025-03-20 08:46:40 | varicella | 1 | 81242 | 2 | 3.313 | 24522.2 |
| 296 | 2025-03-16 22:10:52 | varicella | 1 | 81242 | 2 | 5.720 | 14203.1 |
| 295 | 2025-03-08 21:36:33 | varicella | 1 | 81242 | 2 | 9.860 | 8239.6 |
| 294 | 2025-03-08 00:42:08 | varicella | 4 | 165329 | 143 | 82.786 | 1997.1 |
| 293 | 2025-03-07 15:19:43 | varicella | 4 | 165329 | 143 | 44.613 | 3705.8 |
| 292 | 2025-03-07 04:01:28 | varicella | 3 | 148641 | 15 | 19.160 | 7757.9 |
| 291 | 2025-03-06 05:40:34 | varicella | 2 | 121436 | 3 | 17.533 | 6926.1 |
| 290 | 2025-03-05 21:30:02 | varicella | 4 | 165329 | 143 | 69.113 | 2392.2 |
| 289 | 2025-03-05 21:30:00 | varicella | 3 | 148641 | 15 | 52.516 | 2830.4 |
| 288 | 2025-03-05 21:29:59 | varicella | 2 | 121436 | 3 | 41.720 | 2910.7 |
| 287 | 2025-03-03 19:48:58 | varicella | 1 | 81242 | 2 | 6.550 | 12403.4 |
| 286 | 2025-02-20 21:39:02 | varicella | 1 | 81242 | 2 | 4.876 | 16661.6 |
| 285 | 2025-02-07 20:20:42 | varicella | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 284 | 2025-02-07 11:49:17 | varicella | 1 | 81242 | 2 | 6.610 | 12290.8 |
| 283 | 2025-01-23 12:55:04 | varicella | 3 | 148641 | 15 | 15.956 | 9315.7 |
| 282 | 2025-01-04 02:48:39 | varicella | 3 | 148641 | 15 | 44.580 | 3334.3 |
| 281 | 2025-01-04 02:48:35 | varicella | 2 | 121436 | 3 | 25.466 | 4768.6 |
| 280 | 2025-01-04 02:48:27 | varicella | 3 | 148641 | 15 | 22.063 | 6737.1 |
| 279 | 2025-01-04 01:39:07 | varicella | 1 | 81242 | 2 | 6.280 | 12936.6 |
| 278 | 2024-12-28 05:35:40 | varicella | 1 | 81242 | 2 | 3.000 | 27080.7 |
| 277 | 2024-12-28 01:15:31 | varicella | 3 | 148641 | 15 | 35.546 | 4181.7 |
| 276 | 2024-12-27 14:31:12 | varicella | 1 | 81242 | 2 | 1.203 | 67532.8 |
| 275 | 2024-12-27 01:28:55 | varicella | 3 | 148641 | 15 | 32.190 | 4617.6 |
| 274 | 2024-12-22 22:00:54 | varicella | 3 | 148641 | 15 | 35.736 | 4159.4 |
| 273 | 2024-12-22 22:00:48 | varicella | 2 | 121436 | 3 | 15.046 | 8071.0 |
| 272 | 2024-12-16 18:12:54 | varicella | 3 | 148641 | 15 | 40.083 | 3708.3 |
| 271 | 2024-12-16 18:12:55 | varicella | 2 | 121436 | 3 | 18.830 | 6449.1 |
| 270 | 2024-12-13 01:49:48 | varicella | 1 | 81242 | 2 | 10.033 | 8097.5 |
| 269 | 2024-11-28 10:11:30 | varicella | 1 | 81242 | 2 | 2.673 | 30393.6 |
| 268 | 2024-11-26 22:18:17 | varicella | 3 | 148641 | 15 | 44.240 | 3359.9 |
| 267 | 2024-11-24 16:09:35 | varicella | 3 | 148641 | 15 | 37.190 | 3996.8 |
| 266 | 2024-11-21 10:19:04 | varicella | 3 | 148641 | 15 | 27.733 | 5359.7 |
| 265 | 2024-11-09 18:29:07 | varicella | 1 | 81242 | 2 | 6.516 | 12468.1 |
| 264 | 2024-11-03 16:04:08 | varicella | 1 | 81242 | 2 | 1.486 | 54671.6 |
| 263 | 2024-10-26 17:02:09 | varicella | 1 | 81242 | 2 | 5.813 | 13975.9 |
| 262 | 2024-10-17 17:07:08 | varicella | 3 | 148641 | 15 | 39.573 | 3756.1 |
| 261 | 2024-10-17 17:07:07 | varicella | 3 | 148641 | 15 | 39.323 | 3780.0 |
| 260 | 2024-10-15 14:56:50 | varicella | 3 | 148641 | 15 | 35.360 | 4203.6 |
| 259 | 2024-10-11 02:55:38 | varicella | 2 | 121436 | 3 | 27.443 | 4425.0 |
| 258 | 2024-10-11 02:55:24 | varicella | 2 | 121436 | 3 | 21.816 | 5566.4 |
| 257 | 2024-10-11 02:55:22 | varicella | 2 | 121436 | 3 | 18.156 | 6688.5 |
| 256 | 2024-10-10 10:06:04 | varicella | 1 | 81242 | 2 | 6.733 | 12066.2 |
| 255 | 2024-10-03 05:19:11 | varicella | 3 | 148641 | 15 | 76.683 | 1938.4 |
| 254 | 2024-10-03 05:19:15 | varicella | 2 | 121436 | 3 | 34.623 | 3507.4 |
| 253 | 2024-09-24 16:03:41 | varicella | 1 | 81242 | 2 | 8.406 | 9664.8 |
| 252 | 2024-09-09 22:45:35 | varicella | 4 | 165329 | 143 | 102.160 | 1618.3 |
| 251 | 2024-09-06 13:55:43 | varicella | 4 | 165329 | 143 | 92.346 | 1790.3 |
| 250 | 2024-09-06 08:39:11 | varicella | 4 | 165329 | 143 | 98.863 | 1672.3 |
| 249 | 2024-08-22 10:39:40 | varicella | 1 | 81242 | 2 | 9.173 | 8856.6 |
| 248 | 2024-08-19 11:44:16 | varicella | 1 | 81242 | 2 | 7.910 | 10270.8 |
| 247 | 2024-08-16 14:21:45 | varicella | 4 | 165329 | 143 | 139.303 | 1186.8 |