History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"violets"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 404 | 2024-12-21 05:40:28 | violets | 1 | 69583 | 3 | 2.326 | 29915.3 |
| 403 | 2024-11-29 11:47:17 | violets | 1 | 69583 | 3 | 4.953 | 14048.7 |
| 402 | 2024-11-19 16:34:50 | violets | 1 | 69583 | 3 | 2.906 | 23944.6 |
| 401 | 2024-10-29 22:07:14 | violets | 1 | 69583 | 3 | 5.220 | 13330.1 |
| 400 | 2024-10-24 22:24:04 | violets | 1 | 69583 | 3 | 4.220 | 16488.9 |
| 399 | 2024-10-17 04:51:11 | violets | 1 | 69583 | 3 | 6.143 | 11327.2 |
| 398 | 2024-10-16 23:01:54 | violets | 1 | 69583 | 3 | 5.936 | 11722.2 |
| 397 | 2024-10-12 02:48:17 | violets | 1 | 69583 | 3 | 2.736 | 25432.4 |
| 396 | 2024-09-29 01:27:15 | violets | 1 | 69583 | 3 | 5.110 | 13617.0 |
| 395 | 2024-09-13 21:56:40 | violets | 1 | 69583 | 3 | 4.236 | 16426.6 |
| 394 | 2024-09-08 12:14:44 | violets | 1 | 69583 | 3 | 4.530 | 15360.5 |
| 393 | 2024-09-08 07:10:11 | violets | 1 | 69583 | 3 | 9.986 | 6968.1 |
| 392 | 2024-09-05 08:19:11 | violets | 1 | 69583 | 3 | 10.673 | 6519.5 |
| 391 | 2024-08-29 04:55:23 | violets | 2 | 107671 | 37 | 32.313 | 3332.1 |
| 390 | 2024-08-29 03:22:37 | violets | 2 | 107671 | 37 | 24.893 | 4325.4 |
| 389 | 2024-08-29 02:04:20 | violets | 1 | 69583 | 3 | 3.530 | 19711.9 |
| 388 | 2024-08-28 14:54:50 | violets | 3 | 134027 | 412 | 48.270 | 2776.6 |
| 387 | 2024-08-20 23:08:56 | violets | 3 | 134027 | 412 | 90.753 | 1476.8 |
| 386 | 2024-08-20 04:12:12 | violets | 3 | 134027 | 412 | 25.656 | 5224.0 |
| 385 | 2024-08-19 18:23:34 | violets | 3 | 134027 | 412 | 68.973 | 1943.2 |
| 384 | 2024-08-18 03:36:25 | violets | 2 | 107671 | 37 | 21.816 | 4935.4 |
| 383 | 2024-08-17 21:57:06 | violets | 3 | 134027 | 412 | 61.956 | 2163.3 |
| 382 | 2024-08-17 21:57:08 | violets | 2 | 107671 | 37 | 35.296 | 3050.5 |
| 381 | 2024-08-17 21:57:02 | violets | 1 | 69583 | 3 | 4.406 | 15792.8 |
| 380 | 2024-08-17 03:38:45 | violets | 1 | 69583 | 3 | 10.450 | 6658.7 |
| 379 | 2024-08-13 14:37:22 | violets | 1 | 69583 | 3 | 7.546 | 9221.2 |
| 378 | 2024-08-12 16:05:30 | violets | 1 | 69583 | 3 | 9.813 | 7090.9 |
| 377 | 2024-08-01 16:29:52 | violets | 1 | 69583 | 3 | 3.876 | 17952.3 |
| 376 | 2024-08-01 16:29:17 | violets | 1 | 69583 | 3 | 4.110 | 16930.2 |
| 375 | 2024-07-29 00:03:45 | violets | 1 | 69583 | 3 | 3.143 | 22139.0 |
| 374 | 2024-07-20 07:31:57 | violets | 1 | 69583 | 3 | 3.843 | 18106.4 |
| 373 | 2024-07-02 05:26:24 | violets | 2 | 107671 | 37 | 11.500 | 9362.7 |
| 372 | 2024-07-02 05:26:09 | violets | 1 | 69583 | 3 | 4.923 | 14134.3 |
| 371 | 2024-07-02 03:09:30 | violets | 3 | 134027 | 412 | 23.766 | 5639.4 |
| 370 | 2024-07-02 01:59:51 | violets | 3 | 134027 | 412 | 45.160 | 2967.8 |
| 369 | 2024-06-30 06:36:07 | violets | 1 | 69583 | 3 | 6.216 | 11194.2 |
| 368 | 2024-06-29 15:45:28 | violets | 1 | 69583 | 3 | 2.300 | 30253.5 |
| 367 | 2024-06-26 19:51:33 | violets | 3 | 134027 | 412 | 21.783 | 6152.8 |
| 366 | 2024-06-26 14:49:52 | violets | 1 | 69583 | 3 | 4.030 | 17266.3 |
| 365 | 2024-06-26 14:42:47 | violets | 1 | 69583 | 3 | 5.936 | 11722.2 |
| 364 | 2024-06-25 05:10:07 | violets | 3 | 134027 | 412 | 31.406 | 4267.6 |
| 363 | 2024-06-24 10:31:00 | violets | 3 | 134027 | 412 | 10.893 | 12304.0 |
| 362 | 2024-06-22 23:09:03 | violets | 3 | 134027 | 412 | 34.983 | 3831.2 |
| 361 | 2024-06-21 19:49:16 | violets | 1 | 69583 | 3 | 2.110 | 32977.7 |
| 360 | 2024-06-19 14:44:45 | violets | 3 | 134027 | 412 | 31.346 | 4275.7 |
| 359 | 2024-06-19 14:44:48 | violets | 2 | 107671 | 37 | 19.113 | 5633.4 |
| 358 | 2024-06-19 14:44:10 | violets | 1 | 69583 | 3 | 4.436 | 15686.0 |
| 357 | 2024-05-30 12:00:10 | violets | 1 | 69583 | 3 | 2.983 | 23326.5 |
| 356 | 2024-05-08 03:45:02 | violets | 2 | 107671 | 37 | 8.686 | 12395.9 |
| 355 | 2024-05-08 03:42:30 | violets | 2 | 107671 | 37 | 6.546 | 16448.4 |
| 354 | 2024-05-08 03:42:20 | violets | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 353 | 2024-05-08 03:42:01 | violets | 3 | 134027 | 412 | 7.830 | 17117.1 |
| 352 | 2024-05-07 12:23:55 | violets | 3 | 134027 | 412 | 11.423 | 11733.1 |
| 351 | 2024-05-07 09:44:34 | violets | 3 | 134027 | 412 | 6.623 | 20236.6 |
| 350 | 2024-04-25 21:51:52 | violets | 3 | 134027 | 412 | 12.483 | 10736.8 |
| 349 | 2024-04-25 06:05:19 | violets | 1 | 69583 | 3 | 1.846 | 37693.9 |
| 348 | 2024-04-25 05:00:22 | violets | 3 | 134027 | 412 | 21.690 | 6179.2 |
| 347 | 2024-04-25 05:00:21 | violets | 2 | 107671 | 37 | 9.123 | 11802.1 |
| 346 | 2024-04-25 04:57:49 | violets | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 345 | 2024-04-19 03:04:20 | violets | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 344 | 2024-03-30 13:10:35 | violets | 1 | 69583 | 3 | 3.656 | 19032.5 |
| 343 | 2024-03-28 17:48:29 | violets | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 342 | 2024-02-27 16:00:25 | violets | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 341 | 2024-02-14 22:54:22 | violets | 1 | 69583 | 3 | 1.860 | 37410.2 |
| 340 | 2024-01-06 10:36:35 | violets | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 339 | 2024-01-06 08:58:06 | violets | 3 | 134027 | 412 | 6.360 | 21073.4 |
| 338 | 2024-01-06 08:58:07 | violets | 2 | 107671 | 37 | 3.326 | 32372.5 |
| 337 | 2024-01-01 17:36:55 | violets | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 336 | 2023-12-19 10:32:37 | violets | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 335 | 2023-12-04 17:02:56 | violets | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 334 | 2023-12-04 17:02:55 | violets | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 333 | 2023-11-29 10:06:39 | violets | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 332 | 2023-11-21 07:47:03 | violets | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 331 | 2023-10-31 13:38:17 | violets | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 330 | 2023-10-23 15:35:05 | violets | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 329 | 2023-10-13 23:11:57 | violets | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 328 | 2023-09-23 08:32:57 | violets | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 327 | 2023-08-19 08:17:30 | violets | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 326 | 2023-08-06 01:25:19 | violets | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 325 | 2023-05-21 03:08:16 | violets | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 324 | 2023-04-06 11:36:31 | violets | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 323 | 2023-03-22 05:46:14 | violets | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 322 | 2023-03-14 00:39:24 | violets | 1 | 69583 | 3 | 1.016 | 68487.2 |
| 321 | 2023-01-02 19:17:57 | violets | 1 | 69583 | 3 | 1.016 | 68487.2 |
| 320 | 2022-12-01 10:48:18 | violets | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 319 | 2022-11-28 03:49:01 | violets | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 318 | 2022-09-22 05:51:22 | violets | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 317 | 2022-07-13 23:32:34 | violets | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 316 | 2022-05-05 22:09:16 | violets | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 315 | 2022-03-03 08:37:38 | violets | 1 | 69583 | 3 | 1.453 | 47889.2 |
| 314 | 2022-01-22 19:08:21 | violets | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 313 | 2021-12-04 22:26:23 | violets | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 312 | 2021-10-30 12:42:06 | violets | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 311 | 2021-07-26 21:03:32 | violets | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 310 | 2021-07-13 06:05:16 | violets | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 309 | 2021-05-17 13:00:01 | violets | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 308 | 2021-04-17 13:33:51 | violets | 1 | 69583 | 3 | 1.016 | 68487.2 |
| 307 | 2021-04-09 18:11:15 | violets | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 306 | 2021-03-20 09:55:48 | violets | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 305 | 2021-02-26 05:29:16 | violets | 1 | 69583 | 3 | 1.110 | 62687.4 |