History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"provincial"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 367 | 2026-02-12 14:38:46 | provincial | 4 | 161450 | 53 | 14.296 | 11293.4 |
| 366 | 2026-02-09 13:08:42 | provincial | 4 | 161450 | 53 | 10.936 | 14763.2 |
| 365 | 2026-02-07 15:27:08 | provincial | 1 | 67641 | 2 | 8.110 | 8340.4 |
| 364 | 2026-02-06 01:48:38 | provincial | 1 | 67641 | 2 | 1.060 | 63812.3 |
| 363 | 2026-02-05 04:30:01 | provincial | 1 | 67641 | 2 | 2.190 | 30886.3 |
| 362 | 2026-02-04 04:32:46 | provincial | 1 | 67641 | 2 | 1.140 | 59334.2 |
| 361 | 2026-02-03 04:42:22 | provincial | 1 | 67641 | 2 | 1.250 | 54112.8 |
| 360 | 2026-01-29 22:15:32 | provincial | 4 | 161450 | 53 | 55.673 | 2900.0 |
| 359 | 2026-01-26 05:28:31 | provincial | 1 | 67641 | 2 | 1.643 | 41169.2 |
| 358 | 2026-01-26 01:06:54 | provincial | 1 | 67641 | 2 | 1.106 | 61158.2 |
| 357 | 2026-01-21 09:36:40 | provincial | 4 | 161450 | 53 | 11.910 | 13555.8 |
| 356 | 2026-01-21 09:32:28 | provincial | 3 | 140603 | 13 | 7.673 | 18324.4 |
| 355 | 2026-01-18 12:36:41 | provincial | 3 | 140603 | 13 | 6.643 | 21165.6 |
| 354 | 2026-01-18 08:24:56 | provincial | 3 | 140603 | 13 | 5.750 | 24452.7 |
| 353 | 2026-01-15 04:18:06 | provincial | 1 | 67641 | 2 | 1.203 | 56226.9 |
| 352 | 2026-01-14 13:19:46 | provincial | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 351 | 2026-01-14 10:13:22 | provincial | 1 | 67641 | 2 | 1.063 | 63632.2 |
| 350 | 2026-01-09 18:42:11 | provincial | 3 | 140603 | 13 | 8.580 | 16387.3 |
| 349 | 2026-01-09 18:17:58 | provincial | 3 | 140603 | 13 | 11.123 | 12640.7 |
| 348 | 2026-01-08 23:24:27 | provincial | 3 | 140603 | 13 | 13.593 | 10343.8 |
| 347 | 2026-01-08 22:54:21 | provincial | 3 | 140603 | 13 | 6.233 | 22557.8 |
| 346 | 2026-01-08 10:56:04 | provincial | 2 | 108824 | 3 | 3.220 | 33796.3 |
| 345 | 2026-01-02 19:07:48 | provincial | 2 | 108824 | 3 | 2.983 | 36481.4 |
| 344 | 2025-12-27 16:18:16 | provincial | 4 | 161450 | 53 | 14.300 | 11290.2 |
| 343 | 2025-12-26 17:37:01 | provincial | 2 | 108824 | 3 | 3.466 | 31397.6 |
| 342 | 2025-12-26 17:36:35 | provincial | 2 | 108824 | 3 | 3.360 | 32388.1 |
| 341 | 2025-12-25 17:26:57 | provincial | 2 | 108824 | 3 | 8.156 | 13342.8 |
| 340 | 2025-12-25 17:19:40 | provincial | 2 | 108824 | 3 | 3.593 | 30287.8 |
| 339 | 2025-12-21 17:26:25 | provincial | 2 | 108824 | 3 | 3.296 | 33017.0 |
| 338 | 2025-12-20 11:46:05 | provincial | 1 | 67641 | 2 | 2.576 | 26258.2 |
| 337 | 2025-12-19 17:18:44 | provincial | 3 | 140603 | 13 | 7.363 | 19095.9 |
| 336 | 2025-12-17 11:54:23 | provincial | 1 | 67641 | 2 | 1.080 | 62630.6 |
| 335 | 2025-12-15 19:38:48 | provincial | 2 | 108824 | 3 | 3.326 | 32719.2 |
| 334 | 2025-12-15 12:14:00 | provincial | 1 | 67641 | 2 | 1.153 | 58665.2 |
| 333 | 2025-12-15 05:46:25 | provincial | 1 | 67641 | 2 | 1.203 | 56226.9 |
| 332 | 2025-12-14 20:57:24 | provincial | 1 | 67641 | 2 | 1.233 | 54858.9 |
| 331 | 2025-12-14 17:07:06 | provincial | 2 | 108824 | 3 | 13.500 | 8061.0 |
| 330 | 2025-12-14 15:25:55 | provincial | 1 | 67641 | 2 | 1.216 | 55625.8 |
| 329 | 2025-12-13 10:13:45 | provincial | 1 | 67641 | 2 | 2.470 | 27385.0 |
| 328 | 2025-12-12 18:35:55 | provincial | 1 | 67641 | 2 | 2.983 | 22675.5 |
| 327 | 2025-12-12 17:41:57 | provincial | 4 | 161450 | 53 | 52.256 | 3089.6 |
| 326 | 2025-12-12 00:54:52 | provincial | 3 | 140603 | 13 | 33.143 | 4242.3 |
| 325 | 2025-12-12 00:54:40 | provincial | 3 | 140603 | 13 | 16.860 | 8339.4 |
| 324 | 2025-11-29 13:02:17 | provincial | 1 | 67641 | 2 | 1.173 | 57665.0 |
| 323 | 2025-11-23 16:32:44 | provincial | 1 | 67641 | 2 | 1.860 | 36366.1 |
| 322 | 2025-11-19 01:40:09 | provincial | 4 | 161450 | 53 | 10.250 | 15751.2 |
| 321 | 2025-10-29 03:45:39 | provincial | 4 | 161450 | 53 | 11.406 | 14154.8 |
| 320 | 2025-10-20 18:19:22 | provincial | 1 | 67641 | 2 | 7.860 | 8605.7 |
| 319 | 2025-10-20 18:19:12 | provincial | 1 | 67641 | 2 | 7.563 | 8943.7 |
| 318 | 2025-10-18 17:27:14 | provincial | 4 | 161450 | 53 | 10.376 | 15559.9 |
| 317 | 2025-10-09 07:44:16 | provincial | 4 | 161450 | 53 | 10.563 | 15284.5 |
| 316 | 2025-09-26 08:15:38 | provincial | 1 | 67641 | 2 | 1.203 | 56226.9 |
| 315 | 2025-09-09 08:56:46 | provincial | 1 | 67641 | 2 | 1.250 | 54112.8 |
| 314 | 2025-09-01 19:00:45 | provincial | 1 | 67641 | 2 | 1.186 | 57032.9 |
| 313 | 2025-08-09 13:30:53 | provincial | 1 | 67641 | 2 | 5.013 | 13493.1 |
| 312 | 2025-07-27 13:45:29 | provincial | 1 | 67641 | 2 | 2.720 | 24868.0 |
| 311 | 2025-07-23 23:28:52 | provincial | 1 | 67641 | 2 | 5.750 | 11763.7 |
| 310 | 2025-07-23 14:18:39 | provincial | 1 | 67641 | 2 | 3.063 | 22083.3 |
| 309 | 2025-07-14 11:37:37 | provincial | 3 | 140603 | 13 | 21.063 | 6675.4 |
| 308 | 2025-06-30 13:29:52 | provincial | 1 | 67641 | 2 | 5.966 | 11337.7 |
| 307 | 2025-06-14 15:05:39 | provincial | 2 | 108824 | 3 | 19.720 | 5518.5 |
| 306 | 2025-06-14 12:37:15 | provincial | 3 | 140603 | 13 | 35.330 | 3979.7 |
| 305 | 2025-06-13 13:17:42 | provincial | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 304 | 2025-06-03 08:31:56 | provincial | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 303 | 2025-05-31 11:16:00 | provincial | 1 | 67641 | 2 | 2.516 | 26884.3 |
| 302 | 2025-05-30 05:17:59 | provincial | 1 | 67641 | 2 | 1.220 | 55443.4 |
| 301 | 2025-05-27 00:00:18 | provincial | 1 | 67641 | 2 | 2.936 | 23038.5 |
| 300 | 2025-05-14 16:44:34 | provincial | 1 | 67641 | 2 | 5.920 | 11425.8 |
| 299 | 2025-05-12 12:51:09 | provincial | 1 | 67641 | 2 | 8.343 | 8107.5 |
| 298 | 2025-04-23 17:24:30 | provincial | 3 | 140603 | 13 | 35.953 | 3910.7 |
| 297 | 2025-04-23 08:40:48 | provincial | 4 | 161450 | 53 | 53.486 | 3018.5 |
| 296 | 2025-04-22 08:02:34 | provincial | 3 | 140603 | 13 | 9.813 | 14328.2 |
| 295 | 2025-04-22 00:26:03 | provincial | 4 | 161450 | 53 | 17.156 | 9410.7 |
| 294 | 2025-04-18 13:53:14 | provincial | 2 | 108824 | 3 | 12.530 | 8685.1 |
| 293 | 2025-04-18 12:19:21 | provincial | 3 | 140603 | 13 | 25.110 | 5599.5 |
| 292 | 2025-04-18 10:24:27 | provincial | 4 | 161450 | 53 | 56.333 | 2866.0 |
| 291 | 2025-04-17 12:54:23 | provincial | 1 | 67641 | 2 | 5.970 | 11330.2 |
| 290 | 2025-03-23 15:39:49 | provincial | 1 | 67641 | 2 | 5.530 | 12231.6 |
| 289 | 2025-03-20 14:57:09 | provincial | 1 | 67641 | 2 | 5.533 | 12225.0 |
| 288 | 2025-03-15 19:06:06 | provincial | 4 | 161450 | 53 | 67.270 | 2400.0 |
| 287 | 2025-03-12 17:48:05 | provincial | 4 | 161450 | 53 | 39.563 | 4080.8 |
| 286 | 2025-03-12 17:48:00 | provincial | 2 | 108824 | 3 | 14.580 | 7463.9 |
| 285 | 2025-03-12 17:45:59 | provincial | 1 | 67641 | 2 | 4.890 | 13832.5 |
| 284 | 2025-03-07 23:21:13 | provincial | 1 | 67641 | 2 | 4.470 | 15132.2 |
| 283 | 2025-03-03 04:43:12 | provincial | 3 | 140603 | 13 | 26.670 | 5272.0 |
| 282 | 2025-03-01 07:52:10 | provincial | 2 | 108824 | 3 | 15.580 | 6984.9 |
| 281 | 2025-03-01 07:47:15 | provincial | 3 | 140603 | 13 | 33.926 | 4144.4 |
| 280 | 2025-02-21 12:39:47 | provincial | 2 | 108824 | 3 | 14.420 | 7546.7 |
| 279 | 2025-02-19 01:29:13 | provincial | 3 | 140603 | 13 | 19.456 | 7226.7 |
| 278 | 2025-02-18 09:27:35 | provincial | 3 | 140603 | 13 | 51.563 | 2726.8 |
| 277 | 2025-02-17 16:13:29 | provincial | 1 | 67641 | 2 | 6.780 | 9976.5 |
| 276 | 2025-02-13 15:18:43 | provincial | 3 | 140603 | 13 | 33.440 | 4204.6 |
| 275 | 2025-02-13 14:00:36 | provincial | 2 | 108824 | 3 | 20.923 | 5201.2 |
| 274 | 2025-02-13 13:59:35 | provincial | 3 | 140603 | 13 | 32.656 | 4305.6 |
| 273 | 2025-02-13 13:59:05 | provincial | 1 | 67641 | 2 | 2.123 | 31861.0 |
| 272 | 2025-02-02 09:40:15 | provincial | 3 | 140603 | 13 | 34.783 | 4042.3 |
| 271 | 2025-01-26 02:20:35 | provincial | 4 | 161450 | 53 | 55.250 | 2922.2 |
| 270 | 2025-01-26 02:20:48 | provincial | 3 | 140603 | 13 | 33.800 | 4159.9 |
| 269 | 2025-01-26 02:20:57 | provincial | 2 | 108824 | 3 | 16.373 | 6646.6 |
| 268 | 2025-01-26 02:19:54 | provincial | 1 | 67641 | 2 | 3.143 | 21521.2 |