History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prelected"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 201 | 2024-04-20 16:25:51 | prelected | 2 | 121436 | 31 | 5.970 | 20341.0 |
| 200 | 2024-04-20 03:32:10 | prelected | 2 | 121436 | 31 | 15.393 | 7889.0 |
| 199 | 2024-04-18 21:29:07 | prelected | 2 | 121436 | 31 | 3.423 | 35476.5 |
| 198 | 2024-04-08 08:20:02 | prelected | 1 | 81242 | 3 | 1.403 | 57905.9 |
| 197 | 2024-04-08 02:51:52 | prelected | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 196 | 2024-03-29 05:18:01 | prelected | 1 | 81242 | 3 | 1.733 | 46879.4 |
| 195 | 2024-03-25 03:06:57 | prelected | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 194 | 2024-03-02 09:35:52 | prelected | 1 | 81242 | 3 | 4.720 | 17212.3 |
| 193 | 2024-03-01 01:30:03 | prelected | 1 | 81242 | 3 | 1.403 | 57905.9 |
| 192 | 2024-02-27 19:26:37 | prelected | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 191 | 2024-02-12 13:47:48 | prelected | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 190 | 2024-01-30 18:58:44 | prelected | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 189 | 2024-01-28 17:20:23 | prelected | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 188 | 2023-12-14 14:29:10 | prelected | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 187 | 2023-12-12 02:15:26 | prelected | 2 | 121436 | 31 | 3.220 | 37713.0 |
| 186 | 2023-12-01 04:31:52 | prelected | 1 | 81242 | 3 | 3.030 | 26812.5 |
| 185 | 2023-11-29 08:19:31 | prelected | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 184 | 2023-11-26 14:37:39 | prelected | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 183 | 2023-11-21 23:59:49 | prelected | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 182 | 2023-10-25 00:47:30 | prelected | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 181 | 2023-09-24 07:58:01 | prelected | 1 | 81242 | 3 | 1.440 | 56418.1 |
| 180 | 2023-09-14 12:06:15 | prelected | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 179 | 2023-09-11 23:40:13 | prelected | 2 | 121436 | 31 | 3.983 | 30488.6 |
| 178 | 2023-07-30 12:23:58 | prelected | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 177 | 2023-06-29 06:28:01 | prelected | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 176 | 2023-06-09 10:03:10 | prelected | 2 | 121436 | 31 | 3.156 | 38477.8 |
| 175 | 2023-04-09 11:34:18 | prelected | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 174 | 2023-04-07 12:43:11 | prelected | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 173 | 2023-04-03 19:17:32 | prelected | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 172 | 2023-03-12 09:20:57 | prelected | 2 | 121436 | 31 | 3.313 | 36654.4 |
| 171 | 2023-01-30 11:18:40 | prelected | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 170 | 2022-12-18 09:53:22 | prelected | 2 | 121436 | 31 | 4.783 | 25389.1 |
| 169 | 2022-12-15 09:47:38 | prelected | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 168 | 2022-11-26 22:26:18 | prelected | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 167 | 2022-08-18 11:25:06 | prelected | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 166 | 2022-08-12 23:15:05 | prelected | 2 | 121436 | 31 | 3.623 | 33518.1 |
| 165 | 2022-08-10 13:27:28 | prelected | 2 | 121436 | 31 | 3.300 | 36798.8 |
| 164 | 2022-07-20 16:06:32 | prelected | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 163 | 2022-07-16 02:13:03 | prelected | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 162 | 2022-06-07 10:03:17 | prelected | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 161 | 2022-04-18 00:49:31 | prelected | 1 | 81242 | 3 | 1.393 | 58321.6 |
| 160 | 2022-03-24 09:37:54 | prelected | 2 | 121436 | 31 | 3.826 | 31739.7 |
| 159 | 2022-03-13 18:22:26 | prelected | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 158 | 2022-03-11 13:19:53 | prelected | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 157 | 2022-01-05 19:37:52 | prelected | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 156 | 2021-12-26 17:21:12 | prelected | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 155 | 2021-09-13 03:16:03 | prelected | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 154 | 2021-06-13 00:03:59 | prelected | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 153 | 2021-04-06 18:49:19 | prelected | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 152 | 2021-03-13 14:44:32 | prelected | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 151 | 2021-02-14 16:24:05 | prelected | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 150 | 2021-01-26 00:32:01 | prelected | 1 | 81242 | 3 | 1.440 | 56418.1 |
| 149 | 2020-12-06 13:53:49 | prelected | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 148 | 2020-10-31 22:21:22 | prelected | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 147 | 2020-10-30 08:16:09 | prelected | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 146 | 2020-10-14 03:52:56 | prelected | 1 | 81242 | 3 | 1.450 | 56029.0 |
| 145 | 2020-08-31 10:06:59 | prelected | 1 | 81242 | 3 | 1.310 | 62016.8 |
| 144 | 2020-06-21 20:07:14 | prelected | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 143 | 2020-05-26 15:19:21 | prelected | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 142 | 2020-03-29 20:25:35 | prelected | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 141 | 2020-03-28 18:56:40 | prelected | 1 | 81242 | 3 | 1.643 | 49447.4 |
| 140 | 2020-03-26 17:51:41 | prelected | 1 | 81242 | 3 | 1.953 | 41598.6 |
| 139 | 2020-03-23 07:34:10 | prelected | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 138 | 2020-03-20 11:30:18 | prelected | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 137 | 2020-02-28 18:05:58 | prelected | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 136 | 2020-02-23 12:39:16 | prelected | 1 | 81242 | 3 | 3.266 | 24875.1 |
| 135 | 2020-02-23 10:22:03 | prelected | 1 | 81242 | 3 | 1.656 | 49059.2 |
| 134 | 2020-02-21 02:35:19 | prelected | 1 | 81242 | 3 | 1.550 | 52414.2 |
| 133 | 2020-02-14 09:03:32 | prelected | 1 | 81242 | 3 | 3.360 | 24179.2 |
| 132 | 2020-02-12 12:00:14 | prelected | 1 | 81242 | 3 | 3.626 | 22405.4 |
| 131 | 2020-02-05 01:49:07 | prelected | 1 | 81242 | 3 | 2.643 | 30738.6 |
| 130 | 2020-02-04 16:22:40 | prelected | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 129 | 2020-02-03 17:00:01 | prelected | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 128 | 2020-01-28 18:47:50 | prelected | 1 | 81242 | 3 | 1.593 | 50999.4 |
| 127 | 2020-01-24 07:17:08 | prelected | 1 | 81242 | 3 | 3.486 | 23305.2 |
| 126 | 2020-01-22 18:00:32 | prelected | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 125 | 2020-01-22 16:17:51 | prelected | 1 | 81242 | 3 | 3.216 | 25261.8 |
| 124 | 2020-01-16 11:28:27 | prelected | 1 | 81242 | 3 | 3.186 | 25499.7 |
| 123 | 2020-01-14 04:01:31 | prelected | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 122 | 2020-01-02 20:12:20 | prelected | 1 | 81242 | 3 | 2.376 | 34192.8 |
| 121 | 2019-12-31 05:04:56 | prelected | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 120 | 2019-11-24 13:50:37 | prelected | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 119 | 2019-08-25 19:13:13 | prelected | 1 | 81242 | 3 | 1.240 | 65517.7 |
| 118 | 2019-07-21 14:39:33 | prelected | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 117 | 2019-05-26 02:54:39 | prelected | 1 | 81242 | 3 | 1.270 | 63970.1 |
| 116 | 2019-02-16 20:51:45 | prelected | 1 | 81242 | 3 | 1.293 | 62832.2 |
| 115 | 2018-11-09 06:35:43 | prelected | 1 | 81242 | 3 | 1.366 | 59474.4 |
| 114 | 2018-10-28 09:34:39 | prelected | 1 | 81242 | 3 | 1.223 | 66428.5 |
| 113 | 2018-09-05 10:32:24 | prelected | 1 | 81242 | 3 | 1.363 | 59605.3 |
| 112 | 2018-08-31 04:17:38 | prelected | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 111 | 2018-08-14 09:50:40 | prelected | 1 | 81242 | 3 | 1.356 | 59913.0 |
| 110 | 2018-08-08 11:39:36 | prelected | 1 | 81242 | 3 | 1.586 | 51224.5 |
| 109 | 2018-07-18 09:22:08 | prelected | 1 | 81242 | 3 | 1.306 | 62206.7 |
| 108 | 2018-06-23 22:00:12 | prelected | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 107 | 2018-06-23 19:52:22 | prelected | 1 | 81242 | 3 | 5.356 | 15168.4 |
| 106 | 2018-06-05 00:54:41 | prelected | 1 | 81242 | 3 | 1.260 | 64477.8 |
| 105 | 2018-05-08 03:24:14 | prelected | 1 | 81242 | 3 | 1.646 | 49357.2 |
| 104 | 2018-02-02 11:04:57 | prelected | 1 | 81242 | 3 | 2.376 | 34192.8 |
| 103 | 2018-01-03 17:55:50 | prelected | 1 | 81242 | 3 | 2.336 | 34778.3 |
| 102 | 2017-12-23 16:21:03 | prelected | 1 | 81242 | 3 | 2.343 | 34674.3 |