History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crankier"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 308 | 2024-04-30 21:16:05 | crankier | 1 | 82945 | 3 | 1.640 | 50576.2 |
| 307 | 2024-04-18 01:13:54 | crankier | 1 | 82945 | 3 | 3.140 | 26415.6 |
| 306 | 2024-04-13 15:56:40 | crankier | 1 | 82945 | 3 | 3.030 | 27374.6 |
| 305 | 2024-04-05 19:41:35 | crankier | 3 | 146162 | 316 | 20.096 | 7273.2 |
| 304 | 2024-04-05 07:11:07 | crankier | 1 | 82945 | 3 | 3.656 | 22687.4 |
| 303 | 2024-04-03 10:40:58 | crankier | 3 | 146162 | 316 | 25.580 | 5713.9 |
| 302 | 2024-04-03 10:41:01 | crankier | 2 | 121059 | 43 | 13.563 | 8925.7 |
| 301 | 2024-04-03 10:39:00 | crankier | 1 | 82945 | 3 | 3.156 | 26281.7 |
| 300 | 2024-03-31 09:11:53 | crankier | 2 | 121059 | 43 | 7.720 | 15681.2 |
| 299 | 2024-03-31 01:10:36 | crankier | 2 | 121059 | 43 | 6.093 | 19868.5 |
| 298 | 2024-03-30 19:46:38 | crankier | 3 | 146162 | 316 | 43.160 | 3386.5 |
| 297 | 2024-03-29 22:50:18 | crankier | 2 | 121059 | 43 | 13.533 | 8945.5 |
| 296 | 2024-03-29 12:36:14 | crankier | 2 | 121059 | 43 | 11.343 | 10672.6 |
| 295 | 2024-03-29 12:36:12 | crankier | 3 | 146162 | 316 | 11.190 | 13061.8 |
| 294 | 2024-03-29 12:36:04 | crankier | 1 | 82945 | 3 | 3.313 | 25036.2 |
| 293 | 2024-03-28 07:36:12 | crankier | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 292 | 2024-03-07 23:21:38 | crankier | 1 | 82945 | 3 | 2.920 | 28405.8 |
| 291 | 2024-03-06 14:21:14 | crankier | 2 | 121059 | 43 | 8.690 | 13930.8 |
| 290 | 2024-03-06 13:45:45 | crankier | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 289 | 2024-03-06 13:45:22 | crankier | 3 | 146162 | 316 | 7.250 | 20160.3 |
| 288 | 2024-03-04 08:53:07 | crankier | 3 | 146162 | 316 | 14.440 | 10122.0 |
| 287 | 2024-03-04 08:53:04 | crankier | 2 | 121059 | 43 | 6.283 | 19267.7 |
| 286 | 2024-03-04 06:50:48 | crankier | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 285 | 2024-03-01 13:26:36 | crankier | 3 | 146162 | 316 | 25.843 | 5655.8 |
| 284 | 2024-02-29 17:40:34 | crankier | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 283 | 2024-02-28 09:14:00 | crankier | 3 | 146162 | 316 | 17.250 | 8473.2 |
| 282 | 2024-02-28 04:27:06 | crankier | 3 | 146162 | 316 | 13.063 | 11189.0 |
| 281 | 2024-02-28 04:27:01 | crankier | 2 | 121059 | 43 | 7.640 | 15845.4 |
| 280 | 2024-02-28 04:23:00 | crankier | 3 | 146162 | 316 | 16.783 | 8708.9 |
| 279 | 2024-02-28 04:22:59 | crankier | 2 | 121059 | 43 | 12.640 | 9577.5 |
| 278 | 2024-02-28 04:22:54 | crankier | 1 | 82945 | 3 | 1.796 | 46183.2 |
| 277 | 2024-02-20 19:14:12 | crankier | 1 | 82945 | 3 | 1.640 | 50576.2 |
| 276 | 2023-12-15 09:39:17 | crankier | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 275 | 2023-12-05 03:23:24 | crankier | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 274 | 2023-11-23 14:48:19 | crankier | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 273 | 2023-11-06 12:34:50 | crankier | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 272 | 2023-11-03 21:01:10 | crankier | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 271 | 2023-10-31 02:24:03 | crankier | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 270 | 2023-10-26 04:41:18 | crankier | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 269 | 2023-10-06 17:49:06 | crankier | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 268 | 2023-09-18 23:37:38 | crankier | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 267 | 2023-09-14 23:51:04 | crankier | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 266 | 2023-07-01 15:27:02 | crankier | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 265 | 2023-06-24 14:04:01 | crankier | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 264 | 2023-06-21 04:18:03 | crankier | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 263 | 2023-04-08 04:23:43 | crankier | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 262 | 2023-03-02 09:25:06 | crankier | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 261 | 2023-02-26 19:18:23 | crankier | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 260 | 2023-01-20 22:10:34 | crankier | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 259 | 2022-11-18 02:04:53 | crankier | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 258 | 2022-11-09 22:59:28 | crankier | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 257 | 2022-07-20 17:23:45 | crankier | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 256 | 2022-07-17 00:05:23 | crankier | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 255 | 2022-07-09 19:18:11 | crankier | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 254 | 2022-03-19 17:05:51 | crankier | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 253 | 2022-03-12 08:55:31 | crankier | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 252 | 2022-02-07 00:57:12 | crankier | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 251 | 2021-12-20 14:40:30 | crankier | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 250 | 2021-12-18 11:45:18 | crankier | 1 | 82945 | 3 | 1.403 | 59119.7 |
| 249 | 2021-12-02 14:25:15 | crankier | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 248 | 2021-10-27 13:57:29 | crankier | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 247 | 2021-09-15 19:52:59 | crankier | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 246 | 2021-08-26 05:03:17 | crankier | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 245 | 2021-08-24 21:25:25 | crankier | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 244 | 2021-05-25 10:41:15 | crankier | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 243 | 2021-05-02 07:13:26 | crankier | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 242 | 2021-02-19 22:12:51 | crankier | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 241 | 2021-02-09 07:29:05 | crankier | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 240 | 2020-11-16 08:04:43 | crankier | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 239 | 2020-11-06 02:32:18 | crankier | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 238 | 2020-10-30 15:36:41 | crankier | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 237 | 2020-10-02 02:29:37 | crankier | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 236 | 2020-09-01 21:29:15 | crankier | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 235 | 2020-08-29 11:49:35 | crankier | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 234 | 2020-08-29 02:25:09 | crankier | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 233 | 2020-08-20 00:48:49 | crankier | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 232 | 2020-08-19 23:48:31 | crankier | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 231 | 2020-08-14 02:36:01 | crankier | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 230 | 2020-08-06 03:27:36 | crankier | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 229 | 2020-07-24 04:08:10 | crankier | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 228 | 2020-05-09 21:49:37 | crankier | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 227 | 2020-03-22 17:15:26 | crankier | 1 | 82945 | 3 | 2.876 | 28840.4 |
| 226 | 2020-03-06 03:36:55 | crankier | 1 | 82945 | 3 | 3.266 | 25396.5 |
| 225 | 2020-02-27 05:50:43 | crankier | 1 | 82945 | 3 | 2.906 | 28542.7 |
| 224 | 2020-02-22 17:02:20 | crankier | 1 | 82945 | 3 | 2.563 | 32362.5 |
| 223 | 2020-02-14 12:19:03 | crankier | 1 | 82945 | 3 | 1.610 | 51518.6 |
| 222 | 2020-02-11 19:26:52 | crankier | 1 | 82945 | 3 | 2.576 | 32199.1 |
| 221 | 2020-02-07 08:23:07 | crankier | 1 | 82945 | 3 | 3.093 | 26817.0 |
| 220 | 2020-02-07 01:45:10 | crankier | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 219 | 2020-02-07 00:20:50 | crankier | 1 | 82945 | 3 | 1.983 | 41828.0 |
| 218 | 2020-02-02 02:42:43 | crankier | 1 | 82945 | 3 | 2.623 | 31622.2 |
| 217 | 2020-02-01 08:15:41 | crankier | 1 | 82945 | 3 | 3.296 | 25165.4 |
| 216 | 2020-01-22 17:14:13 | crankier | 1 | 82945 | 3 | 1.690 | 49079.9 |
| 215 | 2020-01-20 20:14:37 | crankier | 1 | 82945 | 3 | 1.720 | 48223.8 |
| 214 | 2020-01-17 23:17:35 | crankier | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 213 | 2020-01-10 20:14:13 | crankier | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 212 | 2020-01-07 01:24:18 | crankier | 1 | 82945 | 3 | 3.530 | 23497.2 |
| 211 | 2020-01-01 18:58:43 | crankier | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 210 | 2020-01-01 18:26:58 | crankier | 1 | 82945 | 3 | 1.766 | 46967.7 |
| 209 | 2019-11-06 19:41:43 | crankier | 1 | 82945 | 3 | 1.296 | 64000.8 |