History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"violation"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 337 | 2025-10-09 10:25:31 | violation | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 336 | 2025-10-09 07:05:17 | violation | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 335 | 2025-10-08 06:31:56 | violation | 1 | 81242 | 2 | 1.330 | 61084.2 |
| 334 | 2025-10-07 15:53:03 | violation | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 333 | 2025-10-07 14:50:30 | violation | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 332 | 2025-09-24 00:01:22 | violation | 1 | 81242 | 2 | 1.283 | 63321.9 |
| 331 | 2025-09-22 23:15:37 | violation | 1 | 81242 | 2 | 1.220 | 66591.8 |
| 330 | 2025-09-08 07:34:10 | violation | 1 | 81242 | 2 | 1.330 | 61084.2 |
| 329 | 2025-09-07 19:21:29 | violation | 1 | 81242 | 2 | 1.330 | 61084.2 |
| 328 | 2025-09-06 17:24:22 | violation | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 327 | 2025-08-19 00:21:01 | violation | 1 | 81242 | 2 | 2.000 | 40621.0 |
| 326 | 2025-08-17 14:56:20 | violation | 1 | 81242 | 2 | 4.593 | 17688.2 |
| 325 | 2025-08-17 06:15:17 | violation | 1 | 81242 | 2 | 4.516 | 17989.8 |
| 324 | 2025-08-16 20:46:56 | violation | 1 | 81242 | 2 | 3.563 | 22801.6 |
| 323 | 2025-07-27 13:05:02 | violation | 1 | 81242 | 2 | 2.670 | 30427.7 |
| 322 | 2025-07-19 06:48:54 | violation | 1 | 81242 | 2 | 1.186 | 68500.8 |
| 321 | 2025-07-17 18:45:47 | violation | 1 | 81242 | 2 | 5.563 | 14604.0 |
| 320 | 2025-07-15 08:29:59 | violation | 1 | 81242 | 2 | 6.813 | 11924.6 |
| 319 | 2025-07-07 20:16:16 | violation | 1 | 81242 | 2 | 4.796 | 16939.5 |
| 318 | 2025-06-28 14:26:45 | violation | 1 | 81242 | 2 | 8.640 | 9403.0 |
| 317 | 2025-06-26 11:30:05 | violation | 1 | 81242 | 2 | 10.063 | 8073.3 |
| 316 | 2025-06-16 15:39:19 | violation | 1 | 81242 | 2 | 3.170 | 25628.4 |
| 315 | 2025-06-16 00:50:35 | violation | 1 | 81242 | 2 | 9.470 | 8578.9 |
| 314 | 2025-06-14 07:27:59 | violation | 1 | 81242 | 2 | 9.420 | 8624.4 |
| 313 | 2025-06-08 07:17:58 | violation | 1 | 81242 | 2 | 5.436 | 14945.2 |
| 312 | 2025-05-31 11:11:13 | violation | 1 | 81242 | 2 | 2.830 | 28707.4 |
| 311 | 2025-05-26 14:31:49 | violation | 1 | 81242 | 2 | 4.016 | 20229.6 |
| 310 | 2025-05-14 15:38:30 | violation | 1 | 81242 | 2 | 9.173 | 8856.6 |
| 309 | 2025-05-06 07:55:40 | violation | 1 | 81242 | 2 | 6.826 | 11901.8 |
| 308 | 2025-05-06 05:22:50 | violation | 2 | 121436 | 17 | 20.126 | 6033.8 |
| 307 | 2025-05-05 00:07:09 | violation | 1 | 81242 | 2 | 3.076 | 26411.6 |
| 306 | 2025-04-26 10:36:34 | violation | 1 | 81242 | 2 | 6.186 | 13133.2 |
| 305 | 2025-04-25 11:51:49 | violation | 3 | 148641 | 132 | 55.396 | 2683.2 |
| 304 | 2025-04-24 14:52:34 | violation | 3 | 148641 | 132 | 19.206 | 7739.3 |
| 303 | 2025-04-21 06:27:04 | violation | 3 | 148641 | 132 | 43.173 | 3442.9 |
| 302 | 2025-04-20 19:28:59 | violation | 2 | 121436 | 17 | 13.393 | 9067.1 |
| 301 | 2025-04-18 12:35:19 | violation | 3 | 148641 | 132 | 32.720 | 4542.8 |
| 300 | 2025-04-18 07:00:31 | violation | 1 | 81242 | 2 | 7.470 | 10875.8 |
| 299 | 2025-04-17 23:17:10 | violation | 2 | 121436 | 17 | 13.826 | 8783.2 |
| 298 | 2025-04-17 16:11:43 | violation | 1 | 81242 | 2 | 1.220 | 66591.8 |
| 297 | 2025-03-29 17:40:01 | violation | 1 | 81242 | 2 | 6.250 | 12998.7 |
| 296 | 2025-03-23 12:04:04 | violation | 1 | 81242 | 2 | 9.453 | 8594.3 |
| 295 | 2025-03-18 00:59:29 | violation | 2 | 121436 | 17 | 17.313 | 7014.2 |
| 294 | 2025-03-13 22:57:22 | violation | 3 | 148641 | 132 | 34.473 | 4311.8 |
| 293 | 2025-03-13 22:57:20 | violation | 2 | 121436 | 17 | 16.860 | 7202.6 |
| 292 | 2025-03-13 22:55:34 | violation | 1 | 81242 | 2 | 4.063 | 19995.6 |
| 291 | 2025-03-07 06:35:45 | violation | 1 | 81242 | 2 | 6.876 | 11815.3 |
| 290 | 2025-03-05 22:34:00 | violation | 3 | 148641 | 132 | 49.690 | 2991.4 |
| 289 | 2025-03-05 21:45:47 | violation | 1 | 81242 | 2 | 7.110 | 11426.4 |
| 288 | 2025-03-04 07:34:44 | violation | 3 | 148641 | 132 | 27.440 | 5416.9 |
| 287 | 2025-03-04 07:34:30 | violation | 2 | 121436 | 17 | 17.643 | 6883.0 |
| 286 | 2025-03-04 07:30:37 | violation | 1 | 81242 | 2 | 3.170 | 25628.4 |
| 285 | 2025-03-04 04:18:45 | violation | 3 | 148641 | 132 | 53.283 | 2789.7 |
| 284 | 2025-03-04 00:36:28 | violation | 3 | 148641 | 132 | 28.720 | 5175.5 |
| 283 | 2025-03-04 00:36:27 | violation | 2 | 121436 | 17 | 11.423 | 10630.8 |
| 282 | 2025-03-04 00:35:41 | violation | 1 | 81242 | 2 | 4.000 | 20310.5 |
| 281 | 2025-02-02 02:10:22 | violation | 1 | 81242 | 2 | 4.673 | 17385.4 |
| 280 | 2025-01-28 19:59:21 | violation | 3 | 148641 | 132 | 32.546 | 4567.1 |
| 279 | 2025-01-27 11:55:54 | violation | 3 | 148641 | 132 | 40.423 | 3677.1 |
| 278 | 2025-01-27 11:55:44 | violation | 2 | 121436 | 17 | 15.453 | 7858.4 |
| 277 | 2025-01-26 22:30:24 | violation | 1 | 81242 | 2 | 6.063 | 13399.6 |
| 276 | 2025-01-26 16:21:16 | violation | 3 | 148641 | 132 | 29.940 | 4964.6 |
| 275 | 2025-01-26 16:21:10 | violation | 2 | 121436 | 17 | 12.343 | 9838.5 |
| 274 | 2025-01-21 02:32:53 | violation | 1 | 81242 | 2 | 9.890 | 8214.6 |
| 273 | 2024-12-30 00:28:29 | violation | 1 | 81242 | 2 | 5.046 | 16100.3 |
| 272 | 2024-12-19 08:48:34 | violation | 3 | 148641 | 132 | 30.516 | 4870.9 |
| 271 | 2024-12-18 12:25:37 | violation | 3 | 148641 | 132 | 34.266 | 4337.9 |
| 270 | 2024-12-17 23:52:53 | violation | 2 | 121436 | 17 | 18.016 | 6740.5 |
| 269 | 2024-12-17 23:52:52 | violation | 3 | 148641 | 132 | 18.643 | 7973.0 |
| 268 | 2024-12-17 22:01:23 | violation | 1 | 81242 | 2 | 3.750 | 21664.5 |
| 267 | 2024-12-15 12:58:19 | violation | 1 | 81242 | 2 | 4.843 | 16775.1 |
| 266 | 2024-12-11 21:07:50 | violation | 1 | 81242 | 2 | 6.406 | 12682.2 |
| 265 | 2024-11-26 08:07:29 | violation | 1 | 81242 | 2 | 6.300 | 12895.6 |
| 264 | 2024-11-13 00:42:08 | violation | 1 | 81242 | 2 | 6.983 | 11634.3 |
| 263 | 2024-11-11 15:49:25 | violation | 1 | 81242 | 2 | 6.500 | 12498.8 |
| 262 | 2024-11-10 10:13:46 | violation | 2 | 121436 | 17 | 18.783 | 6465.2 |
| 261 | 2024-11-09 23:54:16 | violation | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 260 | 2024-10-27 04:32:05 | violation | 3 | 148641 | 132 | 26.580 | 5592.2 |
| 259 | 2024-10-26 21:35:05 | violation | 3 | 148641 | 132 | 18.813 | 7901.0 |
| 258 | 2024-10-26 21:23:21 | violation | 1 | 81242 | 2 | 7.126 | 11400.8 |
| 257 | 2024-10-24 12:00:12 | violation | 2 | 121436 | 17 | 17.330 | 7007.3 |
| 256 | 2024-10-15 07:58:45 | violation | 2 | 121436 | 17 | 17.236 | 7045.5 |
| 255 | 2024-10-13 14:18:28 | violation | 2 | 121436 | 17 | 16.140 | 7523.9 |
| 254 | 2024-10-10 14:19:54 | violation | 1 | 81242 | 2 | 3.563 | 22801.6 |
| 253 | 2024-10-09 20:51:56 | violation | 1 | 81242 | 2 | 7.376 | 11014.4 |
| 252 | 2024-10-09 16:27:44 | violation | 2 | 121436 | 17 | 23.063 | 5265.4 |
| 251 | 2024-10-09 16:02:04 | violation | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 250 | 2024-09-20 23:15:20 | violation | 3 | 148641 | 132 | 49.550 | 2999.8 |
| 249 | 2024-09-15 03:12:17 | violation | 3 | 148641 | 132 | 19.266 | 7715.2 |
| 248 | 2024-09-14 06:12:13 | violation | 3 | 148641 | 132 | 42.486 | 3498.6 |
| 247 | 2024-09-08 22:39:01 | violation | 3 | 148641 | 132 | 54.783 | 2713.3 |
| 246 | 2024-09-08 22:39:12 | violation | 2 | 121436 | 17 | 25.753 | 4715.4 |
| 245 | 2024-09-08 22:28:32 | violation | 1 | 81242 | 2 | 9.233 | 8799.1 |
| 244 | 2024-09-05 06:22:07 | violation | 1 | 81242 | 2 | 11.830 | 6867.5 |
| 243 | 2024-08-27 01:26:06 | violation | 1 | 81242 | 2 | 9.843 | 8253.8 |
| 242 | 2024-08-09 10:54:30 | violation | 1 | 81242 | 2 | 6.610 | 12290.8 |
| 241 | 2024-08-08 17:14:08 | violation | 1 | 81242 | 2 | 4.423 | 18368.1 |
| 240 | 2024-07-29 03:12:06 | violation | 1 | 81242 | 2 | 1.483 | 54782.2 |
| 239 | 2024-07-25 00:01:44 | violation | 2 | 121436 | 17 | 11.800 | 10291.2 |
| 238 | 2024-07-24 03:00:31 | violation | 1 | 81242 | 2 | 5.216 | 15575.5 |