History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"reconciled"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 285 | 2025-01-09 14:57:59 | reconciled | 4 | 161450 | 238 | 72.520 | 2226.3 |
| 284 | 2025-01-09 12:13:12 | reconciled | 4 | 161450 | 238 | 81.176 | 1988.9 |
| 283 | 2025-01-09 10:55:13 | reconciled | 4 | 161450 | 238 | 56.253 | 2870.1 |
| 282 | 2025-01-09 10:53:26 | reconciled | 1 | 67641 | 4 | 2.580 | 26217.4 |
| 281 | 2025-01-07 11:02:58 | reconciled | 3 | 140603 | 50 | 25.440 | 5526.8 |
| 280 | 2025-01-06 14:46:19 | reconciled | 3 | 140603 | 50 | 31.503 | 4463.2 |
| 279 | 2024-12-31 07:12:45 | reconciled | 3 | 140603 | 50 | 30.640 | 4588.9 |
| 278 | 2024-12-31 07:12:46 | reconciled | 2 | 108824 | 11 | 13.096 | 8309.7 |
| 277 | 2024-12-31 07:10:13 | reconciled | 1 | 67641 | 4 | 3.093 | 21869.1 |
| 276 | 2024-12-30 20:41:26 | reconciled | 1 | 67641 | 4 | 1.043 | 64852.3 |
| 275 | 2024-12-09 10:47:49 | reconciled | 1 | 67641 | 4 | 4.576 | 14781.7 |
| 274 | 2024-12-07 02:23:59 | reconciled | 3 | 140603 | 50 | 34.830 | 4036.8 |
| 273 | 2024-12-05 08:51:46 | reconciled | 3 | 140603 | 50 | 32.906 | 4272.9 |
| 272 | 2024-12-05 08:51:45 | reconciled | 2 | 108824 | 11 | 23.483 | 4634.2 |
| 271 | 2024-12-05 08:51:45 | reconciled | 3 | 140603 | 50 | 21.190 | 6635.3 |
| 270 | 2024-11-28 08:13:18 | reconciled | 1 | 67641 | 4 | 7.043 | 9604.0 |
| 269 | 2024-11-27 12:30:25 | reconciled | 1 | 67641 | 4 | 1.046 | 64666.3 |
| 268 | 2024-11-17 11:52:47 | reconciled | 3 | 140603 | 50 | 43.190 | 3255.5 |
| 267 | 2024-11-16 01:44:35 | reconciled | 3 | 140603 | 50 | 43.130 | 3260.0 |
| 266 | 2024-11-16 01:42:19 | reconciled | 2 | 108824 | 11 | 15.736 | 6915.6 |
| 265 | 2024-11-03 18:38:40 | reconciled | 1 | 67641 | 4 | 5.466 | 12374.9 |
| 264 | 2024-10-29 18:05:38 | reconciled | 3 | 140603 | 50 | 33.503 | 4196.7 |
| 263 | 2024-10-27 21:18:39 | reconciled | 1 | 67641 | 4 | 1.123 | 60232.4 |
| 262 | 2024-10-20 04:14:02 | reconciled | 2 | 108824 | 11 | 8.296 | 13117.6 |
| 261 | 2024-10-20 04:12:51 | reconciled | 3 | 140603 | 50 | 27.766 | 5063.9 |
| 260 | 2024-10-20 04:10:56 | reconciled | 1 | 67641 | 4 | 2.030 | 33320.7 |
| 259 | 2024-10-19 17:15:05 | reconciled | 2 | 108824 | 11 | 10.126 | 10747.0 |
| 258 | 2024-10-19 17:11:30 | reconciled | 1 | 67641 | 4 | 2.140 | 31607.9 |
| 257 | 2024-10-15 08:26:19 | reconciled | 3 | 140603 | 50 | 43.753 | 3213.6 |
| 256 | 2024-10-11 11:51:19 | reconciled | 3 | 140603 | 50 | 47.423 | 2964.9 |
| 255 | 2024-10-03 10:59:47 | reconciled | 3 | 140603 | 50 | 46.106 | 3049.6 |
| 254 | 2024-10-01 04:52:27 | reconciled | 1 | 67641 | 4 | 7.693 | 8792.5 |
| 253 | 2024-09-26 15:44:54 | reconciled | 2 | 108824 | 11 | 22.703 | 4793.4 |
| 252 | 2024-09-25 13:04:03 | reconciled | 2 | 108824 | 11 | 18.830 | 5779.3 |
| 251 | 2024-09-22 12:21:55 | reconciled | 2 | 108824 | 11 | 36.203 | 3005.9 |
| 250 | 2024-09-22 12:21:11 | reconciled | 2 | 108824 | 11 | 34.313 | 3171.5 |
| 249 | 2024-09-22 12:21:00 | reconciled | 3 | 140603 | 50 | 42.283 | 3325.3 |
| 248 | 2024-09-22 12:14:42 | reconciled | 1 | 67641 | 4 | 2.263 | 29890.0 |
| 247 | 2024-09-21 21:50:16 | reconciled | 3 | 140603 | 50 | 58.550 | 2401.4 |
| 246 | 2024-09-12 19:19:24 | reconciled | 1 | 67641 | 4 | 12.623 | 5358.6 |
| 245 | 2024-09-10 05:45:14 | reconciled | 3 | 140603 | 50 | 50.926 | 2760.9 |
| 244 | 2024-09-05 23:48:13 | reconciled | 3 | 140603 | 50 | 29.253 | 4806.4 |
| 243 | 2024-09-02 05:15:56 | reconciled | 3 | 140603 | 50 | 41.780 | 3365.3 |
| 242 | 2024-08-25 19:21:17 | reconciled | 3 | 140603 | 50 | 45.593 | 3083.9 |
| 241 | 2024-08-22 21:46:44 | reconciled | 1 | 67641 | 4 | 2.453 | 27574.8 |
| 240 | 2024-08-21 18:05:41 | reconciled | 3 | 140603 | 50 | 66.850 | 2103.3 |
| 239 | 2024-08-21 01:44:07 | reconciled | 3 | 140603 | 50 | 58.673 | 2396.4 |
| 238 | 2024-08-20 23:21:47 | reconciled | 3 | 140603 | 50 | 46.770 | 3006.3 |
| 237 | 2024-08-20 23:21:24 | reconciled | 4 | 161450 | 238 | 45.580 | 3542.1 |
| 236 | 2024-08-20 23:21:49 | reconciled | 2 | 108824 | 11 | 12.893 | 8440.5 |
| 235 | 2024-08-20 23:16:36 | reconciled | 1 | 67641 | 4 | 8.000 | 8455.1 |
| 234 | 2024-08-18 20:59:34 | reconciled | 1 | 67641 | 4 | 5.530 | 12231.6 |
| 233 | 2024-08-06 17:56:57 | reconciled | 1 | 67641 | 4 | 6.546 | 10333.2 |
| 232 | 2024-08-04 03:57:14 | reconciled | 1 | 67641 | 4 | 4.233 | 15979.4 |
| 231 | 2024-08-03 21:49:16 | reconciled | 1 | 67641 | 4 | 7.076 | 9559.2 |
| 230 | 2024-07-27 20:42:36 | reconciled | 1 | 67641 | 4 | 5.673 | 11923.3 |
| 229 | 2024-07-15 11:33:21 | reconciled | 2 | 108824 | 11 | 17.093 | 6366.6 |
| 228 | 2024-07-15 11:29:01 | reconciled | 1 | 67641 | 4 | 4.233 | 15979.4 |
| 227 | 2024-07-14 17:47:42 | reconciled | 1 | 67641 | 4 | 3.516 | 19238.1 |
| 226 | 2024-07-04 13:55:48 | reconciled | 4 | 161450 | 238 | 52.430 | 3079.3 |
| 225 | 2024-07-03 04:15:29 | reconciled | 4 | 161450 | 238 | 62.256 | 2593.3 |
| 224 | 2024-07-03 02:42:23 | reconciled | 1 | 67641 | 4 | 2.000 | 33820.5 |
| 223 | 2024-07-03 02:40:32 | reconciled | 4 | 161450 | 238 | 57.486 | 2808.5 |
| 222 | 2024-07-03 02:40:34 | reconciled | 2 | 108824 | 11 | 5.953 | 18280.5 |
| 221 | 2024-07-03 02:35:31 | reconciled | 1 | 67641 | 4 | 5.860 | 11542.8 |
| 220 | 2024-07-02 22:22:29 | reconciled | 4 | 161450 | 238 | 37.706 | 4281.8 |
| 219 | 2024-07-02 12:18:23 | reconciled | 4 | 161450 | 238 | 28.016 | 5762.8 |
| 218 | 2024-07-02 12:18:34 | reconciled | 2 | 108824 | 11 | 6.046 | 17999.3 |
| 217 | 2024-07-02 12:11:05 | reconciled | 1 | 67641 | 4 | 6.140 | 11016.4 |
| 216 | 2024-07-02 09:08:01 | reconciled | 3 | 140603 | 50 | 26.033 | 5401.0 |
| 215 | 2024-07-01 20:22:48 | reconciled | 3 | 140603 | 50 | 39.610 | 3549.7 |
| 214 | 2024-06-30 15:03:27 | reconciled | 3 | 140603 | 50 | 26.470 | 5311.8 |
| 213 | 2024-06-29 12:27:58 | reconciled | 3 | 140603 | 50 | 26.936 | 5219.9 |
| 212 | 2024-06-28 07:02:01 | reconciled | 3 | 140603 | 50 | 25.453 | 5524.0 |
| 211 | 2024-06-25 06:44:55 | reconciled | 3 | 140603 | 50 | 32.796 | 4287.2 |
| 210 | 2024-06-24 04:13:01 | reconciled | 1 | 67641 | 4 | 4.046 | 16718.0 |
| 209 | 2024-06-22 06:14:42 | reconciled | 1 | 67641 | 4 | 6.283 | 10765.7 |
| 208 | 2024-06-07 03:38:56 | reconciled | 2 | 108824 | 11 | 7.890 | 13792.6 |
| 207 | 2024-05-31 16:11:06 | reconciled | 2 | 108824 | 11 | 11.313 | 9619.4 |
| 206 | 2024-05-31 07:00:00 | reconciled | 1 | 67641 | 4 | 1.330 | 50857.9 |
| 205 | 2024-05-30 14:12:40 | reconciled | 3 | 140603 | 50 | 35.393 | 3972.6 |
| 204 | 2024-05-28 20:52:38 | reconciled | 3 | 140603 | 50 | 37.066 | 3793.3 |
| 203 | 2024-05-28 02:44:55 | reconciled | 3 | 140603 | 50 | 22.236 | 6323.2 |
| 202 | 2024-05-28 02:44:45 | reconciled | 2 | 108824 | 11 | 10.640 | 10227.8 |
| 201 | 2024-05-26 08:29:30 | reconciled | 3 | 140603 | 50 | 12.393 | 11345.4 |
| 200 | 2024-05-26 08:29:31 | reconciled | 2 | 108824 | 11 | 9.110 | 11945.6 |
| 199 | 2024-05-26 08:28:19 | reconciled | 1 | 67641 | 4 | 2.750 | 24596.7 |
| 198 | 2024-05-25 23:17:30 | reconciled | 3 | 140603 | 50 | 8.486 | 16568.8 |
| 197 | 2024-05-25 17:29:37 | reconciled | 4 | 161450 | 238 | 44.750 | 3607.8 |
| 196 | 2024-05-25 10:29:22 | reconciled | 3 | 140603 | 50 | 16.550 | 8495.6 |
| 195 | 2024-05-25 10:28:26 | reconciled | 1 | 67641 | 4 | 3.610 | 18737.1 |
| 194 | 2024-05-23 10:06:28 | reconciled | 4 | 161450 | 238 | 18.080 | 8929.8 |
| 193 | 2024-05-21 20:22:52 | reconciled | 4 | 161450 | 238 | 22.846 | 7066.9 |
| 192 | 2024-05-21 07:16:55 | reconciled | 1 | 67641 | 4 | 2.763 | 24481.0 |
| 191 | 2024-05-20 07:07:25 | reconciled | 4 | 161450 | 238 | 32.626 | 4948.5 |
| 190 | 2024-05-20 07:05:13 | reconciled | 4 | 161450 | 238 | 27.110 | 5955.4 |
| 189 | 2024-05-18 16:36:37 | reconciled | 4 | 161450 | 238 | 39.380 | 4099.8 |
| 188 | 2024-05-18 16:36:42 | reconciled | 2 | 108824 | 11 | 9.093 | 11967.9 |
| 187 | 2024-05-18 16:31:52 | reconciled | 1 | 67641 | 4 | 2.593 | 26086.0 |
| 186 | 2024-05-11 02:03:33 | reconciled | 1 | 67641 | 4 | 1.296 | 52192.1 |