History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subagency"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 332 | 2026-01-07 22:13:16 | subagency | 4 | 165329 | 100 | 12.580 | 13142.2 |
| 331 | 2026-01-06 09:59:56 | subagency | 4 | 165329 | 100 | 14.610 | 11316.2 |
| 330 | 2026-01-05 14:30:30 | subagency | 4 | 165329 | 100 | 15.080 | 10963.5 |
| 329 | 2026-01-04 21:02:59 | subagency | 4 | 165329 | 100 | 12.673 | 13045.8 |
| 328 | 2026-01-04 17:50:27 | subagency | 4 | 165329 | 100 | 19.546 | 8458.5 |
| 327 | 2026-01-03 18:02:23 | subagency | 4 | 165329 | 100 | 17.423 | 9489.1 |
| 326 | 2026-01-03 09:22:56 | subagency | 4 | 165329 | 100 | 11.156 | 14819.7 |
| 325 | 2026-01-03 09:22:26 | subagency | 4 | 165329 | 100 | 12.486 | 13241.2 |
| 324 | 2025-12-27 19:01:00 | subagency | 2 | 121436 | 4 | 4.000 | 30359.0 |
| 323 | 2025-12-27 09:43:58 | subagency | 3 | 148641 | 14 | 7.580 | 19609.6 |
| 322 | 2025-12-26 08:10:42 | subagency | 1 | 81242 | 1 | 2.403 | 33808.6 |
| 321 | 2025-12-25 05:05:06 | subagency | 2 | 121436 | 4 | 3.690 | 32909.5 |
| 320 | 2025-12-25 04:47:05 | subagency | 1 | 81242 | 1 | 1.763 | 46081.7 |
| 319 | 2025-12-24 21:34:10 | subagency | 3 | 148641 | 14 | 19.406 | 7659.5 |
| 318 | 2025-12-23 23:37:06 | subagency | 2 | 121436 | 4 | 5.373 | 22601.2 |
| 317 | 2025-12-23 20:39:35 | subagency | 3 | 148641 | 14 | 7.266 | 20457.1 |
| 316 | 2025-12-21 11:17:55 | subagency | 3 | 148641 | 14 | 16.063 | 9253.6 |
| 315 | 2025-12-20 17:59:44 | subagency | 3 | 148641 | 14 | 25.330 | 5868.2 |
| 314 | 2025-12-20 13:14:07 | subagency | 2 | 121436 | 4 | 4.563 | 26613.2 |
| 313 | 2025-12-19 01:43:22 | subagency | 2 | 121436 | 4 | 6.750 | 17990.5 |
| 312 | 2025-12-18 13:06:04 | subagency | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 311 | 2025-12-05 23:51:22 | subagency | 1 | 81242 | 1 | 1.486 | 54671.6 |
| 310 | 2025-12-05 22:03:04 | subagency | 1 | 81242 | 1 | 1.623 | 50056.7 |
| 309 | 2025-12-01 09:59:02 | subagency | 1 | 81242 | 1 | 2.593 | 31331.3 |
| 308 | 2025-12-01 06:26:53 | subagency | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 307 | 2025-11-30 02:06:27 | subagency | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 306 | 2025-11-28 22:39:01 | subagency | 1 | 81242 | 1 | 1.376 | 59042.2 |
| 305 | 2025-11-28 15:02:10 | subagency | 2 | 121436 | 4 | 4.376 | 27750.5 |
| 304 | 2025-11-25 14:34:04 | subagency | 1 | 81242 | 1 | 1.626 | 49964.3 |
| 303 | 2025-11-02 23:19:49 | subagency | 1 | 81242 | 1 | 1.310 | 62016.8 |
| 302 | 2025-10-30 02:51:14 | subagency | 1 | 81242 | 1 | 1.313 | 61875.1 |
| 301 | 2025-10-25 14:42:17 | subagency | 1 | 81242 | 1 | 1.466 | 55417.5 |
| 300 | 2025-10-23 17:36:42 | subagency | 1 | 81242 | 1 | 1.736 | 46798.4 |
| 299 | 2025-10-22 07:27:52 | subagency | 1 | 81242 | 1 | 2.310 | 35169.7 |
| 298 | 2025-09-29 11:07:39 | subagency | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 297 | 2025-09-29 03:37:10 | subagency | 1 | 81242 | 1 | 1.330 | 61084.2 |
| 296 | 2025-09-26 07:15:53 | subagency | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 295 | 2025-09-23 14:44:53 | subagency | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 294 | 2025-09-08 22:06:02 | subagency | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 293 | 2025-08-29 03:24:26 | subagency | 1 | 81242 | 1 | 1.423 | 57092.1 |
| 292 | 2025-08-28 10:39:39 | subagency | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 291 | 2025-08-22 08:34:41 | subagency | 1 | 81242 | 1 | 1.450 | 56029.0 |
| 290 | 2025-08-19 03:06:25 | subagency | 2 | 121436 | 4 | 7.156 | 16969.8 |
| 289 | 2025-08-05 03:28:22 | subagency | 2 | 121436 | 4 | 8.266 | 14691.0 |
| 288 | 2025-08-04 06:24:10 | subagency | 1 | 81242 | 1 | 1.373 | 59171.2 |
| 287 | 2025-07-30 22:42:07 | subagency | 1 | 81242 | 1 | 5.063 | 16046.2 |
| 286 | 2025-07-25 07:24:28 | subagency | 1 | 81242 | 1 | 6.453 | 12589.8 |
| 285 | 2025-07-23 17:16:10 | subagency | 1 | 81242 | 1 | 3.063 | 26523.7 |
| 284 | 2025-07-17 23:53:37 | subagency | 1 | 81242 | 1 | 9.266 | 8767.8 |
| 283 | 2025-07-17 16:36:33 | subagency | 1 | 81242 | 1 | 3.810 | 21323.4 |
| 282 | 2025-07-12 02:31:55 | subagency | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 281 | 2025-05-19 09:46:34 | subagency | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 280 | 2025-05-08 01:36:36 | subagency | 1 | 81242 | 1 | 6.643 | 12229.7 |
| 279 | 2025-03-26 16:53:47 | subagency | 1 | 81242 | 1 | 8.716 | 9321.0 |
| 278 | 2025-03-23 02:19:06 | subagency | 1 | 81242 | 1 | 6.046 | 13437.3 |
| 277 | 2025-03-15 19:32:52 | subagency | 1 | 81242 | 1 | 4.656 | 17448.9 |
| 276 | 2025-03-15 11:27:33 | subagency | 1 | 81242 | 1 | 5.533 | 14683.2 |
| 275 | 2025-03-05 05:23:45 | subagency | 1 | 81242 | 1 | 3.376 | 24064.6 |
| 274 | 2025-02-13 01:19:12 | subagency | 3 | 148641 | 14 | 41.766 | 3558.9 |
| 273 | 2025-02-13 01:19:07 | subagency | 2 | 121436 | 4 | 16.376 | 7415.5 |
| 272 | 2025-02-12 08:01:21 | subagency | 3 | 148641 | 14 | 37.206 | 3995.1 |
| 271 | 2025-02-12 08:01:04 | subagency | 3 | 148641 | 14 | 29.063 | 5114.4 |
| 270 | 2025-02-12 08:01:19 | subagency | 2 | 121436 | 4 | 9.220 | 13170.9 |
| 269 | 2025-02-12 08:00:53 | subagency | 3 | 148641 | 14 | 32.486 | 4575.5 |
| 268 | 2025-02-12 07:59:33 | subagency | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 267 | 2025-01-28 23:29:48 | subagency | 1 | 81242 | 1 | 7.283 | 11155.0 |
| 266 | 2025-01-03 00:17:52 | subagency | 3 | 148641 | 14 | 45.703 | 3252.3 |
| 265 | 2025-01-03 00:18:01 | subagency | 2 | 121436 | 4 | 8.936 | 13589.5 |
| 264 | 2025-01-03 00:17:33 | subagency | 3 | 148641 | 14 | 24.326 | 6110.4 |
| 263 | 2025-01-03 00:17:13 | subagency | 3 | 148641 | 14 | 31.656 | 4695.5 |
| 262 | 2025-01-03 00:15:59 | subagency | 1 | 81242 | 1 | 5.376 | 15112.0 |
| 261 | 2025-01-01 18:12:19 | subagency | 1 | 81242 | 1 | 3.126 | 25989.1 |
| 260 | 2024-12-30 21:57:32 | subagency | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 259 | 2024-12-25 18:43:06 | subagency | 3 | 148641 | 14 | 53.800 | 2762.8 |
| 258 | 2024-12-25 18:43:03 | subagency | 3 | 148641 | 14 | 54.130 | 2746.0 |
| 257 | 2024-12-25 18:43:10 | subagency | 3 | 148641 | 14 | 40.050 | 3711.4 |
| 256 | 2024-12-25 18:43:07 | subagency | 2 | 121436 | 4 | 14.643 | 8293.1 |
| 255 | 2024-12-25 17:10:33 | subagency | 1 | 81242 | 1 | 9.093 | 8934.6 |
| 254 | 2024-12-02 15:22:58 | subagency | 1 | 81242 | 1 | 7.343 | 11063.9 |
| 253 | 2024-11-28 02:51:01 | subagency | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 252 | 2024-11-25 09:18:23 | subagency | 1 | 81242 | 1 | 1.423 | 57092.1 |
| 251 | 2024-11-02 20:25:59 | subagency | 3 | 148641 | 14 | 36.800 | 4039.2 |
| 250 | 2024-11-01 07:32:21 | subagency | 1 | 81242 | 1 | 7.576 | 10723.6 |
| 249 | 2024-10-24 05:44:44 | subagency | 3 | 148641 | 14 | 37.893 | 3922.7 |
| 248 | 2024-10-24 05:44:45 | subagency | 2 | 121436 | 4 | 26.726 | 4543.7 |
| 247 | 2024-10-24 05:43:11 | subagency | 1 | 81242 | 1 | 4.376 | 18565.4 |
| 246 | 2024-10-17 03:19:40 | subagency | 3 | 148641 | 14 | 48.456 | 3067.5 |
| 245 | 2024-10-17 03:19:43 | subagency | 2 | 121436 | 4 | 16.936 | 7170.3 |
| 244 | 2024-10-17 03:19:30 | subagency | 3 | 148641 | 14 | 24.173 | 6149.1 |
| 243 | 2024-10-17 03:19:01 | subagency | 1 | 81242 | 1 | 6.266 | 12965.5 |
| 242 | 2024-10-13 13:51:19 | subagency | 3 | 148641 | 14 | 52.116 | 2852.1 |
| 241 | 2024-10-13 13:49:26 | subagency | 1 | 81242 | 1 | 5.970 | 13608.4 |
| 240 | 2024-10-07 23:42:54 | subagency | 4 | 165329 | 100 | 85.866 | 1925.4 |
| 239 | 2024-10-06 14:51:45 | subagency | 4 | 165329 | 100 | 85.286 | 1938.5 |
| 238 | 2024-10-04 15:27:25 | subagency | 4 | 165329 | 100 | 114.913 | 1438.7 |
| 237 | 2024-10-04 15:27:00 | subagency | 2 | 121436 | 4 | 26.093 | 4654.0 |
| 236 | 2024-10-03 17:48:56 | subagency | 4 | 165329 | 100 | 86.786 | 1905.0 |
| 235 | 2024-09-22 09:08:57 | subagency | 1 | 81242 | 1 | 14.890 | 5456.1 |
| 234 | 2024-09-09 20:32:20 | subagency | 1 | 81242 | 1 | 12.406 | 6548.6 |
| 233 | 2024-09-01 14:59:55 | subagency | 4 | 165329 | 100 | 137.380 | 1203.4 |