History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scratched"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 327 | 2025-10-25 08:54:22 | scratched | 1 | 81242 | 4 | 2.686 | 30246.5 |
| 326 | 2025-10-23 14:18:57 | scratched | 3 | 148641 | 114 | 35.003 | 4246.5 |
| 325 | 2025-10-23 14:18:44 | scratched | 3 | 148641 | 114 | 22.220 | 6689.5 |
| 324 | 2025-10-23 14:18:27 | scratched | 3 | 148641 | 114 | 25.860 | 5747.9 |
| 323 | 2025-10-23 14:18:11 | scratched | 3 | 148641 | 114 | 27.096 | 5485.7 |
| 322 | 2025-10-19 05:43:56 | scratched | 3 | 148641 | 114 | 7.470 | 19898.4 |
| 321 | 2025-10-05 18:23:33 | scratched | 1 | 81242 | 4 | 1.516 | 53589.7 |
| 320 | 2025-10-01 23:30:10 | scratched | 3 | 148641 | 114 | 6.376 | 23312.6 |
| 319 | 2025-09-07 17:14:58 | scratched | 3 | 148641 | 114 | 7.733 | 19221.6 |
| 318 | 2025-08-27 14:44:30 | scratched | 1 | 81242 | 4 | 1.563 | 51978.2 |
| 317 | 2025-08-26 04:23:00 | scratched | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 316 | 2025-08-25 13:14:04 | scratched | 3 | 148641 | 114 | 22.436 | 6625.1 |
| 315 | 2025-08-22 16:30:42 | scratched | 3 | 148641 | 114 | 8.373 | 17752.4 |
| 314 | 2025-08-19 10:41:27 | scratched | 3 | 148641 | 114 | 20.910 | 7108.6 |
| 313 | 2025-08-15 07:56:18 | scratched | 3 | 148641 | 114 | 16.953 | 8767.8 |
| 312 | 2025-08-11 11:19:09 | scratched | 2 | 121436 | 24 | 18.736 | 6481.4 |
| 311 | 2025-08-11 09:12:44 | scratched | 3 | 148641 | 114 | 18.813 | 7901.0 |
| 310 | 2025-08-10 05:31:44 | scratched | 3 | 148641 | 114 | 20.033 | 7419.8 |
| 309 | 2025-08-09 17:03:43 | scratched | 1 | 81242 | 4 | 5.140 | 15805.8 |
| 308 | 2025-08-09 03:42:17 | scratched | 1 | 81242 | 4 | 4.280 | 18981.8 |
| 307 | 2025-08-08 22:39:08 | scratched | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 306 | 2025-08-02 04:32:48 | scratched | 1 | 81242 | 4 | 3.500 | 23212.0 |
| 305 | 2025-08-01 02:24:31 | scratched | 1 | 81242 | 4 | 4.796 | 16939.5 |
| 304 | 2025-07-31 21:00:26 | scratched | 1 | 81242 | 4 | 7.266 | 11181.1 |
| 303 | 2025-07-25 06:09:24 | scratched | 1 | 81242 | 4 | 3.263 | 24897.9 |
| 302 | 2025-07-24 21:01:08 | scratched | 1 | 81242 | 4 | 5.110 | 15898.6 |
| 301 | 2025-07-24 18:17:55 | scratched | 1 | 81242 | 4 | 7.093 | 11453.8 |
| 300 | 2025-07-23 05:16:44 | scratched | 1 | 81242 | 4 | 5.096 | 15942.3 |
| 299 | 2025-07-22 23:10:10 | scratched | 1 | 81242 | 4 | 3.736 | 21745.7 |
| 298 | 2025-07-13 17:24:28 | scratched | 1 | 81242 | 4 | 3.813 | 21306.6 |
| 297 | 2025-07-13 09:30:04 | scratched | 1 | 81242 | 4 | 2.923 | 27794.0 |
| 296 | 2025-07-10 21:31:25 | scratched | 2 | 121436 | 24 | 9.470 | 12823.2 |
| 295 | 2025-07-10 04:49:07 | scratched | 1 | 81242 | 4 | 12.986 | 6256.1 |
| 294 | 2025-07-09 17:06:29 | scratched | 1 | 81242 | 4 | 1.250 | 64993.6 |
| 293 | 2025-07-08 06:44:53 | scratched | 2 | 121436 | 24 | 24.406 | 4975.7 |
| 292 | 2025-06-30 08:11:36 | scratched | 3 | 148641 | 114 | 36.376 | 4086.2 |
| 291 | 2025-06-29 05:32:25 | scratched | 3 | 148641 | 114 | 6.673 | 22275.0 |
| 290 | 2025-06-28 08:10:24 | scratched | 3 | 148641 | 114 | 34.546 | 4302.7 |
| 289 | 2025-06-26 02:11:41 | scratched | 2 | 121436 | 24 | 22.390 | 5423.7 |
| 288 | 2025-06-24 04:38:55 | scratched | 2 | 121436 | 24 | 18.956 | 6406.2 |
| 287 | 2025-06-23 15:51:20 | scratched | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 286 | 2025-06-22 13:33:18 | scratched | 3 | 148641 | 114 | 37.143 | 4001.9 |
| 285 | 2025-06-21 10:25:32 | scratched | 3 | 148641 | 114 | 35.580 | 4177.7 |
| 284 | 2025-06-20 00:29:58 | scratched | 3 | 148641 | 114 | 31.346 | 4741.9 |
| 283 | 2025-06-19 14:18:22 | scratched | 3 | 148641 | 114 | 39.890 | 3726.3 |
| 282 | 2025-06-18 12:38:36 | scratched | 3 | 148641 | 114 | 35.393 | 4199.7 |
| 281 | 2025-06-16 05:27:47 | scratched | 1 | 81242 | 4 | 3.560 | 22820.8 |
| 280 | 2025-06-16 01:43:47 | scratched | 3 | 148641 | 114 | 43.673 | 3403.5 |
| 279 | 2025-06-13 12:14:10 | scratched | 3 | 148641 | 114 | 8.716 | 17053.8 |
| 278 | 2025-06-11 13:23:15 | scratched | 3 | 148641 | 114 | 18.876 | 7874.6 |
| 277 | 2025-06-08 17:02:30 | scratched | 1 | 81242 | 4 | 6.843 | 11872.3 |
| 276 | 2025-06-05 01:58:15 | scratched | 1 | 81242 | 4 | 7.156 | 11353.0 |
| 275 | 2025-05-29 14:48:39 | scratched | 1 | 81242 | 4 | 3.453 | 23527.9 |
| 274 | 2025-05-29 10:01:22 | scratched | 1 | 81242 | 4 | 7.376 | 11014.4 |
| 273 | 2025-05-26 19:54:22 | scratched | 1 | 81242 | 4 | 5.970 | 13608.4 |
| 272 | 2025-05-24 05:21:38 | scratched | 2 | 121436 | 24 | 17.236 | 7045.5 |
| 271 | 2025-05-22 08:28:52 | scratched | 3 | 148641 | 114 | 29.206 | 5089.4 |
| 270 | 2025-05-21 21:22:59 | scratched | 2 | 121436 | 24 | 14.830 | 8188.5 |
| 269 | 2025-05-20 07:57:08 | scratched | 3 | 148641 | 114 | 41.253 | 3603.2 |
| 268 | 2025-05-20 00:07:48 | scratched | 3 | 148641 | 114 | 30.033 | 4949.3 |
| 267 | 2025-05-19 10:42:53 | scratched | 3 | 148641 | 114 | 7.470 | 19898.4 |
| 266 | 2025-05-12 16:55:45 | scratched | 1 | 81242 | 4 | 3.623 | 22424.0 |
| 265 | 2025-05-10 08:47:06 | scratched | 1 | 81242 | 4 | 9.643 | 8425.0 |
| 264 | 2025-05-08 16:48:45 | scratched | 1 | 81242 | 4 | 9.843 | 8253.8 |
| 263 | 2025-05-02 04:58:05 | scratched | 1 | 81242 | 4 | 4.890 | 16613.9 |
| 262 | 2025-04-28 08:58:21 | scratched | 2 | 121436 | 24 | 19.406 | 6257.7 |
| 261 | 2025-04-27 15:27:36 | scratched | 1 | 81242 | 4 | 1.436 | 56575.2 |
| 260 | 2025-04-25 18:49:04 | scratched | 3 | 148641 | 114 | 7.626 | 19491.3 |
| 259 | 2025-04-22 10:11:42 | scratched | 3 | 148641 | 114 | 10.796 | 13768.2 |
| 258 | 2025-04-17 23:10:37 | scratched | 3 | 148641 | 114 | 38.203 | 3890.8 |
| 257 | 2025-04-17 20:39:14 | scratched | 2 | 121436 | 24 | 18.046 | 6729.2 |
| 256 | 2025-04-16 14:02:29 | scratched | 1 | 81242 | 4 | 6.986 | 11629.3 |
| 255 | 2025-04-11 13:32:47 | scratched | 3 | 148641 | 114 | 22.266 | 6675.7 |
| 254 | 2025-04-09 14:23:38 | scratched | 3 | 148641 | 114 | 28.063 | 5296.7 |
| 253 | 2025-04-08 08:06:41 | scratched | 1 | 81242 | 4 | 6.016 | 13504.3 |
| 252 | 2025-04-06 16:07:13 | scratched | 1 | 81242 | 4 | 6.750 | 12035.9 |
| 251 | 2025-04-06 07:51:09 | scratched | 3 | 148641 | 114 | 33.003 | 4503.9 |
| 250 | 2025-04-06 00:49:25 | scratched | 3 | 148641 | 114 | 20.393 | 7288.8 |
| 249 | 2025-04-05 02:22:29 | scratched | 3 | 148641 | 114 | 18.156 | 8186.9 |
| 248 | 2025-04-02 01:03:11 | scratched | 1 | 81242 | 4 | 7.143 | 11373.7 |
| 247 | 2025-03-31 06:18:32 | scratched | 1 | 81242 | 4 | 7.170 | 11330.8 |
| 246 | 2025-03-25 17:17:43 | scratched | 1 | 81242 | 4 | 3.546 | 22910.9 |
| 245 | 2025-03-15 23:21:02 | scratched | 1 | 81242 | 4 | 3.953 | 20552.0 |
| 244 | 2025-03-11 07:45:45 | scratched | 2 | 121436 | 24 | 18.356 | 6615.6 |
| 243 | 2025-03-10 01:39:32 | scratched | 3 | 148641 | 114 | 26.343 | 5642.5 |
| 242 | 2025-03-10 01:39:28 | scratched | 2 | 121436 | 24 | 17.846 | 6804.7 |
| 241 | 2025-03-08 19:21:41 | scratched | 3 | 148641 | 114 | 34.516 | 4306.4 |
| 240 | 2025-03-08 18:40:52 | scratched | 1 | 81242 | 4 | 10.390 | 7819.2 |
| 239 | 2025-02-25 17:19:22 | scratched | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 238 | 2025-02-22 03:44:53 | scratched | 3 | 148641 | 114 | 36.800 | 4039.2 |
| 237 | 2025-02-22 03:44:47 | scratched | 2 | 121436 | 24 | 24.656 | 4925.2 |
| 236 | 2025-02-22 03:43:23 | scratched | 1 | 81242 | 4 | 6.906 | 11764.0 |
| 235 | 2025-02-08 15:40:23 | scratched | 1 | 81242 | 4 | 8.953 | 9074.3 |
| 234 | 2025-02-05 15:57:30 | scratched | 3 | 148641 | 114 | 48.813 | 3045.1 |
| 233 | 2025-02-01 15:30:06 | scratched | 1 | 81242 | 4 | 5.186 | 15665.6 |
| 232 | 2025-01-31 21:59:27 | scratched | 3 | 148641 | 114 | 38.486 | 3862.2 |
| 231 | 2025-01-31 07:21:11 | scratched | 3 | 148641 | 114 | 53.923 | 2756.5 |
| 230 | 2025-01-18 10:14:17 | scratched | 3 | 148641 | 114 | 35.440 | 4194.2 |
| 229 | 2025-01-18 10:13:57 | scratched | 1 | 81242 | 4 | 2.516 | 32290.1 |
| 228 | 2025-01-09 11:36:08 | scratched | 1 | 81242 | 4 | 10.016 | 8111.2 |