History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"luminaire"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 361 | 2026-02-08 12:24:50 | luminaire | 1 | 81242 | 2 | 2.233 | 36382.4 |
| 360 | 2026-02-08 07:11:05 | luminaire | 1 | 81242 | 2 | 3.266 | 24875.1 |
| 359 | 2026-02-04 01:04:29 | luminaire | 3 | 148641 | 24 | 19.626 | 7573.7 |
| 358 | 2026-01-25 00:25:07 | luminaire | 3 | 148641 | 24 | 36.643 | 4056.5 |
| 357 | 2026-01-22 09:51:34 | luminaire | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 356 | 2026-01-16 22:51:36 | luminaire | 2 | 121436 | 6 | 3.703 | 32794.0 |
| 355 | 2026-01-16 02:35:43 | luminaire | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 354 | 2026-01-07 15:27:23 | luminaire | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 353 | 2026-01-03 14:48:09 | luminaire | 1 | 81242 | 2 | 1.250 | 64993.6 |
| 352 | 2026-01-02 20:16:26 | luminaire | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 351 | 2025-12-28 07:59:10 | luminaire | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 350 | 2025-12-22 03:38:26 | luminaire | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 349 | 2025-12-21 13:35:15 | luminaire | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 348 | 2025-12-20 14:06:35 | luminaire | 1 | 81242 | 2 | 3.280 | 24768.9 |
| 347 | 2025-12-16 09:16:55 | luminaire | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 346 | 2025-12-15 14:48:58 | luminaire | 1 | 81242 | 2 | 2.920 | 27822.6 |
| 345 | 2025-12-14 23:26:30 | luminaire | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 344 | 2025-12-13 15:04:25 | luminaire | 1 | 81242 | 2 | 1.876 | 43306.0 |
| 343 | 2025-12-13 13:08:27 | luminaire | 1 | 81242 | 2 | 1.420 | 57212.7 |
| 342 | 2025-12-11 17:36:02 | luminaire | 3 | 148641 | 24 | 31.203 | 4763.7 |
| 341 | 2025-12-07 16:50:24 | luminaire | 3 | 148641 | 24 | 7.063 | 21045.0 |
| 340 | 2025-11-26 20:44:20 | luminaire | 1 | 81242 | 2 | 2.390 | 33992.5 |
| 339 | 2025-11-24 15:19:55 | luminaire | 4 | 165329 | 162 | 20.283 | 8151.1 |
| 338 | 2025-11-24 02:36:36 | luminaire | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 337 | 2025-11-19 06:22:47 | luminaire | 2 | 121436 | 6 | 3.703 | 32794.0 |
| 336 | 2025-09-26 02:54:17 | luminaire | 1 | 81242 | 2 | 1.233 | 65889.7 |
| 335 | 2025-09-13 20:07:18 | luminaire | 3 | 148641 | 24 | 6.580 | 22589.8 |
| 334 | 2025-09-13 15:51:42 | luminaire | 2 | 121436 | 6 | 5.593 | 21712.1 |
| 333 | 2025-09-13 02:41:59 | luminaire | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 332 | 2025-08-12 16:47:18 | luminaire | 4 | 165329 | 162 | 30.360 | 5445.6 |
| 331 | 2025-08-10 23:22:51 | luminaire | 4 | 165329 | 162 | 36.846 | 4487.0 |
| 330 | 2025-07-31 23:54:57 | luminaire | 4 | 165329 | 162 | 58.220 | 2839.7 |
| 329 | 2025-07-25 22:35:51 | luminaire | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 328 | 2025-07-25 06:45:19 | luminaire | 1 | 81242 | 2 | 4.123 | 19704.6 |
| 327 | 2025-07-24 11:36:02 | luminaire | 1 | 81242 | 2 | 7.593 | 10699.6 |
| 326 | 2025-07-24 02:25:48 | luminaire | 1 | 81242 | 2 | 6.296 | 12903.7 |
| 325 | 2025-07-22 22:06:03 | luminaire | 4 | 165329 | 162 | 39.366 | 4199.8 |
| 324 | 2025-07-22 00:57:40 | luminaire | 4 | 165329 | 162 | 82.146 | 2012.6 |
| 323 | 2025-07-18 18:49:56 | luminaire | 4 | 165329 | 162 | 64.533 | 2561.9 |
| 322 | 2025-07-14 12:19:51 | luminaire | 4 | 165329 | 162 | 53.736 | 3076.7 |
| 321 | 2025-07-14 05:18:35 | luminaire | 4 | 165329 | 162 | 86.926 | 1902.0 |
| 320 | 2025-07-13 19:05:14 | luminaire | 2 | 121436 | 6 | 23.126 | 5251.1 |
| 319 | 2025-07-11 19:50:57 | luminaire | 2 | 121436 | 6 | 17.716 | 6854.6 |
| 318 | 2025-07-11 09:44:25 | luminaire | 4 | 165329 | 162 | 58.890 | 2807.4 |
| 317 | 2025-07-11 03:00:58 | luminaire | 3 | 148641 | 24 | 27.876 | 5332.2 |
| 316 | 2025-07-10 16:44:56 | luminaire | 1 | 81242 | 2 | 7.173 | 11326.1 |
| 315 | 2025-07-10 08:40:50 | luminaire | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 314 | 2025-06-29 22:19:48 | luminaire | 2 | 121436 | 6 | 8.956 | 13559.2 |
| 313 | 2025-06-24 03:56:28 | luminaire | 2 | 121436 | 6 | 12.360 | 9824.9 |
| 312 | 2025-06-23 09:14:44 | luminaire | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 311 | 2025-06-10 01:50:00 | luminaire | 1 | 81242 | 2 | 6.876 | 11815.3 |
| 310 | 2025-06-06 16:32:19 | luminaire | 4 | 165329 | 162 | 36.673 | 4508.2 |
| 309 | 2025-05-28 16:39:45 | luminaire | 3 | 148641 | 24 | 11.703 | 12701.1 |
| 308 | 2025-05-26 09:43:46 | luminaire | 3 | 148641 | 24 | 35.016 | 4244.9 |
| 307 | 2025-05-18 16:56:30 | luminaire | 1 | 81242 | 2 | 5.783 | 14048.4 |
| 306 | 2025-05-17 19:53:42 | luminaire | 3 | 148641 | 24 | 30.296 | 4906.3 |
| 305 | 2025-05-07 12:59:40 | luminaire | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 304 | 2025-05-06 11:38:45 | luminaire | 4 | 165329 | 162 | 46.643 | 3544.6 |
| 303 | 2025-05-05 00:40:46 | luminaire | 3 | 148641 | 24 | 6.953 | 21378.0 |
| 302 | 2025-05-04 14:37:44 | luminaire | 1 | 81242 | 2 | 7.923 | 10253.9 |
| 301 | 2025-05-03 23:46:26 | luminaire | 3 | 148641 | 24 | 22.360 | 6647.6 |
| 300 | 2025-05-02 16:57:24 | luminaire | 4 | 165329 | 162 | 66.536 | 2484.8 |
| 299 | 2025-05-01 23:40:52 | luminaire | 3 | 148641 | 24 | 19.156 | 7759.5 |
| 298 | 2025-05-01 06:39:28 | luminaire | 2 | 121436 | 6 | 24.613 | 4933.8 |
| 297 | 2025-04-27 09:12:04 | luminaire | 1 | 81242 | 2 | 1.343 | 60492.9 |
| 296 | 2025-04-27 03:56:22 | luminaire | 4 | 165329 | 162 | 15.453 | 10698.8 |
| 295 | 2025-04-27 01:17:04 | luminaire | 2 | 121436 | 6 | 3.610 | 33638.8 |
| 294 | 2025-04-26 22:55:13 | luminaire | 3 | 148641 | 24 | 6.296 | 23608.8 |
| 293 | 2025-04-25 16:55:42 | luminaire | 3 | 148641 | 24 | 7.673 | 19372.0 |
| 292 | 2025-04-23 01:28:33 | luminaire | 1 | 81242 | 2 | 5.076 | 16005.1 |
| 291 | 2025-04-22 11:35:43 | luminaire | 3 | 148641 | 24 | 27.470 | 5411.0 |
| 290 | 2025-04-09 05:17:52 | luminaire | 1 | 81242 | 2 | 6.456 | 12584.0 |
| 289 | 2025-04-05 10:34:54 | luminaire | 2 | 121436 | 6 | 3.360 | 36141.7 |
| 288 | 2025-04-03 19:17:36 | luminaire | 3 | 148641 | 24 | 6.843 | 21721.6 |
| 287 | 2025-03-31 18:02:11 | luminaire | 1 | 81242 | 2 | 7.140 | 11378.4 |
| 286 | 2025-03-31 18:00:48 | luminaire | 2 | 121436 | 6 | 8.750 | 13878.4 |
| 285 | 2025-03-31 17:49:50 | luminaire | 3 | 148641 | 24 | 26.626 | 5582.6 |
| 284 | 2025-03-27 17:50:50 | luminaire | 1 | 81242 | 2 | 3.140 | 25873.2 |
| 283 | 2025-03-27 17:20:37 | luminaire | 1 | 81242 | 2 | 12.283 | 6614.2 |
| 282 | 2025-03-27 16:17:14 | luminaire | 2 | 121436 | 6 | 14.420 | 8421.4 |
| 281 | 2025-03-26 02:55:58 | luminaire | 4 | 165329 | 162 | 49.876 | 3314.8 |
| 280 | 2025-03-26 00:16:48 | luminaire | 3 | 148641 | 24 | 7.143 | 20809.3 |
| 279 | 2025-03-25 11:03:28 | luminaire | 4 | 165329 | 162 | 72.756 | 2272.4 |
| 278 | 2025-03-24 11:42:40 | luminaire | 1 | 81242 | 2 | 4.483 | 18122.2 |
| 277 | 2025-03-24 05:29:11 | luminaire | 4 | 165329 | 162 | 50.970 | 3243.7 |
| 276 | 2025-03-24 02:30:20 | luminaire | 2 | 121436 | 6 | 8.593 | 14132.0 |
| 275 | 2025-03-23 02:12:18 | luminaire | 1 | 81242 | 2 | 3.033 | 26786.0 |
| 274 | 2025-03-22 18:27:59 | luminaire | 3 | 148641 | 24 | 6.500 | 22867.8 |
| 273 | 2025-03-17 16:09:24 | luminaire | 3 | 148641 | 24 | 22.580 | 6582.9 |
| 272 | 2025-02-21 04:25:01 | luminaire | 3 | 148641 | 24 | 42.313 | 3512.9 |
| 271 | 2025-02-21 04:25:07 | luminaire | 3 | 148641 | 24 | 27.143 | 5476.2 |
| 270 | 2025-02-21 04:25:07 | luminaire | 2 | 121436 | 6 | 25.656 | 4733.2 |
| 269 | 2025-02-21 04:23:13 | luminaire | 1 | 81242 | 2 | 4.893 | 16603.7 |
| 268 | 2025-02-04 21:27:44 | luminaire | 3 | 148641 | 24 | 33.266 | 4468.3 |
| 267 | 2025-02-03 06:28:55 | luminaire | 3 | 148641 | 24 | 41.890 | 3548.4 |
| 266 | 2025-02-03 06:28:48 | luminaire | 2 | 121436 | 6 | 23.796 | 5103.2 |
| 265 | 2025-02-03 06:28:27 | luminaire | 1 | 81242 | 2 | 6.576 | 12354.3 |
| 264 | 2025-01-29 09:22:34 | luminaire | 3 | 148641 | 24 | 36.240 | 4101.6 |
| 263 | 2025-01-29 09:22:27 | luminaire | 2 | 121436 | 6 | 17.380 | 6987.1 |
| 262 | 2025-01-29 09:22:02 | luminaire | 3 | 148641 | 24 | 22.083 | 6731.0 |