History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subregional"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 262 | 2025-04-23 18:57:09 | subregional | 4 | 148819 | 26 | 36.580 | 4068.3 |
| 261 | 2025-04-21 15:12:09 | subregional | 2 | 86808 | 4 | 10.453 | 8304.6 |
| 260 | 2025-04-20 22:37:30 | subregional | 4 | 148819 | 26 | 39.906 | 3729.2 |
| 259 | 2025-04-20 09:23:07 | subregional | 1 | 49908 | 1 | 0.766 | 65154.0 |
| 258 | 2025-04-04 02:39:39 | subregional | 1 | 49908 | 1 | 4.220 | 11826.5 |
| 257 | 2025-03-20 11:18:49 | subregional | 1 | 49908 | 1 | 5.016 | 9949.8 |
| 256 | 2025-02-28 23:42:03 | subregional | 1 | 49908 | 1 | 4.126 | 12096.0 |
| 255 | 2025-02-19 17:29:15 | subregional | 1 | 49908 | 1 | 5.263 | 9482.8 |
| 254 | 2025-01-21 10:33:30 | subregional | 2 | 86808 | 4 | 10.956 | 7923.3 |
| 253 | 2025-01-21 10:29:09 | subregional | 1 | 49908 | 1 | 3.953 | 12625.3 |
| 252 | 2025-01-20 08:36:12 | subregional | 3 | 121633 | 8 | 24.093 | 5048.5 |
| 251 | 2025-01-19 05:55:30 | subregional | 3 | 121633 | 8 | 40.253 | 3021.7 |
| 250 | 2025-01-19 05:54:00 | subregional | 3 | 121633 | 8 | 35.723 | 3404.9 |
| 249 | 2025-01-19 05:54:00 | subregional | 2 | 86808 | 4 | 11.970 | 7252.1 |
| 248 | 2025-01-19 05:53:51 | subregional | 1 | 49908 | 1 | 1.343 | 37161.6 |
| 247 | 2025-01-18 12:20:01 | subregional | 1 | 49908 | 1 | 4.390 | 11368.6 |
| 246 | 2025-01-16 05:19:01 | subregional | 3 | 121633 | 8 | 23.470 | 5182.5 |
| 245 | 2025-01-16 00:08:25 | subregional | 3 | 121633 | 8 | 23.983 | 5071.6 |
| 244 | 2025-01-14 16:52:29 | subregional | 4 | 148819 | 26 | 50.516 | 2946.0 |
| 243 | 2025-01-14 16:52:33 | subregional | 3 | 121633 | 8 | 29.596 | 4109.8 |
| 242 | 2025-01-10 19:10:13 | subregional | 3 | 121633 | 8 | 22.940 | 5302.2 |
| 241 | 2025-01-10 19:10:15 | subregional | 2 | 86808 | 4 | 14.640 | 5929.5 |
| 240 | 2025-01-10 19:09:22 | subregional | 4 | 148819 | 26 | 64.143 | 2320.1 |
| 239 | 2025-01-10 19:08:04 | subregional | 1 | 49908 | 1 | 3.733 | 13369.4 |
| 238 | 2025-01-07 19:50:21 | subregional | 4 | 148819 | 26 | 70.506 | 2110.7 |
| 237 | 2025-01-07 09:05:59 | subregional | 4 | 148819 | 26 | 47.016 | 3165.3 |
| 236 | 2025-01-06 16:02:06 | subregional | 4 | 148819 | 26 | 49.346 | 3015.8 |
| 235 | 2024-12-14 16:01:55 | subregional | 4 | 148819 | 26 | 41.923 | 3549.8 |
| 234 | 2024-12-11 16:24:12 | subregional | 4 | 148819 | 26 | 63.656 | 2337.9 |
| 233 | 2024-12-08 19:47:12 | subregional | 5 | 164607 | 182 | 73.753 | 2231.9 |
| 232 | 2024-12-08 15:31:04 | subregional | 4 | 148819 | 26 | 25.690 | 5792.9 |
| 231 | 2024-12-07 22:49:57 | subregional | 4 | 148819 | 26 | 36.753 | 4049.2 |
| 230 | 2024-12-07 21:56:13 | subregional | 3 | 121633 | 8 | 24.423 | 4980.3 |
| 229 | 2024-12-07 21:56:17 | subregional | 2 | 86808 | 4 | 14.453 | 6006.2 |
| 228 | 2024-12-07 21:54:10 | subregional | 1 | 49908 | 1 | 4.106 | 12154.9 |
| 227 | 2024-12-07 15:09:49 | subregional | 5 | 164607 | 182 | 70.690 | 2328.6 |
| 226 | 2024-12-07 15:09:51 | subregional | 4 | 148819 | 26 | 48.846 | 3046.7 |
| 225 | 2024-12-07 15:09:51 | subregional | 3 | 121633 | 8 | 32.110 | 3788.0 |
| 224 | 2024-12-07 15:09:52 | subregional | 2 | 86808 | 4 | 11.830 | 7338.0 |
| 223 | 2024-12-07 15:07:27 | subregional | 1 | 49908 | 1 | 3.966 | 12584.0 |
| 222 | 2024-12-04 09:01:22 | subregional | 4 | 148819 | 26 | 19.596 | 7594.4 |
| 221 | 2024-11-10 00:49:41 | subregional | 1 | 49908 | 1 | 4.173 | 11959.7 |
| 220 | 2024-11-06 23:22:37 | subregional | 3 | 121633 | 8 | 25.876 | 4700.6 |
| 219 | 2024-11-06 23:07:45 | subregional | 4 | 148819 | 26 | 47.810 | 3112.7 |
| 218 | 2024-11-06 23:07:47 | subregional | 3 | 121633 | 8 | 30.623 | 3971.9 |
| 217 | 2024-11-05 09:37:58 | subregional | 1 | 49908 | 1 | 0.876 | 56972.6 |
| 216 | 2024-11-05 09:11:05 | subregional | 3 | 121633 | 8 | 25.470 | 4775.5 |
| 215 | 2024-11-05 09:11:06 | subregional | 2 | 86808 | 4 | 16.610 | 5226.2 |
| 214 | 2024-11-04 05:17:10 | subregional | 4 | 148819 | 26 | 49.363 | 3014.8 |
| 213 | 2024-11-03 10:11:36 | subregional | 4 | 148819 | 26 | 41.813 | 3559.2 |
| 212 | 2024-11-02 18:34:45 | subregional | 5 | 164607 | 182 | 101.816 | 1616.7 |
| 211 | 2024-11-02 18:34:48 | subregional | 4 | 148819 | 26 | 58.146 | 2559.4 |
| 210 | 2024-11-02 18:35:22 | subregional | 2 | 86808 | 4 | 16.076 | 5399.9 |
| 209 | 2024-11-02 18:35:01 | subregional | 3 | 121633 | 8 | 28.580 | 4255.9 |
| 208 | 2024-11-02 18:34:39 | subregional | 1 | 49908 | 1 | 1.686 | 29601.4 |
| 207 | 2024-10-27 00:14:57 | subregional | 1 | 49908 | 1 | 3.923 | 12721.9 |
| 206 | 2024-10-02 09:37:24 | subregional | 1 | 49908 | 1 | 6.236 | 8003.2 |
| 205 | 2024-08-21 17:11:50 | subregional | 1 | 49908 | 1 | 11.250 | 4436.3 |
| 204 | 2024-08-11 14:45:12 | subregional | 1 | 49908 | 1 | 2.406 | 20743.1 |
| 203 | 2024-08-09 23:38:55 | subregional | 1 | 49908 | 1 | 2.860 | 17450.3 |
| 202 | 2024-07-20 21:02:29 | subregional | 4 | 148819 | 26 | 27.076 | 5496.3 |
| 201 | 2024-07-18 23:18:11 | subregional | 4 | 148819 | 26 | 43.783 | 3399.0 |
| 200 | 2024-07-18 23:18:01 | subregional | 3 | 121633 | 8 | 16.733 | 7269.0 |
| 199 | 2024-07-17 06:50:10 | subregional | 4 | 148819 | 26 | 47.003 | 3166.2 |
| 198 | 2024-07-17 06:50:12 | subregional | 3 | 121633 | 8 | 10.970 | 11087.8 |
| 197 | 2024-07-17 06:50:15 | subregional | 2 | 86808 | 4 | 6.483 | 13390.1 |
| 196 | 2024-07-17 06:49:32 | subregional | 4 | 148819 | 26 | 37.706 | 3946.8 |
| 195 | 2024-07-17 06:47:50 | subregional | 1 | 49908 | 1 | 1.763 | 28308.6 |
| 194 | 2024-07-09 10:02:55 | subregional | 2 | 86808 | 4 | 11.376 | 7630.8 |
| 193 | 2024-07-09 09:59:41 | subregional | 1 | 49908 | 1 | 2.470 | 20205.7 |
| 192 | 2024-07-09 02:46:01 | subregional | 4 | 148819 | 26 | 49.426 | 3010.9 |
| 191 | 2024-07-09 02:46:23 | subregional | 2 | 86808 | 4 | 6.690 | 12975.8 |
| 190 | 2024-07-09 02:46:03 | subregional | 3 | 121633 | 8 | 21.643 | 5620.0 |
| 189 | 2024-07-09 02:45:24 | subregional | 1 | 49908 | 1 | 4.593 | 10866.1 |
| 188 | 2024-07-06 14:05:38 | subregional | 1 | 49908 | 1 | 2.936 | 16998.6 |
| 187 | 2024-07-06 00:05:00 | subregional | 1 | 49908 | 1 | 1.690 | 29531.4 |
| 186 | 2024-06-19 00:32:00 | subregional | 3 | 121633 | 8 | 27.876 | 4363.4 |
| 185 | 2024-06-19 00:31:59 | subregional | 2 | 86808 | 4 | 4.953 | 17526.3 |
| 184 | 2024-06-18 03:29:21 | subregional | 4 | 148819 | 26 | 50.280 | 2959.8 |
| 183 | 2024-06-08 08:46:02 | subregional | 3 | 121633 | 8 | 19.440 | 6256.8 |
| 182 | 2024-06-03 01:12:52 | subregional | 1 | 49908 | 1 | 0.923 | 54071.5 |
| 181 | 2024-05-30 05:25:41 | subregional | 4 | 148819 | 26 | 46.850 | 3176.5 |
| 180 | 2024-05-30 03:18:02 | subregional | 5 | 164607 | 182 | 62.940 | 2615.3 |
| 179 | 2024-05-30 03:18:03 | subregional | 4 | 148819 | 26 | 47.346 | 3143.2 |
| 178 | 2024-05-30 03:18:13 | subregional | 3 | 121633 | 8 | 21.300 | 5710.5 |
| 177 | 2024-05-30 03:18:19 | subregional | 2 | 86808 | 4 | 8.686 | 9994.0 |
| 176 | 2024-05-30 03:17:27 | subregional | 1 | 49908 | 1 | 4.703 | 10611.9 |
| 175 | 2024-05-28 20:38:33 | subregional | 5 | 164607 | 182 | 80.210 | 2052.2 |
| 174 | 2024-05-28 20:38:57 | subregional | 3 | 121633 | 8 | 15.390 | 7903.4 |
| 173 | 2024-05-28 20:38:45 | subregional | 4 | 148819 | 26 | 25.986 | 5726.9 |
| 172 | 2024-05-28 20:39:01 | subregional | 2 | 86808 | 4 | 8.766 | 9902.8 |
| 171 | 2024-05-28 20:35:13 | subregional | 1 | 49908 | 1 | 1.326 | 37638.0 |
| 170 | 2024-05-24 20:12:41 | subregional | 1 | 49908 | 1 | 2.106 | 23698.0 |
| 169 | 2024-05-12 05:30:23 | subregional | 4 | 148819 | 26 | 28.970 | 5137.0 |
| 168 | 2024-05-02 08:23:34 | subregional | 1 | 49908 | 1 | 0.936 | 53320.5 |
| 167 | 2024-04-30 18:24:09 | subregional | 4 | 148819 | 26 | 37.020 | 4020.0 |
| 166 | 2024-04-30 18:24:26 | subregional | 4 | 148819 | 26 | 15.170 | 9810.1 |
| 165 | 2024-04-30 18:23:19 | subregional | 3 | 121633 | 8 | 10.000 | 12163.3 |
| 164 | 2024-04-30 18:23:17 | subregional | 2 | 86808 | 4 | 6.343 | 13685.6 |
| 163 | 2024-04-30 02:59:14 | subregional | 4 | 148819 | 26 | 31.970 | 4655.0 |