History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"allergy"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 460 | 2024-04-27 14:19:00 | allergy | 1 | 69583 | 1 | 4.733 | 14701.7 |
| 459 | 2024-04-25 13:39:58 | allergy | 3 | 134027 | 83 | 6.893 | 19443.9 |
| 458 | 2024-04-13 04:15:20 | allergy | 4 | 151207 | 1029 | 10.533 | 14355.5 |
| 457 | 2024-04-11 12:03:20 | allergy | 2 | 107671 | 10 | 5.156 | 20882.7 |
| 456 | 2024-04-11 00:20:44 | allergy | 3 | 134027 | 83 | 14.640 | 9154.8 |
| 455 | 2024-04-09 20:35:50 | allergy | 3 | 134027 | 83 | 8.250 | 16245.7 |
| 454 | 2024-04-09 17:34:09 | allergy | 4 | 151207 | 1029 | 27.953 | 5409.3 |
| 453 | 2024-04-09 11:01:35 | allergy | 3 | 134027 | 83 | 11.516 | 11638.3 |
| 452 | 2024-04-09 11:01:34 | allergy | 2 | 107671 | 10 | 8.076 | 13332.2 |
| 451 | 2024-04-09 03:38:19 | allergy | 4 | 151207 | 1029 | 30.436 | 4968.0 |
| 450 | 2024-04-08 14:06:21 | allergy | 3 | 134027 | 83 | 7.970 | 16816.4 |
| 449 | 2024-04-08 11:03:53 | allergy | 4 | 151207 | 1029 | 14.423 | 10483.7 |
| 448 | 2024-04-08 08:31:00 | allergy | 4 | 151207 | 1029 | 14.046 | 10765.1 |
| 447 | 2024-04-08 08:31:00 | allergy | 3 | 134027 | 83 | 13.593 | 9860.0 |
| 446 | 2024-04-08 08:30:57 | allergy | 2 | 107671 | 10 | 4.970 | 21664.2 |
| 445 | 2024-04-08 08:30:57 | allergy | 1 | 69583 | 1 | 1.376 | 50569.0 |
| 444 | 2024-04-05 13:35:46 | allergy | 1 | 69583 | 1 | 2.673 | 26031.8 |
| 443 | 2024-03-25 01:46:12 | allergy | 1 | 69583 | 1 | 1.376 | 50569.0 |
| 442 | 2024-02-27 23:14:13 | allergy | 1 | 69583 | 1 | 1.983 | 35089.8 |
| 441 | 2023-12-19 13:00:34 | allergy | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 440 | 2023-12-13 04:00:29 | allergy | 3 | 134027 | 83 | 5.876 | 22809.2 |
| 439 | 2023-12-06 06:38:27 | allergy | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 438 | 2023-12-02 13:36:46 | allergy | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 437 | 2023-11-13 17:07:49 | allergy | 1 | 69583 | 1 | 1.106 | 62914.1 |
| 436 | 2023-11-11 08:30:27 | allergy | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 435 | 2023-10-10 22:36:30 | allergy | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 434 | 2023-10-06 17:01:18 | allergy | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 433 | 2023-09-11 08:47:39 | allergy | 3 | 134027 | 83 | 5.750 | 23309.0 |
| 432 | 2023-08-02 07:30:21 | allergy | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 431 | 2023-06-03 07:00:23 | allergy | 3 | 134027 | 83 | 5.673 | 23625.4 |
| 430 | 2023-05-31 22:39:12 | allergy | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 429 | 2023-04-29 00:36:55 | allergy | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 428 | 2023-03-08 23:15:25 | allergy | 3 | 134027 | 83 | 5.660 | 23679.7 |
| 427 | 2023-02-18 11:05:54 | allergy | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 426 | 2023-02-05 06:55:51 | allergy | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 425 | 2022-12-14 19:24:54 | allergy | 3 | 134027 | 83 | 7.156 | 18729.3 |
| 424 | 2022-12-14 03:09:49 | allergy | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 423 | 2022-12-01 09:51:19 | allergy | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 422 | 2022-11-28 14:20:45 | allergy | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 421 | 2022-10-04 07:07:24 | allergy | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 420 | 2022-08-20 00:37:08 | allergy | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 419 | 2022-08-02 09:26:18 | allergy | 3 | 134027 | 83 | 5.780 | 23188.1 |
| 418 | 2022-05-27 16:16:31 | allergy | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 417 | 2022-04-25 01:35:27 | allergy | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 416 | 2022-01-19 08:23:12 | allergy | 1 | 69583 | 1 | 1.216 | 57222.9 |
| 415 | 2022-01-16 02:09:29 | allergy | 1 | 69583 | 1 | 1.470 | 47335.4 |
| 414 | 2022-01-12 19:13:52 | allergy | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 413 | 2021-09-20 14:12:26 | allergy | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 412 | 2021-08-23 06:00:59 | allergy | 1 | 69583 | 1 | 1.216 | 57222.9 |
| 411 | 2021-06-07 01:33:57 | allergy | 4 | 151207 | 1029 | 11.780 | 12835.9 |
| 410 | 2021-06-06 18:39:10 | allergy | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 409 | 2021-06-03 21:07:42 | allergy | 4 | 151207 | 1029 | 10.873 | 13906.6 |
| 408 | 2021-06-03 14:18:52 | allergy | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 407 | 2021-03-01 11:28:01 | allergy | 4 | 151207 | 1029 | 10.000 | 15120.7 |
| 406 | 2021-03-01 03:45:30 | allergy | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 405 | 2020-11-29 19:35:26 | allergy | 4 | 151207 | 1029 | 10.066 | 15021.6 |
| 404 | 2020-11-24 19:09:14 | allergy | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 403 | 2020-08-19 16:42:42 | allergy | 1 | 69583 | 1 | 1.106 | 62914.1 |
| 402 | 2020-07-31 02:12:36 | allergy | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 401 | 2020-05-18 10:29:17 | allergy | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 400 | 2020-05-11 21:37:28 | allergy | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 399 | 2020-03-29 11:06:20 | allergy | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 398 | 2020-03-25 23:52:24 | allergy | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 397 | 2020-03-22 03:14:09 | allergy | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 396 | 2020-02-25 05:27:17 | allergy | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 395 | 2020-02-23 17:36:06 | allergy | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 394 | 2020-02-19 09:45:18 | allergy | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 393 | 2020-02-19 03:07:11 | allergy | 1 | 69583 | 1 | 1.346 | 51696.1 |
| 392 | 2020-02-15 23:14:54 | allergy | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 391 | 2020-02-15 13:28:30 | allergy | 1 | 69583 | 1 | 2.720 | 25582.0 |
| 390 | 2020-02-09 21:36:39 | allergy | 1 | 69583 | 1 | 4.343 | 16021.9 |
| 389 | 2020-02-06 23:57:33 | allergy | 4 | 151207 | 1029 | 17.406 | 8687.1 |
| 388 | 2020-02-06 20:39:50 | allergy | 4 | 151207 | 1029 | 19.420 | 7786.1 |
| 387 | 2020-02-06 18:40:40 | allergy | 4 | 151207 | 1029 | 11.423 | 13237.1 |
| 386 | 2020-02-04 12:05:33 | allergy | 4 | 151207 | 1029 | 15.560 | 9717.7 |
| 385 | 2020-02-04 00:31:32 | allergy | 4 | 151207 | 1029 | 25.736 | 5875.3 |
| 384 | 2020-02-03 15:29:34 | allergy | 1 | 69583 | 1 | 2.186 | 31831.2 |
| 383 | 2020-02-03 03:27:27 | allergy | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 382 | 2020-01-27 06:55:20 | allergy | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 381 | 2020-01-25 02:49:52 | allergy | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 380 | 2020-01-22 18:58:29 | allergy | 1 | 69583 | 1 | 1.796 | 38743.3 |
| 379 | 2020-01-17 03:15:37 | allergy | 4 | 151207 | 1029 | 12.970 | 11658.2 |
| 378 | 2020-01-14 16:57:11 | allergy | 1 | 69583 | 1 | 1.216 | 57222.9 |
| 377 | 2020-01-13 19:38:46 | allergy | 3 | 134027 | 83 | 6.013 | 22289.5 |
| 376 | 2020-01-13 16:32:49 | allergy | 3 | 134027 | 83 | 6.533 | 20515.4 |
| 375 | 2020-01-13 14:35:33 | allergy | 4 | 151207 | 1029 | 19.610 | 7710.7 |
| 374 | 2020-01-13 13:32:56 | allergy | 4 | 151207 | 1029 | 28.720 | 5264.9 |
| 373 | 2020-01-13 09:16:08 | allergy | 4 | 151207 | 1029 | 34.266 | 4412.7 |
| 372 | 2020-01-13 09:16:05 | allergy | 3 | 134027 | 83 | 18.953 | 7071.5 |
| 371 | 2020-01-13 09:16:13 | allergy | 2 | 107671 | 10 | 10.686 | 10075.9 |
| 370 | 2020-01-13 05:21:04 | allergy | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 369 | 2020-01-10 09:35:57 | allergy | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 368 | 2020-01-01 13:31:06 | allergy | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 367 | 2019-12-31 11:57:27 | allergy | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 366 | 2019-12-25 12:19:43 | allergy | 1 | 69583 | 1 | 2.500 | 27833.2 |
| 365 | 2019-12-11 14:53:56 | allergy | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 364 | 2019-11-15 16:58:58 | allergy | 1 | 69583 | 1 | 2.186 | 31831.2 |
| 363 | 2019-08-14 07:28:55 | allergy | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 362 | 2019-08-11 10:24:08 | allergy | 4 | 151207 | 1029 | 9.986 | 15141.9 |
| 361 | 2019-08-08 20:10:15 | allergy | 4 | 151207 | 1029 | 10.133 | 14922.2 |