History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pretravel"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 103 | 2024-04-18 19:11:11 | pretravel | 4 | 165329 | 330 | 31.750 | 5207.2 |
| 102 | 2024-04-18 19:11:13 | pretravel | 3 | 148641 | 29 | 9.190 | 16174.2 |
| 101 | 2024-04-18 19:11:09 | pretravel | 2 | 121436 | 1 | 9.393 | 12928.4 |
| 100 | 2024-04-18 19:07:00 | pretravel | 1 | 81242 | 1 | 3.220 | 25230.4 |
| 99 | 2024-04-03 10:59:01 | pretravel | 1 | 81242 | 1 | 1.640 | 49537.8 |
| 98 | 2024-04-01 13:15:17 | pretravel | 1 | 81242 | 1 | 3.123 | 26014.1 |
| 97 | 2024-03-29 20:37:04 | pretravel | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 96 | 2024-03-29 20:31:15 | pretravel | 1 | 81242 | 1 | 1.373 | 59171.2 |
| 95 | 2024-03-28 16:26:41 | pretravel | 1 | 81242 | 1 | 2.970 | 27354.2 |
| 94 | 2024-03-02 12:11:35 | pretravel | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 93 | 2024-02-26 10:37:19 | pretravel | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 92 | 2024-02-26 06:50:32 | pretravel | 3 | 148641 | 29 | 13.203 | 11258.1 |
| 91 | 2024-02-24 19:28:33 | pretravel | 4 | 165329 | 330 | 37.643 | 4392.0 |
| 90 | 2024-02-24 19:28:33 | pretravel | 3 | 148641 | 29 | 9.190 | 16174.2 |
| 89 | 2024-02-24 19:28:31 | pretravel | 2 | 121436 | 1 | 6.810 | 17832.0 |
| 88 | 2024-02-24 19:13:37 | pretravel | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 87 | 2024-02-08 07:31:32 | pretravel | 1 | 81242 | 1 | 1.546 | 52549.8 |
| 86 | 2024-02-07 11:41:54 | pretravel | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 85 | 2024-02-06 01:13:43 | pretravel | 1 | 81242 | 1 | 2.653 | 30622.7 |
| 84 | 2024-01-22 21:04:41 | pretravel | 1 | 81242 | 1 | 3.220 | 25230.4 |
| 83 | 2021-10-04 10:40:58 | pretravel | 1 | 81242 | 1 | 1.250 | 64993.6 |
| 82 | 2020-11-02 19:49:36 | pretravel | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 81 | 2020-10-31 03:43:41 | pretravel | 1 | 81242 | 1 | 2.940 | 27633.3 |
| 80 | 2020-09-15 01:29:35 | pretravel | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 79 | 2020-03-23 08:37:56 | pretravel | 1 | 81242 | 1 | 3.126 | 25989.1 |
| 78 | 2020-03-15 00:20:00 | pretravel | 1 | 81242 | 1 | 1.280 | 63470.3 |
| 77 | 2020-03-02 19:11:54 | pretravel | 1 | 81242 | 1 | 2.970 | 27354.2 |
| 76 | 2020-02-11 06:00:17 | pretravel | 1 | 81242 | 1 | 1.640 | 49537.8 |
| 75 | 2020-02-04 14:50:23 | pretravel | 1 | 81242 | 1 | 2.610 | 31127.2 |
| 74 | 2020-02-02 02:44:15 | pretravel | 1 | 81242 | 1 | 1.640 | 49537.8 |
| 73 | 2020-01-26 21:59:53 | pretravel | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 72 | 2020-01-25 20:04:19 | pretravel | 1 | 81242 | 1 | 1.623 | 50056.7 |
| 71 | 2020-01-19 08:32:02 | pretravel | 1 | 81242 | 1 | 4.110 | 19766.9 |
| 70 | 2020-01-15 14:34:04 | pretravel | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 69 | 2020-01-02 16:05:09 | pretravel | 1 | 81242 | 1 | 3.330 | 24397.0 |
| 68 | 2019-12-31 14:42:20 | pretravel | 1 | 81242 | 1 | 3.110 | 26122.8 |
| 67 | 2019-12-06 09:09:01 | pretravel | 1 | 81242 | 1 | 1.283 | 63321.9 |
| 66 | 2019-11-05 02:22:16 | pretravel | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 65 | 2019-09-04 06:41:07 | pretravel | 1 | 81242 | 1 | 1.376 | 59042.2 |
| 64 | 2019-05-26 07:21:44 | pretravel | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 63 | 2019-05-23 04:45:33 | pretravel | 1 | 81242 | 1 | 1.276 | 63669.3 |
| 62 | 2019-04-03 05:46:41 | pretravel | 1 | 81242 | 1 | 1.240 | 65517.7 |
| 61 | 2019-04-01 11:52:22 | pretravel | 1 | 81242 | 1 | 1.263 | 64324.6 |
| 60 | 2019-02-14 14:34:57 | pretravel | 1 | 81242 | 1 | 1.256 | 64683.1 |
| 59 | 2019-02-01 19:46:20 | pretravel | 1 | 81242 | 1 | 1.540 | 52754.5 |
| 58 | 2019-02-01 05:31:57 | pretravel | 1 | 81242 | 1 | 1.410 | 57618.4 |
| 57 | 2019-01-27 17:52:38 | pretravel | 1 | 81242 | 1 | 1.443 | 56300.8 |
| 56 | 2019-01-04 16:45:21 | pretravel | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 55 | 2018-12-31 18:20:40 | pretravel | 1 | 81242 | 1 | 1.260 | 64477.8 |
| 54 | 2018-12-27 23:01:31 | pretravel | 1 | 81242 | 1 | 1.236 | 65729.8 |
| 53 | 2018-12-26 02:08:56 | pretravel | 1 | 81242 | 1 | 1.353 | 60045.8 |
| 52 | 2018-11-24 01:08:53 | pretravel | 1 | 81242 | 1 | 1.396 | 58196.3 |
| 51 | 2018-10-24 00:15:15 | pretravel | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 50 | 2018-10-20 13:05:29 | pretravel | 1 | 81242 | 1 | 1.306 | 62206.7 |
| 49 | 2018-09-28 19:39:58 | pretravel | 1 | 81242 | 1 | 1.373 | 59171.2 |
| 48 | 2018-06-30 20:37:51 | pretravel | 1 | 81242 | 1 | 1.223 | 66428.5 |
| 47 | 2018-06-29 12:11:45 | pretravel | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 46 | 2018-06-29 05:05:18 | pretravel | 1 | 81242 | 1 | 1.546 | 52549.8 |
| 45 | 2017-12-02 06:36:09 | pretravel | 1 | 81242 | 1 | 1.710 | 47509.9 |
| 44 | 2017-08-15 19:17:25 | pretravel | 1 | 81242 | 1 | 2.700 | 30089.6 |
| 43 | 2017-05-30 15:45:56 | pretravel | 1 | 81242 | 1 | 1.883 | 43145.0 |
| 42 | 2017-02-09 05:24:33 | pretravel | 1 | 81242 | 1 | 1.723 | 47151.5 |
| 41 | 2016-12-28 03:31:15 | pretravel | 1 | 81242 | 1 | 1.946 | 41748.2 |
| 40 | 2016-11-03 22:42:57 | pretravel | 1 | 81242 | 1 | 1.780 | 45641.6 |
| 39 | 2016-10-20 03:16:26 | pretravel | 1 | 81242 | 1 | 2.130 | 38141.8 |
| 38 | 2016-08-31 00:43:51 | pretravel | 3 | 148641 | 29 | 8.440 | 17611.5 |
| 37 | 2016-08-19 09:55:25 | pretravel | 4 | 165329 | 330 | 30.860 | 5357.4 |
| 36 | 2016-08-15 17:02:02 | pretravel | 1 | 81242 | 1 | 2.290 | 35476.9 |
| 35 | 2016-04-24 15:08:40 | pretravel | 1 | 81242 | 1 | 4.833 | 16809.8 |
| 34 | 2016-03-28 20:31:40 | pretravel | 1 | 81242 | 1 | 4.293 | 18924.3 |
| 33 | 2016-03-27 12:41:05 | pretravel | 1 | 81242 | 1 | 1.933 | 42029.0 |
| 32 | 2016-03-25 18:37:48 | pretravel | 2 | 121436 | 1 | 5.586 | 21739.3 |
| 31 | 2016-01-27 06:31:57 | pretravel | 1 | 81242 | 1 | 1.476 | 55042.0 |
| 30 | 2016-01-03 16:08:38 | pretravel | 1 | 81242 | 1 | 1.430 | 56812.6 |
| 29 | 2015-12-31 12:34:31 | pretravel | 1 | 81242 | 1 | 1.396 | 58196.3 |
| 28 | 2015-12-20 21:25:48 | pretravel | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 27 | 2015-11-01 14:13:37 | pretravel | 1 | 81242 | 1 | 1.363 | 59605.3 |
| 26 | 2015-10-25 09:24:52 | pretravel | 1 | 81242 | 1 | 1.400 | 58030.0 |
| 25 | 2015-10-17 22:05:28 | pretravel | 2 | 121436 | 1 | 3.733 | 32530.4 |
| 24 | 2015-10-17 21:12:34 | pretravel | 3 | 148641 | 29 | 8.956 | 16596.8 |
| 23 | 2015-09-18 09:30:28 | pretravel | 1 | 81242 | 1 | 1.396 | 58196.3 |
| 22 | 2015-09-04 12:39:07 | pretravel | 1 | 81242 | 1 | 1.506 | 53945.6 |
| 21 | 2015-08-26 09:41:14 | pretravel | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 20 | 2015-08-15 23:07:09 | pretravel | 2 | 121436 | 1 | 7.353 | 16515.2 |
| 19 | 2015-08-12 09:47:52 | pretravel | 3 | 148641 | 29 | 33.383 | 4452.6 |
| 18 | 2015-08-08 00:01:06 | pretravel | 4 | 165329 | 330 | 16.973 | 9740.7 |
| 17 | 2015-08-01 07:40:53 | pretravel | 1 | 81242 | 1 | 1.476 | 55042.0 |
| 16 | 2015-07-29 08:06:32 | pretravel | 1 | 81242 | 1 | 3.493 | 23258.5 |
| 15 | 2015-06-03 18:04:13 | pretravel | 1 | 81242 | 1 | 3.386 | 23993.5 |
| 14 | 2015-05-17 19:57:31 | pretravel | 1 | 81242 | 1 | 2.980 | 27262.4 |
| 13 | 2015-05-04 20:00:57 | pretravel | 2 | 121436 | 1 | 8.176 | 14852.7 |
| 12 | 2015-03-20 13:25:34 | pretravel | 3 | 148641 | 29 | 15.973 | 9305.8 |
| 11 | 2015-03-20 13:20:43 | pretravel | 3 | 148641 | 29 | 18.306 | 8119.8 |
| 10 | 2015-03-20 13:11:08 | pretravel | 1 | 81242 | 1 | 1.773 | 45821.8 |
| 9 | 2015-02-21 05:21:24 | pretravel | 1 | 81242 | 1 | 1.720 | 47233.7 |
| 8 | 2015-02-14 13:10:51 | pretravel | 1 | 81242 | 1 | 3.163 | 25685.1 |
| 7 | 2014-07-07 13:53:38 | pretravel | 1 | 81242 | 1 | 4.253 | 19102.3 |
| 6 | 2014-04-05 03:58:45 | pretravel | 1 | 81242 | 1 | 1.900 | 42758.9 |
| 5 | 2013-11-14 06:51:29 | pretravel | 2 | 121436 | 1 | 5.303 | 22899.5 |
| 4 | 2013-11-13 18:02:35 | pretravel | 1 | 81242 | 1 | 1.686 | 48186.2 |