History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tranche"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 395 | 2024-05-08 02:33:38 | tranche | 1 | 69583 | 3 | 2.263 | 30748.1 |
| 394 | 2024-05-01 09:07:35 | tranche | 2 | 107671 | 32 | 3.876 | 27778.9 |
| 393 | 2024-05-01 03:17:02 | tranche | 2 | 107671 | 32 | 2.906 | 37051.3 |
| 392 | 2024-04-05 17:52:21 | tranche | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 391 | 2024-02-01 21:09:20 | tranche | 2 | 107671 | 32 | 2.876 | 37437.8 |
| 390 | 2024-02-01 20:51:53 | tranche | 3 | 134027 | 252 | 6.906 | 19407.3 |
| 389 | 2024-02-01 05:49:28 | tranche | 2 | 107671 | 32 | 3.470 | 31029.1 |
| 388 | 2024-02-01 05:49:12 | tranche | 3 | 134027 | 252 | 7.046 | 19021.7 |
| 387 | 2024-01-31 23:30:12 | tranche | 1 | 69583 | 3 | 1.310 | 53116.8 |
| 386 | 2024-01-31 23:26:12 | tranche | 3 | 134027 | 252 | 7.623 | 17581.9 |
| 385 | 2024-01-31 23:26:15 | tranche | 2 | 107671 | 32 | 3.686 | 29210.8 |
| 384 | 2024-01-11 11:36:41 | tranche | 3 | 134027 | 252 | 6.266 | 21389.6 |
| 383 | 2024-01-11 11:36:36 | tranche | 2 | 107671 | 32 | 3.486 | 30886.7 |
| 382 | 2024-01-01 04:08:21 | tranche | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 381 | 2023-12-31 10:23:52 | tranche | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 380 | 2023-12-26 17:45:25 | tranche | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 379 | 2023-12-24 12:32:46 | tranche | 2 | 107671 | 32 | 2.890 | 37256.4 |
| 378 | 2023-12-24 09:13:13 | tranche | 1 | 69583 | 3 | 2.516 | 27656.2 |
| 377 | 2023-12-21 04:33:02 | tranche | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 376 | 2023-12-08 07:57:21 | tranche | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 375 | 2023-12-08 07:57:19 | tranche | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 374 | 2023-11-17 17:02:48 | tranche | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 373 | 2023-11-10 09:46:14 | tranche | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 372 | 2023-10-20 14:33:11 | tranche | 1 | 69583 | 3 | 2.890 | 24077.2 |
| 371 | 2023-10-14 19:15:46 | tranche | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 370 | 2023-10-01 00:21:17 | tranche | 2 | 107671 | 32 | 6.470 | 16641.6 |
| 369 | 2023-09-25 09:27:34 | tranche | 2 | 107671 | 32 | 3.406 | 31612.2 |
| 368 | 2023-09-23 23:56:35 | tranche | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 367 | 2023-08-10 09:04:29 | tranche | 1 | 69583 | 3 | 2.123 | 32775.8 |
| 366 | 2023-08-04 09:14:43 | tranche | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 365 | 2023-07-05 14:31:02 | tranche | 2 | 107671 | 32 | 3.263 | 32997.5 |
| 364 | 2023-05-09 22:53:00 | tranche | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 363 | 2023-04-04 19:58:42 | tranche | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 362 | 2023-03-29 05:12:20 | tranche | 2 | 107671 | 32 | 3.233 | 33303.7 |
| 361 | 2023-03-04 20:26:07 | tranche | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 360 | 2023-03-04 05:28:13 | tranche | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 359 | 2022-12-28 19:11:16 | tranche | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 358 | 2022-12-26 14:14:58 | tranche | 2 | 107671 | 32 | 2.830 | 38046.3 |
| 357 | 2022-12-20 00:22:01 | tranche | 3 | 134027 | 252 | 6.576 | 20381.2 |
| 356 | 2022-12-09 21:57:49 | tranche | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 355 | 2022-11-26 01:14:58 | tranche | 2 | 107671 | 32 | 3.296 | 32667.2 |
| 354 | 2022-11-02 18:48:42 | tranche | 3 | 134027 | 252 | 5.890 | 22755.0 |
| 353 | 2022-10-27 13:33:32 | tranche | 3 | 134027 | 252 | 6.720 | 19944.5 |
| 352 | 2022-10-26 08:12:42 | tranche | 2 | 107671 | 32 | 2.890 | 37256.4 |
| 351 | 2022-10-20 15:44:14 | tranche | 3 | 134027 | 252 | 5.766 | 23244.4 |
| 350 | 2022-10-05 19:31:49 | tranche | 3 | 134027 | 252 | 5.830 | 22989.2 |
| 349 | 2022-09-19 09:39:47 | tranche | 3 | 134027 | 252 | 5.813 | 23056.4 |
| 348 | 2022-09-15 10:21:20 | tranche | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 347 | 2022-08-29 08:08:52 | tranche | 2 | 107671 | 32 | 4.203 | 25617.7 |
| 346 | 2022-08-26 22:36:38 | tranche | 2 | 107671 | 32 | 2.876 | 37437.8 |
| 345 | 2022-08-22 12:28:24 | tranche | 3 | 134027 | 252 | 5.780 | 23188.1 |
| 344 | 2022-08-15 02:36:15 | tranche | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 343 | 2022-08-03 01:44:02 | tranche | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 342 | 2022-07-29 10:06:18 | tranche | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 341 | 2022-07-19 06:22:25 | tranche | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 340 | 2022-07-16 22:43:29 | tranche | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 339 | 2022-07-15 13:26:25 | tranche | 3 | 134027 | 252 | 5.766 | 23244.4 |
| 338 | 2022-04-03 20:40:32 | tranche | 2 | 107671 | 32 | 3.170 | 33965.6 |
| 337 | 2022-03-25 17:20:25 | tranche | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 336 | 2022-03-16 17:17:44 | tranche | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 335 | 2022-01-12 23:49:00 | tranche | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 334 | 2021-11-28 06:48:59 | tranche | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 333 | 2021-11-24 23:26:16 | tranche | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 332 | 2021-09-15 21:05:58 | tranche | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 331 | 2021-08-08 15:11:52 | tranche | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 330 | 2021-05-29 13:22:53 | tranche | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 329 | 2021-05-04 01:19:10 | tranche | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 328 | 2021-04-27 05:50:55 | tranche | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 327 | 2021-04-02 05:06:24 | tranche | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 326 | 2021-02-10 18:44:15 | tranche | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 325 | 2021-01-17 06:05:48 | tranche | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 324 | 2021-01-06 11:56:27 | tranche | 1 | 69583 | 3 | 1.090 | 63837.6 |
| 323 | 2020-11-22 13:22:39 | tranche | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 322 | 2020-10-08 22:34:55 | tranche | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 321 | 2020-09-30 15:35:02 | tranche | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 320 | 2020-09-17 20:10:06 | tranche | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 319 | 2020-09-11 18:34:54 | tranche | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 318 | 2020-09-01 16:10:23 | tranche | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 317 | 2020-08-14 08:06:55 | tranche | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 316 | 2020-08-01 01:56:54 | tranche | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 315 | 2020-07-22 08:24:44 | tranche | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 314 | 2020-07-20 19:51:22 | tranche | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 313 | 2020-06-17 15:00:09 | tranche | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 312 | 2020-05-15 08:31:23 | tranche | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 311 | 2020-03-29 15:16:46 | tranche | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 310 | 2020-03-29 05:36:38 | tranche | 1 | 69583 | 3 | 2.563 | 27149.0 |
| 309 | 2020-03-28 22:28:21 | tranche | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 308 | 2020-03-24 22:13:13 | tranche | 1 | 69583 | 3 | 1.410 | 49349.6 |
| 307 | 2020-03-24 01:02:50 | tranche | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 306 | 2020-03-20 21:49:44 | tranche | 1 | 69583 | 3 | 1.686 | 41271.1 |
| 305 | 2020-03-09 23:09:54 | tranche | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 304 | 2020-02-29 14:15:59 | tranche | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 303 | 2020-02-22 09:06:39 | tranche | 1 | 69583 | 3 | 1.423 | 48898.8 |
| 302 | 2020-02-16 12:47:39 | tranche | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 301 | 2020-02-12 09:57:05 | tranche | 1 | 69583 | 3 | 1.800 | 38657.2 |
| 300 | 2020-02-06 11:40:13 | tranche | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 299 | 2020-02-06 02:37:55 | tranche | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 298 | 2020-02-01 13:18:34 | tranche | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 297 | 2020-01-28 01:57:59 | tranche | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 296 | 2020-01-28 01:33:15 | tranche | 1 | 69583 | 3 | 2.483 | 28023.8 |