History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"thermostat"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 348 | 2025-09-17 11:50:40 | thermostat | 2 | 108824 | 7 | 2.846 | 38237.5 |
| 347 | 2025-09-09 20:14:10 | thermostat | 1 | 67641 | 2 | 1.173 | 57665.0 |
| 346 | 2025-09-08 05:10:40 | thermostat | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 345 | 2025-08-19 06:58:12 | thermostat | 4 | 161450 | 61 | 40.273 | 4008.9 |
| 344 | 2025-08-17 12:07:25 | thermostat | 1 | 67641 | 2 | 2.216 | 30523.9 |
| 343 | 2025-08-11 09:30:07 | thermostat | 1 | 67641 | 2 | 2.873 | 23543.7 |
| 342 | 2025-08-04 13:01:12 | thermostat | 1 | 67641 | 2 | 5.686 | 11896.1 |
| 341 | 2025-07-23 20:30:51 | thermostat | 1 | 67641 | 2 | 3.796 | 17819.0 |
| 340 | 2025-07-21 22:05:55 | thermostat | 4 | 161450 | 61 | 23.813 | 6779.9 |
| 339 | 2025-07-18 18:24:32 | thermostat | 4 | 161450 | 61 | 44.626 | 3617.8 |
| 338 | 2025-07-17 17:14:51 | thermostat | 1 | 67641 | 2 | 3.076 | 21989.9 |
| 337 | 2025-07-17 15:43:06 | thermostat | 4 | 161450 | 61 | 30.016 | 5378.8 |
| 336 | 2025-07-16 10:36:36 | thermostat | 2 | 108824 | 7 | 8.093 | 13446.7 |
| 335 | 2025-07-16 07:02:21 | thermostat | 4 | 161450 | 61 | 51.533 | 3132.9 |
| 334 | 2025-07-16 04:37:33 | thermostat | 3 | 140603 | 20 | 21.780 | 6455.6 |
| 333 | 2025-07-15 14:56:37 | thermostat | 1 | 67641 | 2 | 2.593 | 26086.0 |
| 332 | 2025-07-04 12:44:37 | thermostat | 1 | 67641 | 2 | 6.923 | 9770.5 |
| 331 | 2025-06-14 15:03:52 | thermostat | 1 | 67641 | 2 | 2.716 | 24904.6 |
| 330 | 2025-06-12 12:43:26 | thermostat | 1 | 67641 | 2 | 5.686 | 11896.1 |
| 329 | 2025-05-20 10:43:52 | thermostat | 1 | 67641 | 2 | 7.606 | 8893.1 |
| 328 | 2025-05-20 09:35:01 | thermostat | 1 | 67641 | 2 | 5.513 | 12269.4 |
| 327 | 2025-05-20 05:17:01 | thermostat | 1 | 67641 | 2 | 7.986 | 8469.9 |
| 326 | 2025-05-12 23:47:50 | thermostat | 1 | 67641 | 2 | 6.876 | 9837.3 |
| 325 | 2025-05-12 18:22:36 | thermostat | 1 | 67641 | 2 | 2.250 | 30062.7 |
| 324 | 2025-05-08 15:07:20 | thermostat | 1 | 67641 | 2 | 4.660 | 14515.2 |
| 323 | 2025-04-20 12:02:57 | thermostat | 1 | 67641 | 2 | 4.733 | 14291.4 |
| 322 | 2025-03-23 16:54:19 | thermostat | 1 | 67641 | 2 | 5.773 | 11716.8 |
| 321 | 2025-03-20 10:04:47 | thermostat | 3 | 140603 | 20 | 20.890 | 6730.6 |
| 320 | 2025-03-06 04:40:57 | thermostat | 3 | 140603 | 20 | 33.440 | 4204.6 |
| 319 | 2025-03-06 04:40:54 | thermostat | 2 | 108824 | 7 | 15.703 | 6930.1 |
| 318 | 2025-03-06 04:40:04 | thermostat | 1 | 67641 | 2 | 5.343 | 12659.7 |
| 317 | 2025-03-01 16:48:01 | thermostat | 3 | 140603 | 20 | 31.030 | 4531.2 |
| 316 | 2025-02-25 02:57:03 | thermostat | 1 | 67641 | 2 | 5.156 | 13118.9 |
| 315 | 2025-02-23 15:29:02 | thermostat | 1 | 67641 | 2 | 5.140 | 13159.7 |
| 314 | 2025-02-18 18:05:25 | thermostat | 2 | 108824 | 7 | 15.186 | 7166.1 |
| 313 | 2025-02-16 10:08:33 | thermostat | 3 | 140603 | 20 | 34.373 | 4090.5 |
| 312 | 2025-02-16 05:43:50 | thermostat | 3 | 140603 | 20 | 37.673 | 3732.2 |
| 311 | 2025-02-16 05:43:40 | thermostat | 3 | 140603 | 20 | 29.140 | 4825.1 |
| 310 | 2025-02-16 05:42:12 | thermostat | 1 | 67641 | 2 | 3.783 | 17880.3 |
| 309 | 2025-02-03 01:54:45 | thermostat | 3 | 140603 | 20 | 32.546 | 4320.1 |
| 308 | 2025-02-03 01:54:34 | thermostat | 2 | 108824 | 7 | 8.173 | 13315.1 |
| 307 | 2025-02-01 07:02:58 | thermostat | 3 | 140603 | 20 | 33.063 | 4252.6 |
| 306 | 2025-01-28 20:02:29 | thermostat | 3 | 140603 | 20 | 24.470 | 5745.9 |
| 305 | 2025-01-28 20:01:49 | thermostat | 3 | 140603 | 20 | 34.236 | 4106.9 |
| 304 | 2025-01-28 20:01:49 | thermostat | 3 | 140603 | 20 | 31.940 | 4402.1 |
| 303 | 2025-01-28 20:01:49 | thermostat | 2 | 108824 | 7 | 7.536 | 14440.6 |
| 302 | 2025-01-28 19:13:15 | thermostat | 1 | 67641 | 2 | 1.080 | 62630.6 |
| 301 | 2025-01-23 13:02:23 | thermostat | 3 | 140603 | 20 | 38.940 | 3610.8 |
| 300 | 2025-01-23 13:02:25 | thermostat | 3 | 140603 | 20 | 30.830 | 4560.6 |
| 299 | 2025-01-19 03:28:01 | thermostat | 1 | 67641 | 2 | 7.673 | 8815.5 |
| 298 | 2025-01-03 01:19:20 | thermostat | 2 | 108824 | 7 | 12.656 | 8598.6 |
| 297 | 2025-01-03 00:00:20 | thermostat | 2 | 108824 | 7 | 19.423 | 5602.8 |
| 296 | 2025-01-02 23:57:27 | thermostat | 1 | 67641 | 2 | 2.296 | 29460.4 |
| 295 | 2025-01-01 09:07:46 | thermostat | 3 | 140603 | 20 | 32.643 | 4307.3 |
| 294 | 2024-12-31 21:35:53 | thermostat | 3 | 140603 | 20 | 33.396 | 4210.2 |
| 293 | 2024-12-30 07:50:42 | thermostat | 3 | 140603 | 20 | 39.736 | 3538.4 |
| 292 | 2024-12-30 07:50:47 | thermostat | 3 | 140603 | 20 | 30.876 | 4553.8 |
| 291 | 2024-12-30 07:50:42 | thermostat | 2 | 108824 | 7 | 15.813 | 6881.9 |
| 290 | 2024-12-30 07:50:39 | thermostat | 3 | 140603 | 20 | 16.763 | 8387.7 |
| 289 | 2024-12-30 06:16:28 | thermostat | 1 | 67641 | 2 | 1.076 | 62863.4 |
| 288 | 2024-12-28 14:29:16 | thermostat | 1 | 67641 | 2 | 2.236 | 30250.9 |
| 287 | 2024-12-19 16:41:46 | thermostat | 1 | 67641 | 2 | 3.110 | 21749.5 |
| 286 | 2024-11-30 22:29:12 | thermostat | 3 | 140603 | 20 | 31.250 | 4499.3 |
| 285 | 2024-11-30 22:29:09 | thermostat | 3 | 140603 | 20 | 34.233 | 4107.2 |
| 284 | 2024-11-26 11:07:34 | thermostat | 1 | 67641 | 2 | 0.983 | 68810.8 |
| 283 | 2024-11-26 03:53:06 | thermostat | 1 | 67641 | 2 | 4.216 | 16043.9 |
| 282 | 2024-11-17 17:05:42 | thermostat | 1 | 67641 | 2 | 5.610 | 12057.2 |
| 281 | 2024-11-15 14:37:33 | thermostat | 3 | 140603 | 20 | 30.296 | 4641.0 |
| 280 | 2024-11-15 14:37:34 | thermostat | 2 | 108824 | 7 | 10.876 | 10005.9 |
| 279 | 2024-11-15 14:36:47 | thermostat | 3 | 140603 | 20 | 42.446 | 3312.5 |
| 278 | 2024-11-15 14:36:47 | thermostat | 3 | 140603 | 20 | 34.443 | 4082.2 |
| 277 | 2024-11-15 14:31:41 | thermostat | 1 | 67641 | 2 | 3.906 | 17317.2 |
| 276 | 2024-10-26 22:12:03 | thermostat | 1 | 67641 | 2 | 2.546 | 26567.6 |
| 275 | 2024-10-25 23:57:32 | thermostat | 1 | 67641 | 2 | 1.173 | 57665.0 |
| 274 | 2024-10-17 14:19:49 | thermostat | 3 | 140603 | 20 | 33.470 | 4200.9 |
| 273 | 2024-10-15 09:11:55 | thermostat | 3 | 140603 | 20 | 33.626 | 4181.4 |
| 272 | 2024-10-15 09:11:54 | thermostat | 3 | 140603 | 20 | 31.846 | 4415.1 |
| 271 | 2024-10-15 09:12:10 | thermostat | 2 | 108824 | 7 | 15.500 | 7020.9 |
| 270 | 2024-10-15 09:06:23 | thermostat | 1 | 67641 | 2 | 4.733 | 14291.4 |
| 269 | 2024-10-13 14:34:25 | thermostat | 3 | 140603 | 20 | 33.250 | 4228.7 |
| 268 | 2024-10-11 10:17:24 | thermostat | 3 | 140603 | 20 | 28.550 | 4924.8 |
| 267 | 2024-10-11 10:17:30 | thermostat | 2 | 108824 | 7 | 12.266 | 8872.0 |
| 266 | 2024-10-11 10:01:03 | thermostat | 1 | 67641 | 2 | 1.093 | 61885.6 |
| 265 | 2024-09-17 20:12:22 | thermostat | 1 | 67641 | 2 | 10.750 | 6292.2 |
| 264 | 2024-09-13 03:34:49 | thermostat | 3 | 140603 | 20 | 56.656 | 2481.7 |
| 263 | 2024-09-10 07:31:57 | thermostat | 3 | 140603 | 20 | 50.316 | 2794.4 |
| 262 | 2024-09-09 03:46:04 | thermostat | 1 | 67641 | 2 | 10.890 | 6211.3 |
| 261 | 2024-09-08 08:31:38 | thermostat | 3 | 140603 | 20 | 49.410 | 2845.6 |
| 260 | 2024-08-25 18:45:41 | thermostat | 3 | 140603 | 20 | 60.173 | 2336.6 |
| 259 | 2024-08-23 22:41:38 | thermostat | 3 | 140603 | 20 | 42.816 | 3283.9 |
| 258 | 2024-08-23 12:52:54 | thermostat | 3 | 140603 | 20 | 38.903 | 3614.2 |
| 257 | 2024-08-23 12:52:35 | thermostat | 3 | 140603 | 20 | 49.796 | 2823.6 |
| 256 | 2024-08-23 12:52:41 | thermostat | 2 | 108824 | 7 | 25.720 | 4231.1 |
| 255 | 2024-08-14 21:18:39 | thermostat | 4 | 161450 | 61 | 96.163 | 1678.9 |
| 254 | 2024-08-14 21:18:53 | thermostat | 3 | 140603 | 20 | 70.506 | 1994.2 |
| 253 | 2024-08-14 21:18:52 | thermostat | 2 | 108824 | 7 | 24.906 | 4369.4 |
| 252 | 2024-08-14 21:17:21 | thermostat | 1 | 67641 | 2 | 7.406 | 9133.3 |
| 251 | 2024-08-10 01:01:14 | thermostat | 4 | 161450 | 61 | 44.910 | 3595.0 |
| 250 | 2024-08-06 18:30:57 | thermostat | 4 | 161450 | 61 | 31.656 | 5100.1 |
| 249 | 2024-08-06 18:30:42 | thermostat | 1 | 67641 | 2 | 2.000 | 33820.5 |