History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"firewall"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 437 | 2024-04-26 10:03:37 | firewall | 1 | 82945 | 4 | 3.013 | 27529.0 |
| 436 | 2024-04-12 22:08:16 | firewall | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 435 | 2024-04-07 16:45:59 | firewall | 1 | 82945 | 4 | 3.606 | 23001.9 |
| 434 | 2024-04-06 01:20:46 | firewall | 3 | 146162 | 47 | 11.826 | 12359.4 |
| 433 | 2024-04-05 20:46:35 | firewall | 1 | 82945 | 4 | 2.236 | 37095.3 |
| 432 | 2024-04-05 02:49:40 | firewall | 2 | 121059 | 8 | 14.126 | 8569.9 |
| 431 | 2024-04-05 02:49:41 | firewall | 3 | 146162 | 47 | 11.186 | 13066.5 |
| 430 | 2024-04-03 15:47:23 | firewall | 3 | 146162 | 47 | 15.170 | 9634.9 |
| 429 | 2024-04-03 15:47:19 | firewall | 2 | 121059 | 8 | 8.720 | 13882.9 |
| 428 | 2024-04-03 15:46:17 | firewall | 1 | 82945 | 4 | 3.296 | 25165.4 |
| 427 | 2024-04-03 06:36:29 | firewall | 4 | 161609 | 406 | 20.173 | 8011.2 |
| 426 | 2024-04-01 15:15:42 | firewall | 4 | 161609 | 406 | 22.186 | 7284.3 |
| 425 | 2024-04-01 15:15:43 | firewall | 3 | 146162 | 47 | 11.703 | 12489.3 |
| 424 | 2024-04-01 15:15:26 | firewall | 3 | 146162 | 47 | 24.800 | 5893.6 |
| 423 | 2024-04-01 15:15:44 | firewall | 2 | 121059 | 8 | 6.233 | 19422.3 |
| 422 | 2024-04-01 15:15:28 | firewall | 4 | 161609 | 406 | 19.110 | 8456.8 |
| 421 | 2024-04-01 15:15:38 | firewall | 1 | 82945 | 4 | 2.343 | 35401.2 |
| 420 | 2024-04-01 15:15:27 | firewall | 2 | 121059 | 8 | 7.266 | 16661.0 |
| 419 | 2024-04-01 15:15:24 | firewall | 1 | 82945 | 4 | 4.406 | 18825.5 |
| 418 | 2024-03-28 15:31:31 | firewall | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 417 | 2024-03-26 14:35:41 | firewall | 1 | 82945 | 4 | 1.716 | 48336.2 |
| 416 | 2024-03-07 21:29:43 | firewall | 4 | 161609 | 406 | 25.266 | 6396.3 |
| 415 | 2024-03-04 21:51:30 | firewall | 1 | 82945 | 4 | 1.626 | 51011.7 |
| 414 | 2024-03-02 02:25:04 | firewall | 4 | 161609 | 406 | 23.160 | 6977.9 |
| 413 | 2024-03-01 19:59:46 | firewall | 1 | 82945 | 4 | 4.300 | 19289.5 |
| 412 | 2024-02-27 02:57:12 | firewall | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 411 | 2024-02-26 20:03:28 | firewall | 2 | 121059 | 8 | 3.703 | 32692.1 |
| 410 | 2024-02-25 23:04:45 | firewall | 4 | 161609 | 406 | 27.343 | 5910.4 |
| 409 | 2024-02-22 19:48:34 | firewall | 4 | 161609 | 406 | 12.923 | 12505.5 |
| 408 | 2024-02-22 19:48:33 | firewall | 2 | 121059 | 8 | 3.750 | 32282.4 |
| 407 | 2024-02-22 16:42:35 | firewall | 1 | 82945 | 4 | 1.283 | 64649.3 |
| 406 | 2024-02-06 12:57:57 | firewall | 4 | 161609 | 406 | 13.330 | 12123.7 |
| 405 | 2024-02-04 20:00:02 | firewall | 3 | 146162 | 47 | 11.690 | 12503.2 |
| 404 | 2024-02-04 03:08:35 | firewall | 3 | 146162 | 47 | 8.486 | 17223.9 |
| 403 | 2024-02-01 10:05:00 | firewall | 3 | 146162 | 47 | 14.110 | 10358.8 |
| 402 | 2024-01-23 04:11:44 | firewall | 4 | 161609 | 406 | 33.423 | 4835.3 |
| 401 | 2024-01-23 01:23:48 | firewall | 4 | 161609 | 406 | 15.690 | 10300.1 |
| 400 | 2024-01-22 21:11:23 | firewall | 3 | 146162 | 47 | 8.763 | 16679.4 |
| 399 | 2024-01-22 21:11:11 | firewall | 4 | 161609 | 406 | 19.206 | 8414.5 |
| 398 | 2024-01-22 21:11:07 | firewall | 2 | 121059 | 8 | 4.140 | 29241.3 |
| 397 | 2024-01-22 21:09:07 | firewall | 1 | 82945 | 4 | 3.250 | 25521.5 |
| 396 | 2023-12-08 02:03:12 | firewall | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 395 | 2023-12-07 04:10:08 | firewall | 1 | 82945 | 4 | 1.423 | 58288.8 |
| 394 | 2023-11-26 09:17:13 | firewall | 1 | 82945 | 4 | 1.253 | 66197.1 |
| 393 | 2023-10-18 10:05:49 | firewall | 1 | 82945 | 4 | 1.466 | 56579.1 |
| 392 | 2023-09-20 23:34:59 | firewall | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 391 | 2023-07-30 05:56:37 | firewall | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 390 | 2023-07-15 11:31:32 | firewall | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 389 | 2023-04-20 14:13:36 | firewall | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 388 | 2023-04-07 06:19:16 | firewall | 1 | 82945 | 4 | 1.220 | 67987.7 |
| 387 | 2023-03-04 06:26:55 | firewall | 1 | 82945 | 4 | 1.466 | 56579.1 |
| 386 | 2023-02-07 23:18:42 | firewall | 1 | 82945 | 4 | 1.233 | 67270.9 |
| 385 | 2022-12-08 17:55:24 | firewall | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 384 | 2022-12-06 04:47:00 | firewall | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 383 | 2022-08-05 07:27:16 | firewall | 1 | 82945 | 4 | 1.403 | 59119.7 |
| 382 | 2022-08-03 17:02:57 | firewall | 1 | 82945 | 4 | 1.263 | 65673.0 |
| 381 | 2022-05-16 00:17:05 | firewall | 1 | 82945 | 4 | 1.266 | 65517.4 |
| 380 | 2022-04-03 21:19:29 | firewall | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 379 | 2022-03-28 21:27:08 | firewall | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 378 | 2022-03-26 17:08:13 | firewall | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 377 | 2021-12-13 17:18:30 | firewall | 1 | 82945 | 4 | 1.360 | 60989.0 |
| 376 | 2021-10-09 17:58:10 | firewall | 1 | 82945 | 4 | 2.810 | 29517.8 |
| 375 | 2021-09-21 22:05:26 | firewall | 4 | 161609 | 406 | 12.156 | 13294.6 |
| 374 | 2021-09-18 17:39:22 | firewall | 4 | 161609 | 406 | 12.376 | 13058.3 |
| 373 | 2021-09-18 15:42:53 | firewall | 3 | 146162 | 47 | 6.300 | 23200.3 |
| 372 | 2021-09-17 14:41:25 | firewall | 3 | 146162 | 47 | 7.046 | 20744.0 |
| 371 | 2021-09-15 17:17:55 | firewall | 3 | 146162 | 47 | 6.313 | 23152.5 |
| 370 | 2021-09-14 17:29:00 | firewall | 3 | 146162 | 47 | 7.843 | 18636.0 |
| 369 | 2021-09-10 00:55:26 | firewall | 3 | 146162 | 47 | 7.406 | 19735.6 |
| 368 | 2021-09-08 08:38:58 | firewall | 3 | 146162 | 47 | 7.296 | 20033.2 |
| 367 | 2021-09-07 14:37:37 | firewall | 3 | 146162 | 47 | 6.986 | 20922.1 |
| 366 | 2021-09-06 19:38:44 | firewall | 3 | 146162 | 47 | 7.550 | 19359.2 |
| 365 | 2021-08-30 20:37:54 | firewall | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 364 | 2021-08-19 14:52:06 | firewall | 1 | 82945 | 4 | 1.283 | 64649.3 |
| 363 | 2021-08-04 14:35:23 | firewall | 3 | 146162 | 47 | 6.296 | 23215.1 |
| 362 | 2021-07-30 04:11:49 | firewall | 1 | 82945 | 4 | 1.233 | 67270.9 |
| 361 | 2021-07-26 03:44:18 | firewall | 1 | 82945 | 4 | 1.280 | 64800.8 |
| 360 | 2021-07-09 22:18:07 | firewall | 3 | 146162 | 47 | 7.406 | 19735.6 |
| 359 | 2021-05-23 23:31:18 | firewall | 3 | 146162 | 47 | 6.280 | 23274.2 |
| 358 | 2021-05-23 12:12:48 | firewall | 1 | 82945 | 4 | 1.440 | 57600.7 |
| 357 | 2021-05-23 10:19:19 | firewall | 3 | 146162 | 47 | 7.923 | 18447.8 |
| 356 | 2021-05-23 00:04:41 | firewall | 3 | 146162 | 47 | 7.236 | 20199.3 |
| 355 | 2021-05-22 12:44:49 | firewall | 3 | 146162 | 47 | 7.283 | 20068.9 |
| 354 | 2021-05-21 21:18:32 | firewall | 3 | 146162 | 47 | 6.766 | 21602.4 |
| 353 | 2021-05-18 23:45:54 | firewall | 3 | 146162 | 47 | 6.953 | 21021.4 |
| 352 | 2021-05-18 08:45:28 | firewall | 3 | 146162 | 47 | 6.266 | 23326.2 |
| 351 | 2021-05-17 13:06:35 | firewall | 3 | 146162 | 47 | 7.220 | 20244.0 |
| 350 | 2021-05-16 21:31:43 | firewall | 3 | 146162 | 47 | 7.013 | 20841.6 |
| 349 | 2021-05-16 04:29:59 | firewall | 3 | 146162 | 47 | 7.690 | 19006.8 |
| 348 | 2021-05-14 01:28:06 | firewall | 3 | 146162 | 47 | 7.140 | 20470.9 |
| 347 | 2021-05-12 16:37:29 | firewall | 3 | 146162 | 47 | 7.830 | 18666.9 |
| 346 | 2021-05-11 02:15:21 | firewall | 3 | 146162 | 47 | 7.546 | 19369.5 |
| 345 | 2021-05-10 11:06:01 | firewall | 3 | 146162 | 47 | 7.186 | 20339.8 |
| 344 | 2021-05-09 23:59:59 | firewall | 2 | 121059 | 8 | 4.077 | 29693.2 |
| 343 | 2021-05-09 20:50:26 | firewall | 3 | 146162 | 47 | 7.656 | 19091.2 |
| 342 | 2021-05-08 23:47:46 | firewall | 3 | 146162 | 47 | 7.296 | 20033.2 |
| 341 | 2021-05-08 06:31:53 | firewall | 3 | 146162 | 47 | 13.440 | 10875.1 |
| 340 | 2021-05-06 21:40:26 | firewall | 3 | 146162 | 47 | 7.796 | 18748.3 |
| 339 | 2021-05-05 10:12:28 | firewall | 3 | 146162 | 47 | 15.440 | 9466.5 |
| 338 | 2021-05-04 21:03:14 | firewall | 3 | 146162 | 47 | 6.203 | 23563.1 |