History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"soldiers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 311 | 2024-04-25 18:10:32 | soldiers | 2 | 121059 | 28 | 4.360 | 27765.8 |
| 310 | 2024-04-25 17:55:44 | soldiers | 3 | 146162 | 302 | 7.686 | 19016.7 |
| 309 | 2024-04-25 03:47:32 | soldiers | 3 | 146162 | 302 | 27.000 | 5413.4 |
| 308 | 2024-04-24 03:29:55 | soldiers | 3 | 146162 | 302 | 14.876 | 9825.4 |
| 307 | 2024-04-19 00:02:58 | soldiers | 3 | 146162 | 302 | 27.046 | 5404.2 |
| 306 | 2024-04-18 23:56:50 | soldiers | 2 | 121059 | 28 | 10.420 | 11617.9 |
| 305 | 2024-04-18 21:39:14 | soldiers | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 304 | 2024-04-16 17:23:27 | soldiers | 3 | 146162 | 302 | 9.203 | 15882.0 |
| 303 | 2024-04-16 17:23:18 | soldiers | 2 | 121059 | 28 | 4.420 | 27388.9 |
| 302 | 2024-04-16 14:23:45 | soldiers | 1 | 82945 | 4 | 3.266 | 25396.5 |
| 301 | 2024-04-16 14:23:16 | soldiers | 2 | 121059 | 28 | 6.140 | 19716.4 |
| 300 | 2024-04-16 14:08:17 | soldiers | 1 | 82945 | 4 | 8.813 | 9411.7 |
| 299 | 2024-04-16 14:08:12 | soldiers | 2 | 121059 | 28 | 5.703 | 21227.2 |
| 298 | 2024-04-01 07:32:00 | soldiers | 1 | 82945 | 4 | 3.470 | 23903.5 |
| 297 | 2024-03-30 01:21:43 | soldiers | 1 | 82945 | 4 | 1.686 | 49196.3 |
| 296 | 2024-03-07 03:46:18 | soldiers | 2 | 121059 | 28 | 7.203 | 16806.7 |
| 295 | 2024-03-01 00:07:58 | soldiers | 1 | 82945 | 4 | 1.690 | 49079.9 |
| 294 | 2024-02-18 06:34:53 | soldiers | 1 | 82945 | 4 | 1.656 | 50087.6 |
| 293 | 2024-02-18 06:34:01 | soldiers | 1 | 82945 | 4 | 1.986 | 41764.9 |
| 292 | 2023-12-21 07:05:13 | soldiers | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 291 | 2023-12-03 06:26:59 | soldiers | 1 | 82945 | 4 | 1.420 | 58412.0 |
| 290 | 2023-11-22 15:58:54 | soldiers | 1 | 82945 | 4 | 1.593 | 52068.4 |
| 289 | 2023-11-05 15:32:00 | soldiers | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 288 | 2023-11-04 09:11:58 | soldiers | 1 | 82945 | 4 | 1.450 | 57203.4 |
| 287 | 2023-10-16 04:56:26 | soldiers | 1 | 82945 | 4 | 1.466 | 56579.1 |
| 286 | 2023-10-15 00:35:35 | soldiers | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 285 | 2023-10-12 14:06:06 | soldiers | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 284 | 2023-09-18 02:35:09 | soldiers | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 283 | 2023-06-02 11:58:07 | soldiers | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 282 | 2023-01-27 13:09:50 | soldiers | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 281 | 2022-12-14 08:37:44 | soldiers | 1 | 82945 | 4 | 1.483 | 55930.5 |
| 280 | 2022-09-18 00:15:09 | soldiers | 1 | 82945 | 4 | 1.330 | 62364.7 |
| 279 | 2022-09-10 22:22:13 | soldiers | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 278 | 2022-08-20 02:51:54 | soldiers | 1 | 82945 | 4 | 1.280 | 64800.8 |
| 277 | 2022-07-30 16:52:07 | soldiers | 1 | 82945 | 4 | 1.310 | 63316.8 |
| 276 | 2022-07-29 05:29:57 | soldiers | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 275 | 2022-07-18 01:35:49 | soldiers | 1 | 82945 | 4 | 1.423 | 58288.8 |
| 274 | 2022-07-04 07:18:56 | soldiers | 2 | 121059 | 28 | 3.173 | 38152.9 |
| 273 | 2022-07-03 06:12:26 | soldiers | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 272 | 2022-06-25 10:30:07 | soldiers | 1 | 82945 | 4 | 1.293 | 64149.3 |
| 271 | 2022-06-09 02:15:57 | soldiers | 1 | 82945 | 4 | 1.330 | 62364.7 |
| 270 | 2022-05-08 21:18:51 | soldiers | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 269 | 2022-04-18 13:47:56 | soldiers | 1 | 82945 | 4 | 1.423 | 58288.8 |
| 268 | 2022-01-14 07:34:20 | soldiers | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 267 | 2022-01-11 01:59:14 | soldiers | 1 | 82945 | 4 | 1.720 | 48223.8 |
| 266 | 2021-12-02 10:36:11 | soldiers | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 265 | 2021-12-01 11:49:57 | soldiers | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 264 | 2021-11-30 15:52:09 | soldiers | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 263 | 2021-11-29 11:46:26 | soldiers | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 262 | 2021-11-16 09:56:16 | soldiers | 1 | 82945 | 4 | 1.310 | 63316.8 |
| 261 | 2021-10-04 04:17:22 | soldiers | 1 | 82945 | 4 | 1.373 | 60411.5 |
| 260 | 2021-09-25 05:40:33 | soldiers | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 259 | 2021-09-21 08:38:25 | soldiers | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 258 | 2021-09-20 14:46:17 | soldiers | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 257 | 2021-09-13 22:12:58 | soldiers | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 256 | 2021-09-04 02:25:37 | soldiers | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 255 | 2021-08-19 16:34:34 | soldiers | 1 | 82945 | 4 | 1.423 | 58288.8 |
| 254 | 2021-06-22 04:56:00 | soldiers | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 253 | 2021-03-30 08:31:06 | soldiers | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 252 | 2021-03-19 23:04:51 | soldiers | 1 | 82945 | 4 | 1.623 | 51106.0 |
| 251 | 2021-03-04 03:29:10 | soldiers | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 250 | 2021-01-26 03:42:34 | soldiers | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 249 | 2020-12-17 01:34:58 | soldiers | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 248 | 2020-10-14 23:59:54 | soldiers | 1 | 82945 | 4 | 1.330 | 62364.7 |
| 247 | 2020-09-13 03:14:48 | soldiers | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 246 | 2020-08-30 10:20:57 | soldiers | 1 | 82945 | 4 | 1.330 | 62364.7 |
| 245 | 2020-06-08 13:51:06 | soldiers | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 244 | 2020-05-23 00:17:11 | soldiers | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 243 | 2020-03-22 12:14:29 | soldiers | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 242 | 2020-03-11 21:00:28 | soldiers | 1 | 82945 | 4 | 1.483 | 55930.5 |
| 241 | 2020-02-29 15:47:24 | soldiers | 1 | 82945 | 4 | 1.576 | 52630.1 |
| 240 | 2020-02-27 20:01:38 | soldiers | 1 | 82945 | 4 | 1.673 | 49578.6 |
| 239 | 2020-02-24 01:29:04 | soldiers | 1 | 82945 | 4 | 4.576 | 18126.1 |
| 238 | 2020-02-17 12:07:03 | soldiers | 1 | 82945 | 4 | 1.593 | 52068.4 |
| 237 | 2020-02-16 19:51:54 | soldiers | 1 | 82945 | 4 | 2.580 | 32149.2 |
| 236 | 2020-02-12 13:26:09 | soldiers | 1 | 82945 | 4 | 1.876 | 44213.8 |
| 235 | 2020-02-11 02:30:16 | soldiers | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 234 | 2020-02-02 00:26:17 | soldiers | 1 | 82945 | 4 | 1.533 | 54106.3 |
| 233 | 2020-02-01 13:06:23 | soldiers | 1 | 82945 | 4 | 3.233 | 25655.7 |
| 232 | 2020-01-28 02:22:26 | soldiers | 1 | 82945 | 4 | 1.580 | 52496.8 |
| 231 | 2020-01-21 19:10:59 | soldiers | 1 | 82945 | 4 | 2.313 | 35860.4 |
| 230 | 2020-01-20 11:40:26 | soldiers | 1 | 82945 | 4 | 3.250 | 25521.5 |
| 229 | 2020-01-18 14:48:09 | soldiers | 1 | 82945 | 4 | 1.483 | 55930.5 |
| 228 | 2020-01-07 00:24:52 | soldiers | 1 | 82945 | 4 | 2.076 | 39954.2 |
| 227 | 2020-01-04 13:20:28 | soldiers | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 226 | 2020-01-02 23:00:36 | soldiers | 1 | 82945 | 4 | 3.250 | 25521.5 |
| 225 | 2020-01-02 11:41:15 | soldiers | 1 | 82945 | 4 | 1.953 | 42470.6 |
| 224 | 2019-12-30 04:18:41 | soldiers | 1 | 82945 | 4 | 1.903 | 43586.4 |
| 223 | 2019-11-14 17:52:37 | soldiers | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 222 | 2019-11-10 20:48:25 | soldiers | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 221 | 2019-08-18 07:17:46 | soldiers | 1 | 82945 | 4 | 1.566 | 52966.2 |
| 220 | 2019-08-09 13:55:07 | soldiers | 1 | 82945 | 4 | 1.493 | 55555.9 |
| 219 | 2019-08-09 04:14:27 | soldiers | 1 | 82945 | 4 | 1.353 | 61304.5 |
| 218 | 2019-08-04 05:58:06 | soldiers | 1 | 82945 | 4 | 1.293 | 64149.3 |
| 217 | 2019-07-24 10:53:17 | soldiers | 1 | 82945 | 4 | 2.546 | 32578.6 |
| 216 | 2019-07-11 13:31:00 | soldiers | 1 | 82945 | 4 | 1.316 | 63028.1 |
| 215 | 2019-07-07 20:24:19 | soldiers | 1 | 82945 | 4 | 1.270 | 65311.0 |
| 214 | 2019-07-04 02:01:33 | soldiers | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 213 | 2019-06-30 21:50:22 | soldiers | 1 | 82945 | 4 | 1.293 | 64149.3 |
| 212 | 2019-06-28 11:49:46 | soldiers | 1 | 82945 | 4 | 1.370 | 60543.8 |