History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"transacts"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 374 | 2025-11-04 05:00:48 | transacts | 4 | 165329 | 257 | 18.936 | 8730.9 |
| 373 | 2025-10-22 08:42:00 | transacts | 1 | 81242 | 3 | 6.906 | 11764.0 |
| 372 | 2025-10-12 17:03:36 | transacts | 4 | 165329 | 257 | 12.330 | 13408.7 |
| 371 | 2025-10-11 05:20:57 | transacts | 4 | 165329 | 257 | 12.610 | 13110.9 |
| 370 | 2025-10-05 14:50:00 | transacts | 1 | 81242 | 3 | 1.576 | 51549.5 |
| 369 | 2025-10-05 05:38:55 | transacts | 4 | 165329 | 257 | 13.923 | 11874.5 |
| 368 | 2025-09-13 02:54:53 | transacts | 2 | 121436 | 12 | 3.826 | 31739.7 |
| 367 | 2025-09-13 02:52:46 | transacts | 3 | 148641 | 41 | 7.610 | 19532.3 |
| 366 | 2025-09-12 20:54:59 | transacts | 4 | 165329 | 257 | 12.656 | 13063.3 |
| 365 | 2025-09-11 06:02:31 | transacts | 1 | 81242 | 3 | 3.890 | 20884.8 |
| 364 | 2025-08-27 08:26:17 | transacts | 1 | 81242 | 3 | 2.893 | 28082.3 |
| 363 | 2025-08-23 12:05:19 | transacts | 3 | 148641 | 41 | 18.923 | 7855.0 |
| 362 | 2025-08-23 08:22:28 | transacts | 3 | 148641 | 41 | 27.863 | 5334.7 |
| 361 | 2025-08-23 03:41:53 | transacts | 2 | 121436 | 12 | 14.186 | 8560.3 |
| 360 | 2025-08-21 02:34:44 | transacts | 1 | 81242 | 3 | 7.190 | 11299.3 |
| 359 | 2025-08-20 07:36:24 | transacts | 4 | 165329 | 257 | 11.300 | 14630.9 |
| 358 | 2025-08-19 23:08:12 | transacts | 4 | 165329 | 257 | 12.296 | 13445.8 |
| 357 | 2025-08-19 10:07:23 | transacts | 2 | 121436 | 12 | 17.733 | 6848.0 |
| 356 | 2025-08-19 10:01:53 | transacts | 1 | 81242 | 3 | 3.593 | 22611.2 |
| 355 | 2025-08-15 11:30:20 | transacts | 2 | 121436 | 12 | 7.190 | 16889.6 |
| 354 | 2025-08-15 11:01:02 | transacts | 1 | 81242 | 3 | 6.593 | 12322.5 |
| 353 | 2025-08-12 20:26:42 | transacts | 1 | 81242 | 3 | 2.750 | 29542.5 |
| 352 | 2025-08-02 21:20:16 | transacts | 4 | 165329 | 257 | 31.830 | 5194.1 |
| 351 | 2025-08-02 21:20:09 | transacts | 4 | 165329 | 257 | 34.613 | 4776.5 |
| 350 | 2025-08-01 23:25:30 | transacts | 4 | 165329 | 257 | 30.343 | 5448.7 |
| 349 | 2025-08-01 06:27:04 | transacts | 1 | 81242 | 3 | 5.516 | 14728.4 |
| 348 | 2025-07-29 00:31:03 | transacts | 4 | 165329 | 257 | 60.580 | 2729.1 |
| 347 | 2025-07-19 09:44:59 | transacts | 2 | 121436 | 12 | 4.033 | 30110.6 |
| 346 | 2025-07-17 06:10:51 | transacts | 1 | 81242 | 3 | 6.016 | 13504.3 |
| 345 | 2025-07-12 03:29:02 | transacts | 3 | 148641 | 41 | 10.576 | 14054.6 |
| 344 | 2025-07-09 17:53:33 | transacts | 3 | 148641 | 41 | 8.046 | 18473.9 |
| 343 | 2025-07-05 07:37:40 | transacts | 1 | 81242 | 3 | 6.550 | 12403.4 |
| 342 | 2025-07-04 21:47:24 | transacts | 1 | 81242 | 3 | 6.656 | 12205.8 |
| 341 | 2025-07-03 07:13:27 | transacts | 3 | 148641 | 41 | 6.716 | 22132.4 |
| 340 | 2025-07-03 03:50:51 | transacts | 3 | 148641 | 41 | 44.923 | 3308.8 |
| 339 | 2025-07-03 03:50:05 | transacts | 2 | 121436 | 12 | 17.540 | 6923.4 |
| 338 | 2025-07-01 16:29:03 | transacts | 2 | 121436 | 12 | 3.576 | 33958.6 |
| 337 | 2025-07-01 13:41:28 | transacts | 3 | 148641 | 41 | 8.876 | 16746.4 |
| 336 | 2025-06-29 20:05:01 | transacts | 1 | 81242 | 3 | 10.140 | 8012.0 |
| 335 | 2025-06-25 08:28:59 | transacts | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 334 | 2025-06-25 02:43:54 | transacts | 1 | 81242 | 3 | 3.516 | 23106.4 |
| 333 | 2025-06-24 09:28:03 | transacts | 1 | 81242 | 3 | 4.673 | 17385.4 |
| 332 | 2025-06-16 06:21:01 | transacts | 1 | 81242 | 3 | 3.236 | 25105.7 |
| 331 | 2025-05-19 08:49:33 | transacts | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 330 | 2025-05-15 19:49:04 | transacts | 1 | 81242 | 3 | 6.216 | 13069.8 |
| 329 | 2025-04-30 06:02:20 | transacts | 1 | 81242 | 3 | 3.813 | 21306.6 |
| 328 | 2025-04-25 05:05:42 | transacts | 1 | 81242 | 3 | 6.673 | 12174.7 |
| 327 | 2025-04-20 02:55:05 | transacts | 3 | 148641 | 41 | 37.516 | 3962.1 |
| 326 | 2025-04-18 02:31:16 | transacts | 1 | 81242 | 3 | 5.780 | 14055.7 |
| 325 | 2025-04-14 21:25:12 | transacts | 3 | 148641 | 41 | 21.703 | 6848.9 |
| 324 | 2025-04-09 18:53:50 | transacts | 2 | 121436 | 12 | 28.516 | 4258.5 |
| 323 | 2025-04-08 05:21:00 | transacts | 2 | 121436 | 12 | 7.486 | 16221.7 |
| 322 | 2025-03-28 06:47:37 | transacts | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 321 | 2025-03-28 01:45:51 | transacts | 1 | 81242 | 3 | 2.763 | 29403.5 |
| 320 | 2025-03-22 21:37:49 | transacts | 1 | 81242 | 3 | 6.796 | 11954.4 |
| 319 | 2025-03-21 07:15:17 | transacts | 1 | 81242 | 3 | 6.470 | 12556.7 |
| 318 | 2025-03-17 22:38:38 | transacts | 3 | 148641 | 41 | 42.130 | 3528.2 |
| 317 | 2025-03-16 09:17:36 | transacts | 3 | 148641 | 41 | 39.896 | 3725.7 |
| 316 | 2025-03-15 19:20:40 | transacts | 1 | 81242 | 3 | 9.313 | 8723.5 |
| 315 | 2025-03-11 15:22:46 | transacts | 3 | 148641 | 41 | 51.456 | 2888.7 |
| 314 | 2025-03-11 13:02:19 | transacts | 3 | 148641 | 41 | 72.473 | 2051.0 |
| 313 | 2025-03-11 13:02:22 | transacts | 3 | 148641 | 41 | 36.296 | 4095.2 |
| 312 | 2025-03-11 13:02:10 | transacts | 2 | 121436 | 12 | 9.266 | 13105.5 |
| 311 | 2025-03-05 13:59:35 | transacts | 2 | 121436 | 12 | 17.453 | 6957.9 |
| 310 | 2025-03-05 00:03:21 | transacts | 2 | 121436 | 12 | 16.686 | 7277.7 |
| 309 | 2025-02-18 15:17:39 | transacts | 1 | 81242 | 3 | 7.953 | 10215.3 |
| 308 | 2025-02-11 04:45:58 | transacts | 1 | 81242 | 3 | 6.923 | 11735.1 |
| 307 | 2025-02-06 19:54:20 | transacts | 2 | 121436 | 12 | 28.206 | 4305.3 |
| 306 | 2025-02-04 17:38:15 | transacts | 3 | 148641 | 41 | 38.360 | 3874.9 |
| 305 | 2025-02-03 13:26:20 | transacts | 3 | 148641 | 41 | 41.143 | 3612.8 |
| 304 | 2025-02-02 18:08:34 | transacts | 3 | 148641 | 41 | 39.160 | 3795.7 |
| 303 | 2025-02-02 18:08:39 | transacts | 2 | 121436 | 12 | 11.796 | 10294.7 |
| 302 | 2025-02-02 18:05:29 | transacts | 1 | 81242 | 3 | 4.626 | 17562.0 |
| 301 | 2025-01-09 14:40:37 | transacts | 1 | 81242 | 3 | 5.703 | 14245.5 |
| 300 | 2025-01-04 01:13:25 | transacts | 2 | 121436 | 12 | 22.593 | 5374.9 |
| 299 | 2025-01-03 09:11:53 | transacts | 2 | 121436 | 12 | 9.110 | 13330.0 |
| 298 | 2025-01-02 11:13:58 | transacts | 2 | 121436 | 12 | 18.326 | 6626.4 |
| 297 | 2025-01-01 18:52:07 | transacts | 1 | 81242 | 3 | 7.143 | 11373.7 |
| 296 | 2025-01-01 17:47:27 | transacts | 3 | 148641 | 41 | 41.860 | 3550.9 |
| 295 | 2024-12-29 17:40:52 | transacts | 3 | 148641 | 41 | 32.796 | 4532.3 |
| 294 | 2024-12-29 17:41:01 | transacts | 2 | 121436 | 12 | 14.830 | 8188.5 |
| 293 | 2024-12-29 17:32:53 | transacts | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 292 | 2024-12-23 04:23:30 | transacts | 3 | 148641 | 41 | 36.160 | 4110.6 |
| 291 | 2024-12-21 04:20:04 | transacts | 3 | 148641 | 41 | 31.973 | 4649.0 |
| 290 | 2024-12-18 22:46:23 | transacts | 3 | 148641 | 41 | 35.670 | 4167.1 |
| 289 | 2024-12-18 18:03:53 | transacts | 3 | 148641 | 41 | 36.233 | 4102.4 |
| 288 | 2024-12-18 01:54:16 | transacts | 3 | 148641 | 41 | 37.063 | 4010.5 |
| 287 | 2024-12-16 17:49:29 | transacts | 1 | 81242 | 3 | 7.360 | 11038.3 |
| 286 | 2024-11-29 15:46:30 | transacts | 1 | 81242 | 3 | 6.673 | 12174.7 |
| 285 | 2024-11-29 01:46:45 | transacts | 1 | 81242 | 3 | 6.750 | 12035.9 |
| 284 | 2024-11-07 14:49:35 | transacts | 3 | 148641 | 41 | 39.283 | 3783.9 |
| 283 | 2024-11-07 14:46:32 | transacts | 2 | 121436 | 12 | 17.873 | 6794.4 |
| 282 | 2024-11-07 09:05:20 | transacts | 3 | 148641 | 41 | 45.003 | 3302.9 |
| 281 | 2024-11-07 09:05:16 | transacts | 2 | 121436 | 12 | 17.830 | 6810.8 |
| 280 | 2024-11-06 22:12:24 | transacts | 3 | 148641 | 41 | 30.250 | 4913.8 |
| 279 | 2024-11-06 14:31:23 | transacts | 4 | 165329 | 257 | 50.220 | 3292.1 |
| 278 | 2024-11-06 14:31:25 | transacts | 3 | 148641 | 41 | 33.860 | 4389.9 |
| 277 | 2024-11-06 14:31:25 | transacts | 2 | 121436 | 12 | 8.686 | 13980.7 |
| 276 | 2024-11-06 13:00:11 | transacts | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 275 | 2024-10-29 22:27:06 | transacts | 1 | 81242 | 3 | 1.250 | 64993.6 |