History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"transaction"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 353 | 2025-07-19 20:51:01 | transaction | 3 | 121633 | 30 | 10.080 | 12066.8 |
| 352 | 2025-07-17 19:43:34 | transaction | 2 | 86808 | 11 | 11.830 | 7338.0 |
| 351 | 2025-07-17 16:54:54 | transaction | 3 | 121633 | 30 | 15.610 | 7792.0 |
| 350 | 2025-07-14 04:04:33 | transaction | 1 | 49908 | 3 | 2.000 | 24954.0 |
| 349 | 2025-07-13 02:01:31 | transaction | 2 | 86808 | 11 | 6.530 | 13293.7 |
| 348 | 2025-07-10 20:54:20 | transaction | 2 | 86808 | 11 | 18.156 | 4781.2 |
| 347 | 2025-07-10 19:41:28 | transaction | 1 | 49908 | 3 | 4.530 | 11017.2 |
| 346 | 2025-07-10 16:21:08 | transaction | 3 | 121633 | 30 | 21.893 | 5555.8 |
| 345 | 2025-07-07 02:50:48 | transaction | 3 | 121633 | 30 | 48.066 | 2530.5 |
| 344 | 2025-07-06 21:53:35 | transaction | 2 | 86808 | 11 | 16.830 | 5157.9 |
| 343 | 2025-07-06 05:48:59 | transaction | 1 | 49908 | 3 | 0.733 | 68087.3 |
| 342 | 2025-07-05 15:57:12 | transaction | 2 | 86808 | 11 | 5.873 | 14780.9 |
| 341 | 2025-07-05 12:54:09 | transaction | 3 | 121633 | 30 | 16.000 | 7602.1 |
| 340 | 2025-07-04 13:53:15 | transaction | 1 | 49908 | 3 | 2.626 | 19005.3 |
| 339 | 2025-07-04 13:31:01 | transaction | 1 | 49908 | 3 | 3.826 | 13044.4 |
| 338 | 2025-06-26 00:35:49 | transaction | 4 | 148819 | 105 | 47.093 | 3160.1 |
| 337 | 2025-06-23 08:13:17 | transaction | 4 | 148819 | 105 | 15.406 | 9659.8 |
| 336 | 2025-06-21 04:07:22 | transaction | 4 | 148819 | 105 | 51.316 | 2900.1 |
| 335 | 2025-06-18 05:32:24 | transaction | 4 | 148819 | 105 | 41.740 | 3565.4 |
| 334 | 2025-06-14 13:56:13 | transaction | 3 | 121633 | 30 | 20.236 | 6010.7 |
| 333 | 2025-06-13 02:38:52 | transaction | 1 | 49908 | 3 | 0.750 | 66544.0 |
| 332 | 2025-06-10 15:05:20 | transaction | 3 | 121633 | 30 | 15.970 | 7616.3 |
| 331 | 2025-06-08 00:34:14 | transaction | 1 | 49908 | 3 | 3.953 | 12625.3 |
| 330 | 2025-06-06 02:44:44 | transaction | 3 | 121633 | 30 | 26.890 | 4523.4 |
| 329 | 2025-06-04 13:15:00 | transaction | 1 | 49908 | 3 | 3.673 | 13587.8 |
| 328 | 2025-06-01 23:46:48 | transaction | 1 | 49908 | 3 | 3.420 | 14593.0 |
| 327 | 2025-05-31 01:34:36 | transaction | 1 | 49908 | 3 | 3.733 | 13369.4 |
| 326 | 2025-05-30 00:34:11 | transaction | 3 | 121633 | 30 | 5.690 | 21376.6 |
| 325 | 2025-05-29 14:43:04 | transaction | 1 | 49908 | 3 | 4.296 | 11617.3 |
| 324 | 2025-05-20 04:05:29 | transaction | 1 | 49908 | 3 | 4.906 | 10172.8 |
| 323 | 2025-05-18 00:50:32 | transaction | 1 | 49908 | 3 | 4.266 | 11699.0 |
| 322 | 2025-05-12 03:10:46 | transaction | 1 | 49908 | 3 | 4.000 | 12477.0 |
| 321 | 2025-05-11 05:31:59 | transaction | 1 | 49908 | 3 | 1.936 | 25778.9 |
| 320 | 2025-05-05 00:13:44 | transaction | 1 | 49908 | 3 | 0.970 | 51451.5 |
| 319 | 2025-05-01 23:33:01 | transaction | 1 | 49908 | 3 | 4.453 | 11207.7 |
| 318 | 2025-04-25 13:49:53 | transaction | 1 | 49908 | 3 | 2.160 | 23105.6 |
| 317 | 2025-04-11 03:10:45 | transaction | 1 | 49908 | 3 | 5.673 | 8797.5 |
| 316 | 2025-04-07 07:16:29 | transaction | 3 | 121633 | 30 | 13.780 | 8826.8 |
| 315 | 2025-04-04 14:31:03 | transaction | 2 | 86808 | 11 | 13.736 | 6319.7 |
| 314 | 2025-04-04 13:32:21 | transaction | 3 | 121633 | 30 | 33.080 | 3676.9 |
| 313 | 2025-04-04 07:42:44 | transaction | 2 | 86808 | 11 | 7.030 | 12348.2 |
| 312 | 2025-04-02 00:19:33 | transaction | 1 | 49908 | 3 | 3.623 | 13775.3 |
| 311 | 2025-03-30 12:58:15 | transaction | 3 | 121633 | 30 | 8.470 | 14360.4 |
| 310 | 2025-03-30 04:01:34 | transaction | 2 | 86808 | 11 | 2.046 | 42428.2 |
| 309 | 2025-03-29 17:03:33 | transaction | 1 | 49908 | 3 | 3.940 | 12667.0 |
| 308 | 2025-03-25 15:15:52 | transaction | 1 | 49908 | 3 | 4.270 | 11688.1 |
| 307 | 2025-03-21 16:26:43 | transaction | 1 | 49908 | 3 | 3.936 | 12679.9 |
| 306 | 2025-03-13 13:03:25 | transaction | 1 | 49908 | 3 | 3.466 | 14399.3 |
| 305 | 2025-03-11 08:52:45 | transaction | 1 | 49908 | 3 | 3.813 | 13088.9 |
| 304 | 2025-02-09 01:34:30 | transaction | 1 | 49908 | 3 | 4.346 | 11483.7 |
| 303 | 2025-02-07 23:26:45 | transaction | 1 | 49908 | 3 | 4.000 | 12477.0 |
| 302 | 2025-01-27 07:04:24 | transaction | 3 | 121633 | 30 | 24.923 | 4880.4 |
| 301 | 2025-01-20 07:55:20 | transaction | 3 | 121633 | 30 | 27.906 | 4358.7 |
| 300 | 2025-01-20 07:55:25 | transaction | 2 | 86808 | 11 | 12.546 | 6919.2 |
| 299 | 2025-01-20 07:50:03 | transaction | 1 | 49908 | 3 | 4.203 | 11874.4 |
| 298 | 2025-01-17 21:25:46 | transaction | 1 | 49908 | 3 | 2.516 | 19836.2 |
| 297 | 2025-01-09 11:25:45 | transaction | 1 | 49908 | 3 | 3.343 | 14929.1 |
| 296 | 2025-01-07 23:35:38 | transaction | 4 | 148819 | 105 | 46.096 | 3228.5 |
| 295 | 2025-01-07 10:29:25 | transaction | 4 | 148819 | 105 | 56.846 | 2617.9 |
| 294 | 2025-01-06 23:42:46 | transaction | 4 | 148819 | 105 | 50.283 | 2959.6 |
| 293 | 2025-01-04 20:42:31 | transaction | 4 | 148819 | 105 | 53.316 | 2791.3 |
| 292 | 2024-12-24 06:45:38 | transaction | 1 | 49908 | 3 | 1.936 | 25778.9 |
| 291 | 2024-12-18 01:39:21 | transaction | 3 | 121633 | 30 | 25.610 | 4749.4 |
| 290 | 2024-12-16 02:18:17 | transaction | 2 | 86808 | 11 | 12.406 | 6997.3 |
| 289 | 2024-12-14 23:44:41 | transaction | 3 | 121633 | 30 | 23.033 | 5280.8 |
| 288 | 2024-12-14 23:44:41 | transaction | 2 | 86808 | 11 | 10.250 | 8469.1 |
| 287 | 2024-12-14 23:42:19 | transaction | 1 | 49908 | 3 | 1.296 | 38509.3 |
| 286 | 2024-12-11 19:54:30 | transaction | 3 | 121633 | 30 | 24.440 | 4976.8 |
| 285 | 2024-12-10 23:45:06 | transaction | 3 | 121633 | 30 | 21.046 | 5779.4 |
| 284 | 2024-12-10 23:39:09 | transaction | 1 | 49908 | 3 | 0.860 | 58032.6 |
| 283 | 2024-12-08 09:08:04 | transaction | 4 | 148819 | 105 | 55.800 | 2667.0 |
| 282 | 2024-12-08 07:02:56 | transaction | 4 | 148819 | 105 | 53.316 | 2791.3 |
| 281 | 2024-12-07 19:43:17 | transaction | 4 | 148819 | 105 | 49.016 | 3036.1 |
| 280 | 2024-12-05 03:50:17 | transaction | 2 | 86808 | 11 | 10.610 | 8181.7 |
| 279 | 2024-12-02 05:23:39 | transaction | 4 | 148819 | 105 | 43.563 | 3416.2 |
| 278 | 2024-12-02 05:23:42 | transaction | 2 | 86808 | 11 | 18.876 | 4598.9 |
| 277 | 2024-12-02 05:21:15 | transaction | 1 | 49908 | 3 | 0.923 | 54071.5 |
| 276 | 2024-11-15 08:18:33 | transaction | 3 | 121633 | 30 | 13.110 | 9277.9 |
| 275 | 2024-11-12 16:38:23 | transaction | 2 | 86808 | 11 | 12.670 | 6851.5 |
| 274 | 2024-11-07 09:05:41 | transaction | 4 | 148819 | 105 | 38.753 | 3840.2 |
| 273 | 2024-11-07 09:05:40 | transaction | 3 | 121633 | 30 | 24.910 | 4882.9 |
| 272 | 2024-11-06 14:51:43 | transaction | 4 | 148819 | 105 | 57.126 | 2605.1 |
| 271 | 2024-11-06 14:51:48 | transaction | 2 | 86808 | 11 | 13.906 | 6242.5 |
| 270 | 2024-11-02 07:24:03 | transaction | 3 | 121633 | 30 | 26.126 | 4655.6 |
| 269 | 2024-11-02 07:23:58 | transaction | 2 | 86808 | 11 | 10.030 | 8654.8 |
| 268 | 2024-11-01 14:41:07 | transaction | 3 | 121633 | 30 | 27.690 | 4392.7 |
| 267 | 2024-10-31 12:15:46 | transaction | 3 | 121633 | 30 | 17.670 | 6883.6 |
| 266 | 2024-10-31 12:15:48 | transaction | 2 | 86808 | 11 | 8.843 | 9816.6 |
| 265 | 2024-10-31 12:15:44 | transaction | 1 | 49908 | 3 | 0.920 | 54247.8 |
| 264 | 2024-10-29 12:25:51 | transaction | 1 | 49908 | 3 | 3.500 | 14259.4 |
| 263 | 2024-10-27 01:08:27 | transaction | 1 | 49908 | 3 | 6.063 | 8231.6 |
| 262 | 2024-10-16 15:14:51 | transaction | 1 | 49908 | 3 | 2.736 | 18241.2 |
| 261 | 2024-10-11 23:51:58 | transaction | 3 | 121633 | 30 | 31.643 | 3843.9 |
| 260 | 2024-10-01 15:30:39 | transaction | 3 | 121633 | 30 | 19.766 | 6153.6 |
| 259 | 2024-09-29 15:05:27 | transaction | 3 | 121633 | 30 | 41.283 | 2946.3 |
| 258 | 2024-09-26 18:00:03 | transaction | 1 | 49908 | 3 | 6.360 | 7847.2 |
| 257 | 2024-09-26 08:08:19 | transaction | 3 | 121633 | 30 | 60.676 | 2004.6 |
| 256 | 2024-09-26 08:08:23 | transaction | 3 | 121633 | 30 | 45.423 | 2677.8 |
| 255 | 2024-09-06 13:59:13 | transaction | 1 | 49908 | 3 | 6.876 | 7258.3 |
| 254 | 2024-09-06 05:39:07 | transaction | 1 | 49908 | 3 | 7.673 | 6504.4 |