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 |
| 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 |
| 267 | 2025-01-24 05:22:34 | provincial | 4 | 161450 | 53 | 65.083 | 2480.7 |
| 266 | 2025-01-24 05:22:49 | provincial | 2 | 108824 | 3 | 20.813 | 5228.7 |
| 265 | 2025-01-24 05:19:57 | provincial | 1 | 67641 | 2 | 7.483 | 9039.3 |
| 264 | 2025-01-20 22:39:12 | provincial | 4 | 161450 | 53 | 74.173 | 2176.7 |
| 263 | 2025-01-18 11:07:02 | provincial | 4 | 161450 | 53 | 61.450 | 2627.3 |
| 262 | 2025-01-18 11:07:37 | provincial | 2 | 108824 | 3 | 15.686 | 6937.7 |
| 261 | 2025-01-18 11:05:26 | provincial | 1 | 67641 | 2 | 1.516 | 44618.1 |
| 260 | 2025-01-16 17:47:19 | provincial | 3 | 140603 | 13 | 18.546 | 7581.3 |
| 259 | 2025-01-10 03:55:54 | provincial | 3 | 140603 | 13 | 34.266 | 4103.3 |
| 258 | 2024-12-31 08:25:12 | provincial | 3 | 140603 | 13 | 17.093 | 8225.8 |
| 257 | 2024-12-25 14:41:59 | provincial | 4 | 161450 | 53 | 75.536 | 2137.4 |
| 256 | 2024-12-25 14:42:41 | provincial | 2 | 108824 | 3 | 15.953 | 6821.5 |
| 255 | 2024-12-25 14:42:08 | provincial | 3 | 140603 | 13 | 35.596 | 3950.0 |
| 254 | 2024-12-25 14:42:06 | provincial | 4 | 161450 | 53 | 35.540 | 4542.8 |
| 253 | 2024-12-25 14:39:01 | provincial | 1 | 67641 | 2 | 2.203 | 30704.0 |
| 252 | 2024-12-24 07:38:33 | provincial | 3 | 140603 | 13 | 21.766 | 6459.8 |
| 251 | 2024-12-24 07:38:36 | provincial | 2 | 108824 | 3 | 17.670 | 6158.7 |
| 250 | 2024-12-24 07:37:18 | provincial | 1 | 67641 | 2 | 4.263 | 15867.0 |
| 249 | 2024-12-21 01:59:14 | provincial | 2 | 108824 | 3 | 13.173 | 8261.1 |
| 248 | 2024-12-21 01:58:05 | provincial | 3 | 140603 | 13 | 33.266 | 4226.6 |
| 247 | 2024-12-21 01:57:46 | provincial | 3 | 140603 | 13 | 31.610 | 4448.1 |
| 246 | 2024-12-21 01:52:49 | provincial | 1 | 67641 | 2 | 7.220 | 9368.6 |
| 245 | 2024-12-17 01:41:49 | provincial | 3 | 140603 | 13 | 44.456 | 3162.7 |