History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"vanning"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 276 | 2024-04-21 13:40:20 | vanning | 1 | 69583 | 8 | 3.123 | 22280.8 |
| 275 | 2024-04-21 13:39:09 | vanning | 1 | 69583 | 8 | 2.470 | 28171.3 |
| 274 | 2024-01-21 15:08:28 | vanning | 1 | 69583 | 8 | 1.170 | 59472.6 |
| 273 | 2023-12-31 20:03:23 | vanning | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 272 | 2023-12-15 22:37:59 | vanning | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 271 | 2023-12-07 07:09:12 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 270 | 2023-12-07 07:09:10 | vanning | 1 | 69583 | 8 | 1.123 | 61961.7 |
| 269 | 2023-12-03 06:22:11 | vanning | 1 | 69583 | 8 | 2.330 | 29863.9 |
| 268 | 2023-11-10 23:46:55 | vanning | 1 | 69583 | 8 | 1.296 | 53690.6 |
| 267 | 2023-11-03 05:26:56 | vanning | 1 | 69583 | 8 | 1.170 | 59472.6 |
| 266 | 2023-10-21 14:46:00 | vanning | 1 | 69583 | 8 | 1.170 | 59472.6 |
| 265 | 2023-10-14 01:50:10 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 264 | 2023-10-06 21:55:07 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 263 | 2023-09-29 14:59:05 | vanning | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 262 | 2023-09-21 07:25:46 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 261 | 2023-08-17 00:41:52 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 260 | 2023-06-13 17:10:40 | vanning | 1 | 69583 | 8 | 1.356 | 51314.9 |
| 259 | 2023-05-17 01:49:00 | vanning | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 258 | 2023-03-12 20:03:48 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 257 | 2023-02-08 14:23:05 | vanning | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 256 | 2023-01-02 05:01:04 | vanning | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 255 | 2022-10-07 10:43:43 | vanning | 1 | 69583 | 8 | 1.050 | 66269.5 |
| 254 | 2022-10-03 21:36:57 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 253 | 2022-09-26 10:10:36 | vanning | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 252 | 2022-05-30 12:59:29 | vanning | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 251 | 2022-05-13 17:06:27 | vanning | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 250 | 2022-02-01 17:10:16 | vanning | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 249 | 2022-01-29 08:49:02 | vanning | 1 | 69583 | 8 | 1.033 | 67360.1 |
| 248 | 2021-11-23 15:00:50 | vanning | 1 | 69583 | 8 | 1.546 | 45008.4 |
| 247 | 2021-11-13 00:48:54 | vanning | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 246 | 2021-10-12 14:26:58 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 245 | 2021-10-09 08:29:08 | vanning | 1 | 69583 | 8 | 1.050 | 66269.5 |
| 244 | 2021-09-18 04:25:42 | vanning | 1 | 69583 | 8 | 1.050 | 66269.5 |
| 243 | 2021-07-11 11:46:17 | vanning | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 242 | 2021-06-07 15:33:44 | vanning | 1 | 69583 | 8 | 1.206 | 57697.3 |
| 241 | 2021-05-07 09:14:36 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 240 | 2021-04-07 13:22:18 | vanning | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 239 | 2021-04-03 09:48:20 | vanning | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 238 | 2020-12-14 19:40:32 | vanning | 1 | 69583 | 8 | 1.110 | 62687.4 |
| 237 | 2020-11-12 06:03:08 | vanning | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 236 | 2020-11-09 15:41:11 | vanning | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 235 | 2020-10-14 17:29:56 | vanning | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 234 | 2020-10-13 07:32:12 | vanning | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 233 | 2020-09-04 12:25:05 | vanning | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 232 | 2020-07-23 14:44:39 | vanning | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 231 | 2020-06-18 12:27:51 | vanning | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 230 | 2020-05-27 05:27:31 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 229 | 2020-03-24 01:35:15 | vanning | 1 | 69583 | 8 | 1.296 | 53690.6 |
| 228 | 2020-03-22 02:21:28 | vanning | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 227 | 2020-03-16 13:59:21 | vanning | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 226 | 2020-02-23 09:24:49 | vanning | 1 | 69583 | 8 | 1.750 | 39761.7 |
| 225 | 2020-02-22 19:43:20 | vanning | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 224 | 2020-02-21 01:34:54 | vanning | 1 | 69583 | 8 | 2.470 | 28171.3 |
| 223 | 2020-02-13 01:37:10 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 222 | 2020-02-10 18:22:00 | vanning | 1 | 69583 | 8 | 1.296 | 53690.6 |
| 221 | 2020-02-07 17:10:10 | vanning | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 220 | 2020-02-02 23:40:42 | vanning | 1 | 69583 | 8 | 1.576 | 44151.6 |
| 219 | 2020-01-27 14:54:44 | vanning | 1 | 69583 | 8 | 2.076 | 33517.8 |
| 218 | 2020-01-27 11:21:03 | vanning | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 217 | 2020-01-21 00:36:30 | vanning | 1 | 69583 | 8 | 4.000 | 17395.8 |
| 216 | 2020-01-19 21:38:05 | vanning | 1 | 69583 | 8 | 1.313 | 52995.4 |
| 215 | 2020-01-15 16:43:16 | vanning | 1 | 69583 | 8 | 2.890 | 24077.2 |
| 214 | 2020-01-09 20:24:21 | vanning | 1 | 69583 | 8 | 2.563 | 27149.0 |
| 213 | 2020-01-07 13:32:54 | vanning | 1 | 69583 | 8 | 1.280 | 54361.7 |
| 212 | 2020-01-04 21:14:46 | vanning | 1 | 69583 | 8 | 1.296 | 53690.6 |
| 211 | 2019-12-31 02:40:27 | vanning | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 210 | 2019-12-30 11:52:36 | vanning | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 209 | 2019-11-22 03:43:29 | vanning | 1 | 69583 | 8 | 1.126 | 61796.6 |
| 208 | 2019-08-20 05:21:36 | vanning | 1 | 69583 | 8 | 1.090 | 63837.6 |
| 207 | 2019-05-17 08:38:07 | vanning | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 206 | 2019-03-06 01:52:20 | vanning | 1 | 69583 | 8 | 1.240 | 56115.3 |
| 205 | 2019-03-01 08:07:16 | vanning | 1 | 69583 | 8 | 1.053 | 66080.7 |
| 204 | 2019-02-01 16:14:17 | vanning | 1 | 69583 | 8 | 1.033 | 67360.1 |
| 203 | 2019-01-13 07:41:03 | vanning | 1 | 69583 | 8 | 1.023 | 68018.6 |
| 202 | 2019-01-09 18:09:49 | vanning | 1 | 69583 | 8 | 1.043 | 66714.3 |
| 201 | 2019-01-03 20:28:56 | vanning | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 200 | 2019-01-01 21:23:49 | vanning | 1 | 69583 | 8 | 1.026 | 67819.7 |
| 199 | 2018-12-25 07:14:05 | vanning | 1 | 69583 | 8 | 1.013 | 68690.0 |
| 198 | 2018-12-15 20:15:48 | vanning | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 197 | 2018-11-17 09:45:22 | vanning | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 196 | 2018-11-15 09:54:39 | vanning | 1 | 69583 | 8 | 1.146 | 60718.2 |
| 195 | 2018-11-03 19:23:55 | vanning | 1 | 69583 | 8 | 1.056 | 65893.0 |
| 194 | 2018-11-01 19:34:29 | vanning | 1 | 69583 | 8 | 1.060 | 65644.3 |
| 193 | 2018-10-30 20:23:55 | vanning | 1 | 69583 | 8 | 1.200 | 57985.8 |
| 192 | 2018-10-24 23:10:20 | vanning | 1 | 69583 | 8 | 1.183 | 58819.1 |
| 191 | 2018-10-17 00:33:17 | vanning | 1 | 69583 | 8 | 1.020 | 68218.6 |
| 190 | 2018-09-01 16:11:35 | vanning | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 189 | 2018-08-18 06:49:27 | vanning | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 188 | 2018-08-16 17:50:27 | vanning | 1 | 69583 | 8 | 1.176 | 59169.2 |
| 187 | 2018-08-02 06:03:13 | vanning | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 186 | 2018-07-18 16:14:13 | vanning | 1 | 69583 | 8 | 1.340 | 51927.6 |
| 185 | 2018-05-17 05:50:35 | vanning | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 184 | 2018-05-06 20:41:33 | vanning | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 183 | 2018-04-27 12:20:19 | vanning | 1 | 69583 | 8 | 1.050 | 66269.5 |
| 182 | 2018-04-22 04:27:33 | vanning | 1 | 69583 | 8 | 1.050 | 66269.5 |
| 181 | 2018-04-17 15:55:27 | vanning | 1 | 69583 | 8 | 1.193 | 58326.1 |
| 180 | 2018-04-11 17:26:58 | vanning | 1 | 69583 | 8 | 1.066 | 65274.9 |
| 179 | 2018-02-20 22:42:39 | vanning | 1 | 69583 | 8 | 2.153 | 32319.1 |
| 178 | 2018-01-16 17:48:29 | vanning | 1 | 69583 | 8 | 1.883 | 36953.3 |
| 177 | 2018-01-14 15:41:31 | vanning | 1 | 69583 | 8 | 1.370 | 50790.5 |