History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stranger"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 325 | 2024-03-29 23:58:02 | stranger | 1 | 82945 | 9 | 3.640 | 22787.1 |
| 324 | 2024-03-02 11:53:06 | stranger | 3 | 146162 | 310 | 26.223 | 5573.8 |
| 323 | 2024-02-26 09:26:29 | stranger | 3 | 146162 | 310 | 7.533 | 19402.9 |
| 322 | 2024-02-22 12:30:00 | stranger | 2 | 121059 | 46 | 8.500 | 14242.2 |
| 321 | 2024-02-22 03:56:59 | stranger | 3 | 146162 | 310 | 18.563 | 7873.8 |
| 320 | 2024-02-21 11:39:35 | stranger | 3 | 146162 | 310 | 21.093 | 6929.4 |
| 319 | 2024-02-21 11:39:35 | stranger | 2 | 121059 | 46 | 13.156 | 9201.8 |
| 318 | 2024-02-21 04:50:37 | stranger | 1 | 82945 | 9 | 2.080 | 39877.4 |
| 317 | 2024-02-15 00:33:00 | stranger | 3 | 146162 | 310 | 7.326 | 19951.1 |
| 316 | 2024-01-31 00:16:34 | stranger | 1 | 82945 | 9 | 1.466 | 56579.1 |
| 315 | 2024-01-26 06:04:45 | stranger | 3 | 146162 | 310 | 8.983 | 16271.0 |
| 314 | 2024-01-15 13:45:25 | stranger | 3 | 146162 | 310 | 9.030 | 16186.3 |
| 313 | 2024-01-09 18:26:20 | stranger | 3 | 146162 | 310 | 8.343 | 17519.1 |
| 312 | 2024-01-01 08:14:49 | stranger | 1 | 82945 | 9 | 1.580 | 52496.8 |
| 311 | 2023-12-09 00:41:53 | stranger | 1 | 82945 | 9 | 1.436 | 57761.1 |
| 310 | 2023-12-08 04:48:17 | stranger | 1 | 82945 | 9 | 1.280 | 64800.8 |
| 309 | 2023-11-28 06:29:07 | stranger | 1 | 82945 | 9 | 1.313 | 63172.1 |
| 308 | 2023-11-25 11:28:03 | stranger | 1 | 82945 | 9 | 1.453 | 57085.3 |
| 307 | 2023-11-16 08:58:35 | stranger | 3 | 146162 | 310 | 7.736 | 18893.7 |
| 306 | 2023-11-10 01:19:40 | stranger | 1 | 82945 | 9 | 1.280 | 64800.8 |
| 305 | 2023-10-31 07:53:09 | stranger | 1 | 82945 | 9 | 1.343 | 61761.0 |
| 304 | 2023-09-19 18:19:15 | stranger | 1 | 82945 | 9 | 1.406 | 58993.6 |
| 303 | 2023-09-11 07:58:56 | stranger | 1 | 82945 | 9 | 1.263 | 65673.0 |
| 302 | 2023-08-26 18:55:51 | stranger | 1 | 82945 | 9 | 1.300 | 63803.8 |
| 301 | 2023-08-18 05:13:50 | stranger | 3 | 146162 | 310 | 6.423 | 22756.0 |
| 300 | 2023-06-23 03:02:40 | stranger | 1 | 82945 | 9 | 1.360 | 60989.0 |
| 299 | 2023-05-03 16:40:23 | stranger | 3 | 146162 | 310 | 6.313 | 23152.5 |
| 298 | 2023-04-28 11:32:09 | stranger | 1 | 82945 | 9 | 1.296 | 64000.8 |
| 297 | 2023-04-06 14:30:23 | stranger | 1 | 82945 | 9 | 1.453 | 57085.3 |
| 296 | 2023-03-30 10:34:08 | stranger | 3 | 146162 | 310 | 7.423 | 19690.4 |
| 295 | 2023-02-08 11:07:09 | stranger | 3 | 146162 | 310 | 6.750 | 21653.6 |
| 294 | 2023-01-21 06:54:44 | stranger | 1 | 82945 | 9 | 1.263 | 65673.0 |
| 293 | 2023-01-01 04:57:12 | stranger | 1 | 82945 | 9 | 1.390 | 59672.7 |
| 292 | 2022-11-20 05:56:21 | stranger | 3 | 146162 | 310 | 7.063 | 20694.0 |
| 291 | 2022-11-16 22:51:52 | stranger | 1 | 82945 | 9 | 1.326 | 62552.8 |
| 290 | 2022-09-01 18:57:03 | stranger | 3 | 146162 | 310 | 7.813 | 18707.5 |
| 289 | 2022-08-17 12:14:28 | stranger | 1 | 82945 | 9 | 1.283 | 64649.3 |
| 288 | 2022-07-29 04:30:16 | stranger | 1 | 82945 | 9 | 1.296 | 64000.8 |
| 287 | 2022-07-19 03:35:30 | stranger | 3 | 146162 | 310 | 6.533 | 22372.9 |
| 286 | 2022-07-19 03:35:07 | stranger | 2 | 121059 | 46 | 3.656 | 33112.4 |
| 285 | 2022-07-07 07:20:58 | stranger | 1 | 82945 | 9 | 1.280 | 64800.8 |
| 284 | 2022-07-02 21:39:16 | stranger | 1 | 82945 | 9 | 1.280 | 64800.8 |
| 283 | 2022-06-22 23:03:04 | stranger | 3 | 146162 | 310 | 6.610 | 22112.3 |
| 282 | 2022-04-03 03:18:01 | stranger | 1 | 82945 | 9 | 1.300 | 63803.8 |
| 281 | 2022-03-01 07:10:41 | stranger | 1 | 82945 | 9 | 1.360 | 60989.0 |
| 280 | 2022-02-24 23:05:53 | stranger | 1 | 82945 | 9 | 1.580 | 52496.8 |
| 279 | 2022-02-04 08:02:49 | stranger | 3 | 146162 | 310 | 6.516 | 22431.2 |
| 278 | 2022-02-02 05:44:35 | stranger | 3 | 146162 | 310 | 6.796 | 21507.1 |
| 277 | 2021-12-11 21:53:55 | stranger | 1 | 82945 | 9 | 1.500 | 55296.7 |
| 276 | 2021-11-29 18:11:32 | stranger | 1 | 82945 | 9 | 1.330 | 62364.7 |
| 275 | 2021-11-22 12:19:25 | stranger | 1 | 82945 | 9 | 1.376 | 60279.8 |
| 274 | 2021-11-21 21:12:58 | stranger | 1 | 82945 | 9 | 1.280 | 64800.8 |
| 273 | 2021-11-07 12:22:14 | stranger | 3 | 146162 | 310 | 7.813 | 18707.5 |
| 272 | 2021-10-23 06:41:20 | stranger | 1 | 82945 | 9 | 1.436 | 57761.1 |
| 271 | 2021-09-26 10:29:21 | stranger | 2 | 121059 | 46 | 3.686 | 32842.9 |
| 270 | 2021-09-25 21:52:01 | stranger | 2 | 121059 | 46 | 3.313 | 36540.6 |
| 269 | 2021-09-25 08:02:24 | stranger | 2 | 121059 | 46 | 4.076 | 29700.4 |
| 268 | 2021-09-24 19:41:37 | stranger | 3 | 146162 | 310 | 7.516 | 19446.8 |
| 267 | 2021-09-24 08:14:40 | stranger | 3 | 146162 | 310 | 10.220 | 14301.6 |
| 266 | 2021-09-20 17:20:25 | stranger | 1 | 82945 | 9 | 1.343 | 61761.0 |
| 265 | 2021-09-19 19:54:34 | stranger | 2 | 121059 | 46 | 3.530 | 34294.3 |
| 264 | 2021-09-19 19:51:38 | stranger | 1 | 82945 | 9 | 1.470 | 56425.2 |
| 263 | 2021-09-17 23:36:07 | stranger | 3 | 146162 | 310 | 6.470 | 22590.7 |
| 262 | 2021-09-15 13:34:22 | stranger | 1 | 82945 | 9 | 1.296 | 64000.8 |
| 261 | 2021-09-13 09:55:49 | stranger | 1 | 82945 | 9 | 1.296 | 64000.8 |
| 260 | 2021-09-07 21:09:14 | stranger | 3 | 146162 | 310 | 7.423 | 19690.4 |
| 259 | 2021-08-28 22:54:28 | stranger | 1 | 82945 | 9 | 1.486 | 55817.6 |
| 258 | 2021-08-10 02:40:14 | stranger | 1 | 82945 | 9 | 1.310 | 63316.8 |
| 257 | 2021-05-02 14:47:45 | stranger | 1 | 82945 | 9 | 1.533 | 54106.3 |
| 256 | 2021-01-16 19:17:32 | stranger | 1 | 82945 | 9 | 1.453 | 57085.3 |
| 255 | 2020-11-01 15:21:52 | stranger | 1 | 82945 | 9 | 1.470 | 56425.2 |
| 254 | 2020-10-30 14:19:58 | stranger | 1 | 82945 | 9 | 1.623 | 51106.0 |
| 253 | 2020-10-07 06:36:14 | stranger | 1 | 82945 | 9 | 1.453 | 57085.3 |
| 252 | 2020-07-22 05:38:12 | stranger | 1 | 82945 | 9 | 1.420 | 58412.0 |
| 251 | 2020-06-15 19:58:22 | stranger | 1 | 82945 | 9 | 1.296 | 64000.8 |
| 250 | 2020-04-19 18:54:49 | stranger | 1 | 82945 | 9 | 1.346 | 61623.3 |
| 249 | 2020-03-23 07:04:56 | stranger | 1 | 82945 | 9 | 1.546 | 53651.4 |
| 248 | 2020-03-11 04:52:59 | stranger | 1 | 82945 | 9 | 1.266 | 65517.4 |
| 247 | 2020-02-26 02:10:34 | stranger | 1 | 82945 | 9 | 1.563 | 53067.8 |
| 246 | 2020-02-22 18:56:53 | stranger | 1 | 82945 | 9 | 3.703 | 22399.4 |
| 245 | 2020-02-17 12:34:28 | stranger | 1 | 82945 | 9 | 1.640 | 50576.2 |
| 244 | 2020-02-10 10:13:47 | stranger | 1 | 82945 | 9 | 3.626 | 22875.1 |
| 243 | 2020-02-10 09:59:59 | stranger | 1 | 82945 | 9 | 1.906 | 43517.8 |
| 242 | 2020-02-07 23:03:59 | stranger | 1 | 82945 | 9 | 1.563 | 53067.8 |
| 241 | 2020-02-07 18:32:36 | stranger | 1 | 82945 | 9 | 4.703 | 17636.6 |
| 240 | 2020-02-05 01:44:37 | stranger | 1 | 82945 | 9 | 2.750 | 30161.8 |
| 239 | 2020-01-29 03:01:08 | stranger | 1 | 82945 | 9 | 5.030 | 16490.1 |
| 238 | 2020-01-26 18:19:06 | stranger | 1 | 82945 | 9 | 1.656 | 50087.6 |
| 237 | 2020-01-21 04:32:01 | stranger | 1 | 82945 | 9 | 1.640 | 50576.2 |
| 236 | 2020-01-20 20:01:41 | stranger | 1 | 82945 | 9 | 3.326 | 24938.4 |
| 235 | 2020-01-15 09:59:33 | stranger | 1 | 82945 | 9 | 1.483 | 55930.5 |
| 234 | 2020-01-10 05:36:36 | stranger | 1 | 82945 | 9 | 1.516 | 54713.1 |
| 233 | 2020-01-07 03:04:10 | stranger | 1 | 82945 | 9 | 1.656 | 50087.6 |
| 232 | 2019-12-31 11:37:49 | stranger | 1 | 82945 | 9 | 1.750 | 47397.1 |
| 231 | 2019-12-30 11:35:41 | stranger | 1 | 82945 | 9 | 1.576 | 52630.1 |
| 230 | 2019-12-08 06:23:01 | stranger | 1 | 82945 | 9 | 1.436 | 57761.1 |
| 229 | 2019-12-04 00:13:38 | stranger | 1 | 82945 | 9 | 1.280 | 64800.8 |
| 228 | 2019-10-21 05:33:45 | stranger | 1 | 82945 | 9 | 1.360 | 60989.0 |
| 227 | 2019-09-06 06:56:16 | stranger | 1 | 82945 | 9 | 1.213 | 68380.0 |
| 226 | 2019-06-17 06:29:10 | stranger | 1 | 82945 | 9 | 1.286 | 64498.4 |