History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hotspots"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 273 | 2024-04-14 12:46:37 | hotspots | 4 | 161609 | 469 | 33.656 | 4801.8 |
| 272 | 2024-04-13 19:06:52 | hotspots | 3 | 146162 | 37 | 20.936 | 6981.4 |
| 271 | 2024-04-13 19:06:42 | hotspots | 2 | 121059 | 9 | 16.313 | 7421.0 |
| 270 | 2024-04-13 18:15:24 | hotspots | 1 | 82945 | 3 | 1.623 | 51106.0 |
| 269 | 2024-04-11 14:22:24 | hotspots | 4 | 161609 | 469 | 13.690 | 11804.9 |
| 268 | 2024-04-10 20:08:14 | hotspots | 3 | 146162 | 37 | 18.970 | 7704.9 |
| 267 | 2024-04-09 22:42:41 | hotspots | 1 | 82945 | 3 | 1.590 | 52166.7 |
| 266 | 2024-04-09 19:56:04 | hotspots | 3 | 146162 | 37 | 14.503 | 10078.1 |
| 265 | 2024-04-09 19:56:00 | hotspots | 1 | 82945 | 3 | 1.703 | 48705.2 |
| 264 | 2024-04-01 10:31:48 | hotspots | 3 | 146162 | 37 | 24.640 | 5931.9 |
| 263 | 2024-04-01 10:31:50 | hotspots | 1 | 82945 | 3 | 3.343 | 24811.5 |
| 262 | 2024-04-01 10:26:37 | hotspots | 2 | 121059 | 9 | 6.203 | 19516.2 |
| 261 | 2024-03-31 19:35:22 | hotspots | 4 | 161609 | 469 | 33.313 | 4851.2 |
| 260 | 2024-03-30 22:30:52 | hotspots | 3 | 146162 | 37 | 13.546 | 10790.0 |
| 259 | 2024-03-30 18:56:31 | hotspots | 4 | 161609 | 469 | 26.046 | 6204.8 |
| 258 | 2024-03-29 22:56:57 | hotspots | 4 | 161609 | 469 | 40.426 | 3997.7 |
| 257 | 2024-03-29 21:07:09 | hotspots | 4 | 161609 | 469 | 22.470 | 7192.2 |
| 256 | 2024-03-29 21:07:08 | hotspots | 3 | 146162 | 37 | 14.736 | 9918.7 |
| 255 | 2024-03-29 21:07:10 | hotspots | 2 | 121059 | 9 | 4.890 | 24756.4 |
| 254 | 2024-03-29 21:07:07 | hotspots | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 253 | 2024-03-28 23:27:42 | hotspots | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 252 | 2024-03-25 17:56:49 | hotspots | 2 | 121059 | 9 | 3.796 | 31891.2 |
| 251 | 2024-03-25 17:56:45 | hotspots | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 250 | 2024-03-25 17:56:20 | hotspots | 2 | 121059 | 9 | 7.876 | 15370.6 |
| 249 | 2024-03-21 19:30:12 | hotspots | 2 | 121059 | 9 | 4.170 | 29030.9 |
| 248 | 2024-03-11 04:36:02 | hotspots | 4 | 161609 | 469 | 13.580 | 11900.5 |
| 247 | 2024-03-09 20:22:56 | hotspots | 3 | 146162 | 37 | 11.046 | 13232.1 |
| 246 | 2024-03-05 02:04:38 | hotspots | 3 | 146162 | 37 | 11.923 | 12258.8 |
| 245 | 2024-03-05 02:04:38 | hotspots | 2 | 121059 | 9 | 9.610 | 12597.2 |
| 244 | 2024-03-04 23:53:12 | hotspots | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 243 | 2024-03-01 23:57:26 | hotspots | 3 | 146162 | 37 | 9.720 | 15037.2 |
| 242 | 2024-03-01 23:57:24 | hotspots | 2 | 121059 | 9 | 3.966 | 30524.2 |
| 241 | 2024-03-01 23:57:23 | hotspots | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 240 | 2024-02-28 11:40:44 | hotspots | 3 | 146162 | 37 | 14.953 | 9774.8 |
| 239 | 2024-02-28 00:07:06 | hotspots | 4 | 161609 | 469 | 13.046 | 12387.6 |
| 238 | 2024-02-27 22:39:38 | hotspots | 4 | 161609 | 469 | 33.440 | 4832.8 |
| 237 | 2024-02-27 22:39:36 | hotspots | 3 | 146162 | 37 | 9.830 | 14869.0 |
| 236 | 2024-02-27 22:39:35 | hotspots | 2 | 121059 | 9 | 3.876 | 31233.0 |
| 235 | 2024-02-27 22:39:35 | hotspots | 1 | 82945 | 3 | 2.283 | 36331.6 |
| 234 | 2024-02-08 07:19:44 | hotspots | 4 | 161609 | 469 | 16.593 | 9739.6 |
| 233 | 2024-02-06 00:03:54 | hotspots | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 232 | 2024-02-06 00:03:26 | hotspots | 3 | 146162 | 37 | 7.546 | 19369.5 |
| 231 | 2024-02-06 00:01:19 | hotspots | 4 | 161609 | 469 | 17.393 | 9291.6 |
| 230 | 2024-02-05 15:38:12 | hotspots | 3 | 146162 | 37 | 12.953 | 11284.0 |
| 229 | 2024-01-31 06:07:20 | hotspots | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 228 | 2024-01-30 18:23:27 | hotspots | 3 | 146162 | 37 | 8.080 | 18089.4 |
| 227 | 2024-01-28 07:44:39 | hotspots | 3 | 146162 | 37 | 6.843 | 21359.3 |
| 226 | 2024-01-28 07:44:31 | hotspots | 2 | 121059 | 9 | 3.563 | 33976.7 |
| 225 | 2024-01-27 01:42:01 | hotspots | 2 | 121059 | 9 | 3.890 | 31120.6 |
| 224 | 2024-01-26 09:48:13 | hotspots | 4 | 161609 | 469 | 23.440 | 6894.6 |
| 223 | 2024-01-26 08:57:59 | hotspots | 4 | 161609 | 469 | 28.390 | 5692.5 |
| 222 | 2024-01-26 08:55:39 | hotspots | 4 | 161609 | 469 | 16.046 | 10071.6 |
| 221 | 2024-01-26 08:55:35 | hotspots | 2 | 121059 | 9 | 3.593 | 33693.0 |
| 220 | 2024-01-26 08:55:31 | hotspots | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 219 | 2024-01-02 03:59:32 | hotspots | 4 | 161609 | 469 | 10.500 | 15391.3 |
| 218 | 2023-12-27 15:08:51 | hotspots | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 217 | 2023-12-26 11:34:53 | hotspots | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 216 | 2023-12-21 20:40:29 | hotspots | 3 | 146162 | 37 | 6.326 | 23105.0 |
| 215 | 2023-12-05 07:38:14 | hotspots | 4 | 161609 | 469 | 10.890 | 14840.1 |
| 214 | 2023-12-05 05:39:05 | hotspots | 3 | 146162 | 37 | 7.766 | 18820.8 |
| 213 | 2023-12-01 05:41:13 | hotspots | 4 | 161609 | 469 | 22.486 | 7187.1 |
| 212 | 2023-11-26 19:03:15 | hotspots | 2 | 121059 | 9 | 3.063 | 39523.0 |
| 211 | 2023-11-10 00:54:47 | hotspots | 4 | 161609 | 469 | 12.656 | 12769.4 |
| 210 | 2023-11-10 00:54:25 | hotspots | 3 | 146162 | 37 | 6.686 | 21860.9 |
| 209 | 2023-11-10 00:54:27 | hotspots | 2 | 121059 | 9 | 3.560 | 34005.3 |
| 208 | 2023-11-08 00:10:56 | hotspots | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 207 | 2023-10-17 12:20:52 | hotspots | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 206 | 2023-10-13 23:30:59 | hotspots | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 205 | 2023-10-06 08:50:49 | hotspots | 4 | 161609 | 469 | 12.860 | 12566.8 |
| 204 | 2023-09-22 04:31:00 | hotspots | 3 | 146162 | 37 | 6.250 | 23385.9 |
| 203 | 2023-08-27 02:06:28 | hotspots | 2 | 121059 | 9 | 3.080 | 39304.9 |
| 202 | 2023-08-15 04:30:59 | hotspots | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 201 | 2023-08-09 16:09:20 | hotspots | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 200 | 2023-07-18 04:42:06 | hotspots | 4 | 161609 | 469 | 10.546 | 15324.2 |
| 199 | 2023-07-10 11:21:59 | hotspots | 4 | 161609 | 469 | 10.970 | 14731.9 |
| 198 | 2023-06-29 14:44:10 | hotspots | 3 | 146162 | 37 | 6.610 | 22112.3 |
| 197 | 2023-05-10 09:40:50 | hotspots | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 196 | 2023-05-10 09:32:35 | hotspots | 2 | 121059 | 9 | 3.140 | 38553.8 |
| 195 | 2023-04-23 06:04:23 | hotspots | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 194 | 2023-04-02 07:31:28 | hotspots | 4 | 161609 | 469 | 14.940 | 10817.2 |
| 193 | 2023-03-27 13:12:41 | hotspots | 4 | 161609 | 469 | 12.906 | 12522.0 |
| 192 | 2023-03-17 01:29:13 | hotspots | 3 | 146162 | 37 | 6.063 | 24107.2 |
| 191 | 2023-02-15 19:28:50 | hotspots | 2 | 121059 | 9 | 3.360 | 36029.5 |
| 190 | 2023-02-14 06:24:53 | hotspots | 4 | 161609 | 469 | 11.266 | 14344.8 |
| 189 | 2023-01-29 22:40:37 | hotspots | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 188 | 2023-01-05 19:41:32 | hotspots | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 187 | 2022-12-29 20:04:21 | hotspots | 4 | 161609 | 469 | 11.373 | 14209.9 |
| 186 | 2022-12-28 17:13:41 | hotspots | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 185 | 2022-12-26 22:48:28 | hotspots | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 184 | 2022-12-26 00:42:05 | hotspots | 4 | 161609 | 469 | 10.580 | 15275.0 |
| 183 | 2022-12-19 01:03:36 | hotspots | 3 | 146162 | 37 | 6.063 | 24107.2 |
| 182 | 2022-12-15 06:12:11 | hotspots | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 181 | 2022-11-28 02:57:26 | hotspots | 2 | 121059 | 9 | 3.873 | 31257.2 |
| 180 | 2022-11-12 19:08:14 | hotspots | 4 | 161609 | 469 | 12.236 | 13207.7 |
| 179 | 2022-11-09 08:05:28 | hotspots | 4 | 161609 | 469 | 11.000 | 14691.7 |
| 178 | 2022-11-07 00:02:56 | hotspots | 1 | 82945 | 3 | 2.470 | 33581.0 |
| 177 | 2022-09-27 21:22:02 | hotspots | 4 | 161609 | 469 | 10.390 | 15554.3 |
| 176 | 2022-09-19 20:40:28 | hotspots | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 175 | 2022-09-16 11:09:15 | hotspots | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 174 | 2022-08-30 06:01:28 | hotspots | 4 | 161609 | 469 | 10.360 | 15599.3 |