History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aardvarks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
6455 | 2024-05-05 19:45:09 | aardvarks | 1 | 81242 | 2 | 1.500 | 54161.3 |
6454 | 2024-05-05 12:16:33 | aardvarks | 1 | 81242 | 2 | 4.563 | 17804.5 |
6453 | 2024-05-05 09:50:36 | aardvarks | 4 | 165329 | 113 | 23.890 | 6920.4 |
6452 | 2024-05-05 09:50:32 | aardvarks | 3 | 148641 | 14 | 16.876 | 8807.8 |
6451 | 2024-05-05 09:50:33 | aardvarks | 2 | 121436 | 2 | 12.626 | 9617.9 |
6450 | 2024-05-05 09:33:10 | aardvarks | 1 | 81242 | 2 | 4.733 | 17165.0 |
6449 | 2024-05-04 16:43:10 | aardvarks | 3 | 148641 | 14 | 7.546 | 19698.0 |
6448 | 2024-05-04 04:56:42 | aardvarks | 1 | 81242 | 2 | 1.546 | 52549.8 |
6447 | 2024-05-03 15:35:15 | aardvarks | 1 | 81242 | 2 | 1.846 | 44009.8 |
6446 | 2024-05-02 20:24:19 | aardvarks | 1 | 81242 | 2 | 4.140 | 19623.7 |
6445 | 2024-05-02 10:43:10 | aardvarks | 1 | 81242 | 2 | 1.500 | 54161.3 |
6444 | 2024-05-02 09:20:40 | aardvarks | 4 | 165329 | 113 | 17.266 | 9575.4 |
6443 | 2024-05-02 09:20:17 | aardvarks | 3 | 148641 | 14 | 8.390 | 17716.4 |
6442 | 2024-05-02 09:19:59 | aardvarks | 2 | 121436 | 2 | 4.470 | 27166.9 |
6441 | 2024-05-02 03:25:57 | aardvarks | 1 | 81242 | 2 | 1.436 | 56575.2 |
6440 | 2024-05-01 06:17:12 | aardvarks | 4 | 165329 | 113 | 20.423 | 8095.2 |
6439 | 2024-04-29 07:32:24 | aardvarks | 3 | 148641 | 14 | 7.250 | 20502.2 |
6438 | 2024-04-29 07:17:54 | aardvarks | 3 | 148641 | 14 | 7.156 | 20771.5 |
6437 | 2024-04-28 22:16:58 | aardvarks | 2 | 121436 | 2 | 3.640 | 33361.5 |
6436 | 2024-04-27 16:59:16 | aardvarks | 1 | 81242 | 2 | 1.593 | 50999.4 |
6435 | 2024-04-27 04:48:02 | aardvarks | 1 | 81242 | 2 | 3.280 | 24768.9 |
6434 | 2024-04-26 19:38:38 | aardvarks | 4 | 165329 | 113 | 12.826 | 12890.1 |
6433 | 2024-04-26 08:40:25 | aardvarks | 4 | 165329 | 113 | 14.530 | 11378.5 |
6432 | 2024-04-25 21:49:47 | aardvarks | 1 | 81242 | 2 | 1.623 | 50056.7 |
6431 | 2024-04-25 19:53:19 | aardvarks | 4 | 165329 | 113 | 16.860 | 9806.0 |
6430 | 2024-04-24 15:20:21 | aardvarks | 1 | 81242 | 2 | 4.143 | 19609.5 |
6429 | 2024-04-24 14:22:30 | aardvarks | 1 | 81242 | 2 | 3.140 | 25873.2 |
6428 | 2024-04-24 11:19:26 | aardvarks | 1 | 81242 | 2 | 6.046 | 13437.3 |
6427 | 2024-04-21 06:36:02 | aardvarks | 1 | 81242 | 2 | 1.453 | 55913.3 |
6426 | 2024-04-21 02:51:09 | aardvarks | 1 | 81242 | 2 | 7.766 | 10461.2 |
6425 | 2024-04-20 19:01:06 | aardvarks | 1 | 81242 | 2 | 2.533 | 32073.4 |
6424 | 2024-04-19 04:07:27 | aardvarks | 1 | 81242 | 2 | 1.623 | 50056.7 |
6423 | 2024-04-19 01:45:53 | aardvarks | 3 | 148641 | 14 | 7.063 | 21045.0 |
6422 | 2024-04-18 09:35:12 | aardvarks | 1 | 81242 | 2 | 5.503 | 14763.2 |
6421 | 2024-04-17 23:02:17 | aardvarks | 3 | 148641 | 14 | 11.423 | 13012.4 |
6420 | 2024-04-17 23:02:18 | aardvarks | 2 | 121436 | 2 | 4.843 | 25074.5 |
6419 | 2024-04-17 19:53:35 | aardvarks | 2 | 121436 | 2 | 6.013 | 20195.6 |
6418 | 2024-04-17 09:12:19 | aardvarks | 4 | 165329 | 113 | 13.376 | 12360.1 |
6417 | 2024-04-17 09:12:12 | aardvarks | 3 | 148641 | 14 | 6.733 | 22076.5 |
6416 | 2024-04-17 09:12:07 | aardvarks | 2 | 121436 | 2 | 4.373 | 27769.5 |
6415 | 2024-04-17 08:36:03 | aardvarks | 1 | 81242 | 2 | 1.360 | 59736.8 |
6414 | 2024-04-16 07:07:11 | aardvarks | 1 | 81242 | 2 | 1.593 | 50999.4 |
6413 | 2024-04-16 04:58:25 | aardvarks | 1 | 81242 | 2 | 4.216 | 19269.9 |
6412 | 2024-04-15 13:51:12 | aardvarks | 4 | 165329 | 113 | 54.876 | 3012.8 |
6411 | 2024-04-15 13:51:14 | aardvarks | 3 | 148641 | 14 | 18.966 | 7837.2 |
6410 | 2024-04-15 13:51:16 | aardvarks | 2 | 121436 | 2 | 6.376 | 19045.8 |
6409 | 2024-04-15 13:50:08 | aardvarks | 4 | 165329 | 113 | 24.643 | 6709.0 |
6408 | 2024-04-15 13:50:08 | aardvarks | 3 | 148641 | 14 | 19.266 | 7715.2 |
6407 | 2024-04-15 13:50:08 | aardvarks | 2 | 121436 | 2 | 12.733 | 9537.1 |
6406 | 2024-04-15 13:29:57 | aardvarks | 1 | 81242 | 2 | 1.610 | 50460.9 |
6405 | 2024-04-13 14:37:27 | aardvarks | 4 | 165329 | 113 | 12.766 | 12950.7 |
6404 | 2024-04-13 14:37:19 | aardvarks | 3 | 148641 | 14 | 7.030 | 21143.8 |
6403 | 2024-04-13 14:37:15 | aardvarks | 2 | 121436 | 2 | 3.750 | 32382.9 |
6402 | 2024-04-13 14:05:25 | aardvarks | 1 | 81242 | 2 | 1.403 | 57905.9 |
6401 | 2024-04-12 10:06:56 | aardvarks | 1 | 81242 | 2 | 3.640 | 22319.2 |
6400 | 2024-04-11 05:39:50 | aardvarks | 1 | 81242 | 2 | 1.483 | 54782.2 |
6399 | 2024-04-09 18:43:31 | aardvarks | 1 | 81242 | 2 | 1.533 | 52995.4 |
6398 | 2024-04-09 17:22:14 | aardvarks | 1 | 81242 | 2 | 4.783 | 16985.6 |
6397 | 2024-04-09 16:51:18 | aardvarks | 1 | 81242 | 2 | 1.346 | 60358.1 |
6396 | 2024-04-09 15:54:36 | aardvarks | 1 | 81242 | 2 | 3.123 | 26014.1 |
6395 | 2024-04-07 19:55:47 | aardvarks | 4 | 165329 | 113 | 25.046 | 6601.0 |
6394 | 2024-04-07 19:55:51 | aardvarks | 3 | 148641 | 14 | 18.626 | 7980.3 |
6393 | 2024-04-07 19:55:54 | aardvarks | 2 | 121436 | 2 | 8.736 | 13900.6 |
6392 | 2024-04-07 19:43:03 | aardvarks | 1 | 81242 | 2 | 2.513 | 32328.7 |
6391 | 2024-04-01 09:12:18 | aardvarks | 4 | 165329 | 113 | 21.783 | 7589.8 |
6390 | 2024-04-01 09:12:22 | aardvarks | 2 | 121436 | 2 | 4.410 | 27536.5 |
6389 | 2024-04-01 09:12:16 | aardvarks | 1 | 81242 | 2 | 3.266 | 24875.1 |
6388 | 2024-04-01 09:08:38 | aardvarks | 3 | 148641 | 14 | 8.860 | 16776.6 |
6387 | 2024-03-29 03:31:47 | aardvarks | 1 | 81242 | 2 | 1.576 | 51549.5 |
6386 | 2024-03-20 20:09:27 | aardvarks | 2 | 121436 | 2 | 8.686 | 13980.7 |
6385 | 2024-03-20 19:30:50 | aardvarks | 1 | 81242 | 2 | 1.843 | 44081.4 |
6384 | 2024-03-15 09:45:04 | aardvarks | 1 | 81242 | 2 | 2.016 | 40298.6 |
6383 | 2024-03-12 18:13:12 | aardvarks | 4 | 165329 | 113 | 11.706 | 14123.4 |
6382 | 2024-03-08 10:27:29 | aardvarks | 1 | 81242 | 2 | 3.593 | 22611.2 |
6381 | 2024-03-05 09:30:52 | aardvarks | 4 | 165329 | 113 | 16.906 | 9779.3 |
6380 | 2024-03-05 09:30:44 | aardvarks | 3 | 148641 | 14 | 8.330 | 17844.1 |
6379 | 2024-03-05 09:30:39 | aardvarks | 2 | 121436 | 2 | 4.156 | 29219.4 |
6378 | 2024-03-05 08:47:20 | aardvarks | 1 | 81242 | 2 | 1.893 | 42917.1 |
6377 | 2024-03-04 11:42:27 | aardvarks | 2 | 121436 | 2 | 5.220 | 23263.6 |
6376 | 2024-03-04 11:40:29 | aardvarks | 1 | 81242 | 2 | 1.470 | 55266.7 |
6375 | 2024-03-03 16:15:01 | aardvarks | 1 | 81242 | 2 | 1.470 | 55266.7 |
6374 | 2024-03-03 06:39:21 | aardvarks | 2 | 121436 | 2 | 8.016 | 15149.2 |
6373 | 2024-03-01 18:13:33 | aardvarks | 1 | 81242 | 2 | 2.580 | 31489.1 |
6372 | 2024-02-29 11:17:22 | aardvarks | 4 | 165329 | 113 | 17.546 | 9422.6 |
6371 | 2024-02-29 11:00:04 | aardvarks | 3 | 148641 | 14 | 7.466 | 19909.1 |
6370 | 2024-02-29 11:00:00 | aardvarks | 2 | 121436 | 2 | 3.530 | 34401.1 |
6369 | 2024-02-25 21:15:02 | aardvarks | 4 | 165329 | 113 | 36.080 | 4582.3 |
6368 | 2024-02-25 16:02:47 | aardvarks | 4 | 165329 | 113 | 12.423 | 13308.3 |
6367 | 2024-02-25 16:02:46 | aardvarks | 3 | 148641 | 14 | 7.173 | 20722.3 |
6366 | 2024-02-25 16:02:45 | aardvarks | 2 | 121436 | 2 | 3.703 | 32794.0 |
6365 | 2024-02-25 15:47:31 | aardvarks | 1 | 81242 | 2 | 1.406 | 57782.4 |
6364 | 2024-02-21 07:08:05 | aardvarks | 1 | 81242 | 2 | 1.530 | 53099.3 |
6363 | 2024-02-21 06:01:28 | aardvarks | 1 | 81242 | 2 | 1.596 | 50903.5 |
6362 | 2024-02-19 13:49:58 | aardvarks | 1 | 81242 | 2 | 1.436 | 56575.2 |
6361 | 2024-02-08 18:03:01 | aardvarks | 1 | 81242 | 2 | 2.000 | 40621.0 |
6360 | 2024-01-31 07:32:28 | aardvarks | 3 | 148641 | 14 | 6.250 | 23782.6 |
6359 | 2024-01-29 17:08:54 | aardvarks | 1 | 81242 | 2 | 1.280 | 63470.3 |
6358 | 2024-01-26 14:04:45 | aardvarks | 1 | 81242 | 2 | 1.343 | 60492.9 |
6357 | 2024-01-26 13:45:12 | aardvarks | 4 | 165329 | 113 | 14.080 | 11742.1 |
6356 | 2024-01-26 13:45:03 | aardvarks | 3 | 148641 | 14 | 8.123 | 18298.8 |