History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subbases"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 300 | 2024-05-13 23:28:27 | subbases | 3 | 146162 | 154 | 17.080 | 8557.5 |
| 299 | 2024-05-11 18:19:33 | subbases | 2 | 121059 | 18 | 6.186 | 19569.8 |
| 298 | 2024-05-11 18:17:33 | subbases | 3 | 146162 | 154 | 7.770 | 18811.1 |
| 297 | 2024-05-11 05:59:00 | subbases | 3 | 146162 | 154 | 8.330 | 17546.5 |
| 296 | 2024-05-11 05:59:01 | subbases | 2 | 121059 | 18 | 4.270 | 28351.1 |
| 295 | 2024-05-11 05:58:52 | subbases | 1 | 82945 | 5 | 5.000 | 16589.0 |
| 294 | 2024-05-11 05:58:38 | subbases | 2 | 121059 | 18 | 7.906 | 15312.3 |
| 293 | 2024-05-11 05:58:07 | subbases | 3 | 146162 | 154 | 15.390 | 9497.2 |
| 292 | 2024-05-09 20:35:43 | subbases | 3 | 146162 | 154 | 25.706 | 5685.9 |
| 291 | 2024-05-09 15:19:36 | subbases | 3 | 146162 | 154 | 14.300 | 10221.1 |
| 290 | 2024-05-09 15:19:41 | subbases | 2 | 121059 | 18 | 4.860 | 24909.3 |
| 289 | 2024-05-09 14:35:58 | subbases | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 288 | 2024-05-09 07:30:24 | subbases | 1 | 82945 | 5 | 4.610 | 17992.4 |
| 287 | 2024-04-26 08:27:39 | subbases | 3 | 146162 | 154 | 10.470 | 13960.1 |
| 286 | 2024-04-08 08:51:37 | subbases | 1 | 82945 | 5 | 6.703 | 12374.3 |
| 285 | 2024-04-07 21:31:15 | subbases | 3 | 146162 | 154 | 8.986 | 16265.5 |
| 284 | 2024-04-06 23:47:35 | subbases | 3 | 146162 | 154 | 29.800 | 4904.8 |
| 283 | 2024-04-06 06:55:32 | subbases | 3 | 146162 | 154 | 27.456 | 5323.5 |
| 282 | 2024-04-06 02:34:02 | subbases | 3 | 146162 | 154 | 24.313 | 6011.7 |
| 281 | 2024-04-05 06:50:48 | subbases | 3 | 146162 | 154 | 7.906 | 18487.5 |
| 280 | 2024-04-05 06:50:50 | subbases | 2 | 121059 | 18 | 4.080 | 29671.3 |
| 279 | 2024-04-05 06:50:45 | subbases | 1 | 82945 | 5 | 1.593 | 52068.4 |
| 278 | 2024-04-05 06:50:30 | subbases | 3 | 146162 | 154 | 12.220 | 11960.9 |
| 277 | 2024-04-05 06:50:31 | subbases | 2 | 121059 | 18 | 8.203 | 14757.9 |
| 276 | 2024-04-05 06:50:22 | subbases | 1 | 82945 | 5 | 3.060 | 27106.2 |
| 275 | 2024-03-30 14:54:16 | subbases | 1 | 82945 | 5 | 3.220 | 25759.3 |
| 274 | 2024-03-29 13:47:43 | subbases | 1 | 82945 | 5 | 1.643 | 50483.9 |
| 273 | 2024-03-07 11:31:42 | subbases | 1 | 82945 | 5 | 1.733 | 47862.1 |
| 272 | 2024-03-04 12:07:15 | subbases | 1 | 82945 | 5 | 4.703 | 17636.6 |
| 271 | 2024-02-04 09:38:18 | subbases | 1 | 82945 | 5 | 1.656 | 50087.6 |
| 270 | 2024-01-27 06:02:34 | subbases | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 269 | 2023-12-27 23:10:20 | subbases | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 268 | 2023-12-21 23:41:13 | subbases | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 267 | 2023-12-19 06:20:23 | subbases | 3 | 146162 | 154 | 6.096 | 23976.7 |
| 266 | 2023-11-20 20:48:35 | subbases | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 265 | 2023-11-05 22:18:08 | subbases | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 264 | 2023-10-19 11:09:25 | subbases | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 263 | 2023-10-09 11:46:53 | subbases | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 262 | 2023-09-25 19:33:17 | subbases | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 261 | 2023-09-19 06:47:09 | subbases | 3 | 146162 | 154 | 6.953 | 21021.4 |
| 260 | 2023-08-05 07:26:53 | subbases | 1 | 82945 | 5 | 1.440 | 57600.7 |
| 259 | 2023-06-25 16:36:38 | subbases | 3 | 146162 | 154 | 6.483 | 22545.4 |
| 258 | 2023-05-26 16:57:26 | subbases | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 257 | 2023-05-03 01:27:48 | subbases | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 256 | 2023-05-02 11:39:32 | subbases | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 255 | 2023-04-07 11:07:01 | subbases | 3 | 146162 | 154 | 7.830 | 18666.9 |
| 254 | 2023-04-02 14:09:27 | subbases | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 253 | 2023-03-18 13:49:33 | subbases | 3 | 146162 | 154 | 6.830 | 21400.0 |
| 252 | 2023-02-26 17:42:55 | subbases | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 251 | 2023-02-06 18:18:43 | subbases | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 250 | 2023-01-21 18:31:22 | subbases | 3 | 146162 | 154 | 6.000 | 24360.3 |
| 249 | 2023-01-17 16:34:47 | subbases | 3 | 146162 | 154 | 6.893 | 21204.4 |
| 248 | 2022-12-27 18:24:14 | subbases | 3 | 146162 | 154 | 6.266 | 23326.2 |
| 247 | 2022-12-24 22:05:12 | subbases | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 246 | 2022-12-20 18:14:19 | subbases | 3 | 146162 | 154 | 5.983 | 24429.6 |
| 245 | 2022-12-13 23:58:45 | subbases | 3 | 146162 | 154 | 6.500 | 22486.5 |
| 244 | 2022-12-13 15:05:26 | subbases | 3 | 146162 | 154 | 5.953 | 24552.7 |
| 243 | 2022-12-03 19:25:04 | subbases | 3 | 146162 | 154 | 6.346 | 23032.1 |
| 242 | 2022-11-08 03:47:58 | subbases | 3 | 146162 | 154 | 7.093 | 20606.5 |
| 241 | 2022-10-12 22:32:54 | subbases | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 240 | 2022-09-12 13:28:15 | subbases | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 239 | 2022-08-17 19:31:07 | subbases | 3 | 146162 | 154 | 6.750 | 21653.6 |
| 238 | 2022-07-14 22:03:41 | subbases | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 237 | 2022-06-11 11:15:32 | subbases | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 236 | 2022-06-07 20:54:06 | subbases | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 235 | 2022-03-17 01:22:45 | subbases | 1 | 82945 | 5 | 1.593 | 52068.4 |
| 234 | 2022-02-07 04:34:55 | subbases | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 233 | 2022-01-11 04:37:29 | subbases | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 232 | 2022-01-07 18:53:20 | subbases | 1 | 82945 | 5 | 1.640 | 50576.2 |
| 231 | 2021-12-23 20:22:31 | subbases | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 230 | 2021-12-23 12:26:34 | subbases | 1 | 82945 | 5 | 1.580 | 52496.8 |
| 229 | 2021-12-23 01:11:58 | subbases | 1 | 82945 | 5 | 3.093 | 26817.0 |
| 228 | 2021-12-22 16:48:02 | subbases | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 227 | 2021-12-22 07:01:25 | subbases | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 226 | 2021-12-21 21:13:28 | subbases | 1 | 82945 | 5 | 1.466 | 56579.1 |
| 225 | 2021-12-21 12:01:36 | subbases | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 224 | 2021-12-20 21:53:25 | subbases | 1 | 82945 | 5 | 1.610 | 51518.6 |
| 223 | 2021-12-20 14:32:43 | subbases | 1 | 82945 | 5 | 1.593 | 52068.4 |
| 222 | 2021-12-20 08:26:07 | subbases | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 221 | 2021-12-19 19:17:33 | subbases | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 220 | 2021-12-08 11:08:12 | subbases | 1 | 82945 | 5 | 1.560 | 53169.9 |
| 219 | 2021-11-22 12:13:33 | subbases | 1 | 82945 | 5 | 2.970 | 27927.6 |
| 218 | 2021-11-21 21:06:56 | subbases | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 217 | 2021-11-14 13:59:27 | subbases | 1 | 82945 | 5 | 1.610 | 51518.6 |
| 216 | 2021-11-10 19:01:27 | subbases | 1 | 82945 | 5 | 1.686 | 49196.3 |
| 215 | 2021-11-10 06:42:59 | subbases | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 214 | 2021-11-09 21:50:48 | subbases | 1 | 82945 | 5 | 1.610 | 51518.6 |
| 213 | 2021-11-09 10:06:50 | subbases | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 212 | 2021-11-08 14:08:59 | subbases | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 211 | 2021-11-08 04:07:09 | subbases | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 210 | 2021-10-22 09:18:28 | subbases | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 209 | 2021-10-21 21:26:53 | subbases | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 208 | 2021-10-21 02:03:03 | subbases | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 207 | 2021-10-14 05:24:11 | subbases | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 206 | 2021-10-10 22:59:39 | subbases | 1 | 82945 | 5 | 1.503 | 55186.3 |
| 205 | 2021-09-24 00:58:33 | subbases | 2 | 121059 | 18 | 3.236 | 37410.1 |
| 204 | 2021-09-23 20:34:49 | subbases | 3 | 146162 | 154 | 6.813 | 21453.4 |
| 203 | 2021-09-23 06:55:19 | subbases | 3 | 146162 | 154 | 7.296 | 20033.2 |
| 202 | 2021-09-23 00:48:58 | subbases | 2 | 121059 | 18 | 3.126 | 38726.5 |
| 201 | 2021-09-18 19:08:31 | subbases | 1 | 82945 | 5 | 1.546 | 53651.4 |