History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drillings"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 314 | 2024-05-04 00:35:36 | drillings | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 313 | 2024-04-30 18:31:33 | drillings | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 312 | 2024-04-05 02:30:03 | drillings | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 311 | 2024-04-04 19:30:31 | drillings | 3 | 148641 | 159 | 27.473 | 5410.4 |
| 310 | 2024-04-03 16:22:57 | drillings | 3 | 148641 | 159 | 22.563 | 6587.8 |
| 309 | 2024-04-03 16:23:00 | drillings | 2 | 121436 | 28 | 12.453 | 9751.5 |
| 308 | 2024-04-03 16:22:57 | drillings | 1 | 81242 | 3 | 1.686 | 48186.2 |
| 307 | 2024-03-31 11:18:55 | drillings | 1 | 81242 | 3 | 2.403 | 33808.6 |
| 306 | 2024-03-04 11:18:29 | drillings | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 305 | 2024-02-29 23:09:05 | drillings | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 304 | 2024-02-02 17:13:44 | drillings | 2 | 121436 | 28 | 3.670 | 33088.8 |
| 303 | 2024-02-02 17:11:28 | drillings | 3 | 148641 | 159 | 6.876 | 21617.4 |
| 302 | 2024-02-02 16:57:32 | drillings | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 301 | 2024-01-30 10:08:58 | drillings | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 300 | 2024-01-26 23:15:03 | drillings | 1 | 81242 | 3 | 1.450 | 56029.0 |
| 299 | 2024-01-10 01:07:00 | drillings | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 298 | 2024-01-03 12:22:56 | drillings | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 297 | 2023-11-26 14:50:14 | drillings | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 296 | 2023-11-23 14:11:40 | drillings | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 295 | 2023-11-19 10:19:12 | drillings | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 294 | 2023-11-09 23:16:36 | drillings | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 293 | 2023-11-03 20:51:08 | drillings | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 292 | 2023-10-11 21:42:17 | drillings | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 291 | 2023-09-07 05:22:24 | drillings | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 290 | 2023-09-05 12:38:22 | drillings | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 289 | 2023-06-07 11:44:33 | drillings | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 288 | 2023-05-17 23:21:04 | drillings | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 287 | 2023-03-28 22:58:15 | drillings | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 286 | 2023-02-06 03:31:06 | drillings | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 285 | 2023-01-28 16:21:10 | drillings | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 284 | 2023-01-11 16:37:25 | drillings | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 283 | 2022-12-20 20:05:23 | drillings | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 282 | 2022-11-11 03:15:07 | drillings | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 281 | 2022-10-23 13:31:52 | drillings | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 280 | 2022-10-07 01:32:20 | drillings | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 279 | 2022-06-12 21:27:23 | drillings | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 278 | 2022-05-30 04:13:15 | drillings | 1 | 81242 | 3 | 1.216 | 66810.9 |
| 277 | 2022-05-26 23:30:49 | drillings | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 276 | 2022-02-18 08:14:09 | drillings | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 275 | 2022-01-28 23:58:42 | drillings | 1 | 81242 | 3 | 1.356 | 59913.0 |
| 274 | 2021-12-11 20:35:05 | drillings | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 273 | 2021-12-09 16:51:38 | drillings | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 272 | 2021-10-31 07:58:40 | drillings | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 271 | 2021-10-12 05:51:37 | drillings | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 270 | 2021-09-22 10:26:17 | drillings | 3 | 148641 | 159 | 14.390 | 10329.5 |
| 269 | 2021-08-12 13:21:12 | drillings | 3 | 148641 | 159 | 6.000 | 24773.5 |
| 268 | 2021-07-18 16:22:20 | drillings | 3 | 148641 | 159 | 8.393 | 17710.1 |
| 267 | 2021-07-11 00:16:15 | drillings | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 266 | 2021-05-30 23:26:58 | drillings | 1 | 81242 | 3 | 1.580 | 51419.0 |
| 265 | 2021-04-13 10:52:33 | drillings | 1 | 81242 | 3 | 1.356 | 59913.0 |
| 264 | 2021-04-07 02:44:43 | drillings | 1 | 81242 | 3 | 1.216 | 66810.9 |
| 263 | 2021-04-06 12:49:38 | drillings | 1 | 81242 | 3 | 1.346 | 60358.1 |
| 262 | 2021-04-02 22:37:31 | drillings | 1 | 81242 | 3 | 1.670 | 48647.9 |
| 261 | 2021-03-08 07:20:21 | drillings | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 260 | 2021-01-18 21:44:37 | drillings | 3 | 148641 | 159 | 6.216 | 23912.6 |
| 259 | 2020-12-21 22:25:59 | drillings | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 258 | 2020-11-07 15:30:24 | drillings | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 257 | 2020-10-30 12:07:51 | drillings | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 256 | 2020-10-30 07:48:19 | drillings | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 255 | 2020-09-21 18:01:31 | drillings | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 254 | 2020-08-22 06:28:04 | drillings | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 253 | 2020-06-05 03:40:02 | drillings | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 252 | 2020-04-16 21:54:29 | drillings | 3 | 148641 | 159 | 6.093 | 24395.4 |
| 251 | 2020-03-26 21:41:03 | drillings | 3 | 148641 | 159 | 6.453 | 23034.4 |
| 250 | 2020-03-26 01:13:24 | drillings | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 249 | 2020-03-03 15:16:35 | drillings | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 248 | 2020-03-01 16:45:43 | drillings | 3 | 148641 | 159 | 8.076 | 18405.3 |
| 247 | 2020-03-01 15:25:16 | drillings | 3 | 148641 | 159 | 7.720 | 19254.0 |
| 246 | 2020-03-01 05:34:47 | drillings | 3 | 148641 | 159 | 7.733 | 19221.6 |
| 245 | 2020-02-29 17:54:29 | drillings | 1 | 81242 | 3 | 1.533 | 52995.4 |
| 244 | 2020-02-28 17:17:31 | drillings | 3 | 148641 | 159 | 7.703 | 19296.5 |
| 243 | 2020-02-25 10:30:46 | drillings | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 242 | 2020-02-23 09:59:54 | drillings | 3 | 148641 | 159 | 8.876 | 16746.4 |
| 241 | 2020-02-20 07:28:16 | drillings | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 240 | 2020-02-17 23:25:53 | drillings | 1 | 81242 | 3 | 4.326 | 18779.9 |
| 239 | 2020-02-17 20:33:06 | drillings | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 238 | 2020-02-17 16:29:32 | drillings | 3 | 148641 | 159 | 12.110 | 12274.2 |
| 237 | 2020-02-11 23:53:02 | drillings | 3 | 148641 | 159 | 13.596 | 10932.7 |
| 236 | 2020-02-04 01:30:23 | drillings | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 235 | 2020-02-03 20:35:09 | drillings | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 234 | 2020-01-25 14:04:41 | drillings | 3 | 148641 | 159 | 8.330 | 17844.1 |
| 233 | 2020-01-25 09:14:36 | drillings | 3 | 148641 | 159 | 12.140 | 12243.9 |
| 232 | 2020-01-25 09:05:05 | drillings | 2 | 121436 | 28 | 8.686 | 13980.7 |
| 231 | 2020-01-25 05:09:41 | drillings | 1 | 81242 | 3 | 2.783 | 29192.2 |
| 230 | 2020-01-24 03:20:46 | drillings | 1 | 81242 | 3 | 2.390 | 33992.5 |
| 229 | 2020-01-23 23:03:36 | drillings | 1 | 81242 | 3 | 1.716 | 47343.8 |
| 228 | 2020-01-17 03:36:51 | drillings | 3 | 148641 | 159 | 12.046 | 12339.4 |
| 227 | 2020-01-16 17:08:33 | drillings | 1 | 81242 | 3 | 3.153 | 25766.6 |
| 226 | 2020-01-16 15:45:48 | drillings | 3 | 148641 | 159 | 15.940 | 9325.0 |
| 225 | 2020-01-16 11:22:03 | drillings | 3 | 148641 | 159 | 12.686 | 11716.9 |
| 224 | 2020-01-11 22:36:01 | drillings | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 223 | 2020-01-02 10:26:42 | drillings | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 222 | 2019-12-30 08:05:55 | drillings | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 221 | 2019-12-12 17:17:30 | drillings | 3 | 148641 | 159 | 6.250 | 23782.6 |
| 220 | 2019-11-30 16:02:26 | drillings | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 219 | 2019-10-28 18:43:02 | drillings | 3 | 148641 | 159 | 6.250 | 23782.6 |
| 218 | 2019-10-28 18:42:57 | drillings | 2 | 121436 | 28 | 3.143 | 38637.0 |
| 217 | 2019-10-28 18:42:54 | drillings | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 216 | 2019-09-01 06:29:20 | drillings | 1 | 81242 | 3 | 1.286 | 63174.2 |
| 215 | 2019-06-26 15:52:28 | drillings | 1 | 81242 | 3 | 1.200 | 67701.7 |