History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stocktaking"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 334 | 2026-01-09 05:22:07 | stocktaking | 4 | 148819 | 39 | 28.956 | 5139.5 |
| 333 | 2026-01-04 20:36:13 | stocktaking | 1 | 49908 | 2 | 1.890 | 26406.3 |
| 332 | 2026-01-02 23:51:54 | stocktaking | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 331 | 2025-12-01 03:07:02 | stocktaking | 1 | 49908 | 2 | 0.846 | 58992.9 |
| 330 | 2025-09-10 11:59:04 | stocktaking | 1 | 49908 | 2 | 0.750 | 66544.0 |
| 329 | 2025-09-02 11:36:26 | stocktaking | 1 | 49908 | 2 | 0.830 | 60130.1 |
| 328 | 2025-08-09 01:54:03 | stocktaking | 1 | 49908 | 2 | 3.923 | 12721.9 |
| 327 | 2025-08-02 12:56:53 | stocktaking | 4 | 148819 | 39 | 36.123 | 4119.8 |
| 326 | 2025-08-02 08:43:46 | stocktaking | 2 | 86808 | 3 | 5.903 | 14705.7 |
| 325 | 2025-07-29 18:35:05 | stocktaking | 4 | 148819 | 39 | 51.393 | 2895.7 |
| 324 | 2025-07-27 18:27:58 | stocktaking | 2 | 86808 | 3 | 6.186 | 14033.0 |
| 323 | 2025-07-27 06:32:10 | stocktaking | 3 | 121633 | 7 | 15.686 | 7754.2 |
| 322 | 2025-07-27 06:00:15 | stocktaking | 5 | 164607 | 376 | 39.330 | 4185.3 |
| 321 | 2025-07-25 18:39:23 | stocktaking | 4 | 148819 | 39 | 8.736 | 17035.1 |
| 320 | 2025-07-25 09:58:38 | stocktaking | 1 | 49908 | 2 | 1.906 | 26184.7 |
| 319 | 2025-07-24 19:08:41 | stocktaking | 1 | 49908 | 2 | 2.453 | 20345.7 |
| 318 | 2025-07-24 06:14:18 | stocktaking | 1 | 49908 | 2 | 2.173 | 22967.3 |
| 317 | 2025-07-18 11:27:34 | stocktaking | 1 | 49908 | 2 | 4.033 | 12374.9 |
| 316 | 2025-06-20 19:05:31 | stocktaking | 1 | 49908 | 2 | 1.970 | 25334.0 |
| 315 | 2025-06-18 04:48:14 | stocktaking | 1 | 49908 | 2 | 5.970 | 8359.8 |
| 314 | 2025-06-09 00:25:08 | stocktaking | 1 | 49908 | 2 | 0.750 | 66544.0 |
| 313 | 2025-05-27 05:21:02 | stocktaking | 1 | 49908 | 2 | 6.533 | 7639.4 |
| 312 | 2025-05-24 22:42:19 | stocktaking | 1 | 49908 | 2 | 0.750 | 66544.0 |
| 311 | 2025-05-24 01:51:33 | stocktaking | 1 | 49908 | 2 | 1.970 | 25334.0 |
| 310 | 2025-05-20 01:01:04 | stocktaking | 1 | 49908 | 2 | 1.860 | 26832.3 |
| 309 | 2025-05-16 07:27:18 | stocktaking | 4 | 148819 | 39 | 64.123 | 2320.8 |
| 308 | 2025-05-06 14:15:11 | stocktaking | 1 | 49908 | 2 | 3.623 | 13775.3 |
| 307 | 2025-04-23 04:20:53 | stocktaking | 1 | 49908 | 2 | 4.513 | 11058.7 |
| 306 | 2025-04-12 12:15:43 | stocktaking | 4 | 148819 | 39 | 51.936 | 2865.4 |
| 305 | 2025-04-06 23:39:56 | stocktaking | 4 | 148819 | 39 | 59.363 | 2506.9 |
| 304 | 2025-04-03 05:45:39 | stocktaking | 4 | 148819 | 39 | 13.186 | 11286.1 |
| 303 | 2025-04-02 07:41:42 | stocktaking | 1 | 49908 | 2 | 4.346 | 11483.7 |
| 302 | 2025-03-17 14:38:21 | stocktaking | 1 | 49908 | 2 | 5.516 | 9047.9 |
| 301 | 2025-03-16 13:59:34 | stocktaking | 4 | 148819 | 39 | 47.003 | 3166.2 |
| 300 | 2025-03-16 13:59:27 | stocktaking | 2 | 86808 | 3 | 11.626 | 7466.7 |
| 299 | 2025-03-16 13:58:05 | stocktaking | 1 | 49908 | 2 | 1.796 | 27788.4 |
| 298 | 2025-03-14 08:18:06 | stocktaking | 1 | 49908 | 2 | 1.876 | 26603.4 |
| 297 | 2025-03-09 14:42:46 | stocktaking | 4 | 148819 | 39 | 34.490 | 4314.8 |
| 296 | 2025-03-07 09:43:21 | stocktaking | 4 | 148819 | 39 | 31.720 | 4691.6 |
| 295 | 2025-03-05 11:48:19 | stocktaking | 4 | 148819 | 39 | 68.786 | 2163.5 |
| 294 | 2025-03-04 23:16:18 | stocktaking | 4 | 148819 | 39 | 46.520 | 3199.0 |
| 293 | 2025-03-04 23:16:23 | stocktaking | 2 | 86808 | 3 | 12.686 | 6842.8 |
| 292 | 2025-03-04 23:14:27 | stocktaking | 1 | 49908 | 2 | 1.623 | 30750.5 |
| 291 | 2025-02-23 07:12:36 | stocktaking | 3 | 121633 | 7 | 24.516 | 4961.4 |
| 290 | 2025-02-22 19:26:08 | stocktaking | 1 | 49908 | 2 | 4.873 | 10241.7 |
| 289 | 2025-02-17 06:31:37 | stocktaking | 3 | 121633 | 7 | 37.783 | 3219.3 |
| 288 | 2025-02-11 16:19:04 | stocktaking | 4 | 148819 | 39 | 57.096 | 2606.5 |
| 287 | 2025-02-11 16:18:58 | stocktaking | 3 | 121633 | 7 | 31.800 | 3824.9 |
| 286 | 2025-02-11 14:31:17 | stocktaking | 4 | 148819 | 39 | 61.503 | 2419.7 |
| 285 | 2025-02-05 11:12:29 | stocktaking | 1 | 49908 | 2 | 6.623 | 7535.6 |
| 284 | 2025-01-30 00:56:46 | stocktaking | 3 | 121633 | 7 | 6.796 | 17897.7 |
| 283 | 2025-01-21 16:57:27 | stocktaking | 1 | 49908 | 2 | 4.360 | 11446.8 |
| 282 | 2025-01-20 15:19:40 | stocktaking | 4 | 148819 | 39 | 64.473 | 2308.2 |
| 281 | 2025-01-20 15:20:13 | stocktaking | 3 | 121633 | 7 | 29.923 | 4064.9 |
| 280 | 2025-01-20 15:20:19 | stocktaking | 2 | 86808 | 3 | 10.750 | 8075.2 |
| 279 | 2025-01-20 15:16:33 | stocktaking | 1 | 49908 | 2 | 2.000 | 24954.0 |
| 278 | 2025-01-20 13:25:37 | stocktaking | 4 | 148819 | 39 | 46.830 | 3177.9 |
| 277 | 2025-01-20 13:25:55 | stocktaking | 2 | 86808 | 3 | 12.923 | 6717.3 |
| 276 | 2025-01-20 13:22:11 | stocktaking | 1 | 49908 | 2 | 5.766 | 8655.6 |
| 275 | 2025-01-02 03:56:55 | stocktaking | 4 | 148819 | 39 | 41.066 | 3623.9 |
| 274 | 2025-01-01 08:49:57 | stocktaking | 3 | 121633 | 7 | 24.346 | 4996.0 |
| 273 | 2025-01-01 08:49:25 | stocktaking | 4 | 148819 | 39 | 55.723 | 2670.7 |
| 272 | 2025-01-01 08:49:49 | stocktaking | 2 | 86808 | 3 | 11.923 | 7280.7 |
| 271 | 2024-12-29 19:56:56 | stocktaking | 3 | 121633 | 7 | 24.843 | 4896.1 |
| 270 | 2024-12-29 19:57:02 | stocktaking | 2 | 86808 | 3 | 10.640 | 8158.6 |
| 269 | 2024-12-29 19:55:17 | stocktaking | 1 | 49908 | 2 | 2.376 | 21005.1 |
| 268 | 2024-12-25 02:47:12 | stocktaking | 3 | 121633 | 7 | 27.143 | 4481.2 |
| 267 | 2024-12-25 02:46:12 | stocktaking | 4 | 148819 | 39 | 45.330 | 3283.0 |
| 266 | 2024-12-21 00:21:01 | stocktaking | 1 | 49908 | 2 | 4.500 | 11090.7 |
| 265 | 2024-12-02 12:24:37 | stocktaking | 3 | 121633 | 7 | 25.440 | 4781.2 |
| 264 | 2024-12-02 12:24:36 | stocktaking | 2 | 86808 | 3 | 10.923 | 7947.3 |
| 263 | 2024-12-02 12:22:18 | stocktaking | 1 | 49908 | 2 | 7.156 | 6974.3 |
| 262 | 2024-11-29 20:48:50 | stocktaking | 2 | 86808 | 3 | 11.643 | 7455.8 |
| 261 | 2024-11-29 20:47:48 | stocktaking | 1 | 49908 | 2 | 6.266 | 7964.9 |
| 260 | 2024-11-26 08:39:36 | stocktaking | 4 | 148819 | 39 | 54.440 | 2733.6 |
| 259 | 2024-11-25 21:05:58 | stocktaking | 4 | 148819 | 39 | 25.656 | 5800.6 |
| 258 | 2024-11-25 08:56:42 | stocktaking | 3 | 121633 | 7 | 21.796 | 5580.5 |
| 257 | 2024-11-24 00:01:15 | stocktaking | 4 | 148819 | 39 | 34.490 | 4314.8 |
| 256 | 2024-11-24 00:00:57 | stocktaking | 3 | 121633 | 7 | 28.250 | 4305.6 |
| 255 | 2024-11-21 20:09:48 | stocktaking | 3 | 121633 | 7 | 26.330 | 4619.6 |
| 254 | 2024-11-21 20:09:48 | stocktaking | 2 | 86808 | 3 | 18.003 | 4821.9 |
| 253 | 2024-11-21 20:08:33 | stocktaking | 1 | 49908 | 2 | 4.126 | 12096.0 |
| 252 | 2024-11-21 00:07:39 | stocktaking | 1 | 49908 | 2 | 4.080 | 12232.4 |
| 251 | 2024-11-01 10:02:16 | stocktaking | 2 | 86808 | 3 | 7.550 | 11497.7 |
| 250 | 2024-11-01 10:01:35 | stocktaking | 1 | 49908 | 2 | 4.063 | 12283.5 |
| 249 | 2024-10-27 04:08:12 | stocktaking | 4 | 148819 | 39 | 65.410 | 2275.2 |
| 248 | 2024-10-26 10:57:33 | stocktaking | 4 | 148819 | 39 | 63.863 | 2330.3 |
| 247 | 2024-10-26 09:02:52 | stocktaking | 4 | 148819 | 39 | 52.963 | 2809.9 |
| 246 | 2024-10-24 16:13:21 | stocktaking | 4 | 148819 | 39 | 54.880 | 2711.7 |
| 245 | 2024-10-21 03:28:28 | stocktaking | 4 | 148819 | 39 | 44.800 | 3321.9 |
| 244 | 2024-10-21 03:28:30 | stocktaking | 3 | 121633 | 7 | 28.923 | 4205.4 |
| 243 | 2024-10-21 03:28:33 | stocktaking | 2 | 86808 | 3 | 12.220 | 7103.8 |
| 242 | 2024-10-21 03:27:05 | stocktaking | 4 | 148819 | 39 | 44.893 | 3315.0 |
| 241 | 2024-10-21 03:24:54 | stocktaking | 1 | 49908 | 2 | 4.250 | 11743.1 |
| 240 | 2024-10-18 05:45:16 | stocktaking | 3 | 121633 | 7 | 25.113 | 4843.4 |
| 239 | 2024-10-13 15:50:37 | stocktaking | 3 | 121633 | 7 | 26.860 | 4528.4 |
| 238 | 2024-10-03 13:43:50 | stocktaking | 1 | 49908 | 2 | 5.983 | 8341.6 |
| 237 | 2024-09-26 21:15:51 | stocktaking | 1 | 49908 | 2 | 3.406 | 14653.0 |
| 236 | 2024-09-24 08:29:19 | stocktaking | 3 | 121633 | 7 | 48.956 | 2484.5 |
| 235 | 2024-09-24 08:29:25 | stocktaking | 3 | 121633 | 7 | 41.050 | 2963.0 |