History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"truncation"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 265 | 2025-09-09 21:37:07 | truncation | 1 | 67641 | 2 | 1.016 | 66575.8 |
| 264 | 2025-08-12 16:54:16 | truncation | 4 | 161450 | 251 | 42.110 | 3834.0 |
| 263 | 2025-08-12 06:29:28 | truncation | 4 | 161450 | 251 | 28.876 | 5591.1 |
| 262 | 2025-08-10 14:58:36 | truncation | 2 | 108824 | 3 | 6.796 | 16012.9 |
| 261 | 2025-08-09 22:58:58 | truncation | 4 | 161450 | 251 | 43.066 | 3748.9 |
| 260 | 2025-08-09 09:30:50 | truncation | 1 | 67641 | 2 | 2.486 | 27208.8 |
| 259 | 2025-07-18 15:49:06 | truncation | 1 | 67641 | 2 | 2.796 | 24192.1 |
| 258 | 2025-07-17 01:50:43 | truncation | 1 | 67641 | 2 | 5.123 | 13203.4 |
| 257 | 2025-07-08 09:19:17 | truncation | 4 | 161450 | 251 | 62.470 | 2584.4 |
| 256 | 2025-07-07 08:57:06 | truncation | 1 | 67641 | 2 | 3.063 | 22083.3 |
| 255 | 2025-07-07 00:41:20 | truncation | 4 | 161450 | 251 | 57.520 | 2806.8 |
| 254 | 2025-07-04 21:53:56 | truncation | 4 | 161450 | 251 | 54.330 | 2971.7 |
| 253 | 2025-07-04 09:00:24 | truncation | 1 | 67641 | 2 | 2.810 | 24071.5 |
| 252 | 2025-06-29 23:06:42 | truncation | 1 | 67641 | 2 | 5.703 | 11860.6 |
| 251 | 2025-06-18 14:30:33 | truncation | 2 | 108824 | 3 | 12.296 | 8850.4 |
| 250 | 2025-06-18 11:27:02 | truncation | 3 | 140603 | 37 | 28.703 | 4898.5 |
| 249 | 2025-06-18 04:45:38 | truncation | 3 | 140603 | 37 | 29.013 | 4846.2 |
| 248 | 2025-06-17 00:26:19 | truncation | 1 | 67641 | 2 | 3.283 | 20603.4 |
| 247 | 2025-05-30 11:04:50 | truncation | 1 | 67641 | 2 | 6.326 | 10692.5 |
| 246 | 2025-05-29 09:02:05 | truncation | 1 | 67641 | 2 | 2.733 | 24749.7 |
| 245 | 2025-05-28 09:09:40 | truncation | 1 | 67641 | 2 | 3.356 | 20155.2 |
| 244 | 2025-05-21 23:44:52 | truncation | 1 | 67641 | 2 | 7.673 | 8815.5 |
| 243 | 2025-05-21 22:13:59 | truncation | 1 | 67641 | 2 | 4.016 | 16842.9 |
| 242 | 2025-05-20 08:41:14 | truncation | 3 | 140603 | 37 | 46.030 | 3054.6 |
| 241 | 2025-05-19 18:45:08 | truncation | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 240 | 2025-05-19 09:38:57 | truncation | 1 | 67641 | 2 | 1.143 | 59178.5 |
| 239 | 2025-05-19 00:22:06 | truncation | 3 | 140603 | 37 | 33.983 | 4137.5 |
| 238 | 2025-05-18 11:14:42 | truncation | 3 | 140603 | 37 | 40.990 | 3430.2 |
| 237 | 2025-05-18 05:26:23 | truncation | 4 | 161450 | 251 | 62.080 | 2600.7 |
| 236 | 2025-05-17 01:17:16 | truncation | 1 | 67641 | 2 | 5.673 | 11923.3 |
| 235 | 2025-05-02 08:09:58 | truncation | 1 | 67641 | 2 | 4.063 | 16648.0 |
| 234 | 2025-04-25 08:45:08 | truncation | 1 | 67641 | 2 | 2.796 | 24192.1 |
| 233 | 2025-04-18 05:46:35 | truncation | 1 | 67641 | 2 | 7.346 | 9207.9 |
| 232 | 2025-04-17 22:36:01 | truncation | 1 | 67641 | 2 | 5.610 | 12057.2 |
| 231 | 2025-04-14 00:44:32 | truncation | 1 | 67641 | 2 | 5.500 | 12298.4 |
| 230 | 2025-04-02 10:54:23 | truncation | 1 | 67641 | 2 | 2.860 | 23650.7 |
| 229 | 2025-03-23 11:04:34 | truncation | 1 | 67641 | 2 | 4.606 | 14685.4 |
| 228 | 2025-03-23 09:21:16 | truncation | 1 | 67641 | 2 | 5.750 | 11763.7 |
| 227 | 2025-03-17 11:47:07 | truncation | 1 | 67641 | 2 | 2.970 | 22774.7 |
| 226 | 2025-03-08 14:38:58 | truncation | 1 | 67641 | 2 | 3.283 | 20603.4 |
| 225 | 2025-03-05 02:31:06 | truncation | 1 | 67641 | 2 | 4.313 | 15683.1 |
| 224 | 2025-02-16 13:46:17 | truncation | 3 | 140603 | 37 | 26.453 | 5315.2 |
| 223 | 2025-02-11 23:37:23 | truncation | 3 | 140603 | 37 | 34.580 | 4066.0 |
| 222 | 2025-02-10 05:31:57 | truncation | 2 | 108824 | 3 | 9.203 | 11824.8 |
| 221 | 2025-02-10 05:11:52 | truncation | 3 | 140603 | 37 | 33.473 | 4200.5 |
| 220 | 2025-02-10 04:21:20 | truncation | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 219 | 2025-02-06 03:12:41 | truncation | 2 | 108824 | 3 | 3.063 | 35528.6 |
| 218 | 2025-02-06 03:08:28 | truncation | 1 | 67641 | 2 | 1.140 | 59334.2 |
| 217 | 2025-02-02 22:05:53 | truncation | 1 | 67641 | 2 | 5.860 | 11542.8 |
| 216 | 2025-02-02 13:00:36 | truncation | 1 | 67641 | 2 | 5.313 | 12731.2 |
| 215 | 2025-01-30 05:01:46 | truncation | 3 | 140603 | 37 | 32.313 | 4351.3 |
| 214 | 2025-01-30 05:01:45 | truncation | 3 | 140603 | 37 | 31.876 | 4410.9 |
| 213 | 2025-01-29 21:25:29 | truncation | 3 | 140603 | 37 | 31.376 | 4481.2 |
| 212 | 2025-01-29 07:36:11 | truncation | 4 | 161450 | 251 | 60.083 | 2687.1 |
| 211 | 2025-01-29 07:36:07 | truncation | 3 | 140603 | 37 | 39.830 | 3530.1 |
| 210 | 2025-01-29 07:36:13 | truncation | 2 | 108824 | 3 | 14.203 | 7662.0 |
| 209 | 2025-01-29 07:32:21 | truncation | 1 | 67641 | 2 | 5.296 | 12772.1 |
| 208 | 2025-01-08 11:48:07 | truncation | 1 | 67641 | 2 | 1.190 | 56841.2 |
| 207 | 2025-01-02 20:19:00 | truncation | 3 | 140603 | 37 | 19.656 | 7153.2 |
| 206 | 2025-01-01 02:02:40 | truncation | 3 | 140603 | 37 | 26.266 | 5353.0 |
| 205 | 2024-12-31 04:18:14 | truncation | 3 | 140603 | 37 | 34.046 | 4129.8 |
| 204 | 2024-12-31 04:18:17 | truncation | 2 | 108824 | 3 | 15.096 | 7208.8 |
| 203 | 2024-12-31 04:17:12 | truncation | 3 | 140603 | 37 | 32.673 | 4303.3 |
| 202 | 2024-12-31 04:15:07 | truncation | 1 | 67641 | 2 | 7.640 | 8853.5 |
| 201 | 2024-12-28 15:29:16 | truncation | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 200 | 2024-11-27 23:31:15 | truncation | 2 | 108824 | 3 | 9.140 | 11906.3 |
| 199 | 2024-11-27 23:29:00 | truncation | 1 | 67641 | 2 | 6.470 | 10454.6 |
| 198 | 2024-11-23 16:14:11 | truncation | 3 | 140603 | 37 | 52.396 | 2683.5 |
| 197 | 2024-11-22 18:40:45 | truncation | 3 | 140603 | 37 | 42.876 | 3279.3 |
| 196 | 2024-11-22 18:40:53 | truncation | 3 | 140603 | 37 | 32.830 | 4282.8 |
| 195 | 2024-11-21 11:02:43 | truncation | 4 | 161450 | 251 | 51.973 | 3106.4 |
| 194 | 2024-11-21 11:02:52 | truncation | 3 | 140603 | 37 | 40.316 | 3487.5 |
| 193 | 2024-11-21 11:02:54 | truncation | 2 | 108824 | 3 | 22.580 | 4819.5 |
| 192 | 2024-11-21 11:00:58 | truncation | 1 | 67641 | 2 | 8.030 | 8423.5 |
| 191 | 2024-10-23 07:22:49 | truncation | 4 | 161450 | 251 | 43.593 | 3703.6 |
| 190 | 2024-10-22 14:59:24 | truncation | 4 | 161450 | 251 | 37.986 | 4250.3 |
| 189 | 2024-10-22 14:59:36 | truncation | 2 | 108824 | 3 | 14.860 | 7323.3 |
| 188 | 2024-10-22 14:52:05 | truncation | 1 | 67641 | 2 | 1.190 | 56841.2 |
| 187 | 2024-10-22 11:16:19 | truncation | 3 | 140603 | 37 | 26.923 | 5222.4 |
| 186 | 2024-10-20 17:27:05 | truncation | 2 | 108824 | 3 | 15.263 | 7129.9 |
| 185 | 2024-10-20 17:26:31 | truncation | 3 | 140603 | 37 | 32.783 | 4288.9 |
| 184 | 2024-10-20 17:22:33 | truncation | 1 | 67641 | 2 | 1.970 | 34335.5 |
| 183 | 2024-10-15 11:58:13 | truncation | 3 | 140603 | 37 | 31.290 | 4493.5 |
| 182 | 2024-10-15 06:42:04 | truncation | 3 | 140603 | 37 | 32.690 | 4301.1 |
| 181 | 2024-10-12 17:21:51 | truncation | 2 | 108824 | 3 | 22.313 | 4877.2 |
| 180 | 2024-10-12 17:21:49 | truncation | 3 | 140603 | 37 | 23.016 | 6108.9 |
| 179 | 2024-10-12 17:21:47 | truncation | 3 | 140603 | 37 | 21.593 | 6511.5 |
| 178 | 2024-10-12 17:01:02 | truncation | 1 | 67641 | 2 | 1.686 | 40119.2 |
| 177 | 2024-10-11 13:33:06 | truncation | 1 | 67641 | 2 | 5.516 | 12262.7 |
| 176 | 2024-09-19 19:25:08 | truncation | 1 | 67641 | 2 | 3.626 | 18654.4 |
| 175 | 2024-08-25 02:33:07 | truncation | 1 | 67641 | 2 | 8.280 | 8169.2 |
| 174 | 2024-08-05 07:13:17 | truncation | 2 | 108824 | 3 | 6.986 | 15577.4 |
| 173 | 2024-08-05 07:08:32 | truncation | 1 | 67641 | 2 | 5.346 | 12652.6 |
| 172 | 2024-07-22 05:33:01 | truncation | 3 | 140603 | 37 | 29.983 | 4689.4 |
| 171 | 2024-07-22 05:33:01 | truncation | 2 | 108824 | 3 | 17.000 | 6401.4 |
| 170 | 2024-07-22 05:28:09 | truncation | 1 | 67641 | 2 | 2.656 | 25467.2 |
| 169 | 2024-07-19 01:23:07 | truncation | 2 | 108824 | 3 | 11.436 | 9515.9 |
| 168 | 2024-07-19 01:15:54 | truncation | 1 | 67641 | 2 | 3.983 | 16982.4 |
| 167 | 2024-07-19 00:29:45 | truncation | 3 | 140603 | 37 | 29.390 | 4784.0 |
| 166 | 2024-07-18 22:18:48 | truncation | 4 | 161450 | 251 | 39.690 | 4067.8 |